Focused Decision Making
j_shina05m2_a1_deviation_formula_calculator.xlsx
Sheet1
Pair | X | Y | DevX | DevY | DevX2 | DevY2 | (DevX)(DevY) | ||
1 | |||||||||
2 | |||||||||
3 | |||||||||
4 | |||||||||
5 | |||||||||
6 | |||||||||
7 | |||||||||
8 | |||||||||
9 | |||||||||
10 | |||||||||
0 | 0 | 0 | Sum | ||||||
Correlation | ERROR:#DIV/0! | ||||||||
r Square | |||||||||
t | |||||||||
p(t) | |||||||||
To use this template, enter up to 10 pairs of X, Y observations in the green-shaded data entry area. The template uses the deviation score formula to calculate the correlation coefficient and performs a t test of the significance of the correlation.