EBK BASIC BUSINESS STATISTICS
14th Edition
ISBN: 9780134685168
Author: STEPHAN
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 16, Problem 45PS
Are gasoline prices higher during the height of the summer vacation season than at other times? The file GasPrices contains the mean monthly prices
a. Construct a time-series plot.
b. Develop an exponential trend forecasting equation with monthly components.
c. Interpret the monthly compound growth rate.
d. Interpret the monthly multipliers.
e. Write a short summary of your findings.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Please answer asap I really need help
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
Siena 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 better
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
- If an asset declines in value from $5000 to $3500 over nine years, what is the mean annual growth rate in the asset's value over these nine years?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_forwardWhat do the Forecast for each year add up to?arrow_forward
- The lifetime of a camera costing $200 is exponentially distributed with mean 4 years. The manufacturer agrees to pay a full refund to a buyer if the camera fails during the first year following its purchase, and a one-half refund if it fails during the second year. If the manufacturer sells 100 cameras, how much should it expect to pay in refunds? The manufacturer should expect to pay $6817.51 in refunds. (Round to the nearest cent as needed.)arrow_forwardAnnual revenue for Corning Supplies grew by 5.5% in 2010, 1.1% in 2011, -3.5% in 2012, -1.1% in 2013,and 1.8% in 2014. What is the mean growth annual rate over this period?arrow_forwardThe following table gives the average monthly exchange rate between the U.S. dollar and the euro for 2009. It shows that 1 euro was equivalent to 1.289 U.S. dollars in January 2009. Develop a trend line that could be used to predict the exchange rate for 2010. Use this model to predict the exchange rate for January 2010 and February 2010. MONTH ______________________ EXCHANGE RATE January ....................................... 1.289 February ...................................... 1.324 March ......................................... 1.321 April .......................................... 1.317 May ........................................... 1.280 June ........................................... 1.254 July ........................................... 1.230 August ....................................... 1.240 September ................................... 1.287 October ..................................... 1.298 November .................................. 1.283 December…arrow_forward
- c. Predict sales in 15 years.arrow_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_forwardshow the solution if necessaryarrow_forward
- In the last three years, there have been changes of 55%, 3% and 2% in the production amount of a good, respectively. What is the geometric mean of the annual rate of change?arrow_forwardSuppose admission to a movie cost $7.50 in 2005. What was its price in 1979 dollars? Assume that all prices have risen at the same rate as the CPI. The price was about $ in 1979. (Round to the nearest cent.) Average Annual Consumer Price Index (CPI) (1982- 1984=100) Year CPI Year CPI Year CPI 1976 56.9 1989 124.0 2001 177.1 1977 60.6 1990 130.7 2002 179.9 2003 184.0 1978 65.2 1991 136.2 1992 1979 72.6 140.3 2004 188.9 1980 82.4 1993 144.5 2005 90.9 1994 148.2 2006 2007 1981 1982 96.5 1983 99.6 1984 103.9 1985 107.6 1995 152.4 1996 156.9 2008 1997 160.5 2009 1998 163.0 2010 1986 109.6 1999 166.6 2011 1987 113.6 2000 172.2 2012 1988 118.3 195.3 201.6 207.3 215.3 214.5 218.1 224.9 229.6arrow_forwardIf an asset declines in value from $5,000 to $2,600 over nine years, what is the mean annual growth rate in the asset's value over these nine years? Enter your answer as a percentage. If needed, round your answer to two decimal digits.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
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