Solve using excel
Q1. 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 (1,000s) GUITAR SALES
30 8
40 11
70 12
60 10
80 15
50 13
Graph these data to see whether a linear equation might describe the relationship between the views on YouTube and guitar sales. compute the SST, SSE, and SSR. Find the least-squares regression line for these data.Using the regression equation, predict guitar sales if there were 40,000 views last month.
Q2.5-15 Develop a 4-month moving average forecast for Wallace Garden Supply, and compute the MAD. A 3-month moving average forecast was developed in the section on moving averages in the table attached