APPLIED STAT.IN BUS.+ECONOMICS
6th Edition
ISBN: 9781259957598
Author: DOANE
Publisher: RENT MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 14, Problem 31CE
(a) Plot the data on revolving credit (credit cards and home equity lines of credit are the two major types of revolving credit). (b) Use MegaStat or Minitab to calculate seasonal indexes and trend. Is there a trend? (c) Which months have the most borrowing? The least? Is this logical? (d) Discuss anything unusual in the shape of the trend that might make forecasting difficult.
Source: www.federalreserve.gov.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What do the Forecast for each year add up to?
Use the accompanying data table regarding retirement funds. Complete parts (a) through (d) below.
a. Construct a growth and value table that tabulates type, market cap, risk,and rating.
The Bureau of Transportation Statistics conducts a quarterly survey to monitor domestic and international airfares. Here are
the average airfares (inflation-adjusted to 2018 dollars) for U.S. domestic flights for 2004 through 2018.
Airfare Year Airfare Year
Year
2004 $402.26 2009 $359.91 2014
2005 $391.50 2010 $383.48 2015 $395.70
2006 $405.48 2011 $402.45 2016 $361.94
2007 $390.30 2012 $406.13 2017 $352.85
2008 $400.27 2013 $407.99 2018 $346.49
Airfare
$411.67
Hand calculate forecasts for the time series using an exponential smoothing model with the smoothing constant w = 0.2.
Provide a forecast for the average U.S. domestic airfare for 2019.
(Use decimal notation. Give your answer to two decimal places.)
Chapter 14 Solutions
APPLIED STAT.IN BUS.+ECONOMICS
Ch. 14.2 - (a) Make an Excel graph of the data on the number...Ch. 14.2 - Prob. 3SECh. 14.2 - Prob. 4SECh. 14.2 - Prob. 5SECh. 14.4 - (a) Make an Excel line graph of the exchange rate...Ch. 14.5 - (a) Make an Excel line graph of the following bond...Ch. 14 - Explain the difference between (a) stocks and...Ch. 14 - (a) What is periodicity? (b) Give original...Ch. 14 - (a) What are the distinguishing features of each...Ch. 14 - Name four criteria for assessing a trend forecast.
Ch. 14 - Name two advantages and two disadvantages of each...Ch. 14 - When would the exponential trend model be...Ch. 14 - Explain how to obtain the compound percent growth...Ch. 14 - (a) When might a quadratic model be useful? (b)...Ch. 14 - Name five measures of fit for a trend, and state...Ch. 14 - Prob. 10CRCh. 14 - Prob. 11CRCh. 14 - Prob. 12CRCh. 14 - (a) Why is seasonality irrelevant for annual data?...Ch. 14 - Prob. 14CRCh. 14 - (a) Explain how seasonal binaries can be used to...Ch. 14 - What is the purpose of index numbers?Ch. 14 - (a) Make a line chart for JetBlues revenue. (b)...Ch. 14 - (a) Plot both Swiss watch time series on the same...Ch. 14 - (a) Make a line graph of the U.S. civilian labor...Ch. 14 - (a) Plot the voter participation rate. (b)...Ch. 14 - For each of the following fitted trends, make a...Ch. 14 - (a) Make a line graph of consumer credit...Ch. 14 - (a) Plot the data on U.S. general aviation...Ch. 14 - Prob. 17CECh. 14 - (a) Plot either receipts and outlays or federal...Ch. 14 - Prob. 19CECh. 14 - (a) Plot the data on leisure and hospitality...Ch. 14 - Prob. 21CECh. 14 - Prob. 22CECh. 14 - (a) Plot the data on skier/snowboard visits. (b)...Ch. 14 - Prob. 24CECh. 14 - (a) Plot U.S. petroleum imports on a graph. (b)...Ch. 14 - (a) Make a line chart and fit an m-period moving...Ch. 14 - Refer to exercise 14.26. (a) Plot the dollar/pound...Ch. 14 - (a) Plot the data on natural gas bills. (b) Can...Ch. 14 - (a) Plot the data on air travel delays. (b) Can...Ch. 14 - (a) Plot the data on airplane shipments. (b) Can...Ch. 14 - (a) Plot the data on revolving credit (credit...Ch. 14 - The following seasonal regression was fitted with...Ch. 14 - The following seasonal regression was fitted with...
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
- Cryptocurrencies have rapidly become an important alternative to traditional currencies for many types of transactions. Etherium, one of the most prominent cryptocurrencies, has rapidly appreciated in value. Daily Etherium trading information for the first 332 days of 2021. It includes the following variables: Date Day – Day of the year, used to assess trend over time Volume (US $) – Daily trading volume Opening Price (US $) – Opening price for daily trading Price Change (US $) – Daily change in price from opening to close 1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the alternative hypothesis that Volume has a linear relationship to Price Change. Specifically, what are the test statistic and the p-value for that test statistic? For α = .05, what do you conclude about the relationship between the variables? (reminder: the T.DIST.2T function requires input of a positive test statistic)arrow_forwardUse the dataset to complete the EXACT five-number summary of the dollar values of the LEXCX mutual fund. Do not round your results even if they go beyond two decimal places. For any calculated values, show your work in the table along with your answer.arrow_forwardOfficial unemployment rates for the U.S. population are reportedon a monthly basis by the Bureau of Labor Statistics.For the period October, 2011, through January, 2012, theofficial unemployment rates were 8.9% (Oct.), 8.7% (Nov.),8.5% (Dec.), and 8.3% (Jan.). (Source: U.S. Bureau of LaborStatistics, www.bls.gov.) If the unemployment rateswere to continue to decrease following a linear model,(a) predict the unemployment rate on January, 2013.(b) predict when the United States would reach a zero unemploymentrate.arrow_forward
- 5arrow_forwardIn Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018. Date Revenue February/14 3,519,756 March/14 4,092,575 April/14 4,980,992 May/14 5,273,355 June/14 5,715,707 July/14 6,522,085 August/14 7,407,450 September/14 7,741,167 October/14 7,232,870 November/14 7,642,800 December/14 7,465,568 January/15 8,558,141 February/15 8,802,295 March/15 9,099,395 April/15 9,979,643 May/15 10,617,311 June/15 11,326,452 July/15 10,856,584 August/15 12,811,437 September/15 13,181,758 October/15 11,656,736 November/15 11,290,012 December/15 12,231,410 January/16 13,247,434 February/16…arrow_forwarda) The cost of an 'average' television has fallen over recent years. 2017 2018 2019 2020 £950 £820 £740 £630 Convert the costs into an index using 2017 as the base year.arrow_forward
- Suppose that the Producer Price Index and the sales of Hoskin’s Wholesale Distributors for 2006 and 2018 are: What are Hoskin's real sales (also called deflated sales) for the 2 years? (Round your answers to the nearest whole dollar.)arrow_forwardCreate a line chart for the closing price for all years and a stock chart for the high/low/close prices for 2011 through 2012 in the accompanying s&p 500 data. Then choose the correct sock chart for the high/low/close prices for 2011 through 2012arrow_forwardThe following table gives the average monthly exchange rate between the U.S. dollar and the euro for 2009. It shows that 1 euro was equivalent to 1.289 U.S. dollars in January 2009. Develop a trend line that could be used to predict the exchange rate for 2010. Use this model to predict the exchange rate for January 2010 and February 2010. MONTH ______________________ EXCHANGE RATE January ....................................... 1.289 February ...................................... 1.324 March ......................................... 1.321 April .......................................... 1.317 May ........................................... 1.280 June ........................................... 1.254 July ........................................... 1.230 August ....................................... 1.240 September ................................... 1.287 October ..................................... 1.298 November .................................. 1.283 December…arrow_forward
- Explain Reporting the Funded Status of the Pension Plan.arrow_forward1. If a stock market index goes up 70% of the time, what percent of the time does it go down?arrow_forwardIn 2014, the median salary nationwide for a high school teacher was $56,310 per year. The median annual wage for all workers was $35,540.SOURCE: United States. Department of Labor. "High School Teachers." Occupational Outlook Handbook. 17 Dec. 2015. Web. 7 March 2016. Suppose a worker makes $29,000 in wages per year. Find the percent increase in salary the worker can expect if he/she trains to be a teacher and can expect to earn a salary of $40,000. Enter your response to the nearest 0.1% %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
Which is the best chart: Selecting among 14 types of charts Part II; Author: 365 Data Science;https://www.youtube.com/watch?v=qGaIB-bRn-A;License: Standard YouTube License, CC-BY