The weekly sales figures (000 units) for a company are given below. Calculate the seasonal variation (000 units) for week 5 using a 3 period moving average to calculate the trend. Enter your answer to one decimal place. week 1: 167 week 2: 133 week 3: 180 week 4: 171 week 5: 177 week 6: 208 Correct Answer: -8.3
The weekly sales figures (000 units) for a company are given below. Calculate the seasonal variation (000 units) for week 5 using a 3 period moving average to calculate the trend. Enter your answer to one decimal place. week 1: 167 week 2: 133 week 3: 180 week 4: 171 week 5: 177 week 6: 208 Correct Answer: -8.3
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
How to calculate time series analysis
![ESTION 2:
CALCU
The weekly sales figures (000 units) for a company are given below. Calculate the
seasonal variation (000 units) for week 5 using a 3 period moving average to calculate
the trend. Enter your answer to one decimal place.
week 1: 167
week 2: 133
week 3: 180
week 4: 171
week 5: 177
week 6: 208
Correct Answer: -8.3
QUESTION 3: CALCULATED FORMULA
Brooks & Company are preforming time series analysis on their sales data for their most
popular product. The average sales seasonal variation (000 units) for each quarter is
calculated as: Qtr I is 4, Qtr Il is -1, Qtr Ill is -1 and Qtr IV is 7.
Calculate the adjusted average seasonal variation (000 units) for Qtr l. (Hint: you must
calculate the adjustment first). Answer correct to one decimal place.
Correct Answer: O1.8
QUESTION 4:
Page & Company has had the quarterly sales (000 units) given below for the last two years.
Calculate a trend figure (in 000 units) for quarter IIl of year 1 using the appropriate moving
CALCULATED FORMULA
averages. Enter your answer to nearest whole number.
Sales data (000 units) year 1: Qtr I is 118, Qtr Il is 164, Qtr IIl is 68 and Qtr IV is 53
Sales data (000 units) year 2: Qtr I is 200, Qtr Il is 232, Qtr IIl is 118 and Qtr IV is 86
Correct Answer: 111
QUESTION 5: CALCULATED FORMULA
The quarterly sales (in 000s units) for the past three years of a dune buggy have been anal
The trends, average seasonal variations and adjusted average seasonal variations have be
calculated. Some of the adjusted average seasonal variations (in 000s units) are:
Quarter 1: 18.5 Quarter 2:-5.6 Quarter 3: -8.4
The regression equation for the sales trend is given as Y = 85 +4.5X, where Y is the trend
units) and X represents the time periods, starting with X = 1 for Quarter I of the first of th
years.
Use the adjusted average seasonal variation figures and the regression equation to forec:
(to the nearest unit) for Quarter 1 of the fourth year.
Correct Answer: 162,000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F737bd472-54a8-413c-9fcd-626037e62eb0%2Fa21807dc-a7aa-43a0-bb78-16ee5a3b90bf%2Fuqnkam_processed.jpeg&w=3840&q=75)
Transcribed Image Text:ESTION 2:
CALCU
The weekly sales figures (000 units) for a company are given below. Calculate the
seasonal variation (000 units) for week 5 using a 3 period moving average to calculate
the trend. Enter your answer to one decimal place.
week 1: 167
week 2: 133
week 3: 180
week 4: 171
week 5: 177
week 6: 208
Correct Answer: -8.3
QUESTION 3: CALCULATED FORMULA
Brooks & Company are preforming time series analysis on their sales data for their most
popular product. The average sales seasonal variation (000 units) for each quarter is
calculated as: Qtr I is 4, Qtr Il is -1, Qtr Ill is -1 and Qtr IV is 7.
Calculate the adjusted average seasonal variation (000 units) for Qtr l. (Hint: you must
calculate the adjustment first). Answer correct to one decimal place.
Correct Answer: O1.8
QUESTION 4:
Page & Company has had the quarterly sales (000 units) given below for the last two years.
Calculate a trend figure (in 000 units) for quarter IIl of year 1 using the appropriate moving
CALCULATED FORMULA
averages. Enter your answer to nearest whole number.
Sales data (000 units) year 1: Qtr I is 118, Qtr Il is 164, Qtr IIl is 68 and Qtr IV is 53
Sales data (000 units) year 2: Qtr I is 200, Qtr Il is 232, Qtr IIl is 118 and Qtr IV is 86
Correct Answer: 111
QUESTION 5: CALCULATED FORMULA
The quarterly sales (in 000s units) for the past three years of a dune buggy have been anal
The trends, average seasonal variations and adjusted average seasonal variations have be
calculated. Some of the adjusted average seasonal variations (in 000s units) are:
Quarter 1: 18.5 Quarter 2:-5.6 Quarter 3: -8.4
The regression equation for the sales trend is given as Y = 85 +4.5X, where Y is the trend
units) and X represents the time periods, starting with X = 1 for Quarter I of the first of th
years.
Use the adjusted average seasonal variation figures and the regression equation to forec:
(to the nearest unit) for Quarter 1 of the fourth year.
Correct Answer: 162,000
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman