Assignment:
Please show step by step how to perform using EXCEL or hand computations.
Question 1: Below are revenue and profit (both in $ billions) for nine large entertainment companies. (a) Make a scatter plot of profit as a function of revenue. (b) Use Excel to fit the regression, with fitted equation and R2. (c) In your own words, describe the fit.
Revenue and Profit of Nine Entertainment Companies
Company Revenue Profit
AMC Entertainment 1.792 −0.020
Clear Channel Communication 8.931 1.146
Liberty Media 2.446 -0.978
Metro-Goldwyn-Mayer 1.883 -0.162
Regal Entertainment Group 2.490 0.185
Time Warner 43.877 2.639
Univision Communications 1.311 0.155
Viacom 26.585 1.417
Walt Disney 27.061 1.267
Question 2: One particular morning, the length of time spent in the examination rooms is recorded for each patient seen by each physician at an orthopedic clinic. Does the data prove a significant difference in mean times? Physicians
Scrap Rate (Per Thousand Units)
Time in Examination Rooms (minutes)
Physician 1 Physician 2 Physician 3 Physician 4
34 33 17 28
25 35 30 33
27 31 30 31
31 31 26 27
26 42 32 32
34 33 28 33
21 26 40
29
Question 3: Advertisers need to know which age groups are likely to see their ads. Purchasers of 120 copies of Cosmopolitan are shown by age group. (a) Make a bar chart and describe it. (b) Calculate expected frequencies for each class. (c) Perform the chi-square test for a uniform distribution. At α = .01, does this sample contradict the assumption that readership is uniformly distributed among these six age groups?
Purchaser Age Units Sold
18-24 38
25-34 28
35-44 19
45-54 16
55-64 10
65+ 9
Total 120