Question 4: Quadratic regression (20 points) 1. The internet movie database monitors the gross revenues for major motion pictures both in United States and internationally. A student is hired to investigate the relationship between international revenue, y, and domestic revenue, X, using quadratic model. To fit the model, the values of y and X are collected for 19 movies. The data in Millions of Dollars is shown in the table. Using the excel output, please answer the questions. Movie Domestic International SUMMARY OUTPUT Regression Statistics 0.9333050 Multiple R 4 0.8710582 R Square 9 Adjusted R 0.8549405 d) Is there sufficient evidence for curvature in the model? (please conduct hypothesis test using alpha=0.05) (3 points) e) Interpret each parameter estimate (b0, 131,132) in English words. (3 points) f) Please use the quadratic model developed to estimate the international gross revenue when domestic gross revenue is 200. (3 points) Square 8 Standard Error 172.95204 Observations 19 ANOVA Significanc df SS MS F 2F 161657 54.0435 7.6409E- Regression 2 3233145 2 08 29912.4 Residual 16 478598.5 1 Total 18 3711743 Coefficient Standard Lower Upper S Error t Stat P-value 95% 95% 406.42322 1.82486 0.08674 878.556 Intercept 6 222.7142 5 65.7097 2 0.15217 X Variable 1 1.7929554 1.192457 1.50358 1 4.3208512 0.73494 0.0049930 3.66034 0.00211 0.0021013 0.00788 X2 Variable 2 8 0.001364 2 2 5 a) Please write the least square prediction equation. (3 points) b) Find the R2 and interpret it. (3 points) c) Is there sufficient evidence to conclude that the overall model is useful to predict international gross revenue? (please conduct hypothesis test using alpha=0.01) (3 points)g) Please write estimate for the standard deviation of error term (2 points) [an