- Graphic skills
- Case
Returns the quartiles of the data set. Quartiles are commonly used to group populations in sales and measurement data.
For example, you can use the function QUARTILE to find the income values of the top 25% of the population.
Grammar QUARTILE(array,quart)
Array Array or numeric cell range that needs to find quartile values.
Quart determines which quartile value is returned.
Description
■If the array is empty, QUARTILE returns the error value #NUM!.
■If quart is not an integer, it will be truncated.
■The values returned by the MIN, MEDIAN, and MAX functions are the same as those returned by the QUARTILE function when quart is equal to 0, 2, and 4, respectively.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/jie-xi-QUARTILE-han-shu-qing-song-huo-qu-shu-ju-si-fen-wei.html
评论列表(196条)
测试