Long long long time ago, I had studied but forgotten totally 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) | ΣM2/I-1 It describes how far values lie from the mean | O | Standard Deviation Stdevp(A)
| √(ΣM2/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 |
|