Calculate linear regression slope, intercept, monthly predictions, and R-squared in T-SQL while keeping extrapolation limits clear.
SQL SERVER – Fibonacci Series with T-SQL
What’s fascinating about the Fibonacci series is its ubiquitous presence in nature, from the arrangement of leaves on a stem to the shape of a hurricane.
The Pigeonhole Principle: Bridging Mathematics and SQL
The other day I was reading Wikipedia, and I ended up on the Pigeonhole Principle. I find it very intriguing about this and I decide to blog
SQL SERVER – Banker’s Rounding
Also known as unbiased rounding or round half to even, banker’s rounding follows a set of rules that ensures numbers are rounded.
SQL SERVER – Stored Procedures to Check for Pythagorean Triples
I wanted to share another useful programming technique for learning math – using stored procedures to check for Pythagorean triples.
Calculating Extended Internal Rate of Return (XIRR) in SQL Server with T-SQL
The Extended Internal Rate of Return (XIRR) is a metric to calculate the annualized rate of return for a series of irregularly timed flows.
Solving Quadratic Equations with T-SQL
I often find myself teaching mathematics to my daughter, and recently, she has been diving into the realm of Quadratic Equations.