Search
Now showing items 11-20 of 42
2.1 - Taylor Series & Exp(x)
(6/15/18)
In this lesson you'll learn about what Taylor Series are and how to approximate the Exp(x) function using Taylor Series
7.1 - Trapezoidal Rule
(7/19/18)
In this lesson you'll learn about how to approximate an area under the curve using the Trapezoidal rule and how to develop a VBA code to implement this technique to any desired approximate error.
3.5 - Multiple Roots
(6/28/19)
In this lesson you'll learn about the Modified Newton Raphson Method to deal with Multiple Roots and How to develop a VBA code to implement this technique to any desired approximate error.
1.5 - If-Then-Else
(6/6/18)
In this lesson you'll learn about the decision structure of VBA Programming and that the if-then-else statement.
1.4 - Nested Loops
(6/6/18)
In this lesson you'll learn about how created a nested loop where a loop is imbedded within another loop
4.1 - Vectors, Matrices & Arrays
(6/26/18)
In this lesson you'll learn about what an array is and the difference between a vector and a matrix. You’ll then create a vector to store ten elements and display it back onto an Excel sheet. Finally, you’ll learn to create ...
1.8 - Inbuilt Functions
(6/12/18)
In this lesson you'll learn about some the most useful and common EXCEL/VBA inbuilt functions used in numerical methods
7.3 - Romberg Integration
(7/26/18)
In this lesson you'll learn about how to approximate an area under the curve using Romberg Integration, how to develop a VBA code to implement this technique to any desired approximate error in addition to how Romberg ...
6.1 - Linear Regression
(7/13/18)
In this lesson you'll learn about how to best fit a line to a set of linear data points and how to develop a linear regression program. This is followed by a comparison of the results to Excel's inbuilt linear regression function
8.3 - Improvements on Euler (Heun's, Midpoint & Ralston)
(7/28/18)
In this lesson you'll learn about three techniques to improve Euler's Solution, and learn how to write a VBA program to apply all three techniques.