Are you using the same model (linear, polynomial, etc.) in both cases?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"balmalik" wrote in
message ...

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