Computer Science, asked by ishubht, 11 months ago

Give the syntax and example of any three statistical functions in spreadsheet.

Answers

Answered by sushiladevi4418

Explanation:

Statistical functions in the spreadsheet:

AVERAGE

It helps in calculating the average a set of numbers.

Syntax

AVERAGE(number_1, number_2......number_n)

Example

AVERAGE(A15: A20) will return the average across the cells A15 to A20.

MAX

It will return the maximum value within the specified range of a cell.

Syntax

MAX(number_1,number_2...number_n)

Example

MAX(A15:A20)

It will return the maximum value from the cells A15 to A20.

MIN

MIN(number_1,number_2...number_n)

It will return the minimum value within the specified range of a cell.

Example

MIN(A15: A20) will return the minimum value from the cell A15 to A20.

Answered by khushisathish100

Answer:

Statistical Functions

Explanation:

Statistical functions in the spreadsheet:

Previous Question

Next Question