Chapter 8

Using the Database Functions

In This Chapter

arrow Reviewing function basics

arrow Using the DAVERAGE function

arrow Using the DCOUNT and DCOUNTA functions

arrow Using the DGET function

arrow Using the DMAX and DMIN functions

arrow Using the DPRODUCT function

arrow Using the DSTDEV and DSTDEVP functions

arrow Using the DSUM function

arrow Using the DVAR and DVARP functions

Excel provides a special set of functions, called database functions, especially for simple statistical analysis of information that you store in Excel tables. In this chapter, I describe and illustrate these functions.

Are you interested in statistical analysis ...

Get Excel Data Analysis For Dummies, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.