For the given data using Regression in Excel we get output as
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.971652465 | |||||
R Square | 0.944108513 | |||||
Adjusted R Square | 0.934793265 | |||||
Standard Error | 28.22118098 | |||||
Observations | 8 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 1 | 80719.38966 | 80719.39 | 101.3509 | 5.57451E-05 | |
Residual | 6 | 4778.610337 | 796.4351 | |||
Total | 7 | 85498 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | -12.10615245 | 117.3979573 | -0.10312 | 0.921228 | -299.368605 | 275.1563001 |
x | 1.402120735 | 0.139274517 | 10.06732 | 5.57E-05 | 1.06132827 | 1.742913201 |
So from the above output
The table shows the average weekly wages (in dollars) for state government employees and federal government...
The table shows the avrage wookly wages (n dollars) for state govemment eplnyeesand deral govemment employees for 8 yeans. The equation of the regression line is y 1.479x-78 874 Complete parts (a) and (b) below Weekly Wages ( 794 (a) Find the coefficient of deteemination and intepret the resu Round to three decimal places as needed. How can the ooefficient of determination be interpreted? The coeficient of deseminasion is the fraction ol the variation in average weekly wages for he...
The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years. Construct and interpret a 90% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $879. The equation of the regression line is ModifyingAbove y with caret equals 1.369 x plus 32.849 . The table below shows the average weekly wages (in dollars) for state government employees and...
The table shows the number of goals allowed and the total points earned (2 points for a win, and 1 point for an overtime or shoc season. The equation of the regression line is y = -0.600x + 225.826. Use the data to answer the following questions. (a) Find the coefficient of determination, and interpret the result. (b) Find the standard error of the estimate, se, and interpret the result. Goals 212 210 219 223 259 258 273 200 217...