select experiment_number, sum(power(value - avg(value) over (partition by experiment_number), 2)) / count(*) from my_table group by experiment_number