I need the percentile to tell me who is in the 25% percentile. Under the rules I have to report, if you entries 1-100, the 25% percentile should be 25. Testing the function on that data set, it returns a value of 25.75. There is no data value of that. It should be 25.
Any idea on how I can fix this?
The 25th percentile for 1-100 is not 25. It is 25.75, as Excel is saying. However, what I think you mean is the 25th percentile for 0-100 is 25. Insert a row and add a zero to your data. What does that return?
Spread the love, add to the Rep
"None of us are as smart as all of us."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks