ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Download and open in Excel to use the formulas!
2
Enter values in GREY boxes; answer(s) will appear in GREEN boxes.
3
4
5
Cutoff Scores for Outliers
6
Q1Q3IQR
Lower Cutoff
Upper Cutoff
7
000
8
9
10
Standard Error for a Categorical Variable
11
pN(1-p)SE
12
1#DIV/0!
13
^ p should be proportion (0-1), not percentage (0-100)
14
15
16
95% Confidence Interval
17
M or %SECI (lower)CI (upper)
18
00
19
^ Use mean for continuous variables; use % for categorical variables.
20
21
22
Skewness Test (Skew/SE)
23
Skewness
SE
Skew/SE
24
#DIV/0!
25
^ If Skew/SE is between -3 and +3, there is not problematic skewness.
26
27
28
Phi Coefficient and 95% Confidence Interval
29
χ²NφCI (lower)CI (upper)
30
#DIV/0!#DIV/0!#DIV/0!
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100