Assignment: Moving Average Forecasting Models
Moving average forecasting models are influential tools which help managers in making educated forecasting decisions. The moving average is mainly employed to forecast short historical range data. This tool all along with other forecasting tools is now computerized like in Excel, which makes it simple to use. With regard to moving average forecasting, read the given task.
Obtain the daily price data over the past 5 years for three different stocks. Data can be received from the Internet by using the given keywords: stock price data, return data, company data, and stock returns.
A) Make trend-moving averages with the following values form: 10, 100, and 200. Graph the data with Excel.
B) Make centered-moving averages with the following values form: 10, 100, and 200. Graph the data with Excel.
C) How do the moving averages for similar values of m compare among the trend-moving average and the centered-moving average?
D) Elucidate how such moving averages can assist a stock analyst in determining the stocks’ price direction. Give a detailed elucidation with justifications.
Submit your answers in an eight- to ten-page Word document and in an Excel sheet.
Name your document SUO_BUS3059_W5_A2_LastName_FirstInitial.doc.
On a separate page, cite all sources by using the APA guidelines.