A company is interested in modeling their sales data as part of their sales forecasting for the year 2023. The company collects sales data for the five previous years (2018 -> 2022) and they appear in the tables below (Sales Data worksheet). 33) When fitting an exponential smoothing model with a = 0.25, what is the Mean Squared Error (MSE)? A) 84 B) 7
HELP ASAP.
Use the following scenario and data and when answering questions 33) and 34):
A company is interested in modeling their sales data as part of their sales forecasting for
the year 2023. The company collects sales data for the five previous years (2018 -> 2022)
and they appear in the tables below (Sales Data worksheet).
33) When fitting an exponential smoothing model with a = 0.25, what is the Mean Squared
Error (MSE)?
A) 84
B) 7
C) 672
D) 9.33
E 112
34) When fitting a moving average model of order 3 to the data (i.e., a three-year moving
average, what are the Forecasted sales for 2023?
A) 51.33
B) 50.33
C) 55
D)49
E) 52.5
35) Using the Wilcoxon Signed-Rank Test with a = 0.05 you take a sample of n = 15.
From the sample data you calculate a sum of the positive ranks T* = 89.5. What is the
test statistic for the hypothesis test?
A) 2.33
B) -1.96
C) 1.96
D) -1.65
E) 1.65
Step by step
Solved in 4 steps
