DAX Statistical - CONFIDENCE.T function


Advertisements

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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements