Calculating Standard Deviation (1 SD Move, 2 SD Move, 3 SD Move – Upper & Lower), Variance, Mean of Stocks using Microsoft Excel & Google Spreadsheets…
Formulas
Returns –
=LN(G2/G3)
Mean –
=Average(H:H)
Variance –
=VAR.P(H:H)
Standard Deviation –
=STDEV.P(H:H)
1 SD Move (Lower) –
=Average(H:H)-1*STDEV.P(H:H)
1 SD Move (Upper) –
=Average(H:H)+1*STDEV.P(H:H)
2 SD Move (Lower) –
=Average(H:H)-2*STDEV.P(H:H)
2 SD Move (Upper) –
=Average(H:H)+2*STDEV.P(H:H)
3 SD Move (Lower) –
=Average(H:H)-3*STDEV.P(H:H)
3 SD Move (Upper) –
=Average(H:H)+3*STDEV.P(H:H)