EBK BASIC BUSINESS STATISTICS
14th Edition
ISBN: 9780134685168
Author: STEPHAN
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 16, Problem 14PS
a.
To determine
Plot the time series.
b.
To determine
Compute the linear trend forecasting equation and plot of the trend line.
c.
To determine
Determine the forecasted values of the federal receipts for the years 2017 and 2018.
d.
To determine
Determine the conclusion about the trend in federal receipts.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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…
What do the Forecast for each year add up to?
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
Chapter 16 Solutions
EBK BASIC BUSINESS STATISTICS
Ch. 16 - If you are using exponential smoothing for...Ch. 16 - Consider a nine-year moving average used to smooth...Ch. 16 - You are using exponential smoothing on an annual...Ch. 16 - Prob. 4PSCh. 16 - Prob. 5PSCh. 16 - How have stocks performed in the past? The...Ch. 16 - Prob. 7PSCh. 16 - Prob. 8PSCh. 16 - Prob. 9PSCh. 16 - Prob. 10PS
Ch. 16 - The linear trend forecasting equation for an...Ch. 16 - There has been much publicity about bounces paid...Ch. 16 - Prob. 13PSCh. 16 - Prob. 14PSCh. 16 - Prob. 15PSCh. 16 - The data shown in the following table and stored...Ch. 16 - Prob. 17PSCh. 16 - Prob. 18PSCh. 16 - Prob. 19PSCh. 16 - Prob. 20PSCh. 16 - Prob. 21PSCh. 16 - Prob. 22PSCh. 16 - You are given an annual time series with 40...Ch. 16 - Prob. 24PSCh. 16 - Prob. 25PSCh. 16 - Prob. 26PSCh. 16 - Prob. 27PSCh. 16 - Prob. 28PSCh. 16 - Prob. 29PSCh. 16 - Using the average baseball salary from 200 through...Ch. 16 - Using the yearly amount of solar power generated...Ch. 16 - The following residuals are from a linear trend...Ch. 16 - Prob. 33PSCh. 16 - Prob. 34PSCh. 16 - Prob. 35PSCh. 16 - Prob. 36PSCh. 16 - Prob. 37PSCh. 16 - Prob. 38PSCh. 16 - Prob. 39PSCh. 16 - Prob. 40PSCh. 16 - In forecasting daily time-series data, how many...Ch. 16 - In forecasting a quarterly time series over the...Ch. 16 - Prob. 43PSCh. 16 - Prob. 44PSCh. 16 - Are gasoline prices higher during the height of...Ch. 16 - Prob. 46PSCh. 16 - Prob. 47PSCh. 16 - The file Silver-Q contains the price in London for...Ch. 16 - Prob. 49PSCh. 16 - What is a time series?Ch. 16 - What are the different components of a time-series...Ch. 16 - What is the difference between moving average and...Ch. 16 - Prob. 53PSCh. 16 - How does the least-squares linear trend...Ch. 16 - How does autoregressive modelling differ from the...Ch. 16 - What are the different approaches to choosing an...Ch. 16 - What is the major difference between using SYX and...Ch. 16 - How does forecasting for monthly or quarterly data...Ch. 16 - Prob. 60PSCh. 16 - The monthly commercial and residential prices for...Ch. 16 - The data stored in McDonalds represent the gross...Ch. 16 - Teachers’ Retirement System of the City of New...Ch. 16 - Prob. 64PS
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
- Handwritten onlyarrow_forwardAssume figures were presented for the past 5 years on merchandise sold at Chicago department and discount stores ($ million). Sales in 2018 were $3,214; in 2017, $3,474; in 2016, $3,148;, in 2015, $3,212; and in 2014, $3,276. Using 2014 as the base year, complete a trend analysis. (Round your answers to the nearest whole percent.) 2018 2017 2016 2015 2014 $ 3,474 % $ 3,214 $ 3,148 $ 3,212 3,276 Sales Sales (in percent) % % % %arrow_forwardc. Predict sales in 15 years.arrow_forward
- John Kittle, an independent insurance agent, uses a five-year moving average to forecast the number of claims made in a single year for one of the large insurance companies he sells for. He has just discovered that a clerk in his employ incorrectly entered the number of claims made four years ago as 1,400 when it should have been 1,200.a. What adjustment should Mr. Kittle make in next year’s forecast to take into account the corrected value of the number of claims four years ago?b. Suppose that Mr. Kittle used simple exponential smoothing with a = .2instead of moving averages to determine his forecast. What adjustment is now required in next year’s forecast? (Note that you do not need to know the value of the forecast for next year in order to solve this problem.)arrow_forwardU.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 analysis of Earnings Per Share (EPS) is as follows: 2015: $5.70 2016: $3.30 2017: $6.21 2018: $6.20 2019: $4.91 a. What is the trend analysis for that EPS and why it is increasing and decreasing?arrow_forward
- A company estimates its sales for a particular year to be Rs. 24,00,000. The seasonal indices for sales are as follows: Seasonal Index 75 Month Seasonal Index Month July August September October 102 104 January February March 80 100 98 128 137 102 April May June November 82 119 December 73 Using this information, calculate estimates of monthly sales of the company, Assume that there is no trend). (Delhi Univ., B. Com., Hons., 1979arrow_forwardUsing the following time series data of U.S. new car sales ($ millions), respond to the following items. (The data is sourced from https://www.census.gov/retail/index.html#mrts. Find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts” to find the data for U.S. new car sales.). Year $ Sales (Millions) 2009 486,565 2010 549,473 2011 608,788 2012 672,550 2013 735,374 2014 785,142 2015 842,122 2016 877,743 2017 911,157 2018 943,538 b. Test for autocorrelation using the 0.05 significance level. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.) Year $ Sales (Millions) Predicted Residuals Lagged Residuals Squared Difference Squared Residuals 2009 486,565 2010 549,473 2011 608,788 2012 672,550 2013 735,374 2014 785,142 2015 842,122 2016 877,743 2017 911,157 2018 943,538…arrow_forwardUse the most accurate method to forecast the revenues of licenses, permits, and fees in Years 9, 10, and 11. Use the Year 8 actual figure instead of the forecast figure (Year 8 was $23,210,218). Also, consider three incremental changes in forecasting.arrow_forward
- Using the following time series data of U.S. new car sales ($ millions), respond to the following items. (The data is sourced from https://www.census.gov/retail/index.html#mrts. Find “Monthly Retail Trade Report," then select "Time Series/Trend Charts" to find the data for U.S. new car sales.). $ Sales (Millions) $ 486,565 Year 2009 549,473 608,790 672,550 735,374 785,142 842,120 877,743 911,157 943,538 2010 2011 2012 2013 2014 2015 2016 2017 2018 E Click here for the Excel Data File b. Test for autocorrelation using the 0.05 significance level. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.) Lagged Residuals Squared Difference Squared Residuals Year Sales Predicted Residuals 2009 $ 486,565 508,123.70 (21,558.70) 0.00 0.00 464,758,328.46 (10,455.50) (2,943.26) 2010 549,473 559,928.50 2011 608,790 611,733.30 2012 672,550 663,538.00 9,011.96 2013 735,374 715,342.80 20,031.19 2014 785.142 767,147.60 17,994.41 2015 842.120 818,952.40…arrow_forward3. Consider the following data, taken from the Federal Reserve Bank's Web site. Perform the graphing exercises below using a computer spreadsheet or presentation program. Unemployment rate Inflation (%) (% per year) 9.3 -0.4 9.6 1.6 8.9 3.2 8.1 2.1 7.4 1.5 6.2 1.6 5.3 0.1 4.9 1.3 4.4 2.1 3.9 2.4 Year 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 a. Looking at the data listed in the chart, can you detect a trend in the unemployment rate during these years? In the inflation rate? If so, what sort of trends do you see? Create a time-series graph for the unemployment rate during 2009-2018. b. Create a scatter-plot graph with the unemployment rate on the horizontal axis and inflation on the vertical axis. d. C. Using your graph in part (c), do the two variables seem to have an empirical relationship during this period, or do the points seem to be randomly scattered? If there appears to be an empirical relationship, is it inverse or direct?arrow_forwardThe 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.)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
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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