src/ports/postgres/modules/regress/test/clustered.sql_in

-- Test clustered standard errors

DROP TABLE IF EXISTS abalone1;

CREATE TABLE abalone1 (
    id integer,
    sex text,
    length double precision,
    diameter double precision,
    height double precision,
    whole double precision,
    shucked double precision,
    viscera double precision,
    shell double precision,
    rings integer
);

INSERT INTO abalone1 VALUES
(1, 'M', 0.45500000000000002, 0.36499999999999999, 0.095000000000000001, 0.51400000000000001, 0.22450000000000001, 0.10100000000000001, 0.14999999999999999, 15),
(4, 'M', 0.44, 0.36499999999999999, 0.125, 0.51600000000000001, 0.2155, 0.114, 0.155, 10),
(3, 'F', 0.53000000000000003, 0.41999999999999998, 0.13500000000000001, 0.67700000000000005, 0.25650000000000001, 0.14149999999999999, 0.20999999999999999, 9),
(2, 'M', 0.34999999999999998, 0.26500000000000001, 0.089999999999999997, 0.22550000000000001, 0.099500000000000005, 0.048500000000000001, 0.070000000000000007, 7),
(5, 'I', 0.33000000000000002, 0.255, 0.080000000000000002, 0.20499999999999999, 0.089499999999999996, 0.0395, 0.055, 7),
(8, 'F', 0.54500000000000004, 0.42499999999999999, 0.125, 0.76800000000000002, 0.29399999999999998, 0.14949999999999999, 0.26000000000000001, 16),
(7, 'F', 0.53000000000000003, 0.41499999999999998, 0.14999999999999999, 0.77749999999999997, 0.23699999999999999, 0.14149999999999999, 0.33000000000000002, 20),
(6, 'I', 0.42499999999999999, 0.29999999999999999, 0.095000000000000001, 0.35149999999999998, 0.14099999999999999, 0.077499999999999999, 0.12, 8),
(9, 'M', 0.47499999999999998, 0.37, 0.125, 0.50949999999999995, 0.2165, 0.1125, 0.16500000000000001, 9),
(12, 'M', 0.42999999999999999, 0.34999999999999998, 0.11, 0.40600000000000003, 0.16750000000000001, 0.081000000000000003, 0.13500000000000001, 10),
(11, 'F', 0.52500000000000002, 0.38, 0.14000000000000001, 0.60650000000000004, 0.19400000000000001, 0.14749999999999999, 0.20999999999999999, 14),
(10, 'F', 0.55000000000000004, 0.44, 0.14999999999999999, 0.89449999999999996, 0.3145, 0.151, 0.32000000000000001, 19),
(13, 'M', 0.48999999999999999, 0.38, 0.13500000000000001, 0.54149999999999998, 0.2175, 0.095000000000000001, 0.19, 11),
(16, 'M', 0.5, 0.40000000000000002, 0.13, 0.66449999999999998, 0.25800000000000001, 0.13300000000000001, 0.23999999999999999, 12),
(15, 'F', 0.46999999999999997, 0.35499999999999998, 0.10000000000000001, 0.47549999999999998, 0.16750000000000001, 0.080500000000000002, 0.185, 10),
(14, 'F', 0.53500000000000003, 0.40500000000000003, 0.14499999999999999, 0.6845, 0.27250000000000002, 0.17100000000000001, 0.20499999999999999, 10),
(17, 'I', 0.35499999999999998, 0.28000000000000003, 0.085000000000000006, 0.29049999999999998, 0.095000000000000001, 0.0395, 0.115, 7),
(20, 'M', 0.45000000000000001, 0.32000000000000001, 0.10000000000000001, 0.38100000000000001, 0.17050000000000001, 0.074999999999999997, 0.115, 9),
(19, 'M', 0.36499999999999999, 0.29499999999999998, 0.080000000000000002, 0.2555, 0.097000000000000003, 0.042999999999999997, 0.10000000000000001, 7),
(18, 'F', 0.44, 0.34000000000000002, 0.10000000000000001, 0.45100000000000001, 0.188, 0.086999999999999994, 0.13, 10),
(21, 'M', 0.35499999999999998, 0.28000000000000003, 0.095000000000000001, 0.2455, 0.095500000000000002, 0.062, 0.074999999999999997, 11),
(24, 'F', 0.55000000000000004, 0.41499999999999998, 0.13500000000000001, 0.76349999999999996, 0.318, 0.20999999999999999, 0.20000000000000001, 9),
(23, 'F', 0.56499999999999995, 0.44, 0.155, 0.9395, 0.42749999999999999, 0.214, 0.27000000000000002, 12),
(22, 'I', 0.38, 0.27500000000000002, 0.10000000000000001, 0.22550000000000001, 0.080000000000000002, 0.049000000000000002, 0.085000000000000006, 10),
(25, 'F', 0.61499999999999999, 0.47999999999999998, 0.16500000000000001, 1.1615, 0.51300000000000001, 0.30099999999999999, 0.30499999999999999, 10),
(28, 'M', 0.58999999999999997, 0.44500000000000001, 0.14000000000000001, 0.93100000000000005, 0.35599999999999998, 0.23400000000000001, 0.28000000000000003, 12),
(27, 'F', 0.57999999999999996, 0.45000000000000001, 0.185, 0.99550000000000005, 0.39450000000000002, 0.27200000000000002, 0.28499999999999998, 11),
(26, 'F', 0.56000000000000005, 0.44, 0.14000000000000001, 0.92849999999999999, 0.38250000000000001, 0.188, 0.29999999999999999, 11),
(29, 'M', 0.60499999999999998, 0.47499999999999998, 0.17999999999999999, 0.9365, 0.39400000000000002, 0.219, 0.29499999999999998, 15),
(32, 'F', 0.68000000000000005, 0.56000000000000005, 0.16500000000000001, 1.639, 0.60550000000000004, 0.28050000000000003, 0.46000000000000002, 15),
(31, 'M', 0.57999999999999996, 0.46999999999999997, 0.16500000000000001, 0.99750000000000005, 0.39350000000000002, 0.24199999999999999, 0.33000000000000002, 10),
(30, 'M', 0.57499999999999996, 0.42499999999999999, 0.14000000000000001, 0.86350000000000005, 0.39300000000000002, 0.22700000000000001, 0.20000000000000001, 11),
(33, 'M', 0.66500000000000004, 0.52500000000000002, 0.16500000000000001, 1.3380000000000001, 0.55149999999999999, 0.35749999999999998, 0.34999999999999998, 18),
(36, 'M', 0.46500000000000002, 0.35499999999999998, 0.105, 0.47949999999999998, 0.22700000000000001, 0.124, 0.125, 8),
(35, 'F', 0.70499999999999996, 0.55000000000000004, 0.20000000000000001, 1.7095, 0.63300000000000001, 0.41149999999999998, 0.48999999999999999, 13),
(34, 'F', 0.68000000000000005, 0.55000000000000004, 0.17499999999999999, 1.798, 0.81499999999999995, 0.39250000000000002, 0.45500000000000002, 19),
(37, 'F', 0.54000000000000004, 0.47499999999999998, 0.155, 1.2170000000000001, 0.53049999999999997, 0.3075, 0.34000000000000002, 16),
(40, 'M', 0.35499999999999998, 0.28999999999999998, 0.089999999999999997, 0.32750000000000001, 0.13400000000000001, 0.085999999999999993, 0.089999999999999997, 9),
(39, 'F', 0.57499999999999996, 0.44500000000000001, 0.13500000000000001, 0.88300000000000001, 0.38100000000000001, 0.20349999999999999, 0.26000000000000001, 11),
(38, 'F', 0.45000000000000001, 0.35499999999999998, 0.105, 0.52249999999999996, 0.23699999999999999, 0.11650000000000001, 0.14499999999999999, 8),
(41, 'F', 0.45000000000000001, 0.33500000000000002, 0.105, 0.42499999999999999, 0.1865, 0.090999999999999998, 0.115, 9),
(44, 'I', 0.20499999999999999, 0.14999999999999999, 0.055, 0.042000000000000003, 0.025499999999999998, 0.014999999999999999, 0.012, 5),
(43, 'I', 0.23999999999999999, 0.17499999999999999, 0.044999999999999998, 0.070000000000000007, 0.0315, 0.0235, 0.02, 5),
(42, 'F', 0.55000000000000004, 0.42499999999999999, 0.13500000000000001, 0.85150000000000003, 0.36199999999999999, 0.19600000000000001, 0.27000000000000002, 14),
(45, 'I', 0.20999999999999999, 0.14999999999999999, 0.050000000000000003, 0.042000000000000003, 0.017500000000000002, 0.012500000000000001, 0.014999999999999999, 4),
(48, 'F', 0.46000000000000002, 0.375, 0.12, 0.46050000000000002, 0.17749999999999999, 0.11, 0.14999999999999999, 7),
(47, 'M', 0.46999999999999997, 0.37, 0.12, 0.57950000000000002, 0.29299999999999998, 0.22700000000000001, 0.14000000000000001, 9),
(46, 'I', 0.39000000000000001, 0.29499999999999998, 0.095000000000000001, 0.20300000000000001, 0.087499999999999994, 0.044999999999999998, 0.074999999999999997, 7),
(49, 'I', 0.32500000000000001, 0.245, 0.070000000000000007, 0.161, 0.075499999999999998, 0.025499999999999998, 0.044999999999999998, 6),
(52, 'M', 0.40000000000000002, 0.32000000000000001, 0.095000000000000001, 0.30299999999999999, 0.13350000000000001, 0.059999999999999998, 0.10000000000000001, 7),
(51, 'I', 0.52000000000000002, 0.40999999999999998, 0.12, 0.59499999999999997, 0.23849999999999999, 0.111, 0.19, 8),
(50, 'F', 0.52500000000000002, 0.42499999999999999, 0.16, 0.83550000000000002, 0.35449999999999998, 0.2135, 0.245, 9),
(53, 'M', 0.48499999999999999, 0.35999999999999999, 0.13, 0.54149999999999998, 0.25950000000000001, 0.096000000000000002, 0.16, 10),
(56, 'F', 0.5, 0.40000000000000002, 0.14000000000000001, 0.66149999999999998, 0.25650000000000001, 0.17549999999999999, 0.22, 8),
(55, 'M', 0.40500000000000003, 0.31, 0.10000000000000001, 0.38500000000000001, 0.17299999999999999, 0.091499999999999998, 0.11, 7),
(54, 'F', 0.46999999999999997, 0.35999999999999999, 0.12, 0.47749999999999998, 0.21049999999999999, 0.1055, 0.14999999999999999, 10),
(57, 'M', 0.44500000000000001, 0.34999999999999998, 0.12, 0.4425, 0.192, 0.095500000000000002, 0.13500000000000001, 8),
(60, 'F', 0.505, 0.40000000000000002, 0.125, 0.58299999999999996, 0.246, 0.13, 0.17499999999999999, 7),
(59, 'I', 0.245, 0.19, 0.059999999999999998, 0.085999999999999993, 0.042000000000000003, 0.014, 0.025000000000000001, 4),
(58, 'M', 0.46999999999999997, 0.38500000000000001, 0.13500000000000001, 0.58950000000000002, 0.27650000000000002, 0.12, 0.17000000000000001, 8),
(61, 'M', 0.45000000000000001, 0.34499999999999997, 0.105, 0.41149999999999998, 0.17999999999999999, 0.1125, 0.13500000000000001, 7),
(64, 'M', 0.42499999999999999, 0.32500000000000001, 0.095000000000000001, 0.3785, 0.17050000000000001, 0.080000000000000002, 0.10000000000000001, 7),
(63, 'F', 0.53000000000000003, 0.40999999999999998, 0.13, 0.69650000000000001, 0.30199999999999999, 0.19350000000000001, 0.20000000000000001, 10),
(62, 'M', 0.505, 0.40500000000000003, 0.11, 0.625, 0.30499999999999999, 0.16, 0.17499999999999999, 9),
(65, 'M', 0.52000000000000002, 0.40000000000000002, 0.12, 0.57999999999999996, 0.23400000000000001, 0.13150000000000001, 0.185, 8),
(68, 'F', 0.59499999999999997, 0.495, 0.185, 1.2849999999999999, 0.41599999999999998, 0.224, 0.48499999999999999, 13),
(67, 'F', 0.56499999999999995, 0.44, 0.16, 0.91500000000000004, 0.35399999999999998, 0.19350000000000001, 0.32000000000000001, 12),
(66, 'M', 0.47499999999999998, 0.35499999999999998, 0.12, 0.47999999999999998, 0.23400000000000001, 0.10150000000000001, 0.13500000000000001, 8),
(69, 'F', 0.47499999999999998, 0.39000000000000001, 0.12, 0.53049999999999997, 0.2135, 0.11550000000000001, 0.17000000000000001, 10),
(72, 'F', 0.40000000000000002, 0.32000000000000001, 0.11, 0.35299999999999998, 0.14050000000000001, 0.098500000000000004, 0.10000000000000001, 8),
(71, 'M', 0.55500000000000005, 0.42499999999999999, 0.13, 0.76649999999999996, 0.26400000000000001, 0.16800000000000001, 0.27500000000000002, 13),
(70, 'I', 0.31, 0.23499999999999999, 0.070000000000000007, 0.151, 0.063, 0.040500000000000001, 0.044999999999999998, 6),
(73, 'F', 0.59499999999999997, 0.47499999999999998, 0.17000000000000001, 1.2470000000000001, 0.47999999999999998, 0.22500000000000001, 0.42499999999999999, 20),
(76, 'F', 0.59999999999999998, 0.47499999999999998, 0.14999999999999999, 1.0075000000000001, 0.4425, 0.221, 0.28000000000000003, 15),
(75, 'F', 0.60499999999999998, 0.45000000000000001, 0.19500000000000001, 1.0980000000000001, 0.48099999999999998, 0.28949999999999998, 0.315, 13),
(74, 'M', 0.56999999999999995, 0.47999999999999998, 0.17499999999999999, 1.1850000000000001, 0.47399999999999998, 0.26100000000000001, 0.38, 11),
(77, 'M', 0.59499999999999997, 0.47499999999999998, 0.14000000000000001, 0.94399999999999995, 0.36249999999999999, 0.189, 0.315, 9),
(80, 'F', 0.61499999999999999, 0.47499999999999998, 0.17000000000000001, 1.1025, 0.46949999999999997, 0.23549999999999999, 0.34499999999999997, 14),
(79, 'F', 0.55500000000000005, 0.42499999999999999, 0.14000000000000001, 0.78800000000000003, 0.28199999999999997, 0.1595, 0.28499999999999998, 11),
(78, 'F', 0.59999999999999998, 0.46999999999999997, 0.14999999999999999, 0.92200000000000004, 0.36299999999999999, 0.19400000000000001, 0.30499999999999999, 10),
(81, 'F', 0.57499999999999996, 0.44500000000000001, 0.14000000000000001, 0.94099999999999995, 0.38450000000000001, 0.252, 0.28499999999999998, 9),
(84, 'M', 0.59499999999999997, 0.47499999999999998, 0.16, 1.3174999999999999, 0.40799999999999997, 0.23400000000000001, 0.57999999999999996, 21),
(83, 'F', 0.52000000000000002, 0.42499999999999999, 0.16500000000000001, 0.98850000000000005, 0.39600000000000002, 0.22500000000000001, 0.32000000000000001, 16),
(82, 'M', 0.62, 0.51000000000000001, 0.17499999999999999, 1.615, 0.51049999999999995, 0.192, 0.67500000000000004, 12),
(85, 'M', 0.57999999999999996, 0.45000000000000001, 0.14000000000000001, 1.0129999999999999, 0.38, 0.216, 0.35999999999999999, 14),
(88, 'M', 0.56000000000000005, 0.44, 0.16, 0.86450000000000005, 0.33050000000000002, 0.20749999999999999, 0.26000000000000001, 10),
(87, 'M', 0.625, 0.46500000000000002, 0.14000000000000001, 1.1950000000000001, 0.48249999999999998, 0.20499999999999999, 0.40000000000000002, 13),
(86, 'F', 0.56999999999999995, 0.46500000000000002, 0.17999999999999999, 1.2949999999999999, 0.33900000000000002, 0.2225, 0.44, 12),
(89, 'F', 0.46000000000000002, 0.35499999999999998, 0.13, 0.51700000000000002, 0.2205, 0.114, 0.16500000000000001, 9),
(92, 'M', 0.55500000000000005, 0.44, 0.14999999999999999, 0.755, 0.307, 0.1525, 0.26000000000000001, 12),
(91, 'M', 0.56499999999999995, 0.42499999999999999, 0.13500000000000001, 0.8115, 0.34100000000000003, 0.16750000000000001, 0.255, 15),
(90, 'F', 0.57499999999999996, 0.45000000000000001, 0.16, 0.97750000000000004, 0.3135, 0.23100000000000001, 0.33000000000000002, 12),
(93, 'M', 0.59499999999999997, 0.46500000000000002, 0.17499999999999999, 1.115, 0.40150000000000002, 0.254, 0.39000000000000001, 13),
(96, 'M', 0.66500000000000004, 0.53500000000000003, 0.19500000000000001, 1.6060000000000001, 0.57550000000000001, 0.38800000000000001, 0.47999999999999998, 14),
(95, 'M', 0.69499999999999995, 0.56000000000000005, 0.19, 1.494, 0.58799999999999997, 0.34250000000000003, 0.48499999999999999, 15),
(94, 'F', 0.625, 0.495, 0.16500000000000001, 1.262, 0.50700000000000001, 0.318, 0.39000000000000001, 10),
(97, 'M', 0.53500000000000003, 0.435, 0.14999999999999999, 0.72499999999999998, 0.26900000000000002, 0.13850000000000001, 0.25, 9),
(100, 'F', 0.47499999999999998, 0.375, 0.125, 0.57850000000000001, 0.27750000000000002, 0.085000000000000006, 0.155, 10),
(99, 'M', 0.46999999999999997, 0.37, 0.13, 0.52249999999999996, 0.20100000000000001, 0.13300000000000001, 0.16500000000000001, 7),
(98, 'M', 0.46999999999999997, 0.375, 0.13, 0.52300000000000002, 0.214, 0.13200000000000001, 0.14499999999999999, 8),
(101, 'I', 0.35999999999999999, 0.26500000000000001, 0.095000000000000001, 0.23150000000000001, 0.105, 0.045999999999999999, 0.074999999999999997, 7),
(104, 'M', 0.53000000000000003, 0.41499999999999998, 0.14000000000000001, 0.72399999999999998, 0.3105, 0.16750000000000001, 0.20499999999999999, 10),
(103, 'M', 0.53000000000000003, 0.435, 0.16, 0.88300000000000001, 0.316, 0.16400000000000001, 0.33500000000000002, 15),
(102, 'M', 0.55000000000000004, 0.435, 0.14499999999999999, 0.84299999999999997, 0.32800000000000001, 0.1915, 0.255, 15),
(105, 'M', 0.60499999999999998, 0.46999999999999997, 0.16, 1.1735, 0.4975, 0.24049999999999999, 0.34499999999999997, 12),
(108, 'F', 0.5, 0.40000000000000002, 0.125, 0.66749999999999998, 0.26100000000000001, 0.13150000000000001, 0.22, 10),
(107, 'F', 0.54500000000000004, 0.42999999999999999, 0.16500000000000001, 0.80200000000000005, 0.29349999999999998, 0.183, 0.28000000000000003, 11),
(106, 'F', 0.52000000000000002, 0.40999999999999998, 0.155, 0.72699999999999998, 0.29099999999999998, 0.1835, 0.23499999999999999, 12),
(109, 'F', 0.51000000000000001, 0.39000000000000001, 0.13500000000000001, 0.63349999999999995, 0.23100000000000001, 0.17899999999999999, 0.20000000000000001, 9),
(112, 'M', 0.46500000000000002, 0.35999999999999999, 0.105, 0.43099999999999999, 0.17199999999999999, 0.107, 0.17499999999999999, 9),
(111, 'M', 0.495, 0.39500000000000002, 0.125, 0.54149999999999998, 0.23749999999999999, 0.13450000000000001, 0.155, 9),
(110, 'F', 0.435, 0.39500000000000002, 0.105, 0.36349999999999999, 0.13600000000000001, 0.098000000000000004, 0.13, 9),
(113, 'I', 0.435, 0.32000000000000001, 0.080000000000000002, 0.33250000000000002, 0.14849999999999999, 0.063500000000000001, 0.105, 9),
(116, 'F', 0.53000000000000003, 0.41499999999999998, 0.115, 0.59150000000000003, 0.23300000000000001, 0.1585, 0.17999999999999999, 11),
(115, 'F', 0.54500000000000004, 0.40999999999999998, 0.125, 0.69350000000000001, 0.29749999999999999, 0.14599999999999999, 0.20999999999999999, 11),
(114, 'M', 0.42499999999999999, 0.34999999999999998, 0.105, 0.39300000000000002, 0.13, 0.063, 0.16500000000000001, 9),
(117, 'F', 0.48999999999999999, 0.375, 0.13500000000000001, 0.61250000000000004, 0.2555, 0.10199999999999999, 0.22, 11),
(120, 'M', 0.40500000000000003, 0.30499999999999999, 0.085000000000000006, 0.26050000000000001, 0.1145, 0.059499999999999997, 0.085000000000000006, 8),
(119, 'F', 0.56000000000000005, 0.42999999999999999, 0.14999999999999999, 0.88249999999999995, 0.34649999999999997, 0.17199999999999999, 0.31, 9),
(118, 'M', 0.44, 0.34000000000000002, 0.105, 0.40200000000000002, 0.1305, 0.095500000000000002, 0.16500000000000001, 10),
(121, 'F', 0.46999999999999997, 0.36499999999999999, 0.105, 0.42049999999999998, 0.16300000000000001, 0.10349999999999999, 0.14000000000000001, 9),
(124, 'M', 0.37, 0.26500000000000001, 0.074999999999999997, 0.214, 0.089999999999999997, 0.050999999999999997, 0.070000000000000007, 6),
(123, 'F', 0.51500000000000001, 0.42499999999999999, 0.14000000000000001, 0.76600000000000001, 0.30399999999999999, 0.17249999999999999, 0.255, 14),
(122, 'I', 0.38500000000000001, 0.29499999999999998, 0.085000000000000006, 0.2535, 0.10299999999999999, 0.057500000000000002, 0.085000000000000006, 7),
(125, 'I', 0.35999999999999999, 0.28000000000000003, 0.080000000000000002, 0.17549999999999999, 0.081000000000000003, 0.050500000000000003, 0.070000000000000007, 6),
(128, 'I', 0.38500000000000001, 0.28999999999999998, 0.085000000000000006, 0.2505, 0.112, 0.060999999999999999, 0.080000000000000002, 8),
(127, 'I', 0.375, 0.27500000000000002, 0.089999999999999997, 0.23799999999999999, 0.1075, 0.0545, 0.070000000000000007, 6),
(126, 'I', 0.27000000000000002, 0.19500000000000001, 0.059999999999999998, 0.072999999999999995, 0.028500000000000001, 0.0235, 0.029999999999999999, 5),
(129, 'M', 0.69999999999999996, 0.53500000000000003, 0.16, 1.7255, 0.63, 0.26350000000000001, 0.54000000000000004, 19),
(132, 'F', 0.44, 0.34999999999999998, 0.125, 0.40350000000000003, 0.17499999999999999, 0.063, 0.129, 9),
(131, 'M', 0.59499999999999997, 0.47999999999999998, 0.16500000000000001, 1.262, 0.48349999999999999, 0.28299999999999997, 0.40999999999999998, 17),
(130, 'M', 0.70999999999999996, 0.54000000000000004, 0.16500000000000001, 1.9590000000000001, 0.76649999999999996, 0.26100000000000001, 0.78000000000000003, 18),
(133, 'F', 0.32500000000000001, 0.26000000000000001, 0.089999999999999997, 0.1915, 0.085000000000000006, 0.035999999999999997, 0.062, 7),
(136, 'F', 0.42499999999999999, 0.33000000000000002, 0.115, 0.40600000000000003, 0.16350000000000001, 0.081000000000000003, 0.13550000000000001, 8),
(135, 'I', 0.26500000000000001, 0.20000000000000001, 0.065000000000000002, 0.097500000000000003, 0.040000000000000001, 0.020500000000000001, 0.028000000000000001, 7),
(134, 'I', 0.34999999999999998, 0.26000000000000001, 0.095000000000000001, 0.21099999999999999, 0.085999999999999993, 0.056000000000000001, 0.068000000000000005, 7),
(137, 'F', 0.30499999999999999, 0.23000000000000001, 0.080000000000000002, 0.156, 0.067500000000000004, 0.034500000000000003, 0.048000000000000001, 7),
(140, 'M', 0.375, 0.28499999999999998, 0.095000000000000001, 0.253, 0.096000000000000002, 0.057500000000000002, 0.092499999999999999, 9),
(139, 'F', 0.40500000000000003, 0.32500000000000001, 0.11, 0.35549999999999998, 0.151, 0.063, 0.11700000000000001, 9),
(138, 'M', 0.34499999999999997, 0.255, 0.089999999999999997, 0.20050000000000001, 0.094, 0.029499999999999998, 0.063, 9),
(141, 'F', 0.56499999999999995, 0.44500000000000001, 0.155, 0.82599999999999996, 0.34100000000000003, 0.20549999999999999, 0.2475, 10),
(144, 'M', 0.56000000000000005, 0.45500000000000002, 0.155, 0.79700000000000004, 0.34000000000000002, 0.19, 0.24249999999999999, 11),
(143, 'M', 0.65000000000000002, 0.52000000000000002, 0.19, 1.3445, 0.51900000000000002, 0.30599999999999999, 0.44650000000000001, 16),
(142, 'F', 0.55000000000000004, 0.45000000000000001, 0.14499999999999999, 0.74099999999999999, 0.29499999999999998, 0.14349999999999999, 0.26650000000000001, 10),
(145, 'M', 0.47499999999999998, 0.375, 0.13, 0.51749999999999996, 0.20749999999999999, 0.11650000000000001, 0.17000000000000001, 10),
(148, 'I', 0.28000000000000003, 0.20499999999999999, 0.080000000000000002, 0.127, 0.051999999999999998, 0.039, 0.042000000000000003, 9),
(147, 'M', 0.46000000000000002, 0.34999999999999998, 0.12, 0.51500000000000001, 0.224, 0.108, 0.1565, 10),
(146, 'F', 0.48999999999999999, 0.38, 0.125, 0.54900000000000004, 0.245, 0.1075, 0.17399999999999999, 10),
(149, 'I', 0.17499999999999999, 0.13, 0.055, 0.0315, 0.010500000000000001, 0.0064999999999999997, 0.012500000000000001, 5),
(152, 'F', 0.60499999999999998, 0.5, 0.185, 1.1185, 0.46899999999999997, 0.25850000000000001, 0.33500000000000002, 9),
(151, 'M', 0.58999999999999997, 0.47499999999999998, 0.14499999999999999, 1.0529999999999999, 0.4415, 0.26200000000000001, 0.32500000000000001, 15),
(150, 'I', 0.17000000000000001, 0.13, 0.095000000000000001, 0.029999999999999999, 0.012999999999999999, 0.0080000000000000002, 0.01, 4),
(153, 'F', 0.63500000000000001, 0.51500000000000001, 0.19, 1.3714999999999999, 0.50649999999999995, 0.30499999999999999, 0.45000000000000001, 10),
(156, 'M', 0.51500000000000001, 0.40500000000000003, 0.13, 0.72199999999999998, 0.32000000000000001, 0.13100000000000001, 0.20999999999999999, 10),
(155, 'F', 0.56499999999999995, 0.45000000000000001, 0.13500000000000001, 0.98850000000000005, 0.38700000000000001, 0.14949999999999999, 0.31, 12),
(154, 'F', 0.60499999999999998, 0.48499999999999999, 0.16, 1.0565, 0.37, 0.23549999999999999, 0.35499999999999998, 10),
(157, 'F', 0.57499999999999996, 0.46000000000000002, 0.19, 0.99399999999999999, 0.39200000000000002, 0.24249999999999999, 0.34000000000000002, 13),
(160, 'F', 0.57499999999999996, 0.46000000000000002, 0.16500000000000001, 1.1240000000000001, 0.29849999999999999, 0.17849999999999999, 0.44, 13),
(159, 'F', 0.57999999999999996, 0.45500000000000002, 0.17000000000000001, 0.90749999999999997, 0.374, 0.2135, 0.28499999999999998, 13),
(158, 'M', 0.64500000000000002, 0.48499999999999999, 0.215, 1.514, 0.54600000000000004, 0.26150000000000001, 0.63500000000000001, 16),
(161, 'M', 0.60499999999999998, 0.46500000000000002, 0.16500000000000001, 1.056, 0.42149999999999999, 0.2475, 0.34000000000000002, 13),
(164, 'F', 0.72499999999999998, 0.56000000000000005, 0.20999999999999999, 2.141, 0.65000000000000002, 0.39800000000000002, 1.0049999999999999, 18),
(163, 'M', 0.60999999999999999, 0.48499999999999999, 0.17499999999999999, 1.2444999999999999, 0.54400000000000004, 0.29699999999999999, 0.34499999999999997, 12),
(162, 'F', 0.60499999999999998, 0.48499999999999999, 0.16, 1.222, 0.53000000000000003, 0.25750000000000001, 0.28000000000000003, 13),
(165, 'F', 0.65000000000000002, 0.54500000000000004, 0.23000000000000001, 1.752, 0.5605, 0.28949999999999998, 0.81499999999999995, 16),
(168, 'F', 0.68000000000000005, 0.56999999999999995, 0.20499999999999999, 1.8420000000000001, 0.625, 0.40799999999999997, 0.65000000000000002, 20),
(167, 'F', 0.72499999999999998, 0.57499999999999996, 0.17499999999999999, 2.1240000000000001, 0.76500000000000001, 0.45150000000000001, 0.84999999999999998, 20),
(166, 'M', 0.72499999999999998, 0.56999999999999995, 0.19, 2.5499999999999998, 1.0705, 0.48299999999999998, 0.72499999999999998, 14),
(169, 'M', 0.70499999999999996, 0.56000000000000005, 0.22, 1.9810000000000001, 0.8175, 0.3085, 0.76000000000000001, 14),
(172, 'F', 0.53000000000000003, 0.39500000000000002, 0.14499999999999999, 0.77500000000000002, 0.308, 0.16900000000000001, 0.255, 7),
(171, 'M', 0.69499999999999995, 0.55000000000000004, 0.215, 1.9564999999999999, 0.71250000000000002, 0.54100000000000004, 0.58999999999999997, 14),
(170, 'F', 0.68000000000000005, 0.51500000000000001, 0.17499999999999999, 1.6185, 0.51249999999999996, 0.40899999999999997, 0.62, 12),
(173, 'M', 0.52500000000000002, 0.435, 0.155, 1.0649999999999999, 0.48599999999999999, 0.23300000000000001, 0.28499999999999998, 8),
(176, 'I', 0.35999999999999999, 0.26000000000000001, 0.089999999999999997, 0.17849999999999999, 0.064500000000000002, 0.036999999999999998, 0.074999999999999997, 7),
(175, 'I', 0.23499999999999999, 0.16, 0.040000000000000001, 0.048000000000000001, 0.018499999999999999, 0.017999999999999999, 0.014999999999999999, 5),
(174, 'F', 0.52000000000000002, 0.40500000000000003, 0.115, 0.77600000000000002, 0.32000000000000001, 0.1845, 0.22, 8),
(177, 'I', 0.315, 0.20999999999999999, 0.059999999999999998, 0.125, 0.059999999999999998, 0.037499999999999999, 0.035000000000000003, 5),
(180, 'M', 0.57999999999999996, 0.47499999999999998, 0.14999999999999999, 0.96999999999999997, 0.38500000000000001, 0.2165, 0.34999999999999998, 11),
(179, 'I', 0.22500000000000001, 0.16, 0.044999999999999998, 0.0465, 0.025000000000000001, 0.014999999999999999, 0.014999999999999999, 4),
(178, 'I', 0.315, 0.245, 0.085000000000000006, 0.14349999999999999, 0.052999999999999999, 0.047500000000000001, 0.050000000000000003, 8),
(181, 'M', 0.56999999999999995, 0.47999999999999998, 0.17999999999999999, 0.9395, 0.39900000000000002, 0.20000000000000001, 0.29499999999999998, 14),
(184, 'F', 0.62, 0.47499999999999998, 0.17499999999999999, 1.0165, 0.4355, 0.214, 0.32500000000000001, 10),
(183, 'F', 0.56000000000000005, 0.45000000000000001, 0.16, 1.0235000000000001, 0.42899999999999999, 0.26800000000000002, 0.29999999999999999, 10),
(182, 'M', 0.64000000000000001, 0.51000000000000001, 0.17499999999999999, 1.3680000000000001, 0.51500000000000001, 0.26600000000000001, 0.56999999999999995, 21),
(185, 'F', 0.64500000000000002, 0.51000000000000001, 0.20000000000000001, 1.5674999999999999, 0.621, 0.36699999999999999, 0.46000000000000002, 12),
(188, 'F', 0.63, 0.5, 0.185, 1.383, 0.54000000000000004, 0.33150000000000002, 0.38, 10),
(187, 'F', 0.63, 0.47999999999999998, 0.14999999999999999, 1.0525, 0.39200000000000002, 0.33600000000000002, 0.28499999999999998, 12),
(186, 'M', 0.62, 0.48999999999999999, 0.19, 1.218, 0.54549999999999998, 0.29649999999999999, 0.35499999999999998, 13),
(189, 'F', 0.63, 0.47999999999999998, 0.16, 1.1990000000000001, 0.52649999999999997, 0.33500000000000002, 0.315, 11),
(192, 'M', 0.60999999999999999, 0.48499999999999999, 0.17000000000000001, 1.0225, 0.41899999999999998, 0.24049999999999999, 0.35999999999999999, 12),
(191, 'M', 0.61499999999999999, 0.47999999999999998, 0.17999999999999999, 1.1595, 0.48449999999999999, 0.2165, 0.32500000000000001, 13),
(190, 'F', 0.58499999999999996, 0.46000000000000002, 0.17000000000000001, 0.9325, 0.36499999999999999, 0.27100000000000002, 0.28999999999999998, 9),
(193, 'M', 0.57999999999999996, 0.45000000000000001, 0.14999999999999999, 0.92700000000000005, 0.27600000000000002, 0.18149999999999999, 0.35999999999999999, 14),
(196, 'M', 0.5, 0.40500000000000003, 0.155, 0.77200000000000002, 0.34599999999999997, 0.1535, 0.245, 12),
(195, 'F', 0.51000000000000001, 0.40000000000000002, 0.14000000000000001, 0.8145, 0.45900000000000002, 0.19650000000000001, 0.19500000000000001, 10),
(194, 'I', 0.35499999999999998, 0.27500000000000002, 0.085000000000000006, 0.22, 0.091999999999999998, 0.059999999999999998, 0.14999999999999999, 8),
(197, 'F', 0.505, 0.40999999999999998, 0.14999999999999999, 0.64400000000000002, 0.28499999999999998, 0.14499999999999999, 0.20999999999999999, 11),
(200, 'M', 0.58499999999999996, 0.46000000000000002, 0.185, 0.92200000000000004, 0.36349999999999999, 0.21299999999999999, 0.28499999999999998, 10),
(199, 'M', 0.56000000000000005, 0.45000000000000001, 0.16, 0.92200000000000004, 0.432, 0.17799999999999999, 0.26000000000000001, 15),
(198, 'M', 0.64000000000000001, 0.5, 0.185, 1.3035000000000001, 0.44450000000000001, 0.26350000000000001, 0.46500000000000002, 16),
(201, 'F', 0.45000000000000001, 0.34499999999999997, 0.12, 0.41649999999999998, 0.16550000000000001, 0.095000000000000001, 0.13500000000000001, 9),
(204, 'F', 0.53000000000000003, 0.435, 0.17000000000000001, 0.8155, 0.29849999999999999, 0.155, 0.27500000000000002, 13),
(203, 'F', 0.5, 0.40000000000000002, 0.14499999999999999, 0.63, 0.23400000000000001, 0.14649999999999999, 0.23000000000000001, 12),
(202, 'M', 0.5, 0.40000000000000002, 0.16500000000000001, 0.82499999999999996, 0.254, 0.20499999999999999, 0.28499999999999998, 13),
(205, 'M', 0.41999999999999998, 0.33500000000000002, 0.115, 0.36899999999999999, 0.17100000000000001, 0.070999999999999994, 0.12, 8),
(208, 'I', 0.435, 0.34000000000000002, 0.11, 0.3795, 0.14949999999999999, 0.085000000000000006, 0.12, 8),
(207, 'I', 0.40000000000000002, 0.29999999999999999, 0.11, 0.315, 0.109, 0.067000000000000004, 0.12, 9),
(206, 'F', 0.44, 0.34000000000000002, 0.14000000000000001, 0.48199999999999998, 0.186, 0.1085, 0.16, 9),
(209, 'F', 0.52500000000000002, 0.41499999999999998, 0.17000000000000001, 0.83250000000000002, 0.27550000000000002, 0.16850000000000001, 0.31, 13),
(212, 'M', 0.33500000000000002, 0.25, 0.089999999999999997, 0.18099999999999999, 0.075499999999999998, 0.041500000000000002, 0.059999999999999998, 7),
(211, 'F', 0.48999999999999999, 0.36499999999999999, 0.14499999999999999, 0.63449999999999995, 0.19950000000000001, 0.16250000000000001, 0.22, 10),
(210, 'I', 0.37, 0.28000000000000003, 0.095000000000000001, 0.26550000000000001, 0.122, 0.051999999999999998, 0.080000000000000002, 7),
(213, 'F', 0.41499999999999998, 0.32500000000000001, 0.105, 0.38, 0.1595, 0.0785, 0.12, 12),
(216, 'M', 0.55000000000000004, 0.40500000000000003, 0.14000000000000001, 0.80249999999999999, 0.24399999999999999, 0.16350000000000001, 0.255, 10),
(215, 'F', 0.48499999999999999, 0.39500000000000002, 0.16, 0.66000000000000003, 0.2475, 0.128, 0.23499999999999999, 14),
(214, 'M', 0.5, 0.40500000000000003, 0.14000000000000001, 0.61550000000000005, 0.24099999999999999, 0.13550000000000001, 0.20499999999999999, 9),
(217, 'M', 0.45000000000000001, 0.34999999999999998, 0.13, 0.46000000000000002, 0.17399999999999999, 0.111, 0.13500000000000001, 8),
(220, 'F', 0.41499999999999998, 0.30499999999999999, 0.13, 0.32000000000000001, 0.1305, 0.075499999999999998, 0.105, 8),
(219, 'M', 0.46999999999999997, 0.35999999999999999, 0.13500000000000001, 0.501, 0.16650000000000001, 0.115, 0.16500000000000001, 10),
(218, 'I', 0.40500000000000003, 0.29999999999999999, 0.12, 0.32400000000000001, 0.1265, 0.070000000000000007, 0.11, 7),
(221, 'F', 0.44500000000000001, 0.32500000000000001, 0.125, 0.45500000000000002, 0.17849999999999999, 0.1125, 0.14000000000000001, 9),
(224, 'F', 0.44500000000000001, 0.35499999999999998, 0.14999999999999999, 0.48499999999999999, 0.18099999999999999, 0.125, 0.155, 11),
(223, 'F', 0.48999999999999999, 0.375, 0.14999999999999999, 0.57550000000000001, 0.22, 0.14399999999999999, 0.19, 9),
(222, 'F', 0.46999999999999997, 0.34999999999999998, 0.14499999999999999, 0.51749999999999996, 0.187, 0.1235, 0.17999999999999999, 11),
(225, 'I', 0.42499999999999999, 0.38, 0.105, 0.32650000000000001, 0.1285, 0.0785, 0.10000000000000001, 10),
(228, 'I', 0.36499999999999999, 0.27000000000000002, 0.085000000000000006, 0.20499999999999999, 0.078, 0.048500000000000001, 0.070000000000000007, 7),
(227, 'F', 0.39000000000000001, 0.28999999999999998, 0.125, 0.30549999999999999, 0.121, 0.082000000000000003, 0.089999999999999997, 7),
(226, 'F', 0.5, 0.37, 0.13500000000000001, 0.45000000000000001, 0.17150000000000001, 0.1055, 0.155, 9),
(229, 'F', 0.57999999999999996, 0.46500000000000002, 0.16500000000000001, 1.1014999999999999, 0.40400000000000003, 0.20949999999999999, 0.34999999999999998, 11),
(232, 'M', 0.56499999999999995, 0.44, 0.17499999999999999, 0.90249999999999997, 0.31, 0.193, 0.32500000000000001, 14),
(231, 'M', 0.55500000000000005, 0.44500000000000001, 0.13500000000000001, 0.83599999999999997, 0.33600000000000002, 0.16250000000000001, 0.27500000000000002, 13),
(230, 'F', 0.53000000000000003, 0.41499999999999998, 0.16, 0.78300000000000003, 0.29349999999999998, 0.158, 0.245, 15),
(233, 'M', 0.625, 0.505, 0.215, 1.4455, 0.496, 0.28699999999999998, 0.435, 22),
(236, 'I', 0.29499999999999998, 0.22500000000000001, 0.080000000000000002, 0.124, 0.048500000000000001, 0.032000000000000001, 0.040000000000000001, 9),
(235, 'I', 0.44, 0.34999999999999998, 0.13500000000000001, 0.435, 0.18149999999999999, 0.083000000000000004, 0.125, 12),
(234, 'I', 0.27500000000000002, 0.215, 0.074999999999999997, 0.11550000000000001, 0.048500000000000001, 0.029000000000000001, 0.035000000000000003, 7),
(237, 'I', 0.074999999999999997, 0.055, 0.01, 0.002, 0.001, 0.00050000000000000001, 0.0015, 1),
(240, 'I', 0.16, 0.12, 0.035000000000000003, 0.021000000000000001, 0.0074999999999999997, 0.0044999999999999997, 0.0050000000000000001, 5),
(239, 'I', 0.11, 0.089999999999999997, 0.029999999999999999, 0.0080000000000000002, 0.0025000000000000001, 0.002, 0.0030000000000000001, 3),
(238, 'I', 0.13, 0.10000000000000001, 0.029999999999999999, 0.012999999999999999, 0.0044999999999999997, 0.0030000000000000001, 0.0040000000000000001, 3),
(241, 'M', 0.56499999999999995, 0.42499999999999999, 0.16, 0.9425, 0.34949999999999998, 0.2185, 0.27500000000000002, 17),
(244, 'I', 0.29999999999999999, 0.23000000000000001, 0.080000000000000002, 0.1275, 0.043499999999999997, 0.026499999999999999, 0.040000000000000001, 8),
(243, 'I', 0.23000000000000001, 0.17499999999999999, 0.065000000000000002, 0.064500000000000002, 0.025999999999999999, 0.010500000000000001, 0.02, 5),
(242, 'I', 0.27000000000000002, 0.20000000000000001, 0.070000000000000007, 0.10000000000000001, 0.034000000000000002, 0.024500000000000001, 0.035000000000000003, 5),
(245, 'I', 0.33000000000000002, 0.255, 0.085000000000000006, 0.16550000000000001, 0.063, 0.039, 0.059999999999999998, 8),
(248, 'I', 0.35999999999999999, 0.27500000000000002, 0.085000000000000006, 0.19750000000000001, 0.074499999999999997, 0.041500000000000002, 0.070000000000000007, 9),
(247, 'I', 0.32000000000000001, 0.245, 0.080000000000000002, 0.1585, 0.063500000000000001, 0.032500000000000001, 0.050000000000000003, 13),
(246, 'I', 0.34999999999999998, 0.26000000000000001, 0.085000000000000006, 0.17399999999999999, 0.070499999999999993, 0.034500000000000003, 0.059999999999999998, 10),
(249, 'I', 0.30499999999999999, 0.245, 0.074999999999999997, 0.156, 0.067500000000000004, 0.037999999999999999, 0.044999999999999998, 7),
(252, 'M', 0.58999999999999997, 0.46999999999999997, 0.17999999999999999, 1.1234999999999999, 0.42049999999999998, 0.28050000000000003, 0.35999999999999999, 13),
(251, 'I', 0.33000000000000002, 0.25, 0.105, 0.17150000000000001, 0.065500000000000003, 0.035000000000000003, 0.059999999999999998, 7),
(250, 'I', 0.34499999999999997, 0.27000000000000002, 0.11, 0.2135, 0.082000000000000003, 0.0545, 0.070000000000000007, 7),
(254, 'F', 0.57499999999999996, 0.46000000000000002, 0.185, 1.0940000000000001, 0.44850000000000001, 0.217, 0.34499999999999997, 15),
(255, 'M', 0.59999999999999998, 0.495, 0.16500000000000001, 1.2415, 0.48499999999999999, 0.27750000000000002, 0.34000000000000002, 15),
(256, 'M', 0.56000000000000005, 0.45000000000000001, 0.17499999999999999, 1.0109999999999999, 0.38350000000000001, 0.20649999999999999, 0.37, 15),
(253, 'F', 0.59499999999999997, 0.45500000000000002, 0.155, 1.0605, 0.51349999999999996, 0.2165, 0.29999999999999999, 12),
(258, 'M', 0.54500000000000004, 0.46000000000000002, 0.16, 0.89749999999999996, 0.34100000000000003, 0.16550000000000001, 0.34499999999999997, 10),
(259, 'F', 0.63500000000000001, 0.505, 0.17000000000000001, 1.415, 0.60499999999999998, 0.29699999999999999, 0.36499999999999999, 15),
(260, 'F', 0.58999999999999997, 0.47499999999999998, 0.16, 1.1014999999999999, 0.47749999999999998, 0.2555, 0.29499999999999998, 13),
(257, 'M', 0.56000000000000005, 0.45000000000000001, 0.185, 1.0700000000000001, 0.3805, 0.17499999999999999, 0.40999999999999998, 19),
(262, 'F', 0.56999999999999995, 0.44, 0.125, 0.86499999999999999, 0.36749999999999999, 0.17249999999999999, 0.27000000000000002, 12),
(263, 'M', 0.53000000000000003, 0.41999999999999998, 0.16500000000000001, 0.89449999999999996, 0.31900000000000001, 0.23899999999999999, 0.245, 11),
(264, 'I', 0.245, 0.19500000000000001, 0.059999999999999998, 0.095000000000000001, 0.044499999999999998, 0.024500000000000001, 0.025999999999999999, 4),
(261, 'F', 0.54000000000000004, 0.47499999999999998, 0.155, 0.92800000000000005, 0.39400000000000002, 0.19400000000000001, 0.26000000000000001, 11),
(266, 'F', 0.46000000000000002, 0.38, 0.13, 0.63900000000000001, 0.29999999999999999, 0.1525, 0.16, 11),
(267, 'M', 0.52000000000000002, 0.45000000000000001, 0.14999999999999999, 0.89500000000000002, 0.36149999999999999, 0.186, 0.23499999999999999, 14),
(268, 'M', 0.34999999999999998, 0.27500000000000002, 0.11, 0.29249999999999998, 0.1225, 0.063500000000000001, 0.090499999999999997, 8),
(265, 'M', 0.27000000000000002, 0.20000000000000001, 0.080000000000000002, 0.1205, 0.0465, 0.028000000000000001, 0.040000000000000001, 6),
(270, 'F', 0.45000000000000001, 0.35999999999999999, 0.125, 0.4995, 0.20349999999999999, 0.10000000000000001, 0.17000000000000001, 13),
(271, 'F', 0.64000000000000001, 0.52500000000000002, 0.215, 1.7789999999999999, 0.45350000000000001, 0.28549999999999998, 0.55000000000000004, 22),
(272, 'M', 0.58999999999999997, 0.5, 0.20000000000000001, 1.1870000000000001, 0.41199999999999998, 0.27050000000000002, 0.37, 16),
(269, 'M', 0.46999999999999997, 0.39000000000000001, 0.14999999999999999, 0.63549999999999995, 0.2185, 0.088499999999999995, 0.255, 9),
(274, 'M', 0.63, 0.505, 0.22500000000000001, 1.5249999999999999, 0.56000000000000005, 0.33350000000000002, 0.45000000000000001, 15),
(275, 'M', 0.63, 0.51500000000000001, 0.155, 1.2589999999999999, 0.41049999999999998, 0.19700000000000001, 0.40999999999999998, 13),
(276, 'M', 0.65500000000000003, 0.54000000000000004, 0.215, 1.8440000000000001, 0.74250000000000005, 0.32700000000000001, 0.58499999999999996, 22),
(273, 'M', 0.62, 0.48499999999999999, 0.20499999999999999, 1.2190000000000001, 0.38750000000000001, 0.2505, 0.38500000000000001, 14),
(278, 'M', 0.60999999999999999, 0.5, 0.23999999999999999, 1.6419999999999999, 0.53200000000000003, 0.33450000000000002, 0.68999999999999995, 18),
(279, 'M', 0.63500000000000001, 0.52500000000000002, 0.20499999999999999, 1.484, 0.55000000000000004, 0.3115, 0.42999999999999999, 20),
(280, 'F', 0.51500000000000001, 0.42499999999999999, 0.13500000000000001, 0.71199999999999997, 0.26650000000000001, 0.1605, 0.25, 11),
(277, 'F', 0.66000000000000003, 0.53000000000000003, 0.185, 1.3485, 0.49299999999999999, 0.245, 0.48999999999999999, 12),
(282, 'I', 0.35999999999999999, 0.28499999999999998, 0.105, 0.24149999999999999, 0.091499999999999998, 0.057000000000000002, 0.074999999999999997, 7),
(283, 'F', 0.45500000000000002, 0.35499999999999998, 0.12, 0.44950000000000001, 0.17699999999999999, 0.104, 0.14999999999999999, 9),
(284, 'M', 0.48499999999999999, 0.39500000000000002, 0.14000000000000001, 0.62949999999999995, 0.22850000000000001, 0.127, 0.22500000000000001, 14),
(281, 'F', 0.53500000000000003, 0.41499999999999998, 0.185, 0.84150000000000003, 0.314, 0.1585, 0.29999999999999999, 15),
(286, 'F', 0.53500000000000003, 0.41499999999999998, 0.17000000000000001, 0.879, 0.29499999999999998, 0.19650000000000001, 0.28499999999999998, 10),
(287, 'M', 0.53000000000000003, 0.435, 0.155, 0.69899999999999995, 0.28799999999999998, 0.1595, 0.20499999999999999, 10),
(288, 'F', 0.495, 0.40000000000000002, 0.155, 0.64449999999999996, 0.24199999999999999, 0.13250000000000001, 0.20499999999999999, 17),
(285, 'M', 0.51500000000000001, 0.38, 0.17499999999999999, 0.95650000000000002, 0.32500000000000001, 0.158, 0.31, 14),
(290, 'F', 0.53500000000000003, 0.435, 0.16, 0.8105, 0.3155, 0.17949999999999999, 0.23999999999999999, 10),
(291, 'M', 0.54000000000000004, 0.435, 0.17999999999999999, 0.996, 0.38350000000000001, 0.22600000000000001, 0.32500000000000001, 17),
(292, 'F', 0.56499999999999995, 0.505, 0.20999999999999999, 1.2765, 0.501, 0.27900000000000003, 0.35499999999999998, 12),
(289, 'M', 0.44, 0.35499999999999998, 0.125, 0.47749999999999998, 0.13200000000000001, 0.081500000000000003, 0.19, 9),
(294, 'F', 0.56499999999999995, 0.45500000000000002, 0.17499999999999999, 1.0129999999999999, 0.34200000000000003, 0.20699999999999999, 0.34999999999999998, 19),
(295, 'M', 0.59999999999999998, 0.495, 0.19500000000000001, 1.0575000000000001, 0.38400000000000001, 0.19, 0.375, 26),
(296, 'I', 0.29499999999999998, 0.215, 0.085000000000000006, 0.128, 0.049000000000000002, 0.034000000000000002, 0.040000000000000001, 6),
(293, 'M', 0.60999999999999999, 0.47499999999999998, 0.16500000000000001, 1.1160000000000001, 0.42799999999999999, 0.2205, 0.315, 15),
(298, 'I', 0.28000000000000003, 0.20999999999999999, 0.085000000000000006, 0.1065, 0.039, 0.029499999999999998, 0.029999999999999999, 4),
(299, 'M', 0.48999999999999999, 0.39500000000000002, 0.14000000000000001, 0.54900000000000004, 0.2215, 0.1275, 0.14999999999999999, 11),
(300, 'M', 0.37, 0.28000000000000003, 0.105, 0.23400000000000001, 0.090499999999999997, 0.058500000000000003, 0.074999999999999997, 9),
(297, 'I', 0.27500000000000002, 0.20499999999999999, 0.074999999999999997, 0.1105, 0.044999999999999998, 0.028500000000000001, 0.035000000000000003, 6),
(302, 'F', 0.54000000000000004, 0.435, 0.17499999999999999, 0.89200000000000002, 0.32200000000000001, 0.17399999999999999, 0.33500000000000002, 13),
(303, 'M', 0.37, 0.28000000000000003, 0.10000000000000001, 0.252, 0.1065, 0.059499999999999997, 0.073999999999999996, 8),
(304, 'M', 0.35999999999999999, 0.27000000000000002, 0.10000000000000001, 0.217, 0.088499999999999995, 0.049500000000000002, 0.071499999999999994, 6),
(301, 'F', 0.40500000000000003, 0.30499999999999999, 0.095000000000000001, 0.34849999999999998, 0.14549999999999999, 0.089499999999999996, 0.10000000000000001, 9),
(306, 'I', 0.20000000000000001, 0.14499999999999999, 0.059999999999999998, 0.036999999999999998, 0.012500000000000001, 0.0094999999999999998, 0.010999999999999999, 4),
(307, 'I', 0.16500000000000001, 0.12, 0.029999999999999999, 0.021499999999999998, 0.0070000000000000001, 0.0050000000000000001, 0.0050000000000000001, 3),
(308, 'M', 0.64500000000000002, 0.51500000000000001, 0.23999999999999999, 1.5415000000000001, 0.47099999999999997, 0.36899999999999999, 0.53500000000000003, 13),
(305, 'F', 0.46999999999999997, 0.35999999999999999, 0.13, 0.47199999999999998, 0.182, 0.114, 0.14999999999999999, 10),
(310, 'M', 0.56999999999999995, 0.435, 0.14499999999999999, 0.90549999999999997, 0.39250000000000002, 0.23549999999999999, 0.27500000000000002, 10),
(311, 'F', 0.63, 0.48499999999999999, 0.19, 1.2435, 0.46350000000000002, 0.30549999999999999, 0.39000000000000001, 21),
(312, 'M', 0.56000000000000005, 0.44, 0.14000000000000001, 0.97099999999999997, 0.443, 0.20449999999999999, 0.26500000000000001, 14),
(309, 'M', 0.55000000000000004, 0.40999999999999998, 0.125, 0.76049999999999995, 0.2505, 0.16350000000000001, 0.19500000000000001, 14),
(314, 'F', 0.62, 0.46999999999999997, 0.20000000000000001, 1.2255, 0.38100000000000001, 0.27000000000000002, 0.435, 23),
(315, 'M', 0.63, 0.48499999999999999, 0.17499999999999999, 1.3, 0.4335, 0.29449999999999998, 0.46000000000000002, 23),
(316, 'I', 0.45000000000000001, 0.35499999999999998, 0.11, 0.45850000000000002, 0.19400000000000001, 0.067000000000000004, 0.14000000000000001, 8),
(313, 'M', 0.59499999999999997, 0.45500000000000002, 0.19500000000000001, 1.3305, 0.45950000000000002, 0.32350000000000001, 0.34499999999999997, 19),
(318, 'M', 0.45000000000000001, 0.34999999999999998, 0.10000000000000001, 0.36749999999999999, 0.14649999999999999, 0.10150000000000001, 0.12, 10),
(319, 'F', 0.57999999999999996, 0.45500000000000002, 0.155, 0.83650000000000002, 0.315, 0.13850000000000001, 0.32000000000000001, 18),
(320, 'I', 0.33000000000000002, 0.255, 0.095000000000000001, 0.17199999999999999, 0.066000000000000003, 0.025499999999999998, 0.059999999999999998, 6),
(317, 'F', 0.63500000000000001, 0.53500000000000003, 0.19, 1.242, 0.57599999999999996, 0.2475, 0.39000000000000001, 14),
(322, 'I', 0.19, 0.14499999999999999, 0.040000000000000001, 0.037999999999999999, 0.016500000000000001, 0.0064999999999999997, 0.014999999999999999, 4),
(323, 'M', 0.38500000000000001, 0.31, 0.10000000000000001, 0.28449999999999998, 0.1065, 0.074999999999999997, 0.10000000000000001, 11),
(324, 'I', 0.26500000000000001, 0.20499999999999999, 0.070000000000000007, 0.1055, 0.039, 0.041000000000000002, 0.035000000000000003, 5),
(321, 'I', 0.26500000000000001, 0.20999999999999999, 0.059999999999999998, 0.096500000000000002, 0.042500000000000003, 0.021999999999999999, 0.029999999999999999, 5),
(326, 'I', 0.35499999999999998, 0.27500000000000002, 0.089999999999999997, 0.251, 0.097000000000000003, 0.052999999999999999, 0.080000000000000002, 7),
(327, 'I', 0.32000000000000001, 0.255, 0.10000000000000001, 0.17549999999999999, 0.072999999999999995, 0.041500000000000002, 0.065000000000000002, 7),
(328, 'M', 0.51000000000000001, 0.40000000000000002, 0.13, 0.64349999999999996, 0.27000000000000002, 0.16650000000000001, 0.20499999999999999, 12),
(325, 'M', 0.33500000000000002, 0.26500000000000001, 0.105, 0.222, 0.0935, 0.056000000000000001, 0.074999999999999997, 7),
(330, 'I', 0.35999999999999999, 0.28000000000000003, 0.089999999999999997, 0.22550000000000001, 0.088499999999999995, 0.040000000000000001, 0.089999999999999997, 8),
(331, 'M', 0.5, 0.38, 0.155, 0.59550000000000003, 0.2135, 0.161, 0.20000000000000001, 12),
(332, 'F', 0.40000000000000002, 0.32500000000000001, 0.12, 0.31850000000000001, 0.13400000000000001, 0.056500000000000002, 0.095000000000000001, 8),
(329, 'M', 0.35999999999999999, 0.29499999999999998, 0.105, 0.24099999999999999, 0.086499999999999994, 0.052999999999999999, 0.095000000000000001, 8),
(334, 'I', 0.23499999999999999, 0.17499999999999999, 0.040000000000000001, 0.070499999999999993, 0.033500000000000002, 0.014999999999999999, 0.02, 5),
(335, 'F', 0.73999999999999999, 0.59999999999999998, 0.19500000000000001, 1.974, 0.59799999999999998, 0.40849999999999997, 0.70999999999999996, 16),
(336, 'M', 0.62, 0.46500000000000002, 0.19, 1.3414999999999999, 0.57050000000000001, 0.3175, 0.35499999999999998, 11),
(333, 'I', 0.29999999999999999, 0.22, 0.080000000000000002, 0.121, 0.047500000000000001, 0.042000000000000003, 0.035000000000000003, 5),
(338, 'M', 0.58999999999999997, 0.45000000000000001, 0.185, 1.2829999999999999, 0.47299999999999998, 0.27600000000000002, 0.42499999999999999, 16),
(339, 'M', 0.62, 0.47499999999999998, 0.185, 1.325, 0.60450000000000004, 0.32500000000000001, 0.33000000000000002, 13),
(340, 'F', 0.56499999999999995, 0.45000000000000001, 0.19500000000000001, 1.0035000000000001, 0.40600000000000003, 0.2505, 0.28499999999999998, 15),
(337, 'M', 0.59999999999999998, 0.47499999999999998, 0.19, 1.0874999999999999, 0.40300000000000002, 0.26550000000000001, 0.32500000000000001, 14),
(342, 'F', 0.62, 0.51000000000000001, 0.20499999999999999, 1.3474999999999999, 0.47749999999999998, 0.25650000000000001, 0.47999999999999998, 14),
(343, 'M', 0.62, 0.46500000000000002, 0.185, 1.274, 0.57899999999999996, 0.30649999999999999, 0.32000000000000001, 12),
(344, 'F', 0.505, 0.375, 0.17999999999999999, 0.56799999999999995, 0.23250000000000001, 0.14949999999999999, 0.17000000000000001, 12),
(341, 'M', 0.57499999999999996, 0.45500000000000002, 0.14499999999999999, 1.165, 0.58099999999999996, 0.22750000000000001, 0.29999999999999999, 14),
(346, 'M', 0.48999999999999999, 0.39000000000000001, 0.14000000000000001, 0.70699999999999996, 0.27950000000000003, 0.2185, 0.17999999999999999, 13),
(347, 'F', 0.52500000000000002, 0.41999999999999998, 0.16, 0.75600000000000001, 0.27450000000000002, 0.17299999999999999, 0.27500000000000002, 9),
(348, 'I', 0.34000000000000002, 0.26000000000000001, 0.080000000000000002, 0.20000000000000001, 0.080000000000000002, 0.055500000000000001, 0.055, 6),
(345, 'F', 0.46000000000000002, 0.42499999999999999, 0.155, 0.746, 0.30049999999999999, 0.152, 0.23999999999999999, 8),
(350, 'M', 0.60999999999999999, 0.47999999999999998, 0.14999999999999999, 1.2, 0.56000000000000005, 0.2455, 0.28000000000000003, 14),
(351, 'F', 0.60999999999999999, 0.495, 0.185, 1.153, 0.53600000000000003, 0.29049999999999998, 0.245, 8),
(352, 'F', 0.58499999999999996, 0.45000000000000001, 0.17000000000000001, 0.86850000000000005, 0.33250000000000002, 0.16350000000000001, 0.27000000000000002, 22),
(349, 'I', 0.375, 0.30499999999999999, 0.115, 0.27150000000000002, 0.091999999999999998, 0.073999999999999996, 0.089999999999999997, 8),
(354, 'M', 0.57999999999999996, 0.45500000000000002, 0.17000000000000001, 0.93000000000000005, 0.40799999999999997, 0.25900000000000001, 0.22, 9),
(355, 'M', 0.63500000000000001, 0.51500000000000001, 0.17000000000000001, 1.2749999999999999, 0.50900000000000001, 0.28599999999999998, 0.34000000000000002, 16),
(356, 'M', 0.69999999999999996, 0.57999999999999996, 0.20499999999999999, 2.1299999999999999, 0.74150000000000005, 0.48999999999999999, 0.57999999999999996, 20),
(353, 'M', 0.56999999999999995, 0.46000000000000002, 0.14000000000000001, 0.95350000000000001, 0.44650000000000001, 0.20649999999999999, 0.245, 12),
(358, 'F', 0.64500000000000002, 0.52500000000000002, 0.19, 1.8085, 0.70350000000000001, 0.38850000000000001, 0.39500000000000002, 18),
(359, 'M', 0.745, 0.58499999999999996, 0.215, 2.4990000000000001, 0.92649999999999999, 0.47199999999999998, 0.69999999999999996, 17),
(360, 'F', 0.68500000000000005, 0.54500000000000004, 0.17999999999999999, 1.768, 0.74950000000000006, 0.39200000000000002, 0.48499999999999999, 16),
(357, 'M', 0.67500000000000004, 0.52500000000000002, 0.185, 1.587, 0.69350000000000001, 0.33600000000000002, 0.39500000000000002, 13),
(362, 'F', 0.58999999999999997, 0.46500000000000002, 0.14999999999999999, 0.997, 0.39200000000000002, 0.246, 0.34000000000000002, 12),
(363, 'F', 0.65000000000000002, 0.52500000000000002, 0.17499999999999999, 1.4225000000000001, 0.60999999999999999, 0.29949999999999999, 0.44500000000000001, 20),
(364, 'F', 0.59999999999999998, 0.47999999999999998, 0.14999999999999999, 1.0289999999999999, 0.40849999999999997, 0.27050000000000002, 0.29499999999999998, 16),
(361, 'M', 0.60499999999999998, 0.48999999999999999, 0.17999999999999999, 1.2270000000000001, 0.47999999999999998, 0.28699999999999998, 0.34999999999999998, 18),
(366, 'M', 0.63, 0.51500000000000001, 0.16, 1.016, 0.42149999999999999, 0.24399999999999999, 0.35499999999999998, 19),
(367, 'M', 0.57999999999999996, 0.46500000000000002, 0.14499999999999999, 0.88700000000000001, 0.4405, 0.16550000000000001, 0.26500000000000001, 11),
(368, 'F', 0.57999999999999996, 0.45500000000000002, 0.12, 1.0734999999999999, 0.47899999999999998, 0.27350000000000002, 0.26500000000000001, 10),
(365, 'F', 0.62, 0.5, 0.17499999999999999, 1.1859999999999999, 0.4985, 0.30149999999999999, 0.34999999999999998, 12),
(370, 'F', 0.68999999999999995, 0.56000000000000005, 0.215, 1.7190000000000001, 0.68000000000000005, 0.29899999999999999, 0.46999999999999997, 17),
(371, 'F', 0.65000000000000002, 0.54500000000000004, 0.16500000000000001, 1.5660000000000001, 0.66449999999999998, 0.34549999999999997, 0.41499999999999998, 16),
(372, 'F', 0.66000000000000003, 0.56499999999999995, 0.19500000000000001, 1.7605, 0.69199999999999995, 0.32650000000000001, 0.5, 16),
(369, 'M', 0.63, 0.48999999999999999, 0.17999999999999999, 1.1299999999999999, 0.45800000000000002, 0.27650000000000002, 0.315, 12),
(374, 'F', 0.69999999999999996, 0.57499999999999996, 0.17000000000000001, 1.3100000000000001, 0.50949999999999995, 0.314, 0.41999999999999998, 14),
(375, 'M', 0.68500000000000005, 0.52000000000000002, 0.14999999999999999, 1.343, 0.46350000000000002, 0.29199999999999998, 0.40000000000000002, 13),
(376, 'F', 0.67500000000000004, 0.54500000000000004, 0.19500000000000001, 1.7344999999999999, 0.6845, 0.3695, 0.60499999999999998, 20),
(373, 'F', 0.68000000000000005, 0.57999999999999996, 0.20000000000000001, 1.7869999999999999, 0.58499999999999996, 0.45300000000000001, 0.59999999999999998, 19),
(378, 'F', 0.58499999999999996, 0.45000000000000001, 0.16, 1.077, 0.4995, 0.28749999999999998, 0.25, 10),
(379, 'M', 0.56499999999999995, 0.46500000000000002, 0.17499999999999999, 0.995, 0.38950000000000001, 0.183, 0.37, 15),
(380, 'F', 0.60999999999999999, 0.495, 0.185, 1.1085, 0.3705, 0.3135, 0.33000000000000002, 12),
(377, 'M', 0.63, 0.48999999999999999, 0.19, 1.1775, 0.49349999999999999, 0.33650000000000002, 0.28499999999999998, 11),
(382, 'M', 0.53500000000000003, 0.41999999999999998, 0.14499999999999999, 0.79100000000000004, 0.33000000000000002, 0.189, 0.25, 10),
(383, 'M', 0.48499999999999999, 0.40000000000000002, 0.13500000000000001, 0.66300000000000003, 0.313, 0.13700000000000001, 0.20000000000000001, 10),
(384, 'M', 0.46999999999999997, 0.375, 0.12, 0.55649999999999999, 0.22600000000000001, 0.122, 0.19500000000000001, 12),
(381, 'M', 0.60499999999999998, 0.46999999999999997, 0.17999999999999999, 1.1405000000000001, 0.3755, 0.28050000000000003, 0.38500000000000001, 15),
(386, 'F', 0.45500000000000002, 0.37, 0.105, 0.49249999999999999, 0.216, 0.1245, 0.13500000000000001, 9),
(387, 'M', 0.54000000000000004, 0.41999999999999998, 0.155, 0.73850000000000005, 0.35149999999999998, 0.152, 0.215, 12),
(388, 'M', 0.46000000000000002, 0.38, 0.13500000000000001, 0.48199999999999998, 0.20699999999999999, 0.1225, 0.14499999999999999, 10),
(385, 'M', 0.54500000000000004, 0.42499999999999999, 0.13500000000000001, 0.84450000000000003, 0.373, 0.20999999999999999, 0.23499999999999999, 10),
(390, 'I', 0.46500000000000002, 0.375, 0.12, 0.47099999999999997, 0.222, 0.11899999999999999, 0.14000000000000001, 9),
(391, 'I', 0.41499999999999998, 0.32500000000000001, 0.10000000000000001, 0.32150000000000001, 0.1535, 0.059499999999999997, 0.105, 10),
(392, 'M', 0.47499999999999998, 0.375, 0.125, 0.59299999999999997, 0.27700000000000002, 0.115, 0.17999999999999999, 10),
(389, 'M', 0.48999999999999999, 0.41999999999999998, 0.125, 0.60899999999999999, 0.23899999999999999, 0.14349999999999999, 0.22, 14),
(394, 'I', 0.36499999999999999, 0.29499999999999998, 0.095000000000000001, 0.25, 0.1075, 0.0545, 0.080000000000000002, 9),
(395, 'I', 0.34499999999999997, 0.27500000000000002, 0.095000000000000001, 0.19950000000000001, 0.075499999999999998, 0.053499999999999999, 0.070000000000000007, 6),
(396, 'I', 0.39000000000000001, 0.31, 0.10000000000000001, 0.30199999999999999, 0.11600000000000001, 0.064000000000000001, 0.115, 11),
(393, 'F', 0.46999999999999997, 0.375, 0.125, 0.5615, 0.252, 0.13700000000000001, 0.17999999999999999, 10),
(398, 'M', 0.46999999999999997, 0.38, 0.14499999999999999, 0.58650000000000002, 0.23849999999999999, 0.14399999999999999, 0.185, 8),
(399, 'M', 0.53500000000000003, 0.44, 0.14999999999999999, 0.67649999999999999, 0.25600000000000001, 0.13900000000000001, 0.26000000000000001, 12),
(400, 'M', 0.58499999999999996, 0.45500000000000002, 0.14999999999999999, 0.98699999999999999, 0.4355, 0.20749999999999999, 0.31, 11),
(397, 'F', 0.5, 0.39500000000000002, 0.14000000000000001, 0.71550000000000002, 0.3165, 0.17599999999999999, 0.23999999999999999, 10),
(402, 'M', 0.51500000000000001, 0.45500000000000002, 0.13500000000000001, 0.72250000000000003, 0.29499999999999998, 0.16250000000000001, 0.23499999999999999, 9),
(403, 'F', 0.435, 0.32500000000000001, 0.11, 0.4335, 0.17799999999999999, 0.098500000000000004, 0.155, 7),
(404, 'F', 0.51500000000000001, 0.41499999999999998, 0.14000000000000001, 0.69350000000000001, 0.3115, 0.152, 0.20000000000000001, 10),
(401, 'F', 0.48499999999999999, 0.36499999999999999, 0.12, 0.58850000000000002, 0.27000000000000002, 0.13100000000000001, 0.17499999999999999, 9),
(406, 'F', 0.52500000000000002, 0.44, 0.14999999999999999, 0.84250000000000003, 0.36849999999999999, 0.19850000000000001, 0.23999999999999999, 12),
(407, 'M', 0.45000000000000001, 0.35499999999999998, 0.115, 0.47899999999999998, 0.21249999999999999, 0.1045, 0.14999999999999999, 8),
(408, 'M', 0.58999999999999997, 0.48499999999999999, 0.12, 0.91100000000000003, 0.39000000000000001, 0.182, 0.28999999999999998, 16),
(405, 'I', 0.44, 0.34499999999999997, 0.12, 0.36499999999999999, 0.16550000000000001, 0.083000000000000004, 0.11, 7),
(410, 'M', 0.56999999999999995, 0.44, 0.095000000000000001, 0.82699999999999996, 0.33950000000000002, 0.2215, 0.23499999999999999, 8),
(411, 'M', 0.58999999999999997, 0.5, 0.16500000000000001, 1.1045, 0.45650000000000002, 0.24249999999999999, 0.34000000000000002, 15),
(412, 'M', 0.58499999999999996, 0.47499999999999998, 0.12, 0.94499999999999995, 0.40999999999999998, 0.21149999999999999, 0.28000000000000003, 14),
(409, 'M', 0.55500000000000005, 0.45000000000000001, 0.14499999999999999, 0.91500000000000004, 0.40000000000000002, 0.246, 0.28499999999999998, 11),
(414, 'M', 0.54500000000000004, 0.44, 0.12, 0.85650000000000004, 0.34749999999999998, 0.17150000000000001, 0.23999999999999999, 12),
(415, 'F', 0.60499999999999998, 0.495, 0.17000000000000001, 1.2384999999999999, 0.52800000000000002, 0.2465, 0.39000000000000001, 14),
(416, 'F', 0.62, 0.46999999999999997, 0.14000000000000001, 1.0325, 0.36049999999999999, 0.224, 0.35999999999999999, 15),
(413, 'F', 0.57999999999999996, 0.46000000000000002, 0.12, 0.99350000000000005, 0.46250000000000002, 0.23849999999999999, 0.28000000000000003, 11),
(418, 'M', 0.63, 0.51500000000000001, 0.16500000000000001, 1.3520000000000001, 0.48799999999999999, 0.34899999999999998, 0.45000000000000001, 20),
(419, 'F', 0.63, 0.5, 0.155, 1.0049999999999999, 0.36699999999999999, 0.19900000000000001, 0.35999999999999999, 16),
(420, 'M', 0.54500000000000004, 0.40999999999999998, 0.14000000000000001, 0.625, 0.223, 0.16, 0.23499999999999999, 13),
(417, 'F', 0.63, 0.5, 0.17000000000000001, 1.3134999999999999, 0.5595, 0.26700000000000002, 0.40000000000000002, 20),
(422, 'I', 0.48999999999999999, 0.38, 0.12, 0.52900000000000003, 0.2165, 0.13900000000000001, 0.155, 11),
(423, 'F', 0.48999999999999999, 0.39000000000000001, 0.13500000000000001, 0.57850000000000001, 0.2465, 0.123, 0.20000000000000001, 13),
(424, 'I', 0.28999999999999998, 0.22500000000000001, 0.070000000000000007, 0.10100000000000001, 0.035999999999999997, 0.0235, 0.035000000000000003, 8),
(421, 'F', 0.67000000000000004, 0.54000000000000004, 0.16500000000000001, 1.5015000000000001, 0.51800000000000002, 0.35799999999999998, 0.505, 14),
(426, 'M', 0.57999999999999996, 0.45000000000000001, 0.17499999999999999, 1.0680000000000001, 0.42499999999999999, 0.20300000000000001, 0.32000000000000001, 13),
(427, 'F', 0.60999999999999999, 0.48499999999999999, 0.16500000000000001, 1.0914999999999999, 0.39350000000000002, 0.24349999999999999, 0.33000000000000002, 18),
(428, 'M', 0.59999999999999998, 0.5, 0.16, 1.0149999999999999, 0.39950000000000002, 0.17349999999999999, 0.33000000000000002, 19),
(425, 'I', 0.26000000000000001, 0.20000000000000001, 0.070000000000000007, 0.091999999999999998, 0.036999999999999998, 0.02, 0.029999999999999999, 6),
(430, 'F', 0.57499999999999996, 0.45000000000000001, 0.17000000000000001, 1.0475000000000001, 0.3775, 0.17050000000000001, 0.38500000000000001, 18),
(431, 'F', 0.56999999999999995, 0.45000000000000001, 0.17499999999999999, 0.95550000000000002, 0.38, 0.16650000000000001, 0.29499999999999998, 18),
(432, 'M', 0.59999999999999998, 0.46999999999999997, 0.155, 1.036, 0.4375, 0.19600000000000001, 0.32500000000000001, 20),
(429, 'F', 0.56000000000000005, 0.45500000000000002, 0.125, 0.94299999999999995, 0.34399999999999997, 0.129, 0.375, 21),
(434, 'M', 0.54500000000000004, 0.41999999999999998, 0.14000000000000001, 0.75049999999999994, 0.2475, 0.13, 0.255, 22),
(435, 'I', 0.44, 0.34499999999999997, 0.10000000000000001, 0.36599999999999999, 0.122, 0.090499999999999997, 0.12, 13),
(436, 'M', 0.5, 0.40999999999999998, 0.14999999999999999, 0.66200000000000003, 0.28149999999999997, 0.13700000000000001, 0.22, 11),
(433, 'M', 0.56499999999999995, 0.45500000000000002, 0.17000000000000001, 0.90649999999999997, 0.34200000000000003, 0.156, 0.32000000000000001, 18),
(438, 'I', 0.38500000000000001, 0.30499999999999999, 0.095000000000000001, 0.252, 0.091499999999999998, 0.055, 0.089999999999999997, 14),
(439, 'M', 0.39000000000000001, 0.29999999999999999, 0.089999999999999997, 0.30549999999999999, 0.14299999999999999, 0.064500000000000002, 0.085000000000000006, 9),
(440, 'M', 0.5, 0.41499999999999998, 0.16500000000000001, 0.6885, 0.249, 0.13800000000000001, 0.25, 13),
(437, 'I', 0.35999999999999999, 0.27500000000000002, 0.095000000000000001, 0.217, 0.084000000000000005, 0.043499999999999997, 0.089999999999999997, 7),
(442, 'I', 0.33500000000000002, 0.26000000000000001, 0.10000000000000001, 0.192, 0.0785, 0.058500000000000003, 0.070000000000000007, 8),
(443, 'F', 0.505, 0.42499999999999999, 0.14000000000000001, 0.84999999999999998, 0.27500000000000002, 0.16250000000000001, 0.28499999999999998, 19),
(444, 'I', 0.39500000000000002, 0.29499999999999998, 0.10000000000000001, 0.27150000000000002, 0.13400000000000001, 0.032500000000000001, 0.085000000000000006, 10),
(441, 'I', 0.35999999999999999, 0.27500000000000002, 0.11, 0.23350000000000001, 0.095000000000000001, 0.052499999999999998, 0.085000000000000006, 10),
(446, 'F', 0.56000000000000005, 0.45500000000000002, 0.19, 0.71399999999999997, 0.28299999999999997, 0.129, 0.27500000000000002, 9),
(447, 'M', 0.56499999999999995, 0.435, 0.185, 0.98150000000000004, 0.32900000000000001, 0.13600000000000001, 0.39000000000000001, 13),
(448, 'M', 0.56499999999999995, 0.45500000000000002, 0.185, 0.92649999999999999, 0.35399999999999998, 0.1575, 0.375, 16),
(445, 'F', 0.40999999999999998, 0.32500000000000001, 0.105, 0.36349999999999999, 0.159, 0.076999999999999999, 0.12, 10),
(450, 'F', 0.56499999999999995, 0.45500000000000002, 0.14999999999999999, 0.82050000000000001, 0.36499999999999999, 0.159, 0.26000000000000001, 18),
(451, 'M', 0.72499999999999998, 0.56499999999999995, 0.215, 1.891, 0.69750000000000001, 0.47249999999999998, 0.57999999999999996, 16),
(452, 'F', 0.67500000000000004, 0.53500000000000003, 0.16, 1.4099999999999999, 0.59199999999999997, 0.3175, 0.41999999999999998, 16),
(449, 'M', 0.60499999999999998, 0.5, 0.17499999999999999, 1.0980000000000001, 0.47649999999999998, 0.23200000000000001, 0.375, 12),
(454, 'F', 0.56499999999999995, 0.48999999999999999, 0.155, 0.92449999999999999, 0.40500000000000003, 0.2195, 0.255, 11),
(455, 'F', 0.64500000000000002, 0.55000000000000004, 0.17499999999999999, 1.2915000000000001, 0.56999999999999995, 0.30449999999999999, 0.33000000000000002, 14),
(456, 'M', 0.57499999999999996, 0.46999999999999997, 0.14000000000000001, 0.83750000000000002, 0.34849999999999998, 0.17349999999999999, 0.23999999999999999, 11),
(453, 'F', 0.66500000000000004, 0.55500000000000005, 0.19500000000000001, 1.4384999999999999, 0.58099999999999996, 0.35399999999999998, 0.35999999999999999, 17),
(458, 'I', 0.35999999999999999, 0.28000000000000003, 0.105, 0.19900000000000001, 0.069500000000000006, 0.044999999999999998, 0.080000000000000002, 9),
(459, 'I', 0.41499999999999998, 0.31, 0.11, 0.29649999999999999, 0.123, 0.057000000000000002, 0.099500000000000005, 10),
(460, 'F', 0.52500000000000002, 0.40999999999999998, 0.13500000000000001, 0.70850000000000002, 0.29299999999999998, 0.1525, 0.23499999999999999, 11),
(457, 'F', 0.64000000000000001, 0.54000000000000004, 0.17499999999999999, 1.2210000000000001, 0.51000000000000001, 0.25900000000000001, 0.39000000000000001, 15),
(462, 'F', 0.58499999999999996, 0.46500000000000002, 0.17000000000000001, 0.99150000000000005, 0.38650000000000001, 0.224, 0.26500000000000001, 12),
(463, 'I', 0.23999999999999999, 0.185, 0.070000000000000007, 0.071499999999999994, 0.025999999999999999, 0.017999999999999999, 0.025000000000000001, 6),
(464, 'I', 0.22, 0.16500000000000001, 0.055, 0.0545, 0.021499999999999998, 0.012, 0.02, 5),
(461, 'M', 0.38, 0.28499999999999998, 0.10000000000000001, 0.26650000000000001, 0.115, 0.060999999999999999, 0.074999999999999997, 11),
(466, 'I', 0.17499999999999999, 0.125, 0.050000000000000003, 0.0235, 0.0080000000000000002, 0.0035000000000000001, 0.0080000000000000002, 5),
(467, 'F', 0.67000000000000004, 0.55000000000000004, 0.19, 1.3905000000000001, 0.54249999999999998, 0.30349999999999999, 0.40000000000000002, 12),
(468, 'M', 0.65500000000000003, 0.53000000000000003, 0.19500000000000001, 1.3879999999999999, 0.56699999999999995, 0.27350000000000002, 0.40999999999999998, 13),
(465, 'I', 0.255, 0.19500000000000001, 0.070000000000000007, 0.073499999999999996, 0.025499999999999998, 0.02, 0.025000000000000001, 6),
(470, 'M', 0.67500000000000004, 0.55500000000000005, 0.20000000000000001, 1.4384999999999999, 0.54500000000000004, 0.26650000000000001, 0.46500000000000002, 21),
(471, 'F', 0.53000000000000003, 0.44, 0.13500000000000001, 0.78349999999999997, 0.313, 0.17150000000000001, 0.2185, 9),
(472, 'F', 0.51500000000000001, 0.40500000000000003, 0.12, 0.64600000000000002, 0.28949999999999998, 0.14050000000000001, 0.17699999999999999, 10),
(469, 'F', 0.68000000000000005, 0.55000000000000004, 0.20999999999999999, 1.7444999999999999, 0.59750000000000003, 0.30499999999999999, 0.625, 17),
(474, 'F', 0.52000000000000002, 0.40500000000000003, 0.12, 0.627, 0.26450000000000001, 0.14149999999999999, 0.18099999999999999, 11),
(475, 'F', 0.54500000000000004, 0.41499999999999998, 0.16, 0.77149999999999996, 0.27200000000000002, 0.14549999999999999, 0.27650000000000002, 10),
(476, 'M', 0.53000000000000003, 0.41499999999999998, 0.17499999999999999, 0.73950000000000005, 0.26100000000000001, 0.13950000000000001, 0.26450000000000001, 17),
(473, 'I', 0.42999999999999999, 0.34000000000000002, 0.12, 0.35749999999999998, 0.151, 0.064500000000000002, 0.1045, 9),
(478, 'M', 0.66500000000000004, 0.54000000000000004, 0.17499999999999999, 1.347, 0.4955, 0.254, 0.41499999999999998, 17),
(479, 'M', 0.73499999999999999, 0.58999999999999997, 0.22500000000000001, 1.756, 0.63700000000000001, 0.34050000000000002, 0.57999999999999996, 21),
(480, 'M', 0.66000000000000003, 0.54500000000000004, 0.185, 1.3200000000000001, 0.53049999999999997, 0.26350000000000001, 0.45500000000000002, 16),
(477, 'F', 0.46500000000000002, 0.34999999999999998, 0.115, 0.42099999999999999, 0.1565, 0.090999999999999998, 0.13450000000000001, 9),
(482, 'M', 0.57499999999999996, 0.40000000000000002, 0.155, 0.9325, 0.36049999999999999, 0.2445, 0.29999999999999999, 17),
(483, 'M', 0.56999999999999995, 0.46500000000000002, 0.125, 0.84899999999999998, 0.3785, 0.17649999999999999, 0.23999999999999999, 15),
(484, 'F', 0.57999999999999996, 0.46000000000000002, 0.14999999999999999, 0.99550000000000005, 0.42899999999999999, 0.21199999999999999, 0.26000000000000001, 19),
(481, 'F', 0.69999999999999996, 0.58499999999999996, 0.185, 1.8075000000000001, 0.70550000000000002, 0.32150000000000001, 0.47499999999999998, 29),
(486, 'F', 0.58499999999999996, 0.46500000000000002, 0.14000000000000001, 0.90800000000000003, 0.38100000000000001, 0.1615, 0.315, 13),
(487, 'M', 0.55000000000000004, 0.45000000000000001, 0.13, 0.92000000000000004, 0.378, 0.23849999999999999, 0.28999999999999998, 11),
(488, 'F', 0.625, 0.51500000000000001, 0.14999999999999999, 1.2415, 0.52349999999999997, 0.30649999999999999, 0.35999999999999999, 15),
(485, 'M', 0.63, 0.47999999999999998, 0.14499999999999999, 1.0115000000000001, 0.42349999999999999, 0.23699999999999999, 0.30499999999999999, 12),
(490, 'F', 0.56999999999999995, 0.45500000000000002, 0.16500000000000001, 1.0595000000000001, 0.44, 0.2195, 0.28499999999999998, 14),
(491, 'M', 0.58999999999999997, 0.45500000000000002, 0.14499999999999999, 1.073, 0.47499999999999998, 0.19, 0.28499999999999998, 14),
(492, 'M', 0.57999999999999996, 0.46000000000000002, 0.13, 0.92100000000000004, 0.35699999999999998, 0.18099999999999999, 0.28999999999999998, 13),
(489, 'M', 0.54000000000000004, 0.41999999999999998, 0.13500000000000001, 0.8075, 0.34849999999999998, 0.17949999999999999, 0.23499999999999999, 11),
(494, 'M', 0.65500000000000003, 0.53000000000000003, 0.17499999999999999, 1.2635000000000001, 0.48599999999999999, 0.26350000000000001, 0.41499999999999998, 15),
(495, 'M', 0.625, 0.5, 0.19500000000000001, 1.369, 0.58750000000000002, 0.2185, 0.37, 17),
(496, 'F', 0.625, 0.5, 0.14999999999999999, 0.95299999999999996, 0.34449999999999997, 0.2235, 0.30499999999999999, 15),
(493, 'F', 0.65500000000000003, 0.51000000000000001, 0.155, 1.2895000000000001, 0.53449999999999998, 0.28549999999999998, 0.40999999999999998, 11),
(498, 'F', 0.60499999999999998, 0.48499999999999999, 0.16500000000000001, 1.0105, 0.435, 0.20899999999999999, 0.29999999999999999, 19),
(499, 'F', 0.61499999999999999, 0.52500000000000002, 0.155, 1.0385, 0.42699999999999999, 0.23150000000000001, 0.34499999999999997, 11),
(500, 'M', 0.55500000000000005, 0.45000000000000001, 0.17499999999999999, 0.874, 0.32750000000000001, 0.20200000000000001, 0.30499999999999999, 10),
(497, 'F', 0.64000000000000001, 0.52000000000000002, 0.17499999999999999, 1.248, 0.42449999999999999, 0.25950000000000001, 0.47999999999999998, 12),
(502, 'F', 0.62, 0.52000000000000002, 0.22500000000000001, 1.1835, 0.378, 0.27000000000000002, 0.39500000000000002, 23),
(503, 'F', 0.62, 0.46999999999999997, 0.22500000000000001, 1.115, 0.378, 0.2145, 0.35999999999999999, 15),
(504, 'F', 0.59999999999999998, 0.505, 0.19, 1.129, 0.4385, 0.25600000000000001, 0.35999999999999999, 13),
(501, 'F', 0.57999999999999996, 0.44, 0.17999999999999999, 0.85399999999999998, 0.36649999999999999, 0.16350000000000001, 0.245, 12),
(506, 'M', 0.59999999999999998, 0.46999999999999997, 0.17499999999999999, 1.105, 0.48649999999999999, 0.247, 0.315, 15),
(507, 'M', 0.56000000000000005, 0.46000000000000002, 0.23499999999999999, 0.83950000000000002, 0.33250000000000002, 0.157, 0.30499999999999999, 12),
(508, 'M', 0.58499999999999996, 0.45500000000000002, 0.22500000000000001, 1.0549999999999999, 0.38150000000000001, 0.221, 0.36499999999999999, 15),
(505, 'F', 0.625, 0.48499999999999999, 0.19, 1.1745000000000001, 0.4385, 0.23050000000000001, 0.41999999999999998, 17),
(511, 'I', 0.68000000000000005, 0.53000000000000003, 0.185, 1.1094999999999999, 0.439, 0.245, 0.34000000000000002, 10),
(510, 'I', 0.56000000000000005, 0.44500000000000001, 0.155, 0.87350000000000005, 0.30049999999999999, 0.20899999999999999, 0.27500000000000002, 16),
(509, 'M', 0.56000000000000005, 0.435, 0.17999999999999999, 0.88900000000000001, 0.35999999999999999, 0.20399999999999999, 0.25, 11),
(512, 'F', 0.45500000000000002, 0.34999999999999998, 0.14000000000000001, 0.51849999999999996, 0.221, 0.1265, 0.13500000000000001, 10),
(515, 'F', 0.27500000000000002, 0.19500000000000001, 0.070000000000000007, 0.080000000000000002, 0.031, 0.021499999999999998, 0.025000000000000001, 5),
(514, 'M', 0.31, 0.22, 0.085000000000000006, 0.14599999999999999, 0.060999999999999999, 0.036499999999999998, 0.044999999999999998, 6),
(513, 'F', 0.48999999999999999, 0.38, 0.14499999999999999, 0.67249999999999999, 0.249, 0.18099999999999999, 0.20999999999999999, 10),
(516, 'M', 0.27000000000000002, 0.19500000000000001, 0.080000000000000002, 0.10000000000000001, 0.0385, 0.0195, 0.029999999999999999, 6),
(519, 'M', 0.32500000000000001, 0.23000000000000001, 0.089999999999999997, 0.14699999999999999, 0.059999999999999998, 0.034000000000000002, 0.044999999999999998, 4),
(518, 'M', 0.28000000000000003, 0.20000000000000001, 0.080000000000000002, 0.091499999999999998, 0.033000000000000002, 0.021499999999999998, 0.029999999999999999, 5),
(517, 'M', 0.40000000000000002, 0.28999999999999998, 0.115, 0.27950000000000003, 0.1115, 0.057500000000000002, 0.074999999999999997, 9),
(520, 'F', 0.34499999999999997, 0.25, 0.089999999999999997, 0.20300000000000001, 0.078, 0.058999999999999997, 0.055, 6),
(523, 'I', 0.36499999999999999, 0.26000000000000001, 0.115, 0.218, 0.0935, 0.044499999999999998, 0.070000000000000007, 9),
(522, 'F', 0.35999999999999999, 0.27000000000000002, 0.089999999999999997, 0.1885, 0.084500000000000006, 0.0385, 0.055, 5),
(521, 'M', 0.20999999999999999, 0.14999999999999999, 0.050000000000000003, 0.0385, 0.0155, 0.0085000000000000006, 0.01, 3),
(524, 'M', 0.20000000000000001, 0.14000000000000001, 0.055, 0.035000000000000003, 0.014500000000000001, 0.0080000000000000002, 0.01, 5),
(527, 'M', 0.155, 0.11, 0.040000000000000001, 0.0155, 0.0064999999999999997, 0.0030000000000000001, 0.0050000000000000001, 3),
(526, 'M', 0.17499999999999999, 0.125, 0.040000000000000001, 0.024, 0.0094999999999999998, 0.0060000000000000001, 0.0050000000000000001, 4),
(525, 'M', 0.23499999999999999, 0.16, 0.059999999999999998, 0.0545, 0.026499999999999999, 0.0094999999999999998, 0.014999999999999999, 4),
(528, 'F', 0.56999999999999995, 0.44500000000000001, 0.155, 0.73299999999999998, 0.28199999999999997, 0.159, 0.23499999999999999, 14),
(531, 'I', 0.53000000000000003, 0.41999999999999998, 0.185, 0.752, 0.29899999999999999, 0.156, 0.20499999999999999, 20),
(530, 'M', 0.38500000000000001, 0.29999999999999999, 0.095000000000000001, 0.23999999999999999, 0.088499999999999995, 0.058999999999999997, 0.085000000000000006, 9),
(529, 'F', 0.56999999999999995, 0.45000000000000001, 0.16, 0.97150000000000003, 0.39650000000000002, 0.255, 0.26000000000000001, 12),
(532, 'F', 0.46000000000000002, 0.35499999999999998, 0.13, 0.45800000000000002, 0.192, 0.1055, 0.13, 13),
(535, 'I', 0.46999999999999997, 0.37, 0.14000000000000001, 0.4985, 0.20949999999999999, 0.1225, 0.14499999999999999, 10),
(534, 'F', 0.435, 0.33500000000000002, 0.11, 0.38, 0.16950000000000001, 0.085999999999999993, 0.11, 9),
(533, 'I', 0.46999999999999997, 0.37, 0.12, 0.47049999999999997, 0.1845, 0.1055, 0.155, 12),
(536, 'I', 0.46500000000000002, 0.38, 0.13, 0.45400000000000001, 0.1895, 0.080000000000000002, 0.155, 11),
(539, 'M', 0.27500000000000002, 0.20499999999999999, 0.070000000000000007, 0.094, 0.033500000000000002, 0.02, 0.032500000000000001, 5),
(538, 'M', 0.28999999999999998, 0.23000000000000001, 0.074999999999999997, 0.11650000000000001, 0.042999999999999997, 0.025499999999999998, 0.040000000000000001, 7),
(537, 'I', 0.52000000000000002, 0.40500000000000003, 0.14000000000000001, 0.57750000000000001, 0.20000000000000001, 0.14499999999999999, 0.17899999999999999, 11),
(540, 'F', 0.375, 0.28999999999999998, 0.115, 0.27050000000000002, 0.092999999999999999, 0.066000000000000003, 0.088499999999999995, 10),
(543, 'M', 0.41999999999999998, 0.32500000000000001, 0.115, 0.28849999999999998, 0.10000000000000001, 0.057000000000000002, 0.1135, 15),
(542, 'F', 0.44, 0.35499999999999998, 0.115, 0.41499999999999998, 0.1585, 0.092499999999999999, 0.13100000000000001, 11),
(541, 'F', 0.5, 0.375, 0.14000000000000001, 0.60399999999999998, 0.24199999999999999, 0.14149999999999999, 0.17899999999999999, 15),
(544, 'M', 0.44500000000000001, 0.34999999999999998, 0.115, 0.36149999999999999, 0.1565, 0.069500000000000006, 0.11700000000000001, 8),
(547, 'M', 0.255, 0.19500000000000001, 0.065000000000000002, 0.080000000000000002, 0.0315, 0.017999999999999999, 0.027, 8),
(546, 'M', 0.32000000000000001, 0.245, 0.074999999999999997, 0.1555, 0.058500000000000003, 0.037999999999999999, 0.049000000000000002, 11),
(545, 'F', 0.38, 0.28999999999999998, 0.105, 0.25700000000000001, 0.099000000000000005, 0.050999999999999997, 0.085000000000000006, 10),
(548, 'M', 0.20499999999999999, 0.155, 0.044999999999999998, 0.042500000000000003, 0.017000000000000001, 0.0054999999999999997, 0.0155, 7),
(551, 'I', 0.65000000000000002, 0.51500000000000001, 0.16, 1.1625000000000001, 0.495, 0.20300000000000001, 0.33000000000000002, 17),
(550, 'I', 0.55500000000000005, 0.42499999999999999, 0.17999999999999999, 0.875, 0.3695, 0.20050000000000001, 0.255, 11);


DROP TABLE IF EXISTS abalone2;
create table abalone2 as
select
    length, diameter, height, whole, sex,
    (case when rings < 10 then 1 else 0 end)::integer as y
from abalone1;

drop table if exists temp_out;
drop table if exists temp_out_summary;
select clustered_variance_linregr('abalone1', 'temp_out', 'rings', 'array[1, length, diameter, height, whole]', 'sex');

select assert(
    relative_error(coef, array[1.550894e+00, -1.617533e+00, 1.489248e+01, 2.230165e+01, 2.291137e+00]) < 1e-6 and
    relative_error(std_err, array[5.230808e-01, 9.126018e-01, 4.160678e+00, 1.656641e+00, 6.037868e-01]) < 1e-6 and
    relative_error(t_stats, array[2.964922e+00, -1.772441e+00, 3.579340e+00, 1.346197e+01, 3.794612e+00]) < 1e-6 and
    relative_error(p_values, array[3.160120e-03, 7.687992e-02, 3.752007e-04, 7.224856e-36, 1.644453e-04]) < 1e-6,
    'Clustered standard errors: Wrong results for linear'
) from temp_out;

drop table if exists temp_out;
drop table if exists temp_out_summary;
select clustered_variance_logregr('abalone1', 'temp_out', 'rings < 10', 'array[1, length, diameter, height, whole]', 'sex', NULL, 100, 'irls', 1e-6, False);

select assert(
    relative_error(coef, array[7.019211e+00, -9.452704e+00, 1.213867e+00, -1.625120e+01, -2.357464e+00]) < 1e-4 and
    relative_error(std_err, array[1.869091e+00, 1.638447e+00, 7.460817e+00, 9.503961e+00, 2.069767e+00]) < 1e-4 and
    relative_error(z_stats, array[3.755414e+00, -5.769307e+00, 1.626990e-01, -1.709940e+00, -1.139000e+00]) < 1e-4 and
    relative_error(p_values, array[1.730550e-04, 7.959840e-09, 8.707555e-01, 8.727696e-02, 2.547033e-01]) < 1e-4,
    'Clustered standard errors: Wrong results for logistic'
) from temp_out;

drop table if exists temp_out;
drop table if exists temp_out_summary;
select clustered_variance_mlogregr(
    'abalone2', 'temp_out', 'y', 'array[1, length, diameter, height, whole]',
    'sex', 0, NULL, 'max_iter=100, optimizer=irls, tolerance=1e-6', False);

select assert(
    relative_error(coef, array[7.019211e+00, -9.452704e+00, 1.213867e+00, -1.625120e+01, -2.357464e+00]) < 1e-4 and
    relative_error(std_err, array[1.869091e+00, 1.638447e+00, 7.460817e+00, 9.503961e+00, 2.069767e+00]) < 1e-4 and
    relative_error(z_stats, array[3.755414e+00, -5.769307e+00, 1.626990e-01, -1.709940e+00, -1.139000e+00]) < 1e-4 and
    relative_error(p_values, array[1.730550e-04, 7.959840e-09, 8.707555e-01, 8.727696e-02, 2.547033e-01]) < 1e-4,
    'Clustered standard errors: Wrong results for multinomial logistic'
) from temp_out;

-- NULL handling test

DROP TABLE IF EXISTS abalone1_all_null;
CREATE TABLE abalone1_all_null (
    id integer,
    sex text,
    length double precision,
    diameter double precision,
    height double precision,
    whole double precision,
    shucked double precision,
    viscera double precision,
    shell double precision,
    rings integer
);
INSERT INTO abalone1_all_null VALUES
(552, 'M', NULL, 0.36499999999999999, 0.095000000000000001, 0.51400000000000001, 0.22450000000000001, 0.10100000000000001, 0.14999999999999999, 15),
(553, 'M', 0.44, NULL, 0.125, 0.51600000000000001, 0.2155, 0.114, 0.155, 10),
(554, 'F', 0.53000000000000003, 0.41999999999999998, NULL, 0.67700000000000005, 0.25650000000000001, 0.14149999999999999, 0.20999999999999999, 9),
(555, 'M', 0.34999999999999998, 0.26500000000000001, 0.089999999999999997, 1, 0.099500000000000005, 0.048500000000000001, 0.070000000000000007, NULL),
(556, 'M', 0.34999999999999998, 0.26500000000000001, 0.089999999999999997, NULL, 0.099500000000000005, 0.048500000000000001, 0.070000000000000007, 7);

drop table if exists temp_out;
drop table if exists temp_out_summary;
select clustered_variance_linregr('abalone1_all_null', 'temp_out', 'rings', 'array[1, length, diameter, height, whole]', 'sex');
SELECT * FROM temp_out;

DROP TABLE IF EXISTS abalone1_with_null;
CREATE TABLE abalone1_with_null AS SELECT * FROM abalone1;
INSERT INTO abalone1_with_null SELECT * FROM abalone1_all_null;

DROP TABLE IF EXISTS abalone2_with_null;
create table abalone2_with_null as
select
    length, diameter, height, whole, sex,
    (rings < 10)::integer as y
from abalone1_with_null;

drop table if exists temp_out;
drop table if exists temp_out_summary;
select clustered_variance_linregr('abalone1_with_null', 'temp_out', 'rings', 'array[1, length, diameter, height, whole]', 'sex');
SELECT * FROM temp_out;

select assert(
    relative_error(coef, array[1.550894e+00, -1.617533e+00, 1.489248e+01, 2.230165e+01, 2.291137e+00]) < 1e-6 and
    relative_error(std_err, array[5.230808e-01, 9.126018e-01, 4.160678e+00, 1.656641e+00, 6.037868e-01]) < 1e-6 and
    relative_error(t_stats, array[2.964922e+00, -1.772441e+00, 3.579340e+00, 1.346197e+01, 3.794612e+00]) < 1e-6 and
    relative_error(p_values, array[3.160120e-03, 7.687992e-02, 3.752007e-04, 7.224856e-36, 1.644453e-04]) < 1e-6,
    'Clustered standard errors: Wrong results for linear'
) from temp_out;

drop table if exists temp_out;
drop table if exists temp_out_summary;
select clustered_variance_logregr('abalone1_with_null', 'temp_out', 'rings < 10', 'array[1, length, diameter, height, whole]', 'sex', NULL, 100, 'irls', 1e-6, False);
SELECT * FROM temp_out;

select assert(
    relative_error(coef, array[7.019211e+00, -9.452704e+00, 1.213867e+00, -1.625120e+01, -2.357464e+00]) < 1e-4 and
    relative_error(std_err, array[1.869091e+00, 1.638447e+00, 7.460817e+00, 9.503961e+00, 2.069767e+00]) < 1e-4 and
    relative_error(z_stats, array[3.755414e+00, -5.769307e+00, 1.626990e-01, -1.709940e+00, -1.139000e+00]) < 1e-4 and
    relative_error(p_values, array[1.730550e-04, 7.959840e-09, 8.707555e-01, 8.727696e-02, 2.547033e-01]) < 1e-4,
    'Clustered standard errors: Wrong results for logistic'
) from temp_out;

drop table if exists temp_out;
drop table if exists temp_out_summary;
select clustered_variance_mlogregr(
    'abalone2_with_null', 'temp_out', 'y', 'array[1, length, diameter, height, whole]',
    'sex', 0, NULL, 'max_iter=100, optimizer=irls, tolerance=1e-6', False);
SELECT * FROM temp_out;

select assert(
    relative_error(coef, array[7.019211e+00, -9.452704e+00, 1.213867e+00, -1.625120e+01, -2.357464e+00]) < 1e-4 and
    relative_error(std_err, array[1.869091e+00, 1.638447e+00, 7.460817e+00, 9.503961e+00, 2.069767e+00]) < 1e-4 and
    relative_error(z_stats, array[3.755414e+00, -5.769307e+00, 1.626990e-01, -1.709940e+00, -1.139000e+00]) < 1e-4 and
    relative_error(p_values, array[1.730550e-04, 7.959840e-09, 8.707555e-01, 8.727696e-02, 2.547033e-01]) < 1e-4,
    'Clustered standard errors: Wrong results for multinomial logistic'
) from temp_out;