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%

AD Teaching Wiki: InformationRetrievalWS1213/ResultsHypothesisTesting (last edited 2013-02-13 15:58:51 by p579D13AD)