Basic Business Statistics, Student Value Edition
14th Edition
ISBN: 9780134685113
Author: Mark L. Berenson, David M. Levine, David F. Stephan, Kathryn Szabat
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
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 solution
Students have asked these 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?
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
What do the Forecast for each year add up to?
Chapter 16 Solutions
Basic Business Statistics, Student Value Edition
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
- Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?arrow_forwardWith what kind of exponential model would half-life be associated? What role does half-life play in these models?arrow_forwardEnter the data from Table 2 into a graphing calculator and graph the ranking scatter plot. Determine whetherthe data from the table would likely represent a function that is linear, exponential, or logarithmic.arrow_forward
- Is carbon dating? Why does it work? Give an example in which carbon dating would be useful.arrow_forwardWhat might a scatterplot of data points look like if it were best described by a logarithmic model?arrow_forwardThe 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_forward
- 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 betterarrow_forwardUsing excel. 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. Construct a time series plot. What type of pattern exists in the data? b. Compare the three-month moving average approach with the exponential smoothing approach for α=\alpha =α= .2. Which provides more accurate forecasts using MSE as the measure of forecast accuracy? c. What is the forecast for next month?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_forward
- The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. LOADING... Click the icon to view the closing prices data. Question content area bottom Part 1 a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3. Complete the exponential smoothing forecast model for stock A. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast A 09/03/2010 09/07/2010 enter your response here 09/08/2010 enter your response here 09/09/2010 enter your response here 09/10/2010 enter your response here 09/13/2010 enter your response here 09/14/2010 enter your response here 09/15/2010 enter your response here 09/16/2010 enter your response here 09/17/2010 enter your response here…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_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
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