View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jerry W. Lewis
 
Posts: n/a
Default slope of data with the same y values

If you are saying that you y does not change with x, then the slope is
zero. If you are saying that y=x in all cases, then the slope is one.
Otherwise, please clarify your question.

Jerry

Rosa wrote:

I want excel to calculate the slope of a set of data which has the same x
values. For each column I should enter the syntax. Is there any way that I
can write once for all columns which have the same x or y value?