I need one example hand calculation for each box in the exce

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.169

Solution

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