Guojun Gan – författare

Excel Visual Basic for Applications (VBA) can be used to automate operations in Excel and is one of the most frequently used software programs for manipulating data and building models in banks and insurance companies. An Introduction to Excel VBA Programming: with Applications in Finance and Insurance introduces readers to the basic fundamentals of VBA Programming while demonstrating applications of VBA to solve real-world problems in finance and insurance. Assuming no prior programming experience and with reproducible examples using code and data, this text is suitable for advanced undergraduate students, graduate students, actuaries, and financial analysts who wish to learn VBA.Features: Presents the theory behind the algorithms in detail Includes more than 100 exercises with selected solutions Provides VBA code in Excel files and data to reproduce the results in the book Offers a solutions manual for qualified instructors

Data clustering is a highly interdisciplinary field, the goal of which is to divide a set of objects into homogeneous groups such that objects in the same group are similar and objects in different groups are quite distinct. Thousands of theoretical papers and a number of books on data clustering have been published over the past 50 years. However, few books exist to teach people how to implement data clustering algorithms. This book was written for anyone who wants to implement or improve their data clustering algorithms. Using object-oriented design and programming techniques, Data Clustering in C++ exploits the commonalities of all data clustering algorithms to create a flexible set of reusable classes that simplifies the implementation of any data clustering algorithm. Readers can follow the development of the base data clustering classes and several popular data clustering algorithms. Additional topics such as data pre-processing, data visualization, cluster visualization, and cluster interpretation are briefly covered.This book is divided into three parts-- Data Clustering and C++ Preliminaries: A review of basic concepts of data clustering, the unified modeling language, object-oriented programming in C++, and design patternsA C++ Data Clustering Framework: The development of data clustering base classesData Clustering Algorithms: The implementation of several popular data clustering algorithms A key to learning a clustering algorithm is to implement and experiment the clustering algorithm. Complete listings of classes, examples, unit test cases, and GNU configuration files are included in the appendices of this book as well as in the downloadable resources. The only requirements to compile the code are a modern C++ compiler and the Boost C++ libraries.

This book is devoted to the mathematical methods of metamodeling that can be used to speed up the valuation of large portfolios of variable annuities. It is suitable for advanced undergraduate students, graduate students, and practitioners. It is the goal of this book to describe the computational problems and present the metamodeling approaches in a way that can be accessible to advanced undergraduate students and practitioners. To that end, the book will not only describe the theory of these mathematical approaches, but also present the implementations.

This book is devoted to the mathematical methods of metamodeling that can be used to speed up the valuation of large portfolios of variable annuities. It is suitable for advanced undergraduate students, graduate students, and practitioners. It is the goal of this book to describe the computational problems and present the metamodeling approaches in a way that can be accessible to advanced undergraduate students and practitioners. To that end, the book will not only describe the theory of these mathematical approaches, but also present the implementations.

Actuarial loss models are statistical models used by insurance companies to estimate the frequency and severity of future losses, set premiums, and reserve funds to cover potential claims. Actuarial loss models are a subject in actuarial mathematics that focus on the pricing and reserving for short-term coverages.This is a concise textbook written for undergraduate students majoring in actuarial science who wish to learn the basics of actuarial loss models. This book can be used as a textbook for a one-semester course on actuarial loss models. The prerequisite for this book is a first course on calculus. The reader is supposed to be familiar with differentiation and integration.This book covers part of the learning outcomes of the Fundamentals of Actuarial Mathematics (FAM) exam and the Advanced Short-Term Actuarial Mathematics (ASTAM) exam administered by the Society of Actuaries. It can be used by actuarial students and practitioners who prepare for the aforementioned actuarial exams.Key Features:Review core concepts in probability theory.Cover important topics in actuarial loss models.Include worked examples.Provide both theoretical and numerical exercises.Include solutions of selected exercises.

Data clustering, an interdisciplinary field with diverse applications, has gained increasing popularity since its origins in the 1950s. Over the past six decades, researchers from various fields have proposed numerous clustering algorithms. In 2011, I wrote a book on implementing clustering algorithms in C++ using object-oriented programming. While C++ offers efficiency, its steep learning curve makes it less ideal for rapid prototyping. Since then, Python has surged in popularity, becoming the most widely used programming language since 2022. Its simplicity and extensive scientific libraries make it an excellent choice for implementing clustering algorithms.Features:Introduction to Python programming fundamentalsOverview of key concepts in data clusteringImplementation of popular clustering algorithms in PythonPractical examples of applying clustering algorithms to datasetsAccess to associated Python code on GitHubThis book extends my previous work by implementing clustering algorithms in Python. Unlike the object-oriented approach in C++, this book uses a procedural programming style, as Python allows many clustering algorithms to be implemented concisely. The book is divided into two parts: the first introduces Python and key libraries like NumPy, Pandas, and Matplotlib, while the second covers clustering algorithms, including hierarchical and partitional methods. Each chapter includes theoretical explanations, Python implementations, and practical examples, with comparisons to scikit-learn where applicable.This book is ideal for anyone interested in clustering algorithms, with no prior Python experience required. The complete source code is available at: https://github.com/ganml/dcpython.

An introduction to the mathematical theory and financial models developed and used on Wall StreetProviding both a theoretical and practical approach to the underlying mathematical theory behind financial models, Measure, Probability, and Mathematical Finance: A Problem-Oriented Approach presents important concepts and results in measure theory, probability theory, stochastic processes, and stochastic calculus. Measure theory is indispensable to the rigorous development of probability theory and is also necessary to properly address martingale measures, the change of numeraire theory, and LIBOR market models. In addition, probability theory is presented to facilitate the development of stochastic processes, including martingales and Brownian motions, while stochastic processes and stochastic calculus are discussed to model asset prices and develop derivative pricing models.The authors promote a problem-solving approach when applying mathematics in real-world situations, and readers are encouraged to address theorems and problems with mathematical rigor. In addition, Measure, Probability, and Mathematical Finance features: A comprehensive list of concepts and theorems from measure theory, probability theory, stochastic processes, and stochastic calculusOver 500 problems with hints and select solutions to reinforce basic concepts and important theoremsClassic derivative pricing models in mathematical finance that have been developed and published since the seminal work of Black and Scholes Measure, Probability, and Mathematical Finance: A Problem-Oriented Approach is an ideal textbook for introductory quantitative courses in business, economics, and mathematical finance at the upper-undergraduate and graduate levels. The book is also a useful reference for readers who need to build their mathematical skills in order to better understand the mathematical theory of derivative pricing models.

Excel Visual Basic for Applications (VBA) can be used to automate operations in Excel and is one of the most frequently used software programs for manipulating data and building models in banks and insurance companies. An Introduction to Excel VBA Programming: with Applications in Finance and Insurance introduces readers to the basic fundamentals of VBA Programming while demonstrating applications of VBA to solve real-world problems in finance and insurance. Assuming no prior programming experience and with reproducible examples using code and data, this text is suitable for advanced undergraduate students, graduate students, actuaries, and financial analysts who wish to learn VBA.Features: Presents the theory behind the algorithms in detail Includes more than 100 exercises with selected solutions Provides VBA code in Excel files and data to reproduce the results in the book Offers a solutions manual for qualified instructors

Data clustering is a highly interdisciplinary field, the goal of which is to divide a set of objects into homogeneous groups such that objects in the same group are similar and objects in different groups are quite distinct. Thousands of theoretical papers and a number of books on data clustering have been published over the past 50 years. However, few books exist to teach people how to implement data clustering algorithms. This book was written for anyone who wants to implement or improve their data clustering algorithms. Using object-oriented design and programming techniques, Data Clustering in C++ exploits the commonalities of all data clustering algorithms to create a flexible set of reusable classes that simplifies the implementation of any data clustering algorithm. Readers can follow the development of the base data clustering classes and several popular data clustering algorithms. Additional topics such as data pre-processing, data visualization, cluster visualization, and cluster interpretation are briefly covered.This book is divided into three parts-- Data Clustering and C++ Preliminaries: A review of basic concepts of data clustering, the unified modeling language, object-oriented programming in C++, and design patternsA C++ Data Clustering Framework: The development of data clustering base classesData Clustering Algorithms: The implementation of several popular data clustering algorithms A key to learning a clustering algorithm is to implement and experiment the clustering algorithm. Complete listings of classes, examples, unit test cases, and GNU configuration files are included in the appendices of this book as well as in the downloadable resources. The only requirements to compile the code are a modern C++ compiler and the Boost C++ libraries.