Login     Register

        Contact Us     Search

XLeratorDB/statistics Documentation

SQL Server harmonic mean function


 
Updated: 6 August 2010

Use HARMEAN_q to calculate the harmonic mean of a dataset containing positive numbers. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals. The equation for harmonic mean is:
 HARMEAN
Syntax
SELECT [wctStatistics].[wct].[HARMEAN_q] (
   <@Values_RangeQuery, nvarchar(4000),>)
Arguments
 
@Values_RangeQuery
the select statement, as text, used to determine the values to be used in the HARMEAN_q calculation.
Return Types
float
Remarks
·         If any values in the dataset are less than or equal to zero, HARMEAN_q will return an error.
·         No GROUP BY is required for this function even though it produces aggregated results.
Examples
CREATE TABLE #h1(
      [num] [float] NOT NULL
)
insert into #h1 Values (4.6)
insert into #h1 Values (5.7)
insert into #h1 Values (8.3)
insert into #h1 Values (7.29)
insert into #h1 Values (10.965)
insert into #h1 Values (4.166667)
insert into #h1 Values (3.14159265358979)
select wct.HARMEAN_q('Select num from #h1')

This produces the following result

----------------------
5.38463536083465
 
(1 row(s) affected)


Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service