{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

t-tests in Excel

# t-tests in Excel - t-tests in Excel Single sample tests...

This preview shows pages 1–2. Sign up to view the full content.

t -tests in Excel Single sample tests Single-sample t-test Excel doesn’t have a single-sample t-test built in as a simple function. Instead you will need to calculate the t-statistic, and then use the TDIST function to get a P-value. Put your data in column A. Then in cells B1: C8, enter the following: Sample mean =AVERAGE(A:A) Sample standard deviation =STDEV(A:A) Sample size =COUNT(A:A) μ 0 <enter null hypothesis value here> t-statistic =(C1-C4)/(C2/SQRT(C3)) P-value (two-tailed; H0: μ X = μ 0 ) =TDIST(ABS(C5), C3-1, 2) P-value (one-tailed; H0: μ X <= μ 0 ) =IF(C5>0, TDIST(C5, C3-1, 1), 1-TDIST(-C5, C3-1, 1)) P-value (one-tailed; H0: μ X >= μ 0 ) =IF(C5>0, 1-TDIST(C5, C3-1, 1), TDIST(-C5, C3-1, 1)) The reason we have to do the complicated stuff with the absolute value function (for the two-tailed test) and the IF function (for the one-tailed test) is that the TDIST function won’t accept a negative value of the t statistic (thanks, Microsoft!). I’ve given you the formulas for all three P-values; obviously, in any given application, you would only want to use one!

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 3

t-tests in Excel - t-tests in Excel Single sample tests...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online