Estimate a mean with a two-sided t interval
Your goal: Report the sample mean, sample variation, confidence margin and both endpoints instead of presenting the margin as the whole interval.
Full 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.
Repeated packing durationsRetain the observed sample
A holds the numeric sample; D2 is alpha. Retain signed measurements and zeroes, and ignore unused trailing blanks.
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 | ||
| 8 | ||
| 9 |
Step 1 of 3
Retain the observed sample
Rules for this step
Select every numeric observation in A. Trailing blank cells are unused; signed values and numeric zero remain observations.