This course will require you to create graphs using Microsoft Excel and the Analysis ToolPak add-in. For this activity, which will help prepare you for Projects One and Three, you’ll use the same data set from the previous page to create a pie chart and a
FAST ANSWERS_PHDPSY260_Module_Two_Activity_Data_Set3.xlsx
Sheet1
| Confidence in Education |
Confidence in Science |
Race |
Sex |
Highest Year of School |
Age |
| 3 |
2 |
2 |
2 |
20 |
58 |
| 2 |
3 |
1 |
2 |
16 |
61 |
| 2 |
3 |
1 |
2 |
16 |
53 |
| 2 |
2 |
1 |
1 |
10 |
70 |
| 1 |
2 |
3 |
1 |
20 |
51 |
| 3 |
2 |
1 |
2 |
16 |
58 |
| 2 |
2 |
1 |
2 |
18 |
55 |
| 2 |
3 |
3 |
1 |
18 |
65 |
| 3 |
2 |
1 |
2 |
17 |
35 |
| 2 |
2 |
1 |
2 |
13 |
59 |
| 2 |
3 |
1 |
1 |
16 |
46 |
| 1 |
3 |
2 |
2 |
10 |
42 |
| 3 |
3 |
1 |
1 |
16 |
68 |
| 2 |
2 |
1 |
2 |
12 |
73 |
| 2 |
2 |
1 |
2 |
14 |
51 |
| 2 |
2 |
1 |
2 |
15 |
63 |
| 2 |
2 |
1 |
2 |
12 |
60 |
| 2 |
2 |
1 |
1 |
12 |
60 |
| 2 |
2 |
3 |
2 |
12 |
59 |
| 4 |
3 |
1 |
2 |
14 |
55 |
| 2 |
2 |
1 |
2 |
14 |
25 |
| 2 |
3 |
2 |
1 |
13 |
20 |
| 1 |
2 |
3 |
1 |
12 |
31 |
| 3 |
3 |
1 |
2 |
16 |
60 |
| 3 |
3 |
1 |
2 |
17 |
41 |
| 3 |
3 |
1 |
2 |
14 |
39 |
| 2 |
2 |
1 |
2 |
17 |
70 |
| 2 |
2 |
1 |
2 |
16 |
42 |
| 2 |
2 |
1 |
2 |
16 |
55 |
| 3 |
2 |
1 |
2 |
13 |
19 |
| 1 |
2 |
1 |
1 |
12 |
33 |
| 2 |
3 |
3 |
2 |
15 |
30 |
| 2 |
3 |
1 |
2 |
15 |
89 |
| 2 |
2 |
1 |
2 |
18 |
43 |
| 3 |
3 |
1 |
2 |
12 |
56 |
| 2 |
2 |
2 |
2 |
14 |
45 |
| 3 |
2 |
1 |
2 |
9 |
28 |
| 2 |
2 |
1 |
1 |
12 |
33 |
| 2 |
3 |
2 |
2 |
12 |
19 |
| 3 |
3 |
1 |
2 |
13 |
30 |
| 2 |
3 |
1 |
1 |
13 |
51 |
| 3 |
3 |
2 |
2 |
15 |
45 |
| 2 |
2 |
1 |
1 |
10 |
47 |
| 2 |
1 |
1 |
2 |
12 |
24 |
| 2 |
1 |
1 |
2 |
15 |
40 |
| 2 |
2 |
1 |
2 |
16 |
50 |
| 2 |
3 |
1 |
2 |
12 |
48 |
| 1 |
3 |
1 |
1 |
16 |
48 |
| 3 |
2 |
1 |
2 |
16 |
42 |
| 2 |
2 |
1 |
2 |
15 |
25 |
| 2 |
2 |
1 |
2 |
14 |
25 |
| 1 |
2 |
1 |
2 |
12 |
69 |
| 2 |
2 |
2 |
2 |
15 |
31 |
| 3 |
2 |
1 |
1 |
5 |
70 |
| 2 |
3 |
1 |
2 |
16 |
36 |
| 3 |
2 |
1 |
2 |
6 |
76 |
| 2 |
3 |
1 |
1 |
12 |
34 |
| 3 |
3 |
1 |
1 |
12 |
24 |
| 2 |
3 |
1 |
1 |
16 |
32 |
| 3 |
2 |
1 |
2 |
17 |
30 |
| 2 |
2 |
1 |
2 |
14 |
31 |
| 2 |
2 |
2 |
2 |
16 |
33 |
| 1 |
2 |
2 |
1 |
13 |
86 |
| 1 |
3 |
1 |
1 |
12 |
25 |
| 2 |
2 |
2 |
2 |
0 |
55 |
| 1 |
3 |
1 |
1 |
12 |
33 |
| 2 |
3 |
1 |
1 |
16 |
42 |
| 3 |
3 |
1 |
1 |
16 |
45 |
| 2 |
3 |
1 |
2 |
13 |
71 |
| 1 |
3 |
1 |
1 |
12 |
26 |
| 4 |
2 |
1 |
1 |
6 |
64 |
| 2 |
3 |
1 |
1 |
18 |
61 |
| 3 |
3 |
1 |
2 |
16 |
35 |
| 2 |
2 |
1 |
1 |
18 |
55 |
| 2 |
2 |
1 |
2 |
16 |
28 |
| 4 |
1 |
2 |
1 |
12 |
32 |
| 3 |
2 |
1 |
2 |
17 |
35 |
| 2 |
1 |
1 |
2 |
14 |
39 |
| 3 |
3 |
3 |
1 |
6 |
38 |
| 2 |
2 |
3 |
2 |
9 |
64 |
| 2 |
3 |
1 |
1 |
16 |
27 |
| 2 |
2 |
1 |
2 |
12 |
19 |
| 2 |
2 |
1 |
2 |
17 |
44 |
| 2 |
3 |
1 |
2 |
12 |
45 |
| 0 |
1 |
1 |
1 |
13 |
29 |
| 2 |
3 |
1 |
2 |
12 |
41 |
| 2 |
2 |
1 |
2 |
8 |
24 |
| 3 |
2 |
1 |
2 |
12 |
33 |
| 0 |
2 |
2 |
1 |
16 |
36 |
| 1 |
3 |
3 |
1 |
18 |
48 |
| 3 |
2 |
1 |
2 |
14 |
22 |
| 2 |
2 |
2 |
1 |
14 |
89 |
| 3 |
2 |
1 |
2 |
14 |
60 |
| 1 |
2 |
1 |
2 |
14 |
70 |
| 2 |
3 |
3 |
1 |
18 |
28 |
| 3 |
3 |
1 |
1 |
7 |
40 |
| 3 |
3 |
1 |
2 |
16 |
47 |
| 3 |
3 |
1 |
1 |
19 |
58 |
| 0 |
3 |
1 |
2 |
13 |
64 |
| 2 |
3 |
2 |
2 |
12 |
30 |