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.

    See Also

    CONFIDENCE