Out of curiosity, I wanted to know where the average CR4 member is from. It would have been a bit much to analyze every individual, so I took data from the list of member countries. I've taken just a few liberties with how I crunched the numbers ; Location has been taken as the capital for each country. Longitude and Latitude have been rounded up. Since the earth is somewhat inconveniently flattened, I've treated it as a sphere.
First off, you can't simply average the longitudes – for instance, people in Siberia and Canada would end up averaged as living on about 0 degree longitude. Hence I've extrapolated the locations into Cartesian form. The origin is the centre of the Earth, X is Eastward, Y is Northward, and Z is towards zero latitude and zero longitude.
To reflect the number within each country, I've weighted the co-ordinates. In effect working out the 'centre of gravity' (not that there's much gravity in this subject yet….).
My end results (columns I,J,K) would seem to place the average person in Mali.
If there are any glaring errors in country locations or members/numbers, I'll adjust it. For now, can anyone see a better way of finding the average location ?
Before you interpret this as confirmation that I've completely taken leave of my senses, I'll tease you a little. Since the largest groupings are America and India, I may develop this to find out where the 2 highest concentrations of members are. Think of it like drawing a contour map of member density. Ultimately, it's not really about where CR4 members are. More to do with finding clusters on a sphere. I may elaborate on that later. For now, I'd just like to see what folk think of how the data has been analyzed. Is it fair/representative as an 'average'.


Not sure if that table is clear enough, but the final weighted XYZ values are ; 0.20947947,0.306286, 0.274203. End result ; Latitude 20.63123, Longitude -0.-3381.That's somewhere in Mali.
(note - the final co-ordinates are within the Earth, so some Pythagorean juggling is needed to extrapolate onto the Earths 'spherical' surface as latitude/longitude)
I shall run and hide whilst the onslaught begins................
Comments rated to be Good Answers:
Comments rated to be "almost" Good Answers: