Tag: Excel Formulas
-
The Power of Differential Equations: A Backbone of Science and Engineering
Differential equations, mathematical equations that relate a function and its derivatives, are the cornerstone of many scientific and engineering disciplines. They provide a powerful tool for modeling and understanding complex systems, from the laws of physics to the dynamics of biological populations. In physics, differential equations are used to describe the motion of objects, the…
-
Mastering XLOOKUP: The Ultimate Lookup Function for Scientists and Engineers
Oftentimes, data is stored in tables and frequently needs to be accessed. Take, for example, this data set (taken from kaggle.com) that lists the refractive indices of glass as a function of the percentage of the various elements present in it. Imagine needing to quickly look up the elements of a glass with a particular…
-
Number Series in Excel
Number series are important in many areas of mathematics (which in turn forms the backbone of various other fields, such as Physics and Engineering) for the evaluation of transcendental functions, integrals and differential equations. More often than not, the sum of a series represents an approximation of the function. For example, the value of the…
-
Matrices and Determinants in Excel
Spreadsheets are excellent tools for understanding arrays. While arrays can be multi-dimensional in theory, it’s easiest to visualize them in terms of rows and columns, forming one or two-dimensional arrays. One-dimensional Array Two-Dimensional Array Arrays are always represented as rows x columns. And in many problems, it is useful to manipulate an entire array. Such…