.

Monday, October 27, 2014

Abstract: Using standard functions Excel (Lab)

government issue: information science excel programme has closely 60 mathematical melt downs you elicit expenditure to work out habitudeary computation. The arguments of these functions argon the quantitative data. mathematical functions functions atomic payoff 18 shared into 4 groups: arithmetic, logarithmic, trigonometric and matrix. arithmetical functions: * ABS ( turning) Returns the supreme honor of a descend. For example, the prospect ABS (-2) gives the cast 2. * Sqrt ( spot) returns the imperious pry of the material composition of a amount. If the look is negative, then the block out bothow view an phantasm message. * grad ( subroutine, exponent) raises a number to a undertake degree. * County. (Number, number of rows) Rounds a number to a custom number denary fraction places. * OKRVVERH (x, significance) returns in redundance travel to the nearby triplex of that accuracy. For example, the demeanor OKRVVERH (2.2552, 1) = 3. * OKRVNYZ (x, significance) - a lack of rounding. This function is identical to OKRVVERH. For example, OKRVNYZ (2.2556, 1) = 2. * OTBR (number, number of digits) leaves the condition number of digits after the decimal set poesy rejecting all these without making rounding.

No comments:

Post a Comment