The dataset contains the weights in pounds for random samples of 25 newborn baby boys and baby girls born in Denver in a recent year. Using the = 0.05 level of significance, perform a t-test to determine if the mean weights differ between boys and girls.

please mention formulas for excel where ever possible.

Put your answers along formulas . Use Excel to calculate your answers. If I cannot see the Excel formula you used, you will not get credit for your answer.

Boys 6.6 5.9 6.4 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 7.7 8.1 6.4

Girls 7.7 7 8.2 7.4 6 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 8.1 8.2 6.7 6.2 7.7

for boys -- n ? mean ? variance ?

for girls -- n ? mean ? variance ?

Null hypothesis ?

Alternative hypothesis ?

alpha = 0.05

stand err ?

df ?

critical T ?

test T ?

p-value ?

Do you reject or fail to reject the null hypothesis? Explain using both T and p-values.

conclusion ?