That was very useful, thank you! What if I had 2 independent variables(Xs) and 1 dependent variable(Y) and I need to fit a quadratic equation for the data I have?
R^2 typically increases when you add variables to the model, so it's not a good measure of model prediction power in general, but particularly in this example. A better way to evaluate the value of a quadratic model is to look at the residuals, which is also possible using Excel. Always plot residuals when doing any analysis, but in particular with model selection
can u give the vab code to automate this process and the graph is not required i want polynomial equation with 5th degree order and where 5th degree polynomial is {f(x)=(A)+(Bx)+(C(x^2))+(D(x^3))+(E(x^4))+(F(x^5))} where f(x) and x values are give i required the values of A,B,C,D,E&F
Maybe there's a way to change those coefficients automatically, if the polynomial equation is set up as a formula - perhaps also with some conditional formatting or goal seek. I'm not sure, but we can play with it and figure it out!
This video is on point. Clear, efficient, and direct. Thanks a lot for putting it together.
i was struggling so hard and couldn’t find a better video for my stats hw!
What if the p-value for your coefficients shows that they are not significant?
hi pal thank you so much. your choice for going from linear to poly/quad was based on the fact that there was a negative slope? thank you so much.
That was very useful, thank you! What if I had 2 independent variables(Xs) and 1 dependent variable(Y) and I need to fit a quadratic equation for the data I have?
you sir are a life saver , literly 30 mins before i turn in my project thanks
I would have to say you are great at this. It is so helpfull that i just can not believe it.
Thanks. Its really helpful. Explained in pretty simple terms.
MUY BUENO E INTERESANTE, SALUDOS .
FROM ARGENTINA
THANKS MAN!
R^2 typically increases when you add variables to the model, so it's not a good measure of model prediction power in general, but particularly in this example. A better way to evaluate the value of a quadratic model is to look at the residuals, which is also possible using Excel. Always plot residuals when doing any analysis, but in particular with model selection
Very useful, thanks!
Thank you.. Your video is so easy to follow
please post the link of the first vid
can u give the vab code to automate this process and the graph is not required i want polynomial equation with 5th degree order and where 5th degree polynomial is {f(x)=(A)+(Bx)+(C(x^2))+(D(x^3))+(E(x^4))+(F(x^5))} where f(x) and x values are give i required the values of A,B,C,D,E&F
Thanx, was helpful.
Thanks a lot
Will the coefficients automatically change as data is added or removed from the system?
It seems that they dont change, if u know a way to do this with changing values PLEASE tell me
Maybe there's a way to change those coefficients automatically, if the polynomial equation is set up as a formula - perhaps also with some conditional formatting or goal seek. I'm not sure, but we can play with it and figure it out!
Do you ignore the fact that the p values are not within the normal range for hypothesis testing
plz share excel file used for practice
Sir How to get layout tab?
what to do with cubic. only quadratic u show
I'm assuming you just add another column named "x^3" and type in the first cell: '=A2^3' and that's it
there is no layout in my excel...
Can you plz,y=ab^x
I think, your sample size is not sufficient.