Estimate a mean with a two-sided t interval
Enter separate formulas in G2:G7. Read the numeric observations in A2:A21 and alpha in D2; only trailing unused sample cells are blank. G2 is n, G3 the sample mean, G4 the sample standard deviation, G5 the two-sided t margin at confidence level 1-alpha, and G6:G7 the lower/upper interval endpoints. Use sample spread, n-1 degrees of freedom and full computed precision.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter separate formulas in G2:G7. Read the numeric observations in A2:A21 and alpha in D2; only trailing unused sample cells are blank. G2 is n, G3 the sample mean, G4 the sample standard deviation, G5 the two-sided t margin at confidence level 1-alpha, and G6:G7 the lower/upper interval endpoints. Use sample spread, n-1 degrees of freedom and full computed precision.
No account. No upload. Just try it.