How to create an epidemic curve

The video tutorial explains how to represent the onset of illness in an outbreak using EPI curves. It covers the basics of EPI curves, including the axes and the representation of cases over time. The tutorial then demonstrates how to use Microsoft Excel to create EPI curves, organize data, and apply functions like COUNTIF to analyze cases by week and gender. Advanced techniques for refining EPI curves and presenting them effectively are also discussed.

What does the Y-axis represent in an EPI curve?

• Population size

• Time intervals

• Number of cases

• Types of hazards

In the context of EPI curves, what does the term 'incubation' refer to?

• The time taken to collect data

• The duration of the outbreak

• The period before symptoms appear

• The time when the first case is reported

Why is it important to convert data into a table in Excel when creating an EPI curve?

• To apply filters easily

• To change the data format

• To ensure automatic updates with new data

• To make the data look organized

Which function is used in Excel to count the number of cases in a given week?

• VLOOKUP

• COUNTIF

• AVERAGE

• SUM

What is the purpose of using the COUNTIFS function in the context of EPI curves?

• To find the average number of cases

• To look up data in a table

• To sum up all cases

• To count cases based on multiple criteria

What is one of the key elements to add when refining an EPI curve for presentation?

• Data labels

• Axis titles

• Gridlines

• Background color

What is the benefit of dividing cases into categories like male and female in an EPI curve?

• To simplify the data entry process

• To reduce the number of data points

• To identify which group is most affected

• To make the chart colorful