Question: How do i find the P-value? Propose a 2-sample t-test using two columns of data (group 1 and group 2) with 10 data items in

How do i find the P-value?

Propose a 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. In your discussion post, describe the following:

  • What is your null and alternative hypothesis? (use a two tailed test hypothesis)
  • Place your t-test Result Output in your discussion post
  • Identify your p value for the two tailed test in your t-test output
  • 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.
  • 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.
  • 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!