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. A layout section (at the bottom) for rearranging and repositioning fields.Д¦.A field section (at the top) for fields to be added and removed from the PivotTable.A side pane вЂ“ PivotTable Field List (lists all column titles from the linelist).An empty PivotTable that will be used to build a report.A new set of options in the ribbon вЂ“ PivotTable Tools.A new worksheet where the PivotTable has been placed вЂ“ Sheet 4 (if the New Worksheet option was selected).If you wish to change this, select Existing Worksheet, and once again, use the expand icon can to choose a location on an existing worksheet. Select where you want the PivotTable report to be placed: By default, the chart/report will be placed on a New Worksheet.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.

Dual axis function of excel pivot chart