the following is to be solved on an excel sheet

The commercial arm of the Strathmore Centre for Value Investing (SCVI) has developed an investment product Motocas! (Motocas factorial.) The name of the product is not at all creative. However, it describes the purpose of the product: To enable people save up enough money over a period of 36 months to enable them purchase a motor car. Here's how it works. Investors deposit a fixed sum of KES 25,000 at the beginning of each month into the fund. The fund provides a guaranteed return of 1% per month on the fund value at the beginning of each month. Now the actual returns earned by the fund will vary from the guaranteed rate! Where the returns are higher than the guaranteed rate, the excess interest earned is transferred into a reserve account. And where the returns are lower than guaranteed rate, the shortfall is withdrawn from the reserve account and added to the fund value so that it will still have earned the guaranteed rate in the month. The reserve account however earns no interest and is simply an account where excess or shortfall is deposited or withdrawn as needed. Based on complex (very complex) statistical and time series analysis, the actual interest rates over the 36-month period are expected to be as shown on Interestrates data. Required. 1. Calculate the following summary statistics for actual rates of retum Minimum, maximum, mean, standard deviation, and coefficient of variation. [2 marks] 2. Plot a histogram of the actual rates of return and discuss your results. [2 marks] The commercial arm of the Strathmore Centre for Value Investing (SCVI) has developed an investment product Motocas! (Motocas factorial.) The name of the product is not at all creative. However, it describes the purpose of the product: To enable people save up enough money over a period of 36 months to enable them purchase a motor car. Here's how it works. Investors deposit a fixed sum of KES 25,000 at the beginning of each month into the fund. The fund provides a guaranteed return of 1% per month on the fund value at the beginning of each month. Now the actual returns earned by the fund will vary from the guaranteed rate! Where the returns are higher than the guaranteed rate, the excess interest earned is transferred into a reserve account. And where the returns are lower than guaranteed rate, the shortfall is withdrawn from the reserve account and added to the fund value so that it will still have earned the guaranteed rate in the month. The reserve account however earns no interest and is simply an account where excess or shortfall is deposited or withdrawn as needed. Based on complex (very complex) statistical and time series analysis, the actual interest rates over the 36-month period are expected to be as shown on Interestrates data. Required. 1. Calculate the following summary statistics for actual rates of retum Minimum, maximum, mean, standard deviation, and coefficient of variation. [2 marks] 2. Plot a histogram of the actual rates of return and discuss your results. [2 marks]