Quantile calculation in excel, is there a way to do that? I have values that I want to calculate the quantile(0.05, 0.50, and 0.95). I have tried search online but all i found is quartile calculations, not quantile. Most of info i got online cannot solve the problem. The reason I want this is to cross check values from python calculation results. Looking forward for any help.
In my excel, I have all the values in column "G", as example: I want to calculate the quantile(0.05, 0.5, and 0.95) of all values in "G" column. I want to calculate in excel...is there ways to do that? thanks
An old post, but for anyone else, I've used Percentile in the past and it's worked for what I've wanted to do.
This will give the 10% value.