Splunk Search

Percentile values in splunk is not matching with Excel Percentile?

vengat4043
Path Finder

Dear Team,

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.

Labels (1)
Tags (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust
Excel's percentile.exc and percentile.inc functions perform two different calculations so it shouldn't surprise us that only one will match Splunk's single percentile function. Splunk's percentile function is similar to percentile.inc in Excel. There is no equivalent to percentile.exc.
---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust
Excel's percentile.exc and percentile.inc functions perform two different calculations so it shouldn't surprise us that only one will match Splunk's single percentile function. Splunk's percentile function is similar to percentile.inc in Excel. There is no equivalent to percentile.exc.
---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out >> As our brave ...