Input the below numbers into excel. Calculate the missing numbers and format the
ID: 2922424 • Letter: I
Question
Input the below numbers into excel. Calculate the missing numbers and format them to
one decimal place. in this assignment. You do not have to handwrite the missing values on this assignment sheet.
Year
GDP Deflator (1997 = 100)
GDP Deflator (2002 = 100)
GDP Deflator (2007 = 100)
1997
100.0
1998
101.5
1999
103.2
2000
106.0
2001
108.2
2002
110.7
100.0
2003
102.1
2004
103.7
2005
106.0
96.1
2006
98.1
2007
100.0
2008
102.0
2009
103.0
2010
115.1
104.4
2011
118.0
2012
119.8
2013
121.8
Year
GDP Deflator (1997 = 100)
GDP Deflator (2002 = 100)
GDP Deflator (2007 = 100)
1997
100.0
1998
101.5
1999
103.2
2000
106.0
2001
108.2
2002
110.7
100.0
2003
102.1
2004
103.7
2005
106.0
96.1
2006
98.1
2007
100.0
2008
102.0
2009
103.0
2010
115.1
104.4
2011
118.0
2012
119.8
2013
121.8
Explanation / Answer
Missing values with table
Year GDP Deflator (1997 = 100) GDP Deflator (2002 = 100) GDP Deflator (2007 = 100) 1997 100.0 90.3 81.9 1998 101.5 91.7 83.1 1999 103.2 93.2 84.5 2000 106.0 95.8 86.8 2001 108.2 97.7 88.6 2002 110.7 100.0 90.7 2003 113.0 102.1 92.6 2004 114.8 103.7 94.0 2005 117.3 106.0 96.1 2006 119.8 108.2 98.1 2007 122.1 110.3 100.0 2008 124.5 112.5 102.0 2009 125.8 113.6 103.0 2010 127.4 115.1 104.4 2011 130.6 118.0 107.0 2012 132.6 119.8 108.7 2013 134.8 121.8 110.5