1 TSTA602- Quantitative Methods for Accounting & Finance (worth 20%) Case Study, An Individual Assignment, Due: 25 February 2024 by 11:59pm Structure of the assignment: Your report must include the following sections, respectively: 1) Executive Summary (100 words). This section include: 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. IMPORTANT: You must submit your assignment via Turnitin before the due date. 2 PRESENTATION OF ASSIGNMENT 1. Each part requires an output from any statistical computer package (Excel). The statistical output must be provided. 2. Your report can be maximum 1,500 words (including tables and figures), penalties will be applied if the report is longer than this. 3. Set the font to Times New Roman, size to 12 and line spacing 1.5 for your report. 4. Do not present the data in your assignment. 5. Correct grammar and spelling are important. 6. Insert an assignment cover sheet/ signed as own. 7. Tables/graphs should be properly prepared, numbered and labelled. 8. No broken table or graph across two pages. 9. Page number is necessary. Summary of Marking Guide The answered marks will be based on format (10%) and analysis (90%). Total 100 Format 10 Analysis 90 Executive Summary 5 Statistical problem 5 Part 1 question 1 10 Part 1 question 2 10 Part 2 question 1 10 Part 2 question 2 10 Part 3 question 1 10 Part 3 question 2 10 Part 3 question 3 10 General Conclusion 10 3 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. 4 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 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. 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