Question: The data in Federal Receipts represent federal receipts from 1978 through 2018 in billions of current dollars, from individual and corporate income tax, social insurance,

The data in Federal Receipts represent federal receipts from 1978 through 2018 in billions of current dollars, from individual and corporate income tax, social insurance, excise tax, estate and gift tax, customs duties, and federal reserve deposits.

a. Plot the series of data.

b. Compute a linear trend forecasting equation and plot the trend line.

c. What are your forecasts of the federal receipts for 201 9 and 2020?

d. What conclusions can you reach concerning the trend in federal receipts?

Step by Step Solution

★★★★★

3.39 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answers a To plot the series of data the following steps can be taken 1 Open Microsoft Excel and ent... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Statistics For Managers Using Microsoft Excel Questions!

The data in FedReceipt represent federal receipts from 1978 through 2009, in billions of current dollars, from individual and corporate income tax, social insurance, excise tax, estate and gift tax,...

The data in FedReceipt represent federal receipts from 1978 through 2014, in billions of current dollars, from individual and corporate income tax, social insurance, excise tax, estate and gift tax,...

The data in FedReceipt represent federal receipts from 1978 through 2016, in billions of current dollars, from individual and corporate income tax, social insurance, excise tax, estate and gift tax,...

The data in Fed Receipt represent federal receipts from 1978 through 2011, in billions of current dollars, from individual and corporate income tax, social insurance, excise tax, estate and gift tax,...

3. Government Finances - an Overview. The Excel spreadsheets PS3-datal.xls and PS3-data2.xls on Canvas provide data from the 2019 Economic Report of the President on government outlays (expenditures)...

.I SELECTED ! Schedule D:Net Long-Term Capital Gains or Losses only its a team work. I need in 3-4 just just scehdule D I. Title: Preparation of a Corporate Income Tax Return Using IRS Form 1120 II....

The data in FedReceipt represent federal receipts from 1978 through 2012, in billions of current dollars, from individual and corporate income tax, social insurance, excise tax, estate and gift tax,...

Question 1, 16.3.11 O HW Score: 0%, 0 of 3 points Part 1 of 5 O Points: 0 of 1 Save The linear trend forecasting equation for an annual time series containing 43 values (from 1962 to 2004) on net...

TAX FORM 1120 Candace Zachary is a small business owner who owns 100 percent of a corporation, Doc AlmightyA Professional Corporation, that operates a cash basis, calendar year, medical practice. The...

How thick must an iron shield be to reduce the exposure rate from a mono-directional beam of 1 MeV gamma rays of intensity 2x10 5 -rays/cm 2 -sec to 2.5 mR/hr?

Erindale Automotive borrowed $8000 from the Bank of Montreal on a demand note on May 10. Interest on the loan, calculated on the daily balance, is charged to Erindales current account on the 10th of...

7 - 3 ( OBJECTIVE 7 - 2 ) Describe what is meant by an audit procedure. Why is it important for audit procedures to be carefully worded?

b. Compose an argument supporting your viewpoint that your roommate should be the one to change her behavior. Similarly, compose an argument from the viewpoint of your roommate that you should be the...

The data stored in represents the amount of soft drink in a sample of 50 2-liter bottles. a. Construct a histogram and a percentage polygon. b. Construct a cumulative percentage polygon. c. On the...

The following is a set of data from a sample of n = 11 items: a. Construct a scatter plot. b. Is there a relationship between X and Y? Explain. X: 7 5 8 3 6 0 2 4 9 5 8 Y: 1 5 4 9 8 0 6 2 7 5 4

The following is a series of annual sales (in $millions) over an 11-year period (2001 to 2011): a. Construct a time-series plot. b. Does there appear to be any change in annual sales over time?...

Using which experimental design type can a researcher establish change? (Hint: time is essence for a change to be established) 1. After-only design II. One group before-after design III. Two group...

Blue Angel, Inc., a private firm in the holiday gift industry, is considering a new project. The company currently has a target debt-equity ratio of .45, but the industry target debt-equity ratio...

Hello, please advise, thank you. 11-1, My answer was 111,096.05 and 111.10 but wrong. 11-2, I put 316,000 and 316.5 but wrong. Q11-1 Q 11-2 North Star had the following data (thousands of dollars):...