Question: Use the accompanying data table regarding retirement funds. a. Construct a table that tabulates type, market cap, and rating. b. What conclusions can you reach

Use the accompanying data table regarding retirement funds. a. Construct a table that tabulates type, market cap, and rating. b. What conclusions can you reach concerning differences among the type of retirement funds (growth and value), based on market cap (small, mid-cap, and large) and rating (one, two, three, four, and five)? c. Construct a table that computes the average three-year return for each type, market cap, and rating. d. Drill down to examine the large-cap growth funds with a rating of three. How many funds are there? What conclusions can you reach about these funds? Type Market Cap Rating Return Risk Growth Large Five -1.8 Low Growth Large Five -2.3 Low Growth Large Four 11.8 High Growth Large Four 8 Average Growth Large Three 11 Average Growth Large Four 0.8 Low Growth Large Four 13.8 High Growth Large Three 8.5 Average Growth Mid-Cap Four -0.8 Low Growth Mid-Cap Five 10.8 Average Growth Mid-Cap Four 11 Average Growth Mid-Cap Four 16.5 High Growth Mid-Cap Four -2.5 Low Growth Mid-Cap Four 18.3 High Growth Mid-Cap Four 6.3 Average Growth Mid-Cap Four 8.5 Average Growth Mid-Cap Three 2 Low Growth Mid-Cap Four 5 Average Growth Mid-Cap Four 12 High Growth Small Three 10.5 Average Growth Small One -2 Low Growth Small Three 13.5 High Growth Small Two 14 High Growth Small One 3 Low Value Large Five 9.8 Average Value Large One 8.3 Average Value Large Two -4.5 Low Value Large Three 2.8 Low Value Large Four 2.3 Low Value Large Four 12.3 High

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 Finance Questions!