Recent Comments

Home PARENTING Trick, Tips & Tools How to Build Infant/Baby/Child Growth Percentile (WHO Standards) Calculator using MS Excel/StarOffice Calc?
Multithumb found errors on this page:

There was a problem loading image /home2/lettert1/public_html/images/stories/2011_11/WHO_WeightforAgeChart.jpg
There was a problem loading image /home2/lettert1/public_html/images/stories/2011_11/ChildGrowthPercentileCalculator.jpg
There was a problem loading image /home2/lettert1/public_html/images/stories/2011_11/StarOffice_ChildGrowthPercentile.jpg

I did a few papers on statistics during my undergrad school. I played with statistical tools pretty much extensively during my postgraduate days. I manipulated some statistical terms to put pictures on figures in the business world. Percentile is not an alien term to me but it has never come this close into my life as of now, after I become a mother!

I am a bit obsessed with Percentile recently. Not because Austin is falling out of his curve, he is doing perfectly fine. But as I was researching for a reliable online child growth percentile calculator, I found that percentile range churned out across the calculators that I tried, they gave me different result! This means they are calculated based on different logic, that only make sense that they are referring to different sources in each. And above all, these so-called geeky tools (that I came across) are outdated! How I wish to get the latest revision according to WHO Child Growth Standards. The good news is I found a fantastic website that discussed thoroughly on how to interpret Infant Growth Chart and keep parents’ worry at bay!

Armed with limited resources, let me share with you a snapshot of Austin’s growth chart. If you are interested to keep track on how your child is doing on a softcopy, you may crunch the data like how I did on spreadsheet.
All you need is your child’s growth measurement e.g. weight, length, head circumference by month. And a PC. Missing a few points (like mine) works too, no worries about that. 

Step 1: Gather the weight record for your baby by month e.g. Month 1 = 3.6 kg or (7.92 lbs/2.2).
Step 2:
Open a new MS Office - Excel spreadsheet. Tabulate the month and weight (kg) in Column A (starts from A3) and Column B (starts from B3). Leave A2 and B2 for the headers i.e. Month and Baby’s Name, respectively. 

Step 3:
Insert the WHO child growth standards for weight into this data range ($C$3:$I$27) from here.
If baby Boy: Data Table for Boys Length-for-age and Weight-for-age Charts
If baby Girl: Data Table for Girls Length-for-age and Weight-for-age Charts

Step 4: Go to column J and compute the percentile range using MS Excel built-in formula i.e. Nested IF THEN ELSE. Or, copy the code below and paste into cell J3. Input the same formula for the rest in the row (J4 to J27).


Tips to copy percentile formula:
Click on cell J3. When a tiny cross sits at the bottom right of the cell J3, drag it down to highlight the rest of cells in the same row. 

Tips to read the nested IF, THEN, ELSE: 
IF B3 is “nil”, THEN returns “nil”, ELSE(IF B3 is less than value in C3, THEN returns “Below 5th”, ELSE(IF B3 is less than value in D3, THEN returns “5-10th”, ELSE…..

Tips if you use StarOffice Calc (open source):
Exchange all the comma (,) with semi-colon(;) like below.



Step 5: Congratulations! You are done. 

If you like this new toy, you may repeat with other parameters e.g. length or head circumference, and insert the respective WHO standards.  

Well, it is not a hit on button that gives all the results. Crude. Exploiting the built-in formula of MS Excel or StarOffice Calc, it gives an accurate percentile range of my baby every month! I only need to build it once, and every percentile is on the same page for 24 months.

If you found a better way to do it, please leave behind some clues. I want to learn from you :)


Add comment