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.

Комментарии • 15

  • @GodSearch
    @GodSearch 2 года назад +1

    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)

    • @apm
      @apm  2 года назад

      Try using Desmos online graphing calculator

    • @GodSearch
      @GodSearch 2 года назад

      @@apm Thanks

  • @AJ-et3vf
    @AJ-et3vf 3 года назад +1

    Thank you very much for this sir. Very helpful.

  • @reshmanthm9598
    @reshmanthm9598 6 лет назад +2

    I can't get it. Why did you square and add both the equations?

    • @apm
      @apm  6 лет назад

      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.

  • @odaiqarqaz
    @odaiqarqaz Год назад +1

    thank you, but what i do if i have a log or ln equation

    • @apm
      @apm  Год назад

      You can change the equation to anything that excel supports.

  • @guardiansps5775
    @guardiansps5775 7 лет назад +2

    What a great tutorial. Thank you very much!

  • @dineshkumarsaw8143
    @dineshkumarsaw8143 4 года назад +1

    sir can we solve equation of 5 variables ?

    • @apm
      @apm  4 года назад +2

      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

    • @dineshkumarsaw8143
      @dineshkumarsaw8143 4 года назад +1

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

    • @apm
      @apm  4 года назад

      @@dineshkumarsaw8143 Follow these instructions if they are linear or nonlinear: apmonitor.com/che263/index.php/Main/ExcelSolveEquations

  • @Abhineet12345
    @Abhineet12345 7 лет назад

    Hindi me bhi video daal diya karo

    • @apm
      @apm  7 лет назад +1

      +ABHISHEK DWIVEDI, क्या इस वीडियो के लिए हिंदी उपशीर्षक उपलब्ध हैं? Google कभी-कभी पाठ का अनुवाद कर सकता है मैं इस विषय के लिए हिंदी वीडियो का नहीं जानता हूं।