Statistics: Regression, Scatter Plot, Bar Chart, Chi-square
Not what you're looking for?
Please show step by step how to perform using EXCEL or hand computations.
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
11.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
15.6
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
Purchase this Solution
Solution Summary
Solutions ro questions in attached excel file.
Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Introduction to Finance
This quiz test introductory finance topics.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)