BA Homework 6
.xlsx
keyboard_arrow_up
School
Houston Baptist University *
*We aren’t endorsed by this school
Course
4340
Subject
Aerospace Engineering
Date
Dec 6, 2023
Type
xlsx
Pages
6
Uploaded by lululas1
PROBLEM 1 (15 POINTS)
Consider the following time series data:
Month
Value
naïve forecast absolute errorerror 2
absolute value of % error
1
24
2
13
24
11
121
85%
3
20
13
7
49
35%
4
12
20
8
64
67%
5
19
12
7
49
37%
6
23
19
4
16
17%
7
15
23
8
64
53%
15
total
45
363
2.93848794226369
mean
7.5
60.5
0.489747990377281
(a) Construct a time series plot. What type of pattern exists in the data?
(b) Compute the mean absolute error (MAE), mean squared error (MSE), and mean absolute percentage error MAPE)
using the most recent value as the forecast for the next period. What is the forecast for month 8?
MAE
MSE
MAPE
forecast
(c) Compute the MAE, MSE, and MAPE using the average of all the data as the forecast for the next period.
What is the forecast for month 8?
MAE
MSE
MAPE
forecast
(d) Develop a three-week moving average for this time series and compute the MAE, MSE, and MAPE.
What is the forecast for month 8.
Month
Value
3 week
forecast error abs
1
24
2
13
3
20
4
12
19
5
19
15
6
23
17
7
15
18
MAE
MSE
MAPE
MAE, MSE, and MAPE. What is the forecast for month 8?
(e) Compare the results. Which appears to provide the better forecast based on the MSE?
(d) Use ά = 0.20 to compute the exponential smoothing values for the time series and compute the
1
2
3
4
5
6
7
0
5
10
15
20
25
30
Chart Title
Month
Value
PROBLEM 2 (20 POINTS)
The following data shows the quarterly sales of the LukeHydro tents at a Aubrey Sporting Goods Store.
The store owner wants to forecast the quarterly sales for the next year.
(a) Construct a time series plot. What type of pattern exists in the data?
(b) Use dummy variables and multiple regression to find a multiple regression equation that accounts for seasonal effects in the data?
(c) Based on this model, estimate the quarterly sales for the fourth year.
Year
Quarter
Q1
Q2
Q3
Sales
1
1
1
0
0
74
1
2
0
1
0
53
1
3
0
0
1
61
1
4
0
0
0
82
2
1
1
0
0
71
2
2
0
1
0
45
2
3
0
0
1
65
2
4
0
0
0
87
3
1
1
0
0
67
3
2
0
1
0
57
3
3
0
0
1
58
3
4
0
0
0
78
4
1
70.666666667
4
2
51.666666667
4
3
61.333333333
4
4
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help