Question
Would like to see it done in EXCEL Vehicle Sales: Consider the data below ( in...
Would like to see it done in EXCEL
Vehicle Sales: Consider the data below ( in thousands of units):
year Quarter 1 Quarter 2 Quarter 3 Quarter 4
2016: 4072 4521 4452 4418
2017: 4010 4392 4399 4334
2018: 4092 4484 4277 4360
Obtain the seasonal factors and enter them into the appropriate yellow cells below:
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Seasonal Factor
Using the columns Year and Total (Annual Sales) below, obtain the regression equation from the Excel's Scatter Diagram
Year Quarter 1 Quarter 2 Quarter 3 Quarter 4
2016: 4072 4521 4452 4418
2017: 4010 4392 4399 4334
2018: 4092 4484 4277 4360
(enter equation and paste graph in appropriate yellow areas below) ?? How to get equation from the graph?
Enter equation --->
Paste Scatter Diagram --------------------------------------------------------------------------------------------------------------->
Using the regression equation, what is your forecast for year 2018? (enter answer in yellow cell below)
Enter Forecast for Year 2019 -->
Using the seasonal factors obtained and your forecast for Year 2019, forecast Quarters 1 to 4 of Year 2019 (enter values in appropriate yellow cells below)
Year Quarter 1 Quarter 2 Quarter 3 Quarter 4
2016: 4072 4521 4452 4418
2017: 4010 4392 4399 4334
2018: 4092 4484 4277 4360
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Forecast for 2019
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
Consider the following time series data (Insert the data in an Excel file): Quarter Year 1...
Consider the following time series data (Insert the data in an
Excel file):
Quarter Year 1 Year 2 Year 3
1 8 9 12
2 5 6 9
3 7 8 10
4 8 11 11
2.1. Construct a time series plot. What type of pattern exists
in the data?
2.2. Use a multiple regression model with dummy variables as
follows to develop an equation to account for seasonal effects in
the data. Qtr1=1 if quarter 1, 0 otherwise; Qtr2=1...
Year Quarter Sales ($000) 2015 1 $400 2015 2 2,000 2015 3 3,500 2015 4 260...
Year
Quarter
Sales ($000)
2015
1
$400
2015
2
2,000
2015
3
3,500
2015
4
260
2016
1
740
2016
2
2,720
2016
3
4,900
2016
4
520
2017
1
1,500
2017
2
3,100
2017
3
6,520
2017
4
960
2018
1
1,840
2018
2
4,040
2018
3
7,680
2018
4
1,640
2019
1
3,520
2019
2
5,640
2019
3
8,900
2019
4
3,620
Problem
2
House Depot’s quarterly sales of a lawn, landscaping, and
gardening items – like lawnmowers,...
Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4...
Year
Quarter
Sales (in Billions)
2009
1
2.62
2009
2
2.33
2009
3
2.4
2009
4
2.42
2010
1
2.72
2010
2
2.53
2010
3
2.61
2010
4
2.84
2011
1
2.95
2011
2
2.79
2011
3
2.93
2011
4
3.03
2012
1
3.44
2012
2
3.2
2012
3
3.3
2012
4
3.36
2013
1
3.79
2013
2
3.56
2013
3
3.74
2013
4
3.8
2014
1
4.24
2014
2
3.87
2014
3
4.15
2014
4
4.18
2015
1
4.8...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of...
Question 5: Forecasting (8
p)
The table below shows the demand (in units per quarter) of a
specific product in the past three years.
Quarter
Year
1
2
3
4
2015
350
254
176
228
2016
367
258
169
236
2017
342
250
166
228
Predict demand in quarter 1 and quarter 2 of 2018, given that
the demand forecast for the whole year is a total of 1,040
units.
Find the seasonalized forecast for Q2 of 2017.The sales trend has been modeled as: Sales =...
Find the seasonalized forecast for Q2 of 2017.The sales trend
has been modeled as: Sales = 2 * t + 200, where t= time in
quarters, beginning in Q1 2014. Seasonality for the four quarterly
periods is given in the table below.
Quarter
Seasonal Factor
Quarter #1
1.2000
Quarter #2
1.41
Quarter #3
0.5000
Quarter #4
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series.
Quarter
Year 1
Year 2
Year 3
1
71
68
62
2
48
40
50
3
59
61
54
4
78
81
72
(a) Construct a time series plot.
What type of pattern exists in the data?
a)The time series plot shows a horizontal pattern, but there is
also a seasonal pattern in the data.
b)The time series plot shows a horizontal pattern with no
seasonal pattern present.
c)The time series plot shows a trend...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series.
Quarter
Year 1
Year 2
Year 3
1
71
68
62
2
50
42
52
3
59
61
54
4
78
81
72
(a)
Construct a time series plot.
What type of pattern exists in the data?
The time series plot shows a horizontal pattern, but there is
also a seasonal pattern in the data.
The time series plot shows a trend pattern, but there is also a
seasonal pattern in the data.
The...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6...
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
4
6
7
2
2
3
6
3
3
5
6
4
5
7
8
Use a multiple regression model with dummy variables as follows
to develop an equation to account for seasonal effects in the data.
Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0
otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round
your answers...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series.
Quarter
Year 1
Year 2
Year 3
1
71
68
62
2
49
41
51
3
57
59
52
4
78
81
72
(a) Use the following dummy variables to develop an
estimated regression equation to account for seasonal effects in
the data:
x1 = 1 if quarter 1, 0 otherwise;
x2 = 1 if quarter 2, 0 otherwise;
x3 = 1 if quarter 3, 0 otherwise.
= _____?______
(b) Compute the quarterly forecasts for...
We consider data in the following table, summarizing sales of a product (in thousands). For each...
We consider data in the following table, summarizing sales of a
product (in thousands). For each of the questions, justify your
answer.
Year
Quarter
Sales
2015
1
2
3
4
4.95
4.25
6.15
6.65
2016
1
2
3
4
5.85
5.35
6.95
7.55
2017
1
2
3
4
6.15
5.75
7.65
7.95
(3.3) Ignoring seasonality and assuming the the time-series as
given follows an AR(1) process, what is the expected sales value
for the first quarter of 2018? (5)
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 6 minutes ago
asked 9 minutes ago
asked 11 minutes ago
asked 15 minutes ago
asked 21 minutes ago
asked 23 minutes ago
asked 35 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago