Hi there, not sure if this is the right forum for this post, but anyway, here it goes.
I have a column of historical 5-year returns. For this data I need the standard deviation of the annualized results (that is, the 5-year returns raised to the power of 1/5). Is it possible to do this directly with the Stdev formula in Excel, or do I have to make a separate column for the annualized returns?
Regards
I have a column of historical 5-year returns. For this data I need the standard deviation of the annualized results (that is, the 5-year returns raised to the power of 1/5). Is it possible to do this directly with the Stdev formula in Excel, or do I have to make a separate column for the annualized returns?
Regards
