The summary data is the total number of members who entered the six QQ groups of the Surveyor's Palace as of 12 noon on August 6, 2018, and the total number of members in the six groups was 11,524. After deduplication and deletion of personnel from non-standard provinces After that, we obtained 7006 member data. (The data of the province where the member is located is based on the nickname data written by the member himself. This data relates to 31 provinces, autonomous regions, and municipalities in the country. Data from Hong Kong, Macao, and Taiwan are not included.)
Into the Hall of Surveyors
After finishing, you can get the table. From the table, you can see that due to population, economic development, and other reasons, the provinces of registered surveyors surveyed and tested by different provinces are relatively large. The smallest number is Tibet, with only four. The largest number is 648 in Shandong, accounting for nearly 10% of the total. The number of provinces with the most test takers in each province is 162 times the number of people with the least number of provinces! !! !!
In order to further discover the enthusiasm of candidates from various provinces for taking the survey of registered surveyors, I have compiled the resident population of each province at the end of 2016, as shown below:
Based on the ranking table of the number of members of each province of the QQ group, I have summarized the changes in the ranking of each province based on the population of each province at the end of 2016, as shown below:
From the above figure, we can see that relative population, the largest increase in the number of candidates is Gansu, up 22, and the largest decline in the number of candidates is Guangxi, down 9.
From the above picture, we have less intuitive information. I analyzed the data and designed a formula:
∆ = Proportion of Candidates by Province / Percent of Population by Province-1
If ∆ is positive, candidates in the province are more motivated than the national level;
If ∆ is negative, candidates in the province are less motivated than the national level.
The following icons are calculated:
It can be seen from the above figure that the enthusiasm of 13 provinces is positive, and the candidates in Beijing have the highest positivity, followed by Zhejiang;
16 provinces with negative enthusiasm, Tibet with the lowest enthusiasm, and Hunan, Guizhou, Guangdong, and Guangxi;
Disclaimer: The statistics may not be accurate enough, just for reference only!