APPLIED STAT.IN BUS.+ECONOMICS
6th Edition
ISBN: 9781259957598
Author: DOANE
Publisher: RENT MCG
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 14, Problem 24CE
a.
To determine
Sketch the graph for both men’s and women’s winning times on the same graph.
b.
To determine
Fit the linear trend model for men and women series.
c.
To determine
Forecast the trend graphically to 2040 by using Excel’s option.
Check whether the times will converge eventually or not.
d.
To determine
Solve x by setting the fitted trend equations equally and convert it to a year.
Check whether the result is plausible.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
hudson Marine has been an authorized dealer for c&d marine radios for the past sevenyears. the following table reports the number of radios sold each year.Year 1 2 3 4 5 6 7Number Sold 35 50 75 90 105 110 130a. construct a time series plot. does a linear trend appear to be present?b. Using Minitab or excel, develop a linear trend equation for this time series.c. Use the linear trend equation developed in part (b) to develop a forecast for annualsales in year 8.
A coffee shop owner wants to estimate demand for the next four quarters for hot chocolate.
Sales data consist of trend and seasonality. Quarter relatives are 1.06 for the first quarter, 1.03
for the second quarter, 0.61 for the third quarter, and 1.30 for the fourth quarter. Using the
appropriate values of quarter relatives and the equation Ft = 187 +9.2t for the trend
component, estimate demand for periods 9-12. (Round all calculations to two decimal points.
Demand Period 9
Demand Period 10
Demand Period 11.
Demand Period 12
Monthly sales have been found to follow a linear trend of y = 10 + 8x, where y is the number of items sold and x is the number of the month. Monthly deviations from the trend have been calculated and follow an additive model. In month 12, the seasonal variation is estimated to be -6.
What is the forecasted number of items to be sold in month 12?
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
- The US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the trend appearslinear. Ifso, and assuming the trend continues, in what year will imports exceed 12,000 hectoliters?arrow_forwardThe U.S. Census tracks the percentage of persons 25 years or older who are college graduates. That data forseveral years is given in Table 4[14]. Determine whether the trend appears linear. If so, and assuming the trendcontinues. in what year will the percentage exceed 35%?arrow_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
- Eloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's been tracking her page count at the end of each business day to see if she's on track. Use Excel to fit a trendline to Eloise's data to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next Friday? Assume she works only on weekdays. Day Pages Monday 425 Tuesday 431 Wednesday 449 Thursday 464 Friday 471 A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line? The slope is The intercept is B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday? Yesarrow_forwardConsider the following estimated trend models. Use them to make a forecast for t= 22. a. Linear Trend: ý = 12.42 + 1.13t (Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) b. Quadratic Trend: û = 18.04 + 1.04t - 0.02t2 (Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) c. Exponential Trend: In(y) = 1.6 + 0.08t, se = 0.01 (Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.)arrow_forwardThe accompanying data represent health care expenditures per capita (per person) as a percentage of the U.S. gross domestic product (GDP) from 2007 to 2013. Gross domestic product is the total value of all goods and services created during the course of the year Complete parts (a) through (c) below. Click the icon to view the data table. (a) Construct a time-series plot that a politician would create to support the position that health care expenditures are increasing and must be slowed. Choose the correct graph below OD. O C. OB OA A Q A Q Q 25,000+ 11,000 Q Q 3 2 G HIER 11200 2H 7,000++ C 2013 of + 2013 2007 2007 Year Year Year (b) Construct a time-series plot that the health care industry would create to refute the opinion of the politician. Choose the correct graph below. OB. O C. O A. A Q A Q 11,000 Q (C) 7,000+ 201 20 7.000+++++++* 2007 2007 2013 2013 Year Year (c) Explain how different measures may be used to support two completely different positions. Choose the correct answer…arrow_forward
- The diagram below illustrates the number of moose (red curve) and wolves (blue curve) between 1960 and 2015 in the Isle Royale National Park (USA). It does not show the actual data, but it approximates the trend. The vertical scale is from 0 to 50 for wolves and 0 to 2500 for moose. In certain years the moose population was decreasing and the wolf population was increasing. Which of the options below represents such a year? A. 1980 B. 1970 C. 2000 D. 2010arrow_forwardA statistical program is recommended. Suppose the following table shows a company's annual revenue (in billions of dollars) for 2012 (period 1) to 2017 (period 6). Year Period Sale ($ Billions) 2012 2013 2014 2015 2016 2017 1 2 3 4 5 6 1.54 1.83 2.4 3.17 3.58 4.14arrow_forwardAnita Limited has shared their annual sales revenue over the last 6 financial years from 2015 to 2020. Year Sales ($ 000) 2015 4500 2016 5100 2017 4900 2018 5400 2019 5670 2020 6000 You are required to; a) Using linear trend equation forecast the sales revenue of Anita Limited for 2021. Note: See the formula sheet on the next page. P.S.: I can't attach the formula sheet in this because it has variuos symbols, such as Sigma, log, x value etc. I uploaded the formula sheet and the question as well in the chat box. Please let me know if you need any more information.arrow_forward
- 11-8. The linear trend of sales of a company is Rs. 6,50,000 in 1995 and it rises by Rs. 16,500 per year. pected sales in 1998. in 19999998.arrow_forwardSix years of quarterly data of a seasonally adjusted series are used to estimate a linear trend model as T t=181.60 + 1.44t. In addition, quarterly seasonal indices are calculated as § 1= 0.85, § 2= 0.91, Ŝ 3 = 116, and § 4= 119. a-1. Interpret the first quarterly index. In other words, what is the value of the series in the first quarter as compared to the average? 15% above O 85% below O 15% below 85% above a-2. Interpret the fourth quarterly index. In other words, what is the value of the series in the fourth quarter as compared to the average? O 81% above O 19% above 19% below O 81% below b. Make a forecast for all four quarters of next year. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Quarter 1 Quarter 2 Quarter 3 Quarter 4arrow_forwardA stock has monthly returns of 9%, 22%, 15%, and 28%. What is the stock's geometric average return?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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