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