I D
× COMMENTARYEDITOR'S PAGECOVER STORYIN THE NEWSNEWSFRONTSCHEMENTATOR + Show More
Chemical Engineering MagazineChementator Briefs
Nanofiltration Toray Industries, Inc. (Tokyo, Japan; www.toray.com) has created what…
BUSINESS NEWSTECHNICAL & PRACTICALFEATURE REPORTFACTS AT YOUR FINGERTIPSTECHNOLOGY PROFILEEQUIPMENT & SERVICESFOCUSNEW PRODUCTS + Show More SHOW PREVIEWS

Comment PDF Automation & Control

Using Spreadsheets As Curve Fitting Tools

By B.J. du Plessis, University of Pretoria |

    Spreadsheets have been around almost as long as personal computers. While early versions were clumsy and limited in scope, today’s spreadsheet programs can do almost anything the user wants them to do. These broadened capabilities are made easier through the use of internal (built-in) functions, add-in programs and the use of macro programming. In this article, we explore how spreadsheets can help determine coefficients of an equation from experimental data, without complex or expensive software. Curve fitting, commonly used in engineering, is a technique used to describe experimental data as a mathematical equation in the form y = f(x) where x is the independent variable (controlled by the experimenter) and y is the dependent variable (measured). The better the fit of the equation, the more accurately the function will describe the experimental data. The introduction of personal computers into laboratories greatly reduced the time and effort required to analyze data. Fitting data with simple linear functions by using linear regression equations is a fairly straightforward process. Most spreadsheets can do this with add-in programs or even with built-in functions. Fitting data to more complex, non-linear equations…
Related Content

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
How separation processes profit from Industrial Internet of Things (IIoT) solutions
Up to 80% increased production rates in plastic recycling
Higher throughput and purity in sodium bicarbonate production with up to 15% less energy consumption
Help feeding nations with chemical filtering technologies
Not at the forefront of Industry 4.0?

View More

Live chat by BoldChat