STATISTICS F/BUSINESS+ECONOMICS-TEXT
13th Edition
ISBN: 9781305881884
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 17, Problem 44SE
The 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?
- b. Compute the linear trend equation for the time series. Use the linear trend equation to forecast the crude cost for January 2014.
- c. Compute the quadratic trend equation for the time series. Use the quadratic trend equation to forecast the crude cost for January 2014.
- d. Using MSE. which approach provides the most accuratre forecasts for the historical data?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
the 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?
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?
The following table gives the average monthly exchange rate between the U.S. dollar and the euro for 2009. It shows that 1 euro was equivalent to 1.289 U.S. dollars in January 2009. Develop a trend line that could be used to predict the exchange rate for 2010. Use this model to predict the exchange rate for January 2010 and February 2010. MONTH ______________________ EXCHANGE RATE January ....................................... 1.289 February ...................................... 1.324 March ......................................... 1.321 April .......................................... 1.317 May ........................................... 1.280 June ........................................... 1.254 July ........................................... 1.230 August ....................................... 1.240 September ................................... 1.287 October ..................................... 1.298 November .................................. 1.283 December…
Chapter 17 Solutions
STATISTICS F/BUSINESS+ECONOMICS-TEXT
Ch. 17.2 - Consider the following time series data. Week 1 2...Ch. 17.2 - Refer to the time series data in exercise 1. Using...Ch. 17.2 - Exercises 1 and 2 used different forecasting...Ch. 17.2 - Consider the following time series data. Month 1 2...Ch. 17.3 - Consider the following time series data. Week 1 2...Ch. 17.3 - Consider the following time series data. Month 1 2...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Refer again to the gasoline sales time series data...Ch. 17.3 - With the gasoline time series data from Table...Ch. 17.3 - With a smoothing constant of = .2, equation...
Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in ...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - The U.S. Census Bureau tracks the median price for...Ch. 17.4 - Consider the following time series data. a....Ch. 17.4 - Prob. 18ECh. 17.4 - Consider the following time series. a. Construct a...Ch. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - The Seneca Childrens Fund (SCF) is a local charity...Ch. 17.4 - The following table shows Googles annual revenue...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Quarterly revenue ( millions) for Twitter for the...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - Prob. 27ECh. 17.5 - Consider the following time series. a. Construct a...Ch. 17.5 - Consider the following time series data. a....Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Prob. 33ECh. 17.5 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Consider the following time series data. a....Ch. 17.6 - Refer to exercise 35. a. Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies. Inc., supplies milk to several...Ch. 17 - The data contained in the DATAfile named CrudeCost...Ch. 17 - Annual retail store revenue for Apple from 2007 to...Ch. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Prob. 47SECh. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Hudson Marine has been an authorized dealer for CD...Ch. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise 53....Ch. 17 - Refer to the Hudson Marine data in exercise 53. a....Ch. 17 - Forecasting Food and Beverage Sales The Vintage...Ch. 17 - Forecasting Lost Sales The Carlson Department...
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
- 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_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_forwardFor the hawkins company, the monthly percentages of all shipments received on timeover the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.a. construct a time series plot. What type of pattern exists in the data?b. compare the three-month moving average approach with the exponential smoothing approach for a = .2. Which provides more accurate forecasts using MSe as themeasure of forecast accuracy?arrow_forward
- Using excel. For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Construct a time series plot. What type of pattern exists in the data? b. Compare the three-month moving average approach with the exponential smoothing approach for α=\alpha =α= .2. Which provides more accurate forecasts using MSE as the measure of forecast accuracy? c. What is the forecast for next month?arrow_forwardarget'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 93561arrow_forwardExamine the data for each race/ethnicity group. Do the data represent a stationary or nonstationary process? Do any of the race/ethnicity groups exhibit a decreasing trend? Do any of the race/ethnicity groups show a strictly increasing trend over the entire time period from 2000 to 2016?arrow_forward
- Plot the sales revenue figures and appropriate trend line on a graph and identify from this the choice of model for working out the seasonal component. Using the appropriate seasonal model, complete the calculations that are required to produce the required forecasts for quarters 1, 2, 3 and 4 of 2021. On the basis of your analysis explain the recommendation that you would make to ALAW Ltd regarding its future plans.arrow_forwardDescribe the three major categories of data (time-series, cross-sectional, and panel).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
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillTrigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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