t-tests in Excel

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

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

View Full Document Right Arrow Icon
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! Two-sample tests
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online