WorksheetFunction.Quartile_Exc(Object, Double) Méthode

Définition

Renvoie le quartile de l’ensemble de données d’après des valeurs de centile comprises entre 0 et 1, exclus.

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

Paramètres

Arg1
Object

Tableau : tableau ou plage de cellules de valeurs numériques pour lesquelles vous souhaitez obtenir la valeur de quartile.

Arg2
Double

Quart : valeur à renvoyer.

Retours

Double

Remarques

Si le tableau est vide, Quartile_Exc renvoie la #NUM ! Autrement, la méthode INDEX renvoie la valeur d'erreur #REF!.

Si le quartile n’est pas un entier, il est tronqué.

Si le quart ≤ 0 ou s’il ≥ 4, Quartile_Exc renvoie la #NUM ! Autrement, la méthode INDEX renvoie la valeur d'erreur #REF!.

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), et renvoyer la même valeur que Quartile_Exc lorsque le quart est égal à 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) 0 (zéro), 2 et 4, respectivement.

S’applique à