| Author |
 Topic  |
|
|
DerekK
USA
14 Posts |
 Posted - 02/17/2016 : 1:50:44 PM
|
Hi
I am looking for a simple way (built-in graph or function, column formula, or script) to do the following...
I have 2 columns (XY data). X is the list of "bins" (integers, already in ascending order). Y are values. I would like to get the sum of the values in each bin (the sums of Y values that have the same X value). I tried the "2D Freq Count/Binning" but it did not do what I wanted. This is like a histogram, but instead of count, I need sum.
Thanks for the help!
-Derek
Origin Ver. and Service Release (Select Help-->About Origin): 2015 sr2
Operating System: win 7 |
|
|
snowli
USA
1390 Posts |
Posted - 02/17/2016 : 2:21:35 PM
|
You can highlight Y data and choose Analysis: Data Manipulation: Reduce Duplicated X.
There are many statistics of Y to choose from, mean, median, sum, max, sd, se, RMS.
Thanks, Snow |
 |
|
|
DerekK
USA
14 Posts |
Posted - 02/17/2016 : 2:39:07 PM
|
Snow
That works! Thanks, Derek |
|
|
| |
Topic |
|
|
|
Sum of "binned" data