STATISTICS F/BUSINESS+ECONOMICS-TEXT
13th Edition
ISBN: 9781305881884
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Videos
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 costello Music company has been in business for five years. during that time, salesof pianos increased from 12 units in the first year to 76 units in the most recent year. Fredcostello, the firm’s owner, wants to develop a forecast of piano sales for the coming year.the historical data follow.Year 1 2 3 4 5Sales 12 28 34 50 76a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for the time series. What is the average increase insales that the firm has been realizing per year?c. Forecast sales for years 6 and 7.
Import Illinois.xls as a table. Using logical indexing to select the years with more than 2800 cases of
Diabetes. Then plot all of the data on the same axis.
F1
fx
Homicide
B
C
E
Year
Accidents
Cancer
Diabetes Heart Disease Homicide|
Suicide
1999
4125
25024
3004
33387
1023
1020
3
2000
4041
25365
2995
31844
991
1003
4.
2001
4077
24778
3092
30990
1087
1139
2002
4222
24737
3011
30821
1016
1145
2003
3942
24464
3044
29816
966
1011
7.
2004
4133
24289
3069
28284
871
1028
8.
2005
4182
24250
3034
28226
866
1086
9.
2006
4451
24084
2795
27007
865
1010
10
2007
4367
24115
2851
25813
863
1108
11
2008
4218
24300
2846
26078
872
1198
12
2009
3961
24185
2741
24931
881
1177
13
2010
3997
24070
2507
24959
783
1178
14
2011
4166
24007
2693
24987
812
1226
15
2012
4488
24562
2706
24667
832
1292
16
2013
4511
24491
2798
17
24839
792
1321
2014
4644
24501
2712
18
25024
792
1398
2015
4850
24713
2817
25652
19
863
1363
20
21
The table and graph below both display the percentage of people in the United States who do not have health insurance over several different years. Data downloaded on 2/19/2020 from https://ourworldindata.org/health-meta.
30.0%
25.0%
€ 20.0%
15.0%
10.0%
5.0%
Year
0.0%
Part 1
24.3%
14.5%
1960 1970 1980
1963 1968 1994 2012
Percent without Health Insurance 24.3% 14.5% 15.8% 14.7%
Part 2
Use the table to answer the questions in each part below.
15.8%
Part 3
Which variable is the independent variable and which is the dependent variable? Choose the correct response below. You only get one submission.
T
14.7%
1990 2000 2010 2020
Year
O Percent of people without health insurance is the independent variable and year is the dependent variable.
O Year is the independent variable and percent of people without health insurance is the dependent variable.
Average Rate of Change
In what unit is the average rate of change in the percentage of people without health insurance measured? You get two…
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
- Don't hand writing solution.arrow_forwardTime Series Graphing Exercise Air Quality The following data show the number of days the air quality for Atlanta, Georgia, was below the accepted standards. Draw a time series graph for the data shown below. The times series graph maybe completed using excel or hand generated. If hand generated take a picture of the graph and attach the photo. Interpret the results. . . Exercise Data Year Days 2005 5 2006 14 2007 15 2008 4arrow_forwardYear 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_forward
- The results from a survey that collected annual household income is shown in the given table. Which of the following data types best describe these values? Click the icon to view the annual household income. Annual Household Income OA. Ordinal OB. Time series OC. Cross-sectional OD. Nominal Annual Household Income Household Income ($000) Under $30 $30 to under $40 $40 to under $50 $50 to under $60 $60 to under $70 Over $70 Print Number of Households 67 111 125 21 38 40 Done MacBook Air - X Time Remaining: 01:24:09 Nextarrow_forwardplease answer within 30 minutes...arrow_forwardPlease solve. Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 7 В 2 1 2 5 3 4 6 7 4 6 8 9 (a) Construct a time series plot. What type of pattern exists in the data? O The time series plot shows a horizontal pattern and no seasonal pattern in the data. The time series plot shows a linear trend and a seasonal pattern in the data. O The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. O The time series plot shows a linear trend and no seasonal pattern in the data. (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to three decimal places.) - 1 if quarter 1, 0 otherwise; x₂ = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise (c) Compute the quarterly forecasts for the next year based on the model you developed in part (b). (Round your answers to two decimal places.) quarter 1 forecast quarter 2…arrow_forward
- QUESTION 17 DATAfile: NFLTeamValue In 2014, the 32 teams in the National Football League (NFL) were worth, on average, $1.17 billion, 5% more than in 2013. The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 32 NFL teams in 2014.† Team Revenue($ millions) CurrentValue($ millions) ArizonaCardinals 253 961 AtlantaFalcons 252 933 BaltimoreRavens 292 1,227 BuffaloBills 256 870 CarolinaPanthers 271 1,057 ChicagoBears 298 1,252 CincinnatiBengals 250 924 ClevelandBrowns 264 1,005 DallasCowboys 539 2,300 DenverBroncos 283 1,161 DetroitLions 248 900 Green BayPackers 282 1,183 HoustonTexans 320 1,450 IndianapolisColts 276 1,200 JacksonvilleJaguars 260 840 Kansas CityChiefs 245 1,009 Team Revenue($ millions) CurrentValue($ millions) MiamiDolphins 268 1,074 MinnesotaVikings 234 1,007 New EnglandPatriots 408 1,800 New OrleansSaints 276 1,004 New YorkGiants 338 1,550 New YorkJets 321…arrow_forwardCryptocurrencies have rapidly become an important alternative to traditional currencies for many types of transactions. Etherium, one of the most prominent cryptocurrencies, has rapidly appreciated in value. Daily Etherium trading information for the first 332 days of 2021. It includes the following variables: Date Day – Day of the year, used to assess trend over time Volume (US $) – Daily trading volume Opening Price (US $) – Opening price for daily trading Price Change (US $) – Daily change in price from opening to close 1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the alternative hypothesis that Volume has a linear relationship to Price Change. Specifically, what are the test statistic and the p-value for that test statistic? For α = .05, what do you conclude about the relationship between the variables? (reminder: the T.DIST.2T function requires input of a positive test statistic)arrow_forwardIn Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018. Date Revenue February/14 3,519,756 March/14 4,092,575 April/14 4,980,992 May/14 5,273,355 June/14 5,715,707 July/14 6,522,085 August/14 7,407,450 September/14 7,741,167 October/14 7,232,870 November/14 7,642,800 December/14 7,465,568 January/15 8,558,141 February/15 8,802,295 March/15 9,099,395 April/15 9,979,643 May/15 10,617,311 June/15 11,326,452 July/15 10,856,584 August/15 12,811,437 September/15 13,181,758 October/15 11,656,736 November/15 11,290,012 December/15 12,231,410 January/16 13,247,434 February/16…arrow_forward
- 3) U.S. Health care expenditures. Because the over-65 population is growing more rapidly in the next few decades health care spending is expected to increase significantly in the next few decades. The following table gives the projected US health care expenditure (in trillions) from 2008 to 2013 Year 2008 2009 2010 2011 2012 2012 Expenditure 2.34 2.47 2.57 2.70 2.85 3.02 a) Draw a scatter diagram for this data. Use “Years since 2008” on the x-axis. Make sure the scatter diagram includes all required elements (axes labels, title, and appropriate scale) b) Use the points for 2009 and 2011 to find an equation of a line modeling this situation c) Use linear regression to find an equation of a line modeling this situation d) Use the equation in b to predict expenditures in 2016 and do this again for the equation in part c. What is the absolute and percentage difference between the two equations (use the equation in c as the base equation in the % calculation) e) Now use…arrow_forwardConsider the following time series data. Quarter Year 1 1 De- 2 3 4 3 1 4 6 Year 2 quarter 3 forecast quarter 4 forecast 5 2 6 8 Year 3 6 5 7 (a) Construct a time series plot. What type of pattern exists in the data? O The time series plot shows a horizontal pattern and no seasonal pattern in the data. The time series plot shows a linear trend and no seasonal pattern in the data. O The time series plot shows a linear trend and a seasonal pattern in the data. O The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. 9 (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to three decimal places.) x₁ = 1 If quarter 1, 0 otherwise; x₂ = 1 If quarter 2, 0 otherwise; x₂ = 1 If quarter 3, 0 otherwise (c) Compute the quarterly forecasts for the next year based on the model you developed in part (b). (Round your answers to two decimal…arrow_forwardThe monthly cost for health care for an employee and two dependents in a certain year is given in the following table. Provider Cost Provider Cost Maxicare $415.31 Kaiser $4337 Cigna $424.74 Aetna $436.26 Health Net $427.29 Blue Shield $442.25 Pacific Care $428.06 Omni Healthcare $457.90 Redwoods Plan $431.53 Lifeguard $457.64 Draw a box plot for the monthly costs of health care (ranked from lowest to highest). 0415 420 425 430 435 440 0425 430 435 440 445 450 455 420 430 440 450 420 430 440 450arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher: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