Search
Now showing items 1-10 of 42
8.4 - Runge Kutta Methods (2nd & 4th Order)
(7/28/18)
In this lesson you'll learn about a class of equations called the Runge Kutta Methods and the Fourth Order Runge Kutta Method
8.2 - Euler's Method - Newton's Cooling Law
(7/27/18)
In this lesson you'll learn an additional example on the application of Euler's Methods using Newton's Cooling Law
4.4 - Gauss Jordan
(7/4/18)
In this lesson you'll learn about how to solve a system of equations using gauss Jordan and how to develop a gauss Jordan VBA Code.
1.2 - Functions & Variables
(6/4/18)
In this lesson you'll learn about the two possible programs written in VBA, functions and subroutines in addition to the use of variables in a VBA program
5.4 - 2D Optimization - Gradient Descent
(7/17/18)
In this lesson you'll learn about how to apply the gradient decent/ascent method to find optimum min and max of a 2D function and learn how to code a gradient descent code
6.3 - Linearization (Log & Hyperbolic)
(7/17/18)
In this lesson you'll learn about how to best fit a line using regression analysis to fit a log trend and hyperbolic trend.
1.1 - Getting Started with Excel
(6/1/18)
In this lesson you'll learn how to setup Excel for VBA programming, explain the most common features of the interface and how to save an Excel sheet with a macro program
6.4 - Cubic Spline
(7/31/18)
In this lesson you'll learn about how to apply cubic spline to interpolate a value between two points and how to develop a cubic spline code in VBA programming language
5.1 - Introduction to Optimization & Analytical Sol.
(7/9/18)
In this lesson you'll learn about optimization, minimums, maximums, and a saddle. You’ll learn the difference between a local and global optima, the Second Derivative Test, contour lines, and how to graph a 2D function in Excel.
3.7 - Goal Seek and Solver
(7/6/18)
In this lesson you'll learn about how to use Excel's inbuilt root finding functions–goal seek for simple 1D function and Solver for multivariable functions.