DAX Statistical - CONFIDENCE.T function

Description

Returns the confidence interval for a population mean, using a Student's t distribution. DAX CONFIDENCE.T function is new in Excel 2016.

Syntax

```CONFIDENCE.T (alpha, standard_dev, size)
```

Parameters

Sr.No. Parameter & Description
1

alpha

The significance level used to compute the confidence level.

he confidence level equals 100 * (1 - alpha) %. For e.g. if alpha is 0.05, then confidence level is 95%.

2

standard_dev

The population standard deviation for the data range and is assumed to be known.

3

size

The sample size.

Return Value

Returns the confidence interval for a population mean, using a Student's t distribution.

Remarks

• If any argument is non-numeric, CONFIDENCE.T returns the #VALUE! error value.

• If alpha ≤ 0 or alpha ≥ 1, CONFIDENCE.T returns the #NUM! error value.

• If standard_dev ≤ 0, CONFIDENCE.T returns the #NUM! error value.

• If size is not an integer, it is truncated.

• If size equals 1, CONFIDENCE.T returns #DIV/0! error value.

Example

```= CONFIDENCE.T(0.05,1,50) returns 0.28419685549573.
```
dax_functions_statistical.htm