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?
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.
You collect data of average annual returns for Amazon Stock and Microsoft Stock and make the following table: (This data can be copied into Excel.)
Year
Amazon Return
Microsoft Return
2013
0.5896
0.1221
2014
-0.2218
0.2416
2015
1.1778
0.1944
2016
0.1095
0.1200
2017
0.5596
0.3766
2018
0.2843
0.1874
2019
0.3216
0.5526
You use this data to answer the research question: are true population Amazon Returns greater than true population Microsoft Returns?
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_forwardUnited 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?arrow_forward
- Find the MSE in part (b) please.arrow_forwardConsider 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_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
- A stock has monthly returns of 9%, 22%, 15%, and 28%. What is the stock's geometric average return?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_forwardPaint lifetime: A paint company collected data on the lifetime (in years) of its paint in eleven United States cities. The data are in the following table. Average annual Precipitation (inches) 48.6 43.8 29.3 26.4 City Atlanta, GA Boston, MA Kansas City, KS Minneapolis, MN Dallas, TX Denver, CO Miami, FL Phoenix, AZ San Francisco, CA Seattle, WA Send data to Excel Paint Lifetime Part 1 of 2 11.5 11.7 12.3 10.5 11.2 15.2 8.7 11.1 16.7 Average January Temperature 41.9 29.6 28.4 11.2 45.0 29.5 67.1 52.3 48.5 40.6 Average July Temperature 78.6 73.5 80.9 73.1 86,3 73.3 82.4 92.3 62.2 65.3 34.2 15.3 57.5 7.1 19.7 38.9 In Cheyenne, Wyoming, the average January temperature is 26.1, the average July temperature is 68.9, and the average annual precipitation is 13.3. Construct a 95% confidence interval for the paint lifetime. Round your answers to at least two decimal places.arrow_forward
- John Kittle, an independent insurance agent, uses a five-year moving average to forecast the number of claims made in a single year for one of the large insurance companies he sells for. He has just discovered that a clerk in his employ incorrectly entered the number of claims made four years ago as 1,400 when it should have been 1,200.a. What adjustment should Mr. Kittle make in next year’s forecast to take into account the corrected value of the number of claims four years ago?b. Suppose that Mr. Kittle used simple exponential smoothing with a = .2instead of moving averages to determine his forecast. What adjustment is now required in next year’s forecast? (Note that you do not need to know the value of the forecast for next year in order to solve this problem.)arrow_forwardTourism is extremely important to the economy of Florida. Hotel occupancy is an often-reported measure of visitor volume and visitor activity (Orlando Sentinel, May 19, 2018). Hotel occupancy data for February in two consecutive years are as follows. Current Year 1,512 1,800 Let P₁= population proportion of rooms occupied for current year P2 = population proportion of rooms occupied for previous year Occupied Rooms Total Rooms 1,458 1,800 a. Formulate the hypothesis test that can be used to determine whether there has been an increase in the proportion of rooms occupied over the one-year period. Previous Year Ho: P1 P2 - Select your answer - Ha P₁ P2 - Select your answer b. What is the estimated proportion of hotel rooms occupied each year (to 2 decimals)? Current year Previous Year c. Conduct a hypothesis test. What is the p-value (to 4 decimals)? Use Table 1 from Appendix B. p-value = Using a 0.05 level of significance, what is your conclusion? We-Select your answer that there has…arrow_forwardA 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_forward
arrow_back_ios
SEE MORE QUESTIONS
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