NIME - Feature Diff

error set:


aggregation:
temp:

learntriali_scorei_stddevn_scoren_stddevabs_diffbig_stddevsig_diff
0.100010.98480.04670.97910.05360.00560.0536false
0.100020.98480.04670.97910.05360.00560.0536false
0.100030.98480.04670.97910.05360.00560.0536false
0.100040.98480.04670.97910.05360.00560.0536false
0.100050.98480.04670.97910.05360.00560.0536false
0.100060.98480.04670.97910.05360.00560.0536false
0.100070.98480.04670.97910.05360.00560.0536false
0.100080.98480.04670.97910.05360.00560.0536false
0.100090.98480.04670.97910.05360.00560.0536false
0.1000100.98480.04670.97910.05360.00560.0536false
0.300010.99960.00620.99880.00880.00090.0088false
0.300020.99960.00620.99880.00880.00090.0088false
0.300030.99960.00620.99880.00880.00090.0088false
0.300040.99960.00620.99880.00880.00090.0088false
0.300050.99960.00620.99880.00880.00090.0088false
0.300060.99960.00620.99880.00880.00090.0088false
0.300070.99960.00620.99880.00880.00090.0088false
0.300080.99960.00620.99880.00880.00090.0088false
0.300090.99960.00620.99880.00880.00090.0088false
0.3000100.99960.00620.99880.00880.00090.0088false
0.500011.00000.00000.99960.00480.00040.0048false
0.500021.00000.00000.99960.00480.00040.0048false
0.500031.00000.00000.99960.00480.00040.0048false
0.500041.00000.00000.99960.00480.00040.0048false
0.500051.00000.00000.99960.00480.00040.0048false
0.500061.00000.00000.99960.00480.00040.0048false
0.500071.00000.00000.99960.00480.00040.0048false
0.500081.00000.00000.99960.00480.00040.0048false
0.500091.00000.00000.99960.00480.00040.0048false
0.5000101.00000.00000.99960.00480.00040.0048false
0.700011.00000.00001.00000.00000.00000.0000false
0.700021.00000.00001.00000.00000.00000.0000false
0.700031.00000.00001.00000.00000.00000.0000false
0.700041.00000.00001.00000.00000.00000.0000false
0.700051.00000.00001.00000.00000.00000.0000false
0.700061.00000.00001.00000.00000.00000.0000false
0.700071.00000.00001.00000.00000.00000.0000false
0.700081.00000.00001.00000.00000.00000.0000false
0.700091.00000.00001.00000.00000.00000.0000false
0.7000101.00000.00001.00000.00000.00000.0000false
0.900011.00000.00000.99990.00280.00010.0028false
0.900021.00000.00000.99990.00280.00010.0028false
0.900031.00000.00000.99990.00280.00010.0028false
0.900041.00000.00000.99990.00280.00010.0028false
0.900051.00000.00000.99990.00280.00010.0028false
0.900061.00000.00000.99990.00280.00010.0028false
0.900071.00000.00000.99990.00280.00010.0028false
0.900081.00000.00000.99990.00280.00010.0028false
0.900091.00000.00000.99990.00280.00010.0028false
0.9000101.00000.00000.99990.00280.00010.0028false


download as csv
SELECT d.*, IF(d.abs_diff>d.big_stddev,'true','false') AS sig_diff
FROM (SELECT c.*, ABS(c.i_score-c.n_score) AS abs_diff, IF(c.i_stddev>c.n_stddev,c.i_stddev,c.n_stddev) AS big_stddev
FROM (SELECT b.*, AVG(n.d_score) AS n_score, STDDEV_SAMP(n.d_score) AS n_stddev
FROM (SELECT a.*, AVG(i.d_score) AS i_score, STDDEV_SAMP(i.d_score) AS i_stddev
FROM (SELECT d_learn AS learn, d_trial AS trial
FROM exp_data_89
WHERE d_temp=0.1 AND d_errset=1
GROUP BY d_learn, d_trial) a, exp_data_89 i
WHERE i.d_learn=a.learn AND i.d_temp=0.1 AND i.d_errset=1 AND i.d_rule='beats-abs16'
GROUP BY a.learn, a.trial) b, exp_data_89 n
WHERE n.d_learn=b.learn AND n.d_temp=0.1 AND n.d_errset=1 AND n.d_rule='close16'
GROUP BY b.learn, b.trial) c
ORDER BY c.trial ASC, c.learn ASC) d