Area under lethality curve 
Post Reply 
Author  
formula123
Admin Group Administrator Joined: 01 Sep 2009 Location: N. Ireland Status: Offline Points: 390 
Post Options
Thanks(0)
Posted: 07 Apr 2011 at 11:11pm 

I have taken 7 sets of time temperature data and calculated Fo using the Trapezoid rule, Simpson's rule and the Romberg method. The results are summarised below.
For 3 of the data sets the Trapezoid rule slightly overestimated Fo compared with the more accurate methods. However, it underestimated Fo for 4 of the datasets.
I will provide the full analysis including all the data, the trend line equations and the spreadsheets as a download at a future time if there is enough interest.
So Beachgirl it would be reasonable to predict that there will be instances when your company's F values have been underestimated when the Trapezoid rule has been used. BUT unless you have used large time intervals and few data points this underestimation should be too small to cause any concern.


Sponsored Links  
formula123
Admin Group Administrator Joined: 01 Sep 2009 Location: N. Ireland Status: Offline Points: 390 
Post Options
Thanks(0)


I have been wondering why you have kept asking questions about calculating the area under the lethality curve!
I am aware that others have solved a range of equations (with known solutions) using several numerical methods; based on their findings the order of accuracy in obtaining the area under the curve is 1, Romberg, 2 Simpson's and 3 the trapezoidal rule. Based on most of the work published the trapezoidal rule is slightly less accurate and sometimes overestimates area (F value) compared with more accurate methods (e.g. Simpson's rule)  in thermal processing.
Having calculated a few F values using the three methods (using actual data) I have found that as expected the trapezoidal rule gave lower F values compared with Simpson's rule for many data sets.
Thank you for being persistent.


formula123
Admin Group Administrator Joined: 01 Sep 2009 Location: N. Ireland Status: Offline Points: 390 
Post Options
Thanks(0)


You certainly are interested in this topic!
I will prepare a spreadsheet over the next week or so and answer your question more fully.
The trapezoidal rule is expected to slightly underestimate area with concave down curves. However if the spacing (or interval between readings) is small and a large number of readings are taken the error becomes very small and to all practical purposes (thermal processing calculations) is not significant.
Now to theory. The theoretical error of the simple trapezoidal rule is proportional to sample interval raised to the third power. The error for the composite rule is proportional to the sample interval squared. If you increase the number of samples so as to decrease the interval by a factor of 2, then the error will decrease by 2 x 2 , a factor of 4. If you are using 4 min intervals then moving to 2 or 1 will markedly affect accuracy. With a small number of test results and larger time intervals Simpson's rules (there are 2) will give a more accurate estimate. But in many practical situations this does not really matter. You have succeeded in me wanting to close this topic! So over the next few weeks I will prepare a spreadsheet showing F values obtained using trapezoidal rule, Simpson's two rules and the equation for a lethality curve. Hopefully this will give you the information you need?


beachgirl
Newbie Joined: 07 Nov 2010 Status: Offline Points: 10 
Post Options
Thanks(0)


Hi u might said this bfor what are the rrors with the t rule & how u control?


formula123
Admin Group Administrator Joined: 01 Sep 2009 Location: N. Ireland Status: Offline Points: 390 
Post Options
Thanks(0)


Yes welcome back.
I think I have responded to this query under thermal processing before? Perhaps the easiest way to get the equation you want is to use the trendline function in Excel. If the r value is > 0.9 (you can use lower r values) and your knowledge of calculus is good you can integrate the equation to get the area. The
WolframAlpha: Computational Knowledge Enginecan be used to check your calculation.There are a few really good Excel textbooks written by scientists for scientists and engineers and provide a good introduction to the computing power of Excel. Look up the LINEST function it can used instead of the trendline function to find the equation for a curve.
What's wrong with numerical integration using e.g. the trapezoidal rule; the error is usually less than
0.5% and can be reduced further? 

beachgirl
Newbie Joined: 07 Nov 2010 Status: Offline Points: 10 
Post Options
Thanks(0)


Hi back again! How do you get equation for lethal curve and how to solve it?
Thnks!


Post Reply  
Tweet

Forum Jump  Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum 