Task
Nobel Prize Data
Structure of the assignment:
1) Executive Summary This section include:
A-Plus Writing Help For University Students
Get expert assistance in any academic field. All courses and programs covered.
Get Help Now!- the primary purpose of the study
- the general methodology used
- the significant findings of each section and general conclusions
- recommendations.
2) Table of Contents with page numbers
3) Business Problem which is restatement of the primary purpose in business language.
4) Statistical problem includes methods you have used to do your analysis.
5) Analysis: This section should present the answers to all the questions.
6) General Conclusion: This section should briefly review and summarize the inference(s). Also indicate the limitations of the results and your recommendations for action (based on what you have found in your study). In other words, give an overall conclusion which combine all the questions.
Analyses
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.
Part 3:
Answer the following hypothesis questions:
1. How does the winning age at different categories? Calculate the Mean, Median, Mode, Standard Deviation and Coefficient of Variation of winning age for different category. Compare the figures and explain that what conclusions you can draw from these analyses? Draw a box and Whisker plot for each category and comment on the shape of the graph.
2. Determine if average age for Physics is less than average age for Chemistry. Compare the result with question 1. Does the result confirm your previous findings? (Follow the hypothesis testing steps, 0.05 level of significance, assuming “equal variances” of populations).
3. To get a more complete picture, we should look at how the age of winners have changed over time. Using a line chart to present the age of the winner (Y variable on vertical axis) and year (X variable, horizontal axis) for different category, comment on the trend for different category.
This Accounting & Finance Assignment has been solved by our Accounting & Finance Expert at TV Assignment Help. 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 a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
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