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

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman