I have a set of data say {4,7,7,10,10,12,12,14,15,67} and i want to know the 95th Percentile. I used Excel and Online calculator.

In Excel, formula i used : =PERCENTILE.INC(A1:A10,0.95) and result = 43.6

But this online percentile calculator yielded a result of 67

Which one is right?

Mar 30, 2022 in Database 342 views

## 1 answer to this question.

Syntax
PERCENTILE(array,k)

The following are the arguments to the PERCENTILE function:

array is a must. The set of data that determines one's relative position.

The letter k is required. In the range of 0..1, the percentile value.

Remarks
PERCENTILE returns the #VALUE! error value if k is not a number.

PERCENTILE returns the #NUM! error value if k is 0 or if k > 1.

PERCENTILE interpolates the value at the k-th percentile if k is not a multiple of 1/(n - 1).

Example
The 30th percentile of the list will be found in cells E2:E5 in this case.

• 23,260 points

## How do I change the menu language of Excel Online?

Click on App launcher from any worksheet ...READ MORE

## Connection vs Query in Excel data model

There are various ways to construct and ...READ MORE

## SQL vs NoSQL

Well, it depends on what you are ...READ MORE

## Clustered vs Non-clustered Indexes

Clustered indexes - The indexes according to ...READ MORE

+1 vote

## DELETE vs TRUNCATE vs DROP command

After the execution of ‘DELETE’ operation, COMMIT ...READ MORE

## IN vs OR in the SQL WHERE Clause

I assume you want to know the ...READ MORE

## Which is better database vs. flat files?

Difference between database and flat files are ...READ MORE

## LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

At the top level there are mainly ...READ MORE