How to use the CONFIDENCE.T function
What is the CONFIDENCE.T function?
The CONFIDENCE.T function calculates the confidence range for a population mean using a Student's t distribution.
What is the confidence range for a population mean?
A confidence interval around a sample mean provides a range of plausible values for the unknown population mean. It is calculated using the sample mean, standard error, and t-distribution, indicating the precision of the sample mean as an estimate of the actual population mean.
What is a Student's t distribution?
CONFIDENCE.T function Syntax
CONFIDENCE.T(alpha,standard_dev,size)
CONFIDENCE.T function Arguments
| alpha | Required. The significance level. |
| standard_dev | Required. The standard deviation. |
| size | Required. The number of samples. |
What is the significance level?
The significance level, denoted α (alpha) , is the probability of mistakenly rejecting the null hypothesis when it is in fact true. It is providing a threshold used to judge whether sample evidence is sufficient to indicate a real effect or relationship.
What is standard deviation?
Standard deviation tells you how far from the average values are spread out. Both charts above have numbers and an average plotted, they share the exact same average however, the numbers are not the same.
Chart A above shows that the values are more spread out than the values in chart B. Chart A has a standard deviation of 23.45256334, standard deviation for chart B is 5.207075606.
Standard deviation measures the amount of variation or dispersion of values in a dataset relative to the mean. It is calculated as the square root of the variance by taking
- each data point's deviation from the mean
- squaring it
- averaging the squares
- finally square rooting the result
Standard deviation = √(Σ(x - x̄)/n)
x̄ - arithmetic mean
n - count of values
CONFIDENCE.T function example
Formula in cell C7:
CONFIDENCE.T function not working
The CONFIDENCE.T function returns:
- #VALUE! error value if any argument is non-numeric.
- #NUM! error value if
- alpha <= 0 (zero)
- alpha >= 1.
- standard_dev <= 0.
- size < 1.
- #DIV/0! error value if size equals 1.
CONFIDENCE.T function truncates size argument to integers.
Functions in 'Statistical' category
The CONFIDENCE.T function function is one of 74 functions in the 'Statistical' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form