Читать книгу Statistical Analysis with Excel For Dummies - Joseph Schmuller - Страница 24

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 of having to direct Excel to perform a sequence of calculations. As newbies and veterans know, formulas are the business end of Excel. The data analysis tools go beyond the formulas. Each tool provides a set of informative results.