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.
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.
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
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.
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!
Hello, I am watching your video on UA-cam 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.
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...
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.
Amazing. You made me, a complete "math never learning" person understand and try with my model. Thanks!
Thank you so much for the video! I don't know how I would've finished my school project with your help!
immensely thankful!!! You solve me two days of struggles and my data finally make sense!!! TKS so much!!! Clear, effective, simple!
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.
You are great at teaching! Thank you for the video! I had to post this before I even finished watching the video.
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!
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
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.
Thanks! My Arrhenius model fits perfectly now, because of your video.
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!
Thanks. You saved me like a whole day of work.
Excellent... Can this be applied to a generator start scenario?
Hi, is there a way to find the R^2 value of a nonlinear model that we have fit using excel?
Exactly what I needed. Let's do science.
Hello, I am watching your video on UA-cam 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.
thank you verrrrrrrry much , i serch for this vedio depuis long time
its verry clear simlpe and effective
Terrific video, very informative. Thank you!
Exceptional video - exactly what I was looking got!
Thank you for wonderful video, shall i have the data for practicing
Very useful...Many thanks!
great, and how to see R² in this case?
Kim Thuy Tran R^2 does not apply to nonlinear modeling
Thanks you. It is very very helpful.
Thank you SO much. This video is awesome, you helped me a lot!
Oh.. my fucking god... I love you.
thank you for this tutorial, i find it verry usefull
please provide Excel file to practice the same
Thanks, excel...lent!
OMG thank you so much for posting this
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...
That. Was. Awesome.
Thanks! Great help!
Thank you very much ;-)!!
many thanks ..
"Data are", not "data is".
Thank u!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thank you so much! :)
So helpful.
Legend