K-Means Clustering and Iterative Calculation

Abstract

This is our last chapter. Hopefully we have become more and more familiar with Excel. We should have realized that under every main tab, there are quite a few icon groups, each presenting some quick-access tools or features. For example, under the Home tab, there are groups Font, Alignment, Number, Styles, Editing, etc. We can find that under the Formulas tab, the Function Library group organizes functions into different categories including Financial, Logical, Text, Date & Time, Lookup & Reference, and Math & Trig. This Function Library group also lists those Recently Used functions and some other More Functions. Remember that Excel is adding more and more functions, and for general purpose, it is very likely that Excel has all the functions we need for our projects. The same understanding applies to Excel’s built-in features, that is, Excel is likely to have all the built-in features we need.