The Excel data is here: https://docs.google.com/spreadsheets/d/1vgLaFIr_ZGk5KuW0Xy-PAPIBRYzltDTX/edit?amp;ouid=110467223272557658393#gid=1281264908

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:

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 greatest 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.