YEAR MONTH FIXED_RATE% STARTS in $100 # Houses SOLD 1990 9,81 1551 45 1990 9,97 1437 50 1990 JAWN 10,03 1289 58 1990 10,14 1248 52 1990 10,22 1212 50 1990 10,21 1177 50 1990 10,2 1171 46 1990 9,99 1115 46 1990 9,99 1110 38 1990 10 10,06 1014 37 1990 11 10,11 1145 34 1990 12 9,87 969 29 1991 9,75 798 30 1991 9,62 965 40 1991 9,45 921 51 1991 9,47 1001 50 1991 9,52 996 47 1991 9,49 1036 47 1991 9,49 1063 43 1991 9,52 1049 46 1991 9,33 1015 37 1991 9,1 1079 41 1991 11 8,77 1103 39 1991 12 8,58 1079 36 1992 8,35 1176 48 1992 8,46 1250 55 1992 8,65 1297 56 1992 8,71 1099 53 1992 8,68 1214 52 1992 ZOO YOU A WIN 8,52 1145 53 1992 8,28 1139 52 1992 8,09 1226 56 1992 7,92 1186 51 1992 7,92 1244 48 1992 11 8,06 1214 42 1992 12 8,18 1227 42 1993 8,08 1210 44 1993 7,86 1210 50 1993 7,67 1083 60 1993 7,56 1258 66 1993 7,48 1260 58 1993 7,48 1280 59 1993 7,34 1254 55 1993 7,24 1300 57 1993 7,08 1343 57 1993 10 6,93 1392 56 1993 11 6,99 1376 53 1993 12 7,2 1533 51 1994 7,19 1272 46 1994 7,14 1337 58 1994 7,32 1564 74 1994 YOUAWN- 7,68 1465 65 1994 8,15 1526 65 1994 8,33 1409 55 1994 8,36 1439 52 1994 8,5 1450 59 1994 8,5 1474 54 1994 10 8,64 1450 57 1994 11 8,79 1511 45 1994 12 8,9 1455 40 1995 9,06 1407 47 1995 8,96 1316 47 1995 8,82 1249 60 1995 8,6 1267 58 1995 8,3 1314 63 1995 7,88 1281 64 1995 7,76 1461 64 1995 7,88 1416 63 1995 7,82 1369 54 1995 10 7,71 1369 54 1995 11 7,63 1452 46 1995 12 7,51 1431 45 1996 7,28 1467 54 1996 7,24 1491 68 1996 7,47 1424 70 1996 7,82 1516 70 1996 8,05 1504 69 1996 8,17 1467 65 1996 8,27 1472 66 1996 8.19 1557 73 1996 8,2 1475 62 1996 10 8,12 1392 56 1996 11 7,92 1489 54 1996 12 7,77 1370 51Inferential Statistics Using Mutual Funds database : Mutual funds are the most common way people invest for the future with more than $20 trillion in investment assets. They are so popular because they are a simple, convenient way to invest in stocks, bonds, money markets, commodities and other securities. Nearly half of all Canadian households invest in mutual funds. These professionally managed investment products use money from investors to create a diversified pool of securities to achieve a specific investment objective. Investors purchase shares, which represent ownership in the mutual fund. The price of the fund fluctuates based on the gain or loss of the securities that make up the fund. Because each mutual fund has a specific investment objective, such as growth, capital preservation, or income, it is important to understand which funds are designed to meet the investor objectives. For example Asset Allocation Funds invest in a mix of stocks, bonds, alternatives and money market securities, where as TK Funds emphasize on the Science and Technology stocks. To complete your assignment; Your group has been selected as a consultant team by a financial firm to perform a statistical analysis of the Mutual Funds Case. Your 1 page report in Word should show your final recommendation based on the statistical analysis. The 4-case questions will assist you in your database analysis. The database containing the following variables in Excel spreadsheet called MutualFundsfile.xls. - Fund Names -Objective - Sales Charge (Use] for Yes and 0 for No) - Expense Ratio - Risk (High, Average and Low) - Return 1999- Return Q1-2000 - Three-year Return In your analysis you are required to answer at least the following 4 - case questions (but not limited to). 1. Construct a contingency table between Risk and Sales Charge. Use your table to show whether there is a relationship between the two variables at a = 5% significance level. Explain your conclusion in the context of the problem. For the Average risk funds only, test the proportion of funds with the Sales Charge differs from 0.50 use a = 0.05. Explain your conclusion. 2. For the Average risk funds only, set up a 95% confidence interval for the proportion of funds with the Sales Charge and compare your conclusion with the one in the previous part.Mutual Funds Workbook Case Winter 2018 Contents Overview Sheet Summam of this workbook Data Sheet Data for 137 mutual funds A1 :A138 Fund Names B1 :B138 Objective C1 :C138 Sales Charge ( Use1 for Yes and 0 for No) D1 :D138 Expense Ratio E1 :E138 Risk F1 :F138 Return 1999 G1 :G138 Return 012000 H1 :H138 Three-year Return Comm215 Sections H & G Due Date April 4, 2018