View Single Post
  #1   Report Post  
QuestGAV
 
Posts: n/a
Default Linear Trendline Equation Question


I have created a graph of the following data:

93 0.00444
144 0.00621
185 0.00847
243 0.01045
285 0.01246
315 0.01469

I need to know the slope of the trendline it creates. Unfortunately,
the equation it gives is of the form y=4E-05x. It may just be that it's
late, but what does that translate to? I'm reading it as 4*10^5=400000
but that doesn't seem quite right. Even then, only having one
significant figure is a pretty big handicap. Is there a way to make it
print it as a normal number that is more precise? If not, am I reading
it correctly or have I forgotten some basic math?


--
QuestGAV
------------------------------------------------------------------------
QuestGAV's Profile: http://www.excelforum.com/member.php...o&userid=17432
View this thread: http://www.excelforum.com/showthread...hreadid=474664