put data into tertile groups in Excel

0

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


excel

• 48 views

21 minutes ago by


Bine

▴

20



Source link