Hriston
Dungeon Master of Middle-earth
In Libre Calc (I don't have Excel and I have principles)
column A = numbers 3-18
Column B = frequencies 1, 3, 6, 10, 15, 21, 25, 27 (and again backwards)
Colum c= first cell "= (A1-10.5)^2*B1/206" and copied all the way to C16
C17= "=Sum(C1:C16)"
C18= "=Sqrt(C17)"
C17 gives 9.1747572816
C18 gives 3.0289861805 ~ 3.03
I didn't calculate the SD myself. I remember doing some research to find out what seemed to be the right answer. But shouldn't you have divided by 216 instead of 206?
edit: On the other hand, I've definitely seen multiple occurrences of the SD of 3d6 bein rounded to 3, so I don't think this is a matter of much contention.
Last edited: