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

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter7: Analytic Trigonometry
Section7.6: The Inverse Trigonometric Functions
Problem 94E
icon
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
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
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Series
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
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning