How to work out the gradient on Excel?

Hey! I have microsoft excel 2007 and I already have a scatter graph displaying my results. I managed to add a linear trendline to them. Does anybody know how to work out the gradient of this line?

Help greatly appreciated =D

Become an Expert →

Answer #1

Hi,

Do you mean the slope of the line?

I found this online:

Double click on the line in the graph, and it will take you to the properties of the line. Insert a trendline - use linear regression. There you can select to have it show the equation of the line on the graph. The slope is the number next to the letter “X”.

For example if it shows Y=2.9x+3 the slope (gradient) will be 2.9

More Like This

What is the difference b/w Microsoft Works 9 & Home & Student 2007? - 1 Answers
I'm buying a laptop for school soon and could have either Microsoft Works 9 or Microsoft Home and Student 2007 with Word, Exc...
How do phone lines work ? - 1 Answers
How do phone lines work ?? What do they use to work ??? Thanks
Why wont my apple mobile device work? - 1 Answers
My apple mobile devices will not work and I won to know hoe to work it.
Microsoft works is missing - 1 Answers
I had microsoft works task launcher when I reformatted my computer and reinstalled windows programs the microsoft works is no...
What is the purpose of microsoft excel ? - 3 Answers
Hi, What is the purpose of microsoft excel ?? , I need a short but detailed description x
What makes my keyboard stop working? - 1 Answers
Hey guys :) What could stop my keyboard from working ?? Thank you for you advice :)
Why doesn't my music player work on my Myspace? - 1 Answers
why don't my band music player for mysace work?
Can this work for your ipod - 4 Answers
Can you use windows media player to put songs on your ipod?
How to work with two Sims on the same mobile? - 4 Answers
how can i work with two sims on the same mobile?
How do you work twitter? - 2 Answers
How do you work twitter? I know how to add friends but what else can you do on it lol im dumb :d

How to work out the gradient on Excel?

technology Listings