Investment Returns:These data are the annual returns on shareholders’ funds of 97 of Australian’s top 100 companies for the years 1990 and 1998.
(i)Produce a histogram of the 1990 returns.
(ii)Produce a histogram of the 1998 returns.
(iii)Find the mean, median, range and standard deviation for the 1990 returns. Annual Returns % (1990)
(iv)Repeat part (iii) for the 1998 returns.
Annual Returns % (1998)
(v)Which was the better year for investors?
•1990 was the better year for investors in regards to annual returns being consistent with the mean of 12.9% compare to 6.4% for 1998. •The measure of variability was high in 1990 with the range of 75.01 compare to 42.76 for 1998. Another high variability for 1990 was the standard deviation of 9.30 compare to 5.17 for 1998.
(For Excel instructions see pages 28 and 61 of the textbook.)
Question 2.(Statistical Inferences: Single Population)
Feasibility Study: Companies that sell groceries over the Internet are called e-grocers. Customers enter their orders, pay by credit card and receive delivery by truck. To determine whether an e-grocery would be profitable in one large city, a potential e-grocer offered the service and recorded the size of the order for a random sample of customers. The data are stored in the data file.
(i)Estimate with 95% confidence the average order in the city. Orders ($)
Confidence Level (95.0%)3.770623926
(ii)Financial analysis indicates that to be profitable the average order would have to exceed $85. Can we infer from the data that an e-grocery will be profitable in the city? Test using = 0.01.
Step 1: Hypothesis is that to be profitable the average order has to exceed $85. Since it’s unproven, it is the alternative hypothesis. The null...