Question: 2-sample t-test using two columns of data (group 1 and group 2) with 10 data items in each column of data. Use a t-test in

2-sample t-test using two columns of data (group 1 and group 2) with 10 data items in each column of data. Use a t-test in Excel to determine if your results were significant or not significant (i.e., was there a significant difference between group 1 and 2 or was there no significant difference between group 1 and group 2). Use the two-tailed t-test result to analyze your results.

  1. What is your null and alternative hypothesis? (use a two tailed test hypothesis)
  2. Place your t-test Result Output in your discussion post
  3. Identify your p value for the two tailed test in your t-test output
  4. Note: If your p value < 0.05 (your significance level), then reject the null hypothesis and accept the alternative hypothesis. This means there is a significance difference between the two data groups.
  5. If your p value > 0.05 (your significance level), then reject the alternative hypothesis and accept the null and reject the alternative hypothesis.This means there is no significant difference between the two data groups.
  6. What is your overall conclusion from your t-test analysis in relation to your two columns of data?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!