A movie production company in interested in predicting the first year box office

Question

A movie production company in interested in predicting the first year box office sales of a movie. They think the total production cost, total promotional costs, the total book sales and the genre affect the first year box office sales.

•Use the BoxOffice spreadsheet.

•Create dummy variables for genre!

Practice in class Total First yr box office (million dollars) Total Prod Promotional Total BookDummy Dummy Sci-fi Genre Cost (million dollars) Sales (million dollars) Horror Costs (million dollars) Xdh 85.10 106.30 50.20 130.60 54.80 30.30 79.40 91.00 135.40 89.30 95.00 100.00 8.50 12.90 5.20 10.70 3.10 3.50 9.20 9.00 15.10 10.20 7.00 14.00 5.10 5.80 2.10 8.40 2.90 1.20 3.70 7.60 7.70 4.50 4.00 9.00 4.70 8.80 15.10 12.20 10.60 3.50 9.70 5.90 20.80 7.90 10.40 3.00 Horror Horror Horror Horror Drama Drama Drama Drama Sci-f Sci-f Sci-fi Sci-fi 0 0 0 0 0 0 0

Explanation / Answer

Regression Analysis: First Yr box versus Total Prod C, Tpoal Promot, Total Book S, ...

Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value
Regression 5 9392.9 1878.59 9.85 0.007
Total Prod Cost 1 171.4 171.38 0.90 0.380
Tpoal Promotional Cost 1 1015.0 1015.02 5.32 0.060
Total Book Sales 1 662.8 662.79 3.48 0.112
Dummy Horror 1 93.4 93.38 0.49 0.510
Dummy Sci-fi 1 69.8 69.83 0.37 0.567
Error 6 1143.7 190.62
Total 11 10536.7

Model Summary

S R-sq R-sq(adj) R-sq(pred)
13.8067 89.15% 80.10% 51.50%

Coefficients

Term bo Coef SE Coef T-Value P-Value VIF
Constant b1 11.9 12.4 0.96 0.375
Total Prod Cost b2 2.13 2.25 0.95 0.380 4.39
Tpoal Promotional Cost b3 6.95 3.01 2.31 0.060 3.43
Total Book Sales b4 1.616 0.867 1.86 0.112 1.13
Dummy Horror b5 7.6 10.9 0.70 0.510 1.65
Dummy Sci-fi b6 7.5 12.5 0.61 0.567 2.18

Least Square Prediction Equation -

First Yr box office = 11.9 + 2.13 Total Prod Cost + 6.95 Tpoal Promotional Cost
+ 1.616 Total Book Sales + 7.6 Dummy Horror + 7.5 Dummy Sci-fi

Lower 95% Upper 95% Intercept -18.453 42.24209 X Variable 1 -3.37012 7.634373 X Variable 2 -0.41985 14.32214 X Variable 3 -0.50463 3.736781 X Variable 4 -18.9727 34.17427 X Variable 5 -22.972 38.07136

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.