OU - OER - Ancillary Materials: Recent submissions
Now showing items 21-40 of 46
-
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 -
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. -
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. -
3.6 - Right Circular Cone
(6/27/18)In this lesson you'll learn about how to apply the Newton Raphson Technique to find the root of a 2D right circular cone function. -
3.4 - Newton Raphson using different guesses
(6/26/18)In this lesson you'll learn about the effect of using different educated guesses on the output root of the function -
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. -
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 ... -
4.6 - LU Decomposition by generating Inverse A
(7/3/18)In this lesson you'll learn about how to solve a system of equations using LU Decomposition by generating A inverse and how to develop a LU Decomposition A inverse VBA Code -
4.2 - Addition, Multiplication & Transposition of Matrices
(6/28/18)In this lesson you'll learn about addition, multiplication and transposition to two matrices in addition to what a Principle Diagonal, Principal anti-diagonal, identity and unit matrices -
4.3 - Gauss Elimination with Partial Pivoting
(7/5/18)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 -
4.5 - LU Decomposition
(7/2/18)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 -
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. -
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. -
4.7 - Debugging a Multiplication Code
(7/4/18)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. -
5.2 - 1D Optimization - Gold-Section Search
(7/11/18)In this lesson you'll learn about how to apply the golden section search technique to find Minimum and Maximum of a 1D Function in addition to how to develop a golden section search technique -
5.3 - 1D Optimization - Newton Raphson
(7/10/18)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 -
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. -
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 -
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