Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 8, Problem 15P
(a)
To determine
Draw the time-series plot for the commodity futures index for 10-week period and identify the pattern.
(b)
To determine
Calculate an exponential smoothing coefficient α that results in smaller MSE using trial or error method.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The 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?
For 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?
Consider the following data:
Year
Deaths
2000
17,050
Number of Deaths in the U.S. by Drug Overdose
2003 2004
2002
2005
14,311 13,352 17,771 14,516
2001
17,510
2006
2007
11,153 18,656
2008
16,643
Step 1 of 2: Find the two-period moving average for the year 2005. If necessary, round your answer to
one decimal place.
Chapter 8 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 8 - Consider the following time series data:
Using...Ch. 8 - Refer to the time series data in Problem 1. Using...Ch. 8 - Problems 1 and 2 used different forecasting...Ch. 8 - Consider the following time series data:
Compute...Ch. 8 - Consider the following time series...Ch. 8 - Consider the following time series...Ch. 8 - Refer to the gasoline sales time series data in...Ch. 8 - Prob. 8PCh. 8 - Prob. 9PCh. 8 - Prob. 10P
Ch. 8 - For the Hawkins Company, the monthly percentages...Ch. 8 - Corporate triple A bond interest rates for 12...Ch. 8 - The values of Alabama building contracts (in...Ch. 8 - The following time series shows the sales of a...Ch. 8 - Prob. 15PCh. 8 - The following table reports the percentage of...Ch. 8 - Consider the following time series: a. Construct a...Ch. 8 - Consider the following time series:
Construct a...Ch. 8 - Because of high tuition costs at state and private...Ch. 8 - The Seneca Children’s Fund (SCF) is a local...Ch. 8 - The president of a small manufacturing firm is...Ch. 8 - Consider the following time series: a. Construct a...Ch. 8 - Consider the following time series...Ch. 8 - The quarterly sales data (number of copies sold)...Ch. 8 - Prob. 25PCh. 8 - South Shore Construction builds permanent docks...Ch. 8 - Hogs & Dawgs is an ice cream parlor on the border...Ch. 8 - Donna Nickles manages a gasoline station on the...Ch. 8 - The Vintage Restaurant, on Captiva Island near...
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_forwardWhat does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardthe data contained in the datafile named crudecost shows the U.S. refiner acquisition cost of crude oil in dollars per barrel (energy information administration website,February 3, 2014).a. construct a time series plot. What type of pattern exists in the data?arrow_forward
- Consider the following time series: Quarter Year 1 Year 2 Year 3 80 74 65 69 61 51 48 50 43 68 71 82 a. Construct a time-series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? b. Use multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtrl = 1 if quarter 1,0 else; Qtr2 = 1 if quarter 2,0 else; Qtr3 = 1 if quarter 3,0 else. c. Compute the quarterly forecasts for next year.arrow_forwardListed below are the numbers of deaths resulting from motor vehicle crashes. Let x represent the year, with 1975 coded as x = 1, 1980 coded as x = 6, 1985 coded as x = 11, and so on. Construct a scatterplot and identify the mathematical model that best fits the given data. Use the best model to find the projected number of deaths for the year 2028. x (year) 1975 1980 1985 1990 1995 2000 2005 2010 D y (deaths) 44,533 51,122 43,809 44,590 41,798 41,960 43,436 32,697 (...) Choose the correct graph below. O A. O B. O C. D. 52000- 52000- 52000- 52000- DDDD 00 X X X X 32000+ 32000 32000+ 32000+ 0 40 0 40 0 40 0 40 What is the equation of the best model? Select the correct choice below and fill in the answer boxes to complete your choice. Enter only nonzero values. (Type integers or decimals rounded to three decimal places as needed.) O A. y= X B. y = + In x O C. y = + O D. X y=² O E. y = x² + X + Use the best model to find the projected number of such deaths for the year 2028. The projected…arrow_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
- Consider the following time series. 2 3 112 Month 1 4 94 Value 118 100 96 92 86 a. Construct a time series plot. What type of pattern exists in the data? a. Use simple linear regression analysis to find the parameters for the best fit line. a. What is the forecast fort = 8 the answer needed to be solved in MS Excel. %3Darrow_forwardam. 13.arrow_forwardb. Add in the table provided in the spreadsheet a dummy variable that takes the value of 1in the fourth quarter of each year and show the table with all the data c. Using the data provided in the spreadsheet including the dummy variable you have created for the fourth quarter of each year run a regression with dependent variable the CBC house price index and independent variables the other three variables (Nominal GDP, Number of Households, and the dummy variable for the fourth quarter). Present the typical regression results output for this regression produced by Excel. d. Explain what the particular numbers for the following statistics that you presented in b) mean (no points will be given if you write general definitions without interpreting the particular numbers that you have presented): a. R-squared b. The t-statistics of the three independent variables c. The coefficients of the three independent variables e. Discuss if the signs that you get for the coefficients of each of the…arrow_forward
- Describe the three major categories of data (time-series, cross-sectional, and panel).arrow_forwardLook at the four plots in Figure 14.2—the US unemployment rate, thedollar-pound exchange rate, the logarithm of the index of industrial production, and the percentage change in stock prices. Which of these seriesappears to be non-stationary? Which of them appears to resemble a randomwalk?arrow_forwardUse R programming or excel to answer the following. Visualize your answers. Consider the following quarterly time series: Quarter Year 1 Year 2 Year 3 1 923 1112 1243 2 1056 1156 1301 3 1124 1124 1254 4 992 1078 1198 Construct a time series plot. What type of pattern exists in the data? Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Compute the quarterly forecasts for next year based on the model developed in part b.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
- Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage LearningTrigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
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