Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 122 of 212

110 C H A P T E R 6 | More analytics Function type Function Description MROUND() Returns a number rounded to the nearest multiple of a specified number. ODD() Rounds a number up to the nearest odd integer. PI() Returns the value of pi with 15-digit accuracy. PRODUCT() Returns the product of values in a column. PRODUCTX() Returns the product of an expression evaluated for each row in a table. QUOTIENT() Performs division on the numerator and denominator provided as arguments and returns the integer portion of the result. RADIANS() Converts degrees to radians. SIN() Returns the sine of a number. SINH() Returns the hyperbolic sine of a number. SQRTPI() Returns the square root of pi multiplied by a specified number. TAN() Returns the tangent of a number. TANH() Returns the hyperbolic tangent of a number. XIRR() Returns the internal rate of return. XNPV() Returns the net present value. Statistical BETA.DIST() Returns the beta distribution of a sample. BETA.INV() Returns the inverse of the beta cumulative probability density function. CHISQ.INV() Returns the inverse of the left-tailed probability of the chi-squared distribution. CHISQ.INV.RT() Returns the inverse of the right-tailed probability of the chi-squared distribution. CONFIDENCE.NORM() Returns the confidence interval as a range of values. CONFIDENCE.T() Returns the confidence interval for a population mean using a student's t distribution. EXPON.DIST() Returns the exponential distribution. GEOMEAN() Returns the geometric mean of numbers in a column. GEOMEANX() Returns the geometric mean of an expression evaluated for each row in a column. MEDIAN() Returns the median of numbers in a column. MEDIANX() Returns the median of an expression evaluated for each row in a column. PERCENTILE.EXC() Returns the kth percentile of values in a range, where k is in the range 0 to 1, exclusive. PERCENTILE.INC() Returns the kth percentile of values in a range, where k is in the range 0 to 1, inclusive. PERCENTILEX.EXC() Returns the kth percentile of an expression evaluated for each row in a column, where k is in the range 0 to 1, exclusive.

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016