Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Polynomial regression - how does Excel do it? (under "Trendline")
Question on polynomial regression under "trendline" option in charts:
I drew a line chart with my data, and then I used the following option: 1. On the line chart, click the right button of the mouse and select "Add Trendline". 2. Choose "Polynomial" in "Trend/Regression Type". This gave me a polynomial regression line using my data set and the exact equation applied. What I would like to know is how Excel created that equation. None of my other statistics software gave me better fit than this, so I'm trying to understand what the logic behind it is so that I can apply it to the language. Any advice will be appreciated. Thanks!! Best, JH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you run regression in excel? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I conduct linear regression in Excel with more than 16 x's | Excel Worksheet Functions | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |