Please be clear with anwser! thank you! Recall we studied an investment advisory

Question

Please be clear with anwser! thank you!

Recall we studied an investment advisory company? This question is about the same company. For your information, the description of the company and its data set is given again below: 8 points

An investment advisory company studied funds available on the market: Large cap, mid-cap, and small-cap. The company randomly selected some funds and measured their 1-year return rate (2011-2012) and 3-year return rate (2011-2014), respectively. Data is supplied in both Minitab and Excel format.

Your manager is interested in learning whether there is any difference among the three funds’ average 3-year return rate?                                                     5 points

If so, how is each type of fund different from others (Hint: A pairwise comparison).  3 points

P.S. Your manager says that a Minitab (or another statistical software package) report with a conclusion is fine. He is happy with a significance level of 0.05.   

1YrReturn%_Large 3YrReturn%_Large 1YrReturn%_Mid-Cap 3YrReturn%_Mid-Cap 28.99 24.26 26.38 18.70 33.40 22.72 15.77 16.25 33.98 21.91 16.16 15.65 33.78 21.89 16.27 15.26 21.62 16.47 16.94 15.04 22.87 16.10 14.60 15.02 17.41 13.44 11.40 14.97 16.54 13.30 16.64 14.61 15.72 13.16 14.75 14.56 14.50 12.59 17.80 14.44 17.14 12.45 16.95 14.17 15.23 12.39 15.69 13.78 18.62 12.16 15.61 13.78 22.45 12.15 17.80 14.44 15.66 12.14 16.95 14.17 13.75 11.97 15.69 13.78 14.62 11.84 15.61 13.78 26.06 11.80 23.24 13.55 15.72 11.44 10.46 13.50 11.86 11.29 19.73 13.50 18.64 11.21 16.43 13.49 15.71 11.13 14.71 13.40 17.77 11.07 18.57 13.31 15.36 11.07 14.40 13.26 17.33 11.04 17.61 13.24 21.08 10.90 16.40 13.01 18.12 10.86 18.28 12.94 9.16 10.83 10.34 12.92 22.02 10.68 15.08 12.71 16.63 10.67 15.96 12.69 13.08 10.62 12.16 12.60 12.49 10.56 16.04 12.53 17.72 10.54 18.36 12.03 13.42 10.52 10.90 11.81 14.18 10.43 9.82 11.72 16.99 10.35 12.26 11.64 13.12 10.11 13.78 11.60 14.74 10.07 15.46 11.53 17.93 10.06 11.97 11.52 12.27 10.02 14.93 11.50 11.29 10.01 14.45 11.49 10.75 10.00 10.88 11.42 12.57 9.95 12.18 11.27 17.67 9.92 12.20 11.16 13.60 9.92 9.45 10.91 12.18 9.75 7.74 10.86 18.31 9.74 13.80 10.34 17.07 9.69 15.31 10.73 14.88 9.67 21.46 10.39 15.13 9.65 13.69 10.20 15.02 9.64 13.93 10.08 11.17 9.56 12.91 10.04 20.67 9.52 2.43 9.78 16.79 9.46 12.86 9.71 19.91 9.46 12.94 9.60 13.23 9.45 15.46 9.58 9.99 9.44 11.39 9.09 19.95 9.34 5.70 8.65 14.82 9.30 9.97 8.54 16.57 9.25 11.78 8.54 20.85 9.19 8.13 8.19 12.40 9.11 4.23 7.99 11.80 9.07 5.97 7.26 15.67 8.97 12.60 7.11 12.72 8.90 7.85 7.00 11.75 8.78 6.77 6.97 15.27 8.70 11.47 6.18 12.99 8.47 3.80 6.02 15.83 8.42 22.44 5.26 13.39 8.42 -11.28 1.17 13.70 8.40 2.03 1.05 9.77 8.34 9.11 -1.63 16.95 8.21 20.19 14.77 11.21 8.16 19.14 12.67 17.23 8.16 19.37 12.50 9.23 8.12 15.71 12.28 13.42 8.09 22.19 12.18 14.05 7.99 20.21 12.04 12.70 7.96 18.24 12.04 13.96 7.89 21.90 11.61 13.54 7.89 16.44 11.39 13.44 7.88 15.30 11.11 14.09 7.81 18.67 11.01 16.04 7.75 15.57 10.77 16.65 7.64 19.09 10.53 11.80 7.64 12.39 10.53 16.13 7.63 16.03 10.20 14.26 7.24 10.51 8.65 17.74 7.21 11.65 8.19 12.99 7.12 13.06 7.51 15.77 7.03 13.31 5.02 12.25 6.90 14.65 6.62 12.97 6.52 11.28 5.92 11.72 5.63 13.02 5.61 19.40 5.50 10.32 5.35 11.56 4.70 14.29 4.58 8.85 3.70 7.84 1.18 15.05 12.40 10.02 12.28 20.44 11.96 14.75 11.85 17.80 10.81 6.77 10.52 14.50 10.47 17.22 10.45 19.85 10.34 9.40 10.30 11.94 10.27 19.09 10.11 13.65 10.10 9.00 9.93 13.80 9.91 18.68 9.62 16.41 9.43 13.58 9.42 14.55 9.33 14.51 9.26 16.38 9.22 13.67 9.03 16.33 9.03 15.66 8.83 15.61 8.78 17.23 8.76 16.51 8.51 15.34 8.35 16.58 8.32 15.43 8.31 15.92 8.30 9.23 8.23 16.25 8.22 14.70 8.19 8.73 8.12 19.32 7.87 14.60 7.74 14.25 7.54 6.36 7.47 9.47 7.23 10.86 6.80 5.98 6.70 16.81 6.01 10.55 5.68 6.60 5.57 13.85 5.56 11.42 5.48 1.67 4.87 13.83 4.84 9.34 2.37

Explanation / Answer

Your manager is interested in learning whether there is any difference among the three funds’ average 3-year return rate?

Yes there is a difference in the sample size between the data

If so, how is each type of fund different from others

the difference is only in the sample size ok?

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---