In: Math
The table below provides several temperature values taken at various altitudes
Altitude(in the thousands of feet) 3 10 14 22 28 31 33
Temperature 57 37 24 -5 -30 -41 -54
Determine if there is linear correlation between altitude and temperature. Give the appropriate r-value(do not calculate this value by hand) and what values you used to determine if there was or was not correlation. Conduct a hypothesis test at the 0.05 level of significance and List the equation of best fit(found via technology) and use this equation to find the predicted temperature at 6327 feet(show the calculation).
Show ALL WORK in a sample step to step process please
data
| altitude | temperature |
| 3 | 57 |
| 10 | 37 |
| 14 | 24 |
| 22 | -5 |
| 28 | -30 |
| 31 | -41 |
| 33 | -54 |
we use excel for regression
data -> data analysis -> regression
result
| SUMMARY OUTPUT | |||||||
| Regression Statistics | |||||||
| Multiple R | 0.996776806 | ||||||
| R Square | 0.993564001 | ||||||
| Adjusted R Square | 0.992276801 | ||||||
| Standard Error | 3.710411471 | ||||||
| Observations | 7 | ||||||
| ANOVA | |||||||
| df | SS | MS | F | Significance F | |||
| Regression | 1 | 10626.59 | 10626.59281 | 771.8802 | 1.13E-06 | ||
| Residual | 5 | 68.83577 | 13.76715328 | ||||
| Total | 6 | 10695.43 | |||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | |
| Intercept | 72.49817518 | 3.016935 | 24.03040629 | 2.33E-06 | 64.7429 | 80.25345 | 64.7429 |
| altitude | -3.684306569 | 0.132611 | -27.78273175 | 1.13E-06 | -4.02519 | -3.34342 | -4.02519 |
r = -0.996776
TS = -27.7827
p-value = 0.00000113 < 0.05
hence we reject the null hypothesis
y^ = 72.4981 -3.6843 *x
y^ = 72.4981 -3.6843 *6.327 = 49.18753