Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
1, the maximum value for data sets MAX and MIN minimum The two function MAX, MIN data set is used to solve the extremum (ie maximum, minimum). Usage is very simple function. Grammatical form of function (number1, number2 ,...), which Number1, number2, ... need to find the greatest value to the value 1-30. If you want to calculate an array of blank or reference cell, the logic value or the text will be ignored. Therefore, if the logic of value and the text can not be ignored, please use the MAXA function with A or in place of MINA. 2, for the first K data of the first k max LARGE and SMALL a minimum These two functions LARGE, SMALL and MAX, MIN is to imagine that the return difference is that they are not extreme, but the first K values. Grammatical form is: function (array, k), which the Array for the need to find the first k-minimum-type of the array or digital data. K for the return of the data or data in the array region of the location (if it is for the smallest row LARGE, SMALL function if the emission from small to large). Having said that, we can think of it. If K = 1 or K = n (assuming that there are n data data), it is not on the data set can return the maximum or minimum value of it. 3, and the median data MEDIAN MEDIAN function returns the given set of median values. The so-called median is defined as a set 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. Grammatical form of MEDIAN (number1, number2, ...) which Number1, number2, ... is the need to find the median number of 1-30 parameters. If the array or reference argument contains text, logical value or a blank cell, then ignore these values, but its value is zero cells will be included. It should be noted that, if the parameter set contains the number of even-numbered months, MEDIAN function returns the number is in the middle of the average of the two. 4, data for the largest number of frequency MODE MODE function to return an array or data in a frequency region up to values. MEDIAN with the same, MODE is also a function of position measurement. Grammatical form of MODE (number1, number2, ...) which Number1, number2, ... are used in plural (the plural refers to a set of values in the highest frequency value) calculated 1-30 parameters can use a single array (that is, the region of the array reference) to replace the parameters separated by commas. 5, the above example function Year-end bonus to a unit allocation table as an example. In the example, we will use these functions to solve the distribution of year-end bonus units the maximum amount, the minimum amount of average size, the middle amount, and the plural, the second highest amount of amount of money. Detailed wording of the formula can be clearly seen in the figure shall not repeat them here.
|
