MyLab Statistics for Business Stats with Pearson eText -- Standalone Access Card -- for Statistics for Business and Economics
13th Edition
ISBN: 9780134748610
Author: James T. McClave, P. George Benson, Terry Sincich
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 14, Problem 14.68ACI
To determine
To identify: The best forecasting model by applying the MAD, MAPE and RMSE criteria to evaluate the forecasts for the four quarters of 2016.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Compute the forecasted values for Yt for July and August in 2020 by using the modelsstated in (c) and (d)
The MAD for the forecast developed using a weighted 2-year moving average with weights of
0.350.35
and
0.650.65 is what?
After using your forecasting model for six months, you decide to test it using MAD and a tracking signal. Here are the forecast and actual demands for the six-month period:
PERIOD
FORECAST
ACTUAL
May
450
480
June
500
560
July
550
380
August
590
465
September
635
650
October
715
610
a. Find the tracking signal.
Chapter 14 Solutions
MyLab Statistics for Business Stats with Pearson eText -- Standalone Access Card -- for Statistics for Business and Economics
Ch. 14.1 - Explain in words how to construct a simple index.Ch. 14.1 - Explain in words how to calculate the following...Ch. 14.1 - Explain in words the difference between Laspeyres...Ch. 14.1 - The table below gives the prices for three...Ch. 14.1 - Refer to Exercise 14.4. The next table gives the...Ch. 14.1 - Annual median family income. The table below lists...Ch. 14.1 - Annual U.S. craft beer production. While overall...Ch. 14.1 - Quarterly single-family housing starts. The...Ch. 14.1 - Spot price of natural gas. The table shown in the...Ch. 14.1 - Employment in farm and nonfarm categories....
Ch. 14.1 - GOP personal consumption expenditures. The gross...Ch. 14.1 - GDP personal consumption expenditures (contd)....Ch. 14.1 - Weekly earnings for workers. The table in the next...Ch. 14.1 - Production and price of metals. The level or price...Ch. 14.2 - Describe the effect of selecting an exponential...Ch. 14.2 - A monthly time series is shown in the table to the...Ch. 14.2 - Annual U.S. craft beer production. Refer to the...Ch. 14.2 - Foreign fish production. Overfishing and pollution...Ch. 14.2 - Yearly price of gold. The price of gold is used by...Ch. 14.2 - Personal consumption in transportation. There has...Ch. 14.2 - OPEC crude oil imports. The data in the table...Ch. 14.2 - SP 500 Stock Index. Standard Poors 500 Composite...Ch. 14.5 - How does the choice of the smoothing constant w...Ch. 14.5 - Refer to Exercise 14.4 (p. 14-9). The table with...Ch. 14.5 - Annual U.S. craft beer production. Refer to...Ch. 14.5 - Quarterly single-family housing starts. Refer to...Ch. 14.5 - Consumer Price Index. The CPI measures the...Ch. 14.5 - OPEC crude oil imports. Refer to the annual OPEC...Ch. 14.5 - SP 500 Stock Index. Refer to the quarterly...Ch. 14.5 - SP 500 Stock Index (contd). Refer to Exercise...Ch. 14.5 - Monthly gold prices. The fluctuation of gold...Ch. 14.6 - Annual U.S. craft beer production. Refer to the...Ch. 14.6 - Annual U.S. craft beer production (contd). Refer...Ch. 14.6 - SP 500 Stock Index. Refer to your exponential...Ch. 14.6 - SP 500 Stock Index (contd). Refer to your Holt...Ch. 14.6 - Monthly gold prices. Refer to the monthly gold...Ch. 14.6 - US school enrollments. The next table reports...Ch. 14.8 - The annual price of a finished product (in cents...Ch. 14.8 - Retail sales in Quarters 14 over a 10-year period...Ch. 14.8 - What advantage do regression forecasts have over...Ch. 14.8 - Mortgage interest rates. The level at which...Ch. 14.8 - Price of natural gas. Refer to Exercise 14.9 (p....Ch. 14.8 - A gasoline tax on carbon emissions. In an effort...Ch. 14.8 - Predicting presidential elections. Researchers at...Ch. 14.8 - Life insurance policies in force. The table below...Ch. 14.8 - Graphing calculator sales. The next table presents...Ch. 14.8 - Prob. 14.47ACICh. 14.9 - Define autocorrelation. Explain why it is...Ch. 14.9 - For each case, indicate the decision regarding the...Ch. 14.9 - What do the following Durbin-Watson statistics...Ch. 14.9 - Company donations to charity. Refer to the Journal...Ch. 14.9 - Forecasting monthly car and truck sales. Forecasts...Ch. 14.9 - Predicting presidential elections. Refer to the...Ch. 14.9 - Mortgage interest rates. Refer to the data on...Ch. 14.9 - Price of natural gas. Refer to the annual data on...Ch. 14.9 - Life insurance policies in force. Refer to the...Ch. 14.9 - Modeling the deposit share of a retail bank....Ch. 14 - Insured Social Security workers. Workers insured...Ch. 14 - Insured Social Security workers (contd). Refer to...Ch. 14 - Retail prices of food items. In 1990, the average...Ch. 14 - Demand for emergency room services. With the...Ch. 14 - Mortgage interest rates. Refer to the annual...Ch. 14 - Price of Abbott Labs stock. The yearly closing...Ch. 14 - Price o f Abbott Labs stock (contd). Refer to...Ch. 14 - Prob. 14.65ACICh. 14 - Prob. 14.66ACICh. 14 - Quarterly GOP values (contd). Refer to Exercise...Ch. 14 - Prob. 14.68ACICh. 14 - Prob. 14.69ACICh. 14 - Prob. 14.70ACICh. 14 - IBM stock prices. Refer to Example 14.1 (p. 14-5)...Ch. 14 - Prob. 14.72ACI
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
- In 2013 the average houshold credit card balance was $9,884. In 2016 the average houshold credit card balance was $11,184. (a) Compute the average yearly change in credit card balance from 2013 to 2016 (b) Use this to predict what the average credit card balance was in:i. 2014ii. 2015iii. 2017iv. 2018 (c) In 2014 the avearge balance was $10,450 and in 2015 the avearge balance was $10,762. Where your predictions good for those years? (d) In 2017 the average balance was $10,821 and in 2018 the aveage balance was $9,333. Where your predictions good for those years?arrow_forwardThe LawnPlus Fertilizer Company distributes fertilizer tovarious lawn and garden shops. The company must base itsquarterly production schedule on a forecast of how manytons of fertilizer will be demanded from it. The companyhas gathered the following data for the past three yearsfrom its sales records. a. Compute a three-quarter moving average forecast forquarters 4 through 13 and compute the forecast errorfor each quarter.b. Compute a five-quarter moving average forecast forquarters 6 through 13 and compute the forecast errorfor each quarter.c. Compute a weighted three-quarter moving averageforecast using weights of 0.50, 0.33, and 0.17 for the most recent, next recent, and most distant data, respec-tively, and compute the forecast error for each quarter. d. Compare the forecasts developed in parts (a), (b), and(c) using cumulative error. Which forecast appears tobe most accurate? Do any exhibit any bias?arrow_forwardUse the following Sales Data to a) Develop a 4-month moving average forecast, a forecast for January, and compute the MAD. b)Develop 3-month moving average forecast, a forecast for January, and calculate a MAD. c) Which model should be used in the future? Explain why this is your answer. Month Actual Shed Sales January 10 February 12 March 13 April 16 May 19 June 23 July 26 August 30 September 28 October 18 November 16 December 14arrow_forward
- The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year 1 2 3 4 5Mileage 3,050 3,950 3,450 3,850 3,800 a) Using a 2-year moving average, the forecast for year 6 = miles (round your response to the nearest whole number).arrow_forwardGiven the number of incidents between 1 to 7 October 2021 in the table below: Date Incidents 1/10/2021 99430 2/10/2021 101786 3/10/2021 103843 4/10/2021 106318 5/10/2021 109804 6/10/2021 113381 7/10/2021 116864 Calculate the MAPE only for these 7 days and compare the forecasting accuracy of the model for this period with its fitting accuracy during the observation period.arrow_forwardLarge companies typically collect volumes of data before designing a product, not only to gain information as to whether the product should be released, but also to pinpoint which markets would be the best targets for the product. Several months ago, I was interviewed by such a company while shopping at a mall. I was asked about my exercise habits and whether or not I'd be interested in buying a video/DVD designed to teach stretching exercises. I fall into the male, 18 – 35-years-old category, and I guessed that, like me, many males in that category would not be interested in a stretching video. My friend Diane falls in the female, older-than-35 category, and I was thinking that she might like the stretching video. After being interviewed, I looked at the interviewer's results. Of the 93 people in my market category who had been interviewed, 17 said they would buy the product, and of the 113 people in Diane's market category, 34 said they would buy it. Assuming that these data came…arrow_forward
- Large companies typically collect volumes of data before designing a product, not only to gain information as to whether the product should be released, but also to pinpoint which markets would be the best targets for the product. Several months ago, I was interviewed by such a company while shopping at a mall. I was asked about my exercise habits and whether or not I'd be interested in buying a video/DVD designed to teach stretching exercises. I fall into the male, 18 – 35-years-old category, and I guessed that, like me, many males in that category would not be interested in a stretching video. My friend Amanda falls in the female, older-than-35 category, and I was thinking that she might like the stretching video. After being interviewed, I looked at the interviewer's results. Of the 97 people in my market category who had been interviewed, 16 said they would buy the product, and of the 101 people in Amanda's market category, 31 said they would buy it. Assuming that these data came…arrow_forwardWhich of the following time series forecasting methods would not be used to forecast seasonal data?arrow_forwardLarge companies typically collect volumes of data before designing a product, not only to gain information as to whether the product should be released, but also to pinpoint which markets would be the best targets for the product. Several months ago, I was interviewed by such a company while shopping at a mall. I was asked about my exercise habits and whether or not I'd be interested in buying a video/DVD designed to teach stretching exercises. I fall into the male, 18-35-years-old category, and I guessed that, like me, many males in that category would not be interested in a stretching video. My friend Holly falls in the female, older-than-35 category, and I was thinking that she might like the stretching video. After being interviewed, I looked at the interviewer's results. Of the 89 people in my market category who had been interviewed, 20 said they would buy the product, and of the 103 people in Holly's market category, 28 said they would buy it. Assuming that these…arrow_forward
- 4) the accompanying dataset provides data on monthly unemployment rates for a certain region over four years. Compare 3- and 12- month moving average forecast using the MAD criterion. Which of the two models yields better results? (See picture) Find the MAD for the 3 month moving average forcast. MAD = _____arrow_forwardGreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $4,000 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns has obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media: S = -2R2 − 12M2 − 9RM + 20R + 39M, Where S = total sales in thousands of dollars R = thousands of dollars spent on radio advertising M = thousands of dollars spent on direct-mail advertising GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. (a) What is the value of sales if $3,000 is spent on radio advertising and $1,000 is…arrow_forwardDetermine if the following scenarios involve an observational study or an experiment. Make sure your answers are legible and spelled correctly. A team of ecologists determines the different species of frogs that live in the local swamplands. A medical researcher divides patients into a treatment group and a control group to determine the effect of a new drug on overall cholesterol levels in patients. A medical insurance company determines the average cost to cover a tooth extraction procedure over the past 3 years. As part of a medical study to determine the effectiveness of a new technique for abdominal surgery, patients undergo the surgery with the new technique or with a traditional technique. The recovery time from surgery is then compared for the two different techniques. The general manager of a baseball team determines the on-base percentage (OBP) for his players over the past two seasons. A dietitian examined the effectiveness of a weight-loss program by randomly…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
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
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
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
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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