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!