The data stored in Drink represent the amount of soft drink in a sample of 50 consecutively filled 2-liter bottles.
a. Construct a time-series plot for the amount of soft drink on the
b. What pattern, if, any, is present in these data?
c. If you had to make prediction about the amount of soft drink filled in the next bottle, what would you predict?
d. Based on the results of
Want to see the full answer?
Check out a sample textbook solutionChapter 2 Solutions
BASIC BUSINESS STAT LL W/MYLAB
- 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_forwardAfter its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s). a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales? b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. c) Forecast the sales from January to December of the year 2010. d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG Month 2001 2002 2003 2004 2005 2006 2007 2008 2009 January 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 February 114.3 177.8 203.2 254 317.5 457.2 406.4 444.5 533.4 March 101.6 177.8 228.6 266.7 368.3 457.2 431.8 495.3 635 April 152.4 203.2…arrow_forwardWhat is the ratio of the total jobs at risk in Transportation and Storage to those at riks in Retail? A) 4.68:7.79 B) 7.79:4.68 C) 52:41 D) 9:19 E) 30:27 Transcribed Image Text:Likelihood of industries becoming automated in the future Proportion of jobs and their risk of automation. Note: the graph shows a linear decrease in the proportion of jobs at risk of full automation. 60% 55% 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% Transportation and Storage Series Value Proportion of Jobs at Risk of Full Automation 52% Employment Share of Total Jobs Waste Management Transportation and 9% Manufacturing Retail Administration Finance and Insurance ch Other Electricity and Gas Transcribed Image Text:Likelihood of industries becoming automated in the future Proportion of jobs and their risk of automation. Note: the graph shows a linear decrease in the proportion of jobs at risk of full automation. 60% 55% 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% Waste Management Transportation and Retail…arrow_forward
- Consider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 90 89 86 91 90 91 88 86 91 93 90 88 a) Construct a time series plot in Excel. Label the axes and graph. c) Develop a smoothing model forecast with α = 0.35. Compute MSE and forecast for month 13 d) Which model is the better predictor? Why?arrow_forwardThe owner of Kat Motel wants to develop a time standard for the task of cleaning a cat cage. In a preliminary study, she observed one of her workers perform this task six times, with the following results: Observation 1 2 3 4 5 6 Time(Seconds) 99 87 90 81 93 90 _____ is the standard time for this task if the employee worked at a 150 PRF, and an allowance of 20 percent of job time is used. _____ is the normal time for this task if the employee worked at 150 PRF. _____ is the standard time for this task if the employee worked at a 150 PRF and an allowance of 10 percent of the workday is used.arrow_forwardJohn 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_forward
- Which of the following time series forecasting methods would not be used to forecast seasonal data?arrow_forwardThe following table shows Google's annual revenue (in billions of dollars) for 2009 to 2014.† Year Period (t) Revenue ($ billions) 2009 1 23.7 2010 2 29.3 2011 3 37.9 2012 4 50.2 2013 5 59.8 2014 6 66.7 (a)Construct a time series plot. -A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Period. The vertical axis ranges from 0 to 80 and is labeled: Revenue ($ billions). The points are plotted from left to right at regular increments of 1 period starting at period 1. Initially, the points are plotted in an upward, diagonal direction. However, after the third point, the points are plotted in a downward, diagonal direction that becomes steeper as period increases. The points are between 23 to 71 on the vertical axis. -A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Period. The vertical axis ranges…arrow_forwardStorrs Cycles has just started selling the new Cyclonemountain bike, with monthly sales as shown in the table. First,co-owner Bob Day wants to forecast by exponential smoothingby initially setting February’s forecast equal to January’s saleswith a = .1. Co-owner Sherry Snyder wants to use a three-periodmoving average. a) Is there a strong linear trend in sales over time?b) Fill in the table with what Bob and Sherry each forecast forMay and the earlier months, as relevant.c) Assume that May’s actual sales figure turns out to be 405.Complete the table’s columns and then calculate the meanabsolute deviation for both Bob’s and Sherry’s methods.d) Based on these calculations, which method seems moreaccurate?arrow_forward
- Demand for haircut at PogiPoints Barber Shop has increased steadily for the past few months as seen in the following time series data. Do the necessary computations and choose the best answer that would complete each statement. The demand forecast for Month 6 would be: * A. 565 haircuts B. 574 haircuts C. 578 haircuts D. 584 haircutsarrow_forwardConsider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 80 82 84 83 83 84 85 84 82 83 84 83 a) Construct a time series plot in Excel. Label the axes and graph. b) Develop a three month moving average forecast. Compute MSE and a forecast for month 13. c) Develop an exponential smoothing forecast with a = 0.35. Compute MSE and a forecast for month 13.arrow_forwardThe Rockwell Electronics Corporation retains a service crew to repair machine breakdowns that occur on an average of 2 per day (approximately Poisson in nature). The crew can service an average of 5 machines per day, with a repair time distribution that resembles the exponential distribution. How many machines are waiting in the queue at any given time (approximately)? a. 0.355 b. 0.083 c. 0.297 d. 0.157 e. 0.266arrow_forward
- Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage