1 / 27

Step-by-step guidance for calculating AAMR

Step-by-step guidance for calculating AAMR. Department of Environmental Epidemiology, University of Occupational and Environmental Health, Japan. Contents. How to DOWNLOAD and COMPILE the necessary data Mortality Database Population Database How to calculate the AAMR.

iago
Download Presentation

Step-by-step guidance for calculating AAMR

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. Step-by-step guidance for calculating AAMR Department of Environmental Epidemiology, University of Occupational and Environmental Health, Japan AAI-7@Jakarta, Indonesia

  2. Contents • How to DOWNLOAD and COMPILE the necessary data • Mortality Database • Population Database • How to calculate the AAMR

  3. Exercise for today is: Calculation of AAMR of Mesothelioma in Japan, 2000-2011 • Data on Mesothelioma death in Japan during 2000-2011 (by age group) • Population of Japan during 2000-2011 (by age group) Necessary data: Software: • Microsoft Excel

  4. How to DOWNLOADthe necessary data Mortality Database

  5. Available (downloadable) from WHO website: http://www.who.int/healthinfo/statistics/mortality_rawdata/en/ How to download the necessary data: Mortality database

  6. Available (downloadable) from WHO website: • http://www.who.int/healthinfo/statistics/mortality_rawdata/en/index.html (Last updated: 25 Feb 2014) How to download the necessary data: Mortality database Click here

  7. How to download the necessary data: Mortality database • International Classification of Diseases, 10th Revision (ICD-10) • Mesothelioma • C45 Mesothelioma • C450 Mesothelioma of pleura • C451 Mesothelioma of peritoneum • C452 Mesothelioma of pericardium • C457 Mesothelioma of other sites • C459 Mesothelioma, unspecified • Data available for the period: 1994-2011

  8. How to download the necessary data: Mortality database • 3160 – Country code for Japan • Sex: 1=Male; 2=Female • Death1: Total number of deaths • Death2 – Death25 - The number of deaths in each age group D2=Death at age 0 year, D3=age 1; D4=age 2; …; D25=age 95+; D26=Deaths at age unspecified (Explanation is available in Documentation file in WHO website) Note: The format of age group differs by country and year

  9. How to DOWNLOAD the necessary data Population Database

  10. How to download the necessary data: Population database • Data are available in WHO Website: http://www.who.int/healthinfo/statistics/mortality_rawdata/en/ (Last updated: 25 Feb 2014) Click here

  11. How to download the necessary data: Population database • 3160 – Country code for Japan • Sex: 1=Male; 2=Female • Pop1: Population at all ages • Pop2 – Pop25 – Population at each age group Pop2=Pop at age 0 year, Pop3=age 1; Pop4=age 2; …; Pop25=age 95+; Pop26=Pop at age unspecified (Explanation is available in Documentation file in WHO website)

  12. －, Data are not available

  13. How to DOWNLOAD the necessary data • Mortality Database • Population Database • How to COMPILE data • Mortality Database • Population Database • How to calculate AAMR

  14. How to COMPILE data

  15. To COMPILE data • Mortality Database • Combine data using same format of age-group. • Combine number of deaths for different anatomical sites and sexes in the same reported year. • Population Database • Combine data using same format of age-group and combine both sexes.

  16. How to COMPILE the necessary data: Mortality database Death 0-4 Death 75+ Combine sexes Combine age-groups into one, respectively Combine anatomical sites and sexes

  17. How to COMPILE the necessary data: Mortality database Mesothelioma Mortality Data of Japan (2000-2011) (C45, Both sex, 2000-2011)

  18. How to COMPILE the necessary data: Population database Pop 0-4 Pop 75+ Combine sexes Combine age-groups into one, respectively

  19. How to COMPILE the necessary data: Population database Population Data of Japan (2000-2011) (Population, Both sex, 2000-2011)

  20. How to DOWNLOAD the necessary data • Mortality Database • Population Database • How to COMPILE data • Mortality Database • Population Database • How to calculate AAMR

  21. How to calculate AAMR Calculation of AAMR (per million person) due to Mesothelioma in Japan, 2000 • Calculate the Age-specific mortality rate • Adjust with standard population

  22. How to calculate AAMR • Calculation of AAMR (per million person) due to Mesothelioma in Japan, 2000 1.Calculate the ASMR

  23. How to calculate AAMR Standard population * For purposes of comparison, the WHO Standard age group 85+ is an aggregate of the age groups 85-89, 90-94, 95-99 Source: Age Standardization of Rates: A New WHO Standard, GPE Discussion Paper Series: No. 31, EIG/GPE/EBD, World Health Organization.

  24. How to calculate AAMR Calculation of AAMR (per million person) due to Mesothelioma in Japan, 2000 2. Adjust with standard population Sum AAMR in year 2000 = Sum of AAMR of each age group Apply same method for each year from 2001to 2011 3.016

  25. Finding AAMR of Mesotheliomain Japan during 2000-2011 WHO-Europe Workshop@Bonn, Germany

  26. AAMR of Mesothelioma in Japan during 2000-2011 (per million persons/year) AAI-7@Jakarta, Indonesia

  27. THANK YOU FOR YOUR ATTENTION AAI-7@Jakarta, Indonesia

More Related