Question

Assuming Case 1 (equal population standard deviations), calculate the test statistic for the hypothesis test. Examine the difference in the mean age of houses (two-tailed test):

Peaceful Pines

40, 47, 42, 44, 40, 43

Whispering Willows

49, 45, 35, 37, 51, 39

I tried computing this via data analysis on excel, but my result was 0. The two means are the same, and therefore I am not sure what that means? Also can you show me what you input on Excel data analysis once you compute t-test equal variances? (what is the hypothesized difference).

Answer 1

Solution:

Null hypothesis:

Ho:

Alternative Hypothesis:

Ha;

Install analysis toolpak in excel

Go to

Then

output is

t-Test: Two-Sample Assuming Equal Variances
	Peaceful Pines	Whispering Willows
Mean	42.66666667	42.66667
Variance	7.066666667	43.86667
Observations	6	6
Pooled Variance	25.46666667
Hypothesized Mean Difference	0
df	10
t Stat	0
P(T<=t) one-tail	0.5
t Critical one-tail	1.812461123
P(T<=t) two-tail	1
t Critical two-tail	2.228138852

t statistic ,t=0

p=1

p>0.05

Fail to reject null hypothesis

Accept null hypothesis

Conclusion:

There is no sufficient statistical evidence at 5% level of significance to conclude that there  is a difference in the mean age of houses  Peaceful Pines and Whispering Willows

meaning  mean age of houses  Peaceful Pines and Whispering Willows are same.