a.) A certain small company that runs a small local magazine has decided to raise some money by selling advertising on their website. They would like to be able to provide potential advertisers with a forecast of the site visits for the next two months. The data in the table is the number of site visits for the past 24 months.

b.) Develop a linear trend line forecast, an exponential smoothing forecast (with alpha = 0.5), and a 3-month moving average forecast. Compute cumulative error, MAD, and MAPD for all methods. Which method is the best to use to forecast for months 25 and 26? Explain your choice.

PLEASE USE EXCEL AND SHOW FORMULAS, THANK YOU :)

\#3. A certain small company that runs a small local magazine has decided to raise some money by selling advertising on their website. They would like to be able to provide potential advertisers with a forecast of the site visits for the next two months. The data in the table is the number of site visits for the past 24 months. Develop a linear trend line forecast, an exponential smoothing forecast (with alpha =0.5 ), and a 3-month moving average forecast. Compute cumulative error, MAD, and MAPD for all methods. Which method is the best to use to forecast for months 25 and 26 ? Explain your choice. \#3. A certain small company that runs a small local magazine has decided to raise some money by selling advertising on their website. They would like to be able to provide potential advertisers with a forecast of the site visits for the next two months. The data in the table is the number of site visits for the past 24 months. Develop a linear trend line forecast, an exponential smoothing forecast (with alpha =0.5 ), and a 3-month moving average forecast. Compute cumulative error, MAD, and MAPD for all methods. Which method is the best to use to forecast for months 25 and 26 ? Explain your choice