+ Reply to Thread
Results 1 to 3 of 3

Cumulative Frequency error uncertainty

  1. #1
    Registered User
    Join Date
    05-28-2019
    Location
    Edinburgh
    MS-Off Ver
    2013
    Posts
    92

    Cumulative Frequency error uncertainty

    Hi Guys,
    Ive got a list of numbers and im trying to fund the uncertainty. Im having trouble writing the code. If the column had the values A, B, C, D .... The value to the right of A would equal A. The value to the right of B = sqrt(A^2 +B^2), the value to the right of C = sqrt(A^2 +B^2 + C^2) and so on. Can someone help me to do this. Heres what I have so far:

    Please Login or Register  to view this content.
    Last edited by alansidman; 03-18-2020 at 04:48 AM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,719

    Re: Cumulative Frequency error uncertainty

    Perhaps a formula based proposal will help:
    Paste the following into cell C3: =SQRT(SUMPRODUCT(($A3:B3)*($A3:B3)))
    Drag the fill handle to the right.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,644

    Re: Cumulative Frequency error uncertainty

    Quote Originally Posted by jpe1 View Post
    If the column had the values A, B, C, D
    The value to the right of A would equal A.
    The value to the right of B = sqrt(A^2 +B^2),
    the value to the right of C = sqrt(A^2 +B^2 + C^2) and so on
    I am having difficulty reconciling your abstract description with the VBA code snippet that starts with N12.

    Why not describe what you want with actual cell references, starting with M12(?) instead "A"?

    Your code snippet does the following:

    $N$12 = ($M$12^2 + $N$11^2)^0.5
    $N$13 = ($M$13^2 + $N$12^2)^0.5
    $N$14 = ($M$14^2 + $N$13^2)^0.5
    [...etc...]

    Nothing like SQRT(A^2 + B^2 + C^2 +...), as I (mis?)understand your description.

    I wonder if the following does what you want, using Excel instead of VBA. (Do you need a VBA implementation?)

    Enter the following formula into N12 ("to the right of" M12) and copy N12 into N13, N14, etc ("to the right of" M13, M14, etc):

    =SQRT(SUMSQ($M$12:M12))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 02-22-2013, 06:41 AM
  2. Desire Cumulative Frequency
    By Mut in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-28-2009, 01:34 AM
  3. Cumulative frequency formula???
    By kev_newc123 in forum Excel General
    Replies: 1
    Last Post: 07-23-2008, 07:00 AM
  4. Cumulative frequency
    By mattsgr1 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-02-2007, 08:25 PM
  5. [SOLVED] How do I create a more than cumulative frequency polygon ?
    By yahoo in forum Excel General
    Replies: 1
    Last Post: 05-22-2006, 03:15 PM
  6. [SOLVED] How do I do a cumulative frequency graph?
    By ted in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-03-2006, 08:10 PM
  7. How to draw cumulative frequency curve in Excel
    By Alvin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-23-2005, 07:06 PM
  8. Cumulative Frequency
    By Chris Grant in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-03-2005, 02:06 AM

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