Results 1 to 9 of 9

Excel 2007 : Standard Deviation

Threaded View

King_Junior Standard Deviation 09-16-2009, 06:32 AM
Palmetto Re: Standard Deviation 09-16-2009, 08:11 AM
King_Junior Re: Standard Deviation 09-16-2009, 03:25 PM
Palmetto Re: Standard Deviation 09-16-2009, 04:09 PM
King_Junior Re: Standard Deviation 09-16-2009, 11:43 PM
  1. #1
    Registered User
    Join Date
    09-16-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    9

    Standard Deviation

    I have a range of share prices of particular company's stock and I have calculated Standard Deviation for daily return for a given period.

    In order to find out how many times share prices during this period moved
    1. More than 3 SD
    2. Less than 3SD but more thatn 2 SD
    3. Less than 2 SD but more than 1 SD

    Could some help me setting the correct formulae for to find the answers using excel 2007
    Attached Files Attached Files
    Last edited by King_Junior; 09-18-2009 at 04:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1