Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Applications For The Management, Life And Social Sciences

Authors: Ronald J. Harshbarger, James J. Reynolds

12th Edition

978-1337625340

More Books

Students also viewed these Mathematics questions