Statistics for Business & Economics, Revised (MindTap Course List)
12th Edition
ISBN: 9781285846323
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 17.4, Problem 21E
a.
To determine
Construct the time series plot.
Explain the type of pattern.
b.
To determine
Calculate linear trend equation for data.
c.
To determine
Calculate the forecast for 2012.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
the costello Music company has been in business for five years. during that time, salesof pianos increased from 12 units in the first year to 76 units in the most recent year. Fredcostello, the firm’s owner, wants to develop a forecast of piano sales for the coming year.the historical data follow.Year 1 2 3 4 5Sales 12 28 34 50 76a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for the time series. What is the average increase insales that the firm has been realizing per year?c. Forecast sales for years 6 and 7.
The table below is the total assets owned by Sharia Commercial Banks (BUS) in 2011 - 2020 obtained from the publication of Sharia Banking Statistics several years. From the data above answer the question below:
a. Define trend equations and explain what they mean.
b. Draw trend point and line charts
This is for question B-C
Chapter 17 Solutions
Statistics for Business & Economics, Revised (MindTap Course List)
Ch. 17.2 - Consider the following time series data. Week 1 2...Ch. 17.2 - Refer to the time series data in exercise 1. Using...Ch. 17.2 - Exercises 1 and 2 used different forecasting...Ch. 17.2 - Consider the following time series data. Month 1 2...Ch. 17.3 - Consider the following time series data. Week 1 2...Ch. 17.3 - Consider the following time series data. Month 1 2...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Refer again to the gasoline sales time series data...Ch. 17.3 - With the gasoline time series data from Table...Ch. 17.3 - 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 - The U.S. Census Bureau tracks the median price for...Ch. 17.4 - Consider the following time series data. a....Ch. 17.4 - Prob. 18ECh. 17.4 - Consider the following time series. a. Construct a...Ch. 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 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Automobile unit sales at B. J. Scott Motors, Inc.,...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - Prob. 27ECh. 17.5 - Consider the following time series. a. Construct a...Ch. 17.5 - Consider the following time series data. a....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 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Consider the following time series data. a....Ch. 17.6 - Refer to exercise 35. a. 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 - Prob. 44SECh. 17 - Prob. 45SECh. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Canton Supplies, Inc., is a service firm that...Ch. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Hudson Marine has been an authorized dealer for CD...Ch. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise 53....Ch. 17 - Refer to the Hudson Marine data in exercise 53. a....Ch. 17 - Forecasting Food and Beverage Sales The Vintage...Ch. 17 - Forecasting Lost Sales The Carlson Department...
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
- Find the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardIn 2011 home prices and mortgage rates dropped so low that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for 10 markets and the monthly mortgage on the median priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 26–27, 2011).Click on the datafile logo to reference the data. Enter negative values as negative numbers. a. Develop the estimated regression equation that can be used to predict the monthly mortgage given the average asking rent (to 2 decimals).The regression equation is:Mortgage ($) = + Rent ($)arrow_forward1. Perform a Trend and Seasonal analysis with the following data. Include the trend formulaand the multiplicative indices for the seasons. Using the model forecast sales for the nextyear (all 4 seasons of year 4).Year Season Sales1 sp 1401 su 501 w 1301 f 5202 sp 2002 su 1102 w 1902 f 5503 sp 2603 su 2203 w 2103 f 570arrow_forward
- 5. Tabular form of data presentation is also termed as table. A. Frequency distribution B. Tabular C. Data D. Graphicalarrow_forward1. Give below is the data on production of a company (in lakhs). Year: 1983 1984 1985 1986 1987 1988 1989 Production: 15 14 18 20 17 24 27 Fit the linear trend. Compute the trend values for each year. Estimate the production for уear 1991.arrow_forward3) U.S. Health care expenditures. Because the over-65 population is growing more rapidly in the next few decades health care spending is expected to increase significantly in the next few decades. The following table gives the projected US health care expenditure (in trillions) from 2008 to 2013 Year 2008 2009 2010 2011 2012 2012 Expenditure 2.34 2.47 2.57 2.70 2.85 3.02 a) Draw a scatter diagram for this data. Use “Years since 2008” on the x-axis. Make sure the scatter diagram includes all required elements (axes labels, title, and appropriate scale) b) Use the points for 2009 and 2011 to find an equation of a line modeling this situation c) Use linear regression to find an equation of a line modeling this situation d) Use the equation in b to predict expenditures in 2016 and do this again for the equation in part c. What is the absolute and percentage difference between the two equations (use the equation in c as the base equation in the % calculation) e) Now use…arrow_forward
- Name the forecasting methodsarrow_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_forwardChoose a variable (column) and exhibit the following: 1. Stem and Leaf diagram 2. FDT 3. Graphs of the FDT 4. Descriptive narratives pertaining to 1, 2 and 3. 1 Day 1 Dav 3 Dav 3 Day Predicted High Predicted Low Predicted High Predicted Low 79 52 86 63 79 83 59 38 3 印 乃 75 8 7 8 7花5刀2448 77 77 5 Day 5 Dav Predicted High Predicted Low 7722222822288 5 6 40 42arrow_forward
- The accompanying table gives the population (in hundred thousands) and number of people not covered by health insurance (in hundred thousands) for a certain country. Find the percentage of people not covered by health insurance for each of the given years and describe the trend. Year Uninsured Total Population 1990 35,513 251,867 2000 36,872 281,466 2015 29,470 313,513 ..... Find the percentage of people not covered by health insurance for each of the given years. Year % Uninsured 1990 % 2000 2015 % (Round to one decimal place as needed.) -....arrow_forwardSuppose the table below gives the average tuition and fees at 2-year and 4-year state schools in a particular state. Values are adjusted to 2019 dollars. Academic Year 4-year state school 2-year state school 2005-06 $5,904 $2,661 2006-07 $6,066 $2,539 2007-08 $6,289 $2,604 2008-09 $7,222 $2,901 2009-10 $7,738 $3,065 2010-11 $8,035 $3,117 2011-12 $8,154 $3,108 2012-13 $8,497 $3,075 2013-14 $8,578 $3,025 2014-15 $9,390 $3,326 2015-16 $10,004 $3,504 2016-17 $10,474 $3,663 2017-18 $10,789 $3,830 2018-19 $10,874 $3,859 2019-20 $10,900 $3,907 Here is a graph of the information from the table. a. What is the absolute change in tuition and fees at this state's four-year institutions from 2005-06 to 2019-20? b. What is the relative change in tuition and fees at this state's four-year institutions from 2005-06 to 2019-20? Round to the nearest whole percentage…arrow_forward6. The annual population of Afghanistan is available in the global economy data set. a. Plot the data and comment on its features. Can you observe the effect of the Soviet- Afghan war? b. Fit a linear trend model and compare this to a piecewise linear trend model with knots at 1980 and 1989. c. Generate forecasts from these two models for the five years after the end of the data, and comment on the results.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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