Center of mass

Hi,

I generate a large dataset of X- and Y-coordinates. Togeter, these datapoints form random curves. So, in excel, I want to calculate the Y-coordinate of the center of mass of these datapoints. Can anyone tell me the easiest way to do this?

Thanks!

Suppose you have the ten vertices of a simple (i.e., no crossing edges) polygon in clockwise order in A2:B11

1. Duplicate the first point in A12:B12. Then

2. Area =SUMPRODUCT(A3:A12 - A2:A11, B2:B11 + B3:B12) / 2

3. Cx =SUMPRODUCT(A2:A11 + A3:A12, A3:A12 * B2:B11 - A2:A11 * B3:B12) / 6 / Area

4. Cy =SUMPRODUCT(B2:B11 + B3:B12, B2:B11 * A3:A12 - B3:B12 * A2:A11) / 6 / Area

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes