How to stop Numbers from rounding R-squared value and graph equation?

Question

Level 1

0 points

How to stop Numbers from rounding R-squared value and graph equation?

After inputing values into a table, and making a scatter-plot graph, I click "series" add a linear trend-line and check the boxes for "show R-squared value" and "show equation". Both appear on my graph, however they always appear to be rounded. My equation is always "y=x" and my R-squared value is always 1. Even though my lab partner will input the same results into Excel and get an equation like "y=0.9888x+0.00044". Is there a way to fix this? Am I doing something wrong?

Thanks!

MacBook Air, OS X El Capitan (10.11.2)

Posted on Feb 10, 2016 5:18 PM

Reply

Answer 1

Best reply

Wayne Contello

Level 7

26,529 points

Feb 10, 2016 5:39 PM in response to mjunechan

Here is an example I made up. Perhaps you could share your data dan screenshot of the chart:

Reply

Answer 2

mjunechan Author

Level 1

0 points

Feb 10, 2016 5:38 PM in response to Wayne Contello

Wow that is exactly what I am looking for! Thanks for the quick reply. Here is a screenshot of one of my works. On the right is the equation my partner got and I copied down. But on the graph.. you can see mine is different.

Reply

Answer 3

Feb 10, 2016 5:47 PM in response to mjunechan

I tried a similar exercise using Numbers 3.6.1 and found if I clicked Chart the FIRST time the chart did not appear to be the correct scatter pattern. Selecting Chart a SECOND time gave what looked to me like a correct pattern and R-squared values that were no longer set to 1.

Reply

Answer 4

Yellowbox

Level 7

20,383 points

Feb 10, 2016 6:12 PM in response to mjunechan

Hi mjunechan,

Your graph has 4 points, yet the data are 5 pairs.

Your X axis goes from 0 to 0.6, yet the X data go to 7.0

Here are your data. The table has one Header Row and no Header Column.

Curious!

Another point, a polynomial fit is better:

Regards,

Ian.

Reply

Answer 5

mjunechan Author

Level 1

0 points

Feb 10, 2016 6:11 PM in response to pamfrombalwyn

Thanks everyone for such quick replies!! I actually figured out what was causing my problem. I was using the shaded gray sidebar of the table, which was causing the graph to only use the Y-values and not the X. Here is a comparison, with Table 1 I was having my problem, but when I moved the values to "normal" cells, the problem was fixed!