CONFIDENCE.T function

The CONFIDENCE.T function calculates the width of half the confidence interval for a student's t-distribution.

Parts of a CONFIDENCE.T function

CONFIDENCE.T(alpha, standard_deviation, size)

Part	Description
`alpha`	One minus the desired confidence level. E.g. `0.1` for `0.9`, or 90%, confidence.
`standard_deviation`	The standard deviation of the population.
`size`	The size of the population.

Note

CONFIDENCE.T calculates the width of half the confidence interval such that a value picked at random from the data set has 1-alpha probability of lying within the mean plus or minus the result of CONFIDENCE.T.

Examples

	A	B	C	D	E	F
1	Alpha	STDEV	size	Result	Formula	Confidence Interval (Supposed Mean=40)
2	0.05	6.43	27	2.56340262541175	`=CONFIDENCE.T(A2,B2,C2)`	[40-2.563, 40+2.563]

Related functions

CONFIDENCE.NORM: Calculates the width of half the confidence interval for a normal distribution.

Need more help?

Try these next steps:

Post to the help community Get answers from community members

Statistical

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search

Close search

Google apps

Main menu