Question

College Students Weekly Earning in Dollars (n = 5)
(a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy (the same worksheet you used in exercises 12.2 and 12.3).
(b) Use the formulas to calculate the slope and intercept.
(c) Use your estimated slope and intercept to make a worksheet to calculate SSE, SSR, and SST.
(d) Use these sums to calculate the R2.
(e) To check your answers, make an Excel scatter plot of X and Y, select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart.


$1.99
Sales0
Views27
Comments0
  • CreatedAugust 19, 2015
  • Files Included
Post your question
5000