Data Geek Challenge IV: TOP 10 foreign recipients of U.S. science and engineering doctorates
This blog helps us to understand which county is the shows topper for the foreign recipients of U.S science and engineering doctorates.
I made below analysis using SAP Lumira Cloud platform to let people know about the top 10 countries who have recipients of doctorates in America.
In the United States of America, a significant proportion of scientists and engineers are foreign-born, as well as students in science and engineering programs. As of 2011, 28% of graduate students in science, engineering, and health are foreign. So using SAP Lumira application, I have generated some graphical representations which show top 10 countries receiving the science and engineering doctorates ranked by National Survey on R&D resources by DST, New Delhi, and Government of India.
I have taken the data from below site latest by 17th December 2014:
SAP Lumira helped me to find out the answer for below question:
1. Which country is leading in receiving total number of degrees?
2. Who all are what position in receiving the doctorate degree from U.S?
Ranking 1 (China):
No of Doctorates 57705 and the percentage against total 25.8
Ranking 2 (India):
No of Doctorates 24809 and the percentage against total 11.1
Ranking 3 (South Korea):
No of Doctorates 21846 and the percentage against total 9.8
Ranking 4 (Taiwan):
No of Doctorates 17848 and the percentage against total 8
Ranking 5 (Canada):
No of Doctorates 7193 and the percentage total 3.2
Ranking 6 (Turkey):
No of Doctorates 5391 and the percentage against total 2.4
Ranking 7 (Thailand):
No of Doctorates 4003 and the percentage against total 1.8
Ranking 8 (Japan):
No of Doctorates 3806 and the percentage against total 1.7
Ranking 9 (Mexico):
No of Doctorates 3589 and the percentage against total 1.6
Ranking 10 (Germany):
No of Doctorates 3584 and the percentage against total 1.6
I have done the 3D column chart analysis under the Bar chart an option which shows the number of doctorate on Y axis received against the countries on X axis.
In the visualization of Pie chart, China is leading in getting the doctorate degrees from U.S.
In SAP Lumira Cloud Analysis, there are some visualization options that can be used, of course, according to the analytical model that wants to do. This is very helpful in getting information fast.
In below screenshot I have used other charts visualization with the Tag cloud.
Here for this I have used radar chart from the option other charts for visualization.
In other charts visualizations options Funnel chart option is available. In Funnel chart at top level it shows the highest number of degrees received by.
Below screenshot shows the waterfall chart analysis which is available under the other charts options.
In below screenshot I have used line charts visualization option with sub option as Combined Stacked Line chart. Here also we can see clearly China is one 1st position.
Format the data is presented as the table below, the Country name is very helpful for determining the position of a country.
The increase in non-citizen assistant professors of engineering is the result of the fact that, in recent years, foreign-born engineers received close to 50 percent of newly awarded engineering doctorates (naturalized citizens accounted for about 4 percent) and, furthermore, they entered academe in disproportionately large numbers. 33% of all U.S. Ph.D.s in science and engineering are now awarded to foreign born graduate students.
I hope this blog helps you all with inspiration in processing raw data with fun.