Exhibit 11.14
The following questions use the data below.
The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs help analyzing the data using a 2-month moving average.
-Refer to Exhibit 11.14. What formulas should go into cells B15:B18 and cells C15:C18 of the spreadsheet if a 2-month moving average forecasting model is used?

Question

Exhibit 11.14
The following questions use the data below.
The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs help analyzing the data using a 2-month moving average. 
-Refer to Exhibit 11.14. What formulas should go into cells B15:B18 and cells C15:C18 of the spreadsheet if a 2-month moving average forecasting model is used?

Quizplus · Accepted Answer

The Answer of Exhibit 11.14
The following questions use the data below.
The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs help analyzing the data using a 2-month moving average. 
-Refer to Exhibit 11.14. What formulas should go into cells B15:B18 and cells C15:C18 of the spreadsheet if a 2-month moving average forecasting model is used?

Exhibit 11.14 The Following Questions Use the Data Below