There are quarters of sales data 500,350,250,400 450,350,200,300 350,200,150,400 550,350,250,550 550,400,350,600 750,500,400,650,850 Using Minitab 18.0 Winter's time series forecasting method forecast 3 quarters...

Free

80.2K

Verified Solution

Question

Statistics

There are quarters of sales data
500,350,250,400
450,350,200,300
350,200,150,400
550,350,250,550
550,400,350,600
750,500,400,650,850
Using Minitab 18.0 Winter's time series forecasting methodforecast 3 quarters ahead
The weights are level=.2;trend=.2;seasonal=.2

Answer & Explanation Solved by verified expert

4.0 Ratings (799 Votes)

Â Â Â
1Â Â 500
2Â Â 350
3Â Â 250
4Â Â 400
5Â Â 450
6Â Â 350
7Â Â 200
8Â Â 300
9Â Â 350
10Â Â 200
11Â Â 150
12Â Â 400
13Â Â 550
14Â Â 350
15Â Â 250
16Â Â 550
17Â Â 550
18Â Â 400
19Â Â 350
20Â Â 600
21Â Â 750
22Â Â 500
23Â Â 400
24Â Â 650
25Â Â 850

Wintersâ€™ Method for C2

Multiplicative Method

DataÂ Â Â C2
Length 25

Smoothing Constants

Î± (level)Â Â Â Â 0.2
Î³ (trend)Â Â Â Â 0.2
Î´ (seasonal) 0.2

Accuracy Measures

MAPEÂ Â Â Â 19.0
MADÂ Â Â Â Â 76.7
MSDÂ Â 10429.7

Forecasts

Period ForecastÂ Â Â LowerÂ Â Â Upper
26Â Â Â Â Â Â 572.846 385.011Â Â 760.68
27Â Â Â Â Â Â 436.613 245.835Â Â 627.39
28Â Â Â Â Â Â 818.166 624.107 1012.23

Wintersâ€™ Method Plot for C2

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member