Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am doing a physics project. I have made experiments with free-fall, and I have a time-velocity graph which I built. The slope of each point in the graph is the acceleration. The acceleration in free-fall is constant, therefore the graph is linear. I did an approximation with excel ('Trend-line') and gave it the the most default values.

The weird problem is, that although the axis has right values and ratios, and the approximated line LOOKS okay, the EQUATION written is horribly inaccurate. Look for yourself:
enter image description here
For example, for the top line, the equation is y = 0.0792x + 0.9558
But if you look at the graph and do the calculation (y2-y1)/(x2-x1) you will get about (3-1)/(0.5-0)=4.

I am not an excel expert, I'm just trying to do some physics works for school; can anyone please explain this odd behavior and how to fix this? Thanks!

share|improve this question
up vote 2 down vote accepted

You have created a line chart where the X values are being treated as labels, not values, and when you add the trend line it is using the label positions for X values. To get the correct behavior, change the chart type to XY scatter plot.

share|improve this answer
    
You're right. Thanks! – Mark Segal May 13 '12 at 16:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .