Question: Using the date below 1. summarize the data using excel descriptive statistics 2. create a histogram for IQ, inclue Normal distribution density curve 3. make
Using the date below
1. summarize the data using excel descriptive statistics
2. create a histogram for IQ, inclue Normal distribution density curve
3. make a scatter plot with sex(gender) on the x axis and IQ on the y-axis, include trend line. what can you conclude?
| Age | Exam Mark | Paper Mark | Sex | Year in College | IQ |
| 21 | 87 | 83 | M | 2 | 80 |
| 19 | 83 | 80 | M | 1 | 100 |
| 23 | 85 | 86 | M | 4 | 98 |
| 21 | 81 | 75 | F | 1 | 76 |
| 21 | 81 | 75 | F | 3 | 82 |
| 20 | 67 | 68 | F | 3 | 99 |
| 26 | 75 | 88 | F | 2 | 120 |
| 24 | 92 | 78 | F | 4 | 115 |
| 26 | 78 | 92 | M | 4 | 126 |
| 30 | 89 | 95 | F | 3 | 129 |
| 21 | 72 | 80 | F | 1 | 86 |
| 19 | 81 | 65 | M | 2 | 80 |
| 17 | 75 | 77 | M | 1 | 70 |
| 19 | 76 | 85 | F | 1 | 99 |
| 35 | 80 | 83 | F | 3 | 99 |
| 27 | 75 | 60 | F | 2 | 60 |
| 21 | 85 | 80 | M | 3 | 89 |
| 27 | 79 | 75 | M | 4 | 70 |
| 21 | 90 | 93 | F | 3 | 140 |
| 22 | 97 | 95 | M | 3 | 165 |
| 21 | 90 | 82 | M | 2 | 115 |
| 19 | 87 | 86 | F | 3 | 119 |
| 32 | 95 | 90 | M | 2 | 120 |
| 19 | 68 | 57 | F | 3 | 89 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
