07-07-2017, 04:51 PM
(This post was last modified: 07-07-2017, 04:58 PM by timeconsumer.)
(07-07-2017, 05:39 PM)7hawk77 Wrote: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.
I'm a big fan of the regression analysis. The output will give you the r-squared value which tells you how much variance in the dependent variable can be explained by the independent variable(s).
Then you can check your ANOVA table underneath that to see the Significance F value to check the statistical significance of the whole test (and the associated r2).
Then finally your coefficients table gives you the p-value for each attribute while also showing you a coefficient attempting to explain what an increase of 1 in x does to y.
But here's the big issue with a pearson correlation and a regression (and most other tests we would use as amateurs) they rely on continuous data. And with my understanding of this sim attributes and their affect on the player are not continuous. This means that going from 70 to 80 strength does not give as much of a benefit as going from 90 to 100 strength. So instead we have to weight our attributes to account for this. I have a method of weighting that I use, and it's working okay for me, but unfortunately it's secret Otter property. Play around with weighting it, you might get a better system than me.
![[Image: XSfVUgo.png]](https://i.imgur.com/XSfVUgo.png)
Hank Winchester (S25 - Current) - Scrub
Angus Winchester (S1-S12) - 4x Ultimus Champ - #2 Career Sacks - Hall of Fame
Cooter Bigsby (S14-S23) - S23 Ultimus Champ - #4 Career Yards - #4 Career TDs - 2x MVP - Hall of Fame