Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Trendline R square
Hi every body, Can you please help me with this confusing issue? My data is preseted in a scatter plot and the trendline is shown in the figure. The R square value from the trendline option is not the same as the one I got from the Data analysis option from the tools menu (This is an Add-in option). To be sepecific the trend line gave an R square= 0.5465 where the data analysis gave an R square=0.9804509. Thanks in advance for your help..... -- balmalik ------------------------------------------------------------------------ balmalik's Profile: http://www.excelforum.com/member.php...o&userid=36517 View this thread: http://www.excelforum.com/showthread...hreadid=565896 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trendline Equation | Excel Worksheet Functions | |||
Trendline in pivot table | Excel Discussion (Misc queries) | |||
how to center a square plot area in a square chart | Charts and Charting in Excel | |||
Trendline Extract | Charts and Charting in Excel | |||
How do I get the trendline equation from Excel to script? | Charts and Charting in Excel |