STATISTICS F/BUSINESS+ECONOMICS-TEXT
13th Edition
ISBN: 9781305881884
Author: Anderson
Publisher: CENGAGE L
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 the linear trend equation for the data.
c.
To determine
Calculate the forecast value for period 25.
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
In 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…
Chapter 17 Solutions
STATISTICS F/BUSINESS+ECONOMICS-TEXT
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 - The Seneca Childrens Fund (SCF) is a local charity...Ch. 17.4 - The following table shows Googles annual revenue...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Quarterly revenue ( millions) for Twitter for the...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 - The data contained in the DATAfile named CrudeCost...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 - 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
- U.S. Civilian Labor Force (thousands) Year Labor Force Year Labor Force 2007 153,918 2012 155,628 2008 154,655 2013 155,151 2009 153,111 2014 156,238 2010 153,650 2015 157,957 2011 153,995 2016 159,640 1. Fit three trend models: linear, exponential, and quadratic. Which model would offer the most believable forecasts? 2. Make forecasts using the following fitted trend models for years 2017-2019. t Exponential 11 12 13arrow_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_forwardThis is for question B-Carrow_forward
- 1. 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_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_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
- Forecasting Methods: Perform Trend Series Analysis (sales projection for the year 10, 12 and 17) Make based on the sales data below:Year 1: 24,333; Year 2: 33,524; Year 3: 26,778; Year 4: 30,567; Year 5: 27,564; Year 6: 24,555; Year 7: 21,777 and Year 8: 25,669.arrow_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_forwardWhen we use the scatter chart and trend line, what is shown in the graph? I. The equation for the trend line is displayed in the graph. II. The trend line is displayed on the graph. III. The values are scattered on the chart. a.) I and II b.) I and III c.) II and III d.) I, II, IIIarrow_forward
- Choose 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_forwardSolve with the help of grapharrow_forwardThe 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_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
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
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