Question: Use the same information as the previous question. a) Create a regression model to forecast sales. Do this by creating a scatterplot with a regression

Use the same information as the previous question.

a) Create a regression model to forecast sales. Do this by creating a scatterplot with a regression equation and R^2 value. Also use the data analysis tool to create a Summary Output.

b) Use the regression model to create forecasted sales for the historical information.

c) Calculate a MAD score and tell me if this is a better forecast model than either of the forecast models in Problem 2. Explain why you make this claim.

d) create a forecast prediction for January.

Month Actual Shed Sales
1 January 10
2 February 12
3 March 13
4 April 16
5 May 19
6 June 23
7 July 26
8 August 30
9 September 28
10 October 18
11 November 16
12 December 14
13 January

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!