2. General Motors Management would estimate the percent of customers who will return to again choose a GM car. The following table contains five years of quarterly revenue (sales) data, including: quarter, revenues, revenues revenues q-4, lagged (delayed) revenues from four quarters ago, General GM Motors revenu es ($B) q-4 revenue date s ($B) Saturday, December 1, 2001 43.774 42.118 Friday, March 1, 2002 Saturday, June 1, 2002 Sunday, September 1, 2002 44.21 40.698 46.113 44.217 41.417 40.362 Sunday, December 1, 2002 Saturday, March 1, 2003 Sunday, June 1, 2003 Monday, September 1, 2003 45.584 43.774 47.146 44.21 45.944 46.113 43.35 41.417 Monday, December 1, 2003 49.084 45.584 onday, March 1, 2004 Tuesday, June 1, 2004 Wednesday, September 1, 2004 47.83 47.146 49.254 45.944 44.934 43.35 Wednesday, December 1, 2004 51.428 49.084

College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter8: Sequences, Series, And Probability
Section8.CT: Chapter Test
Problem 9CT: Find three arithmetic means between 4 and 24.
icon
Related questions
Topic Video
Question

answer in minitab or excel

2. General Motors Management would estimate the percent of
customers who will return to again choose a GM car. The
following table contains five years of quarterly revenue (sales)
data, including:
quarter,
revenues, revenues
revenues q-4, lagged (delayed) revenues from four
quarters ago,
General
GM
Motors
revenu
revenue
es ($B)
date
s ($B)
g-4
Saturday, December 1,
2001
43.774
42.118
Friday, March 1, 2002
44.21
40.698
Saturday, June 1, 2002
Sunday, September 1,
2002
46.113
44.217
41.417
40.362
Sunday, December 1, 2002
Saturday, March 1, 2003
Sunday, June 1, 2003
Monday, September 1,
2003
45.584
43.774
47.146
44.21
45.944
46.113
43.35
41.417
Monday, December 1,
2003
49.084
45.584
4
Monday, March 1, 2004
Tuesday, June 1, 2004
Wednesday, September 1,
47.83
49.254
45.944
2004
44.934
43.35
Wednesday, December 1,
2004
51.428
49.084
Transcribed Image Text:2. General Motors Management would estimate the percent of customers who will return to again choose a GM car. The following table contains five years of quarterly revenue (sales) data, including: quarter, revenues, revenues revenues q-4, lagged (delayed) revenues from four quarters ago, General GM Motors revenu revenue es ($B) date s ($B) g-4 Saturday, December 1, 2001 43.774 42.118 Friday, March 1, 2002 44.21 40.698 Saturday, June 1, 2002 Sunday, September 1, 2002 46.113 44.217 41.417 40.362 Sunday, December 1, 2002 Saturday, March 1, 2003 Sunday, June 1, 2003 Monday, September 1, 2003 45.584 43.774 47.146 44.21 45.944 46.113 43.35 41.417 Monday, December 1, 2003 49.084 45.584 4 Monday, March 1, 2004 Tuesday, June 1, 2004 Wednesday, September 1, 47.83 49.254 45.944 2004 44.934 43.35 Wednesday, December 1, 2004 51.428 49.084
Tuesday, March 1, 2005
Wednesday, June 1, 2005
Thursday, September 1,
2005
46.286
47.83
48.99
49.254
47.727
44.934
Thursday, December 1,
2005
51.652
51.428
Wednesday, March 1, 2006
Thursday, June 1, 2006
Friday, September 1, 2006
Friday, December 1, 2006
Thursday, March 1, 2007
Friday, June 1, 2007
Saturday, September 1,
2007
52.376
46.286
54.464
48.99
49.3
47.727
51.209
51.652
52.376
54.464
49.3
Saturday, December 1,
2007
51.209
a. Give your regression equation.
b. What percent of variation in revenues can be accounted for
by past revenues?
c. How close to actual revenues could you expect a forecast to
be 95% of the
time?
d. What range in percents of this quarter's GM revenues could
management
be 95% certain to expect will repeat next year?
e. Present a scatterplot of 95% individual prediction intervals
with actual
revenues by quarter.
Transcribed Image Text:Tuesday, March 1, 2005 Wednesday, June 1, 2005 Thursday, September 1, 2005 46.286 47.83 48.99 49.254 47.727 44.934 Thursday, December 1, 2005 51.652 51.428 Wednesday, March 1, 2006 Thursday, June 1, 2006 Friday, September 1, 2006 Friday, December 1, 2006 Thursday, March 1, 2007 Friday, June 1, 2007 Saturday, September 1, 2007 52.376 46.286 54.464 48.99 49.3 47.727 51.209 51.652 52.376 54.464 49.3 Saturday, December 1, 2007 51.209 a. Give your regression equation. b. What percent of variation in revenues can be accounted for by past revenues? c. How close to actual revenues could you expect a forecast to be 95% of the time? d. What range in percents of this quarter's GM revenues could management be 95% certain to expect will repeat next year? e. Present a scatterplot of 95% individual prediction intervals with actual revenues by quarter.
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Algebraic Operations
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
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning