CONFIDENCE.T

This function returns the confidence interval for a population mean.

Syntax

CONFIDENCE.T(alpha,stdev,size)

Arguments

This function has these arguments:

Argument	Description
alpha	Alpha, significance level used in calculating confidence level, where confidence level is 100 times (1-alpha)%
stdev	Population standard deviation for the range
size	Number representing the size of the sample; if not an integer, the number is truncated

Remarks

The function uses a Student's t distribution. If size = 1, the function returns a #DIV/0! error value. If any argument is nonnumeric, the function returns the #VALUE! error value.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

CONFIDENCE.T(0.5,B4,D5)

CONFIDENCE.T(0.5,R4C2,R5C4)

CONFIDENCE.T(0.05,3.5,150) gives the result 0.5646928012079743

Version Available

This function is available in Spread for Windows Forms 11.0 or later.