I need the two elements with the greatest volume in a data set

Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
5 replies · 2K views
tunage
Messages
4
Reaction score
0
I have very large data sets:
coins & amount
i.e. {10 & 11, 9 & 7, 8 & 9, 4 & 5, 3 & 1} graphed would show greater volume to the left side while {1 & 0, 2 & 3, 2 & 1, 4 & 6, 9 & 10} would reflect greater volume on the right, and {1 & 4, 2 & 3, 12 & 10, 4 & 4, 3 & 2} would reflect a surge in the middle of the data set.
I need to calculate the volume and know the location of the two elements that have the greatest volume.
 
Physics news on Phys.org
tunage said:
I have very large data sets:
coins & amount
i.e. {10 & 11, 9 & 7, 8 & 9, 4 & 5, 3 & 1} graphed would show greater volume to the left side while {1 & 0, 2 & 3, 2 & 1, 4 & 6, 9 & 10} would reflect greater volume on the right, and {1 & 4, 2 & 3, 12 & 10, 4 & 4, 3 & 2} would reflect a surge in the middle of the data set.
I need to calculate the volume and know the location of the two elements that have the greatest volume.

If I understand your requirements correctly I think the following would be OK.

For the first set $\frac{1\times 10\times 11+2\times 9\times 7+3\times 8\times 9+4\times 4\times 5+5\times 3\times 1}{ 10\times 11+9\times 7+8\times 9+4\times 5+3\times 1}=2.04..$

The 2.04 indicates your "greater volume to the left side".

This may be of interest: http://archives.math.utk.edu/visual.calculus/5/work.2/
 
M R said:
If I understand your requirements correctly I think the following would be OK.

For the first set $\frac{1\times 10\times 11+2\times 9\times 7+3\times 8\times 9+4\times 4\times 5+5\times 3\times 1}{ 10\times 11+9\times 7+8\times 9+4\times 5+3\times 1}=2.04..$

The 2.04 indicates your "greater volume to the left side".

This may be of interest: http://archives.math.utk.edu/visual.calculus/5/work.2/

Thank you for your response.
I tried it with the 3rd example and I don't see where it would help.
--> (1*1*4+2*2*3+3*12*10+4*4*4+5*3*2)/(1*4+2*3+12*10+4*4+3*2)
ans =
3.0921
But more importantly I need the element location.
Yes, I am pretty sure I need an integral or a summation for the volume but I think I am going to need quadratics for my second max and probably my first.
 
Last edited:
tunage said:
Thank you for your response.
I tried it with the 3rd example and I don't see where it would help.
--> (1*1*4+2*2*3+3*12*10+4*4*4+5*3*2)/(1*4+2*3+12*10+4*4+3*2)
ans =
3.0921
But more importantly I need the element location.
Yes, I am pretty sure I need an integral or a summation for the volume but I think I am going to need quadratics for my second max and probably my first.

If your locations are 1,2,3,4 and 5 then a result of 3.09 is pretty much your "surge in the middle".

Still, I'm not sure that what I'm suggesting is what you need.
 
M R said:
If your locations are 1,2,3,4 and 5 then a result of 3.09 is pretty much your "surge in the middle".

Still, I'm not sure that what I'm suggesting is what you need.

That is a very interesting math hack.
I am running some test on it now.
 
tunage said:
That is a very interesting math hack.
I am running some test on it now.
Works perfect. It does everything I need it to do. I don't even need the second max because of how the numbers work.

Thank you VERY much!

I think I remember seeing this back in Physics.