|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 3rd, 2005, 01:34 PM
|
|||
|
|||
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
June 3rd, 2005, 02:06 PM
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I write a trendline constant into a cell? | Hanbotkot | Charts and Charting | 2 | December 31st, 2004 05:27 PM |
| How do I get the trendline equation from Excel to script? | Mattias | Charts and Charting | 1 | December 7th, 2004 12:21 PM |
| Trendline and its referencing / linking to a cell | MikeG | Charts and Charting | 0 | February 5th, 2004 03:17 PM |
| Trendline Not The Same as Equation Displayed | Dan | Charts and Charting | 2 | January 28th, 2004 01:00 AM |
| trendline equations | kathy | Charts and Charting | 5 | October 2nd, 2003 10:12 PM |
Linear Mode
