| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quartile funciton...quintile?
Hi there
1. I like the quartile function but I actually need quintiles. Is there a way to force the function to break up the range into 5 instead of 4? 2. Instead of returning the value at the top of the quartile (or quintile), I would prefer it averages the range in the specific quartile. How would I do that? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save funciton no longer working after latest download | Excel Discussion (Misc queries) | |||
| What is the formula used to calculate the 1st and 3rd quartile? | Excel Worksheet Functions | |||
| Condtional Quartile statement | Excel Worksheet Functions | |||
| Quartile / Quintile Function | Excel Worksheet Functions | |||
| Quartile Function | Excel Discussion (Misc queries) | |||
Threaded Mode
