Make an Excel worksheet to calculate SSxx SSyy and SSxy (Leave no cells blank be certain to
Question:
Make an Excel worksheet to calculate SSxx SSyy and SSxy (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.) Click here for the Excel Data File Part-Time Weekly Earnings (S) by College Students 7779.24 10.24 Hours Worked (X)Weekly Pay (Y) (xi-x)2 (xi-x) (y ) 100 185 219 157 280 188.2 139.24 3.24 7.84 0.04 262.44 412.8 1040.76 18 17 20 36 5.76 O 86.24 -6.24 487.16 2441.2 C 948.64 C 973.44 8427.24 18138.8 55 yy 19.8 55xx 55%? (b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.) 5.914 71.108 bo
Solve only the incorrect answers that marked in RED?
Applied Statistics In Business And Economics
ISBN: 9780073521480
4th Edition
Authors: David Doane, Lori Seward