Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Minitab - Untitled - [Worksheet 1 = ] [ File Edit Data Cak Stat Graph Egtor Tools Window Help Moving Average Plot for Sales 101
Minitab - Untitled - [Worksheet 1 "= ] [ File Edit Data Cak Stat Graph Egtor Tools Window Help Moving Average Plot for Sales 101 Variable Actua H X Q Fits 100 ATOON . IM - Forecasts A - 95.0% PI C1-D C2 C3 CA C5 C6 C7 C8 99 Quarter Year Sales AVER1 FITS1 RESI1 FORE1 Moving Average Length Mar 2007 96 97.2 98 Jun 98 Accuracy Measures Sep 96 MAPE 1.50365 Sales 97 - Dec 97 MAD 1.46875 96175 MSD 3.66406 Mar 2008 96 96.75 96.75 -0.75 96- Jun 100 97.25 96.75 3.25 Sep 97 97 50 97.25 -0.25 Dec 99 98.00 97.50 1.50 95 Mar 2009 96 98.50 98.00 0.00 Jun 96 97.25 98.50 -3.50 94 Sep 99 97.75 97.25 1.75 Dec 37.25 97.75 -0.75 93 Mar 2010 2 3 4 5 6 7 8 9 10 11 12 13 14 Jun 2010 Index Minitab - Untitled - [Worksheet 2 "] file Edit Data Cak Stat Graph Editor Tools Window Help Smoothing Plot for Sales Single Exponential Method 100 Variable . Actual TOO\\ . UM Fits C1-D C2 C3 CA C5 C6 C7 39 Smoothing Constant Quarter Year Sales SMOO1 FITS1 RESI1 FORE1 Alpha 0.118810 Mar 2007 96 97 4461 97.6410 -1.64105 97.4737 Accuracy Measures Jun 98 97.5119 97.4461 0.56392 MAPE 1.32599 Sep 96 97 3323 97.5119 -1.51189 MAD 1.29110 Dec 97 97 2928 97.3323 -0.33226 Sales MSD 2.35172 Mar 2008 96 97 1392 97.2928 -1.29278 97 Jun 100 97 4791 97.1392 2 86081 Sep 97 97 4222 97.4791 -0.47908 Dec 99 97 6096 97.4222 1.57784 96 Mar 2009 98 97.6560 97.6096 0.39037 Jun 95 97 3404 97.6560 -2.65601 Sep 99 97.5376 97.3404 1.65956 95 Dec 97 97 4737 97.5376 -0.53762 Mar 2010 2 3 4 5 6 8 9 10 11 12 Jun 2010 IndexFor this time series, given the information in the tables and graphs above, the forecast that you would recommend for Mar2010 would likely be [Press CTRL and "-" to see the whole table by reducing the font size. Press CTRL and "+" to restore the font size] Select one: 0 a. 97.47 O b. 1.50% O c. 1.32599 0 d. 97.25 e. Cannot be determined from the table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started