Bine
New member
- Joined
- Dec 3, 2020
- Messages
- 12
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Excel 2016
Dear all,
I have the following problem:
I want to put my data into tertiles:
BMI Tertile Group
20 Low
33 Medium
45 High
32 Medium
Currently I only have the column "BMI".
How do I do that? I can only find a quartile function in excel and this only tells me the number of the quartile but it doesnt put data into quartiles/tertiles.
Thank you so much for any hint!
Bine
I have the following problem:
I want to put my data into tertiles:
BMI Tertile Group
20 Low
33 Medium
45 High
32 Medium
Currently I only have the column "BMI".
How do I do that? I can only find a quartile function in excel and this only tells me the number of the quartile but it doesnt put data into quartiles/tertiles.
Thank you so much for any hint!
Bine