Module Two Activity: Graphing

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 histogram. Then, using the interactive template at the bottom of the page, you’ll upload your charts as images and then download them in a Word document to submit to your instructor. This is an important workflow to learn because you’ll do it again as part of Projects One and Three. To help you create graphs or charts using Excel and the Analysis ToolPak, refer to this Graphing Tips and Tricks document.

A pie chart for Race A histogram for Age, with a bin for each year based on the minimum and maximum data

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