Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started