| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How can i get polinomial trendline constants in a worksheet?
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. |
|
#2
|
|||
|
|||
|
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" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More than 2 constants in Index | Excel Worksheet Functions | |||
| Polinomial - What's Wrong | Charts and Charting in Excel | |||
| How do I write a trendline constant into a cell? | Charts and Charting in Excel | |||
| How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
| Trendline error??? | Charts and Charting in Excel | |||
Hybrid Mode
