#acl All:read,write = Results for Exercise Sheet 13 (Statistical significance) = '''Please read the instructions below, before adding something to the table!''' Add your row to the table below, following the examples already there. Column 1 = name. Columns 2 + 3 + 4 + 5 + 6 = values for n = 3, namely: difference M of means, estimated standard deviation S' = S / sqrt(n), value of test statistic x = M / S', and the p-values for the Z-test and the T-test, respectively. Columns 7 + 8 + 9 + 10 + 11 = same values for n = 10. Please write all values with exactly three digits after the dot. Recall: experiment to measure query times for tables with hex vs. integer ids for person names when joining ''acted_in'' and ''has_won'' on their respective first column. Note: in Wolfram Alpha you can type something like ''P(X >= x) for the standard normal distribution'' or ''P(X >= x) for the t-distribution with ... degrees of freedom'', awesome! ||'''Name''' ||||||||||'''n=3''' ||||||||||'''n=10''' || ||'''M''' ||'''S' = S/sqrt(n)''' ||'''x = M / S'''' ||'''Pr(Z >= x)''' ||'''Pr(T >= x)''' ||'''M''' ||'''S' = S/sqrt(n)''' ||'''x = M / S'''' ||'''Pr(Z >= x)''' ||'''Pr(T >= x)''' || ||Florian B ||0.077 ||0.007 ||10.286 ||0.000% ||0.002% ||0.072 ||0.009 ||7.426 ||0.000% ||0.000% || ||Nikolaus M ||0.253 ||0.0078 ||32.572 ||0.000% ||0.000% ||0.247 ||0.0071 ||34.621 ||0.000% ||0.000% || ||Mallikarjun ||0.507 ||0.0075 ||67.05 ||0.000% ||0.000% ||0.509 ||0.0076 ||66.32 ||0.000% ||0.000% || ||Severin ||0.3494 ||0.0110 ||31.772 ||7.864e-220% ||5.849e-04% ||0.3496 ||0.0071 ||49.288 ||0.000% ||2.2e-16% || ||Chris S ||0.249 ||0.012 ||19.595 ||0.000% ||0.000% ||0.263 ||0.025 ||10.313 ||0.000% ||0.000% || ||Tobias F ||0,1452 ||0,001 ||2,5577 ||0.0054% ||4.000% ||0,1328 ||0,0026 ||0,8132 ||?% ||?% || ||Robin S ||0.147 ||0.005 ||32.439 ||3.871e-229% ||2.854e-6% ||0.176 ||0.012 ||14.414 ||2.113e-45% ||2.503e-10% || ||Andreas H ||0.009 ||0.002 ||4.287 ||0.000 ||0.012 ||0.010 ||0.001 ||9.071 ||0.000 ||0.000 || ||Matthias H ||0.373 ||0.00002 ||134.516 ||0.000% ||0.000% ||0.371 ||0.003 ||108.402 ||0.000% ||0.000% || ||Marc P ||0.3273 ||0.01 ||32.18 ||0.000% ||0.000% ||0.3243 ||0.0074 ||43.73 ||0.000% ||0.000% || ||Niklas||0.1066|| 0.0001 || 1066||0.000%|| 0.000%|| 0.110407|| 0.00029|| 375.41 || 0.000% || 0.000%|| || Bettina H || 0.136 || 0.041 || 3.317 || 0.045% || 0.803% || 0.175 || 0.061 || 2.869 || 0.206% || 0.474% || || Torben S Milan O || 0.1667 || 0.0983 || 1.6949 || 4.55% || 5% || 0.0483 || 0.1033 || 0.4680 || 37% || 25% || ||Manuel M || 0.190 || 0.031 || 6.104 || 0.000% || 5.169%% || 0.173 || 0.033 || 5.292 || 0.000% || 5.944%|| ||Joachim W, Philipp B || 0.1946 || 0.030 || 6.475 || 4.7406e-9 % || 0.0035588 % || 0.1812 || 0.0179 || 10.1229 || 2.18632e-22% || 7.10514e-5 %|| ||Marcel T, Jeremy D|| 0,01 || 0,0019 || 5,263 || - || - || 0.021 || 0.000128874 || 162.949 || - || -|| ||Ragavan N ||0.0007 ||.0009 ||0.74 ||22.9% ||25% ||0.0001 ||0.0008 ||0.1204 ||45.2% ||45% || ||Markus F ||0.061 || 0.001 || 67.357 ||0.000% ||0.000% ||0.062 ||0.001 || 117.628 ||0.000% ||0.000% ||