Assignment Task
ANALYSIS
- You are going to analyse a dataset on the past winners of the Nobel Prize. Let’s see what patterns you can uncover in the past Nobel Laureates and what can we learn about the Nobel prize and our world generally. The data are in an excel file named “nobel_prize_data”. The file includes:
- birth_date: date in string format.
- motivation: description of what the prize is for.
- prize_share: given as a fraction.
- laureate_type: individual or organisation.
- birth_country: has countries that no longer exist.
- birth_country_current: current name of the country where the birth city is located
- ISO: three-letter international country code.
- organization_name: research institute where the discovery was made.
- organization_city: location of the institution.
QUESTIONS
Part 1:
1. What percentage of the Nobel laureates were women? Construct a pie chart which shows how many prizes went to men compared to how many prizes went to women. Present your findings. 2. How many prizes were given out in each category? Construct a vertical bar chart which shows how many prizes awarded by category. Present your findings. Which category has the most number of prizes awarded? Which category has the fewest number of prizes awarded? Construct a vertical bar chart that shows the split between men and women by category.
Part 2:
1.Construct a horizontal bar chart which shows how many prizes awarded by country (only top 20 countries are needed). Is it best to use birth_country or birth_country_current? What are some potential problems when using birth_country? Construct a cross-classification table of prizes between category and country. Plot a vertical bar chart of prizes (Y variable) and category (X variable), then group the bar charts of category for top 6 countries and comment on the relationship between category and country. In which category does Germany have more prizes than the UK? In which categories does France have more prizes than Germany? In which category are Germany and Japan the weakest compared to the United States? 2. Calculate the age of the laureate in the year of the ceremony. What are the names of the youngest and oldest Nobel Laureate? What did they win the prize for? What is the average age of a winner? 75% of laureates are younger than what age when they received the prize? Investigate the prizes by country over time. Using a histogram to present the distribution of laureate age at the time of wining and number of prizes per age interval.
A-Plus Writing Help For University Students
Get expert assistance in any academic field. All courses and programs covered.
Get Help Now!Welcome to our Online Essay Writing Agency. Securing higher grades costing your pocket? Order your assignment online at the lowest price now! Our online essay writers are able to provide high-quality assignment help within your deadline. With our homework writing company, you can order essays, term papers, research papers, capstone projects, movie review, presentation, annotated bibliography, reaction paper, research proposal, discussion, or another assignment without having to worry about its originality – we offer 100% original content written completely from scratch
We write papers within your selected deadline. Just share the instructions


