Question: 1)Provide Descriptive Statistics for the excel file (e.g., sample size, mean, median, standard deviation, standard error). What are your preliminary observations of the descriptive of
1)Provide Descriptive Statistics for the excel file (e.g., sample size, mean, median, standard deviation, standard error). What are your preliminary observations of the descriptive of data set?
2)Use the Analysis of Variance (ANOVA)-Single Factor technique using Excel on the data set. Show the ANOVA table. Answer the hypothesis being tested in this case study. Also, determine your conclusions. Would you accept or reject the null hypothesis for this sample? Why or why not?
3)What recommendations would you offer to the investment company? Where the mutual funds performing equal, or not?Explain and provide your own conclusions.
4)Provide a Line Graph using Excel or StatCrunch of the 3 year return, 5 year return, and 10year return, and explain if these are performing in an equal fashion, or if any of these is performing poorly. Discuss your conclusion and determine if this conclusion relates to the ANOVA results.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
