Use the accompanying data table regarding retirement funds.

a. Construct a table that tabulates market capmarket cap, riskrisk, and ratingrating.

b. What conclusions can you reach concerning differences among the funds based on market cap (small, mid-cap, and large), riskrisk (low, average, and high), and ratingrating (one, two, three, four, and five)?

c. Construct a table that computes the average three-year return for each market cap, risk, and rating.

d. Drill down to examine the large-cap funds that are high risk with a rating of three. How many funds are there? What conclusions can you reach about these funds?

Type	Market Cap	Rating	Return	Risk
Value	Large	Three	19.3	Low
Value	Large	Four	18.8	Low
Value	Large	Four	15.8	Low
Value	Large	Four	15.8	Low
Growth	Large	Five	6.5	Low
Value	Large	Four	8.5	Average
Value	Large	Three	19.3	Average
Growth	Large	Four	-4	Average
Growth	Large	Five	5.8	Average
Value	Large	Four	14.5	Average
Growth	Large	Four	3.5	Average
Value	Large	Four	12.3	High
Value	Large	Four	16.3	High
Value	Large	Four	19.5	High
Growth	Large	Three	6.8	High
Growth	Large	Five	4	High
Growth	Large	Four	-2.5	High
Value	Large	Four	19.8	High
Value	Large	Four	11	High
Growth	Mid-Cap	Five	-2.3	Low
Value	Mid-Cap	Three	11.8	Low
Growth	Mid-Cap	Four	5.8	Low
Growth	Mid-Cap	Four	4.5	Low
Value	Mid-Cap	Four	11.5	Low
Value	Mid-Cap	Four	18.5	Low
Growth	Mid-Cap	Four	5.5	Low
Growth	Mid-Cap	Four	2.5	Low
Growth	Mid-Cap	Three	-1.5	Average
Growth	Mid-Cap	Five	-4	Average
Growth	Mid-Cap	Five	4	Average
Value	Mid-Cap	Three	18	Average
Growth	Mid-Cap	Four	3	Average
Growth	Mid-Cap	Four	-4.5	Average
Value	Mid-Cap	Four	15.3	High
Growth	Mid-Cap	Four	-2	High
Growth	Mid-Cap	Three	1.3	High
Growth	Mid-Cap	Five	1.8	High
Value	Small	Four	10.3	Low
Growth	Small	Four	-2	Low
Growth	Small	Four	6.3	Low
Growth	Small	Five	7	Low
Value	Small	Three	12.8	Low
Growth	Small	Four	3	Average
Growth	Small	Five	2.3	Average
Value	Small	Four	10.5	Average
Growth	Small	Four	2.8	High
Growth	Small	Four	5.8	High
Value	Small	Three	8.5	High
Value	Small	Three	8	High
Value	Small	Three	16.5	High