Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 8, Problem 12P
Corporate triple A bond interest rates for 12 consecutive months are as follows:
- 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 the four-month moving average provide the better 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 solutionStudents 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?
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)
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 8 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 8 - Consider the following time series data:
Using...Ch. 8 - Refer to the time series data in Problem 1. Using...Ch. 8 - Problems 1 and 2 used different forecasting...Ch. 8 - Consider the following time series data:
Compute...Ch. 8 - Consider the following time series...Ch. 8 - Consider the following time series...Ch. 8 - Refer to the gasoline sales time series data in...Ch. 8 - Prob. 8PCh. 8 - Prob. 9PCh. 8 - Prob. 10P
Ch. 8 - For the Hawkins Company, the monthly percentages...Ch. 8 - Corporate triple A bond interest rates for 12...Ch. 8 - The values of Alabama building contracts (in...Ch. 8 - The following time series shows the sales of a...Ch. 8 - Prob. 15PCh. 8 - The following table reports the percentage of...Ch. 8 - Consider the following time series: a. Construct a...Ch. 8 - Consider the following time series:
Construct a...Ch. 8 - Because of high tuition costs at state and private...Ch. 8 - The Seneca Children’s Fund (SCF) is a local...Ch. 8 - The president of a small manufacturing firm is...Ch. 8 - Consider the following time series: a. Construct a...Ch. 8 - Consider the following time series...Ch. 8 - The quarterly sales data (number of copies sold)...Ch. 8 - Prob. 25PCh. 8 - South Shore Construction builds permanent docks...Ch. 8 - Hogs & Dawgs is an ice cream parlor on the border...Ch. 8 - Donna Nickles manages a gasoline station on the...Ch. 8 - The Vintage Restaurant, on Captiva Island near...
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
- 4. The CDC released the following table of life expectancies for Americans from 1900-2010.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_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_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_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_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
- 1. The monthly closing stock prices ( rounded to the nearest dollar) for Panera Bread Co. for the first six months of 2010 are reported in the following table Month closing stock price January2010 $71 February2010 $73 March 2010 $76 April 2010 $78 May 2010 $81 June 2010 $75 (d) Calculate sample variancearrow_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_forwardA, Perform a Trend and Seasonal analysis with the following data. Include the trend formula and the multiplicative indices for the seasons. Using the model forecast sales for the next year (all 4 seasons of year 4). Year Season Sales 1 Sp 140 1 Su 50 1 w 130 1 F 520 2 Sp 200 2 Su 110 2 w 190 2 f 550 3 Sp 260 3 Su 220 3 W 210 3 f 550 B, Discuss the Price Index most used in your country. How is it calculated?arrow_forward
- Is the following nominal, ordinal, or interval data? Explain your answer. Stock pricesarrow_forwardQUESTION 22Consider a sample of payment times (in days) for 30 randomly selected invoices22 29 16 15 18 1719 17 10 21 15 1436 35 46 20 42 3418 23 22 35 36 1913 28 17 15 24 30(a) Use the above data and determine the frequency using the below frequency distribution.Classes FrequencyLess than 1515 < 2020 < 2525 < 3030 < 3535 < 40At least 40(3)(b) Construct a stem-and-leaf plot and describe the shape of the sample data (payment times).(2)(c) Determine the modal class from the frequency distribution calculated in (a). (2)(d) Using the ungrouped data given in the selected random sample, calculate the mean, medianand the mode. (6)[13]arrow_forwardGiven the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note that the 1st quarter is January, February, and March; 2nd quarter April, May, June; 3rd quarter July, August, September; and 4th quarter October, November, December. Note: Round final answer to a whole number. JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER Last year 100 125 135 175 185 200 150 140 130 200 225 250 This year 125 135 135 190 200 190arrow_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