View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default didn't work!

What do you mean "it didn't work"? - I didn't tell you to do anything
in Excel. You have a (value for the) slope, so choose two points on
this line to give you the x1,y1 and x2,y2 values. Then using the
(mathematical) formula that I gave, you can work out a value for the
slope for one extreme, and then a value for the slope for the other
extreme - these represent the range in values that the slope can take,
and you can express that as an error range for the value of the slope
that you start with.

Hope this helps.

Pete

On Jul 7, 7:10*pm, cer144 wrote:
Didn't work lol! It just changed the y-intercept!! Still need some help on
this one.