Question: Can you help building and analyzing two (2) graphs, both with the data presented below? Please, see instructions below: Growth in Grow Product Years CPI

Can you help building and analyzing two (2) graphs, both with the data presented below? Please, see instructions below:

Growth in Grow Product Years CPI The rate of The The participation unemployment Current Constant inflation rate rate prices prices 2001 85.1 2.7 45.4 10.5 6.3% 2002 84.3 1.5% -1.0 45.8 12.0 2003 2.3% -0.3% 85.8 1.9 46.6 12.1 2004 5.3% 86.6 2.1% 0.9 46.5 11.4 2005 6.9% 90.2 2.7% 4.1 47.0 10.6 5.9% 2006 96.1 1.9% 6.6 48.6 11.0 2007 5.5% 100.2 0.5% 4.2 48.6 10.6 4.8% 2008 104.7 -1.2% 4.5 46.6 11.2 2009 3.6% 107.6 2.8 -2.9% 45.5 13.7 2010 1.5% 109.8 -3.8% 2.0 44.1 16.3 2011 1.1% 111.8 -3.6% 1.8 42.8 162 2012 114.7 2.2% -1.7% 2.6 41.7 15.2 2013 3.6% 115.7 0.5% 0.9 40.9 14.0 2014 1.3% 116.8 -0.1% 0.9 40.3 14.4 2015 0.2% 116.4 -1.8% 0.3 39.6 12.8 2016 1.2% 116.2 -0.8% -0.2 40.0 11.8 2017 0.6% 116.9 -1.6% 0.6 40.1 11.5 2018 -1.3% 118.8 1.6 -3.2% 40.1 10.3 -1.8% 2019 119.4 -4.3% 0.5 40.6 8.5 4.4% 1.5% I. Based on the data above, please construct a line graph in Excel and compare the two indicators of the unemployment rate and economic growth through an analysis. Remember that economic growth must be the real one so that in the short analysis it can integrate the expected connection of the behavior of the unemployment rate with the 4 phases of the economic cycle. (Real GDP is the constant prices II. Based on the data above, please construct a line graph in Excel and compare through an analysis the two indicators of inflation rate and economic growth. Remember that economic growth must be the real one so that in the short analysis it can integrate the expected connection of the behavior of the inflation rate with the 4 phases of the economic cycle. (Real GDP is the constant prices). III. Please make use of the constructed graph from the previous question (II) to differentiate the effects and repercussions of deflation and inflation in the short and long term
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
