MT1 Equations Flashcards
1
Q
Range
A
= highest – lowest
Max-Min
2
Q
IQR
A
Q3 – Q1
(Q3 = 3rd quartile = 75th percentile)
=PERCENTILE(range,%)
3
Q
Deviation
A
(x – mean)
4
Q
Squared deviation
A
(x – mean)^2
5
Q
Sum of squared deviation
A
=Σ(x – mean)^2
=DEVQ.S(range)
6
Q
Sample variance
A
S^2=(x-men)^2/n-1
=VAR.S(range)
7
Q
Coefficient of variation
A
standard deviation/mean
8
Q
Z-score
A
z=x-mean/standard deviation
9
Q
Correlation coefficient
A
Rxy=Sxy/SxSy Rxy= corelation coeffienct Sxy= Covariance Sx standard deviation x Sy= standard deviation y =CORELL(range1,range2)
10
Q
Covariance
A
Sxy=(x-mean X)(y-mean Y)/n-1
=COVARIANCE.S(range1,range2)
11
Q
Standard deviation
A
= square root of variance
=SQRT(variance)
=STDEV.S(range)
12
Q
Frequency
A
=COUNTIF(range,#)
13
Q
Relative Frequency
A
=frequency/$$total
14
Q
Cumulative Relative Frequency
A
=relatrive frequency-previouse cumulative relative frequency
15
Q
Regression analysis
A
y=B0+B1x+e
B0=intercept
B1=slope/marginal effect/regression coeffient
