Perform online research and find five statistical functions not mentioned in the lesson. Specify their functionality and syntax.

MAX: The Max function expresses the maximum value of a given set of values. The input can be numbers, or the input can be cell addresses (A1; A2; etc.) containing numeric values.

Syntax: MAX(number1; number2; number3….number30)

INTERCEPT: The Intercept function calculates the y-value of a straight line that intersects the graph at the Y-axis. Its syntax consists of the x-value and y-value of the line, and the function performs the calculation based on this data.

Syntax: INTERCEPT(data_Y; data_X)

COUNT: The Count function expresses the count of numbers in a list. It ignores text entries in the list. If there are three numbers and one text item in a list, this function will express a result of 3.

Syntax: COUNT(Value1; Value2;……Value30)

PERMUT: The Permut function calculates the number of permutations or possibilities for a given number of objects.  

Syntax: PERMUT(Count1; Count2)

CORREL: The Correl function calculates the correlation coefficient between two data sets.

Syntax: CORREL (Data1; Data 2)

Explanation:

d?

explanation: