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