Using the excel software to solve the question.

Q2. The following data set gives the recorded birth weights of 50 infants who displayed severe idiopathic respiratory distress syndrome (SIRDS). SIRDS is a serious condition that can result in death and did so in the case of 27 of these children. Birth weights (kg) Died 1.050 1.175 1.230 1.310 1.500 1.600 1.720 1.750 1.770 2.275 2.500 1.030 1.100 1.185 1.225 1.262 1.295 1.300 1.550 1.820 1.890 1.940 2.200 2.270 2.440 2.560 2.370 Survived 1.130 1.575 1.680 1.760 1.930 2.015 2.090 2.600 2.700 2.950 3. 160 3.400 3.640 2.830 1.410 1.715 1.720 2.040 2.200 2.400 2.550 2.570 3.005 (a) Perform an F test to determine whether the variances of the birth weight of the two groups are the same. Use 0.02 significance level. (b) Find a 95% confidence interval for the difference in mean birth weight for SIRDS (c) babies who die and SIRDS babies who live. At 0.01 significance level can we conclude that the SIRDS babies who survived is heavier than babies who died? (18)