﻿ CONFIDENCE.T | Spread Formula Reference
Formula Functions / Functions A to C / CONFIDENCE.T
In This Topic
CONFIDENCE.T
In This Topic

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.