I need help to solve these problems (a) Make an Excel worksheet to calculate ssa

ID: 3207776 • Letter: I

Question

I need help to solve these problems

(a) Make an Excel worksheet to calculate ssa, ss,y, and ssay (Lea no cells blank be certain to ve answers to required. Negative values should be indicated by a minus sign. Round your 2 decimal l Click here for the Excel Data Elle Part Time Weekly Eamings s) by College Students Hours Worked P) Weekly Pay (Y 108,16 19.36 35.2 18 220 1296 14.4 159 196 35 215.56 6929 12782 18.4 405 14314 166 (b) Use the formulas to calculate the slope and intercept (Round your answers to 3 decimal places.) 5.346 (c) Use your estimated slope and intercept to make a worksheet to calculate SSE ssR and SST (Leave a no cells blank -be certain to enter wherever tequired Negative values should be indicated by a minus sign. Do not round intermediate calculations but final ansviers should be founded to 3 decimal places,) MarkenL Estimated Pa

Explanation / Answer

( x - x bar )^2

( y - y bar )^2

( x - x bar ) ( y - y bar )

104

108.16

6400

832

176

19.36

35.2

220

0.16

1296

-14.4

159

1.96

625

261

275.56

5929

1278.2

18.4

184

405.2

14314

2166

We go to Data tab in excel. Then we go for Data Analysis. There we select Regression. We input the values for x and y.

Regression Statistics

Multiple R

0.89938

R Square

0.808884

Adjusted R Square

0.745179

Standard Error

30.19729

Observations

ANOVA

Significance F

Regression

11578.371

11578.37117

12.69730499

0.037730671

Residual

2735.629

911.8762751

Total

14314

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

85.643

30.72918

2.787013645

0.068589005

-12.1513216

183.4366

X Variable 1

5.346

1.500145

3.563327797

0.037730671

0.571377467

10.11964

b1 = 5.346

bo = 85.643

SSE = 2735.629

SSR = 11578.371

SST = 14314

R^2 = 0.8089