Question

Baby weights: Following are weights in pounds for random samples of

19

newborn baby boys and baby girls born in Denver in

2011

. Boxplots indicate that the samples come from populations that are approximately normal. Let

μ1

denote the mean weight of boys and

μ2

denote the mean weight of girls. Can you conclude that the mean weights differ between boys and girls? Use the

=α0.10

level and the

P

-value method with the table.

Boys
7.6	6.4	8.1	7.9	8.3	7.3	6.4	8.4	8.5
6.9	6.3	7.4	7.8	7.5	6.9	7.8	8.6	7.7
7.4

Girls
7.0	8.2	7.4	6.0	6.7	8.2	7.5	5.7	6.6
6.4	8.5	7.2	6.9	8.2	6.5	6.7	7.2	6.3
5.9

Send data to Excel

Part: 0 / 6

0 of 6 Parts Complete

Part 1 of 6

State the appropriate null and alternate hypotheses.

H0 : H1 : This is a ▼(Choose one) test.

Answer 1

## To test the mean weights differ between boys and girls we performe Two-Sample t-Test :-

Step-by-Step Instructions for Running the Two-Sample t-Test in Excel

1. In Excel, click Data Analysis on the Data tab.
2. From the Data Analysis popup, choose t-Test: Two-Sample Assuming Equal Variances.
3. Under Input, select the ranges for both Variable 1 and Variable 2.
4. In Hypothesized Mean Difference, you’ll typically enter zero. This value is the null hypothesis value, which represents no effect. In this case, a mean difference of zero represents no difference between the two methods, which is no effect.
5. Check the Labels checkbox if you have meaningful variables labels in row 1. This option helps make the output easier to interpret. Ensure that you include the label row in step #3.
6. uses a Alpha value of 0.10 .
7. Click OK.