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

    Unanswered: Standard deviation calculation


    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
    If you zip the file, then you can attach on this board.
    old, slow, and confused
    but at least I'm inconsistent!

    (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