3). Use Excel to find the standard deviation for GPA of males and females separa
ID: 2921191 • Letter: 3
Question
3). Use Excel to find the standard deviation for GPA of males and females separately.
Educational Data for 78 seventh-Grade Students:
ID
GPA
IQ
Gender
5
8.882
114
F
9
6.000
100
F
11
7.470
104
F
12
5.528
89
F
14
7.571
102
F
15
4.700
91
F
16
8.167
114
F
17
7.822
114
F
18
7.598
103
F
20
6.231
105
F
24
6.419
108
F
27
10.700
130
F
32
9.571
120
F
33
8.998
132
F
34
8.333
111
F
37
9.333
128
F
40
10.140
118
F
41
9.999
119
F
51
3.408
86
F
58
7.295
72
F
59
8.938
111
F
60
7.882
103
F
69
5.237
74
F
72
7.333
112
F
77
8.714
107
F
78
7.833
103
F
80
7.998
98
F
84
5.936
96
F
85
9.000
112
F
86
9.500
112
F
88
6.057
93
F
1
7.940
111
M
2
8.292
107
M
3
4.643
100
M
4
7.470
107
M
6
7.585
115
M
7
7.650
111
M
8
2.412
97
M
10
8.833
112
M
13
7.167
104
M
19
4.000
106
M
21
7.643
113
M
22
1.760
109
M
26
9.648
113
M
28
10.580
128
M
29
9.429
128
M
30
8.000
118
M
31
9.585
113
M
35
8.175
124
M
36
8.000
127
M
38
9.500
136
M
39
9.167
106
M
43
10.760
123
M
44
9.763
124
M
45
9.410
126
M
46
9.167
116
M
47
9.348
127
M
48
8.167
119
M
50
3.647
97
M
52
3.936
102
M
53
7.167
110
M
54
7.647
120
M
55
0.530
103
M
56
6.173
115
M
57
7.295
93
M
61
8.353
123
M
62
5.062
79
M
63
8.175
119
M
64
8.235
110
M
65
7.588
110
M
68
7.647
107
M
71
7.825
105
M
74
9.167
105
M
76
7.996
110
M
79
4.885
77
M
83
3.820
90
M
87
6.057
114
M
89
6.938
106
M
ID
GPA
IQ
Gender
5
8.882
114
F
9
6.000
100
F
11
7.470
104
F
12
5.528
89
F
14
7.571
102
F
15
4.700
91
F
16
8.167
114
F
17
7.822
114
F
18
7.598
103
F
20
6.231
105
F
24
6.419
108
F
27
10.700
130
F
32
9.571
120
F
33
8.998
132
F
34
8.333
111
F
37
9.333
128
F
40
10.140
118
F
41
9.999
119
F
51
3.408
86
F
58
7.295
72
F
59
8.938
111
F
60
7.882
103
F
69
5.237
74
F
72
7.333
112
F
77
8.714
107
F
78
7.833
103
F
80
7.998
98
F
84
5.936
96
F
85
9.000
112
F
86
9.500
112
F
88
6.057
93
F
1
7.940
111
M
2
8.292
107
M
3
4.643
100
M
4
7.470
107
M
6
7.585
115
M
7
7.650
111
M
8
2.412
97
M
10
8.833
112
M
13
7.167
104
M
19
4.000
106
M
21
7.643
113
M
22
1.760
109
M
26
9.648
113
M
28
10.580
128
M
29
9.429
128
M
30
8.000
118
M
31
9.585
113
M
35
8.175
124
M
36
8.000
127
M
38
9.500
136
M
39
9.167
106
M
43
10.760
123
M
44
9.763
124
M
45
9.410
126
M
46
9.167
116
M
47
9.348
127
M
48
8.167
119
M
50
3.647
97
M
52
3.936
102
M
53
7.167
110
M
54
7.647
120
M
55
0.530
103
M
56
6.173
115
M
57
7.295
93
M
61
8.353
123
M
62
5.062
79
M
63
8.175
119
M
64
8.235
110
M
65
7.588
110
M
68
7.647
107
M
71
7.825
105
M
74
9.167
105
M
76
7.996
110
M
79
4.885
77
M
83
3.820
90
M
87
6.057
114
M
89
6.938
106
M
Explanation / Answer
Female: -
For finding population standard deviation in excel, formula is STDEV.P and for finding sample standard deviation, it is STDEV.S.
ID GPA IQ Gender 5 8.882 114 F 9 6 100 F 11 7.47 104 F 12 5.528 89 F 14 7.571 102 F 15 4.7 91 F 16 8.167 114 F 17 7.822 114 F 18 7.598 103 F 20 6.231 105 F 24 6.419 108 F 27 10.7 130 F 32 9.571 120 F 33 8.998 132 F 34 8.333 111 F 37 9.333 128 F 40 10.14 118 F 41 9.999 119 F 51 3.408 86 F 58 7.295 72 F 59 8.938 111 F 60 7.882 103 F 69 5.237 74 F 72 7.333 112 F 77 8.714 107 F 78 7.833 103 F 80 7.998 98 F 84 5.936 96 F 85 9 112 F 86 9.5 112 F 88 6.057 93 F Std Dev 1.720813293Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.