College Tuition Exercise.xlsx File Edit Insert Format Help Calibri 11 BIUSA A B D E F G H - K L M N 0 2 3 4 5 Question 1 What is the overall inflation rate from 2000 to 2018. (remember inflation rate relative change in CPI)? 6 Shepherd Out of State Tuition year Actual cost in 2018 dollar 2000 $5,938 2005 $10,618 2010 $14,046 2015 $16,628 2018 $18.048 8 Question 2 9 What is the relative change in Shepherd Out of State 10 tuition from 2000 to 2018? 11 12 13 14 Question 3 15 Finish the out-of-state tuition table by computing 16 the 2018 equivalents of each value. 17 18 Question 4 19 Write a couple of sentences comparing how tuition increased 20 to the rate of inflation. What was the real change in tuition? 21 You can use the basevall salaries example as a model. if 22 you wish it was discussed in the Lecture video and 23 is also in your textbook on page 172 24 YEAR CPI 2000 172.21 2001 177.1 2002 179.91 2003 184.01 2004 188.9 2005 195.3 2006 2016 2007 207.3 2008 215.3 2009 214.5 2010 218.1 2011 224.9 2012 229.6 2013 233.0 2014 236.7 2015 2370 2016 240.0 2017 245,1 2018 250.5 Sheet College Tuition Exercise.xlsx File Edit Insert Format Help Calibri 11 BIUSA A B D E F G H - K L M N 0 2 3 4 5 Question 1 What is the overall inflation rate from 2000 to 2018. (remember inflation rate relative change in CPI)? 6 Shepherd Out of State Tuition year Actual cost in 2018 dollar 2000 $5,938 2005 $10,618 2010 $14,046 2015 $16,628 2018 $18.048 8 Question 2 9 What is the relative change in Shepherd Out of State 10 tuition from 2000 to 2018? 11 12 13 14 Question 3 15 Finish the out-of-state tuition table by computing 16 the 2018 equivalents of each value. 17 18 Question 4 19 Write a couple of sentences comparing how tuition increased 20 to the rate of inflation. What was the real change in tuition? 21 You can use the basevall salaries example as a model. if 22 you wish it was discussed in the Lecture video and 23 is also in your textbook on page 172 24 YEAR CPI 2000 172.21 2001 177.1 2002 179.91 2003 184.01 2004 188.9 2005 195.3 2006 2016 2007 207.3 2008 215.3 2009 214.5 2010 218.1 2011 224.9 2012 229.6 2013 233.0 2014 236.7 2015 2370 2016 240.0 2017 245,1 2018 250.5 Sheet