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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!