Forum Discussion
request to solve a formula to find the weight of pigs at different days of during an experiment
If use polynomic approximation we may find coefficients with LINEST() function. For such one
formula for first curve coeficients is
=LINEST(C4:F4,$C$7:$F$7^{1;2;3},TRUE,FALSE)If your Excel doesn't support Dynamic Arrays enter it as array formula (Ctrl+Shift+Enter)
AshaKantaSharma thank you for your help.
unfortunately the average seems do not work because if we use the linear trend line does have a R2 very low.
I've tried to use the polynomial equation (degree 2) formula but i'm not able to solve it..
the R2 obtained with the polynomial trend line seems to be closer to the real situation, but i'm not able to solve it.
the equation of one curve is
y = 2.1482x2 - 6.7453x + 12.323
R² = 0.9793
and the other is
y = 2.0975x2 - 6.8495x + 12.469
R² = 0.9787
is it the right direction i am following or i am totally wrong?
thanks a lot
If use polynomic approximation we may find coefficients with LINEST() function. For such one
formula for first curve coeficients is
=LINEST(C4:F4,$C$7:$F$7^{1;2;3},TRUE,FALSE)If your Excel doesn't support Dynamic Arrays enter it as array formula (Ctrl+Shift+Enter)
dear SergeiBaklan ,
first of all thank you so much for the help and i realy appreciate you work. it is amazing.. wow!
i will try to look for that formula and see if i can learn more about it!
the table looks great though, and i will try to apply the same formula to similar problems and see if it works.
if i have some problems, do you mind if i contact you again here on this community?
thank you so much for the timebeing.
amazing work!
i thank everyone that tried to help me to solve this problem, it means a lot.
cheers,
ricardo