Formulas to calculate the slope and intercept


Problem:

(a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy. (b) Use the formulas to calculate the slope and intercept. (SEE Chart below)
Part-Time Weekly Earnings by College Students
Hours
Worked (X) Weekly
Pay (Y)
10 93
15 171
20 204
20 156
35 261

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Formulas to calculate the slope and intercept
Reference No:- TGS01926230

Now Priced at $20 (50% Discount)

Recommended (98%)

Rated (4.3/5)