| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | a | b | c | |||
2 | 0.2 | 0.3 | 0.5 | r | <- plug in a, b, and c here | |
3 | 0.04 | 0.09 | 0.25 | 0.38 | r² | variance |
4 | 0.11 | 0.24 | 0.66 | standardized r² | ||
5 | 0.32 | 0.49 | 0.81 | r | <- this returns the predicted correlation with y | |
6 | ||||||
7 | ||||||
8 | a | b | ||||
9 | 0.5 | 0.5 | r | <- plug in a, b, and c here | ||
10 | 0.25 | 0.25 | 0.5 | r² | variance | |
11 | 0.50 | 0.50 | standardized r² | |||
12 | 0.71 | 0.71 | r | <- 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 |