如何在mssql中找到标准偏差？ [英] how to find standard deviation in mssql?

问题描述

COMPOUND_CODE供应商TARGET抑制1抑制2抑制3 average_inhi

000A-0013 ChemDev BRCT 5.55057 -6.47881 -18.41165 -6.4466300000000000

000A-0013 ChemDev GRB2 -54.42318 -15.69042 NULL -35.0568000000000000

000A-0013 ChemDev TOPBP1-7 / 8 -16.14892 -15.28732 -4.86530 -12.1005133333333333

000A-0084 ChemDev BRCT -22.34173 -43.79677 -37.04693 -34.3951433333333333

000A-0084 ChemDev GRB2 5.97138 15.17259 NULL 10.5719850000000000

000A-0084 ChemDev TOPBP1-7 / 8 -33.99933 -9.60903 -4.86530 -16.1578866666666666

000A-0089 ChemDev BRCT -23.55783 -50.19342 -57.17303 -43.6414266666666666

000A-0089 ChemDev GRB2 -49.62850 6.78365 NULL -21.4224250000000000

000A-0089 ChemDev TOPBP1-7 / 8 -16.04825 -3.98949 - 10.17289 -10.0702100000000000





我选择值的问题

COMPOUND_CODE Vendor TARGET inhibition1 inhibition2 inhibition3 average_inhi
000A-0013 ChemDev BRCT 5.55057 -6.47881 -18.41165 -6.4466300000000000
000A-0013 ChemDev GRB2 -54.42318 -15.69042 NULL -35.0568000000000000
000A-0013 ChemDev TOPBP1-7/8 -16.14892 -15.28732 -4.86530 -12.1005133333333333
000A-0084 ChemDev BRCT -22.34173 -43.79677 -37.04693 -34.3951433333333333
000A-0084 ChemDev GRB2 5.97138 15.17259 NULL 10.5719850000000000
000A-0084 ChemDev TOPBP1-7/8 -33.99933 -9.60903 -4.86530 -16.1578866666666666
000A-0089 ChemDev BRCT -23.55783 -50.19342 -57.17303 -43.6414266666666666
000A-0089 ChemDev GRB2 -49.62850 6.78365 NULL -21.4224250000000000
000A-0089 ChemDev TOPBP1-7/8 -16.04825 -3.98949 -10.17289 -10.0702100000000000


my querry for selecting the values

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [COMPOUND_CODE]
      ,[Vendor]
      ,[TARGET]
      ,[inhibition1]
      ,[inhibition2]
      ,[inhibition3]
      ,[average_inhi]
  FROM [IJC_FINALIZE].[dbo].[SUNBIO_HTS_IJ

i希望找到[inhibit1]的标准偏差

，[inhibit2]

，[inhibit3]

，[average_inhi]

i want to find the stadard deviation for the [inhibition1]
,[inhibition2]
,[inhibition3]
,[average_inhi]

推荐答案

字面上来自 Google [ ^ ]：

Literally the first result from Google[^]:

STDEV（Transact-SQL） [ ^ ]

返回指定表达式中所有值的统计标准差。

Returns the statistical standard deviation of all values in the specified expression.

这篇关于如何在mssql中找到标准偏差？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！