Your parents have decided to invest their lifetime savings of $$800,000$ into either Mutual Fund A or Mutual Fund B$.$ They plan to retire in five years, with a relatively large proportion of their retirement income coming from returns on their mutual fund investment. Being a Concord University MBA student, you have been asked by your parents to decide which fund would be best for them. Fifteen$-$year historical returns for the funds are provided below. Using Excel Megastat, prepare a comprehensive statistical analysis for each fund, then make a recommendation to your parents. For each fund, prepare a narrative in which you discuss the statistical measures you consider most important.

$\backslash$table$[[$Year$,$Fund A Performance $(\%),$Fund B Performance $(\%)],[2009,11\mathrm{.}37,16\mathrm{.}32],[2010,8\mathrm{.}33,14\mathrm{.}33],[2011,6\mathrm{.}88,-5\mathrm{.}88],[2012,14\mathrm{.}44,51\mathrm{.}43],[2013,16\mathrm{.}44,2\mathrm{.}22],[2014,12\mathrm{.}24,-15\mathrm{.}33],[2015,4\mathrm{.}37,19\mathrm{.}83],[2016,9\mathrm{.}87,27\mathrm{.}77],[2017,-4\mathrm{.}45,2\mathrm{.}12],[2018,13\mathrm{.}05,-5\mathrm{.}98],[2019,7\mathrm{.}60,41\mathrm{.}92],[2020,11\mathrm{.}38,-3\mathrm{.}66],[2021,8\mathrm{.}28,13\mathrm{.}75],[2022,6\mathrm{.}22,12\mathrm{.}35],[2023,13\mathrm{.}77,-3\mathrm{.}75]]$