2 Tail Test The null and alternative hypothesis are

H0:u-2111

Ha 2111- (is that not equal to)

1 and 3, use the quartile function in Excel:

=QUARTILE([data range], [quartile number]) ]

[Summarize your sample data, describing the center, spread, and shape in comparison to thenational Information

Determine the appropriate test statistic (t).]

[Note: This calculation is (mean - target)/standard error. In this case, the mean is your regional mean, and the target is the national mean.]

[Calculate the probability (pvalue).]

[Note: This calculation is done with the TDIST.2T function in Excel: =T.DIST.RT([test statistic], [degree of freedom]). The degree of freedom is calculated by subtracting 1 from your sample size.]