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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!