FirstQuartile Property

The FirstQuartile property returns the first quartile (25th percentile) of the data values in the column from which the statistics were calculated. Returns a Variant. This is a read-only property.

Syntax

object.FirstQuartile( Col )

 

Parameter	Type	Description
Col	Long	optional, default=1 (column A)

 

Example

This example demonstrates how to return the 25th percentile of values in column C.

Debug.Print "First Quartile (25th percentile) "; Stats.FirstQuartile(3)

 

Used by: WksStatistics object