Epidemiological Calculations

profiledanlouie

File Week 1 Epidemiological Tools.xlsx Click for more options (32.448 KB) 


There are a variety of tools that an epidemiologist might have at his or her disposal. The most common tools that are used in the field are SAS, SPSS, EpiInfo, R, and many others. These require significant time and diligence to become proficient at each of these statistical tools. However, almost every office has Microsoft Excel, Numbers (the Mac equivalent), or Google's Excel-like product.

Often times epidemiological calculations can seem/appear intimidating. However, if you let the excel document do the work for you then you do not have to worry about making errors in simple math. Please download the attached excel sheet. You will be doing the following:

Calculating:

Crude Mortality Rate

Age-Specific Mortality Rate

Age-Adjustment (using the direct method)

Prevalence 

Incidence Density

Graphing:

Incidence and Prevalence

You will need to go to the American FactFinder, then click on Advanced Search in the area marked state, county, or place type your community or a community near you and select enter. You are going to want information from a table that contains Age and Sex in the title.

  • Posted: 19 days ago
  • Due: 
  • Budget: $8
Tags: EXCEL
Answers 1
  • Calculations
    Answer rating:5Stars out of1ratings

Purchase the answer to view it

blurred-text