Excel Data Analysis For Dummies, 2nd Edition

Chapter 8

Using the Database Functions

In This Chapter

Reviewing function basics

Using the DAVERAGE function

Using the DCOUNT and DCOUNTA functions

Using the DGET function

Using the DMAX and DMIN functions

Using the DPRODUCT function

Using the DSTDEV and DSTDEVP functions

Using the DSUM function

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 ...