ThirdQuartile Property
The ThirdQuartile property returns the third quartile (75th 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.ThirdQuartile( Col )
Parameter | Type | Description |
Col | Long | optional, default=1 (column A) |
Example
This example demonstrates how to return the 75th percentile of values in column C.
Debug.Print "Third Quartile (75th percentile) "; Stats.ThirdQuartile(3)
Used by: WksStatistics object