How to fit non-linear equations in excel using solver 

Very helpful. One thing to note. The real reason we square the residuals is to ensure that that we are not minimizing the sum with positives and negatives. Being on either side of the fit is an error, but if left unchecked a residual of 0.1 and -0.1 would equate to zero when in fact they should be agnostic to which side the error occurred and sum to 0.2 . To fix that we square the values and everything is positive, thus finding the "least squares" gives us the best fit. I don't know if that is what you were implying in the video, but I did not hear that called out.

Thanks! However, when data are not just near model floats, excel can fail... That is not the case with numpy

I'm here from July 2023 and I'd like to say that this is EXACTLY how neural networks are trained. I watched Andrej Karpathy's full coding of ChatGPT and this is exactly what he did there. We have a certain expected output from the network. But the real output is different. We measure the difference i.e. residual i.e. error and work on minimizing that. That's literally all there is to it. The code is just there to make this process easier and find each parameter for billions of neurons.

As a researcher myself investigating heterogeneous behavior, this short tutorial was extremely helpful. Brilliant explanation, Subscribed!

Guys, how you calculate the R2 in that case ??

This is amazingly helpful! I watched numerous videos trying to do logistic regression fitting and this is the only one that helped me!

Thanks a lot, very helpful. I got it

all these years I've always used Matlab or Python... Often find myself in Excel... this will work well. Thank you!

very helpful, thank you sir!

I have watched so many videos on how to do this and this is the first one that actually made sense and where I actually understood what components went where. Amazing! Thank you so much!

Yes! Thank you! I will be using this for my research as well as for my own educational purposes of modeling covid-19 confirmed cases

It was very helpful, thank you

How would you get the R^2 value from a nonlinear regression fit?

You’re amazing boyyyy!!! You just solved one of my chemical engineering project .Thanks

Thank you for you comprehensive video. I have a simple question, How can we define the error or standard deviation from the fitting constant A, k, n ?? e.g. A+/- something, k +/- something and so on.

You are a legend.

Thank you for help.. I tried to obtain wavefunction (800-data). Result: Great!! thanks 🎉🎉

Thank you _/\_

Is there a way to modify that equation so that the graph is flipped horizontally?

Thanks, you literally saved me trying to interpolate a sine wave to data that looked like a sine wave. Again thanks!!!!!

Great video

Thank You, Taylor. I was trying to fit using MATLAB. However, your video is awesome

CURVEFIT Version 2.10N March 1, 1987 by Thomas S. Cox SHAREWARE

Hi Taylor, this video is very helpful, thank you. Just have a quick question, for inhibitory non-linear response curve, what equation should be used?

Excellent!

ty

Good

Thank you. Great Explanation. Very helpful

Thanks, very useful and quick video.

Wow thank you so much...i now have a clear understanding of this work

When I calculate the Y values with my model and then put them in a data set for the chart, i just have some theoretical points that correspond to the experimental points, i don't have a theoretical line. If i choose for the chart to plot the theoretical dataset as a line and not as points it just connects the theoretical points with straight lines instead of plotting my function with my calculated constants. I can get around it by calculating points for very small steps of the x value so there are many small straight lines that emulate a curve but it takes a lot of time and I feel that there is another way for the line to just represent the equation. Any solutions? Thanks to everyone that read this. *ps I'm using Libre Office Calc and not Excel but I do not think it really matters

good information. Goes pretty fast. I can't quite get my S shape curves to fit close enough. Any suggestions?

How can I estimate the parameters alpha and beta in a gompertz function based on the historical data, so that I can predict the values into the future.Want to know specifically how can I do that in the SPSS

Thank you for mentioning that the Solver needs to have a initial best fit that is somewhat close to the existing data! I tried this method after watching another video, the author failed to mention this and I was very frustrated after spending over an hour going thorough my excel sheet looking for problems that were not there.

This is really helpful.Thank you so much.😃😃

Hey!! Can we do this by using any programming language??

in the case of one independent variable equation can be guessed(by a plot) but how can I guess the equation in the case of more than one independent variable. suppose two independent variables (volume fraction and temperature ) then how can I guess the equation for fitting on excel (only by excel)

How did you got the y fit values in the graph ?.. for me the y fit line is not coming in the graph. Can you tell how to do that?

You made it very easy. In order to fit a model, bring any equation and very the parameters then go to Solver to minimise the sum of the squared Residuals (SSR) and this gives the best values for parameters.

Explain everything in very easy manner... Nice job

Well explained. Thank you.

Thanks!! Is there software that allows me to find the equation based on XY data but not using any known model?

Great explanation but I wounder if I got different trend which equation should be used or same yours?

Awesome video! Helping me with my studies. Thanks a lot!

Greatest curve fitting vedio.. Thank you. 🌹 🌹

After usisng that , can i have R2 and p values for the variables?

Wow.... you teach me what i really want. Thanks a lot!!!

wow very helpful demo, thank you!

Does anyone know where the A value is taken from? or is it just 1 as a standard?

Thanks Taylor . That's very helpful:)

how you put that fit line in your graph? I just can put x and Y axis only and do not know how to insert that fit line.

Thank you so much. It helped me a lot. Your explanations are simple and very efficient.

Thank you so much, great explanation.

Thank you sir Nice explanation

THANKS! Your explanation was super clear!

Thanks Taylor for the video. The solver in excel i understood well from your explanation. Can you please elaborate more that how i can start with the Y_fit equation just by looking at my data set ??? i mean you choose the exponential equation for your data set ???

Can someone help me create a master curve using time temperature superposition principle shift?

Thank you 🙏 solve my question within 6 min lol. I’m trying to do my homework for mass transfer and needed this

Thank you, that was really helpful.

Do you know how to find r-squared value? To see the best fit

Can we find the goodness of fit (GoF) from this?

That was a simple and straightforward explanation. Can you say how did you assume the equation?

My english listening is very very bad, but it was no a problem for I reproduce your procedure, excellent, thank you so much bro

Thank you for the explanation! Which model is better to use if I need to fix one curve of catalytic descomposition? It seems like the curve of your video. Can I use the same Avrami equation modified?

Thank you so much for this video ! It helped solved a problem I've been working on since Friday. Just one quick question, do you have a source to find the type of equation to use or is it emprical knowledge ? For your case I would've tried a sigmoid function but obviously I would have never gotten the fit you have.

hi, what if i have to run a macro each time? then how to use solver in a sheet with macro?

I never knew about plot digitizer before watching your video and going through the description

Helpful, thank you so much

This video helped me so much thank you man

this make me more understand about sigmoid value. Thank you!!!

Amazing video, love your work, saved my chemistry degree xxxx

god bless you

a good solution to find the equations for solving "the area of hysteresis" problem. Thank you so much

It is helpful. However, I need some further help regarding this topic. Please let me know, How can I contact you. Thank you.

well explained , Thank you

lifesaver!

very helpful!! thanks!!

Wonderfull video!!! Very precise and usefull information. I want to try doing this using Origin or R, but I need a video like this.

This is one of the most beautiful video on youtube. God! It's so good.. Thank you!

Hey, Taylor! Just wanted to thank for your all work, from material science to statistics!!!

bruh this explanation goes hard it was so clear and concise, I've tried to read how to use solver from other sources but they were always convoluted and not too useful. this video in contrast was good and efficient thank you!

Absolute legend! I manage to model the behaviour of nitinol using a similar equation, but is there a way of taking the SSR value and converting it to something like R-squared?

What if we don't know the equation?

Helped me a lot, thanks

very helpful,keep uploading this type of content

Mr. Sparks thank you very much!! You did me a big favor!!!!!!!!

Now this is magic! Thanks alot, very helpful!

thank you so much, Sparks. now I can defend my thesis!

Hey Taylor! Thanks for the video. Actually I know how to do it in excel. Do you have a video to do it in R STUDIO? or do you have a link to do it? Thanks a lot in advance!

I have one word. Beautiful video. Thanks

This is f*cking great!!! This helps me to pass my assignment

What if have one response variable, and four factors ( four independent variables)? How is the equation going to be?

Thank you. Saving a students life rn.

Thank you. This is very useful!

Hey, thank you for the video. What if my graph goes from high values to lower values?

amazing, thanks!

Thank you. That helps

Thank you Taylor for sharing this very important video

What type of graph are you using in this vedio.. can you mention its name and how you got that y fit in graph?

You explained it in 6 minutes better than my docent in 2 90min sessions, thank you so much!!