Share
Explore BrainMass

Statistics: Box Office Gross and Video Units Sold

Consider the data below, where data are available for 30 movies that indicate the box office gross (in millions of dollars) and the number of units sold (in thousands) of home videos. Use EXCEL/PHStat to produce the print-out to answer the problems 5 to 9.

1. Find the SSE:
a) 171499
b) 64154
c) 235654

2. Compute the standard error of estimate:
a) 47.87
b) 51.29
c) 10.32

3. Compute r^2
a) .708
b) .728
c) .853

4. Compute r:
a) .618
b) .728
c) .853

5. If the box office gross is increased by 1 million dollars, how much do you expect the increase of the number of home video units sold?
a) 79,653 units
b) 4,333 units
c) 43,331 units

Gross Videos
$million (x1000)
1.10 57.18
1.13 26.17
1.18 92.79
1.25 61.60
1.44 46.50
1.53 85.06
1.53 103.52
1.69 30.88
1.74 49.29
1.77 24.14
2.42 115.31
5.34 87.04
5.70 128.45
6.43 126.64
8.59 107.28
9.36 190.80
9.89 121.57
12.66 183.30
15.35 204.72
17.55 112.47
17.91 162.95
18.25 109.20
23.13 280.79
27.62 229.51
37.09 277.68
40.73 226.73
45.55 365.14
46.62 218.64
54.70 286.31
58.51 254.58.

Solution Preview

See the attached file.

Regression Statistics
Multiple R 0.853088695
R Square 0.727760321
Adjusted R Square 0.718037476
Standard Error 47.8667885
Observations 30

ANOVA
df SS MS F ...

Solution Summary

The solution discusses the box office gross and video units sold.

$2.19