Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
standard deviation
I am working with daily returns over a period of less than a year that I
would like to annualize. Excel help mentions something about list 1 to 30 in the STDEVP(list). I am assuming I can use more than 30 values or? Also what would calc would I use to annualize the result of STDEVP(list)?? thanks for any help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
standard deviation
ckatz -
(1) STDEVP accepts up to 30 arguments, and each argument can be a range of cells on the worksheet containing many values. (2) I don't know what you mean by "annualize." - Mike http://www.mikemiddleton.com "ckatz" wrote in message ... I am working with daily returns over a period of less than a year that I would like to annualize. Excel help mentions something about list 1 to 30 in the STDEVP(list). I am assuming I can use more than 30 values or? Also what would calc would I use to annualize the result of STDEVP(list)?? thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Standard deviation calculation | Excel Worksheet Functions | |||
simulate values for a given Mean and Standard deviation | Excel Discussion (Misc queries) | |||
Standard deviation - confidence intervals | Excel Worksheet Functions | |||
A question about Standard Deviation | Excel Discussion (Misc queries) | |||
feel that the STANDARD DEVIATION formula on Excel is incorrect !! | Excel Worksheet Functions |