If I have X,Y data how do I sum the Y values using a set of bins based on x values
 

I have a complex (x,y) data set equivalent to this simplified example:

Years Experience (x) vs. Workhours (y)
1.3, 7
4.0, 6
4.2, 9
4.5, 3
5.0, 9
5.5, 3
7.1, 3
9.5, 18

I want to produce a set of Experience data bins where the total number
of workhours is calculated within each Experience bin, for example:

1, 7
2, 0
3, 0
4, 18 (Sum of y values when x is between 4 and 5)
5, 12 (Sum y values when x is between 5 and 6)
6, 0
7, 3
8, 0
9, 18


Any help would be greatly appreciated.

Scott


--
ScottBerger
------------------------------------------------------------------------
ScottBerger's Profile: http://www.excelforum.com/member.php...o&userid=16553
View this thread: http://www.excelforum.com/showthread...hreadid=314100

I would try a Pivot Table with Grouping.

On Tue, 16 Nov 2004 17:35:12 -0600, ScottBerger
wrote:


I have a complex (x,y) data set equivalent to this simplified example:

Years Experience (x) vs. Workhours (y)
1.3, 7
4.0, 6
4.2, 9
4.5, 3
5.0, 9
5.5, 3
7.1, 3
9.5, 18

I want to produce a set of Experience data bins where the total number
of workhours is calculated within each Experience bin, for example:

1, 7
2, 0
3, 0
4, 18 (Sum of y values when x is between 4 and 5)
5, 12 (Sum y values when x is between 5 and 6)
6, 0
7, 3
8, 0
9, 18


Any help would be greatly appreciated.

Scott