Phone Hold Time For concert Tickets in Seconds (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.