Score: 2.63 of5 pts 2.6-8.60-T Help Use the data table regarding retirement fund

ID: 3067929 • Letter: S

Question

Score: 2.63 of5 pts 2.6-8.60-T Help Use the data table regarding retirement funds a. Construct a table that tabulates type, risk, and rating b. What can you among the type of retirement funds (growth and value), based on risk (ow, average, and high), and rating (one, two, three, four, and five)? Construct a table that computes the average three-year return for each type, risk, and rating d. Drill down to examine the growth funds with high risk with a rating Click here to view the data of three. How many funds are there? What conclusions can you reach about these funds? c. Complete the table below Enter 0 for any entries with a count of zero Five Four Three Two One Grand Tota Average Growth Total in the edit fields and then click Check Answer

Explanation / Answer

Average return

Rating

Type

Risk

Five

Four

Three

Two

One

Grand total

Growth

Low

18.3

13.3

11.15

12.15

54.9

Average

13.65

3.55

16.65

15.37

58.22

High

2.5

3.57

-1.5

4.57

Growth Total

31.95

22.3

17.2

32.37

13.87

117.69

The last column shows the grand total of average return for all ratings of each risk. Therefore the grand total of average return for Low risk, average risk and High risk are 54.9, 58.22 and 4.57 respectively. The grand total of average return is 117.69.