Question

FORCASTING Three Weighted Moving Average (3WMA) = (0.10), (0. 20) (0.70) Compute: MAE, MSE, MAPE Month...

FORCASTING Three Weighted Moving Average (3WMA) = (0.10), (0. 20) (0.70) Compute:


MAE, MSE, MAPE

Month SALES
80 1

140    2

200    3

260 4

320    5

380 6

440 7

500    8

560 9

720    10




Homework Answers

Answer #1

Weighted average forecast x't = w1*xt-1+w2*xt+w3*xt+1

Month Sales Forecasts
1 80
2 140 176
3 200 236
4 260 296
5 320 356
6 380 416
7 440 476
8 500 536
9 560 666
10 720

excel formulas

Month Sales Forecasts Error Absolute error Square error Percentage error
1 80
2 140 176 -36 36 1296 25.71429
3 200 236 -36 36 1296 18
4 260 296 -36 36 1296 13.84615
5 320 356 -36 36 1296 11.25
6 380 416 -36 36 1296 9.473684
7 440 476 -36 36 1296 8.181818
8 500 536 -36 36 1296 7.2
9 560 666 -106 106 11236 18.92857
10 720
MAE = 44.75 MSE = 2538.5 MAPE = 14.07
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Assume you are injection molding plastics parts using a polylactic acid. In the process, the resin...
Assume you are injection molding plastics parts using a polylactic acid. In the process, the resin is heated from room temperature (25 oC) to 200 oC. The cycle time is 5 second, and shot weight is 0.05 kg. Please calculate the heat input per hour of the process. The heat capacity data of PLA can be found from the excel file. The PLA used has 10, 000g/mol molecular weight (weight-average), Tg around 59.35 oC and melting point Tm at 160...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Problem 2: Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total Problem 3: A firm uses simple exponential smoothing with to forecast demand. The forecast for the week...
3. (Lesson 11) Use Minitab Express to conduct a chi-square test to determine if there is...
3. (Lesson 11) Use Minitab Express to conduct a chi-square test to determine if there is a relationship between gender and whether the student said that they would prefer to win an Academy Award, Nobel Prize, or Olympic Medal.  Use the five-step hypothesis testing procedure. [25 points] Step 1: State hypotheses and check assumptions Step 2:Compute the test statistic Step 3: Determine the p-value Step 4: Make a decision (reject or fail to reject the null) Step 5: State a real...
2. (Lesson 11) The “Year” variable represents whether each student identified as a first-year student, sophomore,...
2. (Lesson 11) The “Year” variable represents whether each student identified as a first-year student, sophomore, junior, or senior. Use Minitab Express to conduct a chi-square test to determine if the proportions of students who identify as each year are not all equal. Use the five-step hypothesis testing procedure. [25 points] Step 1: State hypotheses and check assumptions Step 2:Compute the test statistic Step 3: Determine the p-value Step 4: Make a decision (reject or fail to reject the null)...
Researchers in a 2015 study by Flannery et al. sought to estimate the effectiveness of the...
Researchers in a 2015 study by Flannery et al. sought to estimate the effectiveness of the seasonal influenza vaccine in preventing acute respiratory infection (ARI). A total of 507 subjects from Texas who showed symptoms of ARI were recruited for this study. The data provided show the result of each subject's test for influenza. Click to download the data in your preferred format.    CrunchIt!    CSV    Excel    JMP    Mac-Text    Minitab    PC-Text    R   ...
Your firm works in construction and buys ASTM A325M8S bolts in very large numbers. You are...
Your firm works in construction and buys ASTM A325M8S bolts in very large numbers. You are interested in purchasing bolts from different suppliers and have obtained and tested samples of 200 bolts from three suppliers: Allnutt, Boltzman, Coachers.You have tested these in your new bolt testing machine, purchased after you had discovered your old bolt testing machine was performing erratically. (For the purposes of this question, you are safe to assume that the new machine works perfectly and that its...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT