Anthropometric calculators

These Anthropometric Calculators are Microsoft® Office Excel® workbooks which can calculate Z-scores and centiles for height/length, weight, head circumference, and body-mass index for normal children and for children with selected syndromes, based on published norms.

These workbooks are free and do not contain macros. They may be used online or downloaded and saved to your hard drive.

To use these workbooks, you must first enable (one time only) the built-in Analysis Tool-Pak add-in in Microsoft® Office Excel®. To do this:

Microsoft® Office Excel® for PC 2003 and earlier: click on "Tools" on the Standard Toolbar, then click on "Add-Ins". Then make sure that the "Analysis ToolPak" add-in is checked, then click "OK", then close Excel.
Microsoft® Office Excel® for PC 2007 and later: click on the Office Button at the top left of the screen. Then click "Excel Options" at the bottom. Click on "Add-Ins" on the menu on the left, then click on "Go" after "Manage Add-Ins" at the bottom. Then make sure that the "Analysis ToolPak" add-in is checked, then click "OK", then close Excel.
Microsoft® Office Excel® for Mac 2008 and 2011: this step is not necessary.

The Anthropometric Calculators will now work when you open them in Excel®.

There are currently five calculators available:

Anthropometric Calculator for normal children 0–19 years of age (current version: 2013/03/02), based on the Canadian Pediatric Endocrine Group (CPEG) 2012 growth charts (available online at http://cpeg-gcep.net/SitePages/NewsDetails.aspx?newsId=23). Also contains calculators for predicted adult height from bone age, waist circumference and head circumference.
Anthropometric Calculator for normal children 0–19 years of age (current version: 2012/10/26), based on the World Health Organization (WHO) Child Growth Standards [available online at http://www.who.int/childgrowth/standards/en/ for children 0–5 years of age (2006) and http://www.who.int/growthref/en/ for children 5–19 years of age (2007)]. Also contains calculators for predicted adult height from bone age, waist circumference and head circumference. Please also note that the WHO has also made available its free Anthro and AnthroPlus software to do these calculations in these two age groups, respectively.
Anthropometric Calculator for normal children 0–20 years of age (current version: 2012/10/26), based on the US Centers for Disease Control and Prevention (CDC) 2000 growth charts (available online at http://www.cdc.gov/growthcharts/). Also contains calculators for predicted adult height from bone age, waist circumference and head circumference. Please also note that the CDC has made available a nutrition module in its free Epi Info™ software to do these calculations.
Anthropometric Calculator for children with Turner, Noonan, Russell–Silver, Prader–Willi, and Down syndromes, based on various published norms (references in workbook). Current version: 2012/10/26.
Anthropometric calculator for birthweight by gestational age (current version: 2012/10/26), using data based on Canadian and British Columbia–only (birth weight and length and head circumference). References are in the workbook.

Please let us know if you have any questions about these calculators or any difficulties in using them.

Page Last Updated: 12 March 2013

PHSA improves the health of British Columbians by seeking province-wide solutions to specialized health care needs in collaboration with BC health authorities and other partners. Learn more about our agencies and services

Copyright © 2013 BC Children's Hospital. All rights reserved. Terms of Use | Privacy