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.

Calculate:-

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

2. What is the value of the residual standard error? Answer to three decimal places

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

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

5. 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.

B12 4 A B C D E F G H K L M N O P W N Regression Statistics Multiple R 0.970 R Square VOUP Adjusted R Square 0.934 Standard Error Observations 44 10 ANOVA 11 df SS MS 12 Regression 4 218185.033 54546.258 13 Residual 39 13856.334 355.291 14 Total 43 232041.367 15 16 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% 17 Intercept 25.927 22.760 1.139 0.262 20.110 71.963 18 Budget 0.091 0.075 1.216 0.231 -0.061 0.243 19 Opening 2.655 0.193 13.780 0.000 2.265 3.045 20 Review 0.408 0.204 1.996 0.053 -0.005 0.821 21 Minutes -0.389 0.229 -1.694 0.098 -0.853 0.075 22