Excel and Statistics: Standard Deviation, Mean and Min?
I have a set of data for which I have already calculated the Standard Deviation (cell C8, which is 0.083), the Mean (cell C3, which is 29.81) and the Minimum (cell C4, which is 29.67). However, I would like to write a formula in Excel to figure out how many Standard Deviations away from the Mean the Minimum value actually is while using absolute cell references for the Mean and Standard Deviation values.
Can anyone please help? Thanks!
- cidyahLv 710 years agoFavorite Answer
C8 =0.083 -- SD
C3 =29.81 ---Mean
C4 =29.67 -- Min
C3-k C8 = C4
k C8 = C3-C4
k = (C3-C4)/C8