NSChE Journal Articles
*The article download page is restricted to registered members only.
MICROSOFT EXCEL AS A TOOL FOR DATA ANALYSIS: THE GOOD AND THE BAD
Ayoade Kuye Department of Chemical Engineering University of Port Harcourt, Port Harcourt
Article Abstract
A Microsoft Excel spreadsheet is an array of rows and columns with automatic update and display of results. It also contains libraries of mathematical and statistical functions, graphing and charting facilities, add-ins such as Microsoft Excel’s Solver, as well as tools for writing custom code in languages such as Microsoft’s Visual Basic for Applications. In this work, our emphasis is to evaluate the use of Excel for data analysis. It is demonstrated that Excel is a good tool that can be used for data analysis and can easily be adapted to solve scientific and engineering problems. From the sample data presented in this paper, it is apparent that a lot of caution should be taken when using Excel. For serious data analysis it is better to develop one’s template using built-in functions and first principles. If possible, such a template should be validated with results from other statistical software.
Click here to download full article *Access restricted to members only
<<<<<<<Back to journal listing
 
(c) 2010 Nigerian Society of Chemical Engineers ---------------- Contact Webmaster