mjant
New Member
- Joined
- Jun 4, 2012
- Messages
- 6
Hello fellow Excel users (especially engineer or scientist types),
I've been asked to have MS Excel do calculations done manually so far.
An instrument takes readings (absorbance) over time.
Typically, for a sample, the absorbance goes up, peaks after about 3 minutes and then comes down, then does some other minor ups and downs that we ignore. (Absorbance on y-axis, time on x-axis if plotted).
The instrument spits out two columns of data, time of reading and Abs value (15 second intervals between reads, last read at 1 hr)
We are interested in stuff after the peak abs value but before the 'bottom out" Using only formulas, determine the x-value at 50% peak height
on the 'descent' as well as slope of the line at that point.
I know how to pick up the 'Max' in a set but the rest puzzles me. Suggestions?
I've been asked to have MS Excel do calculations done manually so far.
An instrument takes readings (absorbance) over time.
Typically, for a sample, the absorbance goes up, peaks after about 3 minutes and then comes down, then does some other minor ups and downs that we ignore. (Absorbance on y-axis, time on x-axis if plotted).
The instrument spits out two columns of data, time of reading and Abs value (15 second intervals between reads, last read at 1 hr)
We are interested in stuff after the peak abs value but before the 'bottom out" Using only formulas, determine the x-value at 50% peak height
I know how to pick up the 'Max' in a set but the rest puzzles me. Suggestions?