通过

WorksheetFunction.Quartile_Inc(Object, Double) 方法

  • 参考

定义

命名空间:
Microsoft.Office.Interop.Excel
程序集:
Microsoft.Office.Interop.Excel.dll

基于百分点值（从 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 - 要返回的值。

返回

Double

注解

如果数组为空， 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)

适用于