Trend Line constants as Excel Cell Values
Thanks B. R.Ramachandran again for your great assistance. Ken
--
Ken
"B. R.Ramachandran" wrote:
Hi Ken,
Supposing your x-range is in A2:A10, and y-range in B2:B10,
select a 3-column x 1-row area and enter the following formula and confirm
with CTRL-SHIFT-ENTER.
=LINEST(B2:B10,A2:A10^{0,1,2},0,)
Regards,
B. R. Ramachandran
"Ken" wrote:
I want to put the constants of a 2 degree polynomial trend line into Excel
Cells. Are there formula's to do this? Equation is Y = Ax(2) + Bx + C. I want
the value of A,B and C in seperate cells. Can anyone suggest how this can be
done? Thanks
--
Ken
|