Calculating Standard Deviation, Variance, Mean of Stocks using Microsoft Excel & Google Spreadsheets

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)