Question

A simpler model. In the multiple regression analysis using all four explanatory variables, Theaters and Budget appear to be the least helpful (given that the other two explanatory variables are in the model).

Sequel Budget 160 Hype 33 23 Minutes 148 92 103 112 15 96 110 107 150 60 30 200 200 140 116 Ratings 8.8 7.2 4.4 7.5 6.6 6.6 5.8 8.0 7.7 6.3 7.4 4.6 5.0 6.4 6.0 Namm 157 68 30 3 643 64 36 320 561 134 130 101 99 7.9 4.7 6.4 21 95 39 52 Title USRelease Genre Rating Inception ######## Action/Adventu PG-13 Easy A ## ### ### Comedy/Roman PG-13 The Last Airbender ######## Action/Adventu PG Scott Pilgrim vs. the W######## Comedy/Roman PG-13 Step Up 3D ######## Drama/Romance PG-13 Prince of Persia: The ! ######## Action/Adventu PG-13 2012 ######## Action/Adventu PG-13 Star Trek ######## Action/Adventu PG-13 Despicable Me ######## Animation PG Wall Street: Money Ne ######## Drama PG-13 Invictus ######## Drama PG-13 The Twilight Saga: Ne ######## Adventure/Dran PG-13 Tooth Fairy ######## Comedy Charlie St. Cloud #### #### Drama/Romance PG-13 Bruno ######## Comedy R Tangled ######## Animation PG Cats and Dogs: The R######## Comedy PG He's Just Not That Inti ######## Comedy/Roman PG-13 The Karate Kid ######## Action/Drama PG The Ugly Truth ######## Comedy/Roman R Underworld: Rise of th ######## Action/Adventu R The Hangover ######## Comedy R Paul Blart: Mall Cop ######## Comedy PG My Soul to Take ######## Horror R Up in the Air ######## Drama/RomanceR Men Who Stare at Goa ######## Comedy Dear John ### ### ## Drama PG-13 Jackass 3D ## ### ### Comedy 17 Again ######## Comedy PG-13 Vampires Suck ######## Comedy PG-13 Saw 3D: The Final Chi ######## Horror Fame ######## Drama PG The Expendables ######## Action/Adventu R Inglourious Bastards ######## Adventure/Dran R Watchmen ######## Action R X-Men Origins: Wolve ######## Action/Adventu PG-13 Jennifer's Body ######## Comedy/Horror R Zombieland ######## Comedy/Horror R (500) Days of Summer ######## Comedy/Roman PG-13 Friday the 13th ######## Horror R How To Train Your D ### ### ## Animation PG Hot Tub Time Machin ######## Comedy Red ######## Action/Comedy PG-13 Ava នទី ៨ ៩៩៩៩ ៨៨៨ ៨៨៩ ដង ។ Opening 62.79 17.73 16.35 10.61 15.81 37.81 65.24 75.20 56.40 19.01 8.61 142.84 14.01 12.38 30.62 48.77 12.28 27.80 55.67 27.61 20.83 44.98 31.83 6.84 26.30 12.71 30.47 50.35 23.72 18.57 24.23 10.01 34.83 38.05 55.21 85.06 6.87 24.73 12.36 43.59 43.73 14.02 21.76 Theaters USRevenue IntRevenue World Revenue 3792 292.6 524.5 817.1 2856 58.4 13.1 71.5 3169 131.6 185.5 317.1 2818 31.5 15.3 46.8 2435 42.4 119.0 161.4 3646 90.8 236.4 327.2 3404 166.1 600.7 766.8 3849 257.7 125.0 382.7 3476 251.5 292.0 543.5 3565 52.5 83.6 136.1 2125 37.5 87.0 124.5 4024 296.6 413.2 709.8 3344 60.0 52.6 112.6 2718 31.1 16.5 47.6 2756 60.0 77.8 137.8 3603 200.8 391.0 591.8 3705 43.6 60.3 103.9 3175 94.0 72.4 166.4 3663 176.6 166.6 343.2 2882 88.9 114.2 203.1 2942 45.8 43.3 89.1 3269 277.3 184.3 461.6 3144 146.3 32.5 178.8 2572 14.6 0.0 14.6 1895 83.8 76.7 160.5 2443 32.4 34.5 66.9 2969 80.0 14.7 94.7 3081 117.2 47.3 164.5 3255 64.1 64.5 128.6 3233 36.7 43.3 80.0 2808 45.7 85.0 130.7 3096 22.5 4.3 26.8 3270 103.0 171.4 274.4 3165 120.5 200.1 320.6 3611 107.5 73.5 181.0 4099 179.9 195.0 374.9 2702 16.2 16.5 32.7 3036 75.6 24.3 99.9 1195 32.4 27.2 59.6 3105 65.0 23.8 88.8 4055 217.4 277.5 494.9 2754 50.2 8.0 58.2 3255 90.4 74.6 165.0 38 370 286 100 82 129 140 96 92 100 91 107 109 94 108 95 102 82 90 107 6.2 6.7 6.6 7.8 5.2 4.7 7.5 6.3 6.3 7.1 6.4 3.5 5.6 4.9 15 103 20 106 49 6 75 145 6.5 103 153 162 7.6 6.7 107 5.1 63 7.7 7.8 5.6 20 7.5 19 165 36 58 102 88 95 97 98 101 111 8.2 135 198 6.5 7.1 50

1. (a) Perform a new analysis using only the movie’s opening-weekend revenue and IMDb rating. Give the estimated regression equation for this analysis.

2. (b) What percent of the variability in USRevenue is explained by this model?

Answer 1

(a) Perform a new analysis using only the movie’s opening-weekend revenue and IMDb rating. Give the estimated regression equation for this analysis.

Opening	Ratings
6279	88
1773	72
1635	44
1061	75
1581	66
3781	66
6524	58
7520	80
5640	77
1901	63
	r²	0.194
	r	0.440
	Std. Error	11.839
	n	10
	k	1
	Dep. Var.	Ratings
ANOVA table
Source	SS	df	MS	F	p-value
Regression	269.70	1	269.6969	1.92	.2028
Residual	1,121.20	8	140.1504
Total	1,390.90	9
Regression output				confidence interval
variables	coefficients	std. error	t (df=8)	p-value	95% lower	95% upper
Intercept	60.5986
Opening	0.0022	0.0016	1.387	.2028	-0.0015	0.0059

The estimated regression equation is:

Ratings = 60.5986 + 0.0022*Opening

(b) What percent of the variability in USRevenue is explained by this model?

19.4%

Please give me a thumbs-up if this helps you out. Thank you!