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
Videos
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 solution
Students 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?
Top of Form
a)Plot the monthly sales data.
b)Forecast January sales using each of the following:
i)Naive method.
ii)A 3-month moving average.
iii)A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months.
iv)Exponential smoothing using an α = .3 and a September forecast of 18.
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?
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_forwardvt 14. Calculate trend values by the method of Least Square from the data given below and estimate the sales for 2007. Year 2000 2001 2002 2003 2004 Sales of GA. (Rs. lakhs) 70 74 80 86 90 上arrow_forward
- Consider the following demand levels for electricity (in Megawatts) for Rundu from 1988 to 1991. Quarter 1 Quarter 2 Quarter 3 Quarter 4 1988 21 C. 42 60 12 1989 1990 1991 35 54 91 14 39 82 136 28 78 114 160 40 a. Make a time series plot of the data and comment. b. Find the least squares trend line for demand. Find the seasonal index for each quarter. d. Estimate the demand for electricity for quarter 4 1992. De-seasonalise the series and comment on the trend/cyclical movements in the dataarrow_forwardWhich of the following time-series forecasting methods would not be used to forecast a time series that exhibits a linear trend with no seasonal or cyclical patterns? a. Dummy variable regression b. Linear trend regression c. Multiplicative Winter's method d. Holt Winter's double exponential smoothing e. Both A and Darrow_forwarda)Given the data 63, 64, 66, 67, 67, 69, 71, 72 are the units of actual sales of TV in the last eight periods. Find the forecast for the ninth period using simple exponential smoothing.Use α = 0.3 and initial forecast using simple average of last eight months. b)The sales of a company (in million dollars) for each year are shown in the table below. Find the linear sales trend line.x (year) 2005 2006 2007 2008 2009y (sales) 12 19 29 37 45 plz i need these answers within 4 hrs i need to submit them do the questions manually without using excel or minitabarrow_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_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_forwardConsider 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_forward
- A mutual fund achieved the following rates of growth over an 11-month period: 3% 2% 7% 8% 2% 4% 3% 7.5% 7.2% 2.7% 2.09% Determine the 5th decile from the data. a. 7% b. 4% c. 3% d. 2%arrow_forwardam. 13.arrow_forwardConsider the following time series. Quarter Year 1 Year 2 Year 3 1 70 67 61 2 50 42 52 3 59 61 54 4 79 82 73 (a) Construct a time series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data.The time series plot shows a horizontal pattern with no seasonal pattern present. The time series plot shows a trend pattern, but there is also a seasonal pattern in the data.The time series plot shows a trend pattern with no seasonal pattern present. (b) Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. x1 = 1 if quarter 1, 0 otherwise; x2 = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise. ŷ = (c) Compute the quarterly forecasts for the next year. quarter 1 forecast quarter 2 forecast quarter 3 forecast quarter 4 forecastarrow_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 Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
Trigonometry (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