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 ...

In this lesson you'll learn about how to solve a system of equations using gauss elimination with Partial Pivoting and how to develop a gauss elimination with Partial Pivoting VBA Code

In this lesson you'll learn about how to solve a system of equations using LU Decomposition and how to develop a LU Decomposition VBA Code

In this lesson you'll learn about the common debugging issues that arise when programming numerical methods and how to best solve them and avoid them in the future.

The major findings of the first type of retrieval are: Initial soil moisture contents as well as deep soil temperature can all be successfully retrieved, for realistic initial guess errors; the relative difficulty in ...

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.

In this lesson you'll learn about how to apply Newton Raphson Root finding Technique to find Minimum and Maximum of a 1D Function and how to adjust a Newton Raphson root finding code to find the optima of a function

In this lesson you'll learn about how to use Excel's inbuilt Solver tool to solve optimization problems