Question

4. Use "Janus_Funds" data in Chapter3.xlsx to answer the following questions. For questions that require Excel, include the appropriate output (copy + paste) along with an explanation. Data description: Five years after graduating from college, Lucia Li feels that she is finally ready to invest some of her earnings. She has eliminated her credit card debt and has established an emergency fund. Her parents have been pleased with the performance of their mutual fund investments with Janus Capital Group. She has narrowed her search down to two mutual funds: The Janus Balanced Fund (JANBX): This “core” fund consists of stocks and bonds and its goal is diversification. It has historically produced solid long-term returns through different market cycles. The Janus Overseas Fund (JAOSX): This fund invests in overseas companies based on their individual merits instead of their geography or industry sector. The table reports a portion of the annual returns (in percent) for these two funds from 2000–2016.

Questions: a. Calculate measures of central location to describe the similarities and the differences in these two funds’ returns.

b. Calculate measures of dispersion to assess the risk of each fund.

c. Calculate and interpret measures of correlation between the two funds.

Year	Balanced	Overseas
2000	-2.16	-18.57
2001	-5.04	-23.11
2002	-6.56	-23.89
2003	13.74	36.79
2004	8.71	18.58
2005	7.75	32.39
2006	10.56	47.21
2007	10.15	27.76
2008	-15.22	-52.75
2009	24.28	78.12
2010	7.83	19.28
2011	1.44	-32.78
2012	13.07	12.42
2013	19.72	12.1
2014	8.46	-13.72
2015	0.60	-8.55
2016	4.51	-6.91

Answer 1