"Bi thing" three data analysis series--Shuhan five tigers will and Wei thrombosis will force analysis, Absolute Classic analysis

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.