通过

WorksheetFunction.Quartile_Exc(Object, Double) 方法

  • 参考

定义

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

基于百分点值（从 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 相同的值。

适用于