A

data

B

Data_area

C

group

particular group or interval

D

Bins_area

The max of the group

E

Frequency

Count of the group

F

Relative Frequency (%)

G

Cumulative Frequency

H

Relative Cumulative Frequency(%)

I

amount

Total frequency

K

Mean

Average(A)

average

L

Median

Median(A)

median

M

Deviation

Avedev(A)

absolute deviations from the mean

N

Variance

Var (A)

ΣM²/I-1

It describes how far values lie from the mean

O

Standard

Deviation

Stdevp(A)

√(ΣM²/I) or √N

How much variation there is from the

"average".

↑spread out↑

↓àclose to the mean

P

Coefficient of Variation

The percentage of O

O/K

Q

Standard Score

Standardize(A,H,L)

(A-K)/O

how many standard deviations an observation or datum is above or below the mean

↓àclose to the mean

R

Deviation Score

Q*10+50

S

Pareto Analysis

            order data

            count Cumulative Frequency

            draw histogram

  x axisàitem

  y axisà$$

  2th yaxisàF

T

Scatter gram

x axisàreason X1

y axisàresult Y

show the relation between Y and X1

if the data trend to become a line, they have strong relations

U

Covariance

Covar(X1,Y)

how much two variables change together

V

Coefficient of Correlation

CORREL(X1,Y)

U/X1’O * Y’O

The relationship between the two samples