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.
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!
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!
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. ;)
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!
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.
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.
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
@@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 😃
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).
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 :)
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?
@@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.
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.
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.
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?
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.
You are absolutely correct. Thanks for pointing that out.
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!
Feedback like this makes me so happy.
As a researcher myself investigating heterogeneous behavior, this short tutorial was extremely helpful. Brilliant explanation, Subscribed!
Thank you!! Let me know what else would be helpful!
@@TaylorSparks Is there any other way of further optimising the solvers fit within excel?
@@michealcairns4971 I'm sure there is. I'm not an expert in using Excel's solver though.
Great explanation. Straight to the point and without missing any necessary details. I'll look at your videos for future questions.
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!
I'm so glad it was helpful!
Hey, Taylor! Just wanted to thank for your all work, from material science to statistics!!!
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. ;)
all these years I've always used Matlab or Python... Often find myself in Excel... this will work well. Thank you!
This is amazingly helpful! I watched numerous videos trying to do logistic regression fitting and this is the only one that helped me!
So glad to help!
Same happened to me. Thank you.
Same for me
You explained it in 6 minutes better than my docent in 2 90min sessions, thank you so much!!
Glad to help dude!
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!
I gotchooo boo
Great video. There is a lot of people out there doing super complex explanations for this, but this one is perfect. Thanks a lot.
Thanks dude!!
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.
Thanks, you literally saved me trying to interpolate a sine wave to data that looked like a sine wave. Again thanks!!!!!
My pleasure!!
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.
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
@@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 😃
This is one of the most beautiful video on youtube. God! It's so good.. Thank you!
Lol. Glad to help friend!
Dude, helped me out so much, thought I had to redo all of my measurements for a uni project. Very well done!
My pleasure! Give the video a like, sub and share and it will help me keep making content like this
ua-cam.com/video/-rW0q11JMag/v-deo.html
Explain everything in very easy manner... Nice job
Heck ya
i LOVE THE VIDEO, I ASKED MANY PEOPLE ABOUT IT, BUT NONE COULD EXPLAIN ME BETTER. Thank you
Glad to help!!
Short, direct and extremely helpful
Glad it was useful!
This is the best video that explained the regression fitting. Thank you!
🙌🙌🙌
Absolutely excellent, enjoyable, clear and precise. Well done sir!
Thank you so much. I'm super glad to help
You’re amazing boyyyy!!! You just solved one of my chemical engineering project .Thanks
Glad to help!
hi fellow chemical engineer
Thank you so much. It helped me a lot. Your explanations are simple and very efficient.
a good solution to find the equations for solving "the area of hysteresis" problem. Thank you so much
Great point. Very happy to help.
Wow.... you teach me what i really want. Thanks a lot!!!
Thank You, Taylor. I was trying to fit using MATLAB. However, your video is awesome
Super glad to help. Thanks for tuning in.
Thank you. Saving a students life rn.
ua-cam.com/video/-rW0q11JMag/v-deo.html
Awesome video! Helping me with my studies. Thanks a lot!
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).
Thank you! I just started a statistics class and I did not understand the residual until I saw it happen, visually, on your graph.
Absolutely awesome video. Clear and to the point. Great work mate.
Amazing video, love your work, saved my chemistry degree xxxx
Woohoo!! This feedback makes me so happy. You might like our materials science podcast "Materialism." Drop us a review if you can.
thank you so much, Sparks. now I can defend my thesis!
wow! I'm so glad to help! Good luck on your defense.
Perfect video! Thanks for your great instruction
@@roykeyer2174 Happy to help!
I have one word. Beautiful video. Thanks
Heck ya!
Excellent video - I now use the solver option a great deal in my work. Thank you.
My english listening is very very bad, but it was no a problem for I reproduce your procedure, excellent, thank you so much bro
Super glad to help!
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 :)
Ya. There's no substitute to some basic mathematics. They really are helpful when getting an equation of the right form.
THANKS! Your explanation was super clear!
Glad to help!
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?
this make me more understand about sigmoid value. Thank you!!!
Heck ya homie!
Mr. Sparks thank you very much!! You did me a big favor!!!!!!!!
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.
Its great video. Very short and only informative. Thanks
Glad to help!!
@@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.
Now this is magic! Thanks alot, very helpful!
Glad to help! Please like subscribe and share!
Wow thank you so much...i now have a clear understanding of this work
Thank you. Great Explanation. Very helpful
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.
Right? Makes a big difference
I never knew about plot digitizer before watching your video and going through the description
It's so great
This helped me A LOT! Thank you!
Glad to help!
Thank you for help.. I tried to obtain wavefunction (800-data). Result: Great!! thanks 🎉🎉
Thanks, very useful and quick video.
very helpful,keep uploading this type of content
Got a specific need?
This is really helpful.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
That's wonderful!
Got here for the same reason. Thank you, Taylor!
Reported covid19 cases are forged...
Jannie Schlüter Wear an aluminum foil hat. Problem solved.
@@tecnocato you already wearing it. Nothing gets through your thick melon. 🙉
Helped me a lot, thanks
Thank you Taylor for sharing this very important video
Glad to help! Sub to see more content.
That was a fantastic video. Great presentation. Thank you
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.
amazing video! Very good job!
Greatest curve fitting vedio.. Thank you. 🌹 🌹
Why thank you!
@@TaylorSparks you did great jobe. You deserve a big thanks. 🌹
Really helpful video I used this in conjunction with Gompertz forecasting equation and found the optimal constants for forecasting shipment nos
Glad it helped!!
Thank you so much, great explanation.
This video helped me so much thank you man
Thanks. I am using this for my thesis regression analysis!!!
Thanks a lot, very helpful. I got it
THANKS! Your explanation is awesome! It is helpful!
Very glad to help
Well explained. Thank you.
💪🏻💪🏻💪🏻
Thanks Taylor .
That's very helpful:)
very helpful, thank you sir!
wow very helpful demo, thank you!
v.v. helpful thank you bro
It was very helpful, thank you
That was a simple and straightforward explanation. Can you say how did you assume the equation?
From domain knowledge. I've seen that shape before so I figured it would work.
Thank you. This is very useful!
Thank you 🙏 solve my question within 6 min lol. I’m trying to do my homework for mass transfer and needed this
Pleasure to serve!
This was so helpful! Thank you!
You are a legend.
Is there a way to modify that equation so that the graph is flipped horizontally?
Thanks! simple, and very useful!
Thanks! Like share and sub so I can grow the channel!
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.
thanks a lot its very helpful i really appreciate it 🙏
Glad to help! Check out our podcast Materialism available as a playlist on my channel 😁😁😁
Thank you sir
Nice explanation
How would you get the R^2 value from a nonlinear regression fit?
well explained , Thank you
This is very helpful! Thank you so much...
Very helpfull tutorial, thanks!
ua-cam.com/video/-rW0q11JMag/v-deo.html
Helpful, thank you so much
Gracias hermano! me ayudaste!
De nada che!
This is f*cking great!!! This helps me to pass my assignment
Glad to help homie
very nice work good work are there any other videos presenting the same ideas?
Love the way you explained. Very clear. Thank you so much,
Glad it helped!
Wonderfull video!!! Very precise and usefull information. I want to try doing this using Origin or R, but I need a video like this.
ua-cam.com/video/-rW0q11JMag/v-deo.html
This is so useful, thanks a lot!
Happy to help!
Great video
very helpful!! thanks!!
Thank you so much!! Really helpful!!
Excellent!
Fantastic video and explanation. Please let me know if you are familiar with other functions similar to Avrami without an upper bound. Thanks!
Just exp(x)?
so so great, thanks a whole lot
Glad to help
Great explanation but I wounder if I got different trend which equation should be used or same yours?
It totally depends on your trend. What does it look like?
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?
Sure, give it a try and see how it fits. You can calculate the r squared if you like.