Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 8, Problem 24P
The quarterly sales data (number of copies sold) for a college textbook over the past three years are as follows:
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = l if quarter l, 0 otherwise; Qtr2 = l if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise.
- c. Based on the model you developed in part (b), compute the quarterly forecasts for next year.
- d. Let t = 1 to refer to the observation in quarter 1 of year 1; t = 2 to refer to the observation in quarter 2 of year 1; …; and t = 12 to refer to the observation in quarter 4 of year 3. Using the dummy variables defined in part (b) and t, develop an equation to account for seasonal effects and any linear trend in the time series.
- e. Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year.
- f. Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
am. 13.
Table 13 lists fall graduate enrollment by gender in U.S. degree-granting institutions. The figure contains a scatter plot and regression line for each data set, where x represents years since 1980 and y represents enrollment in millions.
Fall Graduate Enrollment (in millions)
Year
Male
Female
1980
0.87
0.75
1990
0.90
0.96
2000
0.94
1.21
2010
1.21
1.73
2020
1.21
1.70
A. Interpret the slope of each model.
B. Use the regression models to predict the male and female graduate enrollments in 2025.
C. Use the regression models to estimate the first year in which female graduate enrollment will exceed male graduate enrollment by at least 1 million.
Consider the data in the Excel file Nuclear Power. Use simple linear regression to forecast the data. What would be the forecasts for the next three years?
Nuclear Electric Power Production (Billion KWH)
Year
US
Canada
France
1980
251.12
35.88
63.42
1981
272.67
37.8
99.24
1982
282.77
36.17
102.6
1983
293.68
46.22
136
1984
327.63
49.26
180.5
1985
383.69
57.1
211.2
1986
414.04
67.23
239.6
1987
455.27
72.89
249.3
1988
526.97
78.18
260.3
1989
529.35
75.35
288.7
1990
576.86
69.24
298.4
1991
612.57
80.68
314.8
1992
618.78
76.55
321.5
1993
610.29
90.08
349.8
1994
640.44
102.4
342
1995
673.4
92.95
358.4
1996
674.73
88.13
377.5
1997
628.64
77.86
375.7
1998
673.7
67.74
368.6
1999
728.25
69.82
374.5
2000
753.89
69.16
394.4
2001
768.83
72.86
400
2002
780.06
71.75
414.9
2003
763.73
71.15
419
2004
788.53
85.87
425.8
2005
781.99
87.44
429
2006
787.22
93.07
427.7
Chapter 8 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 8 - Consider the following time series data:
Using...Ch. 8 - Refer to the time series data in Problem 1. Using...Ch. 8 - Problems 1 and 2 used different forecasting...Ch. 8 - Consider the following time series data:
Compute...Ch. 8 - Consider the following time series...Ch. 8 - Consider the following time series...Ch. 8 - Refer to the gasoline sales time series data in...Ch. 8 - Prob. 8PCh. 8 - Prob. 9PCh. 8 - Prob. 10P
Ch. 8 - For the Hawkins Company, the monthly percentages...Ch. 8 - Corporate triple A bond interest rates for 12...Ch. 8 - The values of Alabama building contracts (in...Ch. 8 - The following time series shows the sales of a...Ch. 8 - Prob. 15PCh. 8 - The following table reports the percentage of...Ch. 8 - Consider the following time series: a. Construct a...Ch. 8 - Consider the following time series:
Construct a...Ch. 8 - Because of high tuition costs at state and private...Ch. 8 - The Seneca Children’s Fund (SCF) is a local...Ch. 8 - The president of a small manufacturing firm is...Ch. 8 - Consider the following time series: a. Construct a...Ch. 8 - Consider the following time series...Ch. 8 - The quarterly sales data (number of copies sold)...Ch. 8 - Prob. 25PCh. 8 - South Shore Construction builds permanent docks...Ch. 8 - Hogs & Dawgs is an ice cream parlor on the border...Ch. 8 - Donna Nickles manages a gasoline station on the...Ch. 8 - The Vintage Restaurant, on Captiva Island near...
Knowledge Booster
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.Similar questions
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardTable 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?arrow_forwardWhat does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forward
- Olympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?arrow_forwardTable 3 gives the annual sales (in millions of dollars) of a product from 1998 to 20006. What was the average rate of change of annual sales (a) between 2001 and 2002, and (b) between 2001 and 2004?arrow_forwardSuppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $2,570,000 $3,750,000 $4,380,000 $5,010,000 $5,520,000 What would be the forecast for next year’s sales using regression to estimate a trend?arrow_forward
- The U.S. Postal Service is attempting to reduce the number of complaints made by the public against its workers. To facilitate this task, a staff analyst for the service regresses the number of complaints lodged against an employee last year on the hourly wage of the employee for the year. The analyst ran a simple linear regression in SPSS. The results are shown below. What proportion of variation in the number of complaints can be explained by hourly wages? From the results shown above, write the regression equation If wages were increased by $1.00, what is the expected effect on the number of complaints received per employee?arrow_forwardThe global mean sea level variations taken from satellite observations in the month of May are given in the table below. The variations are calculated using the base May 1997. for example, the mean sea level in May 2008 was 34.37 mm higher than in May 1997. Find the linear model for the data and use it to predict the change in sea level for the year in 2017. year 1997 1999 2001 2005 2008 2012 2014 Sea level change (mm) 0 4.77 15.25 30.75 34.37 47.84 54.13 A)what method will you use to find the model, polynomial interolation or least squares, why? b) write the equation that must be used to find the model and then write the system of equations. c) wirte the vandermonde matrix and the other matrices that must be used. e) write the MatLab formula to find the model. f) wirte the cubic model(find the values using MatLab)arrow_forwardIn retail, a store manager uses time series models to understand shopping trends. Review the scatter plot of the store’s sales from 2010 through 2021 to answer the questions. See attached as image. Here is the data for Fiscal Year and Sales: Fiscal Year Sales 2010 $260,123.00 2011 $256,853.00 2012 $274,366.00 2013 $290,525.00 2014 $322,318.00 2015 $380,921.00 2016 $541,925.00 2017 $909,050.00 2018 $1,817,521.00 2019 $3,206,564.00 2020 $4,921,005.00 2021 $5,686,338.00 Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components? The model can be additive or multiplicative. When do you use each? Review the scatter plot of the exponential trend of the time series data. Do you observe a trend? If so, what type of trend do you observe? What predictions might you make about the store’s annual sales over the next few years?arrow_forward
- Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $2,430,000 $3,650,000 $4,300,000 $5,010,000 $5,660,000 What would be the forecast for next year's sales using regression to estimate a trend? Next year's salesarrow_forwardThe following chart shows the actual sales for the last 12 months for a given company. Assume that sales are best fit by a linear trend and you can use single linear regression to set up a forecasting model. Using the sales data answer below questions (justify your answers): A.What would be the typical linear regression equation for the number of sales? B.Make the sales forecast for period 15 of next year. C. Make the sales forecast for period 17 of next year. D. What is the standard error for the data?arrow_forwardThe following data are the monthly salaries and the grade point averages for students who obtained a bachelor's degree in mathematics. GPA: 2.6, 3.4, 3.6, 3.2, 3.5, and 2.9; Monthly Salary: 3300, 3600, 4000, 3500, 3900, and 3600. Compute for the estimated simple linear regression equation.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY