Linear Trendline Equation Question

[QuestGAV]

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'
late, but what does that translate to? I'm reading it as 4*10^5=40000
but that doesn't seem quite right. Even then, only having on
significant figure is a pretty big handicap. Is there a way to make i
print it as a normal number that is more precise? If not, am I readin
it correctly or have I forgotten some basic math

 

[Mike Middleton]

QuestGAV -

"4E-05x" means 4*10^-5 = 0.00004

Select the special trendline text box, and press the Increase Decimal button
repeatedly, or apply a Number format. You could display it like this:

y = 0.00004486885899x - 0.00000651777008

Or, you could use the worksheet functions SLOPE and INTERCEPT to obtain the
same values in worksheet cells.

- Mike
www.mikemiddleton.com

 

[QuestGAV]

Thanks! That's much better, I'll put this to good use