41.MAX

Purposes: to return to the greatest concentration of numerical data.

Syntax: MAX (number1, number2 ,…)

Parameters: Number1, number2, … is the need to find the greatest value of 1-30 values.

Example: If A1 = 71, A2 = 83, A3 = 76, A4 = 49, A5 = 92, A6 = 88, A7 = 96, while the formula “= MAX (A1: A7)” to return to 96.

42.MAXA

Purposes: to return to the greatest concentration of numerical data. With MAX value of the difference between the text and logical values (such as TRUE and FALSE) as a figure involved in the calculation.

Syntax: MAXA (value1, value2 ,…)

Parameters: value1, value2, … need to find the greatest value from the 1-30 parameters.

Example: If A1: A5 contains 0,0.2,0.5,0.4 and TRUE, then: MAXA (A1: A5) return 1.

43.MEDIAN

Purposes: to return to a given set of median values (it is in a group of data in the middle of a few. In other words, in this set of data, over half of the data than it is large, more than half of the data it small) .

Syntax: MEDIAN (number1, number2 ,…)

Parameters: Number1, number2, … is the need to find the median number of 1-30 parameters.

Examples: MEDIAN (11,12,13,14,15) return 13; MEDIAN (1,2,3,4,5,6) to return to 3.5, that is, the average of 3 and 4.

44.MIN

Purposes: to return to the table to set the minimum parameters.

Syntax: MIN (number1, number2 ,…)。

Parameters: Number1, number2, … are found from the minimum number of 1-30 parameters.

Example: If A1 = 71, A2 = 83, A3 = 76, A4 = 49, A5 = 92, A6 = 88, A7 = 96, while the formula “= MIN (A1: A7)” return 49; and = MIN (A1 : A5, 0, -8) return -8.

45.MINA

Purposes: to return to the list of parameters of the minimum value. MIN function with the difference between the value of the text and logical values (such as TRUE and FALSE) are also calculated as the number of participation.

Syntax: MINA (value1, value2 ,…)

Parameters: value1, value2, … need to find the smallest value from 1-30 parameters.

Example: If A1 = 71, A2 = 83, A3 = 76, A4 = 49, A5 = 92, A6 = 88, A7 = FALSE, then the formula “= MINA (A1: A7)” return 0.

46.MODE

Purposes: to return to the array or data in a particular area of the plural.

Syntax: MODE (number1, number2 ,…)。

Parameters: Number1, number2, … are calculated for the plural 1-30 parameters.

Example: If A1 = 71, A2 = 83, A3 = 71, A4 = 49, A5 = 92, A6 = 88, while the formula “= MODE (A1: A6)” to return to 71.

47.NEGBINOMDIST

Purposes: to return to the negative binomial distribution. When the success probability is constant probability_s, the function return NEGBINOMDIST successful in number_s prior to arrival, there number_f times the probability of failure. This function is similar with the binomial distribution, but its success is the number of fixed, test the total number of variables. With the binomial distribution is similar to test number was assumed to be independent variables.

Syntax: NEGBINOMDIST (number_f, number_s, probability_s)

Views Number_f is a failure, Number_s critical for the success of the number, Probability_s is the probability of success.

Example: If looking for 10 people who have reacted swiftly, and the known characteristics of the candidates have such a probability of 0.3. Then, to find qualified candidates 10 months before the need for qualified candidates for the probability of the formula “= NEGBINOMDIST (40,10,0.3)”, the calculation result is 0.007723798.

48.NORMDIST

Purposes: to return to a given mean and standard deviation of the cumulative normal distribution function.

Syntax: NORMDIST (x, mean, standard_dev, cumulative)

Parameters: X is used to calculate the normal distribution function of the interval point, Mean is the arithmetic mean of the distribution, Standard_dev is the distribution of standard deviation; Cumulative is a logical value, specified in the form of function. If cumulative is TRUE, then return to the cumulative distribution function NORMDIST function; If FALSE, the return probability density function.

Example: the formula “= NORMDIST (46,35,2.5, TRUE)” to return to .999994583.

49.NORMSINV

Purposes: to return the cumulative standard normal distribution function of the inverse function. The distribution of the average 0, standard deviation of 1.

Syntax: NORMSINV (probability)

Parameters: Probability is the probability distribution.

Example: the formula “= NORMSINV (0.8)” to return to .841621386.

50.NORMSDIST

Purposes: to return the cumulative standard normal distribution function, the distribution of average 0, standard deviation of 1.

Syntax: NORMSDIST (z)

Parameters: Z for the need to calculate the distribution of values.

Example: the formula “= NORMSDIST (1.5)” the results of the calculation of 0.933192771.

51.NORMSINV

Purposes: to return the cumulative standard normal distribution function of the inverse function. The distribution of the average 0, standard deviation of 1.

Syntax: NORMSINV (probability)

Parameters: Probability is the probability distribution.

Example: the formula “= NORMSINV (0.933192771)” to return to 1.499997779 (ie 1.5).

52.PEARSON

Purposes: to return to Pearson (Napier Health) the product moment correlation coefficient r, it is a range of between -1.0 to 1.0 (including -1.0 and 1.0 inclusive) of the non-dimensional index, reflecting the data collection between the two linear relevance.

Syntax: PEARSON (array1, array2)

Parameters: Array1 set as variables, Array2 set as the dependent variable.

Example: If A1 = 71, A2 = 83, A3 = 71, A4 = 49, A5 = 92, A6 = 88, B1 = 69, B2 = 80, B3 = 76, B4 = 40, B5 = 90, B6 = 81 , then the formula “= PEARSON (A1: A6, B1: B6)” to return to 0.96229628.

53.PERCENTILE

Purposes: to return to the K value of regional numerical point percentage. For example, examinations to determine the top 80 percentage points in the scores.

Syntax: PERCENTILE (array, k)

Parameters: Array for the definition of the relative positions of the array or the numerical values of regional, k for the array needs to be the value of their ranking.

Example: If a sub-test scores for A1 = 71, A2 = 83, A3 = 71, A4 = 49, A5 = 92, A6 = 88, while the formula “= PERCENTILE (A1: A6, 0.8)” to return to 88, that is, examination In order to place more than 80 percentage points, while scores of at least 88 points should be.

54.PERCENTRANK

Purposes: to return a value in a data set as a percentage of qualifying can be used to view data in the data location. For example, a calculation of scores of examination results in all position.

Syntax: PERCENTRANK (array, x, significance)

Parameters: Array for each other to determine the relative position of the data set, X for which the values need to be qualifying, Significance is optional, that the percentage of the value of the return of the median effective. If omitted, function to retain three decimal PERCENTRANK.

Example: If a sub-test scores for A1 = 71, A2 = 83, A3 = 71, A4 = 49, A5 = 92, A6 = 88, while the formula “= PERCENTRANK (A1: A6, 71)” The results of the 0.2 , that is, 71 points in six scores ranked 20%.

55.PERMUT

Purposes: to return from a given number of selected elements of the collection with a few number of elements.

Syntax: PERMUT (number, number_chosen)

Parameters: Number for the total number of elements, Number_chosen each with the number of elements.

Example: If a lottery number 9 number, each number ranging from 0-9 (including 0 and 9). With the number of all possible use of the formula “= PERMUT (10,9)” calculation, the result is 3628800.

56.POISSON

Purposes: to return to Poisson distribution. Poisson distribution is usually a period of time used to predict the number of incidents, such as within a minute through the toll booths of the number of cars.

Syntax: POISSON (x, mean, cumulative)

Parameters: X is a number of events, Mean is the expected value, Cumulative probability of return in order to determine the logic value of the distribution of the form.

Example: the formula “= POISSON (5,10, TRUE)” to return to 0.067085963, = POISSON (3,12, FALSE) to return to .001769533.

57.PROB

Purposes: to return to a group the probability of the incident falls within the designated area of the incident and the corresponding probability.

Syntax: PROB (x_range, prob_range, lower_limit, upper_limit)

Parameters: X_range is a probability value of their respective x values of regional, Prob_range with the numerical x_range corresponding to a set of probability values, Lower_limit for the numerical calculation of the probability of lower bound of summation, Upper_limit is used to calculate the probability summation of optional upper bound value.

Example: the formula “= PROB ((0,1,2,3), (0.2,0.3,0.1,0.4), 2)” back to 0.1, = PROB ((0,1,2,3), (0.2,0.3 , 0.1,0.4), 1,3) return 0.8.

58.QUARTILE

Purposes: to return a set of data points quartile. Quartile test scores are commonly used in data such as the overall group, such as a group obtained scores in the top 25% of the scores.

Syntax: QUARTILE (array, quart)

Parameters: Array quartile for the need to find the value of the array or the number of reference regions, Quart decided to return the value of which quartile. If qurart check 0,1, 2,3 or 4, QUARTILE function is to return to the minimum, first quartile (25th percentile ranking), middle of the median (50th percentile ranking), the third quartile (75th percentile ranking) and the maximum value.

Example: If A1 = 78, A2 = 45, A3 = 90, A4 = 12, A5 = 85, while the formula “= QUARTILE (A1: A5, 3)” to return to 85.

59.RANK

Purposes: to return a numeric value in a group of ranking (if the data list has been ranked the sequence, then the value of the current ranking is its location).

Syntax: RANK (number, ref, order)

Parameters: Number is the need to calculate the ranking of a number; Ref is an array contains a set of figures or references (including the non-value-type parameters are ignored); Order for a number of ways specified in qualifying. If the order is 0 or omitted, according to the data in descending order of ranking list. If the order is not zero, ref as the data in ascending order according to the list of qualifying.

NOTE: RANK function to repeat the same numerical ranking. However, the existence of duplication of the number of follow-up will affect the ranking values. If an integer, if an integer 60 appears twice, the ranking of 5, then 61 qualifying for the 7 (not ranking the value of 6).

Example: If A1 = 78, A2 = 45, A3 = 90, A4 = 12, A5 = 85, while the formula “= RANK (A1, $ A $ 1: $ A $ 5)” to return to 5,8,2,10,4 .

60.RSQ

Purposes: to return to the set of data points of Pearson product moment correlation coefficient of the square.

Syntax: RSQ (known_y’s, known_x’s)

Parameters: Known_y’s for an array or data region, Known_x’s also an array or data.

Example: the formula “= RSQ ((22,23,29,19,38,27,25), (16,15,19,17,15,14,34))” return .013009334.