Reference no: EM133868105

Videos: Epi Info and read the Ep iInfo User Guide

Data Analysis using the Dashboard

Student Practice 1
See if you can find the answers to the following questions. Steps by step instructions and answers are available in the Appendix section of the manual.

1. - What racial category (RACE) has the highest frequency in this data set?

2. - Does the answer for #1 still hold true when the groups are separated into males and females?
3. - How many people drank water (WATER) and ate their meal at 2:00 pm (ATEAT2)?
4. - What is the average age of people in this data set by case outcome (OUTCOME) and sex (SEX)?

Creating MxN Tables

You will use the MxN / 2x2 gadget to examine the relationship between two or more categorical values. You want to see if there might be a connection between each person's relationship with the company (employee, relative of employee or friend of employee) and illness.

Follow the steps below to create an MxN table.

1. - Ensure all filters have been cleared and that you are working with the full set of 150 records.
2. - Right-click on a blank portion of the Dashboard canvas. A context menu appears.
3. - Select Add Analysis Gadget > MxN / 2x2 from the context menu. The Cross tabulation (MxN / 2x2) gadget appears.
4. - Select AttendeeType in the Exposure drop-down list.
5. - Select Ill in the Outcome drop-down list.
6. - Click OK. The cross tabulation of AttendeeType by Ill appears in Figure 79.

Student Practice 2

You've been shown how to display data using gadgets, filter records based on one or more conditions, and manipulate data by creating new variables. Your main objective is to identify the source of this outbreak. Previously, when 2x2 tables were performed on the food items, you noticed that there were multiple food items with RR > 1. Perhaps you need to investigate the ingredients used to prepare the food items. A common ingredient might have been the cause of the outbreak. Get online assignment help now!

Here is a list of the different ingredients that were used to prepare the different items:

• Chef salad- Iceberg lettuce, ham, turkey, egg, cheddar cheese, tomato, carrots, Italian dressing
• Caesar salad-romaine lettuce, croutons, parmesan cheese, lemon juice, olive oil, Worcestershire sauce, anchovies, garlic, black pepper, Caesar dressing.
• Garden salad- romaine lettuce, tomato, onion, cucumber, carrot
• Peanut butter and Jelly sandwich- Grape jelly, Jif peanut butter, wheat bread
• Reuben sandwich- Rye bread, corned beef, sauerkraut, Thousand Island Dressing, Swiss cheese
• Grilled Cheese- Cheddar cheese, Provolone, wheat bread
• Egg Salad Sandwich- egg, mayonnaise, relish, white bread
• Ham and Cheese Sandwich- Ham, Provolone, mayonnaise, wheat bread
• Chicken Sandwich- Grilled chicken, honey mustard, lettuce, tomato, wheat bun
• Peanut butter cookies-peanut butter cookie dough
• Chocolate chip cookies- chocolate chip cookie dough
• Water
• Iced tea-water and tea bags
• Potato chips- Kettle chips

In the Visual Dashboard, you can create new variables using Conditional Assignments in order to group food items consumed during the picnic to a specific ingredient. Perform 2x2 tables with these new variables to continue your analysis. Try using the Combining Variables example shown above to create variables for each of the ingredients you consider can be the possible source for the outbreak.

1. For this assignment, you will complete the Epi Info 7 Salmonella Outbreak Tutorial. Download Salmonella tutorial: Epi InfoTM 7 Salmonella Outbreak Tutorial.

2. Read the introduction to the Salmonella Outbreak tutorial (pgs. 1-14).

3. Complete lesson 4 (begins on p. 111). NOTE: Make sure to use the correct data set and no filters are applied (there should be a total of 309 reports).

4. Complete Lesson 4: Student Practice 1 and 2 (pgs. 132 and 155). NOTE: The answers to these questions are in the appendix. Check your work before submitting.

5. Save your work with all relevant tables (remove training tables not used to answer questions and line lists) as an HTML file (right-select and "Save output as HTML"). See p. 156 for further directions. You must include all tables you made during completion of Student practices 1 and

2. This is critical to your grade. If you do not submit all tables that show how you determined the answers to the questions in the student practices, you will not receive credit for that answer.

8. Submit your work by answering the questions from step 6 above in a Word or PDF doc. Submit both the Word or PDF and the HTML file you saved in step 7 (do not submit .cvs files). For each question, you must provide rationale for your answer. Your rationale should include references to the tables and graphs you attach in the HTML file. Your HTML file must show the date and time of when the analysis was run - this will be the heading or top lines of your file.