View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cer144 cer144 is offline
external usenet poster
 
Posts: 3
Default Error of slope taking into account error of the data points

Hi!
I need to find the error of the slope of the line of best fit taking into
account the error of the individual data points. I have a fixed value for the
error of the points that I have figured out independently. (It's about .8 for
every point)
I have the error bars on, but excel isn't taking the error of the points
into account when determining the error of the slope! So...how do I solve
this? I don't necessarily need an excel function to do it for me, a formula
would be fine.
Thanks!