STATISTICS F/BUSINESS+ECONOMICS-TEXT
13th Edition
ISBN: 9781305881884
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 17.4, Problem 25E
Quarterly revenue ($ millions) for Twitter for the first quarter of 2012 through the first quarter of 2014 are shown below (adexchange.com, April, 2015):
| Quarter | Revenue ($ millions) |
| 1 | 54 |
| 2 | 68 |
| 3 | 82 |
| 4 | 112 |
| 5 | 114 |
| 6 | 139 |
| 7 | 169 |
| 8 | 243 |
| 9 | 250 |
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Using Excel or Minitab, develop a linear trend equation for this time series.
- c. Using Excel or Minitab, develop a
quadratic trend equation for this time series. - d. Compare the MSE for each model. Which model appears better according to MSE?
- e. Use the models developed in parts (b) and (c) to forecast revenue for the tenth quarter.
- f. Which of the two forecasts in part (e) would you use? Explain.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
In 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?
The accompanying data represent health care expenditures per capita (per person) as a percentage of the U.S. gross domestic product (GDP) from 2007 to 2013. Gross domestic product is the total value of all goods and services created during the course
of the year Complete parts (a) through (c) below.
Click the icon to view the data table.
(a) Construct a time-series plot that a politician would create to support the position that health care expenditures are increasing and must be slowed. Choose the correct graph below
OD.
O C.
OB
OA
A
Q
A
Q
Q
25,000+
11,000
Q
Q
3
2
G
HIER
11200
2H
7,000++
C
2013
of
+
2013
2007
2007
Year
Year
Year
(b) Construct a time-series plot that the health care industry would create to refute the opinion of the politician. Choose the correct graph below.
OB.
O C.
O A.
A
Q
A
Q
11,000
Q
(C)
7,000+
201
20
7.000+++++++*
2007
2007
2013
2013
Year
Year
(c) Explain how different measures may be used to support two completely different positions. Choose the correct answer…
The creator of a new online multiplayer survival game has been tracking the monthly downloads of the game. The following table shows the monthly downloads (in thousands) for each month of the current and previous year.
Click on the datafile logo to reference the data.
The datafile logo.
Month
Downloads
Month
Downloads
(previous year)
(thousands)
(current year)
(thousands)
February
33.0
January
31.0
March
34.0
February
32.0
April
34.0
March
33.0
May
31.0
April
34.0
June
32.0
May
33.0
July
33.0
June
32.0
August
35.0
July
35.0
September
36.0
August
33.0
October
37.0
September
33.0
November
34.0
October
31.0
December
35.0
a. Compute the mean, median, and mode for number of downloads in the previous year.
Mean (to 3 decimals)
thousand
Median (to 2 decimal)
thousand
Mode (to 2 decimal)
thousand
b. Compute the mean, median, and mode for number of downloads in the current year.
Mean (to 3 decimals)
thousand
Median (to 2…
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 US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the trend appearslinear. Ifso, and assuming the trend continues, in what year will imports exceed 12,000 hectoliters?arrow_forwardthe 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?arrow_forwardThe values of Bahria building contracts (in Rupees millions) for a 12-month period follow. 240 350 230 260 280 320 220 310 240 310 240 230 a) Construct a time-series plot. b) Find the trend by method of 3-year moving average and plot the values.arrow_forward
- Please answer asap I really need helparrow_forwardU.S. Civilian Labor Force (thousands) Year Labor Force Year Labor Force 2007 153,918 2012 155,628 2008 154,655 2013 155,151 2009 153,111 2014 156,238 2010 153,650 2015 157,957 2011 153,995 2016 159,640 1. Fit three trend models: linear, exponential, and quadratic. Which model would offer the most believable forecasts? 2. Make forecasts using the following fitted trend models for years 2017-2019. t Exponential 11 12 13arrow_forwardPlease answer asap I really need helparrow_forward
- Interpret the time plot. What are the components you can observe in the time series plot? Is the data stationary? Explainarrow_forwardUsing the following time series data of U.S. new car sales ($ millions), respond to the following items. (The data is sourced from Find "Monthly Retail Trade Report," then select "Time Series/Trend Charts" to find the https://www.census.gov/retail/index.html#mrts. data for U.S. new car sales.). Year $ Sales (Millions) 2009 2010 $ 486,565 549,473 2011 608,792 2012 672,550 2013 735,374 2014 785,142 2015 842,120 2016 2017 2018 877,743 911,157 943,538arrow_forwardUsing the following time series data of U.S. new car sales ($ millions), respond to the following items. (The data is sourced from https://www.census.gov/retail/index.html#mrts. Find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts” to find the data for U.S. new car sales.). Year $ Sales (Millions) 2009 486,565 2010 549,473 2011 608,788 2012 672,550 2013 735,374 2014 785,142 2015 842,122 2016 877,743 2017 911,157 2018 943,538 b. Test for autocorrelation using the 0.05 significance level. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.) Year $ Sales (Millions) Predicted Residuals Lagged Residuals Squared Difference Squared Residuals 2009 486,565 2010 549,473 2011 608,788 2012 672,550 2013 735,374 2014 785,142 2015 842,122 2016 877,743 2017 911,157 2018 943,538…arrow_forward
- the table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.arrow_forwardNo need to answer everything! Just plot the actual visitors and the forecasts. Compare the accuracy of the forecasts in the 1985 to 1990 period with those subsequent to that period.arrow_forwardThe creator of a new online multiplayer survival game has been tracking the monthly downloads of the game. The following table shows the monthly downloads (in thousands) for each month of the current and previous year. Click on the datafile logo to reference the data. Month Downloads Month Downloads (previous year) (thousands) (current year) (thousands) February 33.0 January 37.0 March 34.0 February 35.0 April 34.0 March 37.0 May 32.0 April 38.0 June 32.0 May 35.0 July 35.0 June 36.0 August 35.0 July 35.0 September 37.0 August 35.0 October 37.0 September 34.0 November 36.0 October 31.0 December 34.0 Compute the mean, median, and mode for number of downloads in the previous year. Mean (to 3 decimals) thousand Median (to 2 decimal) thousand Mode (to 2 decimal) thousand…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Which is the best chart: Selecting among 14 types of charts Part II; Author: 365 Data Science;https://www.youtube.com/watch?v=qGaIB-bRn-A;License: Standard YouTube License, CC-BY