Teaching the t test

If you want to make an estimate from a small sample, you need to use the t distribution. Specifically - in Microsoft Excel - you need the =TINV function. This will give you the constant that you should multiply your standard error by in order to calculate your upper and lower 95% confidence intervals.