Microsoft Office Tutorials and References

In Depth Information

of years of abuse have experienced, age, years of schooling, number of par-

ents in the household as a child, and the perceived chances for recovery by a

panel of experts at the clinic. Determine the following using
PivotTables
and

PivotCharts
:

a. Is there a general relationship between age and the number of years of

abuse?

b. For the following age categories, what proportion of their lives have clients

abused alcohol:

i. 0–24

ii. 25–35

iii. 36–49

iv. 49–over.

c. What factor is the most reliable predictor of perceived chances for recovery?

Which is the least?

d. What is the co-relationship between number of parents in the household and

years of schooling?

e. What is the average age of the clients with bad prospects?

f. What is the average number of years of schooling for clients with one parent

in the household as a child?

g. What is the average number of parents for all clients that have poor

prospects for recovery?

Case Yrs abuse Age Years school Number of parents Prospects

1

6

26

12

1

G

2

9

41

12

1

B

31 91 2

B

4

5

20

8

2

G

5

6

29

9

1

B

6

8

34

13

2

B

72 46 2

G

8

7

33

16

1

G

9

9

37

14

1

G

10

7

31

10

2

B

11

6

26

7

2

B

12

7

30

12

1

G

13

8

37

12

2

B

14

12

48

7

2

B

15

9

40

12

1

B

16

6

28

12

1

G

17

8

36

12

2

G

18

9

37

11

2

B

19

4

19

10

1

B

20

6

29

14

2

G

Search JabSto ::

Custom Search