Original: "Bi thing" three data analysis series--Shuhan five tigers will be with Wei thrombosis will force analysis, Absolute Classic analysis
Dedicated to the vast number of the three enthusiasts, hope to like the three countries friends to discuss, deepen the legend of the three times of understanding
Basic concepts of data analysis:
Centralized trend analysis refers to the situation where the measurement data is concentrated on a point in a large number of measurement data distributions.
overall (population) refers to the existence of an objective, and in the same nature on the basis of a combination of many individual units of the whole, that has a certain characteristic of a class of things, also known as the mother or the whole domain. Simply put, the total is the sum of the same individuals we are studying, denoted by the symbol N.
Sample refers to a subset of individuals drawn from the population. The number of individuals included in the sample is called the sample capacity or content, denoted by the symbol N.
The difference between standard deviation and variance : From the formula can be clearly seen that the variance is the square of the standard deviation, the rest is identical.
The difference between them is that the standard deviation exists in the original unit, and the variance is in square units.
Establish a readiness analysis environment:
Shuhan Five Tiger Admiral, refers to Luo Guan in the novel "Kingdoms", Shu Hanzhaoli Emperor Liu Bei under five members of the Reggie, respectively: Guan Yu, Zhang Fei, Zhao Yun, Ma Chao, Jack Huang. The original description is "Five Tigers general", posterity repetitive "five Tigers admiral".
SELECT * from FactSanguo11 WHERE inch (n ' Guan Yu ', n' Zhang Fei ', n' Zhao Yun ' , n' ma Chao ', n' Jack Huang ' )
Guan Yu, Zhang Fei, Zhao Yun, Ma Chao, Jack Huang Force value: 97,98,96,97,93
Analysis Process:
Verify the analysis results:
SELECT AVG([Armed Forces]) asmean value,VARP([Armed Forces]) aspopulation Variance,VAR([Armed Forces]) asSample Variance,STDEVP([Armed Forces]) asoverall standard deviation,STDEV([Armed Forces]) asSample Standard deviation fromFactSanguo11WHERENameinch(N'Guan Yu'N'Zhang Fei'N'Zhao Yun'N'Ma Chao'N'Jack Huang')
Wei Wu Zi Generals
Five thrombosis will refer to the Three Kingdoms period, the Cao Wei forces of the five generals, that is, former general Zhang Liao, right General Lok Jin, left general in Ban, Levy West car general Zhang Yi and right General Xu Akira.
Chen Shou compose Wei Shu volume 17 o'clock, will this five people to preach, narrates the life deeds after the evaluation Yue: "The founder Jianz Martial arts, and when the generals, five sons first", so modern people call it "five sons generals" or "Wei five sons."
SELECT * from FactSanguo11 WHERE inch (n ' Zhang Liao ', n' Lok Jin ', n' Forbidden ') , n' Zhang Yi ', n' xu Akira ' )
Zhang Liao, le Jin, Ban, Zhang Yi, Xu Hoang Force value: 92,84,78,89,90
Analysis Process:
Verify the analysis results:
SELECT AVG([Armed Forces]) asmean value,VARP([Armed Forces]) aspopulation Variance,VAR([Armed Forces]) asSample Variance,STDEVP([Armed Forces]) asoverall standard deviation,STDEV([Armed Forces]) asSample Standard deviation fromFactSanguo11WHERENameinch(N'Zhang Liao'N'Lok Jin'N'to Ban'N'Zhang Yi'N'Xu Akira')
Analysis Conclusion:
|
Shuhan, Admiral of the Five Tigers |
Wei Wu Zi Generals |
1 mean value |
96.2 |
86.6 |
2 Middle Digits |
97 |
89 |
3 Public numbers |
97 |
- |
4 Maximum |
98 |
92 |
5 min |
93 |
78 |
6 Very poor |
5 |
14 |
7 Population Variance |
2.96 |
25.44 |
8 General Standard Deviation |
1.72 |
5.04 |
9 Sample Variance |
3.7 |
31.80 |
10 Sample Standard deviation |
1.92 |
5.64 |
CV (sample) |
1.9958% CV (sample) = (1.92/96.2) *100%=1.9958% |
6.5127% CV (sample) = (5.64/86.6) *100%=6.5127% |
Appendix: Shuhan Five Tigers admiral, Wei Thrombosis will be with map
"Bi thing" three data analysis series--Shuhan five tigers will and Wei thrombosis will force analysis, Absolute Classic analysis