Calculating percentile - Excel vs online

Question

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.

Both gave different answers.

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?

Answer 1

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.