Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17.3, Problem 12E
Corporate triple-A bond interest rates for 12 consecutive months follow.
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Develop three-month and four-month moving averages for this time series. Does the three-month or four-month moving average provide more accurate forecasts based on MSE? Explain.
- c. What is the moving average forecast for the next month?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these 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?
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?
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?
Chapter 17 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (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 - The following data shows the average interest rate...Ch. 17.4 - Quarterly revenue ($ millions) for Twitter for the...Ch. 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 - 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 - 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
- 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)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_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_forward
- 4. The CDC released the following table of life expectancies for Americans from 1900-2010.arrow_forward2. A study was conducted to determine the relationship between a person’s monthly income in Omani Rials and the number of meals that person eats away from home per month. The data are shown below.arrow_forwardA 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_forward
- If year one equals P800,000, year two equals P840,000, and year three equals P896,000, the percentage to be assigned for year three in a trend analysis, assuming that year 1 is the base year, is a. 105%. b. 89%. c. 100%. d. 112%.arrow_forwardIs the following nominal, ordinal, or interval data? Explain your answer. Stock pricesarrow_forwardThe side-by-side boxplots show the cumulative college GPAs for sophomores, juniors, and seniors taking an intro stats course in Autumn 2003. a) Which class (sophomore, junior, or senior) had the lowest cumulative college GPA? What is the approximate value of that GPA? b) Which class has the highest median GPA, and what is that GPA? c) Which class has the largest range for GPA, and what is it? d) Which class has the most symmetric set of GPAS? Which class has the most skewed set of GPAs?arrow_forward
- The 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_forwardConsider the following time series data.Quarter Year 1 Year 2 Year 31 4 6 72 2 3 63 3 5 64 5 7 8a. Construct a time series plot. What type of pattern exists in the data?b. Show the four-quarter and centered moving average values for this time series.c. Compute seasonal indexes and adjusted seasonal indexes for the four quarters.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_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