I D
× COMMENTARYCOVER STORYIN THE NEWSNEWSFRONTSCHEMENTATOR + Show More BUSINESS NEWSTECHNICAL & PRACTICALFEATURE REPORTFACTS AT YOUR FINGERTIPSTECHNOLOGY PROFILEEQUIPMENT & SERVICESFOCUSNEW PRODUCTS + Show More

Comment PDF Automation & Control

Engineering Practice: Functions for Easier Curve Fitting

By Francis X. McConville Impact Technology Consultants |

Engineers often need to fit experimental data to an empirical relationship for extrapolation or modeling without resorting to a full mathematical treatment based on physical principles or theory. The most widely used platform in science for doing this is MS Excel, and while its "off-the-shelf" Trendline tool is useful, it is limited to only 4 or 5 simple functions. Excel’s Solver add-in, on the other hand, offers a simple, powerful means to fit data to user-defined functions. There are numerous commercial packages for data fitting and statistical analysis [ 1], but Excel is ubiquitous, and as E. G. John [2] aptly puts it, the use of Solver for data fitting is "simplicity itself". More recently, in this publication, Du Plessis [3] further extols the virtues of Excel’s Solver function and describes in detail how to use it for this purpose. For a synopsis, see box below. Once one has identified an appropriate function and achieved a good fit, then more-advanced modeling tasks become easier; and using calculus one can obtain derivatives and integrals and thus rates of change, areas under curves, and so on. But selecting the best function for the curve-fitting exercise is never trivial. To simplify the task,…
Related Content

Andritz

Minimizing particle breakage and mother liquor residue in technical salts production

Technical salts and crystallization products have found a broad spectrum of different applications in the industrial sector in the past decades. One of the most frequently used salts is sodium chloride...

Chemical Engineering publishes FREE eletters that bring our original content to our readers in an easily accessible email format about once a week.
Subscribe Now
The Big 6 level measurement technologies: Where to use them and why
Minimizing particle breakage and mother liquor residue in technical salts production
Expectations are shifting: How measurement solutions can help overcome chemical industry challenges
CoriolisMaster: The SmartSensor solution
ABB in Chemical Industry

View More