question 23 (1 point)\nlisten\nthe mean square error (mse) for the forecasts shown in the following table…

question 23 (1 point)\nlisten\nthe mean square error (mse) for the forecasts shown in the following table is:\nmonth forecast demand actual demand\napril 170 180\nmay 225 200\njune 210 200\njuly 260 240\naugust 200 230\nmore than 250 but less than or equal to 300.\nmore than 300 but less than or equal to 350.\nmore than 350 but less than or equal to 400.\nmore than 400 but less than or equal to 450.\nquestion 24 (1 point)\nlisten\nin the context of data patterns in a time series, regular patterns in a data series that take place over long periods of time are called ______ patterns.\northographic\nseasonal\ncyclical\nparallel patterns\nquestion 25 (1 point)\nlisten\na moving average (ma) method is most appropriate for data with major identifiable trends.\ntrue\nfalse
Answer
Question 23
Explanation:
Step1: Calculate error for each month
Error = Forecast - Actual. For April: $170 - 180=- 10$; May: $225 - 200 = 25$; June: $210 - 200 = 10$; July: $260 - 240 = 20$; August: $200 - 230=-30$.
Step2: Calculate squared - error for each month
Squared - error = Error$^2$. For April: $(-10)^2 = 100$; May: $25^2 = 625$; June: $10^2 = 100$; July: $20^2 = 400$; August: $(-30)^2 = 900$.
Step3: Calculate MSE
MSE=$\frac{\sum_{i = 1}^{n}e_{i}^{2}}{n}$, where $n = 5$, $\sum_{i = 1}^{5}e_{i}^{2}=100 + 625+100 + 400+900=2125$, MSE=$\frac{2125}{5}=425$.
Answer: more than 400 but less than or equal to 450.
Question 24
Brief Explanations:
Seasonal patterns occur over short - term regular intervals (e.g., daily, weekly, yearly). Cyclical patterns occur over long periods of time in a time - series data. Orthographic is related to spelling and parallel patterns are not relevant here.
Answer: cyclical
Question 25
Brief Explanations:
A moving average method is best for data with no trend or a very stable trend. It smooths out random fluctuations. For data with major identifiable trends, other methods like trend - adjusted exponential smoothing are more appropriate.