can you help solve 4+5

QUESTION 4 What is the value of the correlation coefficient? What is the value of the coefficient of determination? 1 points Save Answer QUESTIONS Calculate the MAD and MSE for each of the above three forecasting methods by using the last four montho values (ie. September 2010 to Dncomber 2010), and determine which forecasting mothod is the best. O A. Moving Average with 3 Periodo O B. Exponential Smoothing (0-0.3) O C. Moving Average with 5 Periods O D.Linear Trend QUESTION 4 What is the value of the correlation coefficient What is the value of the coefficient of determin 0.9570 0.9159 0.9075 5.1615 QUESTION 5 Calculate the MAD and MSE for each of the above three forecasting methods by using 2010), and determine which forecasting method is the best. O A. Moving Average with 3 Periods O B. Exponential Smoothing (a=0.3) O C. Moving Average with 5 Periods O D. Linear Trend el WIR Oton Common Sale Linear Trand Equation Intercept Slopes Note: Use 2 decimal places for your calculation SUMMARY OUTPUT Regression Statistics Multiple R 0.957010435 R Square 0.915868973 Adjusted R Square 0.90745587 Standard Error 5.161539677 Observations 12 ANOVA dy Significance 1,0757E-06 Regression Residual Total 1 10 11 SS MS 2900 251748 2900.251748 108.8622126 266.4149184 26.64149184 3166.666667 Coefficients Standard Error Stot P value Intercept 464.3939394 3.176708073 146.1871625 5.5090SE 18 X Variable 1 4.503496503 0.431629631 10.4332056 1.0757E-06 By using this equation, what would be your forecast for first months of 2011 Lower 95% Upper 95% 457.3157927 471.4720861 3.5417657525.465227255 Lower 95 ON Upper 95.0% 457.3157927471.4720861 3.5417657525.465227255 QUESTION 4 What is the value of the correlation coefficient? What is the value of the coufficient of determination