stats based question
Make sure your EXCEL settings include ‘View-Formula Bar” so you can see my formulas in each cell. To find a Standard Deviation, you take these steps …
(1) Find the mean (average) of the data
(2) Find the difference of the data value and mean and square that difference. (X-Mean)^2
(3) Sum the differences from Step-2, divide by N-1 (where N=number of data values) and then take the square root