corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Excel Formula


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel Formula
RCS
Member
Registered: 26th Jan 05
Location: Lichfield/Dundee
User status: Offline
6th Jul 12 at 09:22   View User's Profile U2U Member Reply With Quote
Having a blonde moment - what does the e mean?



I thought it was 10^ but the formula doesn't work out?

x = 150 then y = 825
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
6th Jul 12 at 13:39   View Garage View User's Profile U2U Member Reply With Quote
http://en.wikipedia.org/wiki/E_%28mathematical_constant%29

Think its used there so the exponent it works out for you is the actual true gradient of that approximation, as opposed to just giving you a regular a^b which wouldn't scale.

The formula will never work out as that line is an approximation - the polynomial curve which best fits your data. Even thought your data does not have a true exponential relationship.

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Excel Help Darren General Chat 3 702
4th Mar 04 at 11:51
by ipswichcorsa		  
Excel Formula Help.. Bart Geek Day 6 765
7th Dec 06 at 07:59
by Bart		  
Excel Guru's Dom Geek Day 2 247
4th Mar 08 at 12:16
by Daniel_Corsa		  
Working out 15% (VAT) in Excel. deano87 Geek Day 24 823
10th Feb 09 at 19:25
by deano87		  
Excel formula quick help strick206 Geek Day 6 301
20th Sep 10 at 11:49
by strick206		  

Corsa Sport » Message Board » Off Day » Geek Day » Excel Formula 28 database queries in 0.0065119 seconds