Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

ENGR Econ

Check File uploaded

(1) Check Econ Instruction file.

(2) I completed the data spreadsheet


Project Instructions

The assignment is to populate an Excel Spreadsheet with charts and write no more than two pages related to the data. Namely, identify any economic trends (desirable or undesirable and write what the team would do to enhance or reverse the trends. Do not describe the data as that would be redundant since the charts are available. Also, do not write about a topic other than what is derived from the charts.

Grading will be based on how well each team follows instructions as well as on spelling, grammar, logic and the ability to be concise. (This is not a political exercise so it will not matter should a position lean one direction or another.)

This is a team exercise and will require each student to confer with the team to meet the assignment. It is up to each team to determine when and how to meet outside of class. Please advise should a team require support with technology or accessibility.

An Excel Spreadsheet Template with Charts will be provided for each team to populate.

Assignment:

1. Populate the attached excel spreadsheet displaying the GDP of the US for each year since 1900 (total government spending – federal, state and local)

2. Add the total government expenditures

3. Add the values of the
total expenditures for defense, education, entitlements (pensions, healthcare, and welfare)

4. Add the total interest on the debt

5. Add the gross public debt

6. Add the unemployment rates since 1948 and inflation rate (CPI) since 1913

7. Ensure that the populated data is displayed on the charts on the tabs

8. Create any other charts that may support your summary

9. Review the Excel data and write

no more than
two pages on what you perceive as the largest problems/opportunities and your proposed solutions in
Microsoft Word

10. Turn in the package on the date due (
staple the Microsoft Word portion in front of the Excel Spreadsheet and Charts) as well as sending me

one
email with the package (one
Microsoft Word and
Microsoft Excel) attached. I will deduct 5 points for late emails and 10 points for missing email packages –

any portion

.

Spending data is to be taken from:


For spending – select $ bln 2017, select years
1900 to 2022, you can add up to 5 categories, select total, and then download CVS file or download tabbed and copy values into spreadsheet. Continue until all categories are complete.

Employment and CPI data is to be taken from:

For unemployment, go to Data Tools, select “Top Picks, under “Unemployment”, Select
Labor Force Statistics including the National Unemployment Rate”, Select “Unemployment Rate (Seasonally Adjusted) – LNS14000000”, then select “retrieve data”. Then select
1948 to 2022 in output options and select “go”. You will need to annualize the data.

Participation rate is also found on this website – search participation and retrieve data as you did for unemployment - LNS11300000.

On the CPI link, go to Data Tools, select “Top Picks – All Urban Consumers”, under “Consumer Price Index”, check “U.S. All items, 1982-84=100 – CUUR0000SA0”, then select “retrieve data”. Then select
1913 to 2022 in output options and select “go”. You will need to annualize the data.

Note – all percentages of spending to GDP will be populated automatically

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Week 7 Discussion- Delivery of Healthcare

Continuum of Care Scenario: Team B Discussion 1 In this Discussion, you will continue to analyze your continuum of care scenario using the value-based care model, the IOM Aims, and a country comparison. You will be placed into a team and share your suggestions for improvements. Then, you will provide

Week 7 Discussion- Managerial Finance

Using Financial Forecast  Financial forecasts are crucial for businesses to make informed decisions, allocate resources effectively, and measure performance. They are typically based on historical data, which can make it challenging to predict sudden changes in market conditions or business operations. To mitigate financial risk, managers can employ strategies such

week 5

 overall business strategy your canvas depicts.  Assignment Directions: GOAL: Build on your work with your business model canvas by discussing the patterns, the design, and the overall business strategy it illustrates.  Introduction: Using the week 5 Learning Material in the Content area (coupled with the other course resources), examine and discuss

BUSN100

See attached. Instructions For this assignment just type the transcript Assignment Instruction: You are the public information officer (PIO) for a small company, responsible for communicating and distributing information for your organization. Prompt In this scenario, an unexpected incident has occurred within your local community, impacting the safety of employees

MKTG201

see attached Instructions: EOS Brand Assignment Directions: Objective:  For this assignment, you will explore how brands implement Integrated Marketing Communications (IMC) by evaluating their ability to deliver a consistent message across various marketing channels. Start by selecting a brand that interests you; this can be a well-known company or a

Unit V

see attached Post 1: Initial post addressing the discussion board topic • Your initial post should be at least 300 words in length. • Your initial post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or quoted material.

Is Royal Ludo a good first online game?

  Royal Ludo stands out as a welcoming entry point into online real-money gaming, especially for those wary of overly complex platforms. It emphasizes simplicity, familiarity, and low-risk learning. With easy   <a href=” Ludo download</a> options and cross-device compatibility, it’s accessible to everyone.  

How Do Pattern Recognition and Timing Affect Success in Stock Trading

 How does understanding market behavior in sideways trends (like TTQA shifts in sentiment and large vs. small fund activity) compare to recognizing patterns and timing in a game like [url= surfers[/url]  , where success depends on reading the level and reacting at the right moment? 

Create a Shipping list for the items bellow. It needs to be editable

   six-bedroom household shipment.  List of items in shipping Container: * Two (2) dining table sets * Three (3) living room couch sets * Washer and dryer * Two (2) master bedroom furniture sets * Four (4) regular bedroom furniture sets , (2) Kids’ basketball court  10 Children’s toys and

Week 6 Discussion- Delivery of Healthcare

Continuum of Care Scenario: Team A Discussion 3 For this team Discussion, you will have the opportunity to review the work of others and provide them with peer-reviewed feedback, as well as consider how their continuum of care might be improved. Further, you will be able to compare and contrast

Business Finance – Management Week 5 Assignment- Managerial Finance

Module 2 Assignment: Financial Health Assessment: Barry Computer Company Report prepared by: Replace this text with your name. Date: Replace this text with the submission date. Walden University MBAX 6070: Managerial Finance 1 Part 1: Financial Information Replace this text with introductory information. Add or remove headings as necessary. [Heading]

Week 8 MGMT601

 align and discuss the implications for organizational commitment   Assignment Directions:  You will conduct an interview with a colleague or contact currently employed, focusing on their perceptions of the psychological contract with their employer. You will then write a 3–5-page report outlining the unwritten expectations from both the employee and

Week 8

 a major impact on the organization’s ability to operate globally.   Assignment Directions This assignment assesses CO-1, CO-2, CO-3, CO-4, CO-5.  [content page] You will conduct an organizational global readiness for your organization or one you are interested in working for. You will include and/or assess the following: 1. Organizational

Week 5 Discussion- Delivery of Healthcare

Continuum of Care Scenario: Team A Discussion 2  For this team Discussion, you will have the opportunity to review the work of others and provide them with peer-reviewed feedback, as well as consider how their continuum of care might be improved. Further, you will be able to compare and contrast

Financial Forecasting

Financial Forecasting project, Complete the Income Statement and Balance Sheet on the appropriate tabs in the Financial Forecasting Template, using the downloaded data. Calculate the expenses to determine what will change and what will remain the same. Summarize your rationale, within each line item expense.

Future Recommendations for Leaders in the 21st Century

Planning and Decision-Making in Public Health Organizations, Public Health and the Fundamentals of Managing It, Ethics for Public Health Managers and Workforce Diversity Pick one interest to discuss….. Reflect on an aspect(s) of this course that was or were of particular interest to you or might have implications for choices

FINCB/571: Corporate Finance Competency 3 – Assessment

   Course Title: Corporate Finance Competency Assessment Title: Financial Plan Total Number of Points: 100 Assignment Directions Review the company you chose to work with in Competencies 1 and 2. Describe the business, including the type of business. Create the business case: • Determine why funding is needed for the

BUSINESS( NO PLAGARISM A+ WORK, ON TIME)

tutor discussion & assignment 2 Week 7 Assignment Name University Course BUSN604: Fundamentals of Business Analysis Instructor Date Introduction Introduce the topic for this paper. Discuss the how, what, why, where, who as you determine the feasibility of investing in a new product line in a foreign country, or keeping