How to fit non-linear equations in excel using solver

[@amishsattelitedish8615]

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.

[@TaylorSparks]

You are absolutely correct. Thanks for pointing that out.

[@michealcairns4971]

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

[@TaylorSparks]

Thank you!! Let me know what else would be helpful!

[@michealcairns4971]

@@TaylorSparks Is there any other way of further optimising the solvers fit within excel?

[@TaylorSparks]

@@michealcairns4971 I'm sure there is. I'm not an expert in using Excel's solver though.

[@meganmcgee8187]

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

[@TaylorSparks]

So glad to help!

[@zahraghassemi2686]

Same happened to me. Thank you.

[@pragyandash6521]

Same for me

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

[@TaylorSparks]

Feedback like this makes me so happy.

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

[@TaylorSparks]

Yeah, a lot of people think machine learning and AI are more sophisticated than they really are. If you are interested in materials informatics I have a whole playlist from a course that I teach here at the University of Utah. Check it out

[@feynstein1004]

@@TaylorSparks Wow, didn't expect you to reply so quickly. Or at all 😂 Thanks for the video. It really helped me out. I'll check out your other stuff too when I get the chance 😃

[@chadmace3355]

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

[@carloscantu8890]

Great explanation. Straight to the point and without missing any necessary details. I'll look at your videos for future questions.

[@timr3621]

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

[@TaylorSparks]

Glad to help dude!

[@ruslanakbar2730]

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

[@TaylorSparks]

Thank you so much! Do me a favor and check out our podcast Materialism. You can find it on any platform and we would love to get an iTunes review if you've got a second. ;)

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

[@TaylorSparks]

I gotchooo boo

[@georgehellas8184]

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

[@TaylorSparks]

My pleasure!!

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

[@kurry4209]

Dude, helped me out so much, thought I had to redo all of my measurements for a uni project. Very well done!

[@TaylorSparks]

My pleasure! Give the video a like, sub and share and it will help me keep making content like this

[@kazanrao]

kzbin.info/www/bejne/Y6O6YaRnZq-Al8k

[@prasannareddy095]

i LOVE THE VIDEO, I ASKED MANY PEOPLE ABOUT IT, BUT NONE COULD EXPLAIN ME BETTER. Thank you

[@TaylorSparks]

Glad to help!!

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

[@TaylorSparks]

I'm so glad it was helpful!

[@ozandemir8822]

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

[@TaylorSparks]

Lol. Glad to help friend!

[@dr.ajaysujan2258]

Explain everything in very easy manner... Nice job

[@TaylorSparks]

Heck ya

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

[@TaylorSparks]

Thanks dude!!

[@kiendagaetanvianneyramde27]

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

[@TaylorSparks]

Glad to help!

[@sandinomichaelangeloaguila3823]

hi fellow chemical engineer

[@esraelsamuel1473]

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

[@TaylorSparks]

Super glad to help. Thanks for tuning in.

[@bowenqin8013]

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

[@TaylorSparks]

Great point. Very happy to help.

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

[@francoistardif3091]

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

[@TaylorSparks]

Thank you so much. I'm super glad to help

[@yusif97abdin]

Short, direct and extremely helpful

[@TaylorSparks]

Glad it was useful!

[@chandrakanthmalyala1942]

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

[@TaylorSparks]

It's so great

[@leilanemdili3724]

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

[@TaylorSparks]

🙌🙌🙌

[@saidfigueredo]

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

[@TaylorSparks]

Super glad to help!

[@karankotian04]

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

[@donxevir]

Thank you. Saving a students life rn.

[@kazanrao]

kzbin.info/www/bejne/Y6O6YaRnZq-Al8k

[@alexhands8229]

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

[@TaylorSparks]

Woohoo!! This feedback makes me so happy. You might like our materials science podcast "Materialism." Drop us a review if you can.

[@andrewniven4350]

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

[@eqwan]

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

[@christiankeza]

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

[@TaylorSparks]

wow! I'm so glad to help! Good luck on your defense.

[@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).

[@Dngsz6565]

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

[@albertlee7433]

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

[@govhull9933]

Great explanation! Clear and straight to the point. However, the main problem with fitting curve is to find the potential fitting equation to work on :)

[@TaylorSparks]

Ya. There's no substitute to some basic mathematics. They really are helpful when getting an equation of the right form.

[@KamalSingh-dn7gv]

I have one word. Beautiful video. Thanks

[@TaylorSparks]

Heck ya!

[@adityamanimishra5053]

Its great video. Very short and only informative. Thanks

[@TaylorSparks]

Glad to help!!

[@adityamanimishra5053]

@@TaylorSparks I am looking for parameter estimation for a system of ODE direclty without finding its solution. I would be grateful if you suggest anything to me.

[@roykeyer2174]

Perfect video! Thanks for your great instruction

[@TaylorSparks]

@@roykeyer2174 Happy to help!

[@N8Kracken]

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

[@coltonsowsun3681]

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.

[@TaylorSparks]

Right? Makes a big difference

[@Yomohayaru]

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

[@TaylorSparks]

Heck ya homie!

[@CivilEngineeringStuff]

Thank you. Great Explanation. Very helpful

[@rozhinmkian6325]

Now this is magic! Thanks alot, very helpful!

[@TaylorSparks]

Glad to help! Please like subscribe and share!

[@liatzavodivker8087]

THANKS! Your explanation was super clear!

[@TaylorSparks]

Glad to help!

[@rexkurosaki9368]

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

[@TaylorSparks]

oh oh awesome, I'm always glad to help. Do me a favor and subscribe like and share. I'm trying to grow this channel so that more people can find it.

[@emihlengqeme6823]

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

[@InfinityLRDL]

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

[@TaylorSparks]

Pleasure to serve!

[@nipunweerakoon_97]

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

[@Remenry]

This helped me A LOT! Thank you!

[@TaylorSparks]

Glad to help!

[@architkulkarni4873]

Hi Taylor, thank you for such precise explanation. I want to know how can we find uncertainty in fitting parameters and eventually the goodness of the fit?

[@souravnahihoonmain]

Really helpful video I used this in conjunction with Gompertz forecasting equation and found the optimal constants for forecasting shipment nos

[@TaylorSparks]

Glad it helped!!

[@apnaphysics_]

very helpful,keep uploading this type of content

[@TaylorSparks]

Got a specific need?

[@hassanelbari8636]

Thank you Taylor for sharing this very important video

[@TaylorSparks]

Glad to help! Sub to see more content.

[@rogelv8td]

Thanks, very useful and quick video.

[@larryblackwell700]

That was a fantastic video. Great presentation. Thank you

[@TaylorSparks]

So glad that it was helpful! Let me know if I can help with another topic. I also appreciate if you can like and subscribe to help me grow my channel.

[@tibistibility]

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

[@drandrewsanchez]

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

[@TaylorSparks]

That's wonderful!

[@tecnocato]

Got here for the same reason. Thank you, Taylor!

[@jannieschluter9670]

Reported covid19 cases are forged...

[@tecnocato]

Jannie Schlüter Wear an aluminum foil hat. Problem solved.

[@jannieschluter9670]

@@tecnocato you already wearing it. Nothing gets through your thick melon. 🙉

[@collegemathematics6698]

Greatest curve fitting vedio.. Thank you. 🌹 🌹

[@TaylorSparks]

Why thank you!

[@collegemathematics6698]

@@TaylorSparks you did great jobe. You deserve a big thanks. 🌹

[@melkamualebachew2845]

Thanks. I am using this for my thesis regression analysis!!!

[@gabrielmariz9610]

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

[@kazanrao]

kzbin.info/www/bejne/Y6O6YaRnZq-Al8k

[@theblueshade_]

Helped me a lot, thanks

[@kiwah07]

amazing video! Very good job!

[@Prixi33]

This video helped me so much thank you man

[@鄭景鵬-k4v]

THANKS! Your explanation is awesome! It is helpful!

[@TaylorSparks]

Very glad to help

[@chandrakanthmalyala1942]

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

[@TaylorSparks]

From domain knowledge. I've seen that shape before so I figured it would work.

[@RAVIKIRANMudunuru]

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

[@staygreasy]

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

[@biubiuedel1248]

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.

[@bwiredenis898]

Thanks a lot, very helpful. I got it

[@George-rq1yp]

wow very helpful demo, thank you!

[@aditibahuguna7723]

Thank you so much, great explanation.

[@muthuprithivi744]

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?

[@ganesharya3512]

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)

[@gaidanny]

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

[@hoseinpahlavan9295]

Thanks Taylor . That's very helpful:)

[@halilyilmaz3586]

Well explained. Thank you.

[@TaylorSparks]

💪🏻💪🏻💪🏻

[@bobrivera6667]

It was very helpful, thank you

[@ErrysFrondarina]

very helpful, thank you sir!

[@Jehosafath]

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.

[@ganesharya3512]

if i have two indepent variables and I do not know the relationship between my indepent variables and dependent variable then how can obtain the fit model

[@TaylorSparks]

I do that exact thing in this video

[@Warda.H]

This was really useful. If i've calculated the fit how doi calculate the upper and lower limits at 95 % confidence level in excel?

[@sajjadali6147]

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

[@sanadaltarawneh3550]

You are a legend.

[@tarak993]

Fantastic video and explanation. Please let me know if you are familiar with other functions similar to Avrami without an upper bound. Thanks!

[@TaylorSparks]

Just exp(x)?

[@atiliaathira11]

Love the way you explained. Very clear. Thank you so much,

[@TaylorSparks]

Glad it helped!

[@emilyreeves3234]

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

[@chadakarnsirasitthichoke9359]

Thank you. This is very useful!

[@mkadkfa]

v.v. helpful thank you bro

[@khadidjamessabih0394]

thanks a lot its very helpful i really appreciate it 🙏

[@TaylorSparks]

Glad to help! Check out our podcast Materialism available as a playlist on my channel 😁😁😁

[@AbiJohnson-c7x]

Hi Taylor, how did you have the orange fit line on your scatter graph before you started, so that it then followed the calculations you were inputting along the way? I only have my scatter points currently on my graph and no idea how to get the fit line on there as well, before starting the fit line equations you're suggesting. Apologies, I'm a complete novice on Excel. Thanks in advance.

[@PetualangWawasan]

Very helpfull tutorial, thanks!

[@kazanrao]

kzbin.info/www/bejne/Y6O6YaRnZq-Al8k

[@taniyakekunawelapathiranag4888]

This is very helpful! Thank you so much...

[@addisonaverill1196]

This was so helpful! Thank you!

[@motriz-industrial6846]

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

[@theapexpredator157]

I need Solver to accept formulas in the Variable Cells Line so that it can select only certain cells within a range. Is this possible? If not, is there an alternate method to achieve my goal?

[@TaylorSparks]

lots of good info here www.solver.com/solver-tutorial-defining-constraints

[@theapexpredator157]

@@TaylorSparks I appreciate the help, but after reading through the webpage you sent, I don't feel as though my situation has changed. I'm still dealing with the same issue. Thanks for the feedback though, I appreciate it!

[@nivedithareddy5279]

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

[@muthuprithivi744]

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

[@TaylorSparks]

The equation I'm using is called the Avrami equation. It's used in modeling polymer crystallization vs time as well as other structural transformations in materials science. It has a nice S shaped curve that we can fit to other S shaped data.

[@NOx2N2]

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