Google Sheets function

CONFIDENCE.T in Google Sheets

CONFIDENCE.T with worked examples you can test in the live grid. The argument details are in the Excel guide.

In Google Sheets

The arguments and common errors are covered in the CONFIDENCE.T Excel guide; check the function help in Google Sheets for its own argument list.

	A	B	C
1	Alpha	SD	n
2	0.05	2	10

Formula: E2: =ROUND(CONFIDENCE.T(A2,B2,C2),4)

Result: 1.4307

Nine degrees of freedom produce a t-based half-width of 1.4307.

	A	B	C
1	Alpha	SD	n
2	0.05	2	40

Formula: E2: =ROUND(CONFIDENCE.T(A2,B2,C2),4)

Result: 0.6396

More observations reduce the standard error and critical value.

	A	B	C
1	Alpha	SD	n
2	0.1	2	10

Formula: E2: =ROUND(CONFIDENCE.T(A2,B2,C2),4)

A narrower ninety-percent interval has a smaller half-width.

A tiny spreadsheet with example data. Edit the formula or any number and see the result.

Formula in F2: =CONFIDENCE.T(0.05,STDEV.S(C2:C7),COUNT(C2:C7))

Result in F2: 39.6384867462

Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.