Input this data and run the two sample t test in Excel. Do you get the same outp

ID: 2914824 • Letter: I

Question

Input this data and run the two sample t test in Excel. Do you get the same output? Salaries Male Female 45 46 55 56 68 55 102 38 34 55 44 98 37 56 67 23 Use Excel to get the numbers but do a formal test using the5-step process. Interpret your findings and make a clearstatement of your decision. What happens if you run the testfor "unequal" variances? What do you think the differencesare? Input this data and run the two sample t test in Excel. Do you get the same output? Salaries Male Female 45 46 55 56 68 55 102 38 34 55 44 98 37 56 67 23 Use Excel to get the numbers but do a formal test using the5-step process. Interpret your findings and make a clearstatement of your decision. What happens if you run the testfor "unequal" variances? What do you think the differencesare?

Explanation / Answer

t-Test: Two-SampleAssuming Unequal Variances

Variable 1

Variable 2

Mean

56.5

53.375

Variance

498.5714

460.5536

Observations

Hypothesized MeanDifference

t Stat

0.285402

P(T<=t) one-tail

0.389757

t Critical one-tail

1.76131

P(T<=t) two-tail

0.779515

t Critical two-tail

2.144787