The Problem
Example #275: Let us test whether the mean height of population 1 is the same as that of population 2. In symbols, this is:
H0 : μ1 − μ2 = 0
HA : μ1 − μ2 ≠ 0
To test this hypothesis, we collect data. The data from population 1 are:
54, 44, 59, 42, 38, 59, 56, 50, 46, 53, 45, 58
The data from population 2 are:
27, 47, 56, 60, 46, 47, 89, 22, 81, 37, 42, 48, 39, 41, 46, 49, 27, 30
In addition to these data, we also know one important thing: The data are generated from independent Normal processes; that is, the data in each sample come from independent Normal distributions. With this information, calculate the test statistic corresponding to the null hypothesis. Use the pooled variance.
Information given:
To summarize the above, the values of import are:
Summary statistics from the problem
| \( \mu_d \)
| = |
0 |
|---|
| | | |
| \( \bar{x}_1 \)
| = |
50.3333 |
|---|
| \( \bar{x}_2 \)
| = |
46.3333 |
|---|
| | | |
| \( n_1 \)
| = |
12 |
|---|
| \( n_2 \)
| = |
18 |
|---|
| | | |
| \( s_1 \)
| = |
7.202693 |
|---|
| \( s_2 \)
| = |
17.334087 |
|---|
| \( s_p \)
| = |
14.241121 |
|---|
Calculate these values yourself then hover your mouse over the grey spaces to see if you calculated them correctly.
Assistance
Hide Solution
First, let us calculate the pooled variance.
$$ \begin{align}
s_p^2 &= \frac{ \left(n_1-1\right)s_1^2 + \left(n_2-1\right)s_2^2\ }{ n_1 + n_2 - 2 } \\[1em]
&= \frac{ \left(12-1\right)7.202693^2 + \left(18-1\right)17.334087^2\ }{ 12 + 18 - 2 } \\[1em]
&= \frac{ \left(11\right)51.878788 + \left(17\right)300.470588\ }{ 28 } \\[1em]
&= 202.809524 \end{align} $$
And so, \( s_p = 14.241121 \). With that calculated, we thus have
$$ \begin{align}
t &= \frac{ \left(\bar{x}_1 - \bar{x}_2\right) - \mu_d}{ s_p \sqrt{ \frac{1}{n_1} + \frac{1}{n_2}} } \\[1em]
&= \frac{ \left(50.3333 - 46.3333\right) - 0}{ 14.241121 \sqrt{ \frac{1}{12} + \frac{1}{18}} } \\[1em]
&= \frac{ 4}{ 14.241121 \sqrt{ 0.138889} } \\[1em]
&= \frac{ 4}{ 5.307352} \\[1em]
\end{align} $$
Thus, the test statistic for these data and this hypothesis is z = 0.7537.
Hide the R Code
Copy and paste the following code into your R script window, then run it from there.
samp1 = c(54, 44, 59, 42, 38, 59, 56, 50, 46, 53, 45, 58)
samp2 = c(27, 47, 56, 60, 46, 47, 89, 22, 81, 37, 42, 48, 39, 41, 46, 49, 27, 30)
t.test(samp1, samp2, mu=0, var.equal=TRUE)
In the R output, the test statistic is the number that follows “t =” near the top. Note that R will give you test statistics that are more accurate and more precise than doing the calculations by hand. As such, these computer-calculated limits will differ slightly from those you calculate by hand.
Hide the Excel Code
The z-procedures are sensitive to knowing the population variance. Logic dictates that if we do not know the population mean, then we will not know the population variance. As such, the z-procedures are rarely used now. As such, there is no z-test in the base Excel program.
Copy and paste the following code into your Excel spreadsheet window, making sure the value sample1 ends up in A1 after pasting.
How to calculate the expected value in Excel.
| sample1 | sample2 | | |
| 54 |
27 |
mu d: |
0 |
| 44 |
47 |
s1: |
=STDEV.S(A:A) |
| 59 |
56 |
s2: |
=STDEV.S(B:B) |
| 42 |
60 |
sp: |
=SQRT(((COUNT(A:A)-1)*D3^2+(COUNT(B:B)-1)*D4^2)/(COUNT(A:A)+COUNT(B:B)-2)) |
| 38 |
46 |
ts: |
=(AVERAGE(A:A)-AVERAGE(B:B)-D2)/D5/SQRT(1/COUNT(A:A)+1/COUNT(B:B)) |
| 59 |
47 |
|
|
| 56 |
89 |
|
|
| 50 |
22 |
|
|
| 46 |
81 |
|
|
| 53 |
37 |
|
|
| 45 |
42 |
|
|
| 58 |
48 |
|
|
| |
39 |
|
|
| |
41 |
|
|
| |
46 |
|
|
| |
49 |
|
|
| |
27 |
|
|
| |
30 |
|
|
The test statistic is the number calculated in cell D6. Again, when you paste this code into Excel, make sure that you start the pasting in cell A1. To help with that, you may want to also copy this notice. It seems to help.
![[Correct!]](images/correct.png "You are correct. Well done!")
You got the correct answer of t = 0.7537. Congratulations!
![[Incorrect!]](images/incorrect.png "You are not correct.")
Unfortunately, your answer was not correct. Either try again or click on “Show Solution” below to see how to obtain the correct answer.