Production Budget (in million $\'s) Domestic Box Office Revenues (in million S\'

Question

Production Budget (in million $'s) Domestic Box Office Revenues (in million S's) Movie Title $425 $760 Avatar Pirates of the Caribbean: At World's End $300 $310 Spectre $300 $350 $275 $212 The Lone Ranger $275 $73 John Carter $275 $390 The Dark Knight Rises $300 Harry Potter and the Half-Blood Prince $265 $260 Tangled $215 Spider-Man 3 $258 $336 $250 $303 The Hobbit: An Unexpected Journey Pirates of the Caribbean: OnStranger Tides $250 $241 $250 $258 The Hobbit: The Desolation of Smaug $250 $255 The Hobbit: The Battle of the Five Armies $250 $460 The Avengers: Age of Ultron $232 $200 Superman Returns $274.33 $310.87 mean $45.77 $153.81 standard deviation correlation (r) 0.7624 number summary $232 $73 minimum $250 $228 $260 $300 median $275 $343 $425 $760 maximum

Explanation / Answer

Using excel regression model we get:

more the budget, more the revenue is.

maximum negative residual is for John Carter movie and max positive residual is for The Avenger, indicating most of over & under prediction.

Avatar movie has 63 +ve residual indicating under prediction.

SUMMARY OUTPUT Regression Statistics Multiple R 0.762426 R Square 0.581293 Adjusted R Square 0.549085 Standard Error 103.2832 Observations 15 ANOVA df SS MS F Significance F Regression 1 192525.2 192525.2 18.04796 0.00095 Residual 13 138676.5 10667.42 Total 14 331201.7 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -391.973 167.5762 -2.33907 0.03595 -754 -29.9469 -754 -29.9469 budget 2.561993 0.603065 4.248289 0.00095 1.259151 3.864835 1.259151 3.864835 RESIDUAL OUTPUT Observation Predicted revenue Residuals 1 696.8736 63.12641 2 376.6245 -66.6245 3 376.6245 -26.6245 4 312.5747 -100.575 5 312.5747 -239.575 6 312.5747 77.42534 7 286.9547 13.04527 8 274.1448 -59.1448 9 269.0208 66.97922 10 248.5248 54.47516 11 248.5248 -7.52484 12 248.5248 9.47516 13 248.5248 6.47516 14 248.5248 211.4752 15 202.409 -2.40897

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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