Nonlinear Model Fitting using Excel 

Amazing. You made me, a complete "math never learning" person understand and try with my model. Thanks!

Much gratitude for this straight to the point video that basically simplified what textbooks, articles and lectures make complicated. Thanks so much for your effort. You have really helped so many desperate students out there.

Thank you so much for the video! I don't know how I would've finished my school project with your help!

You are great at teaching! Thank you for the video! I had to post this before I even finished watching the video.

immensely thankful!!! You solve me two days of struggles and my data finally make sense!!! TKS so much!!! Clear, effective, simple!

You saved my Chemistry lab report. Thank you for such an incredibly helpful and informative video!

Excellent! Helped me a lot to fit a Thermodynamics model!

Thanks! My Arrhenius model fits perfectly now, because of your video.

Nice video, I have been using the solver frequently lately but was resorting to Matlab to fit a nonlinear function like this. This seems so obvious now I can't believe I didn't think of this! I would also recommend defining variables using the name manager rather than using absolute references. This makes the equations much more readable, especially if referencing a value on another sheet.

Exceptional video - exactly what I was looking got!

Terrific video, very informative. Thank you!

OMG thank you so much for posting this

Thank you SO much. This video is awesome, you helped me a lot!

Thanks. You saved me like a whole day of work.

Thanks! Great help!

Very useful...Many thanks!

That. Was. Awesome.

Exactly what I needed. Let's do science.

thank you for this tutorial, i find it verry usefull

thank you verrrrrrrry much , i serch for this vedio depuis long time its verry clear simlpe and effective

Thanks you. It is very very helpful.

Thank you so much! :)

This is a great video! Thank you! I also need to find the error of those values that are estimated with the solver, so the answer comes to +/- the value. Could you help me with that ? Thank you and thumbs up!

Thank you very much ;-)!!

So helpful.

many thanks ..

This was well explained, but I need to do something a little more complicated. I'm trying to do a multiple nonlinear regression - that is, with at least two parameters needing to be estimated. Using Solver for this is not hard - just change the objective to encompass the two variables. But, I'm wondering how to calculate error bars on each parameter individually. I know how to get a 95% confidence interval on a nonlinear regression, but it only makes sense when there is one parameter.

Thank u!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Thank you for wonderful video, shall i have the data for practicing

But this does not give the R squared and other important info like F and p. If the relationship were nonlinear, would using the Correl function give you the R squared of a nonlinear relationship? thanks

Thanks, excel...lent!

Oh.. my fucking god... I love you.

Excellent... Can this be applied to a generator start scenario?

Legend

Hello, I am watching your video on RU-vid and I founded very interesting and useful. I am writing to ask your help. I need to make the below regression but I don’t know how. If is possible, please let me understand if something is different in this equation since inside has minus: Abnormal return(t+1)=β(earnings(t+1)-α0-α1(earnings(t))+ε(τ+1) Also I have a problem to understand what value has α0, because is coming from another regression which is : earnings(t+1)=α0+α1(earnings(t)+ε(τ+1) so for α0 I don’t have a column wich to select in exel for regression. kindly regards, Loredana.

Hi, is there a way to find the R^2 value of a nonlinear model that we have fit using excel?

Lets do fucking science! thank you men, this will looks great in my adsorption article, now I have to use some Error functions to validate such regression I think...

great, and how to see R² in this case?

please provide Excel file to practice the same

"Data are", not "data is".