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,...
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...
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
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...
Using R and the data in the table below, perform the regression of D on C...
Using R and the data in the table below, perform the regression
of D on C (i.e., report the regression equation).
Hint: The code to enter the vectors C and D into R is: C <-
c(3, 6, 8, 9, 1, 3) D <- c(2, 7, 5, 4, 0, 4)
C
D
3
2
6
7
8
5
9
4
1
0
3
4
You must figure out how to obtain the regression equation from
R. Enter the code below...
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...
home / study / business / accounting / accounting questions and answers / [the following information...
home / study / business / accounting / accounting questions and
answers / [the following information applies to the questions
displayed below.] lexon inc. is a large ...
Question: [The following information applies to the
questions displayed below.] Lexon Inc. is a large manuf...
[The following information applies to the questions
displayed below.]
Lexon Inc. is a large manufacturer of affordable DVD players.
Management recently became aware of rising expenses resulting from
returns of malfunctioning products. As a starting point...
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.
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 3 minutes ago
asked 14 minutes ago
asked 25 minutes ago
asked 28 minutes ago
asked 47 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago