Statistics Sta 2122 Second Custom Edition For Florida International University
2nd Edition
ISBN: 9781323441466
Author: James T. Mcclave And Terry Sincich
Publisher: Pearson Education, Inc.
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 14.6, Problem 14.34ACB
S&P 500 Stock Index. Refer to your exponential smoothing forecasts of the quarterly S&P 500 for 2015, Exercise 14.29 (p. 14-24).
a. Calculate MAD, MAPE, and RMSE for the forecasts with w = .7. 71.35; 3.45; 76.2
b. Calculate MAD, MAPE, and RMSE for the forecasts with w = .3. 191.5; 9.3; 193.3
c Compare MAD, MAPE, and RMSE for the two simple exponential smoothing forecast models. Which model leads to more accurate forecasts?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.
a. Compute for a 3 month moving average forecast.
b. Compute for the exponential smoothing forecast for a=0.2.
c. Which provides the better forecast using MSE as the measure of model accuracy?
d. What is the forecast for next month?
Consider the following data:
Monthly Profit of a Gym
Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12
Profit ($) 6,350
6,103
5,424
5,237
5,380
6,158
7,819
6,351
6,057
Step 4 of 5 : What are the MAD, MSE and MAPE scores for the exponentially smoothed forecast? Round any intermediate calculations, if necessary, to no less than six decimal places, and round your final answer to one decimal place.
U.S. Civilian Labor Force (thousands)Year Labor Force Year Labor Force2007 173,966 2012 175,6762008 174,703 2013 175,1992009 173,159 2014 176,2862010 173,698 2015 178,0052011 174,043 2016 179,688
Make forecasts using the following fitted trend models for years 2017-2019.
t Linear Quadratic Exponential 111213
Chapter 14 Solutions
Statistics Sta 2122 Second Custom Edition For Florida International University
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
- Cable TV The following table shows the number C. in millions, of basic subscribers to cable TV in the indicated year These data are from the Statistical Abstract of the United States. Year 1975 1980 1985 1990 1995 2000 C 9.8 17.5 35.4 50.5 60.6 60.6 a. Use regression to find a logistic model for these data. b. By what annual percentage would you expect the number of cable subscribers to grow in the absence of limiting factors? c. The estimated number of subscribers in 2005 was 65.3million. What light does this shed on the model you found in part a?arrow_forwardWhat does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardWorld Population The following table shows world population N, in billions, in the given year. Year 1950 1960 1970 1980 1990 2000 2010 N 2.56 3.04 3.71 4.45 5.29 6.09 6.85 a. Use regression to find a logistic model for world population. b. What r value do these data yield for humans on planet Earth? c. According to the logistic model using these data, what is the carrying capacity of planet Earth for humans? d. According to this model, when will world population reach 90 of carrying capacity? Round to the nearest year. Note: This represents a rather naive analysis of world population.arrow_forward
- Use this data for the exercises that follow: In 2013, there were roughly 317 million citizens in the United States, and about 40 million were elderly (aged 65 and over).[34] 60. It is predicted that by 2030, one in five U.S. citizens will be elderly. How much greater will the chances of meeting an elderly person be at that time? What policy changes do you foresee if these statistics hold true?arrow_forwardthe table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.arrow_forwardFollowing table presents the quarterly market share of Tasty Food Company; Quarter Firm’s Actual Market Share 1 20 2 22 3 23 4 24 5 18 6 23 7 19 8 17 9 22 10 23 11 18 12 23 13 ? Forecast the company’s market share for the 13th quarter by exponential smoothing with w=0.3. Calculate the Root-Mean Square Error (RMSE) for the exponential forecast using w=0.3. If the RMSE for the exponential forecast using w=0.5 is 2.91 then compare which forecasts is better and why?arrow_forward
- A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were: DAY 1 - 37 2 - 40 3 - 45 4 - 44 5 - 48 6 - 49 7 - 47 8 - 46 9 - 50 10 - 54 11 - 52 12 - 53 13 - 57 14 - 49 15 - 53 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.) This question was previously answered with 16.787. The McGraw-Hill website where you enter this answer says it's not correct. Can you please assist me??arrow_forwardConsider the following data:Monthly Profit of a Gym: Month & Profit: Jan-12: 5700 Feb-12: 5453 March-12: 5034 April-12: 4717 May-12: 5185 June-12: 5638 July-12: 6519 Aug-12: 6182 Sept-12: 5913 What are the MAD, MSE and MAPE scores for the three-period weighted moving average forecast? Round any intermediate calculations, if necessary, to no less than six decimal places, and round your final answer to one decimal place. MAD: MSE: MAPE as %: link to excel sheet for forumla to assist: http://www.livebinders.com/play/play?id=2368073arrow_forwardThe sales records of a major auto manufacturer over the past years from 2005 to 2019 are shown below. Number of Cars Sold Year (In thousands of Units) 2005 195 2006 200 2007 250 2008 270 2009 320 2010 380 2011 440 2012 460 2013 500 2014 500 2015 550 2016 570 2017 600 2018 650 2019 700 Develop moving average with k=4 and compute its MSE Develop exponential model with α = 0.4 and compute its MSE Develop a linear trend model and compute its MSE Based on the MSE computed fore ach model , which model fits well to the data Based on the answer of question (4) forecast the number of cars sold for year 2020.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningAlgebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
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