(Steps Shown) Food poisoning. Below are data on 18 people who fell ill from an incident of food poisoning. The data give each person's age in years, the
Question: Food poisoning. Below are data on 18 people who fell ill from an incident of food poisoning. The data give each person's age in years, the incubation period (the time in hours between eating the infected food and the first signs of illness), and whether the victim survived (S) or died (D).
Person : 1 2 3 4 5 6 7 8 9
Age 29 39 44 37 42 17 38 43 51
Incubation 13 46 43 34 20 20 18 72 19
Outcome D S S D D S D S D
Person 10 11 12 13 14 15 16 17 18
Age 30 32 59 33 31 32 32 36 50
Incubation 36 48 44 21 32 86 48 28 16
Outcome D D S D D S D S D
- Create an Excel spreadsheet of the data and use the chart wizard to construct a scatter plot of incubation period against age, using different symbols for people who died and those who survived.
- Is there an overall relationship between age and incubation period? If so, describe it.
- More important, is there a relationship between either age or incubation period and whether the victim survived? Describe any relationships that seem important here.
- Are there any unusual cases that may require individual investigation?
Deliverable: Word Document 