LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link trendline equation in graph to cell? rossgus Excel Discussion (Misc queries) 2 May 11th 08 03:41 PM
Rounding in Trendline Equation Phil Hageman Charts and Charting in Excel 3 January 15th 05 01:15 AM
Logarithmic Trendline Equation Phil Hageman Charts and Charting in Excel 2 January 13th 05 11:55 AM
How do I get the trendline equation from Excel to script? Mattias Charts and Charting in Excel 1 December 7th 04 12:21 PM
trendline - request power --> get linear CR Optiker Excel Worksheet Functions 1 October 28th 04 11:02 PM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"