| SURVEY ANALYSIS: T-TEST AND HISTOGRAM |
| | | LAST REVISION: | 10/25/14 | | | | Internal instructions: |
| | | FILENAME: | SCM 350 Assignments | | | | Shaded areas are user input. Blue font is for formulas. |
| | | Developer: | John Wu, [email protected], x77437 | | | | Gender 1:Men, 0:Women |
| | | | | | | | Use Data, Data Analysis , t-Test to test differences between groups. |
| Tasks: | 1. For question 2, are there significant differences between group 1 and group 0? How confident can we say that the two groups have different opinions about question 2? | | | | | | Use conservative measure of two groups w/ unequal variances. |
| | | | | | | | Use Data, Data Analysis, Histogram to do histogram analysis. |
| | | | | | | | Creat a chart that shows frequencies and cumulative % for answers to Q1. |
| | | | | | | | Do the same for each of the remaining questions, t-tests and charts. |
| | 2. How about questions 3, 4, and 5? |
| Gender | Q. 1 | Q. 2 | Q. 3 | Q. 4 | Q. 5 | | Sample t-test for Q. 1. |
| 1 | 2 | 3 | 2 | 5 | 2 | | t-Test: Two-Sample Assuming Unequal Variances |
| 1 | 1 | 1 | 4 | 3 | 2 |
| 1 | 3 | 3 | 3 | 4 | 2 |
| 1 | 4 | 2 | 2 | 4 | 1 |
| 1 | 2 | 3 | 5 | 5 | 3 |
| 1 | 2 | 3 | 2 | 4 | 3 |
| 1 | 3 | 5 | 1 | 2 | 1 |
| 1 | 2 | 5 | 4 | 5 | 2 |
| 1 | 1 | 3 | 2 | 3 | 2 |
| 1 | 1 | 2 | 3 | 3 | 3 |
| 1 | 3 | 3 | 2 | 3 | 3 |
| 1 | 2 | 4 | 1 | 4 | 2 |
| 1 | 3 | 4 | 3 | 3 | 2 |
| 1 | 3 | 5 | 3 | 4 | 4 |
| 1 | 5 | 3 | 3 | 5 | 4 |
| 1 | 2 | 3 | 2 | 3 | 3 |
| 1 | 2 | 4 | 4 | 3 | 3 |
| 0 | 3 | 2 | 1 | 2 | 2 |
| 0 | 3 | 4 | 3 | 4 | 2 |
| 0 | 4 | 4 | 3 | 2 | 3 |
| 0 | 3 | 2 | 2 | 2 | 3 |
| 0 | 5 | 5 | 2 | 3 | 2 |
| 0 | 5 | 4 | 4 | 2 | 2 |
| 0 | 3 | 3 | 4 | 3 | 1 |
| 0 | 2 | 1 | 2 | 5 | 3 |
| 0 | 4 | 3 | 1 | 4 | 4 |
| 0 | 2 | 5 | 1 | 4 | 4 |
| 0 | 4 | 4 | 2 | 2 | 3 |
| 0 | 2 | 4 | 2 | 3 | 2 |
| 0 | 3 | 3 | 3 | 4 | 2 |
| Mean |
| Std. Dev. |
| | 1 | 2 | 3 | 4 | 5 |
| T-test |
nawaf89
scm_350_assignment_5_.xlsx
