In: Statistics and Probability
Researchers want to examine whether or not there is a difference in birthweight for mothers who smoke and mothers who do not smoke. Their alternate hypothesis is Ha: μ1 ≠ μ2.They collect smoking status and birthweight information for 189 pregnancies. For your convenience, I have prepared an Excel file with the data
Nonsmoker | Smoker |
2877 | 2600 |
3062 | 2665 |
3234 | 2769 |
3459 | 2769 |
3473 | 2906 |
3586 | 2992 |
3600 | 3076 |
3614 | 3076 |
3827 | 3132 |
3941 | 3317 |
4111 | 3374 |
2100 | 3629 |
2353 | 3637 |
2637 | 3643 |
2836 | 3651 |
2977 | 3651 |
3100 | 3756 |
3317 | 3940 |
3416 | 4238 |
3460 | 1818 |
3614 | 1885 |
3651 | 1928 |
3651 | 1936 |
3699 | 2084 |
3728 | 2084 |
3770 | 2225 |
3799 | 2296 |
3912 | 2410 |
3997 | 2424 |
4054 | 2466 |
4174 | 2557 |
4593 | 2663 |
4990 | 2821 |
2920 | 2948 |
3062 | 3033 |
3090 | 1790 |
3860 | 2187 |
3983 | 2353 |
4153 | 2410 |
4167 | 2594 |
1021 | 2977 |
2082 | 2977 |
2835 | 3005 |
3080 | 3147 |
2523 | 3856 |
2778 | 3884 |
2977 | 1928 |
3374 | 2466 |
3402 | 2782 |
3790 | 2414 |
2187 | 2495 |
2495 | 3430 |
2920 | 2920 |
2920 | 3444 |
3062 | 1135 |
1701 | 2296 |
3317 | 2381 |
1928 | 2381 |
2438 | 2948 |
3860 | 2367 |
2622 | 3042 |
2722 | 2126 |
2750 | 3090 |
2807 | 3203 |
2863 | 3260 |
3090 | 3572 |
3104 | 709 |
3175 | 2125 |
3175 | 2211 |
3203 | 2466 |
3203 | 2495 |
3225 | 3331 |
3225 | 3321 |
3232 | 3303 |
3475 | |
3487 | |
3544 | |
3572 | |
3770 | |
3770 | |
3969 | |
4054 | |
1330 | |
1474 | |
1588 | |
1729 | |
1893 | |
1970 | |
2055 | |
2240 | |
2282 | |
2325 | |
2381 | |
2395 | |
2637 | |
2733 | |
3274 | |
3884 | |
3941 | |
3997 | |
1588 | |
1899 | |
2055 | |
2240 | |
2442 | |
2750 | |
2835 | |
2877 | |
3232 | |
3274 | |
3629 | |
2495 | |
2551 | |
2450 | |
2301 |
Use a t-test to test the hypothesis that there is a difference in birthweight for mothers who smoke and mothers who do not smoke at the α = 0.05 level. Assume unequal variance between the groups.
What is the p-value for this result?
This problem is solved by using Excel.
Input :
Outside is
Analysis Path : Data >>Data Analysis >> T test two sample assuming unequal Variances.
Results :
Thank You ?
Please thumbs up!