To calculate a percentile for data in two different ranges, use the following formula:
Formula:
=PERCENTILE({range1;range2}, percentile)
Example:
Formula:
=PERCENTILE({A1:A4;D8:D11}, 0.9)
Steps:- Enter the formula in the cell where you want to display the result.
- Replace "range1" and "range2" with the cell ranges that contain the data you want to calculate the percentile for.
- Replace "percentile" with the percentile value you want to calculate (e.g. 0.9 for the 90th percentile).
- Make sure to separate the two ranges with a semicolon (;) inside curly braces {}.
- Ensure that the ranges have the same number of columns to avoid errors.