Phone Hold Time For concert Tickets in Seconds n
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.
Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
Relevant Tutors available to help