Respuesta :
Answer:
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:
