how do i find the slope of a line in excel?
|
how do i find the slope of a line in excel?
What are you starting with?
If you have two points, say, (x1,y1) in A1:B1 and (x2,y2) in A2:B2 then the slope in C1 is returned by C1: =(B2-B1)/(A2-A1) In article , colin mccready <colin wrote: |
how do i find the slope of a line in excel?
1) By making an XY chart and inserting a trendline with the equation
displayed or 2) By using the SLOPE function Have you experimented using Excel's Help feature - it is very useful best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "colin mccready" <colin wrote in message ... |
how do i find the slope of a line in excel?
See Help, Slope.
colin mccready wrote: |
how do i find the slope of a line in excel?
Firstly, the purpose of the message body is to allow you to ask the
question. Don't just put it in the subject line. Blank messages are often rejected or ignored. Secondly, why not be brave and type the word "slope" into excel help and see what you find? [A more blunt answer would be RTFM] -- David Biddulph "colin mccready" <colin wrote in message ... |
All times are GMT +1. The time now is 07:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com