Ad hoc analysis of epi data
Download
1 / 5

Ad hoc Analysis of EPI Data - PowerPoint PPT Presentation


  • 105 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Ad hoc Analysis of EPI Data' - sasha-hanson


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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

    • Can rotate rows and columns to see different summaries of the source data


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)


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


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


ad