Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Vincdc
 
Posts: n/a
Default Percentile function

Hello:
I am trying to find out the lower 25% of my dataset. I use the function like
Percentile(A1:A35, 0.25). It returns a value for me. Does it mean that any
number in the data set under this value belongs the lower 25% of the dataset?
I checked the Excel Help file and it does not help. Can anyone give me some
details?
Thanks in advance!
  #2   Report Post  
Michael R Middleton
 
Posts: n/a
Default

Vincdc -

I am trying to find out the lower 25% of my dataset. I use the function
like Percentile(A1:A35, 0.25). It returns a value for me. Does it mean
that any number in the data set under this value belongs the lower 25% of
the dataset? <


Yes. You should get the same result with QUARTILE(A1:A35,1).

I checked the Excel Help file and it does not help. Can anyone give me
some details? <


Min value in the data range is assigned percentile 0. Max value is assigned
1. Other data values, in rank order, get a step increment of 1/(n-1), where
n is the total number of values in the data range. Linear interpolation is
used for intermediate percentiles.

Caution: There are various ways to calculate percentiles. Excel's method is
just one method. So, if you refer to statistics books, you may see some of
the others. For example, the min value could be percentile 1/(2n) and max
value could be (2n-1)/(2n), with steps of 1/n, with extreme percentiles
undefined. The differences among methods are usually small for very large
data sets.

- Mike

www.mikemiddleton.com


  #3   Report Post  
Vincdc
 
Posts: n/a
Default

Thanks!

"Michael R Middleton" wrote:

Vincdc -

I am trying to find out the lower 25% of my dataset. I use the function
like Percentile(A1:A35, 0.25). It returns a value for me. Does it mean
that any number in the data set under this value belongs the lower 25% of
the dataset? <


Yes. You should get the same result with QUARTILE(A1:A35,1).

I checked the Excel Help file and it does not help. Can anyone give me
some details? <


Min value in the data range is assigned percentile 0. Max value is assigned
1. Other data values, in rank order, get a step increment of 1/(n-1), where
n is the total number of values in the data range. Linear interpolation is
used for intermediate percentiles.

Caution: There are various ways to calculate percentiles. Excel's method is
just one method. So, if you refer to statistics books, you may see some of
the others. For example, the min value could be percentile 1/(2n) and max
value could be (2n-1)/(2n), with steps of 1/n, with extreme percentiles
undefined. The differences among methods are usually small for very large
data sets.

- Mike

www.mikemiddleton.com



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 02:00 AM
how to move user defined function Grant Excel Worksheet Functions 1 November 17th 04 07:38 PM
How to resize a comment box, by embedding code into a function? JJ Excel Worksheet Functions 13 November 16th 04 09:44 PM
change function variable prompts?? thinkingfield Excel Worksheet Functions 1 November 8th 04 05:01 PM
Counting Function Dilemma Simon Lloyd Excel Worksheet Functions 0 November 8th 04 04:13 PM


All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"