Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Preview File Edit View 60 Tools Window Help . a: V ECON 201 - Signature Assignment Spring 2023... Page I oi 2 GDQthv (E

image text in transcribedimage text in transcribedimage text in transcribed
Preview File Edit View 60 Tools Window Help . a: V ECON 201 - Signature Assignment Spring 2023... " Page I oi 2 GDQthv (E Q TOPIC: The Phillips Curve Revisited: US Inflation & Unemployment between Yearl and Year2. Data is Provided for Assignment To simplify the initial steps in the Signature Assignment [Phillips Curve Topic], the data needed for the analysis is being provided to you. These data are to be found in Blackboard in the Signature Assignment Learning Module; the file containing these data is an MS-Excel workbook named: \"ECON 201 - Signature Assignment, Phillips Curve, Data (05-0722).x|sx". STEP 1 - Identify 10 Year Time-Period to Analyze Examine the data inside the MS-Excel \"Data\" workbook. Note that the data are already divided into 10 year time periods, except the first period (1946-1954), which is 9 years and the last period (2015-2021) which is 7 years. The file contains the following 76 years of data: Real and Current GDP, % change in Real GDP, Unemployment Rate & Consumer Price Index (CPI) and Change in CPI 1946-2021. Certain conversions were performed on the data to make the data series analyzable over the entire period. If can choose to analyse 10 years of data from one of the pre-identied time-periods (e.g. 2005-2014) or combine 10 years of data from more than one pre-identified time-period. Note: If using data from 2 pre-identified time-periods, read the following: The Real GDP data contains discontinuities when different time-periods were used as a basis, so the actual data may contain jumps in level. This does not affect the % Change in GDP, only the level of GDP. It is acceptable to include Real GDP with in the table that has 2 bases, just add a footnote to the table that: \"The values of Real GDP are from dlfjfferent bases. \" STEP 2 - Extract Analysis Data ' w; "'rlvlcwage wpr ~ K?) l3l20 - 3/26 I u-um \"mu-ktl nun-1.\": mu \\J 6 Preview File Edit View 60 Tools Window Help e G) 3 - -r TueApr2510=35AM . E: V ECON 201 - Signature Assignment Spring 2023... 6) Q Q [T] j V \" QV X + V PageloiZ N (j STEP 2 Extract Analysis Data Open the Sample Table and Plot le named: "ECON 201 - Signature Assignment, Phillips Curve, Table & Plot (05- 07-22).xlsx\Preview File Edit View 60 Tools Window Help . a: V ECON 201 - Signature Assignment Spring 2023... Page 2 or 2 QQQrTiv (B Q STEP 3 Move Table and Plot to Report Template Open the Signature Assignment Template file: \"ECON 201 - Signature Assignment Template [Phillips Curve] (05- 07-22).xlsx\

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Marketing Research

Authors: Naresh K. Malhotra

1st Global Edition

1292060166, 9781292060163

Students also viewed these Economics questions