Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
explain percentiles please
I have a list of numbers that represents numbers of peole that attend the
store at various times of the day e.g 4 at 8 am ,9 at 11 am ...3 at 7pm etc and this is expressed on a graph as the averages for these times of days and the 90th percentile. Whats this meaning. Thanks Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
explain percentiles please
Returns the k-th percentile of values in a range. You can use this function
to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile. Syntax PERCENTILE(array,k) Array is the array or range of data that defines relative standing. K is the percentile value in the range 0..1, inclusive. Remarks If array is empty or contains more than 8,191 data points, PERCENTILE returns the #NUM! error value. If k is nonnumeric, PERCENTILE returns the #VALUE! error value. If k is < 0 or if k 1, PERCENTILE returns the #NUM! error value. If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine the value at the k-th percentile. "MikeR-Oz" wrote: I have a list of numbers that represents numbers of peole that attend the store at various times of the day e.g 4 at 8 am ,9 at 11 am ...3 at 7pm etc and this is expressed on a graph as the averages for these times of days and the 90th percentile. Whats this meaning. Thanks Mike |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
explain percentiles please
Thanks, but I really am trying to undersatnd what the percentile does - what
it sais about data, so as to decide whether I want that analysis. Can you explain the way it works and what it sais and why you might use it? Mike "fascal" wrote: Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile. Syntax PERCENTILE(array,k) Array is the array or range of data that defines relative standing. K is the percentile value in the range 0..1, inclusive. Remarks If array is empty or contains more than 8,191 data points, PERCENTILE returns the #NUM! error value. If k is nonnumeric, PERCENTILE returns the #VALUE! error value. If k is < 0 or if k 1, PERCENTILE returns the #NUM! error value. If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine the value at the k-th percentile. "MikeR-Oz" wrote: I have a list of numbers that represents numbers of peole that attend the store at various times of the day e.g 4 at 8 am ,9 at 11 am ...3 at 7pm etc and this is expressed on a graph as the averages for these times of days and the 90th percentile. Whats this meaning. Thanks Mike |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
explain percentiles please
Hi Mike,
http://en.wikipedia.org/wiki/Percentile -- Kind regards, Niek Otten Microsoft MVP - Excel "MikeR-Oz" wrote in message ... | Thanks, but I really am trying to undersatnd what the percentile does - what | it sais about data, so as to decide whether I want that analysis. Can you | explain the way it works and what it sais and why you might use it? | | Mike | | "fascal" wrote: | | Returns the k-th percentile of values in a range. You can use this function | to establish a threshold of acceptance. For example, you can decide to | examine candidates who score above the 90th percentile. | | Syntax | | PERCENTILE(array,k) | | Array is the array or range of data that defines relative standing. | | K is the percentile value in the range 0..1, inclusive. | | Remarks | | If array is empty or contains more than 8,191 data points, PERCENTILE | returns the #NUM! error value. | If k is nonnumeric, PERCENTILE returns the #VALUE! error value. | If k is < 0 or if k 1, PERCENTILE returns the #NUM! error value. | If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine | the value at the k-th percentile. | | | "MikeR-Oz" wrote: | | I have a list of numbers that represents numbers of peole that attend the | store at various times of the day e.g 4 at 8 am ,9 at 11 am ...3 at 7pm etc | and this is expressed on a graph as the averages for these times of days and | the 90th percentile. | | Whats this meaning. | | Thanks | Mike |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
explain percentiles please
If you have a collection of numbers in an array, then =PERCENTILE(array,0.9)
will give you the value below which 90% of the numbers in the array lie, so only 10% of the population are above that value. See http://www.itl.nist.gov/div898/handb...on2/prc252.htm for one of many simple introductory tutorials which you can find on the web. -- David Biddulph "MikeR-Oz" wrote in message ... Thanks, but I really am trying to undersatnd what the percentile does - what it sais about data, so as to decide whether I want that analysis. Can you explain the way it works and what it sais and why you might use it? Mike "fascal" wrote: Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile. Syntax PERCENTILE(array,k) Array is the array or range of data that defines relative standing. K is the percentile value in the range 0..1, inclusive. Remarks If array is empty or contains more than 8,191 data points, PERCENTILE returns the #NUM! error value. If k is nonnumeric, PERCENTILE returns the #VALUE! error value. If k is < 0 or if k 1, PERCENTILE returns the #NUM! error value. If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine the value at the k-th percentile. "MikeR-Oz" wrote: I have a list of numbers that represents numbers of peole that attend the store at various times of the day e.g 4 at 8 am ,9 at 11 am ...3 at 7pm etc and this is expressed on a graph as the averages for these times of days and the 90th percentile. Whats this meaning. Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Let me explain my problem... (Roommate Accounting) | Excel Worksheet Functions | |||
Mileage Claim Formula | New Users to Excel | |||
Displaying Percentiles | Excel Worksheet Functions | |||
TRIMMEAN with different percentiles? | Excel Worksheet Functions | |||
Explain these please | Excel Worksheet Functions |