ThirdQuartile Property

ThirdQuartile 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

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