Hello All,

Wondering if someone of you might please be able to help?

If you consider a full matrix of data as below but if it continued to cover a grid of 100 by 100

(1;3) (2;3) (3:3)
(1:2) (2,1) (2;2)
(1;1) (2;1) (3;1)

If I have the Weighted average of all the points in that matric and then plot that average in the matrix itself - I'm trying to know if its possible (and how) to group all points/items etc. that call on either side of the slopes... Hopefully the image attached helps explain. (???)

Matrix data.JPG

Each of the tiny blue data points are coordinates of the matrix - and since its on a standard Cartesian plane... I have the slopes etc. I have been trying to group the coordinates that would fall within the area of A and B based on slopes and angles of intersection etc. - but there are instances where the process I've developed labels coordinates that fall into area B - under the naming of Area A.

Any ideas of was to solves this would tremendous as I've been at this for what seems like a 100 man hours now and still keep running into issues.

A final mention - my goal is to achieve this process on a 2x2 grid (so 4 quadrants and each quadrant is further divided by the lines of the quadrants weighted average (visually shown as the larger blue circles in the images). Each coordinate in the grid matrix is at an internal of 0.01. Mentioning this, as the top right quadrant has negative slopes that I've struggled to work around.

XY scatter matrix.JPG

Any help - would be ever so grateful!

Thank you for the time and for even reading and trying to understand my explanation.

Thanks,