Solve Nonlinear Equations with Microsoft Excel
HTML-код
- Опубликовано: 9 ноя 2024
- The GRG (Generalized Reduced Gradient) solver in Excel can be used to solve sets of nonlinear equations. The nonlinear functions are input as cells and equation residuals are minimized. Functions can either be included as equality constraints, inequality constraints, or as objective function terms. Excel solver is best suited for problems with few decision variables (~100 or less). See apmonitor.com/c... for additional course content and solvers in MATLAB and Python.
Great tutorial, thanks. Please, how do I use excel to plot a system of nonlinear equations like this one:
x^2 - y^2 +x -y -2 = 0 (1)
x^2 + y^2 +4x -2y -20 = 0 (2)
Try using Desmos online graphing calculator
@@apm Thanks
Thank you very much for this sir. Very helpful.
I can't get it. Why did you square and add both the equations?
One solution method is to calculate a single objective function to minimize. The objective (sum of squared errors of constraint residuals) should be zero at the solution when the equations are satisfied.
thank you, but what i do if i have a log or ln equation
You can change the equation to anything that excel supports.
What a great tutorial. Thank you very much!
sir can we solve equation of 5 variables ?
Yes, but Excel solver isn't very good for anything more complex. I recommend either MATLAB or Python when you have multiple equations: apmonitor.com/che263/index.php/Main/PythonSolveEquations and here are some exercises: github.com/APMonitor/data_science/blob/master/10.%20Solve_Equations.ipynb
@@apm thank you sir
Sir I need to solve 5 equation of 5 variable at a time how I can do it in excel .
Sir I don't have knowledge of coding
Please help me out
@@dineshkumarsaw8143 Follow these instructions if they are linear or nonlinear: apmonitor.com/che263/index.php/Main/ExcelSolveEquations
Hindi me bhi video daal diya karo
+ABHISHEK DWIVEDI, क्या इस वीडियो के लिए हिंदी उपशीर्षक उपलब्ध हैं? Google कभी-कभी पाठ का अनुवाद कर सकता है मैं इस विषय के लिए हिंदी वीडियो का नहीं जानता हूं।