answersLogoWhite

0


Best Answer

type in =SLOPE(known_y's,known_x's)

Ex: =SLOPE(D1:D5,A1:A5)

And that will give you your slope

You need at least two points on the line, if not more. So in one cell, say D1, you could have a y co-ordinate and in A1 an x cordinate, giving you one point. Then in the other cell pairs, like D2 and A2 you could have the co-ordinates for other points. The above example is getting 5 points. So if you fill in your co-ordinates for the points into the appropriate cells, you can use the formula typed into an empty cell to get the slope:

=SLOPE(D1:D5,A1:A5)

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Find the slope of a line in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you freeze a line in a document on Microsoft Excel?

this my personal file


How do you find slope altitude?

If the slope of a line is m then the slope of an altitude to that line is -1/m.


Verical lines in Microsoft Excel are called in microsoft EXcel?

The actual lines are known as gridlines, both vertical and horizontal. A vertical line of cells is known as a row.


What does ALT ENTER do in Microsoft Excel?

It gives you a line-break inside of a cell.


Does Microsoft Excel allow you to change font size and line color?

Yes it does.


How do you find the slope of a parallel line?

Parallel lines have the same slope. So if you know the slope of a line in question, or you can calculate it, then you know the slope of any line parallel to that line.


How do you find the slope of a line parallel to another line?

The slope of both lines will be the same.


How do you find a slope in a line?

the slope of a line = the Change in Y divided by the Change in X


How do I find the slope of a line?

you look at the line and see if there are any direct points on the line the slope formula


What does the slope examples of rates inclued?

Why do we need to find the slope of a line? The slope of a line tells us how something changes over time. If we find the slope we can find the rate of change over that period.Why do we need to find the slope of a line?The slope of a line tells us how something changes over time. If we find the slope we can find the rate of change over that period. - See more at: http://www.algebra-class.com/rate-of-change.html#sthash.KmE8ACMR.dpuf


How do i find the slope of a graphed line?

you look at the line and see if there are any direct points on the line the slope formula


How do you find a slope of a line parallel?

Line a is parallel to line b, m, and . Find .