Statistics for Business and Economics (13th Edition)
13th Edition
ISBN: 9780134506593
Author: James T. McClave, P. George Benson, Terry Sincich
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
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 solution
Students have asked these similar questions
State at least one type of conclusion that could be made from the data provided for the KPI. Suggest one other data source that would provide more information to make data-driven decisions. Explain what information that source would supply.
(The blue one is mine) or pretty much what can be said of the clustered bar chart
The November 24, 2001, issue of The Economist published economic data for 15
industrialized nations. Included were the percent changes in gross domestic product (GDP),
industrial production (IP), consumer prices (CP), and producer prices (PP) from Fall 2000
to Fall 2001, and the unemployment rate in Fall 2001 (UNEMP). An economist wants to
construct a model to predict GDP from the other variables. A fit of the model
GDP = , + P,IP + 0,UNEMP + f,CP + P,PP + €
yields the following output:
The regression equation is
GDP = 1.19 + 0.17 IP + 0.18 UNEMP + 0.18 CP – 0.18 PP
Predictor
Coef SE Coef
тР
Constant
1.18957 0.42180 2.82 0.018
IP
0.17326 0.041962 4.13 0.002
UNEMP
0.17918 0.045895 3.90 0.003
CP
0.17591 0.11365 1.55 0.153
PP
-0.18393 0.068808 -2.67 0.023
Predict the percent change in GDP for a country with IP = 0.5, UNEMP = 5.7, CP =
3.0, and PP = 4.1.
a.
b.
If two countries differ in unemployment rate by 1%, by how much would you predict
their percent changes in GDP to differ, other…
If a forecaster wanted to choose a forecasting model that avoided having a large forecasting error in any given
period, which error metric should they use when evaluating their forecasting options?
CFE
O AFE
MAD
MAPE
O MSE
Chapter 14 Solutions
Statistics for Business and Economics (13th Edition)
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
- please answer all parts of the question within 30 minutes with detailed explanation. Make sure calculation form part of the answer and are in details for better understanding. If calculations are not shown or are poorly done i will surely give negative ratings.arrow_forwardBriefly describe the principles behind the use of EXTRAPOLATION (TREND) methods of forecasting future water use. Outline the advantages and disadvantages of using this type of methodarrow_forwardPart II- COMPUTING: Answer the following as indicated. Round off your answer to three decimal places. Draw the control charts using R or MS Excel. 12. A company is monitoring the percentage of line items that are shipped correctly from a major supplier. They have collected data for the past 25 weeks. Each week the number of line items shipped from the supplier is determined as well as the number of line items shipped correctly. The data for the past 25 weeks are shown in the table. Construct and interpret the p chart based on average sample size. Show details of the calculations of the control limits and the center line. Week 1 23456 2 7 8 9 PHDSH5 10 11 12 13 14 15 Number Shipped 91 81 47 99 120 42 84 94 69 65 121 125 51 108 86 Number Shipped Correctly 79 81 39 98 120 39 76 88 59 63 120 103 49 107 84 Week 16 17 18 19 20 21 22 23 24 25 Number Shipped 131 122 22 69 65 97 109 123 94 82 Number Shipped Correctly 127 107 18 57 64 92 108 108 92 79arrow_forward
- Answer 4 5 6 7arrow_forwardPlease help me answer this activityarrow_forwardPlot the sales revenue figures and appropriate trend line on a graph and identify from this the choice of model for working out the seasonal component. Using the appropriate seasonal model, complete the calculations that are required to produce the required forecasts for quarters 1, 2, 3 and 4 of 2021. On the basis of your analysis explain the recommendation that you would make to ALAW Ltd regarding its future plans.arrow_forward
- en 000 Pursuing an MBA is a major personal investment. Tuition and expenses associated with business school programs are costly, but the high costs come with hopes of career advancement and high salaries. A prospective MBA student would like to examine the factors that impact starting salary upon graduation and decides to develop a model that uses program per-year tuition as a predictor of starting salary. Data were collected for 37 full-time MBA programs offered at private universities. The data are stored in the accompanying table. Complete parts (a) through (e) below. E Click the icon to view the data on program per-year tuition and mean starting salary. a. Construct a scatter plot. Choose the correct graph below. OA. O B. В. OC. OD. O D. Q 80,000- 80,000- TOLL 200,000- 200,000- 0- 0+ 04 200,000 Starting Salary (S) 80,000 200,000 Starting Salary (S) 80,000 Tuition ($) Tuition ($) b. Assuming a linear relationship, use the least-squares method to determine the regression coefficients…arrow_forwardTop of Form a)Plot the monthly sales data. b)Forecast January sales using each of the following: i)Naive method. ii)A 3-month moving average. iii)A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. iv)Exponential smoothing using an α = .3 and a September forecast of 18.arrow_forwardBriefly explain how the organization forecast sales for its products.a. Using historical sales data, choose a quantitative technique to forecast sales for thatorganisation for the next sales period. Comment on the appropriateness of thetechnique used.b. Describe three strategies that the organization uses to compete and comment on theappropriateness of these strategiesarrow_forward
- The data file, data2.xls (Excel format), has been uploaded to this module. Click, download, and open this file. It contains: Table 1. Violent victimization, by type of crime, 2016, and 2017 Appendix table 3. Standard errors for table 1: Violent victimization, by type of crime, 2016, and 2017 From the estimation of the number of Rape/sexual assault (298,410) in 2016 at 95% CI. what is the lower limit?arrow_forwardLovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store manager estimates a probable six- week lag between fertilizer sales and mower sales. The pertinent data are: Fertilizer Number of Fertilizer Number of Sales Mowers Sold Sales Mowers Sold Period (tons) (six-week lag) Period (tons) (six-week lag) 1 1.6 10 8. 1.3 7 1.3 8 1.7 10 3 1.8 11 10 1.2 6. 4 2.0 12 1.9 11 2.2 12 12 1.4 1.6 9. 13 1.7 10 7 1.5 14 1.6 a. Determine the correlation between the two variables. Does it appear that a relationship exists between these variables will yield good predictions? (Do not round intermediate calculations and round your answer to 3 decimal places.) it appears that a positive v relationship exists between these variables. b. Obtain a linear regression line for the data. (Negative values should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 3 decimal places.) Y = O Xi + c. Predict expected lawn mower sales…arrow_forwardtion 2 of 15 Last summer, the Smith family drove through seven different states and visited various popular landmarks. The prices of gasoline in dollars per gallon varied from state to state and are listed below. $2.34, $2.75, $2.48, $3.58, $2.87, $2.53, $3.31 Click to download the data in your preferred format. CrunchIt! CSV Excel JMP Mac Text Minitab PC Text R SPSS TI Calc Calculate the range of the price of gas. Give your solution to the nearest cent. range: dollars per gallon DELL & 4. 7 8.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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
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
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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