EBK BASIC BUSINESS STATISTICS
14th Edition
ISBN: 9780134685168
Author: STEPHAN
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 16, Problem 8PS
a.
To determine
Plot the time series.
b.
To determine
Fit a three-year moving average to the data and plot the results.
c.
To determine
Determine and plot the exponentially smoothed series when the smoothing coefficient is 0.50.
d.
To determine
Determine the exponential smoothed forecast for the year 2017.
e.
To determine
Determine and plot the exponentially smoothed series when the smoothing coefficient is 0.25. Also, forecast the exponential smoothed value for the year 2017.
f.
To determine
Compare the results of part (d) and part (e).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Prepare a time-series plot of the data, and visually inspect that plot to determine the characteristics you see in this series.
Use an exponential smoothing model to develop a forecast of sales for the next 12 months, and explain why you selected that model. Plot the actual and forecast values. Determine the MAPE for your model during the historical period.
An economist wants to compare the economic growth rate (%) within 50 kilometers and 100 kilometers to cities in a country. He collected 6 cities of the country, and calculated the growth rates with 50km and 100km as shown in the following table. Choose an appropriate test to validate that regions within 100km have higher economic growth rate than the regions within 50km to cities. You can make certain assumptions, but need to write to indicate your assumption. Show calculations by hand.
An electronics company had sales of
$25,000,000 in the year just completed. Sales
are expected to decline by 3% per year for the
next three years un�l new drugs, now under
development, receive regulatory approval. Then
sales should grow at 7% per year for the next
four years. What are the expected sales for the
final year of the seven-year period? [
Chapter 16 Solutions
EBK BASIC BUSINESS STATISTICS
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
- E-Tech Financial indexed fund was tumbling by 10.5% (per annum) such that: where A0 is the (unknown) initially invested amount and t is the time of investment in years. Anticipating the falling trend to last much longer, a skeptical investor decides to withdraw completely should the initial investment drop by a third. Determine how long this investor should wait before implementing his investment plan? (Round to the nearest month) Please dont provide answer in image format thank youarrow_forward21:40 ll LTE A brainmass.com Sign in Join Forecast E Add The Mayfair Department Store in Davenport, lowa, is trying to determine the amount of sales lost while it was shut down during July and August because of damage caused by the Mississippi River flood. Sales data for January through June follow. Month Sales ($1000s) January 185.72 February 167.84 March 205.11 April 210.36 May 255.57 June 261.19 a) Use exponential smoothing with Alpha = 0.4, to develop a forecast for July and August. (Hint: Use the forecast for July as the actual sales in July in developing the August forecast.) Comment on the use of exponential smoothing for forecasts more than one period into the future. We use cookies to ensure that we give you the best experience on our website. By continuing to use the site, you consent to the use of cookies. Please review our Privacy Policy OKarrow_forwardFind the MSE in part (b) please.arrow_forward
- 11) The following data are US exports to Mexico. Complete the missing values. YOU WILL NEED TO USE THE REGRESSION RESULTS BELOW TO HELP COMPLETE THE TABLE ABOVE. a) Fill in the table. b) Note that the Adjusted Seasonal Index for March is 112.7. What does this number mean? To estimate the Trend, a regression of the Seasonally Adjusted Series on a trend yielded the following results. c) What is your forecast of US Exports to Mexico for March 2005 (which would be the 50th observation)?arrow_forwardFind out the next month after april income by using the forecasting method of the moving average methodarrow_forwardAirodyne Wind, Inc., has wind tunnels that can operate vertically or horizontally for evaluating the effects of air flow on a component's PCB response and reliability. The company expects to build a new tunnel that will be outfitted with multiple sensor ports. For the estimates below, calculate the equivalent annual cost of the project. First Cost Replacement Cost, Year 2 AOC per Year Salvage Value Life, Years Interest Rate The equivalent annual cost of the project is $ $-250,000 $-330,000 $-940,000 $280,000 5 11%arrow_forward
- The table below reports the annual stock price in September for Apple from 2005 to 2014. Develop a simple index for the change in earning per share over the period. Use 2005 as the base period. percentages (e.g. 131.32 instead of 1.31)) (Indexes should be rounded to 2 decimal places and be in Year Earnings Per Share ($) Simple Index 2005 4.32 2006 4.14 2007 4.86 2008 5.94 2009 6.76 2010 10.08 2011 16.51 2012 23.65 2013 26.21 2014 29.86 Click here for the Excel Data File, Data file should open in a new browswer window. Select "File" then "Save As" to download the file to your computer and be able to use it in Excel. a. By what percent have stock prices changed from 2005 to 2009? b. By what percent have stock prices changed from 2005 to 2014? c. By what percent have stock prices changed from 2009 to 2014?arrow_forwardThe demand for a product for the last six years has been 15, 15, 17, 18, 20, and 19. The manager wants to predict the demand for this time series using the following simple linear trend equation: trt = 12 + 2t. What are the forecast errors for the 5th and 6th years?arrow_forwardThe following table reports the percentage of stocks in a portfolio for nine quarters: a. Construct a time series plot. What type of pattern exists in the data?b. Use trial and error to find a value of the exponential smoothing coefficient a thatresults in a relatively small MSE.c. Using the exponential smoothing model you developed in part b, what is the forecastof the percentage of stocks in a typical portfolio for the second quarter of year 3?arrow_forward
- Describe the presence of any seasonality, cyclicity, or trend in the below series. retal 500 450 400 350 300 2010 hetertarbeit. 2011 2012 Time 2013 2014 2015arrow_forwardIn 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_forwardFor the Texas Shipping Company, the monthly percentages of all shipments received on time over the past 12 months are 82, 86, 87, 89, 84, 85, 84, 86, 75, 95, 90, and 92. a. Construct a time series plot (you can include it in the work file question at the end, not here). Identify what type of pattern, if any, exists in the data? Compare the three-month moving average forecast with an exponential smoothing forecast for alpha= 0.25 and answer the following: b. MSE for 3-month moving average method c. MSE for exponential-smoothing method : d. Which method should be preferred? Answer "3-month MA" or "Exponential Smoothing": e. What is the forecast for next month using the preferred method?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY