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

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

Growth in Grow Product The rate of The The Years CPI participation unemployment Current Constant inflation rate rate prices prices 2001 35.1 2.7 45.4 10.5 6.3% 2002 1.5% 84.3 -1.0 45.8 12.0 2.3% 2003 35.8 -0.3% 1.9 46.6 12.1 2004 5.3% 86.6 2.1% 0.9 46.5 11.4 6.9% 2005 90.2 2.7% 4.1 47.0 10.6 5.9% 1.9% 2006 96.1 6.6 48.6 11.0 5.5% 2007 100.2 0.5% 4.2 48.6 10.6 2008 4.8% 104.7 -1.2% 4.5 46.6 11.2 3.6% 2009 107.6 -2.9% 2.8 45.5 13.7 1.5% 2010 109.8 -3.8% 2.0 44.1 16.3 1.1% 2011 111.8 -3.6% 1.8 42.8 16.2 2.2% 2012 114.7 -1.7% 2.6 41.7 15.2 2013 3.6% 115.7 0.5% 0.9 40.9 14.0 1.3% 2014 116.8 -0.1% 0.9 40.3 14.4 0.2% 2015 116.4 -1.8% -0.3 39.6 12.8 1.2% 2016 -0.8% 116.2 0.2 40.0 11.8 0.6% 2017 116.9 -1.6% 0.6 40.1 11.5 .1.3% 2018 -3.2% 118.8 1.6 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. 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. 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
