Solution :
The null and the alternate hypothesis can be stated as :
Null hypothesis

Alternate hypothesis

We known;


= 62.286


= 72.125


= 116.571


= 23.45
Therefore, calculating the test statics :



= -2.312
Now calculating the P-value for the test as follows :
P=T.DIST(t, df)




P=T.DIST(t, df)
=T.DIST(-2.31, 7)
= 0.0270
Thus, the
of the test is P = 0.0270 is
than the level of significance
. Hence the researcher can reject the null hypothesis.
Conclusion: The mean launch temperature for the flights with O ring damages less than that for the flights with no O rings.