Results 1 to 3 of 3

Thread: Need help to Annualize a standard deviation in Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    120

    Need help to Annualize a standard deviation in Excel

    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".

  2. #2
    Join Date
    Jun 2011
    Posts
    487

    Re: Need help to Annualize a standard deviation in Excel

    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.

  3. #3
    Join Date
    Jun 2011
    Posts
    798

    Re: Need help to Annualize a standard deviation in Excel

    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.

Similar Threads

  1. How to permanently change standard defaults in Excel
    By Quaker Mike in forum MS Office Support
    Replies: 2
    Last Post: 28-01-2012, 07:46 PM
  2. Replies: 4
    Last Post: 24-01-2012, 05:06 PM
  3. Replies: 4
    Last Post: 24-01-2012, 02:10 PM
  4. Replies: 4
    Last Post: 05-01-2012, 04:40 PM
  5. Excel - Home Edition vs Standard
    By Duncan McC in forum MS Office Support
    Replies: 3
    Last Post: 28-01-2011, 12:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,580,074.95812 seconds with 17 queries