O'Reilly logo

Statistical Analysis with Excel® For Dummies®, 2nd Edition by Joseph Schmuller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Two-Sample Hypothesis Testing

In This Chapter

  • Testing differences between means of two samples

  • Testing means of paired samples

  • Testing hypotheses about variances

In business, in education, and in scientific research the need often arises to compare one sample with another. Sometimes the samples are independent, sometimes they're matched in some way. Each sample comes from a different population. The objective is to decide whether or not the populations they come from are different from one another.

Usually, this involves tests of hypotheses about population means. You can also test hypotheses about population variances. In this chapter, I show you how to carry out these tests. I also discuss useful worksheet functions and data analysis tools that help you get the job done.

Hypotheses Built for Two

As in the one-sample case (Chapter 10), hypothesis testing with two samples starts with a null hypothesis (H0) and an alternative hypothesis (H1). The null hypothesis specifies that any differences you see between the two samples are due strictly to chance. The alternative hypothesis says, in effect, that any differences you see are real and not due to chance.

It's possible to have a one-tailed test, in which the alternative hypothesis specifies the direction of the difference between the two means, or a two-tailed test in which the alternative hypothesis does not specify the direction of the difference.

For a one-tailed test, the hypotheses look like this:

H0: μ1- μ2 = 0

H1: μ1- μ2

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required