Question: How do you compute a T-test in excel to compare results from Group A and Group B Group A Question 1 Response Question 2 response
How do you compute a T-test in excel to compare results from Group A and Group B
| Group A | Question 1 Response | Question 2 response | Question 3 response | Question 4 response | Question 5 response | |||
| Males | 1 | 2 | 3 | 1 | 2 | |||
| Males | 1 | 1 | 1 | 2 | 2 | |||
| Males | 4 | 2 | 3 | 1 | 2 | |||
| Males | 1 | 1 | 1 | 1 | 1 | 5-Point Lukert Scale | ||
| Males | 2 | 3 | 2 | 3 | 1 | (1)Strongly Disagree | ||
| Males | 3 | 1 | 1 | 4 | 1 | (2) Disagree | ||
| Males | 3 | 1 | 2 | 3 | 1 | (3) Neither agree or disagree | ||
| Males | 1 | 3 | 1 | 2 | 2 | (4) Agree | ||
| Males | 3 | 1 | 1 | 2 | 2 | (5) Strongly Agree | ||
| Group B | Question 1 Reponse | Question 2 response | Question 3 response | Question 4 response | Question 5 response | |||
| Females | 5 | 4 | 4 | 4 | 4 | |||
| Females | 3 | 3 | 2 | 5 | 5 | |||
| Females | 3 | 5 | 3 | 5 | 5 | |||
| Females | 2 | 2 | 4 | 4 | 5 | |||
| Females | 3 | 5 | 5 | 3 | 5 | |||
| Females | 5 | 5 | 5 | 4 | 4 | |||
| Females | 4 | 5 | 3 | 4 | 5 | |||
| Females | 5 | 3 | 5 | 4 | 4 | |||
| Females | 5 | 5 | 5 | 3 | 4 | |||
| Females | 4 | 5 | 5 | 3 | 4 |
How can you run a t-test for two independent sample means?
How can you run proportionate test?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help