Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Deviation
Is it possible to form an equation that will give me a standard deviation for
all numbers above a certain value. I know there are SUMIF and COUNTIF formulas and if you want the average you actually have to do (SUMIF/COUNTIF) because there is no AVERAGEIF. I guess what i am asking is if there is a way to do a standard deviation for only a certain range of numbers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Deviation
In article ,
Soccerboy83 wrote: Is it possible to form an equation that will give me a standard deviation for all numbers above a certain value. I know there are SUMIF and COUNTIF formulas and if you want the average you actually have to do (SUMIF/COUNTIF) because there is no AVERAGEIF. I guess what i am asking is if there is a way to do a standard deviation for only a certain range of numbers. Assuming that A2:A100 contains the data, and that C2 contains the value of interest, try the following formula that needs to be confirmed with CONTROL+SHIFT+ENTER... =STDEV(IF($A$2:$A$100C2,$A$2:$A$100)) -- Domenic http://www.xl-central.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Deviation
Soccerboy83 wrote:
Is it possible to form an equation that will give me a standard deviation for all numbers above a certain value. I know there are SUMIF and COUNTIF formulas and if you want the average you actually have to do (SUMIF/COUNTIF) because there is no AVERAGEIF. I guess what i am asking is if there is a way to do a standard deviation for only a certain range of numbers. Suppose you have in A1:A5 1 3 5 3 1 Then this array* formula will give STDEV where the input value is 2 =STDEV(IF(A1:A52,A1:A5)) *Very important: array formulas must be committed by pressing Ctrl+Shift+Enter, not just Enter. The same technique can be applied with some other functions, e.g., =AVERAGE(IF((A1:A52),A1:A5)) =MEDIAN(IF((A1:A52),A1:A5)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
standard deviation | Excel Worksheet Functions | |||
standard deviation | Excel Discussion (Misc queries) | |||
Standard Deviation | Excel Worksheet Functions | |||
Standard Deviation | Excel Worksheet Functions | |||
standard deviation | Excel Discussion (Misc queries) |