Question

Explain any two Statistical functions with example.

Answer 1

Answer:

Statistical functions apply a mathematical process to a group of cells in a worksheet. For example, the SUM function is used to add the values contained in a range of cells. 

Answer 2

Answer:

1. Count Function. We use the count function when we need to count the number of cells containing a number.

2.Counta Function. While the count function only counts the numeric values, the COUNTA function counts all the cells in a range that are not empty.