Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Step-by-Step Guide: “Tariffs, Trade, and Trouble” STEP 1: Open and Explore the Dataset 1. Open the Excel file titled Tariff -Recession Dataset.xlsx. 2. Review the columns: o Real GDP Growth (%) o Un

Step-by-Step Guide: “Tariffs, Trade, and Trouble”

STEP 1: Open and Explore the Dataset

1. Open the Excel file titled Tariff -Recession Dataset.xlsx.

2. Review the columns:

o Real GDP Growth (%)

o Unemployment Rate (%)

o Consumer Price Index (CPI)

o Exports / Imports / Net Exports

o Manufacturing Employment

o Budget Deficit

o Consumer Confidence Index

3. Identify the timeline: Q1 2014 – Q4 2024 (44 quarters).

STEP 2: Build Charts in Excel

Create the following line graphs (Insert → Chart → Line or Scatter with lines):

1. Real GDP Growth over Time

· X-axis: Quarter

· Y-axis: Real GDP Growth (%)

2. Net Exports over Time

· X-axis: Quarter

· Y-axis: Net Exports (Exports – Imports)

3. Unemployment Rate over Time

· X-axis: Quarter

· Y-axis: Unemployment Rate (%)

4. Consumer Confidence Index over Time

· X-axis: Quarter

· Y-axis: Confidence Index

Make sure to:

· Label each chart clearly

· Add a descriptive chart title

· Format axes and use gridlines for clarity

STEP 3: Identify Pre-Tariff vs. Post-Tariff Periods

Pre-Tariff Period: Q1 2014 – Q4 2024 Simulated Post-Tariff Period: Q1 2026 – Q4 2026 (students should estimate values or use projections)

Note: In reality, we don’t have actual post-tariff data. You must simulate what could happen based on economic theory and observed pre-tariff trends.

STEP 4: Perform Key Calculations in Excel

Use formulas or summary rows to:

1. Calculate average GDP growth rate:

o Pre-tariff (Q1 2014–Q4 2024)

o Simulated post-tariff (your estimates)

2. Calculate change in manufacturing employment:

o Compare beginning vs. end of timeline

3. Compare net exports and consumer confidence index:

o Look for significant upward/downward shifts

Use =AVERAGE(range), =MAX(), =MIN(), or create your own columns to calculate changes over time.

STEP 5: Analyze Trends and Write Your Findings

In a short written analysis (1 page or less):

· Identify what changed after the tariffs (real or simulated)

· Discuss if the economy is weakening (signs: lower GDP, higher unemployment, lower confidence, shrinking net exports)

· Make an evidence-based conclusion:

o Is the economy heading toward recession?

o What indicators support your reasoning?

STEP 6: Make a Recommendation

Based on your findings, recommend one of the following:

· Continue the tariff policy

· Modify the tariff policy

· Repeal the tariff policy

Justify your recommendation with data + economic reasoning (e.g., if GDP is falling and unemployment rising, it may point to recession).

STEP 7: Create Final Deliverables

You must submit:

1. Excel File with:

o All graphs

o Calculations

o Clearly labeled sheet(s)

2. Executive Summary:

o One-page report with:

§ Graph screenshots

§ Summary of findings

§ Policy recommendation

Bonus Tips:

· Use color-coding in Excel to highlight key changes

· Double-check that your graphs are easy to interpret

· Practice summarizing your findings in simple, clear language

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Course Textbook(s) McEachern, W. A. (2019). Macro ECON6: Principles of macroeconomics (6th ed.). Cengage Learning. https://online.vitalsource.com/#/books/9798214347905 This assignment focuses on dem

Course Textbook(s) McEachern, W. A. (2019). Macro ECON6: Principles of macroeconomics (6th ed.). Cengage Learning. https://online.vitalsource.com/#/books/9798214347905 This assignment focuses on demand, supply, and equilibrium. Let’s start with the basics. Begin your essay by providing the following information. Explain the difference between a movement along demand and supply curves and a

DFA Closure: 1.4 c and f. Do union and intersection for each (use cross product algorithm) Each of the following languages is the intersection of two simpler languages. In each part, construct DFAs fo

DFA Closure: 1.4 c and f. Do union and intersection for each (use cross product algorithm) Each of the following languages is the intersection of two simpler languages. In each part, construct DFAs for the simpler languages, then combine them using the construction discussed in footnote 3 (page 46) to

Read the following article about globalization and write a two to three- page paper explaining your thoughts and what you learned. Your paper should cover the following points: 1. What is globalizatio

Read the following article about globalization and write a two to three-page paper explaining your thoughts and what you learned. Your papershould cover the following points:1. What is globalization?2. What are the central points of each section?3. What do you think about globalization? (You can relate it toreal world events

In this exercise, you will demonstrate your ability to find macroeconomic data from public sources and display it in an Excel spreadsheet. Start by choosing one of these three macroeconomic variables:

In this exercise, you will demonstrate your ability to find macroeconomic data from public sources and display it in an Excel spreadsheet. Start by choosing one of these three macroeconomic variables: Real GDP, the unemployment rate, or the inflation rate. Follow these instructions to find numbers for your macroeconomic variable

Overview It is important to be able to convey your understanding of macroeconomic concepts by communicating them to others. In the workplace, you might do this by writing papers or reports (as you did

Overview It is important to be able to convey your understanding of macroeconomic concepts by communicating them to others. In the workplace, you might do this by writing papers or reports (as you did for the Week 5 assignment) or creating presentations for your team, manager, or clients. For this

In ECO100, we’ve learned about the economic benefits of competition. Under competition, multiple sellers try to convince consumers to buy their products. Buyers tend to have better options and pay low

In ECO100, we’ve learned about the economic benefits of competition. Under competition, multiple sellers try to convince consumers to buy their products. Buyers tend to have better options and pay lower prices when they can choose from multiple sellers rather than a single seller. Competition among sellers helps to ensure

Can you edit my proposal and 3000-word paper? ill attach the document and the feedback given. my research question is does minimum wage effect unemployment this is the proposal feedback: ” You haven’t

Can you edit my proposal and 3000-word paper? ill attach the document and the feedback given. my research question is does minimum wage effect unemployment this is the proposal feedback: ” You haven’t clearly stated your topic, but I’m assuming you intend to study the effect of minimum wage increases

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:”Table Normal”; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes;

Assignment Part 1: Conducting Incident Investigation-Due, Sunday, week 11 Hide Folder Information Instructions In this Assignment, you will practice: Conducting incident investigation Finding the causes of the incident Providing corrective actions Evaluate your understanding of the incidnet investigation process How are you going to do it: Assignment Instruction Complete the

VAL- UP TO 4/15/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WH

VAL- UP TO 4/15/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** PART 1- Module 1- DISCUSSION- (VAL)- Learning Accounting Discuss why students should learn

discussion Question: Consider a country experiencing rising inflation and a growing balance of payments deficit. Analyze how potential changes in the exchange rate might impact the country’s pursuit

discussion  Question: Consider a country experiencing rising inflation and a growing balance of payments deficit. Analyze how potential changes in the exchange rate might impact the country’s pursuit of internal balance (stable prices and full employment). Would a depreciation or appreciation of the currency help address these challenges, or could

Question: Analyze a scenario where a government imposes comprehensive exchange controls to stabilize the exchange rate and prevent its currency’s value from declining. What immediate effects might thi

Question: Analyze a scenario where a government imposes comprehensive exchange controls to stabilize the exchange rate and prevent its currency’s value from declining. What immediate effects might this policy have on the nation’s economy, including trade, foreign investment, and domestic businesses? Additionally, what longer-term developments or unintended consequences could arise

DISCUSSION Question: Japan currently has a very low rate of immigration because of very restrictive Japanese government policy. You are trying to convince your Japanese friend that Japan should change

DISCUSSION Question: Japan currently has a very low rate of immigration because of very restrictive Japanese government policy. You are trying to convince your Japanese friend that Japan should change its laws to permit and encourage substantially more immigration. Discuss the three strongest arguments based on the case To earn

Reference: Pugel, T. (2023). International Economics (18th ed.). McGraw-Hill Higher Education (US). https://online.vitalsource.com/books/9781266833410 DISCUSSION Question: Analyze the European Union

Reference: Pugel, T. (2023). International Economics (18th ed.). McGraw-Hill Higher Education (US). https://online.vitalsource.com/books/9781266833410 DISCUSSION Question: Analyze the European Union’s use of economic embargoes as a policy tool. What types of countries within the EU are most likely to support or implement such measures, and what factors influence their decisions? In

DISCUSSION Question: Consider a scenario where a large country imposes a tariff on imported goods, effectively shifting part of the tax burden to foreign producers. How might this strategy create econ

DISCUSSION Question: Consider a scenario where a large country imposes a tariff on imported goods, effectively shifting part of the tax burden to foreign producers. How might this strategy create economic gains for the imposing country? What are the potential long-term effects on trade relationships, domestic industries, and global market