# percentiles

1. ### Calculating percentiles using individual cells instead of an array.

So I need to calculate the 95th and 5th percentile for a specific set of cells. However, my data is 10s of thousands of rows long as it is temperatures from every day of the year over a period of 30-100 years. So I want to work out the 95th percentile for the temperature on January 1st of every...
2. ### formula for converting percentile to T-score or z-score

Hi all, Does anybody know of an excel formula to convert percentiles to T-scores/z-scores? Any guidance or tips would be greatly appreciated... thanks!
3. ### Calculating Standard Deviations of Percentile Groups

I am trying to calculate the standard deviation of rows of data that are in percentiles. I have not made any special subgroups. Rather, I have used COUNTIF and AVERAGEIF by establishing the range and using a cell value as the match criteria. This phrase worked once: IF(E6:E20022=G7...
4. ### Percentile with IF statement

I have a spreadsheet where I am calculating average GPA by month over the course of three years. The data is pulling from a table I have on another spreadsheet. I want to find the 25th percentile for each month. The formula i'm trying to use is...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back