EBK BASIC BUSINESS STATISTICS
14th Edition
ISBN: 9780134685168
Author: STEPHAN
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 16, Problem 46PS
a.
To determine
Create a time series plot.
b.
To determine
Develop an exponential trend forecasting equation with monthly components.
c.
To determine
Find the fitted value in December 2016.
d.
To determine
Predict the values for the last four months of 2016.
e.
To determine
Interpret the monthly compound growth rate.
f.
To determine
Interpret the July multiplier.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
21: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
OK
c. Predict sales in 15 years.
Please answer asap I really need help
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
- What do the Forecast for each year add up to?arrow_forwardSiena Ltd attempts to find the trend of its sales over the past five years. Siena is considering which model that best represent the trends of its sales. Following are the result of linear and exponential model trend analysis: a. Calculate the MSE and MAD for the linear trend model b. Calculate the MSE and MAD for the exponential trend model c. Which model that performs betterarrow_forwardStocks in a certain industry depreciated by 5.4% in the first 8 months of 1993. Assuming that this trend were to continue, how much (in dollars) would a $30,000 investment be worth in 8 years? [HINT: Eight years corresponds to 12 eight-month periods.] (Round your answer to the nearest cent.) $15400 Xarrow_forward
- Find the MSE in part (b) please.arrow_forwardNo need to answer everything! Just plot the actual visitors and the forecasts. Compare the accuracy of the forecasts in the 1985 to 1990 period with those subsequent to that period.arrow_forwardThe following data report total, monthly U.S. gasoline sales in millions of dollars from January 2017 to December 2018. (To find the data, go to the site https://www.census.gov/retail/index.html#mrts, find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts.”) d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.)arrow_forward
- United Dairies, Inc., supplies milk to several independent grocers throughout DadeC ounty, Florida. Managers at United Dairies want to develop a forecast of the number ofhalf gallons of milk sold per week. Sales data for the past 12 weeks are: a. Construct a time series plot. What type of pattern exists in the data?b. Use exponential smoothing with a 5 0.4 to develop a forecast of demand for week 13.What is the resulting MSE?arrow_forwardshow the solution if necessaryarrow_forwardUse regression analysis to estimate a linear trend line for annual sales.arrow_forward
- Actual demand for the past 16 periods is shown below. Prepare a trend adjusted exponential smoothing forecast using the following parameters: a = 4, B =.2, TAFS = 729.33, and T5 = 2.33. (Round all your answers to two decimal points.) %3D Period Actual TAF 1. 721 2. 724 3 725 4. 728 5. 732 6. 739 7. 738 8 745 751 10 756 11 754 12 760 13 762 14 765 15 765 16 767 17arrow_forwardCryptocurrencies have rapidly become an important alternative to traditional currencies for many types of transactions. Etherium, one of the most prominent cryptocurrencies, has rapidly appreciated in value. Daily Etherium trading information for the first 332 days of 2021. It includes the following variables: Date Day – Day of the year, used to assess trend over time Volume (US $) – Daily trading volume Opening Price (US $) – Opening price for daily trading Price Change (US $) – Daily change in price from opening to close 1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the alternative hypothesis that Volume has a linear relationship to Price Change. Specifically, what are the test statistic and the p-value for that test statistic? For α = .05, what do you conclude about the relationship between the variables? (reminder: the T.DIST.2T function requires input of a positive test statistic)arrow_forwardPArt C Darrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY