Mase
Premium Member
Registered: 16th Sep 01
Location: Derbyshire
User status: Offline
|
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
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
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
Registered: 16th Sep 01
Location: Derbyshire
User status: Offline
|
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
|
