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.....

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Please provide more information:
- version of Excel
- how the model is specified for the ATP regression tool
- for the ATP regression, are you looking at "Multiple R", "R Square", or
"Adjusted R Square"?
- what chart type did you use "Line" or "XY (Scatter)"?
- what type of trend line on the chart?

If the data is not too extensive or too sensitive, it might help to list it
in the body of your reply (no attachments, please).

Jerry

"balmalik" wrote:

>
> 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
>
>