USE THE FOLLOWING INFORMATION FOR QUESTIONS 10 - 15.

10. A researcher would like to determine if information available soon after a movie's release can be used to predict total U.S. box office revenue ($M), which is referred to as USRevenue in the data set. They use the following explanatory variables:

Budget = Budget ($M)

Opening = Opening weekend box office revenue ($M)

Review = score from 0 to 100 summarizing reviews from movie critics

Minutes = run time of the movie in minutes

The Excel sheet for this question includes the some of the regression output.

What is the equation to find the predicted U.S. box office revenue? Fill in values below to three decimal places.

predicted USRevenue_i = ______ + _______ *Budget_i + ________ *Opening_i + __________ *Review_i + _________ *Minutes_i

_{11. What is the value of the residual standard error? Answer to three decimal places.}

12. What is the R²value? Answer to three decimal places.

13. Calculate the F statistic for testing the significance of the regression. Answer to three decimal places.

14. What F critical value should be used to test the significance of the regression? Answer to three decimal places.

You do not need to complete the test for the significance of the regression.

15. Which of the variables are significant in the regression model using =0.05? Select all that apply:

• Budget
• Opening
• Review
• Minutes

_Excel:

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.970
R Square
Adjusted R Square	0.934
Standard Error
Observations	44
ANOVA
	df	SS	MS
Regression	4	218185.033	54546.258
Residual	39	13856.334	355.291
Total	43	232041.367
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	25.927	22.760	1.139	0.262	-20.110	71.963
Budget	0.091	0.075	1.216	0.231	-0.061	0.243
Opening	2.655	0.193	13.780	0.000	2.265	3.045
Review	0.408	0.204	1.996	0.053	-0.005	0.821
Minutes	-0.389	0.229	-1.694	0.098	-0.853	0.075