I have attached the file needed and also an example of how the final draft has to be.
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 descriptive statistics for the 1-year return of the mutual funds. Describe your findings.
Expectations: Copy & paste the Excel displays into a Word file if you can. Upload the Word file (or the Excel files) for credit. Comments in which you describe your findings should be included with each display. APA formatting is not required for weekly assignments but adhere to the rules of written English in your punctuation, grammar and spelling.
0 comments