corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel Help please !!!


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 Help please !!!
Mase
Premium Member

Avatar

Registered: 16th Sep 01
Location: Derbyshire
User status: Offline
15th Nov 05 at 22:53   View Garage View User's Profile U2U Member Reply With Quote

Just wondered if anybody knew how to get an accurate reading of the peak of a graph on excel ?? The only reason i'm asking as i need the peak value on the Y-axis and the coresponding value on the X-axis (see screenshot) to put these values into an equation, but i'm not very good on excel, so i'm not sure how to go about doing it !!




Mase
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Online
16th Nov 05 at 00:59   View Garage View User's Profile U2U Member Reply With Quote

Not possible, thats just plotted points not a line with equation, so it can't be differentated. Best you have is a guess when you zoom that in.
Mase
Premium Member

Avatar

Registered: 16th Sep 01
Location: Derbyshire
User status: Offline
16th Nov 05 at 11:27   View Garage View User's Profile U2U Member Reply With Quote

Right, i get ya. So if i found the equation for the line and differentiated, i would be able to find the value of the peak.


Mase

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
Help needed again ...Trotty can you help Red_Corsa Geek Day 17 1678
21st Mar 03 at 00:15
by Red_Corsa
 
koni red suspension kit jam Help Zone, Modification and ICE Advice 5 908
25th Mar 03 at 17:48
by jam
 
Any MS Excel experts Steve Geek Day 11 1300
4th Jun 04 at 14:19
by blebo
 
money making scheme Drew General Chat 520 13844
9th Apr 09 at 16:51
by Mark Prydderch
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel Help please !!! 29 database queries in 0.0100608 seconds