WorksheetFunction.Quartile_Inc(Object, Double) 方法
定义
重要
一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。 对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。
基于百分点值（从 0 到 1，包括 0 和 1）返回数据集的四分位数。 四分位数通常用于在销售额和调查数据中对总体进行分组。 例如，可以使用 QUARTILE_INC 求得总体中前 25% 的收入值。
public:
double Quartile_Inc(System::Object ^ Arg1, double Arg2);public double Quartile_Inc (object Arg1, double Arg2);Public Function Quartile_Inc (Arg1 As Object, Arg2 As Double) As Double参数
- Arg1
- Object
array - 要计算其四分位数值的数值数组或单元格区域。
- Arg2
- Double
quart - 要返回的值。
返回
注解
如果数组为空， Quartile_Inc 返回 #NUM！ 。
如果 quart 不为整数，则将被截尾取整。
如果 quart < 0 或 quart >4，Quartile_Inc 返回 #NUM！ 。
Min(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)当夸art 分别等于 0 (零 ) 、2 和 4 时， 和 返回与 Quartile_Inc 相同的值。 Median(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)Max(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)