Tag: Numerical Methods
-
Numerical Solutions to the Logistic Equation: Exploring Population Models in Spreadsheets
Introduction The logistic equation is a fundamental mathematical model used to describe population growth in a constrained environment. It was first proposed by Pierre-François Verhulst in 1838 and is expressed as: Here, P represents the population size at time t, r is the intrinsic growth rate, and K is the carrying capacity of the environment,…
-
Solving a Simple Harmonic Oscillator with Spreadsheets
Introduction In this post, we’ll explore how to solve a simple harmonic oscillator using the Finite Difference Method (FDM) in spreadsheets. The simple harmonic oscillator is a fundamental concept in physics, described by a second-order differential equation that models various oscillatory systems, such as springs, pendulums, and circuits. While such equations can be challenging to…
-
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…