I need one example hand calculation for each box in the excel spreadsheet file p
ID: 3386802 • Letter: I
Question
I need one example hand calculation for each box in the excel spreadsheet file picture below for regression analysis. Below that is the full data set for x and y that is cut off in the spreadsheet.
Linear Regression Robert Erikson Fall 2015 This sheet performs a regression analysis for the linear function: y=ax + b User inputs are shaded (sheet will accept up to 1000 data points) 140 Measured Data Estimate Confidence Interval Prediction Interval 120 Confidence Level 157 Mean of Values (xbar) Mean of y Values (ybar) 99% 10 8 3.36 762100 Degrees of Freedom (df= n-2) --Ybar SST,-(x-xbar)" 10374£ 2816F 80 624E Intercept (a) Slope (b) Coefficient of Determination (R2) 4.32 0.460 0.78 Ybar chart data 105 213 0.087 0.169Explanation / Answer
Sol)
The Regression equation is y=a+bx
From the Excel we have
From the above analysis
The regression equation is y=4.32 + 0.46 (x)
SUMMARY OUTPUT Regression Statistics Multiple R 0.882261 R Square 0.778385 Adjusted R Square 0.750683 Standard Error 8.832871 Observations 10 ANOVA df SS MS F Regression 1 2192.243 2192.243 28.09862 Residual 8 624.1569 78.01961 Total 9 2816.4 Coefficients Standard Error t Stat P-value Intercept 4.318192 13.88217 0.31106 0.763706 X 0.459705 0.086724 5.300813 0.000728