Another function, COUNT (), counts the cells in its range that contain numbers. Many of Excel's statistical functions also calculate the aggregate value of a range of cells.

For statistical data analysis in excel, some of the most useful functions are count and countif. The count function helps you find out how many cells in a specified range contain numerical data.

Excel offers a variety of built-in statistical functions such as AVERAGE, MEDIAN, STDEV, and VAR. Familiarize yourself with these to quickly perform common calculations.

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite ...

Microsoft's Excel software for Mac can execute a number of statistical functions, including finding the y-intercept of the line formed by a set of data points. Excel's intercept function ...