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 45SE
Annual retail store revenue for Apple from 2007 to 2014 are shown below (source: ifoapple.com).
Year | Period | Retail Store Revenue ($ billions) |
2007 | 1 | $4,115 |
2008 | 2 | $6,310 |
2009 | 3 | $6,577 |
2010 | 4 | $9,080 |
2011 | 5 | $14,127 |
2012 | 6 | $18,828 |
2013 | 7 | $20,228 |
2014 | 8 | $21,462 |
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Using Mini tab or Excel, develop a linear trend equation for this time series.
- c. Use the trend equation developed in part (b) to forecast retail store revenue for 2015.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
the values of alabama building contracts (in $ millions) for a 12-month period follow.240 350 230 260 280 320 220 310 240 310 240 230a. construct a time series plot. What type of pattern exists in the data?
A dataset that consists of information from the American Community Survey from years 2006, 2007, and 2008, is an example of which type of data?
A) •Time series
B) Pooled cross-sectional
C) Panel
D) Cross-sectional
corporate triple-a bond interest rates for 12 consecutive months follow.9.5 9.3 9.4 9.6 9.8 9.7 9.8 10.5 9.9 9.7 9.6 9.6a. construct a time series plot. What type of pattern exists in the data?
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
- canton Supplies, inc., is a service firm that employs approximately 100 individuals.Managers of canton Supplies are concerned about meeting monthly cash obligations andwant to develop a forecast of monthly cash requirements. Because of a recent changein operating policy, only the past seven months of data that follow are considered to berelevant.Month 1 2 3 4 5 6 7Cash Required ($1000s) 205 212 218 224 230 240 246a. construct a time series plot. What type of pattern exists in the data?b. Using Minitab or excel, develop a linear trend equation to forecast cash requirementsfor each of the next two months.arrow_forwardThe Vintage Restaurant, on Captive Island near Fort Meyers, Florida, is owned and operated by Karen Payne. The restaurant just completed its second year of operation. Below are the sales for those two years (in ten thousands of dollars). Month First Year Second Year January 57 61 February 51 75 March 58 54 April 57 56 May 68 62 June 72 71 July 60 59 August 51 75 September 68 68 October 51 50 November 71 64 December 75 58 a) Construct a time-series plot in excel. (Label axes and graph) b) Develop a six month moving average. Compute MSE and forecast the amount of sales for the next month. c) Use α = 0.2 to compute the exponential smoothing values. Compute MSE and forecast for the next month. d) Compare the result for the six month average and exponential smoothing. Which appears to provide a better…arrow_forwardThe Energy Information Administration of the U.S. Department of Energy providedtime series data for the U.S. average price per gallon of conventional regular gasolinebetween January 2007 and February 2014 (Energy Information Administration website,March 2014). Use the Internet to obtain the average price per gallon of conventionalregular gasoline since February 2014.a. Extend the graph of the time series shown in Figure 1.1.b. What interpretations can you make about the average price per gallon of conventionalregular gasoline since February 2014?c. Does the time series continue to show a summer increase in the average price pergallon? Explain.arrow_forward
- In the theory of time series, earthquakes can be considered as a. Seasonal Variation b. Cyclical Variation c. Irregular Variations d. Secular Trendarrow_forwardThe Hungry Person restaurant has posted its sales (in thousands of dollars) for the last two years. Month 1st Year 2nd Year January 201 216 February 216 223 March 232 240 April 201 244 May 221 232 June 213 220 July 220 211 August 214 213 September 202 217 October 217 220 November 224 212 December 236 216 a) Construct a time series plot in excel. (Label axes and graph) b) Develop a four month moving average. Compute MSE and forecast the amount of sales for the next month. c) Use α = 0.2 to compute the exponential smoothing values. Compute MSE and forecast for the next month. d) Compare the result for the four month average and exponential smoothing. Which appears to provide a better forecast based on MSE? Explain.arrow_forward4. The CDC released the following table of life expectancies for Americans from 1900-2010.arrow_forward
- Year Gross Federal Debt ($millions) 1945 260,123 1950 256,853 1955 274,366 1960 290,525 1965 322,318 1970 380,921 1975 541,925 1980 909,050 1985 1,817,521 1990 3,206,564 1995 4,921,005 2000 5,686,338 Construct a scatter plot with this data. Do you observe a trend? If so, what type of trend do you observe? Use Excel to fit a linear trend and an exponential trend to the data. Display the models and their respective r^2. Interpret both models. Which model seems to be more appropriate? Why?arrow_forwardSuppose a government organization reported the accompanying data on the number of speed-related crash fatalities during holiday periods for the years from 1994 to 2003. Speed-Related Fatalities Holiday Period 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 New Year's Day 143 144 176 76 219 138 171 134 210 70 Memorial Day 195 176 185 197 138 183 156 190 188 181 July 4th 178 219 202 179 169 178 219 64 234 184 Labor Day 189 188 166 179 162 171 180 138 202 189 Thanksgiving 212 198 218 210 203 168 187 217 210 202 Christmas 152 129 66 183 134 191 155 210 60 198 (a) Calculate the standard deviation for the New Year's Day data. (Round the answer to three decimal places.) (b) Without calculating the standard deviation of the Memorial Day data, determine whether the standard deviation for the Memorial Day data would be larger or smaller than the standard deviation of the New Year's Day data. larger smaller (c) Memorial Day and Labor Day are holidays that always occur on Monday and Thanksgiving…arrow_forwardten weeks of data on the commodity Futures index are 7.35, 7.40, 7.55, 7.56, 7.60, 7.52,7.52, 7.70, 7.62, and 7.55.a. construct a time series plot. What type of pattern exists in the data?arrow_forward
- Interpret data visualization consisting of such tools as time series plots, box plots, and scatter charts using the following data sets. Scatter charts (X versus Y) – Analyze two different and distinct relationships: C22 (X, monthly advertising dollars) versus C23 (Y, monthly revenue dollars), and C24 (X, training hours per year per call center employee) versus C25 (Y, average monthly sales revenue generated per call center employee) C22 C23 C24 C25 12000 101000 0 4779 8000 92000 0 4706 10000 110000 0 4350 13000 120000 20 5189 7000 90000 20 5140 8000 82000 20 4976 10000 93000 30 5110 6000 75000 30 5685 9000 91000 30 5618 11000 105000 40 5995 40 5628 40 5897 50 5746 50 5719 50 5782 60 4895 60 5030 60 4648arrow_forwardA. Ogive B. Time Series Chart C. Frequency Polygon D. Pareto Chart E. Scatter plotarrow_forwardMovieflix, an online movie streaming service that offers a wide variety of award-winning TV shows, movies, animes, and documentaries, would like to determine the mathematical trend ofmemberships in order to project future needs. MovieFlix - Advertising and Subscriptions Year Advertising Expenditure $ 000 Membership Subscriptions 2013 51 62 2014 58 68 2015 62 66 2016 65 66 2017 68 67 2018 76 72 2019 77 73 2020 78 72 2021 78 78 2022 84 73 2023 85 76 (i) Plot the scattergraph for the data.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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