Quantitative Methods for Accounting & Finance
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.
