Question: Perform two linear regressions. ( Please do not copy and paste answer from someone else it is wrong, when you answer the problem do not
-
Perform two linear regressions. ( Please do not copy and paste answer from someone else it is wrong, when you answer the problem do not use a picture from phone insert the tables directly if possible or try to photo-shop it in here)
-
In the first regression use periods 1 to 40 to build the trend line equation. Then forecast sales for periods 41 to 50. Plot the forecast and actual data overlaid.
-
Provide MAD and MAPE.
-
In the first regression use periods 20 to 40 to build the trend line equation. Then forecast sales for periods 41 to 50. Plot the forecast and actual data overlaid.
-
Provide MAD and MAPE.
-
Analyze: how did the two regression forecasts compare? Which one is better? Why?
-
Month Name
Month Number
Sales(thousand $)
Jan
1
53
Feb
2
39
Mar
3
37
Apr
4
55
May
5
47
Jun
6
55
Jul
7
47
Aug
8
43
Sep
9
45
Oct
10
47
Nov
11
45
Dec
12
100
Jan
13
73
Feb
14
55
Mar
15
47
Apr
16
55
May
17
47
Jun
18
43
Jul
19
45
Aug
20
40
Sep
21
23
Oct
22
33
Nov
23
31
Dec
24
44
Jan
25
40
Feb
26
46
Mar
27
50
Apr
28
51
May
29
48
Jun
30
87
Jul
31
90
Aug
32
131
Sep
33
139
Oct
34
144
Nov
35
138
Dec
36
127
Jan
37
177
Feb
38
194
Mar
39
192
Apr
40
172
May
41
201
Jun
42
214
Jul
43
215
Aug
44
199
Sep
45
229
Oct
46
250
Nov
47
233
Dec
48
234
Jan
49
256
Feb
50
280
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
