WorksheetFunction.Quartile_Exc(Object, Double) Método
Definición
Importante
Parte de la información hace referencia a la versión preliminar del producto, que puede haberse modificado sustancialmente antes de lanzar la versión definitiva. Microsoft no otorga ninguna garantía, explícita o implícita, con respecto a la información proporcionada aquí.
Devuelve el cuartil del conjunto de datos, según los valores de percentil de 0 a 1, ambos no incluidos.
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 DoubleParámetros
- Arg1
- Object
Matriz: matriz o intervalo de celdas de valores numéricos para los que desea el valor de cuartil.
- Arg2
- Double
Cuartil: valor que se debe devolver.
Devoluciones
Comentarios
Si la matriz está vacía, Quartile_Exc devuelve el #NUM! valor de error.
Si el argumento de cuartil no es un número entero, se trunca.
Si quart ≤ 0 o si quart ≥ 4, Quartile_Exc devuelve el #NUM! valor de error.
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)y 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) devuelven el mismo valor que Quartile_Exc cuando quart es igual a 0 (cero), 2 y 4, respectivamente.