How to fit non-linear equations in excel using solver

Tutorial of how to fit non-linear curves in excel using solver. This tool lets you fit custom equations to your data. For example in this example we fit data to a modified version of the Avrami equation.
Thanks to Ozkar and Finke for their data and if you want to learn how to grab data from papers using WebPlotDigitizer, check out my video tutorial.
• Tutorial of WebPlotDig...

[@matthulvey8615]

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.

[@IrishJade84]

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!

[@charlierettner5286]

Great job leading us through this so smoothly. I suspect that most people coming here are like me and know what they want Excel to do but had no idea it could do it. It took me about 60 seconds to learn how to use solver from your video, as opposed to never on my own. Thanks!

[@chadmace3355]

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

[@ProcrastinatingPoet]

Thank you for the clear introduction! Like another commenter I am trying to fit dose response curves which all have starts of 0, and it goes very odd, but you've got me further in a few minutes than I expected and opened my eyes to what's possible in excel (I don't get coding, despite trying to learn).

[@sergiopipaonalcibar7885]

Great video. There is a lot of people out there doing super complex explanations for this, but this one is perfect. Thanks a lot.

[@feynstein1004]

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.

[@N8Kracken]

Absolutely awesome video. Clear and to the point. Great work mate.

[@ruslanakbar2730]

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

[@leilanemdili3724]

This is the best video that explained the regression fitting. Thank you!

[@rainbowdust919]

Thank you! I just started a statistics class and I did not understand the residual until I saw it happen, visually, on your graph.

[@potatofries571]

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!

[@michealcairns4971]

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

[@mjmeternal2696]

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.

[@andrewniven4350]

Excellent video - I now use the solver option a great deal in my work. Thank you.

[@georgehellas8184]

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

[@albertlee7433]

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

[@meganmcgee8187]

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

[@karankotian04]

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

[@francoistardif3091]

Absolutely excellent, enjoyable, clear and precise. Well done sir!