Overview

This course will require you to create graphs using Microsoft Excel and the Analysis ToolPak add-in. For this activity, you will use the same data set as the Module Two Activity: Descriptive Statistics Quiz to create a pie chart and a histogram. This activity prepares you for creating graphs for Projects One and Three.

Note that you will submit images in your Soomo webtext of the two graphs you will create. This is important because you will need to do this again as part of Projects One and Three. For more information about how to save graphs as images, refer to the Save a Chart as a Picture resource from Microsoft Support (https://support.microsoft.com/en-us/office/save-a-chart-as-a-picture-254bbf9a-1ce1-459f-914a-4902e8ca9217).

Prompt

For this activity, you will submit a Word file containing two images of graphs: a pie chart for Race and a histogram for Age. You will complete this activity using your Soomo webtext writing template and the data set provided in Soomo.

Specifically, you must address the following:

1. Create a pie chart for Race.
2. Create a histogram for Age, with a bin for each year based on the minimum and maximum data.

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