Question: Assigned Problems: Mutual Fund data (Submit by the end of Module 1) Use Mutual Funds.xls file which consists of 194 different mutual funds from various

Assigned Problems: Mutual Fund data (Submit by the end of Module 1) Use Mutual Funds.xls file which consists of 194 different mutual funds from various companies. It includes variables regarding the name, the net asset value (NAV), the 1-year return, the types of fees, the fund objective, and the size of the fund. ASSIGNED PROBLEM 1: Using the CATEGORICAL_ANALYSIS.xls file, perform a categorical analysis on fees for the mutual funds. Describe your findings. ASSIGNED PROBLEM 2: Using the FREQUENCY_DISTRIBUTION.xls file, create a frequency distribution & histogram on the NAVs. Use ranges of 0 - 10, 10 - 20, 20 - 30, 30 - 40, 40 - 50, 50 - 60, 60 - 70 and 70 - 80. Describe your findings. ASSIGNED PROBLEM 3: Using the DESCRIPTIVE STATISTICS.xls file, compute the descrints atactics for the 1- the mut funds Describe findings
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
