Question

2. Testing two population means using Excel Aa Aa Consider two independent random variables x and y. The variable x follows a normal distribution with an unknown population mean ux and a unknown standard deviation of ox. The variable y also follows a normal distribution with an unknown population mean py and a unknown standard deviation of oy. Independent random samples are drawn from each population To answer the questions that follow, download an Excel spreadsheet containing observed values of the variable x by clicking on the following words in bold: Download Excel File In your downloaded Excel spreadsheet, complete the steps to conduct a hypothesis test about the difference between the two population means px and py when ox and oy are unknown. Enter the values you compute in the sample Excel sheet that follows. Use a hypothesized mean difference of zero and a significance level of a = 0.01. (Note: You may need to adjust the number of decimals shown in your spreadsheet in order to match the correct answers.)

Answer 1

t-Test: Two-Sample Assuming Unequal Variances
	x	y
Mean	14.79	10.87
Variance	3.5077	1.3334
Observations	10	10
Hypothesized Mean Difference	0
df	15
t Stat	5.6340
P(T<=t) one-tail	0.0000
t Critical one-tail	2.6025
P(T<=t) two-tail	0.0000
t Critical two-tail	2.9467

P-value is LESS... you WILL reject