## Trending News

Promoted

# 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!

### 1 Answer

Relevance

- 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

Use

=abs((C3-C4)/C8)

Still have questions? Get your answers by asking now.