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 |
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