| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentiles in Excel
Add the 0 in the array
=PERCENTILE({0,1,2,3,4},0.3) "Jon J" wrote: According to the example in Excel's help tool, the 30th percentile of (1,2,3,4) is 1.9. Can anyone provide any details on how Excel gets this result? My calculations give a different a result for the 30th percentile as follows: There's a 25% chance that a number selected from (1,2,3,4) is <= 1. There's a 50% chance a number selected from (1,2,3,4) is <= 2. Interpolating to get the number with a 30% chance gives me .8(1)+.2(2) = 1.2 for the 30th percentile of (1,2,3,4). Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| percentiles | Excel Discussion (Misc queries) | |||
| Displaying Percentiles | Excel Worksheet Functions | |||
| formulate tests scores then average them as percentiles in excel | New Users to Excel | |||
| TRIMMEAN with different percentiles? | Excel Worksheet Functions | |||
| percentiles? | Excel Worksheet Functions | |||
Threaded Mode
