07-07-2017, 04:47 PM
(This post was last modified: 07-07-2017, 04:48 PM by Molarpistols.)
(07-07-2017, 04: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.
Under the data analysis tool you could run a regression that'll give you a separate p-value for each variable (agi/str/etc/etc). It'll also give you a p-value for the entire relationship, as well as F-values and r^2. It likely won't tell you much unless you have quite a large data set for each variable however.
If you can't find the regression in the data analysis tool, you may have to download it by going into Excel->Options->Add-ins
[div align=center]
Gus T.T. Showbiz Player Page
Gus T.T. Showbiz Update Page
[div align=center]
[div align=center]
Bavitz Player Page Bavitz Update Page
Gus T.T. Showbiz Player Page
Gus T.T. Showbiz Update Page
[div align=center]
[div align=center]
Bavitz Player Page Bavitz Update Page