PBHE427 Week 7 Assignment
brittneysierra
PBHE427Week7assignment.xlsxNurse's Interview
| Gender | Name | Age | Ate at cafeteria? | ill? | Onset | Symptoms | ||||
| M | John | 55 | Yes | Yes | 5-Feb | F,C,H,N | Symptoms | Code | ||
| M | Bill | 42 | No | No | n/a | n/a | Nausea | N | ||
| F | Nancy | 38 | Yes | Yes | 3-Feb | Ac, F,C,D | Vomiting | V | ||
| F | Kate | 32 | Yes | Yes | 1-Feb | Ac, F,C,D, H | Abdominal cramps | Ac | ||
| M | William | 25 | No | Yes | 2-Feb | F,C,H,V | Diarrhea | D | ||
| M | Henry | 52 | No | No | n/a | n/a | Fever | F | ||
| F | Patricia | 20 | Yes | No | n/a | n/a | Chills | C | ||
| F | Ebony | 29 | No | No | n/a | n/a | Headache | H | ||
| F | Vanessa | 24 | No | No | n/a | n/a | Blood in the stool | Bs | ||
| F | Catherine | 36 | Yes | Yes | 3-Feb | Ac, F, C, D, Bs | ||||
| M | Sean | 31 | Yes | Yes | 4-Feb | F, C, D, H | ||||
| M | Rodney | 41 | Yes | Yes | 1-Feb | Ac, F,C,H | ||||
| F | Terese | 50 | Yes | No | n/a | n/a | ||||
| M | Graham | 60 | Yes | Yes | 5-Feb | D,H,V | ||||
| F | Lucy | 49 | No | No | n/a | n/a | ||||
| M | Peter | 33 | Yes | Yes | 4-Feb | Ac, D, N | ||||
| F | Chelsea | 45 | Yes | Yes | 3-Feb | D,H,V | ||||
| F | Joan | 44 | Yes | Yes | 2-Feb | F,C,H | ||||
| F | Colleen | 48 | Yes | Yes | 1-Feb | Ac, D, N | ||||
| M | Ted | 52 | No | No | n/a | n/a |
Epi Curve
| Onset Date | # of cases | Use Data from Step 2 Spreadsheet to complete "# of cases" column (you will notice the y-axis change range as you input data) | ||||
| 29-Jan | * | |||||
| 30-Jan | ||||||
| 31-Jan | ||||||
| 1-Feb | ||||||
| 2-Feb | ||||||
| 3-Feb | ||||||
| 4-Feb | ||||||
| 5-Feb | ||||||
| 6-Feb | ||||||
| 7-Feb | ||||||
Click here to insert your title
# of cases 43129 43130 43131 43132 43133 43134 43135 43136 43137 43138
Retrospective Cohort Study
| Foods in cafeteria | Ate Food | Did Not Eat Food | |||||
| Ill | Well | Attack Rate | Ill | Well | Attack Rate | Risk Ratio | |
| Baked chicken | 10 | 1 | 0.91 | 2 | 7 | 0.22 | 4.14 |
| Spinach | 9 | 5 | 3 | 3 | |||
| Mashed potatoes | 8 | 3 | 4 | 5 | |||
| Egg salad | 1 | 1 | 11 | 7 | |||
| Jello | 1 | 1 | 11 | 7 | |||
| Rolls | 7 | 7 | 5 | 1 | |||
| Brown bread | 3 | 3 | 9 | 5 | |||
| Milk | 4 | 4 | 8 | 4 | |||
| Coffee | 3 | 8 | 9 | 0 | |||
| Water | 6 | 6 | 6 | 2 | |||
| Cake | 2 | 5 | 10 | 3 | |||
| Vanilla ice cream | 5 | 6 | 7 | 2 | |||
| Chocolate ice cream | 3 | 2 | 9 | 6 | |||
| Fruit salad | 7 | 4 | 5 | 4 |
