It has been years since I attempted statistics and I would appreciate any form of help.
I am looking at data, and I want to see if one rate influences another rate. I want to know if two rates are correlated and significance of that correlation. The data looks similar to something like this (made up numbers and ratio names)
A, B, C, D, E, F
City, Officers, Pop, Crimes, Pop/Crime, Pop/Officer,
city1, 50, 50562, 123, 411.07, 1011.24
city2, 100, 250022, 861, …., ….
city3, 76, 100574, 435, …., ….
I would want to find out if more police officers would decrease crime rates. So if smaller pop/officer ratio would increase population/crime.
Or perhaps, a greater officer/pop ratio would decrease crime/pop?
I would like to consider population as a factor for correlation, which is why I am not just testing officers and crimes. I don't know if this is necessary or not.
Anyhow, what test would I use to compare E to F in both correlation and statistical significance?
I sincerely appreciate any and all help.
I am looking at data, and I want to see if one rate influences another rate. I want to know if two rates are correlated and significance of that correlation. The data looks similar to something like this (made up numbers and ratio names)
A, B, C, D, E, F
City, Officers, Pop, Crimes, Pop/Crime, Pop/Officer,
city1, 50, 50562, 123, 411.07, 1011.24
city2, 100, 250022, 861, …., ….
city3, 76, 100574, 435, …., ….
I would want to find out if more police officers would decrease crime rates. So if smaller pop/officer ratio would increase population/crime.
Or perhaps, a greater officer/pop ratio would decrease crime/pop?
I would like to consider population as a factor for correlation, which is why I am not just testing officers and crimes. I don't know if this is necessary or not.
Anyhow, what test would I use to compare E to F in both correlation and statistical significance?
I sincerely appreciate any and all help.