Explore BrainMass

Explore BrainMass

    Statistics: Regression, Scatter Plot, Bar Chart, Chi-square

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com June 3, 2020, 9:43 pm ad1c9bdddf
    https://brainmass.com/business/business-math/statistics-regression-scatter-plot-bar-chart-chi-square-test-using-excel-196267

    Solution Summary

    Solutions ro questions in attached excel file.

    $2.19

    ADVERTISEMENT