A sample of 40 observations is selected from one population

A sample of 40 observations is selected from one population. The sample mean is 102 and the sample STDEV is 5. A second sample of 50 observations is selected from a second population. That sample mean is 99 and the STDEV is 6. Conduct the following test of hypotheses using the 0.04 significance level:
H(0): m(1) = m(2)
H(1): m(1) is not equal to m(2)
a. Is this a one-tailed or a two-tailed test?
b. State the decision rule.
c. Compute the value of the z- test statistic.
d. State your decision regarding H(0).
Please answer in excell spreadsheet if possible.

I need a step by step solution.

Solution

a) This is a two tailed test.

b) If p value <0.04 reject null hypothesis.

c) Z statistic = 2.5868

d) 96% conf interval = (0.6182, 5.3818)

p value =0.0097

Hence reject null hypothesis.