Excercise 2, page 12 "Excel for Scientists and Engineer

[eholz1]

Hello Mr. Excel,

I have a question about exercise number 2. this is the one with the mol/l and mol/min columns. before i looked at the quiz answers, I created the formulas like this

time lapse = b4-a4 (a simple one!)
using the mol/l values (I assumed this is mol/liter)
as the val in col D4

and calculate the mol/min, I assumed that this is mol per minute.
and rote the equation: D4/(C4*60) assuming that I need to convert to minutes (not quite correct, since 1:30 = 1.5 hrs = 90 mins!)

I then checked the quiz answers, and found that the equation for the mol/min
was D4/(C4*24). I see where this is for decimal time values.

but if mol/min, and 57 mol/l and time=2hrs=120 minutes then
mol/min = 57/120 = .475 mol per minute

I think that .475 is correct or what am I missing. Thanks for a handy book!

ewholz

 

[MrExcel]

Good catch. Dr. Verschuuren confirms, "This column should read per HOUR (not per MIN). If you do want per MIN, the formula should be: =D4/(C4*24*60)"

Bill