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
Textbook Question
Chapter 8, Problem 22P
Consider the following time series:
- a. Construct a time series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern?
- b. Use a multiple linear 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.
- c. Compute the quarterly forecasts for next year.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
b. Use a multiple linear 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. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank.
c. Compute the quarterly forecasts for next year.
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow.
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=1 if Quarter 1, 0 otherwise; Qtr2=1 if Quarter 2, 0 otherwise; Qtr3=1 if Quarter 3, 0 otherwise.
c) 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 also using t, develop an equation to account for seasonal effects and any linear trend in the time series. Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year.
STER.
1. Wine Consumption. The table below gives the U.S. adult wine consumption, in gallons per
person per year, for selected years from 1980 to 2005.
a) Create a scatterplot for the data. Graph the scatterplot
Year
Wine
below.
Consumption
2.6
b) Determine what type of model is appropriate for the
1980
data.
1985
2.3
c) Use the appropriate regression on your calculator to find a
Graph the regression equation in the same coordinate
plane below.
d) According to your model, in what year was wine
consumption at a minimum? A
e) Use your model to predict the wine consumption in
2008.
1990
2.0
1995
2.1
2000
2.5
2005
2.8
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
- 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_forwardWhat does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardPart I. Run two regressions in Excel using the provided Excel file “Layoffs”.The Excel file Layoffs provides data on 50 manufacturing workers who lost their jobs due to layoffs. The data includes the following list of variables:Weeks – the number of weeks a manufacturing worker has been without a jobAge – the age of the workerEducation – the number of years of education of the workerMarried – a dummy variable, equal to 1 if the worker is married, 0 otherwiseHead – a dummy variable, equal to 1 if the worker is a head of household, 0 otherwiseTenure – the number of years on the previous jobManager – a dummy variable, equal to 1 if the worker had a management occupation, 0 otherwise Sales – a dummy variable, equal to 1 if the worker had an occupation in sales, 0 otherwise 1. Run a simple regression with a dependent variable Weeks and an independent variable Age. Create the regular and standardized residual plots for the simple regression. 2. Run a multiple regression with a dependent…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. The current minimum wage is $5.15. If an employee earns the minimum wage, how many complaints can that employee expect to receive? Is the regression coefficient statistically significant? How can you tell?arrow_forwardestimate the sale of tyres when motor registration is known. The following table shows the number of motor registration in a certain temike for a term of 5 years and the sale of motor tyres by a firm in that territory for the same period. Year 1 3 4 5 Motor Registration No. of Tyres Sold Find the regression equation to Estimate sale of tyres when registration is 850. 600 630 720 750 800 1250 1100 1300 1350 1500arrow_forwardb. Add in the table provided in the spreadsheet a dummy variable that takes the value of 1in the fourth quarter of each year and show the table with all the data c. Using the data provided in the spreadsheet including the dummy variable you have created for the fourth quarter of each year run a regression with dependent variable the CBC house price index and independent variables the other three variables (Nominal GDP, Number of Households, and the dummy variable for the fourth quarter). Present the typical regression results output for this regression produced by Excel. d. Explain what the particular numbers for the following statistics that you presented in b) mean (no points will be given if you write general definitions without interpreting the particular numbers that you have presented): a. R-squared b. The t-statistics of the three independent variables c. The coefficients of the three independent variables e. Discuss if the signs that you get for the coefficients of each of the…arrow_forward
- Please use linear regression test statistics, and defined everything -- all parts.arrow_forwardThe electric power consumed each month by a chemical plant is thought to be related to the average ambient temperature (x1), the number of days in the month (x2). The past year’s historical data are available and are presented in the following table: Fit a multiple linear regression model to these data.arrow_forwardConsider the following time series: Quarter Year 1 Year 2 Year 3 80 74 65 69 61 51 48 50 43 68 71 82 a. Construct a time-series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? b. Use multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtrl = 1 if quarter 1,0 else; Qtr2 = 1 if quarter 2,0 else; Qtr3 = 1 if quarter 3,0 else. c. Compute the quarterly forecasts for next year.arrow_forward
- Which of the following time-series forecasting methods would not be used to forecast a time series that exhibits a linear trend with no seasonal or cyclical patterns? a. Dummy variable regression b. Linear trend regression c. Multiplicative Winter's method d. Holt Winter's double exponential smoothing e. Both A and Darrow_forwardA sociologist was hired by a large city hospital to investigate the relationship between thenumber of unauthorized days that employees are absent per year and the distance (miles)between home and work for the employees. A sample of 10 employees was chosen, andthe following data were collected. a. Develop a scatter chart for these data. Does a linear relationship appear reasonable?Explain.b. Use the data to develop an estimated regression equation that could be used to predict thenumber of days absent given the distance to work. What is the estimated regression model?c. What is the 99 percent confidence interval for the regression parameter b1? Based onthis interval, what conclusion can you make about the hypotheses that the regressionparameter b1 is equal to zero?d. What is the 99 percent confidence interval for the regression parameter b0? Based onthis interval, what conclusion can you make about the hypotheses that the regressionparameter b0 is equal to zero?e. How much of the…arrow_forwardA time series regression equation measuring the number of surfboards sold by a surfboard manufacturing company in Australia is given below: Y = 35 + 4Q 1+0.5Q3 + 8Q4+ 3t with tin quarters and the first observation of the dataset is December 2015 and Q1 is the indicator variable for March, Q3 is the indicator variable for September and Q4 is the indicator variable for December. Which of the following statements is correct? There is a mistake with this regression model because all the coefficients of the indicator variables are positive. There is no indicator variable for the June quarter in this model because there is no seasonal effect in June due to winter in Australia. There is a mistake with this model because the indicator variable for the June quarter has been left out. There is no indicator variable for the June quarter because the model has an intercept and including the June quarter would result in perfect multicollinearity.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:CengageGlencoe 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 HarcourtLinear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
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
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
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