Consider the following table for an eight-year period T-bill returrn 7.41% 8.64 5.99 5.67 5.57 8.24 10.68 12.70 Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Inflation 8.59% 12.22 6.82 4.98 6.58 8.90 13.17 12.40 Requirement 1 Calculate the average return for Treasury bills and the average annual inflation rate (consumer price index) for this period. (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).) Average return for Treasury bills Average annual inflation rate 2.55 % 3.07% Requirement 2: Calculate the standard deviation of Treasury bill returns and inflation over this time period. (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g 32.16).) Standard deviation of Treasury bills Standard deviation of inflation Requirement 3: (a) Calculate the real return for each year. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).) Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Real return 0 0 0 0 0 0 0 0 (b) What is the average real return for Treasury bills? (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (e.g., 32.16).) Average real return for Treasury bills