Explain how these moving averages can assist a stock analyst in determining the stocks’ price direction.

  • Create trend-moving averages with the following values form: 10, 100, and 200. Graph the data with Excel.
  • Create centered-moving averages with the following values form: 10, 100, and 200. Graph the data with Excel.
  • How do the moving averages for the same values of m compare between a trend-moving average and a centered-moving average?
  • Explain how these moving averages can assist a stock analyst in determining the stocks’ price direction. Provide a detailed explanation with justifications.