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.
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!
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.
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
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!
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!
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.
Thanks! My Arrhenius model fits perfectly now, because of your video.
Thanks. You saved me like a whole day of work.
Exceptional video - exactly what I was looking got!
Terrific video, very informative. Thank you!
Thank you SO much. This video is awesome, you helped me a lot!
OMG thank you so much for posting this
thank you verrrrrrrry much , i serch for this vedio depuis long time
its verry clear simlpe and effective
Exactly what I needed. Let's do science.
Thanks! Great help!
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!
Very useful...Many thanks!
thank you for this tutorial, i find it verry usefull
Thanks you. It is very very helpful.
That. Was. Awesome.
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.
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
Thank you so much! :)
Thank you for wonderful video, shall i have the data for practicing
Thank you very much ;-)!!
many thanks ..
Thank u!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thanks, excel...lent!
Excellent... Can this be applied to a generator start scenario?
So helpful.
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.
Oh.. my fucking god... I love you.
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...
Legend
great, and how to see R² in this case?
Kim Thuy Tran R^2 does not apply to nonlinear modeling
please provide Excel file to practice the same
"Data are", not "data is".