WorksheetFunction.Quartile_Exc(Object, Double) 方法

参考

定义

命名空间:: Microsoft.Office.Interop.Excel

程序集:: Microsoft.Office.Interop.Excel.dll

重要

一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。

基于百分点值（从 0 到 1，不包括 0 和 1）返回数据集的四分位数。

public:
 double Quartile_Exc(System::Object ^ Arg1, double Arg2);

public double Quartile_Exc (object Arg1, double Arg2);

Public Function Quartile_Exc (Arg1 As Object, Arg2 As Double) As Double

参数

Arg1: Object

Array - 需要其四分位值的数值的数组或单元格范围。

Arg2: Double

quart - 要返回的值。

返回

Double

注解

如果数组为空， Quartile_Exc 返回 #NUM！。

如果 quart 不为整数，则将被截尾取整。

如果 quart ≤ 0 或 quart ≥ 4，Quartile_Exc 返回 #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)当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)夸art 分别等于 0 (零 ) 、2 和 4 时，、和 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) 返回与 Quartile_Exc 相同的值。

适用于