Help calculating BMI percentiles using data set!
I have a data set (~400 patients) that I need BMI percentiles for and I'm reaalllyyy not trying to calculate them all manually 🥲 There's little guidance I could find online on how to do this, so I've been winging it but am now stuck.
For pediatrics BMI%s, you have to use the CDC BMI for age chart LMS parameters and then calculate a Z-score. This is a preview of the sheet from the CDC that I've titled CDC_LMS:
In a separate sheet, I have the following columns with my patient data:
I want to pull over the corresponding L parameters for sex and age from the CDC_LMS sheet, so the formula I found to use was:
=XLOOKUP(1,(CDC_LMS!A:A=A2)*(CDC_LMS!B:B=B2),CDC_LMS!C:C)
but all I'm getting is #N/A errors. The formulas to pull over the M and S columns are similar and I'm not having success with those either.
Honestly I have no idea if I'm even on the right track. Any guidance would be greatly appreciated!
[link] [comments]
Want to read more?
Check out the full article on the original site