View the step-by-step solution to:


1. Create a "test forecast" for the years 2012 to 2018. Calculate the error, absolute error, squared error and

percentage error of these forecasts. (This will fill the yellow squares)

2. Calculate the mean error, mean absolute error, mean squared error and the mean absolute percentage error for both forecasts. (This will fill the orange squares).

3. Briefly describe which forecast you are inclined to prefer - and explain your reasoning.

4. Create forecasts using both methods for 2019. (This will fill the green squares) - YOU WILL HAVE TO COPY ALL OF THE DATA FROM ROW B INTO ROW C FOR THIS TO WORK. Place the MA(5) forecast in column B and the MA(10) forecast in column CCapture.PNG


Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes