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
Question
Chapter 17, Problem 47SE
a.
To determine
Construct a time series plot.
Explain the type of pattern.
b.
To determine
Calculate the linear trend equation for the data.
Calculate the forecast values for the next two months’ cash requirements.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The president of State University wants to forecast student enrollments for this Year
academic year based on the following historical data:
5 years ago
4 years ago
3 years ago
2 years ago Last year
Enrollments
15.000
16.000 18.000
20.000 21.000
a- What is the forecast for this year using a 3-year weighted moving average where the weights are halved in a descending order from newest to oldest ?
b. What is the forecast for this year using the trend line for these data? c. using the MAD find which forecasting technique may be appropriate for this quetion
to analyze the risk, or volatility, associated with investing in general electric commonstock, a sample of the eight quarterly percent total returns was identified as shown below(charles schwab website, January 2012). the percent total return includes the stock pricechange plus the dividend payment for the quarter.20.0 −20.5 12.2 12.6 10.5 −5.8 −18.7 15.3a. what is the value of the sample mean? what is its interpretation?
The 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…
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
- The Bank of Canada is interested in studying the relationship between mortgage rates and median home prices. The data is provided below Year interest rate (%) Median home price 1988 10.30 $183,800 1989 10.30 $183,200 1990 10.10 $174,900 1991 9.30 $173,500 1992 8.40 $172,900 1993 7.30 $173,200 1994 8.40 $173,200 1995 7.90 $169,700 1996 7.60 $174,500 1997 7.60 $177,900 1998 6.90 $188,100 1999 7.40 $203,200 2000 8.10 $230,200 2001 7.00 $258,200 2002 6.50 $309,800 2003 5.80 $329,800 2004 5.80 $431,000 2005 5.80 $515,000 2006 6.40 $537,000 2007 6.30 $496,000 2008 6.00 $352,000 2009 5.00 $232,000 2010 4.70 $291,700 2011 4.40 $262,900 2012 3.60 $299,200 2013 4.00 $321,200 2014 4.10 $373,500 2015 3.80 $358,100 2016 3.60 $382,500 2017 4.00 $402,900…arrow_forwardThe Bank of Canada is interested in studying the relationship between mortgage rates and median home prices. The data is provided below Year interest rate (%) Median home price 1988 10.30 $183,800 1989 10.30 $183,200 1990 10.10 $174,900 1991 9.30 $173,500 1992 8.40 $172,900 1993 7.30 $173,200 1994 8.40 $173,200 1995 7.90 $169,700 1996 7.60 $174,500 1997 7.60 $177,900 1998 6.90 $188,100 1999 7.40 $203,200 2000 8.10 $230,200 2001…arrow_forwardcanton Supplies, inc., is a service firm that employs approximately 100 individuals.Managers of canton Supplies are concerned about meeting monthly cash obligations andwant to develop a forecast of monthly cash requirements. Because of a recent changein operating policy, only the past seven months of data that follow are considered to berelevant.Month 1 2 3 4 5 6 7Cash Required ($1000s) 205 212 218 224 230 240 246a. construct a time series plot. What type of pattern exists in the data?b. Using Minitab or excel, develop a linear trend equation to forecast cash requirementsfor each of the next two months.arrow_forward
- Find out the next month after april income by using the forecasting method of the moving average methodarrow_forwardAfter its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s). a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales? b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. c) Forecast the sales from January to December of the year 2010. d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG Month 2001 2002 2003 2004 2005 2006 2007 2008 2009 January 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 February 114.3 177.8 203.2 254 317.5 457.2 406.4 444.5 533.4 March 101.6 177.8 228.6 266.7 368.3 457.2 431.8 495.3 635 April 152.4 203.2…arrow_forwardThe Beaver Creek Pottery Company sells bowls and mugs, hand-made by Native American artisans, at a craft store and through a Web site. Making these items requires a special type of clay and a large amount of individual person-hours, so for planning purposes, the company would like to forecast future demand, specifically through its Web site, which has increasingly become the primary source of sales. Following is the company’s Web site demand (in items sold) for the past 36 months: Develop a linear trend forecast model, an exponentially smoothed model (a = 0.20), and a 5-month moving average forecast model and indicate which one you think should be used to forecast Web site demand.arrow_forward
- Kim is interested in studying the relationship between mortgage rates and median home prices. The data is provided below Year Interest Rate (%) Median home price 1988 10.30 $183,800 1989 10.30 $183,200 1990 10.10 $174,900 1991 9.30 $173,500 1992 8.40 $172,900 1993 7.30 $173,200 1994 8.40 $173,200 1995 7.90 $169,700 1996 7.60 $174,500 1997 7.60 $177,900 1998 6.90 $188,100 1999 7.40 $203,200 2000 8.10 $230,200 2001 7.00 $258,200 2002 6.50 $309,800 2003 5.80 $329,800 2004 5.80…arrow_forwardKim is interested in studying the relationship between mortgage rates and median home prices. The data is provided below Year Interest Rate (%) Median home price 1988 10.30 $183,800 1989 10.30 $183,200 1990 10.10 $174,900 1991 9.30 $173,500 1992 8.40 $172,900 1993 7.30 $173,200 1994 8.40 $173,200 1995 7.90 $169,700 1996 7.60 $174,500 1997 7.60 $177,900 1998 6.90 $188,100 1999 7.40 $203,200 2000 8.10 $230,200 2001 7.00 $258,200 2002 6.50 $309,800 2003 5.80 $329,800 2004 5.80…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_forward
- Movieflix, an online movie streaming service that offers a wide variety of award-winning TV shows, movies, animes, and documentaries, would like to determine the mathematical trend ofmemberships in order to project future needs. MovieFlix - Advertising and Subscriptions Year Advertising Expenditure $ 000 Membership Subscriptions 2013 51 62 2014 58 68 2015 62 66 2016 65 66 2017 68 67 2018 76 72 2019 77 73 2020 78 72 2021 78 78 2022 84 73 2023 85 76 (i) Plot the scattergraph for the data.arrow_forwardIllustrate the formulation of dynamic causal effects in time series data?arrow_forwardTraders from the faraway nation of Chplandia have brought infected goods to market in the capital of Pcoria. As a result, a new infectious disease called chpitis is spreading through the Pcorian population. Chpitis is not fatal, but leaves victims severely disfigured for the remainder of their lives. Throughout this problem, assume no discounting of future years.a. The Pcorian government surveys victims to determine how burdensome chpitis is. Respondents claim they are indifferent between living six years without chpitis and living ten years covered with chpitis scars. Most respondents explain that they face a major social stigma in Pcoria’s schools and workplaces.What is the implied quality weight q for a year lived in the aftermath of a chpitis infection?b. Now assume that a drug company has developed an ointment that can be used to treat chpitis sores and reduce scarring. Surveys indicate that the ointment, which costs $10,000 for a full course of treatment, can improve quality of…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 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
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License