Results 1 to 6 of 6

Cumulative Sum

Threaded View

  1. #1
    Registered User
    Join Date
    12-31-2008
    Location
    Brighton, England
    MS-Off Ver
    Excel 2000
    Posts
    3

    Cumulative Sum

    Hopefully my title isn't misleading (or just plain incorrect, its been a while since i did maths).
    Honestly I'm fairly new to excel, but after breezing through the new users forum i belive this question goes a bit beyond that.

    I have, for my formula, 2 constant values a and x, I then also have a variable, n.

    The formula I'm trying to convert into excel terms is

    SIGMA (with respect from 1 upto n) ((1-x)^(1-n) * x)*a

    Unfortunatly thats not drastically inteligable so i've attached a picture file that should explain it in more understandable terms.

    Now the problem im having is, sigma is a cummulative funtion, which in this example is relative to the variable n, firstly I don't know what formulas I would have to use in order to get a sigma/summination function, and secondly I am uncertain of how to link it to a variable range (i would guess along the count, offset side of things?)

    Hopefully something in their is understandable.
    (annoyingly the neater picture I had preped is too large a file to be used, so I had to resort to a scanned pdf, sorry about that)

    Thanks,
    Fraser
    Attached Files Attached Files
    Last edited by Fraser Clark; 12-31-2008 at 07:41 AM. Reason: Grammer

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