Question

Please show excel sheets for the following, answers are provided

The CPI-U for Americans 62 years of age and older (some of your professors and some of your authors are interested in this!) present the following annual inflation rates in percent:

Year     Rate %     2001     1.6     2002     2.4     2003     1.9     2004     3.3     2005     3.4

a.	Assuming the index value in year 2000 was 100.0, determine the index for each year from 2001 to 2005 to one place after the decimal. 101.6, 104.0, 106.0, 109.5, 113.2

b.	Since inflation, like interest, is compounded from period to period (e.g., year to year), estimate the overall annual inflation rate per year from 2002 to 2006. Suggestion! Do not simply average the rates given above. 2.51744%

Answer 1

I have enclosed the screen shot of excel file for your reference