Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

if you can show this in excel thatvwould be great! Thanks in advance To forecast the number of homes sold per month in New York,

if you can show this in excel thatvwould be great! Thanks in advance

image text in transcribed
To forecast the number of homes sold per month in New York, a data analyst decides to try two different forecasts: a regression model and decomposition. The following table shows the actuals and forecasts (in thousands of home sales) for the two methods for the 12 months of 2018. Regression Date New York Home Decomposition model forecast Sales (000) forecast (000) (000) Jan-2017 15 11 13 Feb-2017 13 10 11 Mar-2017 15 14 13 Apr-2017 14 15 13 May-2017 17 19 15 Jun-2017 19 23 16 Jul-2017 18 22 17 Aug-2017 22 21 19 Sep-2017 18 17 17 Oct-2017 18 17 17 Nov-2017 16 15 15 Dec-2017 17 16 15 (a) Calculate the MAD for the decomposition forecast. (b) Calculate the MAD for the regression forecast. (c) Using the MAD criteria, which forecasting method performed better

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Non-Cooperative Game Theory

Authors: Takako Fujiwara Greve

1st Edition

4431556451, 9784431556459

More Books

Students also viewed these Mathematics questions