Question

2. Explain any two Statistical functions with examples​

Answer 1

Explanation:

here..

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.

Answer 2

Answer:

The two functions are MAX and MIN

MAX It return the largest value in a given range of cells. Syntax: =MAX(range or numbers)

Example:=MAX(A1:A5)gives the output 50

MIN

It returns the smallest value in a given range of cells.

Syntax:=MIN(range or number)

Example: =MIN(A1:A5)gives the output 10

Explanation:

MAX It return the largest value in a given range of cells. Syntax: =MAX(range or numbers)

Example:=MAX(A1:A5)gives the output 50

MIN

It returns the smallest value in a given range of cells.

Syntax:=MIN(range or number)

Example: =MIN(A1:A5)gives the output 10