Quick Standard Deviation question

[mlarson]

This is probably very easy but I don't know the formula. I want to take the standard deviation of the 5 values closest to the bottom of column H and have the output in cell U4. And the 5 closest to the bottom of column I with output in cell V4. And the 5 from column J to cell W4.

Do you know of a simple formulas to do this? My spreadsheet will be changed regularly so the bottom data will constantly be changing and I need to always capture the bottom 5 values. Thanks.

Here's the data and desired output.

<table border="0" cellpadding="0" cellspacing="0" width="192"><col style="width: 48pt;" width="64" span="3"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 48pt;" width="64" height="20">H</td> <td class="xl63" style="border-left: medium none; width: 48pt;" width="64">I</td> <td class="xl63" style="border-left: medium none; width: 48pt;" width="64">J</td> </tr> <tr style="height: 18.75pt;" height="25"> <td class="xl63" style="height: 18.75pt; border-top: medium none;" align="right" height="25">0.000341</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.001327</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.001669</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" align="right" height="20">0.009259</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">-0.00841</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.000853</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" align="right" height="20">0.006787</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.003503</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.01029</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" align="right" height="20">0.000312</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">-0.00054</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">-0.00023</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" align="right" height="20">-0.00143</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">-0.00316</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">-0.00459</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" align="right" height="20">-0.00431</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.007559</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.003244</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" align="right" height="20">-0.00112</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">-0.00327</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">-0.00439</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" align="right" height="20">0.00279</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">-0.00062</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.002173</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" align="right" height="20">-0.01296</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.020307</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.007348</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" align="right" height="20">-0.00372</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.016333</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.012608</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" align="right" height="20">0.002656</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.006031</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0.008687</td> </tr> <tr style="height: 18.75pt;" height="25"> <td class="xl63" style="height: 18.75pt; border-top: medium none;" align="right" height="25">0.005417</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">-0.00643</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">-0.00101</td> </tr> </tbody></table>
Desired Output
Cell U4: 0.00740
Cell V4: 0.01121
Cell W4: 0.00536

 

[mlarson]

Aladin, apologies for the delay in providing feedback (I pride myself on providing feedback quickly so I am sorry for taking a few days). Your solution seemed to work so thank you very much!

 

[Aladin Akyurek]

Aladin, apologies for the delay in providing feedback (I pride myself on providing feedback quickly so I am sorry for taking a few days). Your solution seemed to work so thank you very much!

No problem. Glad to hear that you can work with it.