Basic Business Statistics, Student Value Edition
14th Edition
ISBN: 9780134685113
Author: Mark L. Berenson, David M. Levine, David F. Stephan, Kathryn Szabat
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 16, Problem 32PS
The following residuals are from a linear trend model used to forecast sales:
a. Compute
b. Compute the MAD and interpret your findings.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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?
Find the two lines of regression from the following dataAge of husband Age of wife 25 18 22 15 28 20 26 17 35 22 20 14 22 16
40 21 20 15 18 14Required►Estimate the age of husband when the age of wife is 19►Estimate the age of wife when the age of husband is 30► Calculate the coefficient correlation
The table given below indicates New Holding Ltd.’s quarterly profits in 2019 and 2020.Time Period Profit (Thousands Of Rands)2019 Q1 2502019 Q2 2102019 Q3 1652019 Q4 1952020 Q1 2652020 Q2 2182020 Q3 1782020 Q4 204
Determine the trend regression function for this data set. Given that the typical seasonal index for Q3 is 87.3, use this informationand the trend regression function obtained to determine theseasonally adjusted trend estimate for profits in Q3 of 2022.
Chapter 16 Solutions
Basic Business Statistics, Student Value Edition
Ch. 16 - If you are using exponential smoothing for...Ch. 16 - Consider a nine-year moving average used to smooth...Ch. 16 - You are using exponential smoothing on an annual...Ch. 16 - Prob. 4PSCh. 16 - Prob. 5PSCh. 16 - How have stocks performed in the past? The...Ch. 16 - Prob. 7PSCh. 16 - Prob. 8PSCh. 16 - Prob. 9PSCh. 16 - Prob. 10PS
Ch. 16 - The linear trend forecasting equation for an...Ch. 16 - There has been much publicity about bounces paid...Ch. 16 - Prob. 13PSCh. 16 - Prob. 14PSCh. 16 - Prob. 15PSCh. 16 - The data shown in the following table and stored...Ch. 16 - Prob. 17PSCh. 16 - Prob. 18PSCh. 16 - Prob. 19PSCh. 16 - Prob. 20PSCh. 16 - Prob. 21PSCh. 16 - Prob. 22PSCh. 16 - You are given an annual time series with 40...Ch. 16 - Prob. 24PSCh. 16 - Prob. 25PSCh. 16 - Prob. 26PSCh. 16 - Prob. 27PSCh. 16 - Prob. 28PSCh. 16 - Prob. 29PSCh. 16 - Using the average baseball salary from 200 through...Ch. 16 - Using the yearly amount of solar power generated...Ch. 16 - The following residuals are from a linear trend...Ch. 16 - Prob. 33PSCh. 16 - Prob. 34PSCh. 16 - Prob. 35PSCh. 16 - Prob. 36PSCh. 16 - Prob. 37PSCh. 16 - Prob. 38PSCh. 16 - Prob. 39PSCh. 16 - Prob. 40PSCh. 16 - In forecasting daily time-series data, how many...Ch. 16 - In forecasting a quarterly time series over the...Ch. 16 - Prob. 43PSCh. 16 - Prob. 44PSCh. 16 - Are gasoline prices higher during the height of...Ch. 16 - Prob. 46PSCh. 16 - Prob. 47PSCh. 16 - The file Silver-Q contains the price in London for...Ch. 16 - Prob. 49PSCh. 16 - What is a time series?Ch. 16 - What are the different components of a time-series...Ch. 16 - What is the difference between moving average and...Ch. 16 - Prob. 53PSCh. 16 - How does the least-squares linear trend...Ch. 16 - How does autoregressive modelling differ from the...Ch. 16 - What are the different approaches to choosing an...Ch. 16 - What is the major difference between using SYX and...Ch. 16 - How does forecasting for monthly or quarterly data...Ch. 16 - Prob. 60PSCh. 16 - The monthly commercial and residential prices for...Ch. 16 - The data stored in McDonalds represent the gross...Ch. 16 - Teachers’ Retirement System of the City of New...Ch. 16 - Prob. 64PS
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_forwardFor each of the following data sets, construct a scatter plot, draw a line of best fit, use two points to find the equation for the line, and predict the specified future value.arrow_forwardConsider the following regression equation representing the linear relationship between the Canada Child Benefit provided for a married couple with 3 children under the age of 6, based on their annual family net income: ŷ =121.09−0.57246xR2=0.894 where y = annual Canada Child Benefit paid (in $100s) x = net annual family income (in $1000s) Source: Canada Revenue Agency a. As the net annual family income increases, does the Canada Child Benefit paid increase or decrease? Based on this, is the correlation between the two variables positive or negative?The Canada Child Benefit paid .The correlation between the two variables is .b. Calculate the correlation coefficient and determine if the relationship between the two variables is strong, moderate or weak.r= , the relationship is . Round to 3 decimal places c. Interpret the value of the slope as it relates to this relationship. For every $1 increase in annual family net income, there is a $0.57246 decrease in…arrow_forward
- Consider the following regression equation representing the linear relationship between the Canada Child Benefit provided for a married couple with 3 children under the age of 6, based on their annual family net income: ŷ =121.09−0.57246xR2=0.894 where y= annual Canada Child Benefit paid (in $100s) x = net annual family income (in $1000s) Source: Canada Revenue Agency a. As the net annual family income increases, does the Canada Child Benefit paid increase or decrease? Based on this, is the correlation between the two variables positive or negative?The Canada Child Benefit paid ? .The correlation between the two variables is ? .b. Calculate the correlation coefficient and determine if the relationship between the two variables is strong, moderate or weak.r= , the relationship is ? . Round to 3 decimal places c. Interpret the value of the slope as it relates to this relationship. For every $1 increase in annual family net income, there is a $0.57246 decrease in…arrow_forwardA pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were Day: 1 2 3 4 5 6 7 8 9 Number sold: 34 37 40 39 45 43 47 49 48 Day: 10 11 12 13 14 15 Number sold: 52 53 47 53 47 49 a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 42 for Day 8, an initial trend estimate of 2, and α = β = .3, develop demand forecasts for Days 9 through 16. Then compute the resultant MSE using the error values from Days 8 through 15. (Round your intermediate period-by-period forecast and error values to 3 decimal places. Round your final MSE answer to 3 decimal places.) MSEarrow_forwardSuppose that the index model for two Canadian stocks HD and ML is estimated with the following results: RHD =-0.03+2.10RM+eHD R-squared =0.7 RML =0.06+1.60RM+eML R-squared =0.6 σM =0.15 where M is S&P/TSX Comp Index and RX is the excess return of stock X. What is the standard deviation of each stock? (Hint: βi = (ρiM σi) / σM.) What is the systematic risk of each stock?arrow_forward
- Use the following data to perform a regression analysis. What is the null hypothesis? What is the alternative Hypothesis? What is the R2 Month Sales 1 132 2 131 3 134 4 140 5 141 6 142 7 144 8 143 9 146 10 145 11 148 12 148arrow_forwardThe table given below indicates Small Holding Ltd.’s quarterly profits in 2019 and 2020.Time Period Profit (Thousands Of Rands)2019 Q1 2502019 Q2 2102019 Q3 1652019 Q4 1952020 Q1 2652020 Q2 2182020 Q3 1782020 Q4 204Q.6.3.1 Determine the trend regression function for this data set. In order to obtain full marks for this question, you must complete the relevanttable (template provided below) and then apply the appropriate timeseries formulae in the formulae sheet.Q.6.3.2 Given that the typical seasonal index for Q3 is 87.3, use this informationand the trend regression function obtained in Q.6.3.1 to determine theseasonally adjusted trend estimate for profits in Q3 of 2022.arrow_forwardConsider the following linear trend models estimated from 10 years of quarterly data with and without seasonal dummy variables d1, d2, and d3. Here, d1 = 1 for quarter 1, 0 otherwise; other dummy variables are defined similarly. Model 1: ŷ = 48.00 + 0.44t Model 2: ŷ = 48.00 + 0.46t − 0.38d1 − 0.42d2 − 0.12d3 Use each model to make a forecast for y for the first and the fourth quarters of the 11th year. Note: Round your answers to 2 decimal places. Which is the preferred model for forecasting if, relative to Model 1, Model 2 has higher R2 but lower adjusted R2?arrow_forward
- The following ratio-to-moving averages for the seasonally adjusted series were found by the decomposition method applied on a time series representing quarterly sales for January 2018 to December 2020 period: a. Calculate the Seasonal Index for every quarter. b. If the trend is described by the trend line T^ = 1,000 + 30 t, what is the forecast for the fourth quarter of 2021?arrow_forwardThe following time series shows the sales of supermarket chain over the last six months. Month Sales ($ 000) August 2021 250 Sep 2021 280 Oct 2021 295 Nov 2021 320 Dec 2021 380 Jan 2022 360 Develop a linear trend equation that can be used to forecast sales in Feb 2022. Forecast the sales in Feb 2021 using a three-period weighted moving average designed with the following weights: Nov 2021 weight 0.6, Dec 2021 weight 0.3 and Jan 2022 weight 0.1. Which method (A or B) is the best? Explain why.arrow_forwardA supplier of school stationary recorded its quarterly sales figures ($00s) for the years 2009 to 2012. The data is shown in the table below. Year Q1 Q2 Q3 Q4 2009 48 52 16 35 2010 50 46 22 40 2011 68 34 26 35 2012 73 56 3.1 Calculate centred 4- point moving averages (MA) for the data. 3.2 Plot the 4-point MA series on the same graph as the original series. 3.3 Comment on the trend component of the sales.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher: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
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