Chapter 2
Understanding Excel's Statistical Capabilities
IN THIS CHAPTER
Working with worksheet functions
Creating a shortcut to statistical functions
Getting an array of results
Naming arrays
Tooling around with analysis
Analyzing on the iPad
Using Excel’s Quick Statistics feature
In this chapter, I introduce you to Excel's statistical functions and data analysis tools. If you’ve used Excel, and I'm assuming you have, you’re aware of Excel’s extensive functionality, of which statistical capabilities are a subset. You can either enter a piece of data into each worksheet cell, instruct Excel to carry out calculations on data that reside in a set of cells, or use one of Excel’s worksheet functions to work on data. Each worksheet function is a built-in formula that saves you the trouble ...
Get Statistical Analysis with Excel For Dummies, 5th Edition 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.
