We are used p25() and p75() functions to retrieve Percentile values for a range of values in Splunk. To validate the Percentile value we calculated the Percentile values in excel by using the Percentie.Exc() and Percentile.Inc() function.
From the comparision we came to know that the Percentile values are same in Splunk and Excel for the Percentile.Inc(). But the Percentile.Exc() function values differs from the Splunk Percentile Values.
Do we have Percentile function like excel (i.e, Percentile.Exc() and Percentile.Inc()) in Splunk?
Attached Excel sheet for your reference.