slope function returns different value as the trend-line equation

Hey all,

I don't know if I found a bug or if there is something weird that I did. But I'll share this anyway.

I am using numbers to find the rate of oxygen coming into wine closures. (collecting lab data on numbers for the ipad is soooo easy by the way)

Anyway, amongst my measurements, what I am really interested in is the rate at which they change - the slope of the line.

I noticed that if I use the Slope() function I get one number - but if I add a linear trendline and show the equation, (y=mx+b where m is the slope) the slope in that equation is a different value than what the slope function gives me.

I ported the data over to excel and ran the same exercise - the equation on the chart versus the slope() function - and over there, the two numbers match as they should.

I have a feeling that the problem might be with the generation of the xy/scatter chart itself, because the maxima on the x axis when I chart it all out is less than the same from the data ( I have data over 4 and the chart shows the last readings just below 3.

If the axes are off then that would explain the wrong slope. But then why is the x-y chart wrong, and if it is not a bug and I'm doing something wrong, I'd like to figure it out because I use these x-y charts quite a bit.

Macbook Pro 2.4Ghz, Mac OS X (10.5.6)

Posted on Sep 5, 2010 8:23 PM

Reply
3 replies

Sep 7, 2010 6:38 AM in response to UCDWino

UCDWino wrote:
I noticed that if I use the Slope() function I get one number - but if I add a linear trendline and show the equation, (y=mx+b where m is the slope) the slope in that equation is a different value than what the slope function gives me...
I have a feeling that the problem might be with the generation of the xy/scatter chart itself, because the maxima on the x axis when I chart it all out is less than the same from the data ( I have data over 4 and the chart shows the last readings just below 3.

It sounds like matter of the chart range not covering the entire data range. Did you add some data that didn't get picked up by the chart? Click on the chart to select it and then look at the data table to see if all the data is within the chart selection area. The solution could be as simple as clicking on the little circle in the lower right corner of the chart data range and dragging it to cover all the data.

Jerry

Sep 26, 2010 3:19 PM in response to UCDWino

I've been having the same issue and it drives me bonkers. I've never been able to get a correct linear equation in Numbers for any chart.

I end up doing the Slope and Y Intercept formulas separately and building my own equation from there. When I compare to my graphing calculator, the manual method gives me an accurate formula.

I've been really disappointed in Numbers' charting features and I'm tempted to download Excel (gasp) to get my work done more quickly.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

slope function returns different value as the trend-line equation

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.