ConfidenceInterval99 Property

The ConfidenceInterval99 property returns the 99 percent confidence interval for the mean of the data values in the column from which the statistics were calculated. Returns a Variant. This is a read-only property.

Syntax

object.ConfidenceInterval99( Col )

 

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

 

Example

This example demonstrates how to return the 99 percent confidence interval for the mean of the data values in column C.

Debug.Print "Sample 99% Confidence Interval for the Mean "; Stats.ConfidenceInterval99(3)

 

Used by: WksStatistics object