- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.