The Holy Smokes Corporation sells altar candles world-wide. Quarterly sales dat on the Q1-4 Time Series tab. Use the Seasonal Index technique shown as Forecas answer the following: Period Sales ($mil) $5.00 Year Annual Period Quarter 2008 1 1 2008 1 2 $3.00 2008 1 3 $2.00 2008 4 4 $7.00 2009 2. 1 $6.00 2009 2 $4.00 2009 7 $4.00 $14.00 $10.00 $3.00 2009 4. 8. 2010 1 2010 2 10 2010 11 $5.00 2010 12 $16.00 2011 4 1 13 $12.00 2011 4 2 14 $9.00 2011 4. 15 $7.00 2011 4. 4. 16 $22.00 2012 1 17 $18.00 2012 $10.00 $13.00 $35.00 2 18 2012 19 2012 20 23

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Use regression analysis to estimate a linear trend line for annual sales.

The Holy Smokes Corporation sells altar candles world-wide. Quarterly sales data for the past 5 years are shown
on the Q1-4 Time Series tab. Use the Seasonal Index technique shown as Forecasting Methods spreadsheet to
answer the following:
Predicted
Predicted
Year
Annual Period
Quarter
Period
Sales ($mil)
Annual Sales
Seasonal
Quarter
AE
MPE
MAD
МАРЕ
$5.00
$3.00
$2.00
$7.00
$6.00
$4.00
$4.00
$14.00
$10.00
$3.00
$5.00
$16.00
$12.00
$9.00
$7.00
$22.00
$18.00
$10.00
$13.00
$35.00
2008
1
1
1
2008
1
2
2
2008
1
3
3
2008
1
4
4
2009
1
2009
2
2
2009
2
7
2009
2
4
8
2010
3
1
2010
2
10
2010
3
3
11
2010
3
4
12
2011
4
1
13
2011
4
14
2011
4
15
2011
4
4
16
2012
1
17
2012
5
2
18
2012
3
19
2012
4
20
Transcribed Image Text:The Holy Smokes Corporation sells altar candles world-wide. Quarterly sales data for the past 5 years are shown on the Q1-4 Time Series tab. Use the Seasonal Index technique shown as Forecasting Methods spreadsheet to answer the following: Predicted Predicted Year Annual Period Quarter Period Sales ($mil) Annual Sales Seasonal Quarter AE MPE MAD МАРЕ $5.00 $3.00 $2.00 $7.00 $6.00 $4.00 $4.00 $14.00 $10.00 $3.00 $5.00 $16.00 $12.00 $9.00 $7.00 $22.00 $18.00 $10.00 $13.00 $35.00 2008 1 1 1 2008 1 2 2 2008 1 3 3 2008 1 4 4 2009 1 2009 2 2 2009 2 7 2009 2 4 8 2010 3 1 2010 2 10 2010 3 3 11 2010 3 4 12 2011 4 1 13 2011 4 14 2011 4 15 2011 4 4 16 2012 1 17 2012 5 2 18 2012 3 19 2012 4 20
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman