Real life situation. I have data from different cities saying on average how fast they build a home. I want to correlate this to the amount of construction activity they do & number of homes constructed per construction personnel. I also have data saying total # of construction personnel & total construction cost in respective cities.
I have ran all this in JMP & Excel and am getting a correlation of up to .20, and if I take out outliers I have correlations up to .60.
My question is: how can I get correlation up to .75 or above, if possible?
I am also trying to work with multivariate regression and see if I can get better results.