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
Concept explainers
Videos
Textbook Question
Chapter 17.4, Problem 24E
The following data shows the average interest rate (%) for a 30-year fixed-rate mortgage over a ten-year period (FreddieMac website, July 30, 2016).
- a. Construct a time series plot. Do you think a linear trend or a quadratic trend will provide a better fit for this time series? Why?
- b. Develop the linear trend equation for this time series. Using this linear trend equation, forecast the average interest rate for 2016.
- c. Develop the quadratic trend equation for this time series. Using this quadratic trend equation, forecast the average interest rate for 2016.
- d. Compare your answers to parts (b) and (c). Which model would you recommend? Why?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Complete the following table and draw a graph showing how bond price for each bond changes over time as they move towards their maturity dates. Describe the relationship between bond prices and time remaining for maturity.
Using the table below show all the calculations for every bond prices calculated
Years remaining to
maturity
BOND A
Coupon rate = 8% p.a.
Market interest rate =
6% p.a.
BOND B
Coupon rate = 6% p.a.
Market interest rate =
6% p.a.
BOND C
Coupon rate = 4% p.a.
Market interest rate =
6% p.a.
10
9
8
7
6
5
4
3
2
1
0
c. Predict sales in 15 years.
21:40
ll LTE
A brainmass.com
Sign in
Join
Forecast
E Add
The Mayfair Department Store in Davenport, lowa,
is trying to determine the amount of sales lost
while it was shut down during July and August
because of damage caused by the Mississippi River
flood. Sales data for January through June follow.
Month Sales ($1000s)
January 185.72
February 167.84
March 205.11
April 210.36
May 255.57
June 261.19
a) Use exponential smoothing with Alpha = 0.4, to
develop a forecast for July and August. (Hint: Use
the forecast for July as the actual sales in July in
developing the August forecast.) Comment on the
use of exponential smoothing for forecasts more
than one period into the future.
We use cookies to ensure that we give you the
best experience on our website. By continuing to
use the site, you consent to the use of cookies.
Please review our Privacy Policy
OK
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
- As one of the loan officers for Grove Gate Bank, calculate the monthly principal and interest, PI (in $), using this table and the monthly PITI (in $) for the mortgage. (Round dollars to the nearest cent.) AmountFinanced InterestRate Termof Loan(years) MonthlyPI AnnualPropertyTax AnnualInsurance MonthlyPITI $127,700 6.75% 15 $ $2,370 $1,325 $arrow_forwardAs one of the loan officers for Grove Gate Bank, calculate the monthly principal and interest, PI (in $), using this table and the monthly PITI (in $) for the mortgage. (Round dollars to the nearest cent.) AmountFinanced InterestRate Termof Loan(years) MonthlyPI AnnualPropertyTax AnnualInsurance MonthlyPITI $260,000 9.50% 25 $6,573 $2,126arrow_forwardCalculate the arithmetic gradient after 6 years if the future sum is 8000$ and rate of interest is 8%. a. 479$ b. 438$ c. 426$arrow_forward
- The table below gives information for deposits that will earn simple interest for a certain number of periods in three different savings accounts. Using the example as a guide, fill in the missing information in the table.arrow_forwardFind the simple interest balance function and the annual interest rate for the following partially listed balance table. Years, t Balance, B(t) 9 $1146.32 15 $1317.20 % Round the starting value to the nearest dollar. Input the number without the dollar sign. Example: 112 Round the slope to the nearest penny. Input only the number. Example 12.35 Round the annual interest rate to the nearest tenth of a percent. Input only the number. Example: 7.9arrow_forwardThe year 2018 price of a fast food meal at a certain restaurant is given below. Find the estimated future prices required to fill the blanks in the chart. 2024 price 2030 price 2024 price 2018 price 4% inflation 4% inflation 2030 price 11% 11% Item inflation inflationarrow_forward
- Perform a vertical analysis for the balance sheet entry "Accounts Payable" given below (as a %). (Round your answer to one decimal place.) Liabilities and Owner's Equity Current Liabilities % Accounts Payable $11,200 Enter a number. Salaries Payable 3,200 Taxes Payable 4,000 Total Current Liabilities 18,400 Long-Term Liabilities Debenture Bond 17,000 Total Liabilities 35,400 Stockholder's Equity Retained Earnings 49,000 Total Liabilities and Stockholder's Equity $84,400 Submit Answerarrow_forwardSuppose admission to a movie cost $7.50 in 2005. What was its price in 1979 dollars? Assume that all prices have risen at the same rate as the CPI. The price was about $ in 1979. (Round to the nearest cent.) Average Annual Consumer Price Index (CPI) (1982- 1984=100) Year CPI Year CPI Year CPI 1976 56.9 1989 124.0 2001 177.1 1977 60.6 1990 130.7 2002 179.9 2003 184.0 1978 65.2 1991 136.2 1992 1979 72.6 140.3 2004 188.9 1980 82.4 1993 144.5 2005 90.9 1994 148.2 2006 2007 1981 1982 96.5 1983 99.6 1984 103.9 1985 107.6 1995 152.4 1996 156.9 2008 1997 160.5 2009 1998 163.0 2010 1986 109.6 1999 166.6 2011 1987 113.6 2000 172.2 2012 1988 118.3 195.3 201.6 207.3 215.3 214.5 218.1 224.9 229.6arrow_forwardChapter 7, Section 7.3, Question 022 You deposit $10,000 into a bank account. Use 4% as the annual interest rate to find the number of years before the account holds the following amounts. (a) $15,000 Round your answer to one decimal place. Your account will have $15,000 in years. (b) $20,000 Round your answer to one decimal place. Your account will have $20,000 years.arrow_forward
- Consider golfers who led the Professional Golfers' Association of America (PGA) in winnings at different points in time. Note that the winnings are nominal figures (unadjusted for inflation). To convert the original earnings of Casper, Nicklaus, and Kite, use the formula for converting dollar figures from an earlier era into year 2018 U.S. dollars. Using those figures, fill in the following table, making sure to round your responses to the nearest U.S. dollar. Nominal Winnings U.S. CPI Year Golfer (Dollars) (1983 = 100) Winnings in 2018 Dollars 1968 Billy Casper 205,169 34.8 1973 Jack Nicklaus 308,362 44.4 1981 Tom Kite 375,699 90.9 2018 Tiger Woods 5,443,841 251.1 5,443,841 True or False: According to the previous table, the golfer with the highest PGA winnings in nominal dollars is the same as the golfer with the highest PGA winnings after adjusting for inflation. True O False 100% 54°F Cloudy PrtSc Insert Delete ト\ C F5 F6 F7 F8 F9 F10 F11 F12 F4 & * Backspace Nur Lo 96. + II COarrow_forwardAs one of the loan officers for Grove Gate Bank, calculate the monthly principal and interest, PI (in $), using this table and the monthly PITI (in $) for the mortgage. (Round dollars to the nearest cent.) AmountFinanced InterestRate Termof Loan(years) MonthlyPI AnnualPropertyTax AnnualInsurance MonthlyPITI $220,000 7.50% 25 $6,573 $2,156arrow_forwardFind both the arithmetic growth rate and the geometric growth rate of the dividends for Excellent Pizza Franchises. (Click on the following icon in order to copy its contents into a spreadsheet.) 2010 2009 $7.89 2008 2004 $4.31 2007 $7.05 2006 2005 $5.78 Year 2001 2002 2003 Dividend $1.48 $2.12 $3.11 $6.06 $8.39 $7.02 What is the arithmetic growth rate of the dividends for Excellent Pizza Franchises? % (Round to two decimal places)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
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY