There are 4 cases with an onset date of July 4 There are 4 cases with an onset date of July 3 There is 1 case with an onset date of July 1 There is 1 case with an onset date of June 28.The dates range from (earliest date) to (latest date). In the PivotTable, select the Drop Down menu beside the Row Labels, and Sort Oldest to Newest.
Section C: Earliest and Latest Illness Onset Datesģ. Section B: Number of Cases in each Province/TerritoryĬase counts by province: AB=3, BC=1, MB=4, and SK=4. There are 6 Females and 6 Males in this cluster – total of 12 cases. Drag and drop the following variables into the respective Labels: Note: Uncheck all variables in the PivotTable Field List before you begin each section.Ģ. Part 2: Descriptive summaries using PivotTables Note: A variable can only be added once to either the Report Filter, Row Labels, or Column Labels areas. Try adding two variables, and then three, etc. Repeat step 7 using different variables and play around with the PivotTable, moving different variables into different labels. You should see the Count of National ID = 12 again.Ĩ. Now, drag the Sex variable back into the list (or simply, unclick the variable in the list) to remove it from the PivotTable. With either, you should see 6 Males (M) and 6 Females (F). Try dragging the same Sex variable from the Column Label and drop it into the Row Labels. Now, drag and drop the Sex variable into the Column Labels. To view the field list,click any of the cells that contain the PivotTable on your worksheet. Note: If you select cells outside of the PivotTable, the PivotTable Field List will disappear. The empty PivotTable will now show: Count of National ID = 12. National ID), and drag and drop it into the Values field. Click on a variable from the PivotTable Field List that has an entry for each case (e.g.
If the Table/Range is different from what is selected by the dotted lines, you can click on the expand icon and select a new range. Select the data that you want to analyze: By default, Excel will select the data in your excel sheet and outline it with dotted lines.In the Create PivotTable window, two options must be selected: (in earlier versions, Microsoft Excel 2003/XP/2000/97, select Data > PivotTable and Pivot Chart)Ĥ. Microsoft Excel 2007–2010: In the Ribbon menu, select the insert tab and click on PivotTable. Select any cell (Excel will automatically determine the range required for the PivotTable based on the data), or highlight the range of the data you want to include in your PivotTable.ģ. Retrieve the file Module 2 – Line List.xlsx and save a copy to your desktop. Column titles should appear across a single rowįor this exercise, you have been provided with a “cleaned” line list.Blank rows and columns should be removed.Data entries should be consistent choose a single way to represent your data:.Part 2: Descriptive summaries using PivotTablesīefore you begin, any data set you use to create a PivotTable or Epi Curve must be “cleaned”:.This exercise will use an outbreak line list to build PivotTables, extract descriptive epidemiology statistics from those PivotTables, and create epidemic (epi) curves. You can use this to analyze the data, make comparisons, detect patterns and relationships, and discover trends” (Microsoft Corporation, 2014). A “PivotTable® is an interactive table that automatically extracts, organizes, and summarizes your data.