(07-07-2017, 03:27 PM)timeconsumer Wrote:You're off to a good start. If you want to go a little more in-depth I would examine your p-values to see if the relationship you are seeing with the correlation coefficient is considered significant. If you return a correlation with a p-value of something like 0.5 you're probably looking at a bunch of statistical noises. But if you see a p-value of 0.1 to 0.01 you could be on to something.
Also when it comes to correlation coefficients just because it's positive doesn't necessarily mean much. So when you found a coefficient of 0.16 for blocking it really didn't mean anything. 0 means absolutely no linear relationship at all and 1 means a completely linear relationship so if you look at the picture here:
You can see that 0.16 is basically a big blob. But finding something like a 0.5 or 0.6 (strength) is a good start if you have it associated with a significant p-value, and something you can definitely formulate a conclusion off of.
(disclaimer: not a statistician by any means, but I dabble)
I gotcha. So some of my conclusions might still be right, but instead of me guessing at the statistical significance, I can use P-Values to determine that. I'll try and figure out how to calculate P-values on the above data when I find some time. Also, is there a simple way to do that in excel? I ended up using the data analysis to do an F-Test on Two sample for Variances but I think I just confused myself a bit.