Solver in Excel for Non-Linear Fit Plotting

A quick tutorial on using Solver in Excel for non-linear fit plotting.

[@manuelhonle2846]

You saved my life. A Big thanks to you

[@serdimi]

You literally just saved my friend's thesis

[@frmr121]

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

[@anand99859639]

Excellent. Greatly useful video.

[@LucasNBA2K]

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

[@AJ-et3vf]

Awesome video! Thank you!

[@modernibiofyzika]

Excellent! Thank you for your very comprehensive tutorial!

[@lorenzomusa4993]

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]

@Lorenzo Musa instablaster =)

[@lorenzomusa4993]

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

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

@Lorenzo Musa No problem :D

[@chantellelindangwenya6409]

thank you, very helpful

[@tuhocr]

Thank you for sharing this helpful video.

[@matteomodolo1520]

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

[@Guilopes99]

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

[@mattfuka191]

very nice right to the point

[@yamangokcek2119]

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

[@ganesharya3512]

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

[@kkm5384]

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

[@Klikmac]

Thank you!!!

[@user-py8ih1fm3d]

How we can determine our guess values?

[@charuniehansika1100]

Great!!

[@in-trance2642]

Thank you

[@thekonyawo6107]

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]

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

[@mahbuburrahmankiran9888]

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

[@kkm5384]

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]

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.

[@dr_greg_mouse4125]

How can we find the equation of this line?

[@PhysiKarlz]

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]

@@PhysiKarlz oh! Got it. Thanks a lot

[@haniffshazwanss5720]

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]

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]

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

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

[@haniffshazwanss5720]

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]

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.

[@Jun-il8ci]

genius

[@AltayNuhoglu]

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

[@PhysiKarlz]

Thanks.

[@738shani]

F4 to make cont, relief

[@kuntimaddisadananda9678]

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

[@PhysiKarlz]

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

[@rockkingpeza123]

What the bloody hell is darrrrta?

[@PhysiKarlz]

I don't know. What is it?

[@greatmind3842]

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

[@PhysiKarlz]

Use the pause or the slower playback option.