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
Videos
Question
Chapter 16, Problem 4PS
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).
g.
To determine
Conclude about the desktop/laptop use by American users.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Find the MSE in part (b) please.
Please answer asap I really need help
arget's annual revenue data from 2005 to 2021 are available for download.
Make an Excel graph of the annual data, and fit three trends (linear, quadratic, and exponential) to the time series. Copy and paste the graph in the space below or attach the file.
State the three trendline equations from part a and their R2 values.
Which trend model do you think is the best one to use to forecast annual revenue? Choose only one model and explain the reasons for your choice.
Use the model you chose in part c to forecast the annual revenue for 2022.
Annual Operating Income
Year
t
(Millions of US $)
2005
1
46839
2006
2
52620
2007
3
59490
2008
4
63367
2009
5
64948
2010
6
65357
2011
7
67390
2012
8
69865
2013
9
73301
2014
10
71279
2015
11
72618
2016
12
73785
2017
13
70271
2018
14
72714
2019
15
75356
2020
16
78112
2021
17
93561
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
- Enter 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_forwardEstimate the age of a newly discovered fossil for which the ratio of carbon-14 to carbon-12 is R=1/1014.arrow_forwardWith what kind of exponential model would half-life be associated? What role does half-life play in these models?arrow_forward
- Jerome invests $18,000 at age 17. He hopes the investments will be worth $30,000 when he turns 26. If the interest compounds continuously, approximately what rate of growth will he need to achieve his goal? Is that a reasonable expectation?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_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_forward
- The following table gives the approximate increase in the average price of a movie ticket every two years since 1990. If the price in 2004 is $6.99, what was the price of a ticket in 1990? Do not include a dollar sign in your answer. Starting Year 2-Year Change 1990 0.50 1992 -0.30 1994 0.25 1996 1.20 1998 0.30 2000 0.40 2002 0.2arrow_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_forwardChina had a population in 2008 of about 1.14 billion people. The populaton is growing by about 1.34% each year. If this trend continues, when will China's population reach 1.2 billion.arrow_forward
- The 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_forwardPlease answer asap I really need helparrow_forwardIn retail, a store manager uses time series models to understand shopping trends. Review the scatter plot of the store’s sales from 2010 through 2021 to answer the questions. See attached as image. Here is the data for Fiscal Year and Sales: Fiscal Year Sales 2010 $260,123.00 2011 $256,853.00 2012 $274,366.00 2013 $290,525.00 2014 $322,318.00 2015 $380,921.00 2016 $541,925.00 2017 $909,050.00 2018 $1,817,521.00 2019 $3,206,564.00 2020 $4,921,005.00 2021 $5,686,338.00 Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components? The model can be additive or multiplicative. When do you use each? Review the scatter plot of the exponential trend of the time series data. Do you observe a trend? If so, what type of trend do you observe? What predictions might you make about the store’s annual sales over the next few years?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
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