Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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