Answered step by step
Verified Expert Solution
Question
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started