We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

R2 different using trend line in chart and by regression

asked 2020-06-02 20:09:35 +0200

jverner1011 gravatar image

Two variables, an independent and a dependent. When I plot the data on a chart in calc and generate a trend line, R2 equals 0.23. Using the same data, when I perform linear regression, R2 equals .028. Why are they different?

edit retag flag offensive close merge delete


Was the "linear regression" youi mentioned done by LINEST()?
How was the type parameter set? How was the respctive setting for the trendline?

Lupp gravatar imageLupp ( 2020-06-02 20:33:29 +0200 )edit
  1. Yes.
  2. What do you mean by type parameter?
  3. I don't know. This is what I did: https://www.youtube.com/watch?v=f4_Gw...
jverner1011 gravatar imagejverner1011 ( 2020-06-02 20:42:12 +0200 )edit

Using the formula wizard for LINEST you find "Linear type" as description for the third parameter.
Putting there 0 or something else tells the algorithm whether or not the linear trendline needs tp pass through the origin of the coordinate system.

Lupp gravatar imageLupp ( 2020-06-02 22:03:08 +0200 )edit

Origin not forced for either chart or regression. I can'f figure out how to attach files here. You can find the two items here: vernerlegal.com/Chart.png vernerlegal.com/Regression.png

jverner1011 gravatar imagejverner1011 ( 2020-06-02 23:36:10 +0200 )edit

I cared for the needed "karma". Editing your original question you should now find a "paperclip-tool" which will help you to attach files.

Lupp gravatar imageLupp ( 2020-06-03 01:26:33 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-06-02 21:56:04 +0200

Lupp gravatar image

(I'm too old to understand these boring U-to-be things.)
Please have a glance into the attached example:

edit flag offensive delete link more


Did not answer my question.

jverner1011 gravatar imagejverner1011 ( 2020-06-03 18:55:19 +0200 )edit

If there isn't a basical misunderstanding beyond my horizon:
I cannot answer your question without an example of a Sheet with a Chart and a working LINEST() formula showing the issue.
Did you study my example?
Did you read my comment on your question concerning how to attach an example file?

Lupp gravatar imageLupp ( 2020-06-03 19:42:00 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-02 20:09:35 +0200

Seen: 104 times

Last updated: Jun 02 '20