question archive a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy
Subject:MathPrice:2.85 Bought3
a) |
Make an Excel worksheet to calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required.) |
Part-Time Weekly Earnings ($) by College Students | ||||
Hours Worked (X) | Weekly Pay (Y) | |||
10 | 93 | |||
15 | 171 | |||
20 | 204 | |||
20 | 156 | |||
35 | 261 | |||
(b) |
Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.) |
b1 | |
b0 |
(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 "0" wherever required. Negative values should be indicated by a minus sign. Do not round intermediate calcuations, but final answers should be rounded to 3 decimal places.) |
Hours Worked (xi) |
Weekly Pay (yi) |
Estimated Pay |
||||
10 | 93 | |||||
15 | 171 | |||||
20 | 204 | |||||
20 | 156 | |||||
35 | 261 | |||||
|
|
|
|
SSE | |
SSR | |
SST | |
(d) | Calculate the R2. (Round your answer to 4 decimal places.) |
R2 |
rev: 07_15_2014_QC_49920
check my workreferencesebook & resources