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.