Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
3, the function for data DELTA screening and GESTEP (1) to test whether the two values of the function equal to DELTA DELTA to test whether the two values equal. If number1 = number2, then return 1, otherwise return 0. Screening of this function can be used a set of data, for example, by summing several DELTA function, you can calculate the number of the same data. Function is also known as the Kronecker Delta function. If omitted, assuming zero Number2. Number1 or number2 if non-numeric, it returns an error value DELTA function # VALUE!. (2) may be a function of screening data GESTEP The use of screening data GESTEP function. Number greater than or equal to if the step, return 1, otherwise return 0. For example, by calculating the number of return values GESTEP function, data can be detected above a certain threshold number of data. Grammatical form: GESTEP (number, step) to be Number One numerical tests. Step said threshold. If you omit the step, then the assumption that the zero GESTEP function. It must be noted that, if any non-numerical parameters, the GESTEP function returns an error value # VALUE! (3) statistics of examination results as an example of the use of function For example: a mathematical simulation of the examination held in institutions, are scheduled performance. Evaluation of the program proposed to derive results for more than 90 hours the number of candidates who are going to lose. Here we GEStep function used to complete the statistics, the first results of the candidates for each marking. More than 90 points marked as 1, otherwise 0, and then all the candidates on the summary of the markers can be calculated how many people have more than 90 hours.
= GESTEP (C4, 90) |
