Decision Making Tools in the Business Environment - Statistical Techniques in Business - Prices and Research - Statistics Assignment Help

Assignment Task:

Question 1:

Visit the Australian Stock Exchange website, www.asx.com.au and from “Prices and research” drop-down menu, select “Company information”. Type in the ASX code “TLS” (Telstra Corporation Limited), and find out details about the company. Also, type in the ASX code “TPM” (TPG Telecom Limited), and find out the details about that company. The information available on the ASX website will be inadequate for your purpose, you will need to search the internet for more information. Your task will be to get the opening prices of TLS and TPM shares for every quarter from January 2010 to December 2018 (unadjusted prices). If you are retrieving the monthly prices, read the values at the beginning of every Quarter (January, April, July, October) for every year from 2010 to 2018 (Total 36 observations). After you have researched share prices, answer the following questions: 

a. List all the quarterly opening price values in two tables, one for TLS and the other for TPM. Then construct a stem-and-leaf display with one stem value in the middle, and TLS leaves on the right side and TPM leaves on the left side. (Must use EXCEL or similar for the plot.)

b. Construct a relative frequency histogram for TLS and a frequency polygon for TPM on the same graph with equal class widths”. Use two different colours for TLS and TPM. The graph must be done in EXCEL or similar software.

c. Draw a bar chart of market capitals (or total assets) in 2018 (in million Australian dollars) of 5 companies listed in ASX that trade in similar products or do similar business as TLS or TPM with at least AUD50 million in market capitalization.  Graphs must be done in EXCEL or with similar software.

d. If one wishes to invest in TLS or TPM, what is the market recommendation (for example, from Morningstar, Fatprophets, InvestSmart, etc.)? If you cannot find the information, what would be your recommendation based on your research of these two companies (trend, P/E ratio, dividend yield, debt and Beta)?

Question 2:

The table below lists the retail turnover by industry group between January 2018 and December 2018.

From the information provided in the table above,

a. Calculate the mean and standard deviation for each industry group.

b. Calculate the Minimum, Q1, Median, Q3 and Maximum values for each industry group.

c. Draw a box and whisker plot for the retail turnover of each industry group and put them side by side on one graph with the same scale for comparison. (This graph must be done in EXCEL or similar software and cannot be hand-drawn.)

d. Discuss the retail turnover of each industry group and the trends.

Question 3:

The table below is taken from the Australian Bureau of Statistics (ABS) website. It provides data on households use of the internet from Household Use of Information Technology Survey, Australia, 2016-2017.

From the information provided in the table above,

a. What is the probability that a randomly selected household lives in Queensland?

b. What is the probability that a randomly selected household lives in Tasmania and accesses the internet for social networking purpose?

c. Given that a household lives in Victoria, what is the probability that a randomly selected household accesses the internet for formal educational activities?

d. What is the probability that a randomly selected household has accessed the internet for banking or entertainment?    

Question 4:

a. A study conducted by a public transport association found that the average time of bus arrival at the airport domestic terminal is normally distributed, with a mean of 51 minutes and a standard deviation of 4 minutes. What value does the upper 5% of the time exceed?

b. The height of year 3 students varies uniformly between 110 centimetres and 135 centimetres. What is the probability that the height of year 3 student will be less than 121 centimetres? 

c. A marketing company is conducting an experiment in which participants are to taste one of two different brands of tea. Their task is to correctly identify the brand tasted. A random sample of 250 participants is taken and it is assumed that the participants have no ability to distinguish between the two brands.

(i) What is the probability that the sample percentage of correct identifications is greater than 65?
(ii) What is the probability that the sample will have between 60% and 70% of the identifications correct?
    
Question 5:

a. The Department of Education found that sixty-two per cent of students attend school in a particular urban school district. If a random sample of 500 children is selected, what is the approximate probability that at least 290 children are actually enrolled in school? Use normal approximation of the binomial distribution.

b. A major travel agency in Australia found that 185 out of 500 travellers cancelled their airline bookings after they had selected their flight details. At 0.01 level of significance, is there evidence that the population proportion of travellers who select their flights and cancel their bookings is less than 0.50?

c. A fine dining restaurant owner wants to estimate the mean amount that the customers spend on their meals in the restaurant. Find the 95% confidence interval estimate of the mean given the following random sample (in dollars) of 210, 125, 80, 131, 105, 65, 84, 118, 95.    

This Statistics Assignment has been solved by our Statistics Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.