Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Unanswered: Standard deviation calculation

    Hello,

    I have a spreadsheet with four columns: session number, session length in hours, gain/loss for the session, and gain/loss per hour for the session. The session range in length from 0.25 to 3.00 hours.

    I would like two additional columns that show gain/loss per hour for the last five hours and gain/loss standard deviation for the last five hours. The problem is there is a different session length in hours for each session, so the formula (script?) would need to be able to determine which of the last few sessions and portion of a session to include to comprise five hours and make the calculation accordingly.

    If it helps I will gladly e-mail sample data as an .xls file to anyone interested. Any help would be greatly appreciated.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    If you zip the file, then you can attach on this board.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •