Given my data and assuming 260 trading days per year, what are the annualized standard deviations appropriate for assessing the risk on a 1 year investment. "I have a spreadsheet with historical data".
Given my data and assuming 260 trading days per year, what are the annualized standard deviations appropriate for assessing the risk on a 1 year investment. "I have a spreadsheet with historical data".
You can use STDEV for the same. The syntax for the same is STDEV (number1, number2, ...). Number1, number2, ... are 1 to 30 number arguments corresponding to a sample of a population. You can also use a single array or a reference to an array instead of arguments separated by semicolons. STDEV of the hypothesis that the arguments represent a sample of a population. If your data represents the total population, use STDEVP to calculate the standard deviation.
Look the formula is: = STDEV (GO HERE DETAILS OF THE COLUMN OR ROW INSERT YOU WANT THE DEVIATION) . You can select it directly with the mouse.
Bookmarks