Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Minitab - Untitled - [Worksheet 1 = ] [ File Edit Data Cak Stat Graph Egtor Tools Window Help Moving Average Plot for Sales 101

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Geometry Using The Geometer's Sketchpad

Authors: Barbara E Reynolds, William E Fenton

1st Edition

1118213408, 9781118213407

More Books

Students also viewed these Mathematics questions

Question

Behaviour: What am I doing?

Answered: 1 week ago