Chapter 5 Activity Your superior statistical skills are now known across the area, and you've been contacted by an agency looking to discover the cause of the outbreak. This agency has entrusted you with an Excel file with five different sheets of data. Mission: The agency wishes to have easy-to-read graphical displays of their data to present to the public. They also have some specific questions they would like answered for each of the datasets. Start with the data on \"Sheet 1.\" The data on sheet 1 lists the ethnicity for 50 subjects infected with the virus. 1. What type of graph would be most suitable for this dataset? a. Boxplot c. Line Chart e. Bar Chart b. Histogram d. Scatterplot f. Pie Chart 2. Which ethnicity had the highest number of subjects infected with the virus? Now, look at the data on \"Sheet 2.\" The data on sheet 2 show the number of newly infected individuals per day for the first 30 days. 3. What type of graph would be most suitable for this dataset? a. Boxplot c. Line Chart e. Bar Chart b. Histogram d. Scatterplot f. Pie Chart 4. For what 5-day range was the number of newly infected individuals the highest? You're now ready to look at the data on \"Sheet 3.\" The data on sheet 3 show body temperature for 30 of the subjects along with a variable representing the new test developed to measure a special serum in the blood related to the virus. 5. What type of graph would be most suitable for this dataset? a. Boxplot c. Line Chart e. Bar Chart b. Histogram d. Scatterplot f. Pie Chart 6. What type of relationship is seen between the serum level and body temperature? \"Sheet 4\" shows the age in years for each of the 50 subjects. 7. What type of graph would be most suitable for this dataset? a. Boxplot c. Line Chart e. Bar Chart b. Histogram d. Scatterplot f. Pie Chart 8. Is it reasonable to assume this data follows a normal distribution? Finally, \"Sheet 5\" shows data representing the weight in pounds of 30 subjects divided by gender. 9. What type of graph would be most suitable for this dataset? a. Boxplot c. Line Chart e. Bar Chart b. Histogram d. Scatterplot f. Pie Chart 10. Are there any outliers present in the data? If so, where are they? Subject 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Ethinicity Hispanic Other Race Hispanic Black Other Race White Black Other Race Hispanic Black Black White Other Race Black Black White Black Black Hispanic Black Black Black Black Black Other Race Black Other Race Black Black Black Black Other Race White White Other Race Other Race Other Race Hispanic Black White Hispanic Black Hispanic Black 45 46 47 48 49 50 Other Race Other Race Black Hispanic Hispanic Black Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 # Infected 11 16 22 32 46 57 71 65 56 74 92 63 121 140 123 416 397 467 381 424 130 179 163 218 251 187 275 224 293 270 Serum 50 55 8 51 22 93 15 9 63 77 22 3 17 91 41 2 64 5 27 85 69 49 70 54 60 20 74 55 92 1 Body Temperature 97 95.5 91.8 99.1 94.2 102.3 91.5 91.9 99.3 102.7 93.2 95.3 93.7 104.1 99.1 95.2 99.4 91.5 94.7 98.5 98.9 94.9 98 99.4 98 94 98.4 98.5 104.2 90.1 Subject 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Age 78 46 66 67 75 40 49 25 75 25 28 42 61 27 37 80 69 29 69 45 48 41 11 42 57 63 29 92 23 33 62 43 51 30 48 23 67 74 36 42 50 81 68 66 26 33 34 Bins 10 20 30 40 50 60 70 80 90 100 48 49 50 53 53 72 Males 174 159 209 180 153 184 256 207 218 172 153 160 173 173 152 Females 142 124 144 139 197 151 131 198 174 140 195 178 121 124 133