How do I calculate a statistic from the beginning of the column down to the current row?

To have a statistic calculated from the beginning of the column down to the current row, use a formula like:

c2 = mean([-index() :0, 1:1])

This particular formula finds the mean in column 1 and stores the result in column 2.