Calculate a Z-Score in a Form

This page will walk through an example of setting up a form to calculate a z-score based on a age in months, gender and weight.  

First upload the following z-score table using the Manage Lookup Tables page.  This table covers children between 0 and 60 months of age, but you can modify the table as needed for your project. 

zscores.xlsx

Including Lookup Table Information in the Form

Once we've defined a zscore lookup table, we need to reference it in our form.  Edit the form XML and add an "instance" line that references the name of the table.  You can place this above any existing instance tags in your form.  

Calculating the Z-Score

In your form, first add three questions, one for the gender, age in months and measured weight.  (You can also load these from a case if you've previously captured them elsewhere).  

Then add a hidden value (zscore) to calculate the approximate z-score from the table.  The calculation for this hidden value should be:

This hidden value will be -3, -2, -1, or 0 which corresponds to the child being more than -3, -2 and -1 standard deviations from the mean.  You can then use this hidden value for further calculations or display it back to the user.