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
  • cidyah
    Lv 7
    10 years ago
    Favorite 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.