Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Next of my questions while I work through some brainstorming today
is this: I have (for stocks' daily historical data) a column of highs and a column of lows. I want to know the standard deviation of the day's range. I know I can create a new column, e.g., "X", that contains each day's range (high minus low). Then I could just do STDEV(X:X). But I'd rather not create the column if I don't need to. Is there an easy way to do this? Thanks for more good insight from a great group. -- dman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need formula - Any ideas**** | Excel Discussion (Misc queries) | |||
ANY IDEAS FOR A FORMULA TO KEEP A TEAM BOWLING SCORE | Excel Discussion (Misc queries) | |||
Using today formula for a template | Excel Discussion (Misc queries) | |||
formula - Age today | Excel Worksheet Functions | |||
formula from Excel97 doesn't work in Excel2003,any ideas why? | Excel Worksheet Functions |