Description QUESTION : Overview For this activity, you’ll use the same data set from the previou ...

---

Description QUESTION : Overview For this activity, 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 as a Word document to submit to your instructor. This is an important process to learn because you’ll follow similar steps to complete Projects One and Three. Step 1: Open the Data Set Use Excel to open the Module Two Activity Data Set you downloaded from the previous page. If necessary, you can re-download the data using the link below. Step 2: Create Your Graphs Remember, different scales of measurement require different types of graphs. In the Module Two Activity Data Set, the “Race” column contains discrete, nominal data, so the best graphic depiction is a pie chart. “Age” is continuous, interval-ratio data, so the best graphic depiction is a histogram. Use Excel’s Analysis ToolPak to create: a pie chart for Race and a histogram for Age, with a bin for each year based on the minimum and maximum data. Once you’ve created both the pie chart and histogram, you’ll need to save each graph as an image file. If necessary, you can refer to Microsoft Support for information on how to save a chart as a picture. Step 3: Upload Images of Your Graphs Use the template on this page to upload images of your two graphs to the webtext. Then click Download Module Two Activity to download your charts in a Word document, which you will then upload to Brightspace for your instructor. UNFORMATTED ATTACHMENT PREVIEW Confidence in Education Confidence in Science 3 2 2 2 1 3 2 2 3 2 2 1 3 2 2 2 2 2 2 4 2 2 1 3 3 3 2 2 2 3 1 2 2 2 3 2 3 2 2 3 2 3 2 2 Race 2 3 3 2 2 2 2 3 2 2 3 3 3 2 2 2 2 2 2 3 2 3 2 3 3 3 2 2 2 2 2 3 3 2 3 2 2 2 3 3 3 3 2 1 Highest Year Age of School Sex 2 1 1 1 3 1 1 3 1 1 1 2 1 1 1 1 1 1 3 1 1 2 3 1 1 1 1 1 1 1 1 3 1 1 1 2 1 1 2 1 1 2 1 1 2 2 2 1 1 2 2 1 2 2 1 2 1 2 2 2 2 1 2 2 2 1 1 2 2 2 2 2 2 2 1 2 2 2 2 2 2 1 2 2 1 2 1 2 20 16 16 10 20 16 18 18 17 13 16 10 16 12 14 15 12 12 12 14 14 13 12 16 17 14 17 16 16 13 12 15 15 18 12 14 9 12 12 13 13 15 10 12 58 61 53 70 51 58 55 65 35 59 46 42 68 73 51 63 60 60 59 55 25 20 31 60 41 39 70 42 55 19 33 30 89 43 56 45 28 33 19 30 51 45 47 24 2 2 2 1 3 2 2 1 2 3 2 3 2 3 2 3 2 2 1 1 2 1 2 3 2 1 4 2 3 2 2 4 3 2 3 2 2 2 2 2 0 2 2 3 0 1 3 1 2 3 3 2 2 2 2 2 2 3 2 3 3 3 2 2 2 2 3 2 3 3 3 3 3 2 3 3 2 2 1 2 1 3 2 3 2 2 3 1 3 2 2 2 3 2 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 2 2 1 2 1 1 1 1 1 1 1 1 1 1 2 1 1 3 3 1 1 1 1 1 1 1 1 2 3 1 2 2 2 1 2 2 2 2 2 1 2 2 1 1 1 2 2 2 1 1 2 1 1 1 2 1 1 1 2 1 2 1 2 2 1 2 1 2 2 2 1 2 2 2 1 1 2 15 16 12 16 16 15 14 12 15 5 16 6 12 12 16 17 14 16 13 12 0 12 16 16 13 12 6 18 16 18 16 12 17 14 6 9 16 12 17 12 13 12 8 12 16 18 14 40 50 48 48 42 25 25 69 31 70 36 76 34 24 32 30 31 33 86 25 55 33 42 45 71 26 64 61 35 55 28 32 35 39 38 64 27 19 44 45 29 41 24 33 36 48 22 2 3 1 2 3 3 3 0 2 2 2 2 3 3 3 3 3 3 2 1 1 3 1 1 1 1 2 1 2 2 1 1 2 1 2 2 14 14 14 18 7 16 19 13 12 89 60 70 28 40 47 58 64 30  Purchase answer to see full attachment User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.