| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Polynomial least squares fit
Hi,
I have a graph of two values and I need to know, what the formula is that connects all to points. The trend function in the graph gives y = 0.0557x4 - 51.355x3 + 18559x2 - 3E+06x + 2E+08 I need the last two terms too more places. Is there a spread sheet function for this, a macro or anything. MarkS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Binary Squares | Excel Discussion (Misc queries) | |||
| football squares | Excel Discussion (Misc queries) | |||
| Least Squares Regression ST. Dev. | Excel Worksheet Functions | |||
| chi squares | Excel Discussion (Misc queries) | |||
| removing squares and lines in squares that really should be paragr | Excel Discussion (Misc queries) | |||
Threaded Mode
