Quantitative Methods for Accounting & Finance

Quantitative Methods for
Accounting & Finance
1

Executive summary
Primary purpose of conducting this report is to uncover patterns in the past Nobel
Laureates and gathering information related to Nobel prize. some appropriate and relevant data is
given on which basis, this study will show numbers of women and men who participated and
won Nobel prize. Their tactics of playing game, reasons and other patterns. It shows some
motivation factors that lead and motivate participants towards wining Nobel prize. It also shows
number of prizes that was awarded by countries and average age of people who won as well as
participated in games for Nobel prize.
2

Table of Contents
Executive summary.....................................................................................................................2
MAIN BODY..................................................................................................................................4
Business problem.........................................................................................................................4
Statistical problem.......................................................................................................................4
DATA ANALYSIS.........................................................................................................................4
PART 1............................................................................................................................................4
Question 1: What percentage of the Nobel laureates were women? (pie chart)..........................4
Question 2: How many prizes were given out in each category?................................................5
PART 2............................................................................................................................................8
Question 1: How many prizes awarded by country.....................................................................8
Question 2: Age of the laureate in the year of the ceremony. What are the names of the
youngest and oldest Nobel Laureate?........................................................................................15
PART 3..........................................................................................................................................17
Question 1: How does the winning age at different categories with descriptive statistics........17
Question 2: Average age for Physics with T test.......................................................................18
Question 3: How the age of winners has changed over time.....................................................19
CONCLUSION..............................................................................................................................19
REFERENCES..............................................................................................................................20
APPENDIX................................................................................................................................21
3

MAIN BODY
Business problem
Business problem in this case is centred around Australia that wants to know some key
factors of winning Nobel prize. It aims to increase an understanding about ways as how men and
women can improve their performance and key characteristics of country that provided number
of Nobel prizes.
Statistical problem
There are in total 7 questions in which 3 are based on core statistic. In first sector or part 1,
there is general calculation for identifying number of males and females who won Nobel prize.
In 2 part, calculation is based on knowing number of prizes that awarded by country (Liang and
et.al., 2020). In 3 main part, main calculation is mean, mode and median and it may consume too
much of time.
DATA ANALYSIS
PART 1
Question 1: What percentage of the Nobel laureates were women? (pie chart)
Statistics
VAR00001
N Valid 962
Missing 0
VAR00001
Frequency Percent Valid Percent Cumulative
Percent
Valid
Female 58 6.0 6.0 6.0
Male 876 91.1 91.1 97.1
NA 28 2.9 2.9 100.0
Total 962 100.0 100.0
4

Interpretation: On the basis of above chart, it can clearly be said that number of male were
more than female, who worn Nobel prize in the year of 1901-2020. Out of 962 participants, there
were 876 males who won Nobel prize and number of female were only 58. More than 90% of
participants were male so, it can be said that males are more likely to participate in sports
activities and win prizes.
Question 2: How many prizes were given out in each category?
Statistics
VAR00002
5

N Valid 962
Missing 0
VAR00002
Frequency Percent Valid Percent Cumulative
Percent
Valid
Chemistry 186 19.3 19.3 19.3
Economics 86 8.9 8.9 28.3
Literature 117 12.2 12.2 40.4
Medicine 222 23.1 23.1 63.5
Peace 135 14.0 14.0 77.5
Physics 216 22.5 22.5 100.0
Total 962 100.0 100.0
6

Chemistry Economics Literature Medicine Peace Physics
0
50
100
150
200
250
186
86
117
222
135
216
category of Prize
Total
Interpretation: In regard to category in which participants won prizes, it can be said that
medicine field is the highest one in which people won prizes. 222 people won prizes in medicine
category. In physics category, 216 people won Nobel prize in past years. 186 people were from
chemistry category. 135 participants were from peace category. 117 people who won Nobel prize
were from literature category. The least number of people on the basis of category was
economics as only 86 people in economics won Nobel prize (Bjørk, 2019).
Row Labels
Count of
category
Chemistry 186
Female 7
Male 179
Economics 86
Female 2
Male 84
Literature 117
Female 16
Male 101
Medicine 222
Female 12
Male 210
Peace 135
7

Female 17
Male 90
NA 28
Physics 216
Female 4
Male 212
Grand
Total 962
Chemistry Economics Literature Medicine Peace Physics
0
50
100
150
200
250
179
84 101
210
90
212
7
2
16
12
17
4
category of prize by gender
Male Female
Interpretation: On the basis of above data, it can be said that maximum number of winners of
Nobel prize in each category are: male. Number of female in winning Nobel prize is less than
number of males.
PART 2
Question 1: How many prizes awarded by country
Row Labels
Count of
prize
8