| | |
 
 
For professionals
 Quick Links
 
     
 

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. Please note that for weight-based measures (weight, body-mass index, weight-for-length and weight-for-height), values for percentiles <1 or >99 and Z-scores <–3 or >3 are not reported, because of the non-normal distribution of weights in children.

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

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: We also have available a Microsoft® Excel–based program that can do batch calculations for CPEG, WHO and CDC parameters. If you're intersted, please contact us for more information.

Also take a look at the height- and weight-plotting app for the CPEG growth charts.

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

Page Last Updated: 9 April 2014