Browsing OU - Open Educational Resources (OER) by Title
Now showing items 21-40 of 110
-
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.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.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 -
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.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.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. -
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 -
5.5 - Non Linear Optimization Using Solver
(7/14/18)In this lesson you'll learn about how to use Excel's inbuilt Solver tool to solve optimization problems -
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 -
6.2 - Polynomial Regression
(7/16/18)In this lesson you'll learn about how to find the best fit line to a set of curved data points and how to develop a polynomial regression program. This in followed by a comparison to the results from Excel's inbuilt linear ... -
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 -
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. -
7.2 - Simpson's 13 Rule
(7/20/18)In this lesson you'll learn about how to approximate an area under the curve using the Simpson's 1/3 Rule and how to develop a VBA code to implement this technique to any desired approximate error in addition to how the ... -
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 ... -
7.4 - Conv. Forward Vs. Conv. Centered (1st & 2nd Derivative)
(7/23/18)In this lesson you'll learn about how to approximate derivatives using the conventional forward and centered finite difference approximations -
7.5 - High Accuracy Vs. Conv. Centered (1st & 2nd Derivatives)
(7/23/18)In this lesson you'll learn about how to approximate derivatives using the High Accuracy centered finite difference approximations and how it compares to the conventional finite approximations -
8.1 - Euler's Method
(7/27/18)In this lesson you'll learn about the concept behind applying Euler's Method to solve Ordinary Differential Equations and learn how to write a VBA code to apply Euler's Method