Hello,

I entered the following question into Excel and did not obtain the correct answers. I need a detailed, step by step account, as to how the answers were found so I understand this type of problem. I was also not able to insert a scatter chart.

The operations manager of a musical instrument distributor feels that demand for a particular type of guitar may be related to the number of YouTube views for a music video by the popular rock group Marble Pumpkins during the preceding month. The manager has collected the data shown in the following table:

YouTube Views (1000's) Guitar Sales

30 8

40 11

70 12

60 10

80 15

50 13

(a) Graph these data to see whether a linear equation might describe the relationship between the views on YouTube and Guitar sales.

(b) Using the equations presented in this chapter, compute the SST, SSE, and SSR. Find the least-squares regression line for these data.

(c) Using the regression equation, predict guitar sales if there were 40,000 views last month.