View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
balmalik balmalik is offline
external usenet poster
 
Posts: 1
Default 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