O'Reilly logo

A Guide to Microsoft Excel 2007 for Scientists and Engineers by Bernard Liengme

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required