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
Concept explainers
Textbook Question
Chapter 8, Problem 26P
South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $308,000 in the first year of operation to $1,084,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars:
- a. Construct a time series plot. What type of pattern exists in the data?
- b. 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 I, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise.
- c. Based on the model you developed in part (b), compute estimates of quarterly sales for year 6.
- d. Let Period = 1 refer to the observation in quarter 1 of year 1; Period = 2 refer to the observation in quarter 2 of year 1; … and Period = 20 refer to the observation in quarter 4 of year 5. Using the dummy variables defined in part (b) and the variable Period, develop an equation to account for seasonal effects and any linear trend in the time series.
- e. Based on the seasonal effects in the data and linear trend estimated in part (c), compute estimates of quarterly sales for year 6.
- 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 solutionStudents have asked these similar questions
am. 13.
Suppose 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?
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 sales
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_forwardWhat does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardOlympic 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_forward
- Use the Financial database from “Excel Databases.xls” on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company. Use Excel to develop the multiple linear regression model. Assume a 5% level of significance. Which independent variable is the strongest predictor of the average P/E ratio of a company? A. Total Revenues B. Average Yield C. Earnings Per Share D.Return on Equity E. Total Assets F.Dividends Per Share Company Type Total Revenues Total Assets Return on Equity Earnings per Share Average Yield Dividends per Share Average P/E Ratio AFLAC 6 7251 29454 17.1 2.08 0.9 0.22 11.5 Albertson's 4 14690 5219 21.4 2.08 1.6 0.63 19 Allstate 6 20106 80918 20.1 3.56 1 0.36 10.6 Amerada Hess 7 8340 7935 0.2 0.08 1.1 0.6 698.3 American General 6 3362 80620 7.1 2.19 3 1.4 21.2 American Stores 4 19139 8536 12.2 1.01 1.4 0.34 23.5 Amoco 7 36287…arrow_forwardBalcom Enterprises is planning to introduce a new product that will sell for $150 a unit. Manufacturing cost estimates for 25,500 units for the first year of production are: Direct materials $1,530,000. Direct labor $969,000 (based on $19 per hour × 51,000 hours). Although overhead has not be estimated for the new product, monthly data for Balcom's total production for the last two years has been analyzed using simple linear regression. The analysis results are as follows: Dependent variable Factory overhead costs Independent variable Direct labor hours Intercept $ 131,000 Coefficient on independent variable $ 6.00 Coefficient of correlation 0.944 R2 0.836 Based on this information, what percentage of the variation in overhead costs is explained by the independent variable?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
- The following table shows the reported net sales by Nokia in 2008, 2009, and 2010. Year 2008 2009 2010x 0 1 2Sales ($ millions) 20 50 60 Find the Equation of the Linear Regression Line. Rounds decimal values to the nearest tenths.arrow_forwardConsider 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.7arrow_forwardThe county assessor is studying housing demand and is interested in developing a regression model to estimate the market value (i.e., selling price) of residential property within her jurisdiction. The assessor suspects that the most important variable affecting selling price (measured in thousands of dollars) is the size of house (measured in hundreds of square feet). She randomly selects 15 houses and measures both the selling price and size, as shown in the following table. Complete the table and then use it to determine the estimated regression line. Observation i 1 2 3 4 5 6 7 8 9 10 i 11 12 13 14 15 Total O 8.074 Regression Parameters Slope (B) Intercept (α) 10.181 8.358 O 0.327 Size (x 100 sq. ft.) O 0.316 12 20.2 27 O 0.398 30 30 O Yes 21.4 21.6 25.2 37.2 14.4 15 22.4 23.9 26.6 30.7 357.60 O No What is the standard error of the estimate (Se)? In words, for each hundred square feet, the expected selling price of a house Selling Price (x $1,000) Ii Yi y 265.2 253.4 12 2 20.2…arrow_forward
- Please solve all the questions belowarrow_forwardKidsFeet Regression Analysis Code The KidsFeet dataframe contains data collected on 39 fourth grade students in Ann Arbor, MI, in October 1997. Two of the measurements taken on the children were the length in centimeters, (length), and width in centimeters, (width), of their longest foot. This data could be used to answer the following Research Question: How is the width of a fourth-grade student's foot related to the length? Which of the following lines of code resulted in the following plot and regression analysis? Hint: More than one choice may be correct. ## ## Simple Linear Regression## ## Correlation coefficient r = 0.6411 ## ## Equation of Regression Line:## ## length = 9.817 + 1.658 * width ## ## Residual Standard Error: s = 1.025 ## R^2 (unadjusted): R^2 = 0.411 ( ) KidsFeetMod<-lmGC(length~width,data=KidsFeet) KidsFeetMod ( ) lmGC(width~length,data=KidsFeet,graph=TRUE) ( ) KidsFeetMod<-lmGC(width~length,data=KidsFeet)…arrow_forwardThe managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through o. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs OxBillable Hours (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) Monthly Overhead Costs and Billable Hours Data Overhead Costs $385,000 Billable Hours 3,000 $425,000 4,000 $445.000 5,000 $497,000 6,000 $570,000 7,000 $590,000 8,000arrow_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 LearningCollege AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
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
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY