Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

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

Finite Mathematics and Its Applications

Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair

12th edition

978-0134768588, 9780134437767, 134768582, 134437764, 978-0134768632

More Books

Students also viewed these Mathematics questions