I have a percentile data set bmiage from the CDC that includes the L,M, and S data---is there a formula in Excel that will calculate the Z-score and the percentile that corresponds to that Z score for a given parameter?
I need to be able to determine the child's percentile on a given day based on age and BMI for children age 2 and above.
That is, if the child is X months old and has BMI of Y; what percentile does this BMI fall at?
There is a similar posting for this issue but it uses the wtageinf table and I am not sure how to change the formulas (males, females)to use the bmiage data table.
Thanks,
Hank
I need to be able to determine the child's percentile on a given day based on age and BMI for children age 2 and above.
That is, if the child is X months old and has BMI of Y; what percentile does this BMI fall at?
There is a similar posting for this issue but it uses the wtageinf table and I am not sure how to change the formulas (males, females)to use the bmiage data table.
Thanks,
Hank