Solver in Excel for Non-Linear Fit Plotting

Поделиться
HTML-код
  • Опубликовано: 1 авг 2024
  • A quick tutorial on using Solver in Excel for non-linear fit plotting.

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

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

    You saved my life. A Big thanks to you

  • @serdimi
    @serdimi Год назад +2

    You literally just saved my friend's thesis

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

    thank you! I have never gotten this to work before this video!!

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

    Excellent. Greatly useful video.

  • @LucasNBA2K
    @LucasNBA2K 4 года назад +4

    Thank you! One more question...how can you relate SSR to R square in a trendline?

  • @AJ-et3vf
    @AJ-et3vf 2 года назад

    Awesome video! Thank you!

  • @chantellelindangwenya6409
    @chantellelindangwenya6409 5 лет назад +2

    thank you, very helpful

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

    Hello! Very helpful video, thank you. Do you know how to show the R^2 between the data and the fitting curve?

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

    Amazing tip! Would this work for something like multiple non-linear regression?

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

    very nice right to the point

  • @tuhocr
    @tuhocr 3 года назад

    Thank you for sharing this helpful video.

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

    Excellent! Thank you for your very comprehensive tutorial!

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

      i guess Im asking the wrong place but does anybody know of a method to get back into an instagram account??
      I was dumb forgot my account password. I would love any tips you can give me

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

      @Lorenzo Musa instablaster =)

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

      @Joziah Jesse I really appreciate your reply. I got to the site on google and im in the hacking process atm.
      I see it takes quite some time so I will get back to you later when my account password hopefully is recovered.

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

      @Joziah Jesse it did the trick and I now got access to my account again. I'm so happy:D
      Thank you so much you saved my ass :D

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

      @Lorenzo Musa No problem :D

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

    how can SOLVER find the value of x-intercept of an equation by using nonlinear regression? Thank you.

  • @Klikmac
    @Klikmac 5 лет назад +1

    Thank you!!!

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

    how can i develop a relationship for the data having multiple independent variables and I do not know the formula

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

    hi, i tried for a polynomial fit like Y=Ax^2+Bx+C. but it did not work.

  • @charuniehansika1100
    @charuniehansika1100 3 года назад

    Great!!

  • @in-trance2642
    @in-trance2642 4 года назад

    Thank you

  • @thekonyawo6107
    @thekonyawo6107 5 лет назад +1

    Given a system of two non-linear first order ODEs(Lotka-Volterra equations) and data, how to find parameters of the system?........Plz Help

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

      Llllll
      llloiil
      llllo llama lagi llllll llllll LOLOLLOLOLLIOILOOOOLO illoilolloollllolllllœl. lllllll. l llllll l llllll lllllllllllllllll. llllllllll. lllllllll. llllllllllllllll. llllllllllllllllllllllllll. l. lll. lllllll
      lllllllllllllllllllllllll. llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll. llllll. lllllllllllllp

  • @user-py8ih1fm3d
    @user-py8ih1fm3d 4 месяца назад

    How we can determine our guess values?

  • @mahbuburrahmankiran9888
    @mahbuburrahmankiran9888 5 лет назад +1

    how is it written as
    $A$15 for constant A?

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

      do you mean how to insert that dolar sif=gns? hope you got by this time. if not press F$ key. if you keep pressing the F4 it changes the doalr sign options for Column or row, or both.

  • @zahidurrahaman428
    @zahidurrahaman428 5 лет назад +4

    This is very helpful. However, I want to fit a complex function which have two part real part and imaginary part (such as Debye model for dielectric constant). It would be helpful for me if you make a tutorial for fitting complex function.

  • @Jun-il8ci
    @Jun-il8ci 3 года назад

    genius

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

    helo there, i learned alot from this video. Now im able to create the same thing as you. thank you so much. but i just want to ask you something, the formula that you written there was A*expBx+c . can i know the meaning of B in the formula? is it power exponential? B with (subscript of x) ?

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

      if i need to find the gradient and the y-intercept. which one is it in your formula? if im not mistaken supposedly the b should the gradient and c is the y-intercept, right? sorry for the bad english.

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

      @@haniffshazwanss5720 A, B and C are constants. B is the "decay constant" (there are several names for it) and x is the x-value similar to it being the x-value in y=x and so is not a subscript of B.
      So it's clearer I'll add an asterisk between B and x, the equation is the A*exp(-B*x)+C, where A is the intial value, B is mentioned above and C is the offset. C is not the y-intercept because at x=0 we have y=A*exp(0)+C = A+C. Meaning C can only be the y-intercept when A=0 but then we have eliminated our exponential function.

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

      @@haniffshazwanss5720 B is not the gradient either. To find the gradient of an exponential you must differentiate the function.

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

      I see. So let say that im using the same formula like u did in the video, and i want to find the gradient of the equation, i should then differentiate it , right?

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

      Im doing a study about gastric meal emptying over time. The meal is mix with small amount radioactive drug tracer so that we can observe the progress of the meal in the stomach. I hv Y value as meal retention and X value as time after meal ingestion. Most of related study said i should do non linear least square fit to get the y intercept and gradient and from there and i can get the time-activity curve of gastric emptying.
      Now im stuck at non linear plotting. Thats why i asked for your advice and i need help from mathematicians.
      Sorry to take your time.

  • @dr_greg_mouse4125
    @dr_greg_mouse4125 5 лет назад

    How can we find the equation of this line?

    • @PhysiKarlz
      @PhysiKarlz  5 лет назад +2

      In my example look at cell C1, then substitute the values for A, B and C as found in the cells A14, B14 and C14.
      You have then the equation of this curve.

    • @dr_greg_mouse4125
      @dr_greg_mouse4125 5 лет назад

      @@PhysiKarlz oh! Got it. Thanks a lot

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

    use =SUMSQ() on the residuals, skips a step

  • @738shani
    @738shani 2 года назад

    F4 to make cont, relief

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

    Too fast to follow - tried four time and still not clear what he is really doing. gave up.

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

      Use the pause button. Use the video speed adjustment options too.

  • @rockkingpeza123
    @rockkingpeza123 5 лет назад

    What the bloody hell is darrrrta?

    • @PhysiKarlz
      @PhysiKarlz  5 лет назад +1

      I don't know. What is it?

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

    Just a piece of advice. When you teach you don't assume that everybody knows everything...Go slow!

    • @PhysiKarlz
      @PhysiKarlz  4 года назад +4

      Use the pause or the slower playback option.