Date: August 25th, 2025 12:53 PM
Author: Golf
get crime stats by zip code then something like this to cluster them:
=69.1673982565353*COS(F3*0.0174532925199433)
=MIN(SQRT(ABS((F3-'Cluster Centers'!$I$3:$I$2259)*69)^2+ABS((G3-'Cluster Centers'!$J$3:$J$2259)*H3)^2))
=INDEX('Cluster Centers'!$G$3:$J$2259,MATCH(M5,SQRT(ABS((F5-'Cluster Centers'!$I$3:$I$2259)*69)^2+ABS((G5-'Cluster Centers'!$J$3:$J$2259)*H5)^2),0),MATCH("Revised Cluster",'Cluster Centers'!$G$2:$J$2,0))
(http://www.autoadmit.com/thread.php?thread_id=5766040&forum_id=2#49211282)