10-02 統計資料.md

10-02 統計資料

使用資料集

自製 dataset
    |__ student.csv (349筆)

本範例使用PyCharm

增加外掛模組:
pandas
scipy

執行結果:

(1)main.py

import pandas
from scipy import stats

#--------------------------------------------------------------------------------------------
# serNo, gender, essay, eng, chi, mat, soc, nat, matT, engT, chiT, speT
#--------------------------------------------------------------------------------------------
data = pandas.read_csv('data/student.csv', sep=',')

#---------------------------
# 資料分群
#---------------------------
data2 = data.loc[:, ['gender', 'chi', 'chiT']]
data2_gender = data2.groupby('gender')

print('分群平均值')
print(data2_gender.mean())
print('-'*30)

print('分群變異數')
print(data2_gender.std())
print('-'*30)


#-----------------------------------------------------------
# 假設檢定(雙尾T檢定)
#-----------------------------------------------------------
# H0:兩個群組的平均值相同(虛無假設, null hypothesis)
# H1:兩個群組的平均值不同(對立假設, alternative hypothesis）
#
# 如果p值大於門檻值, 如0.05或0.1, 接受絕虛無假設;
# (接受絕虛無假設不表示H0為真, 只是樣本沒有足夠證據推翻它)
# 如果p值小於門檻值, 拒絕H0.(表示樣本提供足夠證據接受H1為真)
#-----------------------------------------------------------
data_chi_male = data.loc[data['gender']==1, 'chiT']
data_chi_female = data.loc[data['gender']==2, 'chiT']

t, p = stats.ttest_ind(data_chi_male, data_chi_female, equal_var=True)
print('雙尾T檢定')
print('t值:', t)
print('p值:', p)
print('-'*30)

#-----------------------------------------------------------
# 假設檢定(單尾T檢定)
#-----------------------------------------------------------
# H0:女生的平均分數<=男生平均(虛無假設, null hypothesis)
# H1:女生的平均分數>男生平均(對立假設, alternative hypothesis）
#
# 如果p/2值小於門檻值, 如0.05或0.1, 且t>0 => 接受對立假設(大於);
# 如果p/2值小於門檻值, 如0.05或0.1, 且t<0 => 接受對立假設(小於);
#-----------------------------------------------------------
data_chi_male = data.loc[data['gender']==1, 'chiT']
data_chi_female = data.loc[data['gender']==2, 'chiT']

t, p = stats.ttest_ind(data_chi_female, data_chi_male, equal_var=True)
print('單尾T檢定')
print('t值:', t)
print('p值:', p)
print('-'*30)

(2)student.csv

serNo,gender,essay,eng,chi,mat,soc,nat,matT,engT,chiT,speT
1,2,8,55,50,46,48,33,27.86,49.64,13.58,25.08
2,2,8,55,43,33,37,40,27.62,37.47,15.71,26.79
3,2,10,56,48,60,55,33,25.03,17.39,28,23.99
4,2,10,55,37,49,41,42,44.94,36.22,28.92,37.37
5,2,10,55,45,41,48,39,39.53,39.07,32.38,32.79
6,2,8,51,48,39,48,44,45.95,39.19,34.06,38.02
7,2,8,48,35,35,27,28,22.62,29.87,34.74,26.62
8,2,8,60,42,39,50,36,33.04,24.47,35.1,27.65
9,2,10,52,46,50,46,45,42.23,33.29,35.59,30.49
10,2,10,52,53,40,52,48,33.62,28.3,35.59,32.12
11,2,10,60,40,52,41,49,63.02,42.75,35.65,32.71
12,2,8,55,40,46,43,41,44.63,44.21,35.77,42.72
13,2,8,56,44,47,46,41,34.65,47.22,37.06,33.37
14,2,8,55,50,49,35,41,40.65,30.53,37.33,42.27
15,2,8,55,45,43,55,49,40.59,45.34,37.49,37.95
16,2,8,60,43,43,37,38,45.75,42.69,37.62,45.03
17,2,8,56,50,42,46,48,37.09,35.86,37.82,46.62
18,2,10,52,46,57,39,42,47.5,44.55,38,44.8
19,2,8,55,42,46,39,35,39.41,49.27,38.19,43.39
20,2,10,60,40,43,32,40,44.05,38.15,38.35,45.32
21,2,8,52,46,50,55,34,50.44,41.19,38.86,41.64
22,2,10,51,48,52,44,43,33.81,40.15,39.11,41.75
23,2,8,51,35,56,34,35,58.18,43.29,39.07,47.78
24,2,8,47,48,47,52,49,36.94,35.85,39.12,38.3
25,2,8,55,48,35,43,44,28.72,53.51,39.3,29.07
26,2,8,60,38,39,40,49,53.59,40.35,39.3,45.19
27,2,8,41,53,52,40,41,35.63,43.57,39.38,39.76
28,2,10,60,50,41,44,42,44.28,43.9,39.5,43.07
29,2,10,51,42,37,50,54,37.52,37.38,40.18,38.33
30,2,8,60,42,43,35,52,52.93,44.27,40.44,43.4
31,2,12,55,42,33,50,41,32.42,12.21,40.57,21.34
32,2,6,60,43,43,39,46,46.03,47.24,40.68,46.28
33,2,10,45,48,46,46,49,53.32,49.63,40.78,44.48
34,2,8,56,40,53,48,46,57.75,45.84,40.92,41.7
35,2,8,55,48,41,44,44,33.96,45.92,41.77,38.02
36,2,8,55,45,43,44,40,30.3,45.73,41.91,40.76
37,2,8,60,48,43,52,35,35.38,47.31,41.87,38.55
38,2,10,56,46,47,42,46,47.37,48.07,42.02,52.37
39,2,8,52,53,53,44,41,38.07,45.91,42.12,34.6
40,2,10,52,56,42,41,43,42.59,32.25,42.09,34.17
41,2,10,55,35,49,34,47,52.21,43.15,42.25,48.4
42,2,6,55,43,52,35,42,43.5,42.3,42.35,39.87
43,2,8,52,44,50,41,46,49.22,43.59,42.73,45.08
44,2,8,60,40,49,40,35,37.85,51.14,42.65,42.56
45,2,8,55,45,41,48,38,41.42,41.43,42.77,37.19
46,2,8,55,43,52,39,46,49.2,43.06,42.83,38.22
47,2,8,55,43,43,46,40,48.45,48.07,43.01,43.3
48,2,8,48,43,56,48,46,49.65,37.91,43.16,45.5
49,2,10,48,42,56,46,35,46.53,39.11,43.34,34.36
50,2,10,60,48,50,46,39,38.72,41.86,43.55,40.31
51,2,10,60,38,53,50,40,45.61,52.82,43.57,48.66
52,2,8,55,42,39,48,47,40.88,45.4,43.75,38.76
53,2,10,56,48,47,50,51,53.94,50.2,43.85,49.02
54,2,8,60,56,41,52,43,42.27,26.24,43.88,41.31
55,2,8,56,50,42,46,48,37.4,31.34,43.98,37.28
56,2,8,51,45,49,44,38,37.76,53.71,44.01,44.18
57,2,8,60,46,42,48,37,39.01,38.95,44.08,43.18
58,2,8,51,48,46,46,38,49.53,42.71,44.24,47.11
59,2,8,60,50,43,48,43,52.71,36.67,44.27,34.26
60,2,10,60,53,46,35,42,20.9,43.46,44.35,32.53
61,2,10,51,60,46,44,43,42.51,49.83,44.35,35.92
62,2,8,52,56,50,39,43,41.42,39.28,44.49,43.46
63,2,8,60,42,37,46,38,28.02,55.81,44.6,36.72
64,2,8,55,43,46,50,47,48.32,38.77,44.98,44.69
65,2,10,60,40,50,41,40,42.88,45.35,45.23,45.68
66,2,8,60,31,46,40,40,43.06,50.4,45.22,50.55
67,2,8,51,48,43,50,49,39.87,41.4,45.3,46.71
68,2,8,49,53,47,52,46,39.72,35.58,45.3,37.12
69,2,8,48,37,49,41,49,50.04,55.77,45.3,44.65
70,2,8,43,50,56,40,40,42.28,24.53,45.41,50.05
71,2,10,60,43,52,46,41,56.43,48.7,45.54,48.68
72,2,8,60,44,53,46,34,34.32,36.12,45.56,37.59
73,2,8,60,35,49,46,32,48.28,56.81,46,46.24
74,2,12,49,50,53,41,46,45.12,46.04,46.08,41.56
75,2,8,48,50,43,48,46,40.25,50.76,46.87,50.84
76,2,8,55,48,52,35,44,62.53,43.66,46.89,54.77
77,2,8,51,53,56,55,52,45.87,50.39,46.96,49.4
78,2,8,55,48,49,41,39,57.87,42.71,46.96,56.21
79,2,10,60,45,49,43,49,57.67,59.54,47.37,51.03
80,2,10,55,40,56,40,40,51.28,49.32,47.52,48.52
81,2,8,56,48,42,42,45,48.72,46.24,47.52,42.68
82,2,8,51,35,49,32,33,58.53,43.42,47.48,49.73
83,2,8,60,48,39,40,42,37.42,38.43,47.7,44.5
84,2,10,56,50,47,50,49,50.67,58.25,47.9,53.03
85,2,8,60,34,52,41,43,55.23,52.45,47.9,51.57
86,2,10,55,42,56,44,39,45.87,38.6,47.9,44.84
87,2,8,51,43,46,55,47,44.67,41.03,48.14,45.32
88,2,10,51,53,52,41,49,59.68,43.88,48.21,51.43
89,2,8,60,53,33,50,40,31.13,58.96,48.37,33.57
90,2,8,43,45,46,50,47,47.12,19.02,48.61,47.16
91,2,8,52,56,40,50,42,42.83,40.26,48.69,34.76
92,2,8,55,43,39,44,43,46.95,41.24,48.94,34.8
93,2,8,55,43,52,46,47,46.62,49.62,48.89,47.01
94,2,8,55,43,52,46,46,52.78,55.35,48.94,54.36
95,2,8,51,50,46,39,38,46.28,46.66,48.94,45.82
96,2,10,48,45,41,52,44,53.15,57.49,48.94,55.64
97,2,6,55,38,49,36,42,33.32,58.44,49.12,29.25
98,2,8,55,50,43,48,52,51.03,50.11,49.25,55.12
99,2,8,55,38,49,52,44,53.31,47.02,49.32,53.02
100,2,10,51,43,41,55,47,51.51,60.79,49.35,46.37
101,2,10,48,42,49,43,42,59.69,52.26,49.56,57.98
102,2,8,51,48,41,55,41,51.37,61.96,49.73,57.4
103,2,10,51,40,41,50,42,50.64,58.79,49.76,45.55
104,2,8,49,44,50,52,48,58.21,44.04,50.1,48.3
105,2,8,55,42,49,43,40,50.53,62.79,50.44,48.47
106,2,8,55,50,41,41,52,55.25,58.14,50.5,49.99
107,2,8,43,45,52,39,50,39.62,38.8,50.5,43.68
108,2,10,60,48,37,36,39,57.51,54.5,50.59,57.07
109,2,8,55,43,39,43,46,41.44,47.85,50.71,44.23
110,2,8,43,45,46,50,47,52.9,56.25,50.71,59.38
111,2,8,51,45,49,43,52,54.31,50.79,51.19,55.82
112,2,8,55,45,49,41,52,47.03,58.24,51.32,53.01
113,2,8,60,53,42,42,51,39.77,42.19,51.44,43.96
114,2,10,56,53,47,46,43,52.71,50.7,51.44,49.36
115,2,8,56,46,53,46,43,56.22,54.67,51.44,50.31
116,2,8,60,42,41,44,40,48.45,43.78,51.41,51.91
117,2,10,51,43,39,48,46,51.98,41.43,51.42,52.11
118,2,10,55,56,39,46,35,41.02,41.82,51.88,48.58
119,2,8,55,45,56,50,49,65.53,48.92,51.91,62.71
120,2,10,55,43,49,36,50,55.97,48.48,52,49.69
121,2,8,55,45,43,41,42,53.15,52.63,52.04,52.18
122,2,8,60,50,46,46,36,47.55,56.19,52.16,48.81
123,2,8,60,45,41,40,49,57.39,51.7,52.16,52.54
124,2,8,56,44,53,50,45,54.03,51.14,52.16,50.34
125,2,8,55,43,39,46,42,52.49,50.23,52.26,54.32
126,2,8,60,42,35,48,44,44.69,57.23,52.34,46.52
127,2,12,60,56,37,44,25,45.11,58.23,52.45,45.43
128,2,8,55,53,43,41,46,47.91,53.85,52.4,52.86
129,2,8,55,37,49,55,49,56.91,51.89,52.4,52.44
130,2,8,60,38,49,34,47,53.31,53.01,52.4,55.02
131,2,10,60,40,52,37,35,56,57.76,52.4,60.06
132,2,8,60,53,46,48,38,53.82,56.55,52.52,54.18
133,2,8,55,43,39,44,49,61.73,58.75,52.52,58.77
134,2,8,52,38,57,50,46,71.71,55.78,52.65,60.78
135,2,8,56,40,45,46,45,58.22,63.54,52.78,57.5
136,2,8,60,43,52,50,50,46.79,53.94,52.88,55.08
137,2,10,55,40,43,44,47,51.16,59.85,52.9,61.95
138,2,10,60,60,46,44,44,55.47,52.07,52.87,56.04
139,2,8,51,38,49,43,52,51.06,45.47,53.03,56.07
140,2,10,60,50,53,42,34,50.07,53.42,53.14,55.96
141,2,8,55,53,46,46,43,40.35,52.63,53.35,47.83
142,2,8,60,40,43,43,36,56.88,45.65,53.25,57.45
143,2,10,60,43,56,41,43,61.96,60.68,53.82,63.2
144,2,10,60,50,46,48,46,59.29,56.19,53.84,55.23
145,2,8,45,53,49,48,39,45.05,36.87,53.83,41.93
146,2,8,60,25,46,44,46,50.73,55.26,53.84,52
147,2,8,56,50,45,48,51,54.32,51.51,53.9,53.38
148,2,10,60,44,47,41,48,60.62,58.35,53.88,50.21
149,2,8,60,50,43,50,57,44.28,53.44,53.94,49.25
150,2,10,52,42,50,55,48,45.28,43.66,53.98,48.95
151,2,8,52,48,57,52,42,53.78,62.31,53.98,53.56
152,2,8,60,43,39,48,49,56.19,50.01,54.06,48.08
153,2,8,55,45,46,43,46,61.04,44.07,54.07,50.02
154,2,8,55,50,52,44,43,56.44,54.53,54.07,53.77
155,2,8,51,56,46,46,52,54.54,57.52,54.06,53.26
156,2,8,55,43,39,44,49,55.23,45.06,54.2,50.76
157,2,10,52,46,45,55,49,55.47,54.69,54.29,56.33
158,2,10,60,45,46,52,43,58.78,63.03,54.28,66.14
159,2,10,55,43,49,39,41,54.33,54.98,54.32,51.13
160,2,8,60,45,43,55,40,53.86,48.71,54.38,52.78
161,2,10,48,60,43,48,39,53.65,59.17,54.52,51.74
162,2,8,60,48,56,46,54,60.28,50.58,54.53,61
163,2,8,60,45,41,40,41,50.07,50,54.63,48.45
164,2,10,48,50,49,50,49,42.78,54.42,54.57,48.31
165,2,8,48,42,43,50,54,59.78,43.18,54.57,56.94
166,2,8,56,44,40,52,48,53.1,60.69,54.58,53.74
167,2,8,60,42,43,41,35,52.9,49.28,54.58,49.22
168,2,10,51,50,39,46,46,54.9,52.61,54.55,47.54
169,2,10,51,45,49,44,50,46.59,48.7,54.77,50.5
170,2,10,60,50,46,34,50,57.97,56.44,54.79,57.81
171,2,8,56,46,53,46,45,48.38,51.99,54.95,47.87
172,2,10,48,40,49,41,43,52.65,53.38,55.14,55.16
173,2,10,42,46,53,48,45,51.89,34.99,55.13,48.79
174,2,10,51,50,41,55,54,48.99,51.89,55.24,56.71
175,2,8,55,43,52,46,49,52.91,56.53,55.31,61.89
176,2,8,51,48,46,46,36,52.08,49.12,55.35,50.13
177,2,8,51,45,49,40,50,55.95,47.02,55.48,48.31
178,2,8,49,48,53,52,46,60.5,43.37,55.5,52.31
179,2,10,60,42,50,50,43,54.03,45.15,55.71,51.39
180,2,10,60,40,46,43,40,44.91,59.75,55.71,50.31
181,2,10,60,45,52,43,43,51.53,60.4,55.76,48.25
182,2,10,55,43,49,46,46,56.88,64.61,55.77,55.9
183,2,8,52,46,53,42,49,57.11,49.35,55.86,51.32
184,2,8,51,42,46,46,43,60.88,51.02,55.87,64.18
185,2,8,60,42,52,46,41,59.27,60.71,55.86,63.84
186,2,10,48,42,43,52,43,51.31,55.43,55.96,54.86
187,2,8,51,50,46,48,47,56.43,58.06,56.19,56.84
188,2,12,55,50,43,40,46,39.26,42.07,56.36,47.13
189,2,10,60,48,45,46,49,50.81,59.61,56.46,53.28
190,2,10,51,43,39,48,49,56,40.87,56.58,55
191,2,8,55,48,49,50,44,43.03,48.2,56.94,52.8
192,2,6,55,45,43,43,43,60.38,54.82,56.95,56.81
193,2,10,56,46,42,48,37,48.4,58.94,56.9,54.68
194,2,8,56,50,42,50,39,39.6,54.02,56.99,46.25
195,2,8,56,44,50,44,46,51.43,45.28,57.1,47.19
196,2,10,60,50,36,46,46,39.37,54.92,57.35,52.08
197,2,10,60,56,40,46,46,51.81,50.2,57.41,47.25
198,2,8,60,43,39,50,36,40.34,51.49,57.59,49.94
199,2,10,56,50,53,52,49,51.39,60.12,57.61,54.01
200,2,6,60,40,39,46,44,64.14,58.78,57.59,50.63
201,2,10,60,42,46,43,46,59.8,61.43,57.85,62
202,2,8,55,37,43,44,54,57.03,42.22,57.82,54.14
203,2,8,60,42,52,40,41,61.48,63.49,58.08,63.53
204,2,12,55,48,52,44,43,62.14,58.06,58.14,58
205,2,8,60,50,37,44,40,38.24,51.88,58.24,48.37
206,2,8,60,38,56,50,47,55.01,53.29,58.29,58.95
207,2,8,60,42,53,42,45,66.39,58.05,58.44,63.01
208,2,12,60,48,45,48,45,48.98,54.08,58.38,56.7
209,2,10,49,50,42,52,46,51.81,58.79,58.65,58.97
210,2,10,60,53,47,39,48,46.28,53.7,58.71,44.22
211,2,8,60,42,49,52,49,58.59,56.75,58.79,58.59
212,2,10,56,53,60,42,45,52.59,51.51,59.03,51.2
213,2,10,52,53,40,48,42,39.78,61.79,59.04,46.96
214,2,8,41,48,46,50,49,64.21,57.86,59.06,64.79
215,2,10,51,42,43,50,46,65.76,58.35,59.32,65.3
216,2,8,60,50,39,44,47,47.44,50.13,59.58,49.75
217,2,6,44,44,53,55,45,54.33,54.66,59.73,55.97
218,2,8,55,45,37,50,52,53.53,64.94,59.89,47.11
219,2,6,55,38,56,43,36,62.11,57.68,59.99,57.75
220,2,8,60,53,39,50,54,60.38,59.38,60.06,55.79
221,2,8,55,48,52,52,46,54.51,53.01,60.21,52.87
222,2,8,60,48,39,41,34,49.8,64.56,60.31,63.76
223,2,10,60,45,35,46,40,32.93,52.5,60.53,48.09
224,2,8,48,27,56,44,46,68.05,62.13,60.53,69.82
225,2,8,56,53,42,50,48,68.5,60.41,60.53,62.11
226,2,8,48,38,49,48,49,60.89,56.64,60.56,55.76
227,2,8,55,42,37,48,46,51.14,48.9,60.71,52.06
228,2,8,56,46,47,48,45,63.18,61.67,60.82,64.31
229,2,8,55,53,52,55,57,60.15,59.47,60.82,67.03
230,2,8,60,50,56,48,57,70.49,66.23,60.76,67.26
231,2,8,60,50,41,55,44,49.2,56.44,61.01,58.7
232,2,10,60,42,40,44,46,61.78,65.2,61.05,54.81
233,2,10,60,42,46,48,46,56.66,56.44,61.01,59.62
234,2,10,56,53,40,48,51,63.64,65.92,61.16,61.17
235,2,10,60,50,57,50,46,59.95,50.11,61.25,45.98
236,2,10,60,50,46,48,49,62.92,63.12,61.4,63.76
237,2,10,56,46,47,50,45,46.53,50.59,61.37,58.95
238,2,8,60,53,39,50,42,54.33,62.91,61.54,58.54
239,2,8,51,43,41,48,49,57.51,59.76,61.47,59.07
240,2,12,55,53,41,43,47,52.35,57.5,61.63,53.94
241,2,8,55,42,46,46,41,63.04,60.29,61.75,62.35
242,2,10,49,46,50,42,45,58.75,61.23,61.73,57.91
243,2,10,56,46,38,50,39,59.21,51.09,61.73,55.8
244,2,8,48,43,46,43,50,60.15,56.72,62.02,56.68
245,2,10,56,56,42,55,41,33.98,44.62,61.97,42.31
246,2,8,55,45,39,46,44,47.85,59.26,62.21,60.84
247,2,8,52,46,34,60,46,57.67,58.42,62.16,56.87
248,2,8,48,45,49,52,46,64.21,58.61,62.16,67.27
249,2,8,60,48,49,48,47,59.8,58.62,62.34,61.13
250,2,10,51,48,39,48,43,46.76,55.93,62.31,52.91
251,2,10,56,48,57,42,45,63.24,65.72,62.45,61.91
252,2,8,52,46,36,55,45,50.58,50.35,62.42,57.79
253,2,10,48,43,46,50,47,53.78,56.81,62.55,44.82
254,2,10,51,48,60,50,42,63.88,62.93,62.58,64.4
255,2,8,60,56,31,46,50,60.88,58.79,62.57,60.96
256,2,10,48,43,43,50,43,64.36,54.66,62.57,64.46
257,2,8,60,53,37,43,43,52.27,56.29,62.69,58.48
258,2,12,52,40,50,50,49,57.34,63.32,62.77,61.47
259,2,8,55,56,43,52,47,62.95,60.61,62.77,63.58
260,2,10,48,53,43,43,43,50.85,60.37,63.08,59.58
261,2,8,56,42,45,48,48,59.65,59.1,63.34,62.53
262,2,8,51,56,35,48,49,66.84,59.85,63.28,66.19
263,2,8,56,53,40,55,43,61.48,59.24,63.4,61.79
264,2,10,60,50,46,40,41,62.58,54.97,63.4,55.25
265,2,8,51,48,41,55,50,65.38,63.46,63.61,63.25
266,2,10,60,50,35,43,46,49.8,61.13,64.02,58.73
267,2,10,51,53,56,52,52,61.78,56.81,64.33,69.37
268,2,8,60,42,57,42,45,64.99,58.06,64.6,63.05
269,2,12,52,53,42,44,46,62.51,67.35,65.01,58.92
270,2,10,56,44,42,46,42,67.38,60.06,65.17,66.45
271,2,8,49,53,40,48,41,49.42,64.03,65.17,55.54
272,2,10,60,46,50,60,57,61.48,57.76,65.56,58.91
273,2,12,49,50,45,46,43,71.11,68.14,65.63,70.54
274,2,10,49,48,57,46,39,65.94,67.71,65.75,65.92
275,2,10,60,46,47,48,45,65.87,59.83,65.8,61.63
276,2,10,60,45,43,46,39,58.05,59.47,66.32,60.43
277,2,8,56,50,47,42,49,65.21,62.33,67.47,65.45
278,2,8,48,43,41,52,52,66.05,64.4,67.95,72.91
279,2,10,48,50,52,40,54,70.03,63.5,69.35,67.16
280,2,8,55,50,37,44,49,74.14,69.28,70.2,68.29
281,2,10,51,60,39,46,41,65.21,62.9,71.87,69.65
282,2,10,51,53,41,48,49,68.53,60.87,75.56,67.86
283,1,8,51,37,56,41,44,37.96,24.4,20.19,29.38
284,1,8,55,29,49,43,38,38.24,34.33,26.65,37.94
285,1,8,60,45,41,44,41,29.2,34.33,27.09,25.4
286,1,8,55,32,43,50,44,31.45,35.54,27.34,36.79
287,1,8,47,48,45,50,42,26.32,34.77,28.03,20.52
288,1,6,60,46,45,52,43,32.38,57.86,29.13,36.4
289,1,8,49,48,40,52,45,33.97,41.68,30.32,38.36
290,1,6,49,44,40,38,27,38.55,41,30.55,34.41
291,1,8,60,40,52,41,41,33.78,34.81,30.93,39.42
292,1,8,45,48,43,52,52,49.96,37.79,32.04,37.39
293,1,8,60,35,49,48,50,56.02,53.42,32.94,41.47
294,1,8,51,48,52,46,52,40.54,30.69,32.94,30.83
295,1,8,39,40,60,50,47,47.5,38.46,33.06,43.82
296,1,6,55,50,52,52,44,34.15,22.65,33.74,26.45
297,1,8,60,38,43,35,46,32.58,41.17,34.06,34.23
298,1,8,40,50,47,46,48,37.52,33.65,34.91,36.89
299,1,10,60,37,43,44,35,32.04,50.95,35.04,34.9
300,1,8,55,42,43,50,57,38.03,36.72,35.36,46.35
301,1,8,51,42,43,52,52,44.92,43.89,37.57,44.52
302,1,10,49,42,57,44,49,43.84,38.44,38.61,42.7
303,1,10,42,42,47,50,49,42.88,36.24,39.04,40.03
304,1,8,56,48,42,46,41,47.58,47.06,39.38,50.7
305,1,8,60,50,39,46,49,36.53,39.11,39.5,30.2
306,1,8,56,38,42,48,48,50.12,43.15,39.72,47.48
307,1,6,55,45,49,41,47,42.78,45.09,39.8,38.7
308,1,10,55,42,43,44,43,38.99,45.5,39.79,53.83
309,1,8,55,38,46,37,47,54.83,37.69,40.26,48.48
310,1,8,60,43,49,44,47,45.4,46.75,41.35,41.9
311,1,8,52,50,53,44,42,52.95,49.62,41.53,51.29
312,1,8,36,53,45,48,49,34.53,30.88,41.56,39.53
313,1,10,40,48,57,52,51,39.15,42.39,41.99,45.29
314,1,8,56,48,42,52,51,41.09,43.85,42.12,40.27
315,1,6,60,56,49,46,52,43.23,46.65,42.22,46.19
316,1,8,48,48,46,50,50,50.28,36.72,42.16,47.39
317,1,8,55,43,52,43,57,54.75,45.52,42.46,50.76
318,1,8,56,46,36,52,49,51.7,43.78,42.51,39.7
319,1,8,55,43,49,55,50,48.51,52.82,43.88,53.63
320,1,8,51,45,46,50,44,42.03,44.37,44.23,57.5
321,1,8,60,48,42,60,46,55.03,61.35,44.52,54.39
322,1,6,52,42,57,41,48,61.9,41.34,44.52,50.98
323,1,8,34,53,53,50,45,48.19,37.87,44.79,47.34
324,1,8,60,48,31,48,46,41.53,53.85,45.26,48.97
325,1,8,60,44,40,60,46,57.78,57.05,45.41,46.5
326,1,8,51,38,39,44,57,46.35,34.63,45.56,44.33
327,1,8,55,43,52,43,41,41.52,41.27,45.7,41.33
328,1,8,51,43,43,50,44,40.92,31.16,46.25,43.17
329,1,8,51,53,41,41,46,49.42,46.24,46.83,50.17
330,1,8,51,38,43,52,44,58.05,55.94,47.06,58.25
331,1,8,60,46,50,46,55,47.99,52.76,47.36,47.75
332,1,8,55,42,43,46,49,44.53,53.46,48.07,51.01
333,1,8,49,53,57,48,49,63.78,54.66,48.66,57.18
334,1,8,52,46,50,39,45,57.81,52.85,49.81,56.17
335,1,8,60,48,46,46,42,41.96,53.42,50.42,57.01
336,1,8,52,53,50,50,48,57.31,54.97,50.96,49.83
337,1,8,51,50,52,50,50,65.18,54.03,51.23,57.32
338,1,8,51,50,60,52,52,63.31,61.29,51.78,60.6
339,1,8,55,43,49,50,60,50.58,59.47,52.33,44.19
340,1,8,41,56,56,43,41,45.4,40.15,53.08,54.45
341,1,8,47,50,53,36,52,57.34,51.99,53.27,57.5
342,1,8,55,48,39,48,44,52.05,52.91,53.36,54.5
343,1,8,55,32,49,41,41,66.64,64.33,55.88,64.78
344,1,8,56,46,57,60,49,61.37,58.58,57.18,62.54
345,1,8,48,48,46,44,47,60.38,56.82,57.38,55.54
346,1,8,43,48,56,50,46,53.47,35.42,57.93,54.73
347,1,8,56,48,47,50,42,62.08,58.92,59.97,57.96
348,1,8,60,48,41,48,32,48.45,67.99,64.02,62.78
349,1,8,60,56,30,48,41,68.65,68.93,66.95,68.57