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.

  1. Construct a table that computes the mean for eachtype, marketcap, and risk.
  2. Construct a table that computes the standard deviation for eachtype, marketcap, and risk.
  3. 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

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!