For problems 1,2 and 3. The Excel output below is an analysis of year (x) versus...
For problems 1,2 and 3. The Excel output below is an analysis of year (x) versus average global temperature (y) for the years 1940 through 1975. During that time, global temperature appeared to be decreasing rather than increasing. Regression Statistics Multiple R R Square 0.3121 0.0974 Adjusted R Squar 0.0709 68.5 50 67 6 57 66.5 56 Standard Erro Observations 0.1752 36 1900 102ง 1940 1960 1980 2000 ANOVA df F Significance F SS MS 0.1127 0.11273.66970.0639 Regression Residual Total 34 1.0442 0.0307 35 1.1569 Intercept Year Coefficients Stand Err t Stat P-value Lower 95% Upper 95% 67.7418 55039 123080 0,000056.5566 78.9270 00054 0 0028 1.9156 0.0639 00111 00003 1. What is the equation of the regression line? 2.Has there been a statistically significant decrease in average global temperature over this period of time? What in the printout tells you this? 3. Which statement is the best interpretation of the data analysis? a. Because the slope is negative, the temperature decrease was statistically significant during this time. b. Because the confidence interval for the slope has a negative lower limit and a positive upper limit, we cannot say that the temperature decrease was statistically significantly during this time.