$[20$ points$]$ Use the data in the file Historicalinvest.xlsx to create a count of the number of years

in which stock, bond, and T$-$bill returns are from $-20$ percent through $-15$ percent, $-15$ percent

through $-10$ percent, and so on$.($Hint: Use Frequency function as an array formula$)$

Annual Returns on Investments in

Year Stocks T$.$Bills T$.$Bonds

$192843\mathrm{.}81\%3\mathrm{.}08\%0\mathrm{.}84\%$

$1929-8\mathrm{.}30\%3\mathrm{.}16\%4\mathrm{.}20\%$

$1930-25\mathrm{.}12\%4\mathrm{.}55\%4\mathrm{.}54\%$

$1931-43\mathrm{.}84\%2\mathrm{.}31\%-2\mathrm{.}56\%$

$1932-8\mathrm{.}64\%1\mathrm{.}07\%8\mathrm{.}79\%$

$193349\mathrm{.}98\%0\mathrm{.}96\%1\mathrm{.}86\%$

$1934-1\mathrm{.}19\%0\mathrm{.}30\%7\mathrm{.}96\%$

$199731\mathrm{.}86\%4\mathrm{.}91\%9\mathrm{.}94\%$

$199828\mathrm{.}34\%5\mathrm{.}16\%14\mathrm{.}92\%$

$199920\mathrm{.}89\%4\mathrm{.}39\%-8\mathrm{.}25\%$

$2000-9\mathrm{.}03\%5\mathrm{.}37\%16\mathrm{.}66\%$

$2001-11\mathrm{.}85\%5\mathrm{.}73\%5\mathrm{.}57\%$

stocks tbills bonds

averages $12\mathrm{.}05\%3\mathrm{.}96\%5\mathrm{.}21\%$