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
Using Excel’s Quick Statistics feature
Finding out tips for Mac users
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. Into each worksheet cell you can enter a piece of data, 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, 3rd 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.
