Question: Consider the retirement funds data linked below. Using thethree-year return percentagevariable, complete parts(a) through(c) below. Construct a table that computes the mean for eachtype, marketcap,
Consider the retirement funds data linked below. Using thethree-year return percentagevariable, complete parts(a) through(c) below.
- Construct a table that computes the mean for eachtype, marketcap, and risk.
- Construct a table that computes the standard deviation for eachtype, marketcap, and risk.
- What conclusions can you reach concerning differences among the types of retirement funds(growth andvalue), based on market cap(small, mid-cap, andlarge) and the risk(low, average, andhigh)?
b. Construct a table that computes the standard deviation for eachtype, marketcap, and risk.
| Risk | ||||
| Type | Market Cap | Low | Average | High |
| Growth | Small | |||
| Growth | Mid-Cap | |||
| Growth | Large |
| Value | Small | |||
| Value | Mid-Cap | |||
| Value | Large |
(Round to four decimal places asneeded.)
c. What conclusions can you reach concerning differences among the types of retirement funds(growth andvalue), based on market cap(small, mid-cap, andlarge) and the risk(low, average, andhigh)?
The meanthree-year return of the growth funds are generally higher OR lower than those of the valuefunds, with the exception of the small high-risk OR low-risk OR average-risk andmid-cap low-risk OR high-risk OR average-risk.
The standard deviations of the three year return of the growth funds are generally higher OR lower than that of the valuefunds, with the exception of the small low-risk OR high-risk OR average-risk.
| Market_Cap | Type | Risk | 3YrReturn% |
| Large | Growth | High | 63.77 |
| Large | Growth | High | 53.93 |
| Large | Growth | High | 55.2 |
| Large | Growth | Average | 38.52 |
| Large | Growth | Average | 34.32 |
| Large | Growth | Low | 32.64 |
| Large | Growth | High | 32.84 |
| Large | Growth | Average | 28.69 |
| Large | Growth | Average | 27.16 |
| Large | Growth | Average | 27.77 |
| Large | Growth | Average | 26.28 |
| Large | Growth | Average | 26.92 |
| Large | Growth | Average | 25.48 |
| Large | Growth | Average | 25.08 |
| Large | Growth | Average | 25.61 |
| Large | Growth | Average | 24.79 |
| Large | Growth | Average | 25.25 |
| Large | Growth | Average | 23.6 |
| Large | Growth | Low | 23.51 |
| Large | Growth | High | 23.06 |
| Large | Growth | Average | 23.49 |
| Large | Growth | Average | 24.15 |
| Large | Growth | Average | 23.6 |
| Large | Growth | Low | 22.9 |
| Large | Growth | Low | 22.63 |
| Large | Growth | Average | 22.93 |
| Large | Growth | Average | 21.91 |
| Large | Growth | Average | 22.26 |
| Large | Growth | Average | 22.32 |
| Large | Growth | Low | 22.12 |
| Large | Growth | High | 21.2 |
| Large | Growth | Average | 21.31 |
| Large | Growth | Average | 21.62 |
| Large | Growth | Low | 21.78 |
| Large | Growth | Low | 21.92 |
| Large | Growth | Average | 20.99 |
| Large | Growth | Average | 20.98 |
| Large | Growth | Low | 21.79 |
| Large | Growth | Low | 21.76 |
| Large | Growth | High | 21.18 |
| Large | Growth | Low | 20.44 |
| Large | Growth | Low | 19.98 |
| Large | Growth | Average | 21.12 |
| Large | Growth | Average | 20.33 |
| Large | Growth | Low | 20.34 |
| Large | Growth | Average | 21.44 |
| Large | Growth | Low | 19.86 |
| Large | Growth | Low | 20.7 |
| Large | Growth | Average | 19.34 |
| Large | Growth | Low | 19.98 |
| Large | Growth | Average | 18.64 |
| Large | Growth | Average | 18.87 |
| Large | Growth | Low | 19.17 |
| Large | Growth | Average | 19.18 |
| Large | Growth | Low | 18.46 |
| Large | Growth | Average | 18.69 |
| Large | Growth | Average | 18.31 |
| Large | Growth | Low | 18.44 |
| Large | Growth | Low | 19.16 |
| Large | Growth | High | 17.98 |
| Large | Growth | Low | 17.99 |
| Large | Growth | Average | 18.43 |
| Large | Growth | Average | 18.61 |
| Large | Growth | Low | 17.58 |
| Large | Growth | Low | 18.62 |
| Large | Growth | Low | 17.52 |
| Large | Growth | Average | 18.07 |
| Large | Growth | Low | 18.39 |
| Large | Growth | Low | 16.89 |
| Large | Growth | Low | 17.24 |
| Large | Growth | Average | 17.02 |
| Large | Growth | Average | 16.67 |
| Large | Growth | Average | 16.52 |
| Large | Growth | Average | 17.68 |
| Large | Growth | Average | 17.94 |
| Large | Growth | Average | 17.96 |
| Large | Growth | Average | 16.78 |
| Large | Growth | Average | 16.47 |
| Large | Growth | Low | 16.36 |
| Large | Growth | Low | 17.47 |
| Large | Growth | Low | 17.41 |
| Large | Growth | Low | 16.28 |
| Large | Growth | Low | 16.08 |
| Large | Growth | Low | 15.29 |
| Large | Growth | Low | 16.03 |
| Large | Growth | Average | 16.15 |
| Large | Growth | Low | 14.87 |
| Large | Growth | Low | 15.71 |
| Large | Growth | Low | 16.08 |
| Large | Growth | Low | 14.68 |
| Large | Growth | Low | 14.31 |
| Large | Growth | Low | 14.87 |
| Large | Growth | Average | 15.23 |
| Large | Growth | Low | 13.47 |
| Large | Growth | Low | 14.46 |
| Large | Growth | Low | 13.48 |
| Large | Growth | Low | 14.34 |
| Large | Growth | Average | 12.91 |
| Large | Growth | Low | 13.71 |
| Large | Growth | Low | 12.18 |
| Large | Growth | Low | 12.36 |
| Large | Growth | Low | 12.42 |
| Large | Growth | Low | 11.9 |
| Large | Value | Average | 32.05 |
| Large | Value | Average | 27.61 |
| Large | Value | Low | 23.94 |
| Large | Value | Low | 21.62 |
| Large | Value | Low | 22.21 |
| Large | Value | Average | 21.71 |
| Large | Value | Average | 21.47 |
| Large | Value | Low | 19.95 |
| Large | Value | Low | 19.28 |
| Large | Value | Average | 19.37 |
| Large | Value | Low | 19.2 |
| Large | Value | Average | 18.8 |
| Large | Value | Average | 19.05 |
| Large | Value | Average | 17.49 |
| Large | Value | Average | 18.08 |
| Large | Value | Low | 17.31 |
| Large | Value | Average | 18.73 |
| Large | Value | Low | 17.52 |
| Large | Value | Average | 18.19 |
| Large | Value | Average | 17.45 |
| Large | Value | Average | 17.17 |
| Large | Value | Low | 16.91 |
| Large | Value | Low | 17.83 |
| Large | Value | Low | 16.43 |
| Large | Value | Low | 16.15 |
| Large | Value | Low | 16.05 |
| Large | Value | Average | 15.88 |
| Large | Value | Average | 15.81 |
| Large | Value | Average | 15.88 |
| Large | Value | Low | 16.13 |
| Large | Value | Low | 15.8 |
| Large | Value | Average | 15.55 |
| Large | Value | Average | 15.34 |
| Large | Value | Low | 15.55 |
| Large | Value | Average | 16.42 |
| Large | Value | Low | 15.18 |
| Large | Value | Low | 15.21 |
| Large | Value | Average | 16.18 |
| Large | Value | Average | 14.63 |
| Large | Value | Low | 15.06 |
| Large | Value | Low | 16.14 |
| Large | Value | Average | 16.03 |
| Large | Value | Low | 14.96 |
| Large | Value | Low | 14.92 |
| Large | Value | Average | 15.19 |
| Large | Value | Low | 14.96 |
| Large | Value | Average | 14.28 |
| Large | Value | Average | 14.31 |
| Large | Value | Low | 14.96 |
| Large | Value | Low | 13.7 |
| Large | Value | Low | 13.57 |
| Large | Value | Low | 12.53 |
| Large | Value | Low | 10.69 |
| Large | Value | Low | 11.53 |
| Large | Value | Low | 9.97 |
| Mid-Cap | Growth | High | 34.29 |
| Mid-Cap | Growth | High | 31.94 |
| Mid-Cap | Growth | Average | 30.87 |
| Mid-Cap | Growth | High | 29.28 |
| Mid-Cap | Growth | Average | 28.55 |
| Mid-Cap | Growth | Average | 29.41 |
| Mid-Cap | Growth | Average | 28.16 |
| Mid-Cap | Growth | Average | 27.22 |
| Mid-Cap | Growth | Average | 27.14 |
| Mid-Cap | Growth | Average | 26.3 |
| Mid-Cap | Growth | High | 26.71 |
| Mid-Cap | Growth | Average | 26.22 |
| Mid-Cap | Growth | High | 26.23 |
| Mid-Cap | Growth | High | 25.72 |
| Mid-Cap | Growth | Average | 25.03 |
| Mid-Cap | Growth | Average | 25.54 |
| Mid-Cap | Growth | Average | 26.37 |
| Mid-Cap | Growth | Average | 26.06 |
| Mid-Cap | Growth | Average | 24.65 |
| Mid-Cap | Growth | Average | 25 |
| Mid-Cap | Growth | Average | 25.07 |
| Mid-Cap | Growth | Average | 25.22 |
| Mid-Cap | Growth | Average | 25.11 |
| Mid-Cap | Growth | Average | 24.28 |
| Mid-Cap | Growth | Average | 25.28 |
| Mid-Cap | Growth | Low | 24.66 |
| Mid-Cap | Growth | Average | 23.65 |
| Mid-Cap | Growth | Average | 24.71 |
| Mid-Cap | Growth | Average | 23.53 |
| Mid-Cap | Growth | Low | 23.22 |
| Mid-Cap | Growth | Average | 23.83 |
| Mid-Cap | Growth | Low | 24.47 |
| Mid-Cap | Growth | High | 23.38 |
| Mid-Cap | Growth | Average | 22.93 |
| Mid-Cap | Growth | Average | 23.12 |
| Mid-Cap | Growth | Average | 23.42 |
| Mid-Cap | Growth | High | 23.85 |
| Mid-Cap | Growth | Average | 22.15 |
| Mid-Cap | Growth | High | 23.19 |
| Mid-Cap | Growth | Average | 21.93 |
| Mid-Cap | Growth | Average | 22.77 |
| Mid-Cap | Growth | Low | 23.17 |
| Mid-Cap | Growth | Average | 23.03 |
| Mid-Cap | Growth | Low | 21.48 |
| Mid-Cap | Growth | Low | 22.95 |
| Mid-Cap | Growth | Average | 22.69 |
| Mid-Cap | Growth | Average | 22.43 |
| Mid-Cap | Growth | Average | 20.48 |
| Mid-Cap | Growth | Low | 22.1 |
| Mid-Cap | Growth | Low | 20.5 |
| Mid-Cap | Growth | Average | 19.83 |
| Mid-Cap | Growth | Average | 20.02 |
| Mid-Cap | Growth | Average | 19.69 |
| Mid-Cap | Growth | Average | 20.11 |
| Mid-Cap | Growth | Average | 20.05 |
| Mid-Cap | Growth | Average | 19.66 |
| Mid-Cap | Growth | High | 18.9 |
| Mid-Cap | Growth | Low | 18.77 |
| Mid-Cap | Growth | Low | 16.4 |
| Mid-Cap | Growth | Average | 15.47 |
| Mid-Cap | Growth | Average | 15.16 |
| Mid-Cap | Growth | Average | 14 |
| Mid-Cap | Growth | Low | 12.18 |
| Mid-Cap | Growth | Low | 9.09 |
| Mid-Cap | Growth | Average | 7.37 |
| Mid-Cap | Growth | Average | 3.43 |
| Mid-Cap | Value | High | 35.08 |
| Mid-Cap | Value | High | 29.31 |
| Mid-Cap | Value | High | 30.61 |
| Mid-Cap | Value | High | 25.18 |
| Mid-Cap | Value | High | 24.93 |
| Mid-Cap | Value | High | 25.58 |
| Mid-Cap | Value | Low | 24.89 |
| Mid-Cap | Value | Average | 23.28 |
| Mid-Cap | Value | High | 23.78 |
| Mid-Cap | Value | Average | 23.39 |
| Mid-Cap | Value | Low | 21.75 |
| Mid-Cap | Value | Average | 21.81 |
| Mid-Cap | Value | Average | 21.77 |
| Mid-Cap | Value | Low | 22.45 |
| Mid-Cap | Value | Low | 20.41 |
| Mid-Cap | Value | High | 21.33 |
| Mid-Cap | Value | Low | 20.51 |
| Mid-Cap | Value | High | 20.73 |
| Mid-Cap | Value | Average | 20.99 |
| Small | Growth | High | 35.11 |
| Small | Growth | High | 34.72 |
| Small | Growth | Average | 31.94 |
| Small | Growth | High | 32.26 |
| Small | Growth | Average | 30.97 |
| Small | Growth | Average | 31.11 |
| Small | Growth | High | 29.56 |
| Small | Growth | Low | 29.9 |
| Small | Growth | Average | 28.94 |
| Small | Growth | Average | 28.51 |
| Small | Growth | High | 29.04 |
| Small | Growth | High | 28.34 |
| Small | Growth | High | 28.04 |
| Small | Growth | Average | 26.38 |
| Small | Growth | High | 27.23 |
| Small | Growth | Average | 25.99 |
| Small | Growth | Average | 25.59 |
| Small | Growth | High | 25.56 |
| Small | Growth | High | 25.17 |
| Small | Growth | Low | 24.61 |
| Small | Growth | Average | 25.57 |
| Small | Growth | High | 25.14 |
| Small | Growth | Average | 24.5 |
| Small | Growth | High | 24.21 |
| Small | Growth | High | 25.28 |
| Small | Growth | High | 24.59 |
| Small | Growth | High | 24.78 |
| Small | Growth | High | 25.07 |
| Small | Growth | Average | 23.89 |
| Small | Growth | High | 24.45 |
| Small | Growth | Average | 24.34 |
| Small | Growth | Average | 23.76 |
| Small | Growth | Average | 23.74 |
| Small | Growth | Average | 22.97 |
| Small | Growth | High | 22.97 |
| Small | Growth | Average | 22.52 |
| Small | Growth | High | 23.04 |
| Small | Growth | Average | 23.62 |
| Small | Growth | Average | 23.21 |
| Small | Growth | Average | 23.21 |
| Small | Growth | High | 23.18 |
| Small | Growth | High | 23.09 |
| Small | Growth | High | 21.92 |
| Small | Growth | Average | 21.47 |
| Small | Growth | High | 22.26 |
| Small | Growth | Average | 21.14 |
| Small | Growth | High | 20.75 |
| Small | Growth | High | 21.9 |
| Small | Growth | High | 20.42 |
| Small | Growth | High | 21.28 |
| Small | Growth | High | 20.03 |
| Small | Growth | Average | 17.79 |
| Small | Growth | High | 16.21 |
| Small | Growth | High | 12.16 |
| Small | Value | High | 36.33 |
| Small | Value | High | 32.15 |
| Small | Value | High | 32.16 |
| Small | Value | High | 32.41 |
| Small | Value | High | 30.64 |
| Small | Value | High | 31.47 |
| Small | Value | High | 29.89 |
| Small | Value | High | 27.58 |
| Small | Value | High | 27.44 |
| Small | Value | High | 25.4 |
| Small | Value | High | 24.34 |
| Small | Value | High | 24.19 |
| Small | Value | Low | 24.24 |
| Small | Value | Average | 22.94 |
| Small | Value | High | 22.15 |
| Small | Value | Low | 22.52 |
| Small | Value | High | 21.39 |
| Small | Value | High | 20.47 |
| Small | Value | High | 20.22 |
| Small | Value | Average | 20.02 |
| Small | Value | High | 18.43 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
