30 likes | 715 Views
Use of Excel and Episheet for analysis of outbreaks. Preben Aavitsland. Your collection of files during an outbreak. Line list (Excel) Epi curve (Excel) Timeline (Excel) Log (Word, Excel) Presentation (PowerPoint) Outbreak report (Word) Personal notes (Word)
E N D
Use of Excel and Episheet for analysis of outbreaks Preben Aavitsland
Your collection of files during an outbreak • Line list (Excel) • Epi curve (Excel) • Timeline (Excel) • Log (Word, Excel) • Presentation (PowerPoint) • Outbreak report (Word) • Personal notes (Word) • Contact list (Word, Excel) • Data file from analytic study (EpiDataExcel, other)
Analysing case control or cohort study • Enter questionnaires • Epidata or EpiInfo or Excel or other • Transfer data to programme for analysis • Excel, EpiInfo, Stata, SPSS or other • In Excel: • Prepare file • Use pivot-functions • Transfer numbers to Episheet calculator On your CD-ROM