Extended Statistics Report

PropertyValue
DTM Database Content Analyzer 1.03.01
DatabaseSQL Server Native Client 11.0: .///AdventureWorks [AdventureWorks]
Analyzed tables70
Total data size, bytes 69 892 712
Report created07-Sep-2015 15:56

Table of Content

dbo.AWBuildVersion
dbo.DatabaseLog
HumanResources.Department
HumanResources.Employee
HumanResources.EmployeeAddress
HumanResources.EmployeeDepartmentHistory
HumanResources.EmployeePayHistory
HumanResources.JobCandidate
HumanResources.Shift
Person.Address
Person.AddressType
Person.Contact
Person.ContactType
Person.CountryRegion
Person.StateProvince
Production.BillOfMaterials
Production.Culture
Production.Document
Production.Illustration
Production.Location
Production.Product
Production.ProductCategory
Production.ProductCostHistory
Production.ProductDescription
Production.ProductDocument
Production.ProductInventory
Production.ProductListPriceHistory
Production.ProductModel
Production.ProductModelIllustration
Production.ProductModelProductDescriptionCulture
Production.ProductPhoto
Production.ProductProductPhoto
Production.ProductReview
Production.ProductSubcategory
Production.ScrapReason
Production.TransactionHistory
Production.TransactionHistoryArchive
Production.UnitMeasure
Production.WorkOrder
Production.WorkOrderRouting
Purchasing.ProductVendor
Purchasing.PurchaseOrderDetail
Purchasing.PurchaseOrderHeader
Purchasing.ShipMethod
Purchasing.Vendor
Purchasing.VendorAddress
Purchasing.VendorContact
Sales.ContactCreditCard
Sales.CountryRegionCurrency
Sales.CreditCard
Sales.Currency
Sales.CurrencyRate
Sales.Customer
Sales.CustomerAddress
Sales.Individual
Sales.SalesOrderDetail
Sales.SalesOrderHeader
Sales.SalesOrderHeaderSalesReason
Sales.SalesPerson
Sales.SalesPersonQuotaHistory
Sales.SalesReason
Sales.SalesTaxRate
Sales.SalesTerritory
Sales.SalesTerritoryHistory
Sales.ShoppingCartItem
Sales.SpecialOffer
Sales.SpecialOfferProduct
Sales.Store
Sales.StoreContact

Table: dbo.AWBuildVersion

ColumnPropertyValue
SystemInformationID, tinyint identityTotal values1
 Range0 [1;1]
 Arithmetic mean1
 Arithmetic mean absolute deviation0
 Median value1
 Median absolute deviation0
 Harmonic mean1
 Geometric mean1
 Mode value(s)1
ColumnPropertyValue
VersionDate, datetimeTotal values1
 Minimum value2006-04-26
 Arithmetic mean2006-04-26
 Maximum value2006-04-26
 Median2006-04-26
ColumnPropertyValue
ModifiedDate, datetimeTotal values1
 Minimum value2006-04-26
 Arithmetic mean2006-04-26
 Maximum value2006-04-26
 Median2006-04-26

Table: dbo.DatabaseLog

ColumnPropertyValue
DatabaseLogID, int identityTotal values389
 Range388 [1;389]
 Interquartile range195 [98;293]
 Arithmetic mean195
 Arithmetic mean absolute deviation97.2494
 Median value195
 Median absolute deviation97.2494
 Harmonic mean59.4612
 Geometric mean144.547
 Mode value(s)1, 2, 5, 6, 7, 21, 3, 8, 9, 10...
 Variance12642.5
 Standard deviation112.439
 Expected value195
 Skewness0
 Kurtosis-1.20926
ColumnPropertyValue
PostTime, datetimeTotal values389
 Minimum value2006-04-26
 Arithmetic mean2006-04-26
 Maximum value2006-04-26
 Median2006-04-26

Table: HumanResources.Department

ColumnPropertyValue
DepartmentID, smallint identityTotal values16
 Range15 [1;16]
 Interquartile range8 [5;13]
 Arithmetic mean8.5
 Arithmetic mean absolute deviation3.5
 Median value8.5
 Median absolute deviation3.5
 Harmonic mean4.73271
 Geometric mean6.80047
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance22.6667
 Standard deviation4.76095
 Expected value8.5
 Skewness0
 Kurtosis-1.42624
ColumnPropertyValue
ModifiedDate, datetimeTotal values16
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: HumanResources.Employee

ColumnPropertyValue
EmployeeID, int identityTotal values290
 Range289 [1;290]
 Interquartile range146 [73;219]
 Arithmetic mean145.5
 Arithmetic mean absolute deviation72
 Median value145.5
 Median absolute deviation72
 Harmonic mean46.4088
 Geometric mean108.075
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance7032.5
 Standard deviation83.86
 Expected value145.5
 Skewness0
 Kurtosis-1.21242
ColumnPropertyValue
ContactID, intTotal values290
 Range289 [1001;1290]
 Interquartile range146 [1073;1219]
 Arithmetic mean1145.5
 Arithmetic mean absolute deviation72
 Median value1145.5
 Median absolute deviation72
 Harmonic mean1139.36
 Geometric mean1142.43
 Mode value(s)1209, 1030, 1002, 1290, 1009, 1028, 1070, 1071, 1005, 1076...
 Variance7032.5
 Standard deviation83.86
 Expected value1145.5
 Skewness0
 Kurtosis-1.21242
ColumnPropertyValue
ManagerID, intTotal values289
 Range285 [3;288]
 Interquartile range157 [25;182]
 Arithmetic mean107.838
 Arithmetic mean absolute deviation73.8858
 Median value90
 Median absolute deviation73.9619
 Harmonic mean29.6099
 Geometric mean66.119
 Mode value(s)21
 Variance7348.83
 Standard deviation85.7253
 Expected value108.211
 Skewness151.652
 Kurtosis-0.946435
ColumnPropertyValue
BirthDate, datetimeTotal values290
 Minimum value1941-11-17
 Arithmetic mean1968-07-05
 Maximum value1981-07-01
 Median1968-11-19
ColumnPropertyValue
HireDate, datetimeTotal values290
 Minimum value1996-08-00
 Arithmetic mean1999-06-20
 Maximum value2003-07-01
 Median1999-03-06
ColumnPropertyValue
VacationHours, smallintTotal values290
 Range99 [0;99]
 Interquartile range50 [26;76]
 Arithmetic mean50.6138
 Arithmetic mean absolute deviation24.2241
 Median value51
 Median absolute deviation24.7172
 Mode value(s)48
 Variance828.646
 Standard deviation28.7862
 Expected value50.6138
 Skewness-19.6921
 Kurtosis-1.17184
ColumnPropertyValue
SickLeaveHours, smallintTotal values290
 Range60 [20;80]
 Interquartile range25 [33;58]
 Arithmetic mean45.3069
 Arithmetic mean absolute deviation11.9759
 Median value46
 Median absolute deviation12.4724
 Harmonic mean40.0462
 Geometric mean42.754
 Mode value(s)64
 Variance211.425
 Standard deviation14.5404
 Expected value45.3069
 Skewness-16.0871
 Kurtosis-1.12748
ColumnPropertyValue
ModifiedDate, datetimeTotal values290
 Minimum value2004-08-00
 Arithmetic mean2004-08-01
 Maximum value2005-01-26
 Median2004-08-00

Table: HumanResources.EmployeeAddress

ColumnPropertyValue
EmployeeID, intTotal values290
 Range289 [1;290]
 Interquartile range146 [73;219]
 Arithmetic mean145.5
 Arithmetic mean absolute deviation72
 Median value145.5
 Median absolute deviation72
 Harmonic mean46.4088
 Geometric mean108.075
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance7032.5
 Standard deviation83.86
 Expected value145.5
 Skewness0
 Kurtosis-1.21242
ColumnPropertyValue
AddressID, intTotal values290
 Range32520 [1;32521]
 Interquartile range156 [88;244]
 Arithmetic mean2127.77
 Arithmetic mean absolute deviation3689.38
 Median value160.5
 Median absolute deviation2040.87
 Harmonic mean53.8737
 Geometric mean169.812
 Mode value(s)61, 234, 224, 11387, 1, 214, 92, 240, 190, 56...
 Variance5.85648e+007
 Standard deviation7652.77
 Expected value2127.77
 Skewness1062.96
 Kurtosis11.5879
ColumnPropertyValue
ModifiedDate, datetimeTotal values290
 Minimum value2004-10-13
 Arithmetic mean2004-10-13
 Maximum value2004-10-13
 Median2004-10-13

Table: HumanResources.EmployeeDepartmentHistory

ColumnPropertyValue
EmployeeID, intTotal values296
 Range289 [1;290]
 Interquartile range146 [73;219]
 Arithmetic mean145.233
 Arithmetic mean absolute deviation72.5338
 Median value144.5
 Median absolute deviation72.5304
 Harmonic mean44.2429
 Geometric mean106.557
 Mode value(s)274
 Variance7143.59
 Standard deviation84.5198
 Expected value145.233
 Skewness0.43337
 Kurtosis-1.21463
ColumnPropertyValue
DepartmentID, smallintTotal values296
 Range15 [1;16]
 Interquartile range0 [7;7]
 Arithmetic mean7.26689
 Arithmetic mean absolute deviation1.375
 Median value7
 Median absolute deviation1.5777
 Harmonic mean5.70472
 Geometric mean6.64037
 Mode value(s)7
 Variance7.86412
 Standard deviation2.8043
 Expected value7.26689
 Skewness211.028
 Kurtosis1.45187
ColumnPropertyValue
ShiftID, tinyintTotal values296
 Range2 [1;3]
 Interquartile range1 [1;2]
 Arithmetic mean1.56081
 Arithmetic mean absolute deviation0.175676
 Median value1
 Median absolute deviation0.560811
 Harmonic mean1.28509
 Geometric mean1.4024
 Mode value(s)1
 Variance0.599679
 Standard deviation0.77439
 Expected value1.56081
 Skewness275.978
 Kurtosis-0.713428
ColumnPropertyValue
StartDate, datetimeTotal values296
 Minimum value1996-08-00
 Arithmetic mean1999-07-06
 Maximum value2003-12-16
 Median1999-03-07
ColumnPropertyValue
EndDate, datetimeTotal values6
 Minimum value1999-08-15
 Arithmetic mean2001-09-06
 Maximum value2003-12-15
 Median2001-09-15
ColumnPropertyValue
ModifiedDate, datetimeTotal values296
 Minimum value1996-07-30
 Arithmetic mean1999-07-21
 Maximum value2003-12-15
 Median1999-03-08

Table: HumanResources.EmployeePayHistory

ColumnPropertyValue
EmployeeID, intTotal values316
 Range289 [1;290]
 Interquartile range142 [72;214]
 Arithmetic mean143.383
 Arithmetic mean absolute deviation71.2975
 Median value142.5
 Median absolute deviation71.2943
 Harmonic mean43.1758
 Geometric mean104.711
 Mode value(s)4, 6, 24, 62, 96, 113, 134, 140, 146, 171...
 Variance6999.14
 Standard deviation83.6609
 Expected value143.383
 Skewness4.48567
 Kurtosis-1.17309
ColumnPropertyValue
RateChangeDate, datetimeTotal values316
 Minimum value1996-08-00
 Arithmetic mean1999-09-14
 Maximum value2003-08-15
 Median1999-03-12
ColumnPropertyValue
Rate, moneyTotal values316
 Range119 [6.5;125.5]
 Interquartile range12.0769
 Arithmetic mean17.7588
 Arithmetic mean absolute deviation7.47468
 Median value14
 Median absolute deviation6.66456
 Harmonic mean13.8334
 Geometric mean15.3791
 Mode value(s)9.5000
 Variance150.712
 Standard deviation12.2765
 Expected value17.7588
 Skewness1168.26
 Kurtosis22.1035
ColumnPropertyValue
PayFrequency, tinyintTotal values316
 Range1 [1;2]
 Interquartile range1 [1;2]
 Arithmetic mean1.43038
 Arithmetic mean absolute deviation0
 Median value1
 Median absolute deviation0.43038
 Harmonic mean1.27419
 Geometric mean1.34759
 Mode value(s)1
 Variance0.245931
 Standard deviation0.495915
 Expected value1.43038
 Skewness88.4442
 Kurtosis-1.92773
ColumnPropertyValue
ModifiedDate, datetimeTotal values316
 Minimum value1997-12-22
 Arithmetic mean2004-03-02
 Maximum value2004-08-00
 Median2004-08-00

Table: HumanResources.JobCandidate

ColumnPropertyValue
JobCandidateID, int identityTotal values13
 Range12 [1;13]
 Interquartile range7 [4;11]
 Arithmetic mean7
 Arithmetic mean absolute deviation3.23077
 Median value7
 Median absolute deviation3.23077
 Harmonic mean4.08788
 Geometric mean5.66769
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance15.1667
 Standard deviation3.89444
 Expected value7
 Skewness0
 Kurtosis-1.47844
ColumnPropertyValue
EmployeeID, intTotal values2
 Range227 [41;268]
 Arithmetic mean23.7692
 Arithmetic mean absolute deviation130.5
 Median value154.5
 Median absolute deviation113
 Harmonic mean71.1197
 Geometric mean104.824
 Mode value(s)268, 41
 Variance59945.6
 Standard deviation244.838
 Expected value154.5
 Skewness0.992929
 Kurtosis-2.50493
ColumnPropertyValue
ModifiedDate, datetimeTotal values13
 Minimum value1997-07-24
 Arithmetic mean1998-07-24
 Maximum value2004-01-23
 Median1997-07-24

Table: HumanResources.Shift

ColumnPropertyValue
ShiftID, tinyint identityTotal values3
 Range2 [1;3]
 Arithmetic mean2
 Arithmetic mean absolute deviation0.666667
 Median value2
 Median absolute deviation0.666667
 Harmonic mean1.63636
 Geometric mean1.81712
 Mode value(s)1, 2, 3
 Variance1
 Standard deviation1
 Expected value2
 Skewness0
 Kurtosis-2.33333
ColumnPropertyValue
StartTime, datetimeTotal values3
 Minimum value1901-01-01
 Arithmetic mean1901-01-01
 Maximum value1901-01-01
 Median1901-01-01
ColumnPropertyValue
EndTime, datetimeTotal values3
 Minimum value1901-01-01
 Arithmetic mean1901-01-01
 Maximum value1901-01-01
 Median1901-01-01
ColumnPropertyValue
ModifiedDate, datetimeTotal values3
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Person.Address

ColumnPropertyValue
AddressID, int identityTotal values19614
 Range32520 [1;32521]
 Interquartile range9808 [15190;24998]
 Arithmetic mean19516.3
 Arithmetic mean absolute deviation5501.74
 Median value20093.5
 Median absolute deviation5484.76
 Harmonic mean2293.97
 Geometric mean16003.9
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance4.84652e+007
 Standard deviation6961.7
 Expected value19516.3
 Skewness-16911.3
 Kurtosis0.791017
ColumnPropertyValue
StateProvinceID, intTotal values19614
 Range180 [1;181]
 Interquartile range68 [9;77]
 Arithmetic mean49.2846
 Arithmetic mean absolute deviation35.8427
 Median value50
 Median absolute deviation36.3151
 Harmonic mean17.5228
 Geometric mean29.5464
 Mode value(s)9
 Variance2126.01
 Standard deviation46.1086
 Expected value49.2846
 Skewness24283.1
 Kurtosis1.07119
ColumnPropertyValue
ModifiedDate, datetimeTotal values19614
 Minimum value1996-07-24
 Arithmetic mean2003-07-23
 Maximum value2004-08-00
 Median2003-11-15

Table: Person.AddressType

ColumnPropertyValue
AddressTypeID, int identityTotal values6
 Range5 [1;6]
 Interquartile range4 [2;6]
 Arithmetic mean3.5
 Arithmetic mean absolute deviation1
 Median value3.5
 Median absolute deviation1
 Harmonic mean2.44898
 Geometric mean2.9938
 Mode value(s)1, 2, 3, 4, 5, 6
 Variance3.5
 Standard deviation1.87083
 Expected value3.5
 Skewness0
 Kurtosis-1.79762
ColumnPropertyValue
ModifiedDate, datetimeTotal values6
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Person.Contact

ColumnPropertyValue
ContactID, int identityTotal values19972
 Range19976 [1;19977]
 Interquartile range9986 [4999;14985]
 Arithmetic mean9991.25
 Arithmetic mean absolute deviation4992.75
 Median value9991.5
 Median absolute deviation4992.75
 Harmonic mean1906.71
 Geometric mean7354.96
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance3.32465e+007
 Standard deviation5765.97
 Expected value9991.25
 Skewness-4.43136
 Kurtosis-1.19992
ColumnPropertyValue
EmailPromotion, intTotal values19972
 Range2 [0;2]
 Interquartile range1 [0;1]
 Arithmetic mean0.630082
 Arithmetic mean absolute deviation0.188764
 Median value0
 Median absolute deviation0.630082
 Mode value(s)0
 Variance0.610638
 Standard deviation0.781433
 Expected value0.630082
 Skewness14997.6
 Kurtosis-0.968253
ColumnPropertyValue
ModifiedDate, datetimeTotal values19972
 Minimum value1996-07-24
 Arithmetic mean2003-06-18
 Maximum value2005-05-16
 Median2003-10-15

Table: Person.ContactType

ColumnPropertyValue
ContactTypeID, int identityTotal values20
 Range19 [1;20]
 Interquartile range10 [6;16]
 Arithmetic mean10.5
 Arithmetic mean absolute deviation4.5
 Median value10.5
 Median absolute deviation4.5
 Harmonic mean5.55905
 Geometric mean8.30436
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance35
 Standard deviation5.91608
 Expected value10.5
 Skewness0
 Kurtosis-1.38093
ColumnPropertyValue
ModifiedDate, datetimeTotal values20
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Person.CountryRegion

ColumnPropertyValue
ModifiedDate, datetimeTotal values238
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Person.StateProvince

ColumnPropertyValue
StateProvinceID, int identityTotal values181
 Range180 [1;181]
 Interquartile range91 [46;137]
 Arithmetic mean91
 Arithmetic mean absolute deviation45.2486
 Median value91
 Median absolute deviation45.2486
 Harmonic mean31.3232
 Geometric mean67.8933
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance2745.17
 Standard deviation52.3943
 Expected value91
 Skewness0
 Kurtosis-1.21991
ColumnPropertyValue
TerritoryID, intTotal values181
 Range9 [1;10]
 Interquartile range2 [5;7]
 Arithmetic mean5.83978
 Arithmetic mean absolute deviation1.41436
 Median value7
 Median absolute deviation1.46961
 Harmonic mean4.19247
 Geometric mean5.19013
 Mode value(s)7
 Variance4.71308
 Standard deviation2.17096
 Expected value5.83978
 Skewness-166.976
 Kurtosis-0.257284
ColumnPropertyValue
ModifiedDate, datetimeTotal values181
 Minimum value1998-06-01
 Arithmetic mean2001-01-23
 Maximum value2004-03-11
 Median1998-06-01

Table: Production.BillOfMaterials

ColumnPropertyValue
BillOfMaterialsID, int identityTotal values2679
 Range3481 [1;3482]
 Interquartile range1870 [850;2720]
 Arithmetic mean1760.27
 Arithmetic mean absolute deviation906.489
 Median value1770
 Median absolute deviation906.956
 Harmonic mean336.309
 Geometric mean1251.86
 Mode value(s)893, 271, 34, 830, 2074, 1950, 1761, 3088, 3351, 3246...
 Variance1.0939e+006
 Standard deviation1045.9
 Expected value1760.27
 Skewness-24.8892
 Kurtosis-1.24784
ColumnPropertyValue
ProductAssemblyID, intTotal values2576
 Range996 [3;999]
 Interquartile range192 [762;954]
 Arithmetic mean805.474
 Arithmetic mean absolute deviation89.8964
 Median value812
 Median absolute deviation90.3276
 Harmonic mean577.422
 Geometric mean823.996
 Mode value(s)752, 770, 971, 972
 Variance13916.8
 Standard deviation117.97
 Expected value837.681
 Skewness-491.729
 Kurtosis3.36372
ColumnPropertyValue
ComponentID, intTotal values2679
 Range998 [1;999]
 Interquartile range431 [506;937]
 Arithmetic mean701.771
 Arithmetic mean absolute deviation220.355
 Median value806
 Median absolute deviation206.292
 Harmonic mean251.541
 Geometric mean642.501
 Mode value(s)948
 Variance57650.6
 Standard deviation240.105
 Expected value701.771
 Skewness-1201.31
 Kurtosis-1.23948
ColumnPropertyValue
StartDate, datetimeTotal values2679
 Minimum value2000-04-04
 Arithmetic mean2000-08-13
 Maximum value2001-01-23
 Median2000-07-20
ColumnPropertyValue
EndDate, datetimeTotal values199
 Minimum value2000-06-03
 Arithmetic mean2000-09-09
 Maximum value2000-12-15
 Median2000-09-08
ColumnPropertyValue
BOMLevel, smallintTotal values2679
 Range3 [1;4]
 Interquartile range1 [1;2]
 Arithmetic mean1.35984
 Arithmetic mean absolute deviation0.0530049
 Median value1
 Median absolute deviation0.43673
 Mode value(s)1
 Variance0.339477
 Standard deviation0.582646
 Expected value1.35984
 Skewness706.691
 Kurtosis0.121104
ColumnPropertyValue
PerAssemblyQty, decimalTotal values2679
 Range40 [1;41]
 Interquartile range0
 Arithmetic mean2.05412
 Arithmetic mean absolute deviation1.51138
 Median value1
 Median absolute deviation1.05412
 Harmonic mean1.16678
 Geometric mean1.32081
 Mode value(s)1.00
 Variance20.7032
 Standard deviation4.55008
 Expected value2.05412
 Skewness18486.8
 Kurtosis49.8569
ColumnPropertyValue
ModifiedDate, datetimeTotal values2679
 Minimum value2000-03-21
 Arithmetic mean2000-08-05
 Maximum value2001-01-09
 Median2000-07-25

Table: Production.Culture

ColumnPropertyValue
ModifiedDate, datetimeTotal values8
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Production.Document

ColumnPropertyValue
DocumentID, int identityTotal values9
 Range8 [1;9]
 Interquartile range5 [3;8]
 Arithmetic mean5
 Arithmetic mean absolute deviation2.22222
 Median value5
 Median absolute deviation2.22222
 Harmonic mean3.18137
 Geometric mean4.14717
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9
 Variance7.5
 Standard deviation2.73861
 Expected value5
 Skewness0
 Kurtosis-1.60148
ColumnPropertyValue
ChangeNumber, intTotal values9
 Range280 [8;288]
 Interquartile range44 [11;55]
 Arithmetic mean51.3333
 Arithmetic mean absolute deviation53
 Median value25
 Median absolute deviation41
 Mode value(s)0, 25, 15, 32, 28, 11, 8, 55, 288
 Variance8137
 Standard deviation90.2053
 Expected value51.3333
 Skewness17.558
 Kurtosis2.29122
ColumnPropertyValue
Status, tinyintTotal values9
 Range2 [1;3]
 Interquartile range0 [2;2]
 Arithmetic mean1.88889
 Arithmetic mean absolute deviation0.111111
 Median value2
 Median absolute deviation0.333333
 Harmonic mean1.6875
 Geometric mean1.79349
 Mode value(s)2
 Variance0.361111
 Standard deviation0.600925
 Expected value1.88889
 Skewness-0.113785
 Kurtosis-0.636643
ColumnPropertyValue
ModifiedDate, datetimeTotal values9
 Minimum value1998-05-02
 Arithmetic mean2002-06-26
 Maximum value2003-07-01
 Median2002-11-20

Table: Production.Illustration

ColumnPropertyValue
IllustrationID, int identityTotal values5
 Range4 [3;7]
 Interquartile range3 [4;7]
 Arithmetic mean5
 Arithmetic mean absolute deviation1.2
 Median value5
 Median absolute deviation1.2
 Harmonic mean4.57516
 Geometric mean4.78939
 Mode value(s)3, 4, 5, 6, 7
 Variance2.5
 Standard deviation1.58114
 Expected value5
 Skewness0
 Kurtosis-1.912
ColumnPropertyValue
ModifiedDate, datetimeTotal values5
 Minimum value2004-02-10
 Arithmetic mean2004-02-10
 Maximum value2004-02-10
 Median2004-02-10

Table: Production.Location

ColumnPropertyValue
LocationID, smallint identityTotal values14
 Range59 [1;60]
 Interquartile range41 [4;45]
 Arithmetic mean20.2143
 Arithmetic mean absolute deviation17.2857
 Median value8.5
 Median absolute deviation15.7143
 Harmonic mean4.89497
 Geometric mean10.3565
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 10, 20, 30...
 Variance426.489
 Standard deviation20.6516
 Expected value20.2143
 Skewness9.20158
 Kurtosis-1.2833
ColumnPropertyValue
CostRate, smallmoneyTotal values14
 Range12.75 [12.25;25]
 Interquartile range18
 Arithmetic mean8.58929
 Arithmetic mean absolute deviation8
 Median value6.125
 Median absolute deviation8.28571
 Mode value(s).0000
 Variance90.8328
 Standard deviation9.53062
 Expected value8.58929
 Skewness4.82951
 Kurtosis-1.61372
ColumnPropertyValue
Availability, decimalTotal values14
 Range40 [80;120]
 Interquartile range120
 Arithmetic mean54.5714
 Arithmetic mean absolute deviation54.0714
 Median value40
 Median absolute deviation54.5714
 Mode value(s).00
 Variance3322.11
 Standard deviation57.6377
 Expected value54.5714
 Skewness1.16371
 Kurtosis-2.04926
ColumnPropertyValue
ModifiedDate, datetimeTotal values14
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Production.Product

ColumnPropertyValue
ProductID, int identityTotal values504
 Range998 [1;999]
 Interquartile range426 [448;874]
 Arithmetic mean673.04
 Arithmetic mean absolute deviation208.841
 Median value747.5
 Median absolute deviation199.96
 Harmonic mean172.47
 Geometric mean609.963
 Mode value(s)1, 2, 3, 4, 316, 317, 318, 319, 320, 321...
 Variance52612
 Standard deviation229.373
 Expected value673.04
 Skewness-162.542
 Kurtosis-1.15054
ColumnPropertyValue
SafetyStockLevel, smallintTotal values504
 Range996 [4;1000]
 Interquartile range900 [100;1000]
 Arithmetic mean535.151
 Arithmetic mean absolute deviation313.637
 Median value500
 Median absolute deviation304.135
 Harmonic mean33.4338
 Geometric mean271.608
 Mode value(s)500
 Variance139961
 Standard deviation374.113
 Expected value535.151
 Skewness-9.4338
 Kurtosis-1.4363
ColumnPropertyValue
ReorderPoint, smallintTotal values504
 Range747 [3;750]
 Interquartile range675 [75;750]
 Arithmetic mean401.363
 Arithmetic mean absolute deviation235.067
 Median value375
 Median absolute deviation228.101
 Harmonic mean25.0753
 Geometric mean203.706
 Mode value(s)375
 Variance78727.8
 Standard deviation280.585
 Expected value401.363
 Skewness-9.4338
 Kurtosis-1.4363
ColumnPropertyValue
StandardCost, moneyTotal values504
 Range2171.29 [0;2171.29]
 Interquartile range343.65
 Arithmetic mean258.603
 Arithmetic mean absolute deviation326.893
 Median value23.3722
 Median absolute deviation255.891
 Mode value(s).0000
 Variance213105
 Standard deviation461.633
 Expected value258.603
 Skewness1144.55
 Kurtosis4.79448
ColumnPropertyValue
ListPrice, moneyTotal values504
 Range3578.27 [0;3578.27]
 Interquartile range564.99
 Arithmetic mean438.666
 Arithmetic mean absolute deviation545.272
 Median value49.99
 Median absolute deviation432.546
 Mode value(s).0000
 Variance598461
 Standard deviation773.603
 Expected value438.666
 Skewness1161.74
 Kurtosis5.06239
ColumnPropertyValue
Weight, decimalTotal values205
 Range1047.88 [2.12;1050]
 Interquartile range24.54
 Arithmetic mean30.1274
 Arithmetic mean absolute deviation71.9268
 Median value17.9
 Median absolute deviation67.9415
 Harmonic mean5.89892
 Geometric mean14.3639
 Mode value(s)2.30, 2.96, 3.00, 3.04
 Variance35125
 Standard deviation187.417
 Expected value74.0692
 Skewness786.949
 Kurtosis13.7017
ColumnPropertyValue
DaysToManufacture, intTotal values504
 Range4 [0;4]
 Interquartile range1 [0;1]
 Arithmetic mean1.10317
 Arithmetic mean absolute deviation0.873016
 Median value1
 Median absolute deviation1.07937
 Mode value(s)0
 Variance2.2279
 Standard deviation1.49262
 Expected value1.10317
 Skewness611.229
 Kurtosis-0.122065
ColumnPropertyValue
ProductSubcategoryID, intTotal values295
 Range36 [1;37]
 Interquartile range15 [2;17]
 Arithmetic mean7.19643
 Arithmetic mean absolute deviation8.24407
 Median value12
 Median absolute deviation7.81356
 Harmonic mean3.91379
 Geometric mean7.58146
 Mode value(s)2
 Variance123.305
 Standard deviation11.1043
 Expected value12.2949
 Skewness502.967
 Kurtosis0.849904
ColumnPropertyValue
ProductModelID, intTotal values295
 Range127 [1;128]
 Interquartile range39 [11;50]
 Arithmetic mean21.9167
 Arithmetic mean absolute deviation24.1763
 Median value26
 Median absolute deviation24.2102
 Harmonic mean13.9181
 Geometric mean24.2356
 Mode value(s)9, 30
 Variance1399.65
 Standard deviation37.4119
 Expected value37.4441
 Skewness596.128
 Kurtosis1.69449
ColumnPropertyValue
SellStartDate, datetimeTotal values504
 Minimum value1998-06-01
 Arithmetic mean2000-12-00
 Maximum value2003-07-01
 Median2001-07-01
ColumnPropertyValue
SellEndDate, datetimeTotal values98
 Minimum value2002-07-00
 Arithmetic mean2003-03-13
 Maximum value2003-07-00
 Median2003-07-00
ColumnPropertyValue
DiscontinuedDate, datetimeTotal values0
 Minimum value1901-01-00
 Maximum value1901-01-00
ColumnPropertyValue
ModifiedDate, datetimeTotal values504
 Minimum value2004-03-11
 Arithmetic mean2004-03-11
 Maximum value2004-03-11
 Median2004-03-11

Table: Production.ProductCategory

ColumnPropertyValue
ProductCategoryID, int identityTotal values4
 Range3 [1;4]
 Arithmetic mean2.5
 Arithmetic mean absolute deviation0.5
 Median value2.5
 Median absolute deviation0.5
 Harmonic mean1.92
 Geometric mean2.21336
 Mode value(s)1, 2, 3, 4
 Variance1.66667
 Standard deviation1.29099
 Expected value2.5
 Skewness0
 Kurtosis-2.0775
ColumnPropertyValue
ModifiedDate, datetimeTotal values4
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Production.ProductCostHistory

ColumnPropertyValue
ProductID, intTotal values395
 Range292 [707;999]
 Interquartile range153 [749;902]
 Arithmetic mean828.729
 Arithmetic mean absolute deviation74.0861
 Median value814
 Median absolute deviation74.0203
 Harmonic mean819.96
 Geometric mean824.298
 Mode value(s)707, 708, 711, 712, 713, 714, 715, 716, 717, 718...
 Variance7490.22
 Standard deviation86.546
 Expected value828.729
 Skewness136.864
 Kurtosis-1.12223
ColumnPropertyValue
StartDate, datetimeTotal values395
 Minimum value2001-07-01
 Arithmetic mean2002-10-22
 Maximum value2003-07-01
 Median2002-07-01
ColumnPropertyValue
EndDate, datetimeTotal values200
 Minimum value2002-07-00
 Arithmetic mean2003-02-18
 Maximum value2003-07-00
 Median2003-07-00
ColumnPropertyValue
StandardCost, moneyTotal values395
 Range2170.44 [0.8565;2171.29]
 Interquartile range623.793
 Arithmetic mean434.266
 Arithmetic mean absolute deviation383.643
 Median value204.625
 Median absolute deviation360.98
 Harmonic mean30.9826
 Geometric mean161.063
 Mode value(s)413.1463, 486.7066
 Variance247387
 Standard deviation497.38
 Expected value434.266
 Skewness595.9
 Kurtosis1.85649
ColumnPropertyValue
ModifiedDate, datetimeTotal values395
 Minimum value2002-07-00
 Arithmetic mean2003-04-18
 Maximum value2003-07-00
 Median2003-06-17

Table: Production.ProductDescription

ColumnPropertyValue
ProductDescriptionID, int identityTotal values762
 Range2007 [3;2010]
 Interquartile range387 [1429;1816]
 Arithmetic mean1542.58
 Arithmetic mean absolute deviation279.755
 Median value1620.5
 Median absolute deviation271.77
 Harmonic mean511.55
 Geometric mean1432.56
 Mode value(s)3, 4, 5, 8, 64, 88, 128, 168, 170, 209...
 Variance150955
 Standard deviation388.529
 Expected value1542.58
 Skewness-1179.93
 Kurtosis2.48574
ColumnPropertyValue
ModifiedDate, datetimeTotal values762
 Minimum value2003-06-01
 Arithmetic mean2003-07-17
 Maximum value2004-03-11
 Median2003-06-01

Table: Production.ProductDocument

ColumnPropertyValue
ProductID, intTotal values32
 Range682 [317;999]
 Interquartile range421 [517;938]
 Arithmetic mean740.063
 Arithmetic mean absolute deviation232.75
 Median value929.5
 Median absolute deviation209.25
 Harmonic mean642.923
 Geometric mean693.817
 Mode value(s)506
 Variance60422.4
 Standard deviation245.81
 Expected value740.063
 Skewness-12.2515
 Kurtosis-1.63389
ColumnPropertyValue
DocumentID, intTotal values32
 Range7 [1;8]
 Interquartile range7 [1;8]
 Arithmetic mean4.21875
 Arithmetic mean absolute deviation1.875
 Median value4
 Median absolute deviation2.28125
 Harmonic mean2.20563
 Geometric mean3.14328
 Mode value(s)1
 Variance7.78931
 Standard deviation2.79093
 Expected value4.21875
 Skewness6.54115
 Kurtosis-1.48514
ColumnPropertyValue
ModifiedDate, datetimeTotal values32
 Minimum value2004-01-30
 Arithmetic mean2004-01-30
 Maximum value2004-01-30
 Median2004-01-30

Table: Production.ProductInventory

ColumnPropertyValue
ProductID, intTotal values1069
 Range998 [1;999]
 Interquartile range413 [411;824]
 Arithmetic mean611.963
 Arithmetic mean absolute deviation221.319
 Median value506
 Median absolute deviation209.601
 Harmonic mean130.097
 Geometric mean541.354
 Mode value(s)747, 748, 814, 822, 942, 943, 944
 Variance57301.4
 Standard deviation239.377
 Expected value611.963
 Skewness181.575
 Kurtosis-1.23728
ColumnPropertyValue
LocationID, smallintTotal values1069
 Range59 [1;60]
 Interquartile range44 [6;50]
 Arithmetic mean23.6848
 Arithmetic mean absolute deviation21.8718
 Median value7
 Median absolute deviation19.304
 Harmonic mean4.19737
 Geometric mean10.8663
 Mode value(s)50
 Variance553.418
 Standard deviation23.5248
 Expected value23.6848
 Skewness535.973
 Kurtosis-1.61149
ColumnPropertyValue
Bin, tinyintTotal values1069
 Range61 [0;61]
 Interquartile range13 [0;13]
 Arithmetic mean8.89991
 Arithmetic mean absolute deviation7.87839
 Median value5
 Median absolute deviation7.87558
 Mode value(s)0
 Variance128.212
 Standard deviation11.3231
 Expected value8.89991
 Skewness1899.55
 Kurtosis3.27816
ColumnPropertyValue
Quantity, smallintTotal values1069
 Range924 [0;924]
 Interquartile range341 [140;481]
 Arithmetic mean314.288
 Arithmetic mean absolute deviation158.793
 Median value299
 Median absolute deviation158.832
 Mode value(s)99
 Variance36043.2
 Standard deviation189.851
 Expected value314.288
 Skewness324.27
 Kurtosis-0.887232
ColumnPropertyValue
ModifiedDate, datetimeTotal values1069
 Minimum value1998-05-02
 Arithmetic mean2003-06-27
 Maximum value2004-09-12
 Median2004-09-00

Table: Production.ProductListPriceHistory

ColumnPropertyValue
ProductID, intTotal values395
 Range292 [707;999]
 Interquartile range153 [749;902]
 Arithmetic mean828.729
 Arithmetic mean absolute deviation74.0861
 Median value814
 Median absolute deviation74.0203
 Harmonic mean819.96
 Geometric mean824.298
 Mode value(s)707, 708, 711, 712, 713, 714, 715, 716, 717, 718...
 Variance7490.22
 Standard deviation86.546
 Expected value828.729
 Skewness136.864
 Kurtosis-1.12223
ColumnPropertyValue
StartDate, datetimeTotal values395
 Minimum value2001-07-01
 Arithmetic mean2002-10-22
 Maximum value2003-07-01
 Median2002-07-01
ColumnPropertyValue
EndDate, datetimeTotal values200
 Minimum value2002-07-00
 Arithmetic mean2003-02-18
 Maximum value2003-07-00
 Median2003-07-00
ColumnPropertyValue
ListPrice, moneyTotal values395
 Range3575.98 [2.29;3578.27]
 Interquartile range1144.86
 Arithmetic mean747.662
 Arithmetic mean absolute deviation647.651
 Median value364.09
 Median absolute deviation608.873
 Harmonic mean73.3194
 Geometric mean305.527
 Mode value(s)306.5636, 337.2200, 699.0982, 782.9900
 Variance703432
 Standard deviation838.708
 Expected value747.662
 Skewness593.579
 Kurtosis1.86686
ColumnPropertyValue
ModifiedDate, datetimeTotal values395
 Minimum value2002-07-00
 Arithmetic mean2003-04-14
 Maximum value2003-07-00
 Median2003-06-10

Table: Production.ProductModel

ColumnPropertyValue
ProductModelID, int identityTotal values128
 Range127 [1;128]
 Interquartile range64 [33;97]
 Arithmetic mean64.5
 Arithmetic mean absolute deviation31.5
 Median value64.5
 Median absolute deviation31.5
 Harmonic mean23.5591
 Geometric mean48.3356
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance1376
 Standard deviation37.0945
 Expected value64.5
 Skewness0
 Kurtosis-1.22816
ColumnPropertyValue
ModifiedDate, datetimeTotal values128
 Minimum value1998-05-02
 Arithmetic mean2002-12-15
 Maximum value2005-05-16
 Median2003-02-24

Table: Production.ProductModelIllustration

ColumnPropertyValue
ProductModelID, intTotal values7
 Range60 [7;67]
 Interquartile range57 [10;67]
 Arithmetic mean39.1429
 Arithmetic mean absolute deviation16.8571
 Median value47
 Median absolute deviation14.1429
 Harmonic mean20.4677
 Geometric mean30.3774
 Mode value(s)47, 48
 Variance489.81
 Standard deviation22.1316
 Expected value39.1429
 Skewness-3.13484
 Kurtosis-1.56443
ColumnPropertyValue
IllustrationID, intTotal values7
 Range3 [3;6]
 Interquartile range3 [3;6]
 Arithmetic mean4.28571
 Arithmetic mean absolute deviation0.428571
 Median value4
 Median absolute deviation0.857143
 Harmonic mean4.03846
 Geometric mean4.1611
 Mode value(s)3, 4, 5
 Variance1.2381
 Standard deviation1.1127
 Expected value4.28571
 Skewness1.06661
 Kurtosis-1.63603
ColumnPropertyValue
ModifiedDate, datetimeTotal values7
 Minimum value2004-02-10
 Arithmetic mean2004-02-10
 Maximum value2004-02-10
 Median2004-02-10

Table: Production.ProductModelProductDescriptionCulture

ColumnPropertyValue
ProductModelID, intTotal values762
 Range126 [1;127]
 Interquartile range64 [32;96]
 Arithmetic mean64
 Arithmetic mean absolute deviation31.748
 Median value64
 Median absolute deviation31.748
 Harmonic mean23.4087
 Geometric mean47.9663
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance1345.77
 Standard deviation36.6847
 Expected value64
 Skewness0
 Kurtosis-1.20487
ColumnPropertyValue
ProductDescriptionID, intTotal values762
 Range2007 [3;2010]
 Interquartile range387 [1429;1816]
 Arithmetic mean1542.58
 Arithmetic mean absolute deviation279.755
 Median value1620.5
 Median absolute deviation271.77
 Harmonic mean511.55
 Geometric mean1432.56
 Mode value(s)1199, 1467, 1589, 1712, 1838, 1965, 1210, 1476, 1598, 1721...
 Variance150955
 Standard deviation388.529
 Expected value1542.58
 Skewness-1179.93
 Kurtosis2.48574
ColumnPropertyValue
ModifiedDate, datetimeTotal values762
 Minimum value2003-06-01
 Arithmetic mean2003-06-01
 Maximum value2003-06-01
 Median2003-06-01

Table: Production.ProductPhoto

ColumnPropertyValue
ProductPhotoID, int identityTotal values101
 Range180 [1;181]
 Interquartile range58 [98;156]
 Arithmetic mean125.772
 Arithmetic mean absolute deviation28.802
 Median value128
 Median absolute deviation29.2376
 Harmonic mean54.6709
 Geometric mean116.891
 Mode value(s)1, 69, 70, 72, 73, 76, 77, 78, 79, 80...
 Variance1217.84
 Standard deviation34.8975
 Expected value125.772
 Skewness-42.3375
 Kurtosis-0.0420847
ColumnPropertyValue
ModifiedDate, datetimeTotal values101
 Minimum value1998-05-02
 Arithmetic mean2002-07-21
 Maximum value2003-06-01
 Median2002-11-20

Table: Production.ProductProductPhoto

ColumnPropertyValue
ProductID, intTotal values504
 Range998 [1;999]
 Interquartile range426 [448;874]
 Arithmetic mean673.04
 Arithmetic mean absolute deviation208.841
 Median value747.5
 Median absolute deviation199.96
 Harmonic mean172.47
 Geometric mean609.963
 Mode value(s)1, 2, 3, 4, 316, 317, 318, 319, 320, 321...
 Variance52612
 Standard deviation229.373
 Expected value673.04
 Skewness-162.542
 Kurtosis-1.15054
ColumnPropertyValue
ProductPhotoID, intTotal values504
 Range178 [1;179]
 Interquartile range98 [1;99]
 Arithmetic mean41.6706
 Arithmetic mean absolute deviation55.2778
 Median value1
 Median absolute deviation40.6706
 Harmonic mean1.45126
 Geometric mean4.56505
 Mode value(s)1
 Variance3920.58
 Standard deviation62.6146
 Expected value41.6706
 Skewness515.73
 Kurtosis-0.701555
ColumnPropertyValue
ModifiedDate, datetimeTotal values504
 Minimum value1998-05-02
 Arithmetic mean2000-11-00
 Maximum value2003-06-01
 Median2001-06-01

Table: Production.ProductReview

ColumnPropertyValue
ProductReviewID, int identityTotal values4
 Range3 [1;4]
 Arithmetic mean2.5
 Arithmetic mean absolute deviation0.5
 Median value2.5
 Median absolute deviation0.5
 Harmonic mean1.92
 Geometric mean2.21336
 Mode value(s)1, 2, 3, 4
 Variance1.66667
 Standard deviation1.29099
 Expected value2.5
 Skewness0
 Kurtosis-2.0775
ColumnPropertyValue
ProductID, intTotal values4
 Range228 [709;937]
 Arithmetic mean845.25
 Arithmetic mean absolute deviation91.25
 Median value867.5
 Median absolute deviation91.25
 Harmonic mean833.673
 Geometric mean839.522
 Mode value(s)937
 Variance12544.3
 Standard deviation112.001
 Expected value845.25
 Skewness-0.775908
 Kurtosis-2.2194
ColumnPropertyValue
ReviewDate, datetimeTotal values4
 Minimum value2003-10-20
 Arithmetic mean2003-12-02
 Maximum value2003-12-17
 Median2003-12-16
ColumnPropertyValue
Rating, intTotal values4
 Range3 [2;5]
 Arithmetic mean4
 Arithmetic mean absolute deviation1
 Median value4.5
 Median absolute deviation0.5
 Harmonic mean3.47826
 Geometric mean3.7606
 Mode value(s)5
 Variance2
 Standard deviation1.41421
 Expected value4
 Skewness-2.12132
 Kurtosis-1.875
ColumnPropertyValue
ModifiedDate, datetimeTotal values4
 Minimum value2003-10-20
 Arithmetic mean2003-12-02
 Maximum value2003-12-17
 Median2003-12-16

Table: Production.ProductSubcategory

ColumnPropertyValue
ProductSubcategoryID, int identityTotal values37
 Range36 [1;37]
 Interquartile range19 [10;29]
 Arithmetic mean19
 Arithmetic mean absolute deviation9.24324
 Median value19
 Median absolute deviation9.24324
 Harmonic mean8.8062
 Geometric mean14.6525
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance117.167
 Standard deviation10.8244
 Expected value19
 Skewness0
 Kurtosis-1.29764
ColumnPropertyValue
ProductCategoryID, intTotal values37
 Range3 [1;4]
 Interquartile range2 [2;4]
 Arithmetic mean2.78378
 Arithmetic mean absolute deviation0.405405
 Median value3
 Median absolute deviation0.864865
 Harmonic mean2.3617
 Geometric mean2.58421
 Mode value(s)2
 Variance1.00751
 Standard deviation1.00375
 Expected value2.78378
 Skewness-2.07592
 Kurtosis-1.35107
ColumnPropertyValue
ModifiedDate, datetimeTotal values37
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Production.ScrapReason

ColumnPropertyValue
ScrapReasonID, smallint identityTotal values16
 Range15 [1;16]
 Interquartile range8 [5;13]
 Arithmetic mean8.5
 Arithmetic mean absolute deviation3.5
 Median value8.5
 Median absolute deviation3.5
 Harmonic mean4.73271
 Geometric mean6.80047
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance22.6667
 Standard deviation4.76095
 Expected value8.5
 Skewness0
 Kurtosis-1.42624
ColumnPropertyValue
ModifiedDate, datetimeTotal values16
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Production.TransactionHistory

ColumnPropertyValue
TransactionID, int identityTotal values113443
 Range113442 [100000;213442]
 Interquartile range56723 [128360;185083]
 Arithmetic mean156721
 Arithmetic mean absolute deviation28360.7
 Median value156721
 Median absolute deviation28360.7
 Harmonic mean149621
 Geometric mean153196
 Mode value(s)100000, 100001, 100002, 100003, 100004, 100005, 100006, 100007, 100008, 100009...
 Variance1.07245e+009
 Standard deviation32748.3
 Expected value156721
 Skewness-4.66929e-010
 Kurtosis-1.20003
ColumnPropertyValue
ProductID, intTotal values113443
 Range998 [1;999]
 Interquartile range181 [748;929]
 Arithmetic mean813.318
 Arithmetic mean absolute deviation125.404
 Median value871
 Median absolute deviation115.278
 Harmonic mean344.594
 Geometric mean776.491
 Mode value(s)870
 Variance29559.6
 Standard deviation171.929
 Expected value813.318
 Skewness-192556
 Kurtosis2.7912
ColumnPropertyValue
ReferenceOrderID, intTotal values113443
 Range74706 [417;75123]
 Interquartile range12669 [54994;67663]
 Arithmetic mean57587.8
 Arithmetic mean absolute deviation10630.9
 Median value61188
 Median absolute deviation10153.7
 Harmonic mean16754.1
 Geometric mean48088.2
 Mode value(s)53465
 Variance2.85366e+008
 Standard deviation16892.8
 Expected value57587.8
 Skewness-263640
 Kurtosis5.18376
ColumnPropertyValue
ReferenceOrderLineID, intTotal values113443
 Range71 [0;71]
 Interquartile range3 [0;3]
 Arithmetic mean4.67129
 Arithmetic mean absolute deviation4.89439
 Median value2
 Median absolute deviation4.20972
 Mode value(s)0
 Variance78.1519
 Standard deviation8.84035
 Expected value4.67129
 Skewness335130
 Kurtosis9.11342
ColumnPropertyValue
TransactionDate, datetimeTotal values113443
 Minimum value2003-09-01
 Arithmetic mean2004-02-07
 Maximum value2004-09-03
 Median2004-02-08
ColumnPropertyValue
Quantity, intTotal values113443
 Range39269 [1;39270]
 Interquartile range3 [1;4]
 Arithmetic mean35.0591
 Arithmetic mean absolute deviation59.2319
 Median value1
 Median absolute deviation34.0591
 Harmonic mean1.48411
 Geometric mean2.49459
 Mode value(s)1
 Variance141813
 Standard deviation376.581
 Expected value35.0591
 Skewness6.41925e+006
 Kurtosis4357.21
ColumnPropertyValue
ActualCost, moneyTotal values113443
 Range2443.35 [0;2443.35]
 Interquartile range53.99
 Arithmetic mean240.714
 Arithmetic mean absolute deviation356.441
 Median value21.49
 Median absolute deviation236.912
 Mode value(s).0000
 Variance305893
 Standard deviation553.076
 Expected value240.714
 Skewness306478
 Kurtosis6.41419
ColumnPropertyValue
ModifiedDate, datetimeTotal values113443
 Minimum value2003-09-01
 Arithmetic mean2004-02-07
 Maximum value2004-09-03
 Median2004-02-08

Table: Production.TransactionHistoryArchive

ColumnPropertyValue
TransactionID, intTotal values89253
 Range89252 [1;89253]
 Interquartile range44627 [22314;66941]
 Arithmetic mean44627
 Arithmetic mean absolute deviation22313.2
 Median value44627
 Median absolute deviation22313.2
 Harmonic mean7452.37
 Geometric mean32836.8
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance6.63849e+008
 Standard deviation25765.3
 Expected value44627
 Skewness-8.29122e-009
 Kurtosis-1.20004
ColumnPropertyValue
ProductID, intTotal values89253
 Range998 [1;999]
 Interquartile range108 [717;825]
 Arithmetic mean734.889
 Arithmetic mean absolute deviation122.21
 Median value779
 Median absolute deviation113.327
 Harmonic mean222.774
 Geometric mean683.674
 Mode value(s)712
 Variance30822.9
 Standard deviation175.565
 Expected value734.889
 Skewness-134838
 Kurtosis2.44768
ColumnPropertyValue
ReferenceOrderID, intTotal values89253
 Range53448 [1;53449]
 Interquartile range27263 [21392;48655]
 Arithmetic mean35121.2
 Arithmetic mean absolute deviation14540.8
 Median value44217
 Median absolute deviation13655.3
 Harmonic mean3498.46
 Geometric mean26685.8
 Mode value(s)51721, 51739
 Variance2.7341e+008
 Standard deviation16535.1
 Expected value35121.2
 Skewness-64891.9
 Kurtosis-0.913542
ColumnPropertyValue
ReferenceOrderLineID, intTotal values89253
 Range72 [0;72]
 Interquartile range9 [0;9]
 Arithmetic mean6.77298
 Arithmetic mean absolute deviation7.88767
 Median value1
 Median absolute deviation6.70492
 Mode value(s)0
 Variance131.79
 Standard deviation11.48
 Expected value6.77298
 Skewness182589
 Kurtosis3.80655
ColumnPropertyValue
TransactionDate, datetimeTotal values89253
 Minimum value2001-05-17
 Arithmetic mean2002-10-17
 Maximum value2003-09-00
 Median2002-11-01
ColumnPropertyValue
Quantity, intTotal values89253
 Range39569 [1;39570]
 Interquartile range5 [1;6]
 Arithmetic mean34.26
 Arithmetic mean absolute deviation57.0965
 Median value3
 Median absolute deviation32.9304
 Harmonic mean1.96476
 Geometric mean3.18827
 Mode value(s)1
 Variance215740
 Standard deviation464.479
 Expected value34.26
 Skewness3.55577e+006
 Kurtosis2174.37
ColumnPropertyValue
ActualCost, moneyTotal values89253
 Range3578.27 [0;3578.27]
 Interquartile range503.351
 Arithmetic mean396.624
 Arithmetic mean absolute deviation536.134
 Median value8.99
 Median absolute deviation395.594
 Mode value(s).0000
 Variance598597
 Standard deviation773.69
 Expected value396.624
 Skewness214570
 Kurtosis5.41406
ColumnPropertyValue
ModifiedDate, datetimeTotal values89253
 Minimum value2001-05-17
 Arithmetic mean2002-10-17
 Maximum value2003-09-00
 Median2002-11-01

Table: Production.UnitMeasure

ColumnPropertyValue
ModifiedDate, datetimeTotal values38
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Production.WorkOrder

ColumnPropertyValue
WorkOrderID, int identityTotal values72591
 Range72590 [1;72591]
 Interquartile range36297 [18148;54445]
 Arithmetic mean36296
 Arithmetic mean absolute deviation18147.7
 Median value36296
 Median absolute deviation18147.7
 Harmonic mean6167.55
 Geometric mean26707.1
 Mode value(s)5561, 5562, 5563, 5564, 5565, 5566, 5567, 5568, 5569, 5570...
 Variance4.39127e+008
 Standard deviation20955.4
 Expected value36296
 Skewness4.0806e-010
 Kurtosis-1.20005
ColumnPropertyValue
ProductID, intTotal values72591
 Range996 [3;999]
 Interquartile range299 [529;828]
 Arithmetic mean704.328
 Arithmetic mean absolute deviation185.541
 Median value794
 Median absolute deviation169.036
 Harmonic mean152.186
 Geometric mean625.054
 Mode value(s)945
 Variance49655.1
 Standard deviation222.834
 Expected value704.328
 Skewness-61920
 Kurtosis-0.0146692
ColumnPropertyValue
OrderQty, intTotal values72591
 Range39569 [1;39570]
 Interquartile range11 [1;12]
 Arithmetic mean62.0975
 Arithmetic mean absolute deviation101.645
 Median value4
 Median absolute deviation60.4543
 Harmonic mean2.34154
 Geometric mean4.88229
 Mode value(s)1
 Variance468515
 Standard deviation684.482
 Expected value62.0975
 Skewness2.16917e+006
 Kurtosis1184.12
ColumnPropertyValue
StockedQty, intTotal values72591
 Range39569 [1;39570]
 Interquartile range11 [1;12]
 Arithmetic mean61.9508
 Arithmetic mean absolute deviation100.625
 Median value4
 Median absolute deviation60.3075
 Harmonic mean2.34152
 Geometric mean4.88113
 Mode value(s)1
 Variance466917
 Standard deviation683.313
 Expected value61.9508
 Skewness2.17436e+006
 Kurtosis1189.78
ColumnPropertyValue
ScrappedQty, smallintTotal values72591
 Range673 [0;673]
 Interquartile range0 [0;0]
 Arithmetic mean0.146726
 Arithmetic mean absolute deviation0.136684
 Median value0
 Median absolute deviation0.146726
 Mode value(s)0
 Variance23.1048
 Standard deviation4.80674
 Expected value0.146726
 Skewness4.93949e+006
 Kurtosis6764.4
ColumnPropertyValue
StartDate, datetimeTotal values72591
 Minimum value2001-07-04
 Arithmetic mean2003-04-19
 Maximum value2004-07-03
 Median2003-06-29
ColumnPropertyValue
EndDate, datetimeTotal values72591
 Minimum value2001-07-14
 Arithmetic mean2003-05-02
 Maximum value2004-07-18
 Median2003-07-12
ColumnPropertyValue
DueDate, datetimeTotal values72591
 Minimum value2001-07-15
 Arithmetic mean2003-05-00
 Maximum value2004-07-14
 Median2003-07-10
ColumnPropertyValue
ScrapReasonID, smallintTotal values729
 Range15 [1;16]
 Interquartile range9 [4;13]
 Arithmetic mean0.0876142
 Arithmetic mean absolute deviation7.72428
 Median value9
 Median absolute deviation4.14129
 Harmonic mean4.80046
 Geometric mean6.94824
 Mode value(s)13
 Variance97.1279
 Standard deviation9.85535
 Expected value8.72428
 Skewness926.719
 Kurtosis-1.2856
ColumnPropertyValue
ModifiedDate, datetimeTotal values72591
 Minimum value2001-07-14
 Arithmetic mean2003-05-02
 Maximum value2004-07-18
 Median2003-07-12

Table: Production.WorkOrderRouting

ColumnPropertyValue
WorkOrderID, intTotal values67131
 Range72574 [13;72587]
 Interquartile range34547 [21428;55975]
 Arithmetic mean38394.3
 Arithmetic mean absolute deviation17575.5
 Median value39353
 Median absolute deviation17562.3
 Harmonic mean8538.47
 Geometric mean29447.3
 Mode value(s)13, 14, 65, 66, 117, 863, 1099, 1182, 1275, 1276...
 Variance4.18473e+008
 Standard deviation20456.6
 Expected value38394.3
 Skewness-8230.32
 Kurtosis-1.12741
ColumnPropertyValue
ProductID, intTotal values67131
 Range485 [514;999]
 Interquartile range59 [769;828]
 Arithmetic mean798.93
 Arithmetic mean absolute deviation88.9964
 Median value810
 Median absolute deviation87.0423
 Harmonic mean772.093
 Geometric mean786.421
 Mode value(s)813
 Variance17473.1
 Standard deviation132.186
 Expected value798.93
 Skewness-56458.1
 Kurtosis0.376545
ColumnPropertyValue
OperationSequence, smallintTotal values67131
 Range6 [1;7]
 Interquartile range4 [3;7]
 Arithmetic mean5.10996
 Arithmetic mean absolute deviation1.16767
 Median value6
 Median absolute deviation1.44281
 Harmonic mean3.19179
 Geometric mean4.30571
 Mode value(s)6
 Variance4.71721
 Standard deviation2.17191
 Expected value5.10996
 Skewness-69393.4
 Kurtosis-0.609941
ColumnPropertyValue
LocationID, smallintTotal values67131
 Range50 [10;60]
 Interquartile range30 [30;60]
 Arithmetic mean43.8008
 Arithmetic mean absolute deviation14.1803
 Median value50
 Median absolute deviation11.7269
 Harmonic mean29.8457
 Geometric mean37.9814
 Mode value(s)50
 Variance306.985
 Standard deviation17.521
 Expected value43.8008
 Skewness-68274
 Kurtosis-0.508106
ColumnPropertyValue
ScheduledStartDate, datetimeTotal values67131
 Minimum value2001-07-04
 Arithmetic mean2003-05-22
 Maximum value2004-07-03
 Median2003-08-04
ColumnPropertyValue
ScheduledEndDate, datetimeTotal values67131
 Minimum value2001-07-15
 Arithmetic mean2003-06-02
 Maximum value2004-07-14
 Median2003-08-15
ColumnPropertyValue
ActualStartDate, datetimeTotal values67131
 Minimum value2001-07-04
 Arithmetic mean2003-05-26
 Maximum value2004-07-18
 Median2003-08-10
ColumnPropertyValue
ActualEndDate, datetimeTotal values67131
 Minimum value2001-07-16
 Arithmetic mean2003-06-07
 Maximum value2004-07-29
 Median2003-08-20
ColumnPropertyValue
ActualResourceHrs, decimalTotal values67131
 Range3.1 [1;4.1]
 Interquartile range1
 Arithmetic mean3.41068
 Arithmetic mean absolute deviation0.0665862
 Median value3.5
 Median absolute deviation0.0665862
 Harmonic mean3.20666
 Geometric mean3.32962
 Mode value(s)3.0000
 Variance0.41321
 Standard deviation0.642814
 Expected value3.41068
 Skewness-76074.7
 Kurtosis2.36338
ColumnPropertyValue
PlannedCost, moneyTotal values67131
 Range77.75 [14.5;92.25]
 Interquartile range12.25
 Arithmetic mean51.9577
 Arithmetic mean absolute deviation17.2835
 Median value49
 Median absolute deviation15.9544
 Harmonic mean44.2619
 Geometric mean47.8768
 Mode value(s)36.7500
 Variance487.755
 Standard deviation22.0852
 Expected value51.9577
 Skewness64735.9
 Kurtosis-0.533056
ColumnPropertyValue
ActualCost, moneyTotal values67131
 Range77.75 [14.5;92.25]
 Interquartile range12.25
 Arithmetic mean51.9577
 Arithmetic mean absolute deviation17.2835
 Median value49
 Median absolute deviation15.9544
 Harmonic mean44.2619
 Geometric mean47.8768
 Mode value(s)36.7500
 Variance487.755
 Standard deviation22.0852
 Expected value51.9577
 Skewness64735.9
 Kurtosis-0.533056
ColumnPropertyValue
ModifiedDate, datetimeTotal values67131
 Minimum value2001-07-16
 Arithmetic mean2003-06-07
 Maximum value2004-07-29
 Median2003-08-20

Table: Purchasing.ProductVendor

ColumnPropertyValue
ProductID, intTotal values460
 Range951 [1;952]
 Interquartile range140 [383;523]
 Arithmetic mean517.248
 Arithmetic mean absolute deviation162.85
 Median value434.5
 Median absolute deviation138.439
 Harmonic mean168.317
 Geometric mean471.915
 Mode value(s)319, 320, 321, 322, 341, 342, 343, 344, 345, 346...
 Variance42065.9
 Standard deviation205.1
 Expected value517.248
 Skewness481.564
 Kurtosis-0.14331
ColumnPropertyValue
VendorID, intTotal values460
 Range103 [1;104]
 Interquartile range52 [25;77]
 Arithmetic mean51.3565
 Arithmetic mean absolute deviation25.1174
 Median value51
 Median absolute deviation25.6087
 Harmonic mean23.0214
 Geometric mean39.0049
 Mode value(s)7
 Variance868.151
 Standard deviation29.4644
 Expected value51.3565
 Skewness-17.2248
 Kurtosis-1.25794
ColumnPropertyValue
AverageLeadTime, intTotal values460
 Range110 [10;120]
 Interquartile range3 [16;19]
 Arithmetic mean19.45
 Arithmetic mean absolute deviation4.13261
 Median value17
 Median absolute deviation3.64565
 Harmonic mean17.7572
 Geometric mean18.3585
 Mode value(s)17
 Variance86.2916
 Standard deviation9.28933
 Expected value19.45
 Skewness2255.7
 Kurtosis34.8333
ColumnPropertyValue
StandardPrice, moneyTotal values460
 Range78.69 [0.2;78.89]
 Interquartile range12.05
 Arithmetic mean34.6765
 Arithmetic mean absolute deviation9.67826
 Median value39.26
 Median absolute deviation8.85435
 Harmonic mean13.3476
 Geometric mean29.056
 Mode value(s)39.2100, 37.2100, 41.2100
 Variance182.3
 Standard deviation13.5018
 Expected value34.6765
 Skewness-445.596
 Kurtosis0.671644
ColumnPropertyValue
LastReceiptCost, moneyTotal values460
 Range82.6245 [0.21;82.8345]
 Interquartile range13.9335
 Arithmetic mean36.2759
 Arithmetic mean absolute deviation10.3674
 Median value41.1967
 Median absolute deviation9.42609
 Harmonic mean13.8515
 Geometric mean30.292
 Mode value(s)41.1705, 39.0705, 43.2705
 Variance202.978
 Standard deviation14.247
 Expected value36.2759
 Skewness-438.194
 Kurtosis0.631039
ColumnPropertyValue
LastReceiptDate, datetimeTotal values460
 Minimum value2001-08-22
 Arithmetic mean2002-01-10
 Maximum value2004-11-22
 Median2001-09-22
ColumnPropertyValue
MinOrderQty, intTotal values460
 Range4999 [1;5000]
 Interquartile range99 [1;100]
 Arithmetic mean145.909
 Arithmetic mean absolute deviation214.617
 Median value1
 Median absolute deviation144.909
 Harmonic mean1.59858
 Geometric mean6.27504
 Mode value(s)1
 Variance400171
 Standard deviation632.59
 Expected value145.909
 Skewness3206.36
 Kurtosis49.9431
ColumnPropertyValue
MaxOrderQty, intTotal values460
 Range14995 [5;15000]
 Interquartile range995 [5;1000]
 Arithmetic mean776.467
 Arithmetic mean absolute deviation1037.98
 Median value5
 Median absolute deviation771.467
 Harmonic mean8.02035
 Geometric mean37.6175
 Mode value(s)5
 Variance4.33389e+006
 Standard deviation2081.8
 Expected value776.467
 Skewness1955.21
 Kurtosis19.787
ColumnPropertyValue
OnOrderQty, intTotal values155
 Range7997 [3;8000]
 Interquartile range297 [3;300]
 Arithmetic mean222.639
 Arithmetic mean absolute deviation645.652
 Median value150
 Median absolute deviation643.2
 Harmonic mean7.23413
 Geometric mean58.1258
 Mode value(s)3
 Variance2.64937e+006
 Standard deviation1627.69
 Expected value660.735
 Skewness587.999
 Kurtosis12.657
ColumnPropertyValue
ModifiedDate, datetimeTotal values460
 Minimum value2001-08-22
 Arithmetic mean2002-03-07
 Maximum value2005-09-12
 Median2001-09-22

Table: Purchasing.PurchaseOrderDetail

ColumnPropertyValue
PurchaseOrderID, intTotal values8845
 Range4011 [1;4012]
 Interquartile range2011 [994;3005]
 Arithmetic mean1992.32
 Arithmetic mean absolute deviation1008.18
 Median value1978
 Median absolute deviation1008.62
 Harmonic mean481.268
 Geometric mean1458.32
 Mode value(s)1015
 Variance1.35262e+006
 Standard deviation1163.02
 Expected value1992.32
 Skewness193.147
 Kurtosis-1.20453
ColumnPropertyValue
PurchaseOrderDetailID, int identityTotal values8845
 Range8844 [1;8845]
 Interquartile range4423 [2212;6635]
 Arithmetic mean4423
 Arithmetic mean absolute deviation2211.25
 Median value4423
 Median absolute deviation2211.25
 Harmonic mean915.169
 Geometric mean3255.9
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance6.52024e+006
 Standard deviation2553.48
 Expected value4423
 Skewness0
 Kurtosis-1.20041
ColumnPropertyValue
DueDate, datetimeTotal values8845
 Minimum value2001-06-00
 Arithmetic mean2004-02-07
 Maximum value2004-11-22
 Median2004-03-29
ColumnPropertyValue
OrderQty, smallintTotal values8845
 Range7997 [3;8000]
 Interquartile range547 [3;550]
 Arithmetic mean265.533
 Arithmetic mean absolute deviation282.271
 Median value60
 Median absolute deviation258.869
 Harmonic mean6.32129
 Geometric mean39.8569
 Mode value(s)3
 Variance126684
 Standard deviation355.927
 Expected value265.533
 Skewness57391.6
 Kurtosis114.969
ColumnPropertyValue
ProductID, intTotal values8845
 Range951 [1;952]
 Interquartile range160 [367;527]
 Arithmetic mean527.508
 Arithmetic mean absolute deviation177.813
 Median value456
 Median absolute deviation163.515
 Harmonic mean82.4808
 Geometric mean454.272
 Mode value(s)319
 Variance52007.1
 Standard deviation228.051
 Expected value527.508
 Skewness7038.82
 Kurtosis-0.319387
ColumnPropertyValue
UnitPrice, moneyTotal values8845
 Range82.6245 [0.21;82.8345]
 Interquartile range20.0235
 Arithmetic mean34.743
 Arithmetic mean absolute deviation12.5548
 Median value39.2805
 Median absolute deviation11.8471
 Harmonic mean8.93068
 Geometric mean27.0475
 Mode value(s)31.4895, 48.2895
 Variance266.194
 Standard deviation16.3154
 Expected value34.743
 Skewness-3755.29
 Kurtosis0.0328029
ColumnPropertyValue
LineTotal, moneyTotal values8845
 Range249383 [37.0755;249420]
 Interquartile range14752
 Arithmetic mean7212.21
 Arithmetic mean absolute deviation8578.6
 Median value262.5
 Median absolute deviation7077.8
 Harmonic mean238.514
 Geometric mean1078.03
 Mode value(s)17319.2250, 26559.2250
 Variance1.33236e+008
 Standard deviation11542.8
 Expected value7212.21
 Skewness48449.6
 Kurtosis90.8419
ColumnPropertyValue
ReceivedQty, decimalTotal values8845
 Range7998 [2;8000]
 Interquartile range547
 Arithmetic mean263.12
 Arithmetic mean absolute deviation279.759
 Median value60
 Median absolute deviation256.546
 Harmonic mean6.31902
 Geometric mean39.6367
 Mode value(s)3.00
 Variance125345
 Standard deviation354.041
 Expected value263.12
 Skewness58338.1
 Kurtosis117.645
ColumnPropertyValue
RejectedQty, decimalTotal values8845
 Range1250 [0;1250]
 Interquartile range0
 Arithmetic mean8.21933
 Arithmetic mean absolute deviation15.2207
 Median value0
 Median absolute deviation8.21933
 Mode value(s).00
 Variance3400.71
 Standard deviation58.3156
 Expected value8.21933
 Skewness98582.6
 Kurtosis152.427
ColumnPropertyValue
StockedQty, decimalTotal values8845
 Range8000 [0;8000]
 Interquartile range547
 Arithmetic mean254.901
 Arithmetic mean absolute deviation275.308
 Median value60
 Median absolute deviation249.726
 Mode value(s)3.00
 Variance123190
 Standard deviation350.984
 Expected value254.901
 Skewness60145.2
 Kurtosis122.466
ColumnPropertyValue
ModifiedDate, datetimeTotal values8845
 Minimum value2001-05-24
 Arithmetic mean2004-02-03
 Maximum value2005-09-12
 Median2004-03-23

Table: Purchasing.PurchaseOrderHeader

ColumnPropertyValue
PurchaseOrderID, int identityTotal values4012
 Range4011 [1;4012]
 Interquartile range2006 [1004;3010]
 Arithmetic mean2006.5
 Arithmetic mean absolute deviation1002.5
 Median value2006.5
 Median absolute deviation1002.5
 Harmonic mean452.088
 Geometric mean1477.8
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance1.34168e+006
 Standard deviation1158.31
 Expected value2006.5
 Skewness0
 Kurtosis-1.2009
ColumnPropertyValue
RevisionNumber, tinyintTotal values4012
 Range16 [0;16]
 Interquartile range0 [0;0]
 Arithmetic mean0.083001
 Arithmetic mean absolute deviation0.0333998
 Median value0
 Median absolute deviation0.083001
 Mode value(s)0
 Variance0.252645
 Standard deviation0.502638
 Expected value0.083001
 Skewness56228.2
 Kurtosis324.299
ColumnPropertyValue
Status, tinyintTotal values4012
 Range3 [1;4]
 Interquartile range0 [4;4]
 Arithmetic mean3.80434
 Arithmetic mean absolute deviation0.115155
 Median value4
 Median absolute deviation0.195663
 Harmonic mean3.39449
 Geometric mean3.67043
 Mode value(s)4
 Variance0.499976
 Standard deviation0.70709
 Expected value3.80434
 Skewness-14284
 Kurtosis11.0434
ColumnPropertyValue
EmployeeID, intTotal values4012
 Range110 [164;274]
 Interquartile range30 [231;261]
 Arithmetic mean236.584
 Arithmetic mean absolute deviation20.091
 Median value238
 Median absolute deviation20.3225
 Harmonic mean232.345
 Geometric mean234.6
 Mode value(s)266
 Variance827.988
 Standard deviation28.7748
 Expected value236.584
 Skewness-4914.18
 Kurtosis1.12472
ColumnPropertyValue
VendorID, intTotal values4012
 Range103 [1;104]
 Interquartile range49 [27;76]
 Arithmetic mean51.4544
 Arithmetic mean absolute deviation24.2091
 Median value52
 Median absolute deviation24.7041
 Harmonic mean18.0863
 Geometric mean38.4753
 Mode value(s)83, 32, 38, 85, 92, 11, 84, 78, 74, 13...
 Variance832.358
 Standard deviation28.8506
 Expected value51.4544
 Skewness-171.41
 Kurtosis-1.11541
ColumnPropertyValue
ShipMethodID, intTotal values4012
 Range4 [1;5]
 Interquartile range3 [2;5]
 Arithmetic mean3.57278
 Arithmetic mean absolute deviation0.836491
 Median value4
 Median absolute deviation1.18644
 Harmonic mean2.59562
 Geometric mean3.13568
 Mode value(s)5
 Variance2.21185
 Standard deviation1.48723
 Expected value3.57278
 Skewness-2461.33
 Kurtosis-1.15636
ColumnPropertyValue
OrderDate, datetimeTotal values4012
 Minimum value2001-05-17
 Arithmetic mean2004-01-28
 Maximum value2004-10-23
 Median2004-03-17
ColumnPropertyValue
ShipDate, datetimeTotal values4012
 Minimum value2001-05-26
 Arithmetic mean2004-02-06
 Maximum value2004-11-17
 Median2004-03-26
ColumnPropertyValue
SubTotal, moneyTotal values4012
 Range997643 [37.0755;997680]
 Interquartile range27809.7
 Arithmetic mean15900.3
 Arithmetic mean absolute deviation17610.9
 Median value2934.54
 Median absolute deviation15370.5
 Harmonic mean421.545
 Geometric mean2770.77
 Mode value(s)43878.4500
 Variance7.91997e+008
 Standard deviation28142.4
 Expected value15900.3
 Skewness54615.2
 Kurtosis409.799
ColumnPropertyValue
TaxAmt, moneyTotal values4012
 Range79811.4 [2.966;79814.4]
 Interquartile range2224.77
 Arithmetic mean1272.02
 Arithmetic mean absolute deviation1408.39
 Median value234.763
 Median absolute deviation1229.17
 Harmonic mean33.7235
 Geometric mean221.661
 Mode value(s)3510.2760
 Variance5.06878e+006
 Standard deviation2251.4
 Expected value1272.02
 Skewness54615.2
 Kurtosis409.799
ColumnPropertyValue
Freight, moneyTotal values4012
 Range19952.7 [0.9269;19953.6]
 Interquartile range695.242
 Arithmetic mean394.81
 Arithmetic mean absolute deviation436.424
 Median value73.3635
 Median absolute deviation381.056
 Harmonic mean10.5382
 Geometric mean69.2231
 Mode value(s)1096.9613
 Variance414800
 Standard deviation644.05
 Expected value394.81
 Skewness37712.8
 Kurtosis235.331
ColumnPropertyValue
TotalDue, moneyTotal values4012
 Range1.09741e+006 [40.9684;1.09745e+006]
 Interquartile range30729.7
 Arithmetic mean17567.1
 Arithmetic mean absolute deviation19456.6
 Median value3242.67
 Median absolute deviation16981.9
 Harmonic mean465.807
 Geometric mean3061.66
 Mode value(s)48485.6873
 Variance9.63108e+008
 Standard deviation31034
 Expected value17567.1
 Skewness54232.1
 Kurtosis405.61
ColumnPropertyValue
ModifiedDate, datetimeTotal values4012
 Minimum value2001-05-26
 Arithmetic mean2004-02-07
 Maximum value2005-09-12
 Median2004-03-26

Table: Purchasing.ShipMethod

ColumnPropertyValue
ShipMethodID, int identityTotal values5
 Range4 [1;5]
 Interquartile range3 [2;5]
 Arithmetic mean3
 Arithmetic mean absolute deviation1.2
 Median value3
 Median absolute deviation1.2
 Harmonic mean2.18978
 Geometric mean2.60517
 Mode value(s)1, 2, 3, 4, 5
 Variance2.5
 Standard deviation1.58114
 Expected value3
 Skewness0
 Kurtosis-1.912
ColumnPropertyValue
ShipBase, moneyTotal values5
 Range26 [3.95;29.95]
 Interquartile range20.96
 Arithmetic mean14.958
 Arithmetic mean absolute deviation8.2
 Median value9.95
 Median absolute deviation7.4
 Harmonic mean9.19373
 Geometric mean11.8359
 Mode value(s)3.9500, 9.9500, 29.9500, 21.9500, 8.9900
 Variance113.88
 Standard deviation10.6715
 Expected value14.958
 Skewness1.67811
 Kurtosis-1.92837
ColumnPropertyValue
ShipRate, moneyTotal values5
 Range2 [0.99;2.99]
 Interquartile range1.7
 Arithmetic mean1.75
 Arithmetic mean absolute deviation0.2
 Median value1.49
 Median absolute deviation0.2
 Harmonic mean1.51819
 Geometric mean1.62475
 Mode value(s).9900, 1.9900, 2.9900, 1.2900, 1.4900
 Variance0.613
 Standard deviation0.782943
 Expected value1.75
 Skewness2.84733
 Kurtosis-1.53607
ColumnPropertyValue
ModifiedDate, datetimeTotal values5
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Purchasing.Vendor

ColumnPropertyValue
VendorID, int identityTotal values104
 Range103 [1;104]
 Interquartile range52 [27;79]
 Arithmetic mean52.5
 Arithmetic mean absolute deviation25.5
 Median value52.5
 Median absolute deviation25.5
 Harmonic mean19.8989
 Geometric mean39.4709
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance910
 Standard deviation30.1662
 Expected value52.5
 Skewness0
 Kurtosis-1.23467
ColumnPropertyValue
CreditRating, tinyintTotal values104
 Range4 [1;5]
 Interquartile range0 [1;1]
 Arithmetic mean1.35577
 Arithmetic mean absolute deviation0.163462
 Median value1
 Median absolute deviation0.355769
 Harmonic mean1.13372
 Geometric mean1.21111
 Mode value(s)1
 Variance0.71686
 Standard deviation0.846676
 Expected value1.35577
 Skewness269.398
 Kurtosis6.44108
ColumnPropertyValue
ModifiedDate, datetimeTotal values104
 Minimum value2001-05-26
 Arithmetic mean2002-01-28
 Maximum value2002-03-21
 Median2002-02-25

Table: Purchasing.VendorAddress

ColumnPropertyValue
VendorID, intTotal values104
 Range103 [1;104]
 Interquartile range52 [27;79]
 Arithmetic mean52.5
 Arithmetic mean absolute deviation25.5
 Median value52.5
 Median absolute deviation25.5
 Harmonic mean19.8989
 Geometric mean39.4709
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance910
 Standard deviation30.1662
 Expected value52.5
 Skewness0
 Kurtosis-1.23467
ColumnPropertyValue
AddressID, intTotal values104
 Range103 [301;404]
 Interquartile range52 [327;379]
 Arithmetic mean352.5
 Arithmetic mean absolute deviation25.5
 Median value352.5
 Median absolute deviation25.5
 Harmonic mean349.928
 Geometric mean351.216
 Mode value(s)357, 335, 381, 323, 373, 344, 377, 328, 346, 363...
 Variance910
 Standard deviation30.1662
 Expected value352.5
 Skewness0
 Kurtosis-1.23467
ColumnPropertyValue
AddressTypeID, intTotal values104
 Range0 [3;3]
 Interquartile range0 [3;3]
 Arithmetic mean3
 Arithmetic mean absolute deviation0
 Median value3
 Median absolute deviation0
 Harmonic mean3
 Geometric mean3
 Mode value(s)3
 Variance0
 Standard deviation0
 Expected value3
ColumnPropertyValue
ModifiedDate, datetimeTotal values104
 Minimum value2001-05-26
 Arithmetic mean2002-01-28
 Maximum value2002-03-21
 Median2002-02-25

Table: Purchasing.VendorContact

ColumnPropertyValue
VendorID, intTotal values156
 Range103 [1;104]
 Interquartile range52 [26;78]
 Arithmetic mean51.9423
 Arithmetic mean absolute deviation25.6538
 Median value50.5
 Median absolute deviation25.6346
 Harmonic mean20.1869
 Geometric mean39.1309
 Mode value(s)2, 9, 16, 17, 21, 26, 28, 31, 32, 39...
 Variance905.397
 Standard deviation30.0898
 Expected value51.9423
 Skewness5.78383
 Kurtosis-1.25476
ColumnPropertyValue
ContactID, intTotal values156
 Range394 [601;995]
 Interquartile range317 [640;957]
 Arithmetic mean758.083
 Arithmetic mean absolute deviation140.417
 Median value678.5
 Median absolute deviation118.083
 Harmonic mean731.06
 Geometric mean743.944
 Mode value(s)610, 678, 947, 974, 696, 620, 664, 628, 683, 654...
 Variance23123.1
 Standard deviation152.063
 Expected value758.083
 Skewness98.1988
 Kurtosis-1.48923
ColumnPropertyValue
ContactTypeID, intTotal values156
 Range17 [2;19]
 Interquartile range2 [17;19]
 Arithmetic mean16.0641
 Arithmetic mean absolute deviation2.41026
 Median value18
 Median absolute deviation2.44872
 Harmonic mean9.3267
 Geometric mean13.8866
 Mode value(s)17
 Variance26.5636
 Standard deviation5.15399
 Expected value16.0641
 Skewness-355.696
 Kurtosis3.43066
ColumnPropertyValue
ModifiedDate, datetimeTotal values156
 Minimum value2001-05-26
 Arithmetic mean2002-01-18
 Maximum value2002-03-21
 Median2002-02-25

Table: Sales.ContactCreditCard

ColumnPropertyValue
ContactID, intTotal values19118
 Range19975 [2;19977]
 Interquartile range9560 [5639;15199]
 Arithmetic mean10388.6
 Arithmetic mean absolute deviation4808.93
 Median value10418.5
 Median absolute deviation4808.89
 Harmonic mean2298.84
 Geometric mean8043.65
 Mode value(s)2, 3, 4, 5, 6, 7, 8, 9, 10, 11...
 Variance3.10334e+007
 Standard deviation5570.77
 Expected value10388.6
 Skewness-609.434
 Kurtosis-1.15636
ColumnPropertyValue
CreditCardID, intTotal values19118
 Range19236 [1;19237]
 Interquartile range9560 [4780;14340]
 Arithmetic mean9567.67
 Arithmetic mean absolute deviation4787.17
 Median value9559.5
 Median absolute deviation4787.17
 Harmonic mean1832.08
 Geometric mean7038.43
 Mode value(s)17038, 15369, 8010, 5316, 6653, 9010, 8937, 16124, 9478, 17600...
 Variance3.06016e+007
 Standard deviation5531.87
 Expected value9567.67
 Skewness125.267
 Kurtosis-1.19364
ColumnPropertyValue
ModifiedDate, datetimeTotal values19118
 Minimum value2001-07-01
 Arithmetic mean2003-08-07
 Maximum value2004-08-00
 Median2003-10-27

Table: Sales.CountryRegionCurrency

ColumnPropertyValue
ModifiedDate, datetimeTotal values109
 Minimum value1998-06-01
 Arithmetic mean2003-08-30
 Maximum value2004-03-11
 Median2004-03-11

Table: Sales.CreditCard

ColumnPropertyValue
CreditCardID, int identityTotal values19118
 Range19236 [1;19237]
 Interquartile range9560 [4780;14340]
 Arithmetic mean9567.67
 Arithmetic mean absolute deviation4787.17
 Median value9559.5
 Median absolute deviation4787.17
 Harmonic mean1832.08
 Geometric mean7038.43
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance3.06016e+007
 Standard deviation5531.87
 Expected value9567.67
 Skewness125.267
 Kurtosis-1.19364
ColumnPropertyValue
ExpMonth, tinyintTotal values19118
 Range11 [1;12]
 Interquartile range6 [4;10]
 Arithmetic mean6.5273
 Arithmetic mean absolute deviation2.50204
 Median value7
 Median absolute deviation2.99681
 Harmonic mean3.87328
 Geometric mean5.31033
 Mode value(s)11
 Variance11.9412
 Standard deviation3.4556
 Expected value6.5273
 Skewness-294.344
 Kurtosis-1.21553
ColumnPropertyValue
ExpYear, smallintTotal values19118
 Range3 [2005;2008]
 Interquartile range1 [2006;2007]
 Arithmetic mean2006.5
 Arithmetic mean absolute deviation0.495815
 Median value2007
 Median absolute deviation0.995345
 Harmonic mean2006.5
 Geometric mean2006.5
 Mode value(s)2007
 Variance1.2417
 Standard deviation1.11431
 Expected value2006.5
 Skewness-20.2002
 Kurtosis-1.35156
ColumnPropertyValue
ModifiedDate, datetimeTotal values19118
 Minimum value1996-07-24
 Arithmetic mean2003-06-22
 Maximum value2004-08-00
 Median2003-10-16

Table: Sales.Currency

ColumnPropertyValue
ModifiedDate, datetimeTotal values105
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Sales.CurrencyRate

ColumnPropertyValue
CurrencyRateID, int identityTotal values13532
 Range13531 [1;13532]
 Interquartile range6766 [3384;10150]
 Arithmetic mean6766.5
 Arithmetic mean absolute deviation3382.5
 Median value6766.5
 Median absolute deviation3382.5
 Harmonic mean1341.12
 Geometric mean4980.23
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance1.52607e+007
 Standard deviation3906.5
 Expected value6766.5
 Skewness0
 Kurtosis-1.20027
ColumnPropertyValue
CurrencyRateDate, datetimeTotal values13532
 Minimum value2001-07-01
 Arithmetic mean2002-12-18
 Maximum value2004-07-01
 Median2002-12-16
ColumnPropertyValue
AverageRate, moneyTotal values13532
 Range1499.4 [0.6046;1500]
 Interquartile range7.2186
 Arithmetic mean79.2363
 Arithmetic mean absolute deviation126.946
 Median value1.9816
 Median absolute deviation77.473
 Harmonic mean1.89959
 Geometric mean4.82041
 Mode value(s)1.0000
 Variance55185.5
 Standard deviation234.916
 Expected value79.2363
 Skewness48499.1
 Kurtosis13.0754
ColumnPropertyValue
EndOfDayRate, moneyTotal values13532
 Range1499.35 [0.6041;1499.95]
 Interquartile range7.2189
 Arithmetic mean79.2363
 Arithmetic mean absolute deviation126.942
 Median value1.982
 Median absolute deviation77.4615
 Harmonic mean1.89958
 Geometric mean4.82041
 Mode value(s)1.0000
 Variance55185.3
 Standard deviation234.915
 Expected value79.2363
 Skewness48499
 Kurtosis13.0753
ColumnPropertyValue
ModifiedDate, datetimeTotal values13532
 Minimum value2001-07-01
 Arithmetic mean2003-01-19
 Maximum value2004-07-01
 Median2003-02-02

Table: Sales.Customer

ColumnPropertyValue
CustomerID, int identityTotal values19185
 Range29482 [1;29483]
 Interquartile range9593 [15095;24688]
 Arithmetic mean19514.7
 Arithmetic mean absolute deviation5179.42
 Median value19891
 Median absolute deviation5172.53
 Harmonic mean2363.73
 Geometric mean16655.3
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance4.13626e+007
 Standard deviation6431.38
 Expected value19514.7
 Skewness-14211.9
 Kurtosis0.755039
ColumnPropertyValue
TerritoryID, intTotal values19185
 Range9 [1;10]
 Interquartile range5 [4;9]
 Arithmetic mean5.85937
 Arithmetic mean absolute deviation2.2331
 Median value6
 Median absolute deviation2.66291
 Harmonic mean3.1844
 Geometric mean4.65558
 Mode value(s)4
 Variance9.30914
 Standard deviation3.05109
 Expected value5.85937
 Skewness-5529.21
 Kurtosis-1.22164
ColumnPropertyValue
ModifiedDate, datetimeTotal values19185
 Minimum value2004-10-13
 Arithmetic mean2004-10-13
 Maximum value2004-10-13
 Median2004-10-13

Table: Sales.CustomerAddress

ColumnPropertyValue
CustomerID, intTotal values19220
 Range29482 [1;29483]
 Interquartile range9597 [15087;24684]
 Arithmetic mean19502.4
 Arithmetic mean absolute deviation5186.91
 Median value19881.5
 Median absolute deviation5179.44
 Harmonic mean2147.79
 Geometric mean16608.5
 Mode value(s)2, 4, 19, 130, 222, 254, 278, 325, 473, 570...
 Variance4.15303e+007
 Standard deviation6444.4
 Expected value19502.4
 Skewness-14310.4
 Kurtosis0.758672
ColumnPropertyValue
AddressID, intTotal values19220
 Range29874 [9;29883]
 Interquartile range9610 [15469;25079]
 Arithmetic mean19882.3
 Arithmetic mean absolute deviation5203.61
 Median value20273.5
 Median absolute deviation5195.66
 Harmonic mean6696.7
 Geometric mean17498
 Mode value(s)832, 297, 833, 559, 560, 11380, 988, 989, 990, 908...
 Variance4.18944e+007
 Standard deviation6472.59
 Expected value19882.3
 Skewness-14485.2
 Kurtosis0.768928
ColumnPropertyValue
AddressTypeID, intTotal values19220
 Range3 [2;5]
 Interquartile range0 [2;2]
 Arithmetic mean2.04194
 Arithmetic mean absolute deviation0.00364204
 Median value2
 Median absolute deviation0.0419355
 Harmonic mean2.02686
 Geometric mean2.03319
 Mode value(s)2
 Variance0.0511057
 Standard deviation0.226066
 Expected value2.04194
 Skewness131653
 Kurtosis62.15
ColumnPropertyValue
ModifiedDate, datetimeTotal values19220
 Minimum value2001-07-01
 Arithmetic mean2003-08-05
 Maximum value2004-08-00
 Median2003-10-26

Table: Sales.Individual

ColumnPropertyValue
CustomerID, intTotal values18484
 Range18483 [11000;29483]
 Interquartile range9242 [15621;24863]
 Arithmetic mean20241.5
 Arithmetic mean absolute deviation4620.5
 Median value20241.5
 Median absolute deviation4620.5
 Harmonic mean18746.8
 Geometric mean19503
 Mode value(s)26792, 26793, 26794, 26795, 26796, 26797, 26798, 26799, 26800, 26801...
 Variance2.84731e+007
 Standard deviation5336.02
 Expected value20241.5
 Skewness-8.22733e-013
 Kurtosis-1.20019
ColumnPropertyValue
ContactID, intTotal values18484
 Range19272 [705;19977]
 Interquartile range9242 [6115;15357]
 Arithmetic mean10731.8
 Arithmetic mean absolute deviation4624.17
 Median value10735.5
 Median absolute deviation4624.17
 Harmonic mean6968.06
 Geometric mean9032.28
 Mode value(s)18359, 15575, 8221, 4579, 4077, 10388, 3202, 5772, 10861, 12886...
 Variance2.85435e+007
 Standard deviation5342.61
 Expected value10731.8
 Skewness-84.8248
 Kurtosis-1.19314
ColumnPropertyValue
ModifiedDate, datetimeTotal values18484
 Minimum value2004-10-19
 Arithmetic mean2004-10-19
 Maximum value2004-10-19
 Median2004-10-19

Table: Sales.SalesOrderDetail

ColumnPropertyValue
SalesOrderID, intTotal values121317
 Range31464 [43659;75123]
 Interquartile range15606 [49884;65490]
 Arithmetic mean57827.4
 Arithmetic mean absolute deviation7860.84
 Median value57029
 Median absolute deviation7822.33
 Harmonic mean56451.9
 Geometric mean57132.9
 Mode value(s)51721, 51739
 Variance8.11647e+007
 Standard deviation9009.15
 Expected value57827.4
 Skewness29698.3
 Kurtosis-1.20654
ColumnPropertyValue
SalesOrderDetailID, int identityTotal values121317
 Range121316 [1;121317]
 Interquartile range60659 [30330;90989]
 Arithmetic mean60659
 Arithmetic mean absolute deviation30329.2
 Median value60659
 Median absolute deviation30329.2
 Harmonic mean9876.51
 Geometric mean44632.5
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance1.22649e+009
 Standard deviation35021.3
 Expected value60659
 Skewness-2.78441e-010
 Kurtosis-1.20003
ColumnPropertyValue
OrderQty, smallintTotal values121317
 Range43 [1;44]
 Interquartile range2 [1;3]
 Arithmetic mean2.26608
 Arithmetic mean absolute deviation1.23664
 Median value1
 Median absolute deviation1.26608
 Harmonic mean1.35603
 Geometric mean1.63799
 Mode value(s)1
 Variance6.20669
 Standard deviation2.49132
 Expected value2.26608
 Skewness445772
 Kurtosis21.8991
ColumnPropertyValue
ProductID, intTotal values121317
 Range292 [707;999]
 Interquartile range153 [768;921]
 Arithmetic mean841.681
 Arithmetic mean absolute deviation75.0295
 Median value863
 Median absolute deviation74.0324
 Harmonic mean832.682
 Geometric mean837.196
 Mode value(s)870
 Variance7473.97
 Standard deviation86.4521
 Expected value841.681
 Skewness-5346.39
 Kurtosis-1.16552
ColumnPropertyValue
SpecialOfferID, intTotal values121317
 Range15 [1;16]
 Interquartile range0 [1;1]
 Arithmetic mean1.16254
 Arithmetic mean absolute deviation0.117758
 Median value1
 Median absolute deviation0.162541
 Harmonic mean1.02868
 Geometric mean1.05433
 Mode value(s)1
 Variance1.485
 Standard deviation1.2186
 Expected value1.16254
 Skewness1.1674e+006
 Kurtosis96.0948
ColumnPropertyValue
UnitPrice, moneyTotal values121317
 Range3576.94 [1.3282;3578.27]
 Interquartile range580.856
 Arithmetic mean465.093
 Arithmetic mean absolute deviation545.895
 Median value49.99
 Median absolute deviation444.526
 Harmonic mean17.7198
 Geometric mean87.181
 Mode value(s)4.9900
 Variance565331
 Standard deviation751.885
 Expected value465.093
 Skewness252810
 Kurtosis4.05342
ColumnPropertyValue
UnitPriceDiscount, moneyTotal values121317
 Range0.4 [0;0.4]
 Interquartile range0
 Arithmetic mean0.00282607
 Arithmetic mean absolute deviation0
 Median value0
 Median absolute deviation0
 Mode value(s).0000
 Variance0.000615563
 Standard deviation0.0248105
 Expected value0.00282607
 Skewness1.4277e+006
 Kurtosis156.158
ColumnPropertyValue
LineTotal, numericTotal values121317
 Range27892.2 [1.374;27893.6]
 Interquartile range1095.5
 Arithmetic mean905.449
 Arithmetic mean absolute deviation1076.22
 Median value134.982
 Median absolute deviation872.768
 Harmonic mean20.6969
 Geometric mean142.343
 Mode value(s)4.990000
 Variance2.86766e+006
 Standard deviation1693.42
 Expected value905.449
 Skewness479484
 Kurtosis24.2429
ColumnPropertyValue
ModifiedDate, datetimeTotal values121317
 Minimum value2001-07-01
 Arithmetic mean2003-08-16
 Maximum value2004-08-00
 Median2003-11-01

Table: Sales.SalesOrderHeader

ColumnPropertyValue
SalesOrderID, int identityTotal values31465
 Range31464 [43659;75123]
 Interquartile range15733 [51525;67258]
 Arithmetic mean59391
 Arithmetic mean absolute deviation7866.25
 Median value59391
 Median absolute deviation7866.25
 Harmonic mean57974.8
 Geometric mean58685.5
 Mode value(s)43659, 43660, 43661, 43662, 43663, 43664, 43665, 43666, 43667, 43668...
 Variance8.25065e+007
 Standard deviation9083.31
 Expected value59391
 Skewness0
 Kurtosis-1.20011
ColumnPropertyValue
RevisionNumber, tinyintTotal values31465
 Range1 [1;2]
 Interquartile range0 [1;1]
 Arithmetic mean1.00095
 Arithmetic mean absolute deviation0
 Median value1
 Median absolute deviation0.00095344
 Harmonic mean1.00048
 Geometric mean1.00066
 Mode value(s)1
 Variance0.000952562
 Standard deviation0.0308636
 Expected value1.00095
 Skewness1.01751e+006
 Kurtosis1043.77
ColumnPropertyValue
OrderDate, datetimeTotal values31465
 Minimum value2001-07-01
 Arithmetic mean2003-09-22
 Maximum value2004-08-00
 Median2003-12-05
ColumnPropertyValue
DueDate, datetimeTotal values31465
 Minimum value2001-07-13
 Arithmetic mean2003-10-04
 Maximum value2004-08-12
 Median2003-12-17
ColumnPropertyValue
ShipDate, datetimeTotal values31465
 Minimum value2001-07-08
 Arithmetic mean2003-09-29
 Maximum value2004-08-07
 Median2003-12-12
ColumnPropertyValue
Status, tinyintTotal values31465
 Range0 [5;5]
 Interquartile range0 [5;5]
 Arithmetic mean5
 Arithmetic mean absolute deviation0
 Median value5
 Median absolute deviation0
 Harmonic mean5
 Geometric mean5
 Mode value(s)5
 Variance0
 Standard deviation0
 Expected value5
ColumnPropertyValue
CustomerID, intTotal values31465
 Range29482 [1;29483]
 Interquartile range10243 [12484;22727]
 Arithmetic mean16608.1
 Arithmetic mean absolute deviation6231.97
 Median value16785
 Median absolute deviation6230.98
 Harmonic mean708.211
 Geometric mean10758.3
 Mode value(s)11091, 11176
 Variance6.28515e+007
 Standard deviation7927.9
 Expected value16608.1
 Skewness-18279.7
 Kurtosis-0.18245
ColumnPropertyValue
ContactID, intTotal values31465
 Range19976 [1;19977]
 Interquartile range10594 [4179;14773]
 Arithmetic mean9503.67
 Arithmetic mean absolute deviation5272.41
 Median value9538
 Median absolute deviation5272.85
 Harmonic mean660.294
 Geometric mean5890.14
 Mode value(s)3715, 15194
 Variance3.67961e+007
 Standard deviation6065.98
 Expected value9503.67
 Skewness333.351
 Kurtosis-1.23697
ColumnPropertyValue
SalesPersonID, intTotal values3806
 Range22 [268;290]
 Interquartile range7 [277;284]
 Arithmetic mean33.8958
 Arithmetic mean absolute deviation246.224
 Median value279
 Median absolute deviation3.72596
 Harmonic mean280.151
 Geometric mean280.187
 Mode value(s)277
 Variance60713.9
 Standard deviation246.402
 Expected value280.224
 Skewness3806.44
 Kurtosis-1.99916
ColumnPropertyValue
TerritoryID, intTotal values31465
 Range9 [1;10]
 Interquartile range5 [4;9]
 Arithmetic mean6.09077
 Arithmetic mean absolute deviation2.04777
 Median value6
 Median absolute deviation2.53583
 Harmonic mean3.4879
 Geometric mean4.97227
 Mode value(s)9
 Variance8.75047
 Standard deviation2.95812
 Expected value6.09077
 Skewness-12285.6
 Kurtosis-1.08349
ColumnPropertyValue
BillToAddressID, intTotal values31465
 Range29478 [405;29883]
 Interquartile range10599 [14080;24679]
 Arithmetic mean18263.2
 Arithmetic mean absolute deviation6485.57
 Median value19449
 Median absolute deviation6420.36
 Harmonic mean4599.27
 Geometric mean13373.6
 Mode value(s)13550, 25073
 Variance6.74052e+007
 Standard deviation8210.07
 Expected value18263.2
 Skewness-25926.2
 Kurtosis-0.017815
ColumnPropertyValue
ShipToAddressID, intTotal values31465
 Range29874 [9;29883]
 Interquartile range10609 [14063;24672]
 Arithmetic mean18249.2
 Arithmetic mean absolute deviation6492.98
 Median value19438
 Median absolute deviation6427.48
 Harmonic mean3329.45
 Geometric mean13267.9
 Mode value(s)13550, 25073
 Variance6.75426e+007
 Standard deviation8218.43
 Expected value18249.2
 Skewness-25897.7
 Kurtosis-0.0215958
ColumnPropertyValue
ShipMethodID, intTotal values31465
 Range4 [1;5]
 Interquartile range0 [1;1]
 Arithmetic mean1.48384
 Arithmetic mean absolute deviation0.362879
 Median value1
 Median absolute deviation0.483839
 Harmonic mean1.10714
 Geometric mean1.21492
 Mode value(s)1
 Variance1.70131
 Standard deviation1.30434
 Expected value1.48384
 Skewness73147.2
 Kurtosis3.40441
ColumnPropertyValue
CreditCardID, intTotal values30334
 Range19236 [1;19237]
 Interquartile range9617 [4894;14511]
 Arithmetic mean9336.01
 Arithmetic mean absolute deviation4828.62
 Median value9719.5
 Median absolute deviation4821.55
 Harmonic mean1621.32
 Geometric mean7130.98
 Mode value(s)11334, 11843
 Variance3.11049e+007
 Standard deviation5577.17
 Expected value9684.1
 Skewness5391.5
 Kurtosis-1.19414
ColumnPropertyValue
CurrencyRateID, intTotal values13976
 Range12429 [2;12431]
 Interquartile range2772 [8510;11282]
 Arithmetic mean4082.64
 Arithmetic mean absolute deviation5482.16
 Median value10074
 Median absolute deviation2077.68
 Harmonic mean2511.7
 Geometric mean8166.23
 Mode value(s)9755
 Variance3.47763e+007
 Standard deviation5897.14
 Expected value9191.5
 Skewness15735.2
 Kurtosis-1.65224
ColumnPropertyValue
SubTotal, moneyTotal values31465
 Range224355 [1.374;224356]
 Interquartile range2313
 Arithmetic mean4046.95
 Arithmetic mean absolute deviation5478.09
 Median value782.99
 Median absolute deviation3887.38
 Harmonic mean53.1472
 Geometric mean434.982
 Mode value(s)3578.2700
 Variance1.8396e+008
 Standard deviation13563.2
 Expected value4046.95
 Skewness185900
 Kurtosis42.102
ColumnPropertyValue
TaxAmt, moneyTotal values31465
 Range17948.4 [0.1099;17948.5]
 Interquartile range185.04
 Arithmetic mean323.756
 Arithmetic mean absolute deviation437.814
 Median value62.6392
 Median absolute deviation310.523
 Harmonic mean4.25177
 Geometric mean34.7985
 Mode value(s)286.2616
 Variance1.17734e+006
 Standard deviation1085.05
 Expected value323.756
 Skewness185900
 Kurtosis42.102
ColumnPropertyValue
Freight, moneyTotal values31465
 Range5608.88 [0.0344;5608.91]
 Interquartile range57.825
 Arithmetic mean101.174
 Arithmetic mean absolute deviation136.47
 Median value19.5748
 Median absolute deviation96.6556
 Harmonic mean1.32897
 Geometric mean10.8748
 Mode value(s)89.4568
 Variance114975
 Standard deviation339.079
 Expected value101.174
 Skewness185900
 Kurtosis42.102
ColumnPropertyValue
TotalDue, moneyTotal values31465
 Range247912 [1.5183;247914]
 Interquartile range2555.86
 Arithmetic mean4471.88
 Arithmetic mean absolute deviation6053.54
 Median value865.204
 Median absolute deviation4295.45
 Harmonic mean58.7279
 Geometric mean480.655
 Mode value(s)3953.9884
 Variance2.24619e+008
 Standard deviation14987.3
 Expected value4471.88
 Skewness185900
 Kurtosis42.102
ColumnPropertyValue
ModifiedDate, datetimeTotal values31465
 Minimum value2001-07-08
 Arithmetic mean2003-09-29
 Maximum value2004-08-07
 Median2003-12-12

Table: Sales.SalesOrderHeaderSalesReason

ColumnPropertyValue
SalesOrderID, intTotal values27647
 Range31426 [43697;75123]
 Interquartile range14284 [53756;68040]
 Arithmetic mean60458.9
 Arithmetic mean absolute deviation7605.01
 Median value60852
 Median absolute deviation7599.81
 Harmonic mean59064.6
 Geometric mean59772.2
 Mode value(s)51214, 51298, 51303, 51314, 51319, 51452, 51580, 51666, 52275, 52465...
 Variance8.01071e+007
 Standard deviation8950.26
 Expected value60458.9
 Skewness-5273.22
 Kurtosis-1.02645
ColumnPropertyValue
SalesReasonID, intTotal values27647
 Range9 [1;10]
 Interquartile range1 [1;2]
 Arithmetic mean2.58618
 Arithmetic mean absolute deviation1.60932
 Median value1
 Median absolute deviation1.58618
 Harmonic mean1.3633
 Geometric mean1.72651
 Mode value(s)1
 Variance7.66022
 Standard deviation2.76771
 Expected value2.58618
 Skewness46383
 Kurtosis1.42672
ColumnPropertyValue
ModifiedDate, datetimeTotal values27647
 Minimum value2001-07-01
 Arithmetic mean2003-10-15
 Maximum value2004-08-00
 Median2003-12-27

Table: Sales.SalesPerson

ColumnPropertyValue
SalesPersonID, intTotal values17
 Range22 [268;290]
 Interquartile range9 [278;287]
 Arithmetic mean281.647
 Arithmetic mean absolute deviation4.11765
 Median value282
 Median absolute deviation4.58824
 Harmonic mean281.533
 Geometric mean281.59
 Mode value(s)268, 275, 276, 277, 278, 279, 280, 281, 282, 283...
 Variance33.6176
 Standard deviation5.79807
 Expected value281.647
 Skewness-8.5253
 Kurtosis-0.443551
ColumnPropertyValue
TerritoryID, intTotal values14
 Range9 [1;10]
 Interquartile range6 [2;8]
 Arithmetic mean3.94118
 Arithmetic mean absolute deviation2.14286
 Median value4.5
 Median absolute deviation2
 Harmonic mean2.61896
 Geometric mean3.69097
 Mode value(s)1
 Variance9.8725
 Standard deviation3.14205
 Expected value4.78571
 Skewness12.2995
 Kurtosis-1.06665
ColumnPropertyValue
SalesQuota, moneyTotal values14
 Range50000 [250000;300000]
 Interquartile range50000
 Arithmetic mean214706
 Arithmetic mean absolute deviation46008.3
 Median value250000
 Median absolute deviation10714.3
 Harmonic mean259259
 Geometric mean259961
 Mode value(s)250000.0000
 Variance2.7329e+009
 Standard deviation52277.1
 Expected value260714
 Skewness16.415
 Kurtosis-1.31823
ColumnPropertyValue
Bonus, moneyTotal values17
 Range6700 [0;6700]
 Interquartile range4500
 Arithmetic mean2859.41
 Arithmetic mean absolute deviation1977.76
 Median value3500
 Median absolute deviation1940.59
 Mode value(s).0000
 Variance5.16796e+006
 Standard deviation2273.31
 Expected value2859.41
 Skewness0.12918
 Kurtosis-1.55468
ColumnPropertyValue
CommissionPct, smallmoneyTotal values17
 Range0.02 [0;0.02]
 Interquartile range0.008
 Arithmetic mean0.0117647
 Arithmetic mean absolute deviation0
 Median value0.012
 Median absolute deviation0
 Mode value(s).0100
 Variance4.21912e-005
 Standard deviation0.00649547
 Expected value0.0117647
 Skewness-12.068
 Kurtosis-0.735647
ColumnPropertyValue
SalesYTD, moneyTotal values17
 Range5.20048e+006 [0;5.20048e+006]
 Interquartile range2.09878e+006
 Arithmetic mean2.60553e+006
 Arithmetic mean absolute deviation1.36647e+006
 Median value2.81101e+006
 Median absolute deviation1.35438e+006
 Mode value(s)677558.4653, 4557045.0459, 5200475.2313, 3857163.6332, 1764938.9859, 2811012.7151, .0000, 3018725.4858, 3189356.2465, 3587378.4257...
 Variance2.6887e+012
 Standard deviation1.63972e+006
 Expected value2.60553e+006
 Skewness-0.843511
 Kurtosis-1.30779
ColumnPropertyValue
SalesLastYear, moneyTotal values17
 Range2.39654e+006 [0;2.39654e+006]
 Interquartile range730285
 Arithmetic mean1.39329e+006
 Arithmetic mean absolute deviation668254
 Median value1.63582e+006
 Median absolute deviation621888
 Mode value(s).0000
 Variance7.21216e+011
 Standard deviation849244
 Expected value1.39329e+006
 Skewness-13.0519
 Kurtosis-1.03584
ColumnPropertyValue
ModifiedDate, datetimeTotal values17
 Minimum value2001-01-28
 Arithmetic mean2002-01-16
 Maximum value2003-06-24
 Median2001-06-24

Table: Sales.SalesPersonQuotaHistory

ColumnPropertyValue
SalesPersonID, intTotal values163
 Range22 [268;290]
 Interquartile range7 [277;284]
 Arithmetic mean280.153
 Arithmetic mean absolute deviation3.64417
 Median value280
 Median absolute deviation4.12883
 Harmonic mean280.054
 Geometric mean280.104
 Mode value(s)268, 275, 276, 277, 278, 279, 280, 281, 282, 283...
 Variance27.7232
 Standard deviation5.26529
 Expected value280.153
 Skewness-71.6998
 Kurtosis0.068321
ColumnPropertyValue
QuotaDate, datetimeTotal values163
 Minimum value2001-07-01
 Arithmetic mean2003-01-18
 Maximum value2004-04-01
 Median2003-04-01
ColumnPropertyValue
SalesQuota, moneyTotal values163
 Range1.897e+006 [1000;1.898e+006]
 Interquartile range565000
 Arithmetic mean587202
 Arithmetic mean absolute deviation317750
 Median value507000
 Median absolute deviation311515
 Harmonic mean85649.1
 Geometric mean412347
 Mode value(s)7000.0000, 116000.0000, 341000.0000, 280000.0000, 390000.0000, 226000.0000, 583000.0000, 707000.0000, 1262000.0000
 Variance1.58763e+011
 Standard deviation398451
 Expected value587202
 Skewness129.64
 Kurtosis0.109684
ColumnPropertyValue
ModifiedDate, datetimeTotal values163
 Minimum value2001-05-17
 Arithmetic mean2002-12-04
 Maximum value2004-02-16
 Median2003-02-15

Table: Sales.SalesReason

ColumnPropertyValue
SalesReasonID, int identityTotal values10
 Range9 [1;10]
 Interquartile range6 [3;9]
 Arithmetic mean5.5
 Arithmetic mean absolute deviation2
 Median value5.5
 Median absolute deviation2
 Harmonic mean3.41417
 Geometric mean4.52873
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance9.16667
 Standard deviation3.02765
 Expected value5.5
 Skewness0
 Kurtosis-1.56164
ColumnPropertyValue
ModifiedDate, datetimeTotal values10
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Sales.SalesTaxRate

ColumnPropertyValue
SalesTaxRateID, int identityTotal values29
 Range30 [1;31]
 Interquartile range17 [8;25]
 Arithmetic mean16.1034
 Arithmetic mean absolute deviation7.65517
 Median value17
 Median absolute deviation8.13793
 Harmonic mean7.45664
 Geometric mean12.2859
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance88.3818
 Standard deviation9.40116
 Expected value16.1034
 Skewness-0.913524
 Kurtosis-1.42509
ColumnPropertyValue
StateProvinceID, intTotal values29
 Range83 [1;84]
 Interquartile range52 [20;72]
 Arithmetic mean43.8276
 Arithmetic mean absolute deviation22.8621
 Median value45
 Median absolute deviation23.3103
 Harmonic mean9.59056
 Geometric mean29.3541
 Mode value(s)1, 57, 63
 Variance732.719
 Standard deviation27.0688
 Expected value43.8276
 Skewness-3.12199
 Kurtosis-1.41793
ColumnPropertyValue
TaxType, tinyintTotal values29
 Range2 [1;3]
 Interquartile range2 [1;3]
 Arithmetic mean2
 Arithmetic mean absolute deviation0.896552
 Median value2
 Median absolute deviation0.896552
 Harmonic mean1.53982
 Geometric mean1.75802
 Mode value(s)1, 3
 Variance0.928571
 Standard deviation0.963624
 Expected value2
 Skewness0
 Kurtosis-1.96021
ColumnPropertyValue
TaxRate, smallmoneyTotal values29
 Range14.6 [5;19.6]
 Interquartile range3
 Arithmetic mean9.09138
 Arithmetic mean absolute deviation2.58621
 Median value7
 Median absolute deviation2.06897
 Harmonic mean8.10309
 Geometric mean8.51972
 Mode value(s)7.0000
 Variance14.2355
 Standard deviation3.773
 Expected value9.09138
 Skewness42.0362
 Kurtosis0.754186
ColumnPropertyValue
ModifiedDate, datetimeTotal values29
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Sales.SalesTerritory

ColumnPropertyValue
TerritoryID, int identityTotal values10
 Range9 [1;10]
 Interquartile range6 [3;9]
 Arithmetic mean5.5
 Arithmetic mean absolute deviation2
 Median value5.5
 Median absolute deviation2
 Harmonic mean3.41417
 Geometric mean4.52873
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance9.16667
 Standard deviation3.02765
 Expected value5.5
 Skewness0
 Kurtosis-1.56164
ColumnPropertyValue
SalesYTD, moneyTotal values10
 Range6.37382e+006 [1.97747e+006;8.3513e+006]
 Interquartile range4.06585e+006
 Arithmetic mean4.4294e+006
 Arithmetic mean absolute deviation1.59908e+006
 Median value3.8781e+006
 Median absolute deviation1.49301e+006
 Harmonic mean3.68841e+006
 Geometric mean4.03793e+006
 Mode value(s)5767341.9752, 3857163.6331, 4677108.2690, 8351296.7411, 2851419.0435, 6917270.8842, 3899045.6940, 2481039.1786, 1977474.8096, 3514865.9051...
 Variance4.12949e+012
 Standard deviation2.03211e+006
 Expected value4.4294e+006
 Skewness6.07331
 Kurtosis-1.03115
ColumnPropertyValue
SalesLastYear, moneyTotal values10
 Range4.38604e+006 [1.30795e+006;5.69399e+006]
 Interquartile range3.08803e+006
 Arithmetic mean3.27154e+006
 Arithmetic mean absolute deviation1.10676e+006
 Median value3.25185e+006
 Median absolute deviation1.10676e+006
 Harmonic mean2.67299e+006
 Geometric mean2.97021e+006
 Mode value(s)3298694.4938, 3607148.9371, 3205014.0767, 5366575.7098, 3925071.4318, 5693988.8600, 2396539.7601, 1307949.7917, 2278548.9776, 1635823.3967...
 Variance2.12058e+012
 Standard deviation1.45622e+006
 Expected value3.27154e+006
 Skewness3.28086
 Kurtosis-1.27702
ColumnPropertyValue
CostYTD, moneyTotal values10
 Range0 [0;0]
 Interquartile range0
 Arithmetic mean0
 Arithmetic mean absolute deviation0
 Median value0
 Median absolute deviation0
 Mode value(s).0000
 Variance0
 Standard deviation0
 Expected value0
ColumnPropertyValue
CostLastYear, moneyTotal values10
 Range0 [0;0]
 Interquartile range0
 Arithmetic mean0
 Arithmetic mean absolute deviation0
 Median value0
 Median absolute deviation0
 Mode value(s).0000
 Variance0
 Standard deviation0
 Expected value0
ColumnPropertyValue
ModifiedDate, datetimeTotal values10
 Minimum value1998-06-01
 Arithmetic mean1998-06-01
 Maximum value1998-06-01
 Median1998-06-01

Table: Sales.SalesTerritoryHistory

ColumnPropertyValue
SalesPersonID, intTotal values17
 Range15 [275;290]
 Interquartile range9 [277;286]
 Arithmetic mean281.294
 Arithmetic mean absolute deviation3.47059
 Median value281
 Median absolute deviation3.94118
 Harmonic mean281.217
 Geometric mean281.256
 Mode value(s)275, 277, 282
 Variance23.0956
 Standard deviation4.80579
 Expected value281.294
 Skewness5.48246
 Kurtosis-1.26077
ColumnPropertyValue
TerritoryID, intTotal values17
 Range9 [1;10]
 Interquartile range5 [2;7]
 Arithmetic mean4.58824
 Arithmetic mean absolute deviation1.88235
 Median value4
 Median absolute deviation2.35294
 Harmonic mean2.67901
 Geometric mean3.61913
 Mode value(s)6, 1
 Variance8.13235
 Standard deviation2.85173
 Expected value4.58824
 Skewness5.38653
 Kurtosis-1.2052
ColumnPropertyValue
StartDate, datetimeTotal values17
 Minimum value2001-07-01
 Arithmetic mean2002-03-01
 Maximum value2003-07-01
 Median2001-07-01
ColumnPropertyValue
EndDate, datetimeTotal values4
 Minimum value2002-07-00
 Arithmetic mean2002-10-30
 Maximum value2003-01-00
 Median2002-12-00
ColumnPropertyValue
ModifiedDate, datetimeTotal values17
 Minimum value2001-06-24
 Arithmetic mean2002-06-17
 Maximum value2003-06-24
 Median2002-06-24

Table: Sales.ShoppingCartItem

ColumnPropertyValue
ShoppingCartItemID, int identityTotal values3
 Range3 [2;5]
 Arithmetic mean3.66667
 Arithmetic mean absolute deviation0.666667
 Median value4
 Median absolute deviation1
 Harmonic mean3.15789
 Geometric mean3.41995
 Mode value(s)2, 4, 5
 Variance2.33333
 Standard deviation1.52753
 Expected value3.66667
 Skewness-0.62348
 Kurtosis-2.33333
ColumnPropertyValue
Quantity, intTotal values3
 Range4 [3;7]
 Arithmetic mean4.66667
 Arithmetic mean absolute deviation1
 Median value4
 Median absolute deviation1.33333
 Harmonic mean4.13115
 Geometric mean4.37952
 Mode value(s)3, 4, 7
 Variance4.33333
 Standard deviation2.08167
 Expected value4.66667
 Skewness0.862229
 Kurtosis-2.33333
ColumnPropertyValue
ProductID, intTotal values3
 Range19 [862;881]
 Arithmetic mean872.333
 Arithmetic mean absolute deviation6.33333
 Median value874
 Median absolute deviation6.33333
 Harmonic mean872.263
 Geometric mean872.298
 Mode value(s)862, 881, 874
 Variance92.3333
 Standard deviation9.60902
 Expected value872.333
 Skewness-0.50469
 Kurtosis-2.33333
ColumnPropertyValue
DateCreated, datetimeTotal values3
 Minimum value2003-12-11
 Arithmetic mean2003-12-11
 Maximum value2003-12-11
 Median2003-12-11
ColumnPropertyValue
ModifiedDate, datetimeTotal values3
 Minimum value2003-12-11
 Arithmetic mean2003-12-11
 Maximum value2003-12-11
 Median2003-12-11

Table: Sales.SpecialOffer

ColumnPropertyValue
SpecialOfferID, int identityTotal values16
 Range15 [1;16]
 Interquartile range8 [5;13]
 Arithmetic mean8.5
 Arithmetic mean absolute deviation3.5
 Median value8.5
 Median absolute deviation3.5
 Harmonic mean4.73271
 Geometric mean6.80047
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance22.6667
 Standard deviation4.76095
 Expected value8.5
 Skewness0
 Kurtosis-1.42624
ColumnPropertyValue
DiscountPct, smallmoneyTotal values16
 Range0.48 [0.02;0.5]
 Interquartile range0.25
 Arithmetic mean0.22
 Arithmetic mean absolute deviation0
 Median value0.175
 Median absolute deviation0
 Mode value(s).1500
 Variance0.0260667
 Standard deviation0.161452
 Expected value0.22
 Skewness6.31578
 Kurtosis-1.23209
ColumnPropertyValue
StartDate, datetimeTotal values16
 Minimum value2001-06-01
 Arithmetic mean2002-08-08
 Maximum value2004-05-01
 Median2002-07-01
ColumnPropertyValue
EndDate, datetimeTotal values16
 Minimum value2002-07-00
 Arithmetic mean2003-11-10
 Maximum value2005-01-00
 Median2003-10-00
ColumnPropertyValue
MinQty, intTotal values16
 Range61 [0;61]
 Interquartile range15 [0;15]
 Arithmetic mean9.5625
 Arithmetic mean absolute deviation12.625
 Median value0
 Median absolute deviation9.5625
 Mode value(s)0
 Variance327.329
 Standard deviation18.0922
 Expected value9.5625
 Skewness27.2518
 Kurtosis1.74054
ColumnPropertyValue
MaxQty, intTotal values4
 Range46 [14;60]
 Arithmetic mean8.625
 Arithmetic mean absolute deviation25.5
 Median value32
 Median absolute deviation15.5
 Harmonic mean25.8462
 Geometric mean29.9666
 Mode value(s)14, 24, 40, 60
 Variance1296.35
 Standard deviation36.0049
 Expected value34.5
 Skewness3.64806
 Kurtosis-1.81107
ColumnPropertyValue
ModifiedDate, datetimeTotal values16
 Minimum value2001-05-02
 Arithmetic mean2002-07-09
 Maximum value2004-04-01
 Median2002-06-01

Table: Sales.SpecialOfferProduct

ColumnPropertyValue
SpecialOfferID, intTotal values538
 Range15 [1;16]
 Interquartile range1 [1;2]
 Arithmetic mean2.7119
 Arithmetic mean absolute deviation1.5632
 Median value1
 Median absolute deviation1.7119
 Harmonic mean1.42086
 Geometric mean1.76821
 Mode value(s)1
 Variance12.0975
 Standard deviation3.47814
 Expected value2.7119
 Skewness1388.05
 Kurtosis5.5861
ColumnPropertyValue
ProductID, intTotal values538
 Range319 [680;999]
 Interquartile range153 [775;928]
 Arithmetic mean849.47
 Arithmetic mean absolute deviation74.0855
 Median value855.5
 Median absolute deviation73.9368
 Harmonic mean840.589
 Geometric mean845.036
 Mode value(s)707, 708, 711, 863, 869
 Variance7497.81
 Standard deviation86.5899
 Expected value849.47
 Skewness2.23844
 Kurtosis-1.20294
ColumnPropertyValue
ModifiedDate, datetimeTotal values538
 Minimum value2001-05-02
 Arithmetic mean2001-07-28
 Maximum value2004-04-01
 Median2001-05-02

Table: Sales.Store

ColumnPropertyValue
CustomerID, intTotal values701
 Range700 [1;701]
 Interquartile range351 [176;527]
 Arithmetic mean351
 Arithmetic mean absolute deviation175.25
 Median value351
 Median absolute deviation175.25
 Harmonic mean98.3109
 Geometric mean259.431
 Mode value(s)1, 2, 3, 4, 5, 6, 7, 8, 9, 10...
 Variance41008.5
 Standard deviation202.506
 Expected value351
 Skewness0
 Kurtosis-1.20514
ColumnPropertyValue
SalesPersonID, intTotal values701
 Range15 [275;290]
 Interquartile range6 [277;283]
 Arithmetic mean280.873
 Arithmetic mean absolute deviation3.02282
 Median value281
 Median absolute deviation3.52211
 Harmonic mean280.806
 Geometric mean280.839
 Mode value(s)279
 Variance19.051
 Standard deviation4.36475
 Expected value280.873
 Skewness415.257
 Kurtosis-0.537043
ColumnPropertyValue
ModifiedDate, datetimeTotal values701
 Minimum value2004-10-13
 Arithmetic mean2004-10-13
 Maximum value2004-10-13
 Median2004-10-13

Table: Sales.StoreContact

ColumnPropertyValue
CustomerID, intTotal values753
 Range700 [1;701]
 Interquartile range377 [137;514]
 Arithmetic mean329.523
 Arithmetic mean absolute deviation183.254
 Median value325
 Median absolute deviation183.726
 Harmonic mean75.7329
 Geometric mean223.938
 Mode value(s)2, 3, 5, 6, 8, 9, 11, 12, 14, 15...
 Variance44434.1
 Standard deviation210.794
 Expected value329.523
 Skewness61.0281
 Kurtosis-1.26857
ColumnPropertyValue
ContactID, intTotal values753
 Range955 [1;956]
 Interquartile range377 [189;566]
 Arithmetic mean415.623
 Arithmetic mean absolute deviation228.341
 Median value377
 Median absolute deviation226.873
 Harmonic mean105.287
 Geometric mean292.989
 Mode value(s)322, 369, 791, 176, 916, 321, 368, 792, 177, 917...
 Variance76378.5
 Standard deviation276.367
 Expected value415.623
 Skewness348.377
 Kurtosis-0.897987
ColumnPropertyValue
ContactTypeID, intTotal values753
 Range4 [11;15]
 Interquartile range4 [11;15]
 Arithmetic mean13.2656
 Arithmetic mean absolute deviation1.03187
 Median value14
 Median absolute deviation1.38513
 Harmonic mean13.0275
 Geometric mean13.1486
 Mode value(s)11
 Variance2.96925
 Standard deviation1.72315
 Expected value13.2656
 Skewness-336.031
 Kurtosis-1.59979
ColumnPropertyValue
ModifiedDate, datetimeTotal values753
 Minimum value2001-07-01
 Arithmetic mean2002-08-22
 Maximum value2004-06-01
 Median2002-08-01