Welcome!


Join more than 151,000 members on FunAdvice to ask questions, share advice, photos and make new friends today.
FunAdvice RSS for this page:
Rss_feed

How to work out the gradient on excel?

Our Cat Asked by vickylaw about 1 year ago, 1 answer.

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

editor in car 1 Answered by editor on Jan 07, 2008, 07:00PM
8965 answers
Advisor-small

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

Answer this Question: "How to work out the gradient on Excel?"

Your Answer: HTML is not allowed.


Our members said the answers on this page also answer the following questions:


Gradient excel, Excel gradient, Gradient in excel, How to work out gradient, How to work out the gradient, How to find gradient in excel, Excel gradient function, Gradient excel graph, Calculate gradient in excel, Gradient on excel, Calculating gradient in excel, Excel gradient cell, How to work out gradient on excel, Gradients in excel, Color gradient excel, Excel graph gradient

Computers & Tech Photos

Work Work Workall work no playMoms are making it happen with work from home!

Share this question

Copy and paste this code:
It will display on your blog or site like this:
How to work out the gradient on excel?