Develop a linear regression trendline for the data provided (2008 2015) and provide a regression equation Use the regression equation from question 1 to obtain forecasted sales (F T ) for Jan 2015 Dec 2015 (i e months 85 96) Insert your forecasted sales in the Regress Sale Forecast (F T ) column in the Table 1 below Next, calculate the forecast errors for Jan 2015 Dec 2015 (i e months 85 96) Insert your forecast error values in the Forecast Error (FE T ) column in Table below For your submitted you can simply copy and paste the completed Table 1 Table 1 2015 Sales Data and Regression Forecast Year Month Month (T) Actual Sales (A T ) Regression Sales Forecast (F T ) Forecast Error (FE T ) 2015 Jan 85 12,287 14580 29 0 19 2015 Feb 86 11,519 14669 72 0 27 2015 Mar 87 12,767 14759 15 0 16 2015 Apr 88 13,235 14848 57 0 12 2015 May 89 13,643 14938 00 0 09 2015 Jun 90 13,552 15027 43 0 11 2015 Jul 91 13,349 15116 86 0 13 2015 Aug 92 10,240 15206 29 0 48 2015 Sep 93 14,781 15295 71 0 03 2015 Oct 94 17,123 15385 14 0 10 2015 Nov 95 20,396 15474 57 0 24 2015 Dec 96 23,609 15564 00 0 34 Use the data obtained in Table 1 to calculate the Mean Absolute Percentage Error (MAPE) for 2015 when using the Regression method to forecast sales Info in the table may already be right not sure though

The Answer is in the image, click to view ...

Question: Develop a linear regression trendline for the data provided (2008-2015) and provide a regression equation. Use the regression equation from question 1 to obtain forecasted

Develop a linear regression trendline for the data provided (2008-2015) and provide a regression equation.

Use the regression equation from question 1 to obtain forecasted sales (F_T) for Jan 2015-Dec 2015 (i.e. months 85-96). Insert your forecasted sales in the Regress Sale Forecast (F_T) column in the Table 1 below. Next, calculate the forecast errors for Jan 2015-Dec 2015 (i.e. months 85-96). Insert your forecast error values in the Forecast Error (FE_T) column in Table below. For your submitted you can simply copy and paste the completed Table 1.

Table 1: 2015 Sales Data and Regression Forecast

Year	Month	Month # (T)	Actual Sales (A_T)	Regression Sales Forecast (F_T)	Forecast Error (FE_T)
2015	Jan	85	12,287	14580.29	0.19
2015	Feb	86	11,519	14669.72	0.27
2015	Mar	87	12,767	14759.15	0.16
2015	Apr	88	13,235	14848.57	0.12
2015	May	89	13,643	14938.00	0.09
2015	Jun	90	13,552	15027.43	0.11
2015	Jul	91	13,349	15116.86	0.13
2015	Aug	92	10,240	15206.29	0.48
2015	Sep	93	14,781	15295.71	0.03
2015	Oct	94	17,123	15385.14	0.10
2015	Nov	95	20,396	15474.57	0.24
2015	Dec	96	23,609	15564.00	0.34

Use the data obtained in Table 1 to calculate the Mean Absolute Percentage Error (MAPE) for 2015 when using the Regression method to forecast sales.

Info in the table may already be right not sure though!

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