Calculating percentile - Excel vs online

0 votes

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?

Mar 30 in Database by Edureka
• 9,320 points
14 views

1 answer to this question.

0 votes

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.

Excel PERCENTILE function to return the 30th percentile of a given range with =PERCENTILE(E2:E5,0.3).

answered Mar 31 by Edureka
• 8,820 points

Related Questions In Database

0 votes
1 answer

How do I change the menu language of Excel Online?

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

answered Apr 4 in Database by Edureka
• 9,320 points
15 views
0 votes
1 answer

Connection vs Query in Excel data model

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

answered Apr 4 in Database by Edureka
• 9,320 points
31 views
0 votes
2 answers

SQL vs NoSQL

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

answered Aug 11, 2018 in Database by slayer
• 29,310 points
333 views
0 votes
1 answer

Clustered vs Non-clustered Indexes

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

answered Aug 20, 2018 in Database by DataKing99
• 8,240 points
219 views
+1 vote
1 answer

DELETE vs TRUNCATE vs DROP command

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

answered Aug 23, 2018 in Database by CodingByHeart77
• 3,720 points
1,155 views
0 votes
1 answer

IN vs OR in the SQL WHERE Clause

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

answered Sep 24, 2018 in Database by DataKing99
• 8,240 points
420 views
0 votes
1 answer

Which is better database vs. flat files?

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

answered Oct 11, 2019 in Database by Omaiz
• 560 points
6,548 views
0 votes
1 answer

LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

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

answered Feb 4 in Database by Neha
• 6,260 points
76 views
0 votes
1 answer

Date difference: different results in Excel vs. Python

To calculate the date difference, we can ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
41 views
0 votes
1 answer

How do I change the menu language of Excel Online?

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

answered Apr 1 in Database by Edureka
• 8,820 points
18 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP