1 / 5

Ad hoc Analysis of EPI Data

Ad hoc Analysis of EPI Data. Use of Microsoft Excel. Training Workshop for EPI Data Managers and Surveillance Focal Persons (Day 4) Ulaanbaatar, Mongolia – 25-28 August 2009. What is a ‘Pivot Table’?. Pivot table An interactive table that quickly combines and compares large amounts of data

Download Presentation

Ad hoc Analysis of EPI Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Ad hoc Analysis of EPI Data Use of Microsoft Excel Training Workshop for EPI Data Managers and Surveillance Focal Persons (Day 4)Ulaanbaatar, Mongolia – 25-28 August 2009

  2. What is a ‘Pivot Table’? • Pivot table • An interactive table that quickly combines and compares large amounts of data • Can rotate rows and columns to see different summaries of the source data

  3. How to create a pivot table • Demo • Gender of confirmed measles cases by aimag/sourn • Understanding the data: • iCaseID: Unique internally generated ID • sGender: Gender (M=Male; F=Female) • sLevel1: Aimag • sLevel2: Sourn • sConfirmedM: Confirmed measles case? (Y=Yes; N=No)

  4. How to create a pivot table • Exercise • Check lab results of confirmed measles/rubella cases • Understanding the data: • iCaseID: Unique internally generated ID • iMIgM1: Measles IgM result (1=Positive;2=Negative; 3=Equivocal; 4=Pending; 8=Not done; 9=Unknown) • iRIgM1: Rubella IgM result • sConfirmedM: Confirmed measles case? (Y=Yes; N=No) • iConfMethodM: Method of confirmation of measles (1=Lab confirmed; 2=Epi-linked; 3=Clinically) • sConfirmedR: Confirmed rubella case? • iConfMethodR: Method of confirmation of rubella

  5. How to make charts • Demo • Gender of suspected measles cases by aimag • Understanding the data: • iCaseID: Unique internally generated ID • sGender: Gender (M=Male; F=Female; U=Unknown) • sLevel1: Aimag

More Related