Question

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

Answer 1

$\textbf{ Answer }$

SQRT(4) This function can be entered in any cell and will return 2.

SQRT(B1) This returns the square root of the value in cell B1.

SQRT(4+B1) This returns the square root of 4 plus the value in cell B1. The parameter to this function is called an Expression.

SUM(F4:F24) Thus returns the sum of cells F4 through F24.

Answer 2

Answer:

The answer to the given question is explained below

Explanation:

The syntax and examples of three statistical functions in the spreadsheet are explained below.

The three statistical functions of the spreadsheet will be

Average, Minimum and maximum.

Average:

The syntax for the average will be

AVERAGE( number _1, number _2......., number _n).

The example for the average will be

AVERAGE(A11:A20)

This function will return the average across cells 11 to 20 of row A.

Maximum.

This function will return the maximum value within the specified range of the cell

syntax:

MAX( number_1, number 2,......number _n)

Example :

MAX(A10, A19)

This function will return the maximum value within the cells A10 to A19.

MINIMUM.

This function returns the minimum value within the specified range of the cell.

Syntax:

MIN( number_1,number_2,......, number_n)

Example :

MIN(C10, C25)

this will return the minimum value within the cells C10 and C25.

# spj3

we can find similar questions through the link given below

https://brainly.in/question/33763669?referrer=searchResult