Operational risk with Excel and VBA: applied statistical methods for risk management
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Hoboken, N.J.
Wiley
2004
|
| Subjects: | |
| Online Access: | Contributor biographical information Publisher description Table of contents Inhaltsverzeichnis |
| Item Description: | "Published simultaneously in Canada." -- Includes index. |
| Physical Description: | XV, 267 S. graph. Darst. 1 CD-ROM |
| ISBN: | 0471478873 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV020028280 | ||
| 003 | DE-604 | ||
| 005 | 20140123 | ||
| 007 | t | ||
| 008 | 050913s2004 xxud||| |||| 00||| eng d | ||
| 010 | |a 2003023869 | ||
| 020 | |a 0471478873 |9 0-471-47887-3 | ||
| 035 | |a (OCoLC)53361359 | ||
| 035 | |a (DE-599)BVBBV020028280 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-1047 | ||
| 050 | 0 | |a HD61 | |
| 082 | 0 | |a 658.15/5/0285554 |2 22 | |
| 082 | 0 | |a 658.1550285369 |2 21 | |
| 084 | |a QH 231 |0 (DE-625)141546: |2 rvk | ||
| 100 | 1 | |a Lewis, Nigel Da Costa |e Verfasser |0 (DE-588)1024382729 |4 aut | |
| 245 | 1 | 0 | |a Operational risk with Excel and VBA |b applied statistical methods for risk management |c Nigel Da Costa Lewis |
| 264 | 1 | |a Hoboken, N.J. |b Wiley |c 2004 | |
| 300 | |a XV, 267 S. |b graph. Darst. |e 1 CD-ROM | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a "Published simultaneously in Canada." -- Includes index. | ||
| 650 | 4 | |a Gestion du risque - Modèles mathématiques | |
| 650 | 4 | |a Gestion du risque - Méthodes statistiques | |
| 650 | 7 | |a Risk management |2 gtt | |
| 650 | 7 | |a Statistische methoden |2 gtt | |
| 650 | 4 | |a aRisk management |a xStatistical methods | |
| 650 | 4 | |a aRisk management |a xMathematical models | |
| 650 | 0 | 7 | |a Statistik |0 (DE-588)4056995-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Risikomanagement |0 (DE-588)4121590-4 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Risikomanagement |0 (DE-588)4121590-4 |D s |
| 689 | 0 | 1 | |a Statistik |0 (DE-588)4056995-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | |u http://www.loc.gov/catdir/bios/wiley047/2003023869.html |3 Contributor biographical information | |
| 856 | 4 | |u http://www.loc.gov/catdir/description/wiley041/2003023869.html |3 Publisher description | |
| 856 | 4 | |u http://www.loc.gov/catdir/toc/wiley041/2003023869.html |3 Table of contents | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013349550&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-013349550 | ||
Record in the Search Index
| _version_ | 1804133594170392576 |
|---|---|
| adam_text | Contents
Preface xiii
Acknowtedgments xv
CHAPTER 1
Introduction to Operational Risk Management and Modeling 1
What is Operational Risk? 1
The Regulatory Environment 3
Why a Statistical Approach to Operational Risk Management? 5
Summary 6
Review Questions 6
Further Reading 6
CHAPTER 2
Random Variables, Risk indicators, and Probability 7
Random Variables and Operational Risk Indicators 7
Types of Random Variable 8
Probability 9
Frequency and Subjective Probability 11
Probability Functions 13
Case Studies 16
Case Study 2.1: Downtown Investment Bank 17
Case Study 2.2: Mr. Mondey s OPVaR 20
Case Study 2.3: Risk in Software Development 20
Useful Excel Functions 24
Summary 24
Review Questions 25
Further Reading 26
Vl
VHj CONTENTS
CHAPTER 3
Expectation, Covariance, Variance, and Correlation 27
Expected Value of a Random Variable 27
Variance and Standard Deviation 31
Covariance and Correlation 32
Some Rules for Correlation, Variance, and Covariance 34
Case Studies 35
Case Study 3.1: Expected Time to Complete
a Complex Transaction 35
Case Study 3.2: Operational Cost of System Down Time 37
Summary 38
Review Questions 38
Further Reading 39
CHAPTER 4
Modeling Central Tendency and Variability of Operational Risk Indicators 41
Empirical Measures of Central Tendency 41
Measures of Variability 43
Case Studies 44
Case Study 4.1: Approximating Business Risk 44
Excel Functions 47
Summary 47
Review Questions 48
Further Reading 49
CHAPTER 5
Measuring Skew and Fat Tails ol Operationa) Risk hdicatops 51
Measuring Skew 51
Measuring Fat Tails 54
Review of Excel and VBA Functions for Skew and Fat Tails 57
Summary 58
Review Questions 58
Further Reading 58
CHAPTER 6
Statistical Testing of Operational Risk Parameters 59
Objective and Language of Statistical Hypothesis Testing 59
Steps Involved In Conducting a Hypothesis Test 61
Confidence Intervals 64
Case Study 6.1: Stephan s Mistake 65
Excel Functions for Hypothesis Testing 67
Contents jx
Summary 67
Review Questions 68
Further Reading 68
CHAPTER 7
Severity of Loss Probability Models 69
Normal Distribution 69
Estimation of Parameters 72
Beta Distribution 72
Erlang Distribution 77
Exponential Distribution 77
Gamma Distribution 78
Lognormal Distribution 80
Pareto Distribution 81
Weibull Distribution 81
Other Probability Distributions 83
What Distribution Best Fits My Severity of Loss Data? 84
Case Study 7.1: Modeling Severity of Loss Legal
Liability Losses 86
Summary 91
Review Questions 91
Further Reading 92
CHAPTER 8
Frequency oi Loss Probability Models 88
Popular Frequency of Loss Probability Models 93
Other Frequency of Loss Distributions 98
Chi Squared Goodness of Fit Test 100
Case Study 8.1: Key Personnel Risk 102
Summary 103
Review Questions 103
Further Reading 103
CHAPTER 9
Modeling Aggregate Loss Distributions 185
Aggregating Severity of Loss and Frequency
of Loss Distributions 105
Calculating OpVaR 108
Coherent Risk Measures 110
Summary 112
Review Questions 112
Further Reading 112
X CONTENTS
CHAPTER 10
The Law of Significant Digits and Fraud Risk Identification 113
The Law of Significant Digits 113
Benford s Law in Finance 116
Case Study 10.1: Analysis of Trader s Profit and Loss
Using Benford s Law 116
A Step Towards Better Statistical Methods of Fraud Detection 118
Summary 120
Review Questions 120
Further Reading 120
CHAPTER 11
Correlation and Dependence 121
Measuring Correlation 121
Dependence 132
Stochastic Dependence 134
Summary 136
Review Questions 136
Further Reading 136
CHAPTER 12
Linear Regression in Operational Risk Manangement 137
The Simple Linear Regression Model 137
Multiple Regression 148
Prediction 153
Polynomial and Other Types of Regression 155
Multivariate Multiple Regression 155
Regime Switching Regression 157
The Difference Between Correlation and Regression 158
A Strategy for Regression Model Building
in Operational Risk Management 159
Summary 159
Review Questions 159
Further Reading 160
CHAPTER 13
Logistic Regression In Operational Risk Management 161
Binary Logistic Regression 161
Bivariate Logistic Regression 165
Case Study 13.1: Nostro Breaks and Volume
in a Bivariate Logistic Regression 172
Other Approaches for Modeling Bivariate Binary Endpoints 173
Contents Xj
Summary 176
Review Questions 177
Further Reading 177
CHAPTER 14
Mixed Dependent Variable Modeling 179
A Model for Mixed Dependent Variables 179
Working Assumption of Independence 181
Understanding the Benefits of Using a WAI 184
Case Study 14.1: Modeling Failure in Compliance 184
Summary 185
Review Questions 186
Further Reading 186
CHAPTER 15
Validating Operational Risk Proxies Using Surrogate Endpofcrts 187
The Need for Surrogate Endpoints in OR Modeling 187
The Prentice Criterion 188
Limitations of the Prentice Criterion 191
The Real Value Added of Using Surrogate Variables 193
Validation Via the Proportion Explained 196
Limitations of Surrogate Modelling in Operational
Risk Management 200
Case Study 15.1: Legal Experience as a Surrogate Endpoint
for Legal Costs for a Business Unit 201
Summary 202
Review Questions 202
Further Reading 202
CHAPTER 16
Introduction to Extreme Value Theory 208
Fisher Tippet Gnedenko Theorem 203
Method of Block Maxima 205
Peaks over Threshold Modeling 206
Summary 207
Review Questions 207
Further Reading 207
CHAPTER 17
Managing Operational Risk with Bayesian Belief Networks 209
What is a Bayesian Belief Network? 209
Case Study 17.1: A BBN Model for Software Product Risk 212
Creating a BBN Based Simulation 215
Xjj CONTENTS
Assessing the Impact of Different Managerial Strategies 216
Perceived Benefits of Bayesian Belief Network Modeling 218
Common Myths About BBNs—
The Truth for Operational Risk Management 222
Summary 224
Review Questions 224
Further Reading 224
CHAPTER 18
Epilogue 225
Winning the Operational Risk Argument 225
Final Tips on Applied Operational Risk Modeling 226
Further Reading 226
Appendix
Statistical Tables 227
Cumulative Distribution Function of the Standard
Normal Distribution 227
Chi Squared Distribution 230
Student s t Distribution 232
F Distribution 233
Notes 237
Bibliography 245
About the CD ROM 255
Index 259
|
| any_adam_object | 1 |
| author | Lewis, Nigel Da Costa |
| author_GND | (DE-588)1024382729 |
| author_facet | Lewis, Nigel Da Costa |
| author_role | aut |
| author_sort | Lewis, Nigel Da Costa |
| author_variant | n d c l ndc ndcl |
| building | Verbundindex |
| bvnumber | BV020028280 |
| callnumber-first | H - Social Science |
| callnumber-label | HD61 |
| callnumber-raw | HD61 |
| callnumber-search | HD61 |
| callnumber-sort | HD 261 |
| callnumber-subject | HD - Industries, Land Use, Labor |
| classification_rvk | QH 231 |
| ctrlnum | (OCoLC)53361359 (DE-599)BVBBV020028280 |
| dewey-full | 658.15/5/0285554 658.1550285369 |
| dewey-hundreds | 600 - Technology (Applied sciences) |
| dewey-ones | 658 - General management |
| dewey-raw | 658.15/5/0285554 658.1550285369 |
| dewey-search | 658.15/5/0285554 658.1550285369 |
| dewey-sort | 3658.15 15 6285554 |
| dewey-tens | 650 - Management and auxiliary services |
| discipline | Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02163nam a2200517zc 4500</leader><controlfield tag="001">BV020028280</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20140123 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">050913s2004 xxud||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2003023869</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0471478873</subfield><subfield code="9">0-471-47887-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)53361359</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV020028280</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1047</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HD61</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">658.15/5/0285554</subfield><subfield code="2">22</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">658.1550285369</subfield><subfield code="2">21</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QH 231</subfield><subfield code="0">(DE-625)141546:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Lewis, Nigel Da Costa</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1024382729</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Operational risk with Excel and VBA</subfield><subfield code="b">applied statistical methods for risk management</subfield><subfield code="c">Nigel Da Costa Lewis</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken, N.J.</subfield><subfield code="b">Wiley</subfield><subfield code="c">2004</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XV, 267 S.</subfield><subfield code="b">graph. Darst.</subfield><subfield code="e">1 CD-ROM</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">"Published simultaneously in Canada." -- Includes index.</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Gestion du risque - Modèles mathématiques</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Gestion du risque - Méthodes statistiques</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Risk management</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Statistische methoden</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">aRisk management</subfield><subfield code="a">xStatistical methods</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">aRisk management</subfield><subfield code="a">xMathematical models</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Statistik</subfield><subfield code="0">(DE-588)4056995-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Risikomanagement</subfield><subfield code="0">(DE-588)4121590-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Risikomanagement</subfield><subfield code="0">(DE-588)4121590-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Statistik</subfield><subfield code="0">(DE-588)4056995-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/bios/wiley047/2003023869.html</subfield><subfield code="3">Contributor biographical information</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/description/wiley041/2003023869.html</subfield><subfield code="3">Publisher description</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/toc/wiley041/2003023869.html</subfield><subfield code="3">Table of contents</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013349550&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-013349550</subfield></datafield></record></collection> |
| id | DE-604.BV020028280 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T20:11:12Z |
| institution | BVB |
| isbn | 0471478873 |
| language | English |
| lccn | 2003023869 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-013349550 |
| oclc_num | 53361359 |
| open_access_boolean | |
| owner | DE-1047 |
| owner_facet | DE-1047 |
| physical | XV, 267 S. graph. Darst. 1 CD-ROM |
| publishDate | 2004 |
| publishDateSearch | 2004 |
| publishDateSort | 2004 |
| publisher | Wiley |
| record_format | marc |
| spelling | Lewis, Nigel Da Costa Verfasser (DE-588)1024382729 aut Operational risk with Excel and VBA applied statistical methods for risk management Nigel Da Costa Lewis Hoboken, N.J. Wiley 2004 XV, 267 S. graph. Darst. 1 CD-ROM txt rdacontent n rdamedia nc rdacarrier "Published simultaneously in Canada." -- Includes index. Gestion du risque - Modèles mathématiques Gestion du risque - Méthodes statistiques Risk management gtt Statistische methoden gtt aRisk management xStatistical methods aRisk management xMathematical models Statistik (DE-588)4056995-0 gnd rswk-swf Risikomanagement (DE-588)4121590-4 gnd rswk-swf Risikomanagement (DE-588)4121590-4 s Statistik (DE-588)4056995-0 s DE-604 http://www.loc.gov/catdir/bios/wiley047/2003023869.html Contributor biographical information http://www.loc.gov/catdir/description/wiley041/2003023869.html Publisher description http://www.loc.gov/catdir/toc/wiley041/2003023869.html Table of contents HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013349550&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Lewis, Nigel Da Costa Operational risk with Excel and VBA applied statistical methods for risk management Gestion du risque - Modèles mathématiques Gestion du risque - Méthodes statistiques Risk management gtt Statistische methoden gtt aRisk management xStatistical methods aRisk management xMathematical models Statistik (DE-588)4056995-0 gnd Risikomanagement (DE-588)4121590-4 gnd |
| subject_GND | (DE-588)4056995-0 (DE-588)4121590-4 |
| title | Operational risk with Excel and VBA applied statistical methods for risk management |
| title_auth | Operational risk with Excel and VBA applied statistical methods for risk management |
| title_exact_search | Operational risk with Excel and VBA applied statistical methods for risk management |
| title_full | Operational risk with Excel and VBA applied statistical methods for risk management Nigel Da Costa Lewis |
| title_fullStr | Operational risk with Excel and VBA applied statistical methods for risk management Nigel Da Costa Lewis |
| title_full_unstemmed | Operational risk with Excel and VBA applied statistical methods for risk management Nigel Da Costa Lewis |
| title_short | Operational risk with Excel and VBA |
| title_sort | operational risk with excel and vba applied statistical methods for risk management |
| title_sub | applied statistical methods for risk management |
| topic | Gestion du risque - Modèles mathématiques Gestion du risque - Méthodes statistiques Risk management gtt Statistische methoden gtt aRisk management xStatistical methods aRisk management xMathematical models Statistik (DE-588)4056995-0 gnd Risikomanagement (DE-588)4121590-4 gnd |
| topic_facet | Gestion du risque - Modèles mathématiques Gestion du risque - Méthodes statistiques Risk management Statistische methoden aRisk management xStatistical methods aRisk management xMathematical models Statistik Risikomanagement |
| url | http://www.loc.gov/catdir/bios/wiley047/2003023869.html http://www.loc.gov/catdir/description/wiley041/2003023869.html http://www.loc.gov/catdir/toc/wiley041/2003023869.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013349550&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT lewisnigeldacosta operationalriskwithexcelandvbaappliedstatisticalmethodsforriskmanagement |