Modern Business Statistics with Microsoft Excel (MindTap Course List)
5th Edition
ISBN: 9781285433301
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 17.3, Problem 16E
a.
To determine
Construct the time series plot.
Explain the type of pattern.
b.
To determine
Explain whether the forecasting methods developed in this section are appropriate for the time series in part (a).
c.
To determine
Explain how much of the past data would be used to forecast a value for April 2012.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
For 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?
Phillip Cane, the managing editor of Your Life Magazine, needs to develop a forecasting system for monthly newsstand sales in order to schedule press runs. Sales in thousands of copies for the last eight months of 2020 (the first year of publication) were:
Month (2020) Sales
May 50
June 45
July 60
August 52
September 69
October 60
November 47
December 53
Phillip does not believe there is a seasonal pattern. Make the forecast using the following techniques for the first six months of 2021:
3-month moving average
3-month weighted moving average (weights are 3,2,1 : the highest for the most recent past month data)
4. The CDC released the following table of life expectancies for Americans from 1900-2010.
Chapter 17 Solutions
Modern Business Statistics with Microsoft Excel (MindTap Course List)
Ch. 17.2 - 1. Consider the following time series...Ch. 17.2 - 2. Refer to the time series data in exercise 1....Ch. 17.2 - Prob. 3ECh. 17.2 - 4. Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Prob. 8ECh. 17.3 - 9. With the gasoline time series data from Table...Ch. 17.3 - 10. 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 - Prob. 16ECh. 17.4 - Consider the following time series...Ch. 17.4 - Prob. 18ECh. 17.4 - Prob. 19ECh. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - Prob. 22ECh. 17.4 - The president of a small manufacturing firm is...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Prob. 25ECh. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - The number of users of Facebook from 2004 through...Ch. 17.5 - Consider the following time series.
Construct a...Ch. 17.5 - Consider the following time series...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 - Prob. 34ECh. 17.6 - Consider the following time series...Ch. 17.6 - Refer to exercise 35.
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 - Prob. 44SECh. 17 - The Garden Avenue Seven sells CDs of its musical...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 - Prob. 50SECh. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Prob. 52SECh. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise...Ch. 17 - Refer to the Hudson Marine data in exercise...Ch. 17 - Forecasting Food and Beverage Sales
The Vintage...Ch. 17 - The Carlson Department Store suffered heavy damage...
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
- 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_forwardA 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-sectionalarrow_forwardUsing the accompanying table, determine the most appropriate forecasting technique for the accompanying data about the Dow Jones Industrial Average yearly closing value and implement the model. Year Close 1983 1258.64 1984 1211.57 1985 1546.67 1986 1895.95 1987 1938.83 1988 2168.57 1989 2753.2 1990 2633.66 1991 3168.83 1992 3301.11 1993 3754.09 1994 3834.44 1995 5117.12 1996 6448.27 1997 7908.25 1998 9181.43 1999 11497.12 2000 10786.85 2001 10021.5 2002 8341.63 2003 10453.92 2004 10783.01 2005 10717.5 2006 12463.15 2007 13264.82 2008 8776.39 2009 10428.05 2010 11557.5 2011 12217.6 2012 13104.1 Use the model forecast the closing value for 2015.Use α=0.7,β=0.3,and γ=0.4,as needed. F2015?arrow_forward
- The following information looks at computer ownership by year. 1985 8.2 (percentage of households) 1990 15.0 1994 22.8 1995 24.1 1998 36.6 1999 42.1 2000 51.0 Construct a timeline (recognizing that time intervals are not even!) Comment about any trends you might see.arrow_forwardThe Bank of Canada is interested in studying the relationship between mortgage rates and medianhome prices. The data is provided belowYear interest rate (%) Median home price1988 10.30 $183,8001989 10.30 $183,2001990 10.10 $174,9001991 9.30 $173,5001992 8.40 $172,9001993 7.30 $173,2001994 8.40 $173,2001995 7.90 $169,7001996 7.60 $174,5001997 7.60 $177,9001998 6.90 $188,1001999 7.40 $203,2002000 8.10 $230,2002001 7.00 $258,2002002 6.50 $309,8002003 5.80 $329,8002004 5.80 $431,0002005 5.80 $515,0002006 6.40 $537,0002007 6.30 $496,0002008 6.00 $352,0002009 5.00 $232,0002010 4.70 $291,7002011 4.40 $262,9002012 3.60 $299,2002013 4.00 $321,2002014 4.10 $373,5002015 3.80 $358,1002016 3.60 $382,5002017 4.00 $402,900a) Estimate a simple linear regression model and find the value of the parameters for theestimation of mortgage rates and the median home price. All JASP input files and outputtables should be provided. Interpret the intercept and the slope coefficientsb) State the correlation…arrow_forwardMatch the statements below to the age pyramid that they describe. High fertility rate:High life expectancy:Typical of a developing nation, such as Ethiopia:Typical of a developed nation, such as Canada:arrow_forward
- A Bloomberg Businessweek North American subscriber study collected data from a sample of 2861 sub-scribers. Fifty- nine percent of the respondents indicated an annual income of $ 75,000 or more, and 50% reported having an American Express credit card. a. What is the population of interest in this study? b. Is annual income a categorical or quantitative variable? c. Is ownership of an American Express card a categorical or quantitative variable? d. Does this study involve cross- sectional or time series data? e. Describe any statistical inferences Bloomberg Businessweek might make on the basis of the survey.arrow_forwardA Bloomberg Businessweek North American subscriber study collected data from asample of 2861 subscribers. Fifty-nine percent of the respondents indicated an annualincome of $75,000 or more, and 50% reported having an American Express credit card.a. What is the population of interest in this study?b. Is annual income a categorical or quantitative variable?c. Is ownership of an American Express card a categorical or quantitative variable?d. Does this study involve cross-sectional or time series data?e. Describe any statistical inferences Bloomberg Businessweek might make on the basisof the surveyarrow_forwardThe folloiwing table shows data for U.S. movie theater admissions (per week). Display the data as a time-series graph and write a short paragraph explaining any noticeable trends or patterns. Year Admissions Year Admissions 1945 79.0 1985 20.30 1955 39.9 1995 23.3 1965 19.8 2005 26.5 1975 19.9 2015 25.4arrow_forward
- ten 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_forward4 PART E Can we conclude that the median monthly rent for the apartments to the east is less than what is stated on the website? YES OR NOarrow_forwardBorrowing money may be necessary for business expansion. However, too much borrowed money can also mean trouble. Are developing countries tending to borrow more? A random sample of 20 developing countries gave the following information regarding foreign debt per capita (in U.S. dollars, inflation adjusted). (Reference: Handbook of International Economic Statistics, U.S. Government Documents.) Country 1 2 3 4 5 6 7 8 9 10 Modern Debt per Capita 175 152 125 124 95 83 34 29 21 89 Historic Debt per Capita 147 134 86 113 58 62 33 36 49 72 Country 11 12 13 14 15 16 17 18 19 20 Modern Debt per Capita 23 28 18 29 197 189 144 124 102 71 Historic Debt per Capita 24 12 12 29 106 156 145 119 118 76 Does this information indicate that foreign debt per capita is increasing in developing countries? Use a 0.01 level of significance. (a) What is the level of significance? Compute the sample test statistic. Find the P-value of the sample test statistic.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 Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics 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:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction 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