Develop a 4-month moving average forecast for Wallace Garden Supply, and compute the MAD.

Words: 215
Pages: 1
Subject: Uncategorized

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

Let Us write for you! We offer custom paper writing services Order Now.

REVIEWS


Criminology Order #: 564575

“ This is exactly what I needed . Thank you so much.”

Joanna David.


Communications and Media Order #: 564566
"Great job, completed quicker than expected. Thank you very much!"

Peggy Smith.

Art Order #: 563708
Thanks a million to the great team.

Harrison James.


"Very efficient definitely recommend this site for help getting your assignments to help"

Hannah Seven