(a) Make an Excel worksheet to calculate SSx, SSy, and SSy (Leave no cells blank

Question

(a) Make an Excel worksheet to calculate SSx, SSy, and SSy (Leave no cells blank be certain to enter "O" wherever required. Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) he at Part-Time Weekly Earnings ($) by College Students Hours Worked (X)Weekly Pay (Y) 13 18 17 90 181 216 157 276 37 aly (b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.) (c) Use your estimated slope and intercept to make a worksheet to calculate SSE, SSR, and SST. (Leave no cells blank be certain to enter"O" wherever required. Negative values should be indicated by a minus sign. Do not round intermediate calculations, but final answers should be rounded to 3 decimal places.) Hours Worked Weekly Pay Estimated Pay 90 181 216 157 276 17 37 SSE SSR SST (d) Calculate the R2. (Round your answer to 4 decimal places.) R2

Explanation / Answer

> x<-c(13,18,17,22,37);x

[1] 13 18 17 22 37

> y<-c(90,181,216,157,276);y

[1] 90 181 216 157 276

> summary(lm(y~x))

Call:

lm(formula = y ~ x)

Residuals:

1 2 3 4 5

-43.435 17.467 58.487 -30.612 -1.907

Coefficients:

Estimate Std. Error t value Pr(>|t|)  

(Intercept) 55.178 57.747 0.956 0.4098  

x 6.020 2.516 2.393 0.0965 .

---

Signif. codes:  

0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 46.74 on 3 degrees of freedom

Multiple R-squared: 0.6562, Adjusted R-squared: 0.5416

F-statistic: 5.727 on 1 and 3 DF, p-value: 0.09648

> predict(lm(y~x))

1 2 3 4 5

133.4345 163.5330 157.5133 187.6118 277.9073

x y 13 90 70.56 8836 789.6 18 181 324 32761 3258 17 216 289 46656 3672 22 157 484 24649 3454 37 276 1369 76176 10212 21.4 184 2536.56 189078 21385.6

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.