Quantitative Methods for Accounting & Finance - Accounting Assignment Help

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.

This Accounting Assignment has been solved by our Accounting Experts at Exam Question Bank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.