Chapter 3

Working with Data

As reviewed in the prior chapter, Microsoft Excel has powerful quantitative tools built into its capabilities under the Insert Function toolbar button. This chapter will introduce additional capabilities that greatly enhance the user’s ability to summarize and analyze a set of data. While one of the goals of this chapter is to preview the tools in Excel’s Data Analysis ToolPak, the reader may want to expand their facility with basic statistical analysis by reviewing a companion publication, Working with Sample Data: Exploration and Inference, in the Business Expert Press Quantitative Approaches to Decision Making collection.

3.1 Installing the ToolPak

Excel for Mac systems does not offer the Data Analysis ToolPak. ...

Get Working with Excel 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.