Hi,
I have a polinomial fit graph, so I only have the "polinomial fit function"
in the graph ..as a text, but I'd like to have the constants and the
Pearson's value automatically linked in the worksheet.
Could you help me?
Thanks in advance,
Rolo.
Hi,
I have a polinomial fit graph, so I only have the "polinomial fit function"
in the graph ..as a text, but I'd like to have the constants and the
Pearson's value automatically linked in the worksheet.
Could you help me?
Thanks in advance,
Rolo.
Use LINEST to get the coefficients of a polynomial fit into cells
See example at www.stfx.ca/people/bliengme/ExcelTips
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Rolocors" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a polinomial fit graph, so I only have the "polinomial fit
> function"
> in the graph ..as a text, but I'd like to have the constants and the
> Pearson's value automatically linked in the worksheet.
>
> Could you help me?
> Thanks in advance,
> Rolo.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks