CONFIDENCE.T function
CONFIDENCE.T(alpha,
standardDeviation, size) CONFIDENCE.T(alpha;
standardDeviation; size)
alpha
Number or { Number }
The significance level, which determines the desired confidence level.
standardDeviation
Number or { Number }
The (known) standard deviation of a normal distribution.
size
Number or { Number }
The size of a sample from a distribution.
Returns
Number or { Number }
A confidence interval for a Student's t-distribution.
Returns a confidence interval for a Student's t-distribution.
Examples
CONFIDENCE.T(0.05, 1,
50)CONFIDENCE.T(0,05; 1;
50)
Returns roughly 0.28.
CONFIDENCE.T(0.05, 1.5,
100)CONFIDENCE.T(0,05;
1,5; 100)
Returns roughly 0.30.