Data Mining
Publisher Summary
The purpose of this chapter is to demonstrate how to work with lists containing alphanumeric data shows how to import a data list in a non-Excel file. It then analyzes how to count, sum, and average a numeric column, subject to a criterion relating to a textual column. The powerful Pivot Table feature is also explored. Finally, simple sort and filtering is done. The original data were generated by this scenario: Acme Manufacturing has a number of machines in which a particular part must be frequently replaced. There are two sources for this part, Alpha and Beta, each of whom supplies the part in brass, nickel, or stainless steel. The maintenance engineer has kept track of how many hours each part lasts. The ...
Get A Guide to Microsoft Excel 2007 for Scientists and Engineers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
