Predicting correlations for complicated case.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEF
1
abc
2
0.20.30.5r<- plug in a, b, and c here
3
0.040.090.250.38variance
4
0.110.240.66
standardized r²
5
0.320.490.81r<- this returns the predicted correlation with y
6
7
8
ab
9
0.50.5r
<- plug in a, b, and c here
10
0.250.250.5variance
11
0.500.50
standardized r²
12
0.710.71r
<- this returns the predicted correlation with y
13
14
15
Thanks to L.J Zigerell for correcting my math on this in an earlier version.
16
17
18
19
20
Loading...
 
 
 
Sheet1