Many Excel users dismiss statistics as irrelevant, focusing solely on getting the numbers to add up and then moving on, rather than thinking in probabilities and uncertainties. Yet, these numbers often represent moments in time where they’re monitoring for significant changes to alert the business—precisely where statistics shines. ...

The pharmaceutical industry develops life-saving drugs while maintaining strict quality standards. Regulatory requirements ensure safety and compliance but can slow process changes due to extensive documentation and resource demands. GxP compliance can be complex, but we’ve got you covered. Learn how to navigate regulations in the pharmaceutical industry. Quality ...

Technology has changed all areas of our lives, especially in recent decades. And this isn’t going to stop any time soon, going forward the technology available to us will transform just about every element of our lives, homes and businesses that we can possibly imagine. While this is true ...

Integrating Python into Excel unlocks a wide range of data visualization options, though interactivity with Python-generated plots remains somewhat limited. In Excel, Python plots are essentially static images, lacking features like tooltips or the ability to explore series data. That said, with a bit of creativity, it’s possible to ...

Introduction The first part of this two-part blog described the YFinanceService. This is a Flask service that wraps calls to the Python yfinance library and which served up some of the data via the APIs (/IntrinsicValue, /TickerData and so on). Part II...

Online probabilistic estimation of carbon beta and carbon Shapley values for financial and climate risk at the 18th FINANCIAL RISKS INTERNATIONAL FORUM -- Institut Louis Bachelier/Fondation du Risque/Europlace Institute of Finance

Introduction Recently, I’ve been doing some portfolio analysis and I came across an interesting video: How to Calculate the Intrinsic Value of a Stock like Benjamin Graham. Since not all the data is available in Excel, I thought it might be useful to a...

After years of being unable to work with regular expressions, Excel has finally introduced a set of convenient and useful functions for doing so: However, around the same time, regular expressions also became accessible in Excel as a result of its integration with Python: The addition of regex support in ...

Technology is at the forefront of modern society, changing how it operates and what can be done. Today, though, almost everyone is in agreement that it is moving at a much faster pace than before. The ability of tools to achieve ends is almost limitless. Despite this, the entertainment world ...