TSTA 602: Quantitative Methods - Nobel Prize Laureate Analysis

This case study provides a quantitative analysis of Nobel Prize winners, examining various aspects such as gender distribution, prize categories, and the laureates' countries of origin. The study employs observational methodology and statistical tools like pie charts, bar graphs, and t-tests using Excel to analyze secondary data. Key findings reveal that males dominate Nobel Prize wins, medicine is the most awarded category, and the United States leads in the number of prizes. The analysis also explores the age distribution of winners and observes changes over time. The study concludes that there are no specific trends in age or time required to win a Nobel Prize and recommends a more balanced distribution of prizes across different fields. The report includes detailed statistical outputs and references, adhering to a structured format with an executive summary, table of contents, and clear problem statements.

QUANTITATIVE
METHODS OF
ACCOUNTING AND
FINANCE

EXECUTIVE SUMMARY
The purpose of the study is to evaluate about the winners of the Nobel Prize. The key
reason behind the study conducted is to know about the basic characteristic of the Nobel Prize.
The observational methodology has been used in order to conduct the research study. This
methodology is based on the observations created against the study is conducted by the scholar.
This is identified that only 6% are the Nobel Prize winners are female. Medicine hold the most
number of Nobel Prize winners. United States of America hold the maximum number of prizes.
This is recommended that more prizes must be allocated to other areas where only few of the
Nobel Prizes have been awarded.

Table of Contents
Business problem........................................................................................................................5
Statistical problem.......................................................................................................................5
ANALYSIS......................................................................................................................................5
PART 1............................................................................................................................................5
1. Presenting a pie chart for gender.............................................................................................5
PART 2............................................................................................................................................8
1.Horizontal bar chart..................................................................................................................8
2. Age of the laureate in the year of the ceremony...................................................................14
PART 3..........................................................................................................................................15
1. Descriptive statistic...............................................................................................................15
2. T test......................................................................................................................................16
3.Presenting how the age of winners have changed over time.................................................17
CONCLUSION..............................................................................................................................17
REFERENCES..............................................................................................................................17
APPENDIX....................................................................................................................................19

Business problem
The primary purpose of the study is to understand the various aspects related to the Nobel
Prize. The aim of the entire study conducted is to know about the basic nature of the Nobel Prize
winners (Cantarelli, Bellé and Belardinelli, 2020). The purpose of the study is also to understand
the various streams that hold the Nobel Prizes. Study also aim to understand the maximum
preferred area when it comes to awarding. Business language is professional and sufficient to
understand about the basic characteristics of the study.
Statistical problem
The analysis is done with the use of secondary method of data collection. The analysis is
further done with the use of bar graph, pie chart and such like tools. Excel is used to present
information in order to analysis the whole information and records. Problem is entertained when
the information and data is analyses properly. The issue is related to the practices adopted to
evaluate the whole information order to achieve the overall research objectives.
ANALYSIS
PART 1
1. Presenting a pie chart for gender
Particular
s Frequency %
Female 58 6%
Male 876
91
%
962
100
%

Interpretation: From the above, it has been interpreted that there are 876 males and 58 females.
Also, from 100%, only 6% of them are females who won the Nobel Prize. The above stated pie
chart clearly demonstrate the fact that 91% of the total prizes are allocated to the male. Whereas
only 6% have been allocated to the female. The difference between the prize winners based on
gender is huge.
2.
Row Labels
Count of
category
Chemistry 186
Economics 86
6.00%
91.00%
Female
Male

Literature 117
Medicine 222
Peace 135
Physics 216
Grand
Total 962
The above reflected bar chart demonstrate the fact that in medicine the maximum number
of prizes have been allocated. The total prizes in medicine is 222, chemistry 186, physics 216,
literature 117, peace 135 and economics 86. The most prizes have been allocated in medicine
where as the least number of prizes are allocated in economics.
Row Labels
Count of
category
Chemistry 186
Female 7
Male 179
Economics 86
Female 2
Male 84
Literature 117
Chemistry
Economics
Literature
Medicine
Peace
Physics
0 50 100 150 200 250
186
86
117
222
135
216
Column B

Female 16
Male 101
Medicine 222
Female 12
Male 210
Peace 135
Female 17
Male 90
NA 28
Physics 216
Female 4
Male 212
Grand
Total 962
The above stated data clearly demonstrate the fact that the overall segregation between
make and female is done in each of the prize category (Harman, 2020). The maximum number of
winners are male whereas female are only few.
PART 2
1. Horizontal bar chart
Row Labels
Count of
prize
Algeria 2
Argentina 4
Australia 10
Austria 18
Azerbaijan 1
Bangladesh 1
Belarus 4
Belgium 9

Bosnia and Herzegovina 2
Brazil 1
Bulgaria 1
Canada 20
Chile 2
China 12
Colombia 2
Costa Rica 1
Croatia 1
Cyprus 1
Czech Republic 6
Democratic Republic of the
Congo 1
Denmark 12
East Timor 2
Egypt 6
Ethiopia 1
Finland 5
France 57
Germany 84
Ghana 1
Greece 1

Guadeloupe Island 1
Guatemala 2
Hungary 9
Iceland 1
India 9
Indonesia 1
Iran 2
Iraq 1
Ireland 5
Israel 6
Italy 19
Japan 27
Kenya 1
Korea (South Korea) 2
Latvia 1
Liberia 2
Lithuania 3
Luxembourg 2
Madagascar 1
Mexico 3
Morocco 1

Myanmar 1
NA 28
Netherlands 18
New Zealand 3
Nigeria 1
Norway 12
Pakistan 3
Peru 1
Poland 27
Portugal 2
Republic of Macedonia 1
Romania 4
Russia 26
Saint Lucia 2
Slovakia 1
Slovenia 1
South Africa 9
Spain 7
Sweden 29
Switzerland 19
Taiwan 1
Trinidad 1

Turkey 3
Ukraine 5
United Kingdom 105
United States of America 281
Venezuela 1
Vietnam 1
Yemen 1
Zimbabwe 1
Grand Total 962
United states of America hold the maximum number of Nobel Prizes in comparison to all
other nations. The total number of prizes hold by the United States of America is 281. United
Kingdom is the second largest country in term of total number of Nobel Prizes with the figure of
105. There are many countries such as Brazil, Yemen, Vietnam and many other contain only one
prize as a Nobel Prize. The possible reason behind is the awareness of the people about the
Nobel prize and the level of expertise achieved by the prize winners (Harry and et.al., 2021). The
all countries belong to the birth country current. Birth country do not exist so it is not used. Birth
country current is the terminology that is used in respect to all the nations mentioned in the list of
Nobel Prize Winners.

The highest number of award are for United States. The other countries are United
Kingdom, Germany, France, Sweden and NA.
Cross-tabulation
country *
category
Crosstabul
ation
Count
category T
o
t
a
l
Chemistry Literature Medicine Peace Physics
country United States of
America 1 0 0 0 0 1
United Kingdom 0 1 0 0 0 1
Germany 0 0 1 0 0 1
France 0 0 0 1 0 1
United States of America
United Kingdom
Germany
France
Sweden
NA
0 50 100 150 200 250 300
281
105
84
57
29
28
Column B