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

May be you can use BMI quantiles. Any thing below 25% is low, any thing above 75% is high and medium is between 25%-75%. Or you can use ntile option from dplyr to divide the data into 3 groups.