Property | Value |
---|---|
DTM Database Content Analyzer | 1.03.01 |
Database | SQL Server Native Client 11.0: .///AdventureWorks [AdventureWorks] |
Analyzed tables | 70 |
Total data size, bytes | 69 892 712 |
Report created | 07-Sep-2015 15:56 |
Column | Property | Value |
---|---|---|
SystemInformationID, tinyint identity | Total values | 1 |
Range | 0 [1;1] | |
Arithmetic mean | 1 | |
Arithmetic mean absolute deviation | 0 | |
Median value | 1 | |
Median absolute deviation | 0 | |
Harmonic mean | 1 | |
Geometric mean | 1 | |
Mode value(s) | 1 |
Column | Property | Value |
---|---|---|
VersionDate, datetime | Total values | 1 |
Minimum value | 2006-04-26 | |
Arithmetic mean | 2006-04-26 | |
Maximum value | 2006-04-26 | |
Median | 2006-04-26 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 1 |
Minimum value | 2006-04-26 | |
Arithmetic mean | 2006-04-26 | |
Maximum value | 2006-04-26 | |
Median | 2006-04-26 |
Column | Property | Value |
---|---|---|
DatabaseLogID, int identity | Total values | 389 |
Range | 388 [1;389] | |
Interquartile range | 195 [98;293] | |
Arithmetic mean | 195 | |
Arithmetic mean absolute deviation | 97.2494 | |
Median value | 195 | |
Median absolute deviation | 97.2494 | |
Harmonic mean | 59.4612 | |
Geometric mean | 144.547 | |
Mode value(s) | 1, 2, 5, 6, 7, 21, 3, 8, 9, 10... | |
Variance | 12642.5 | |
Standard deviation | 112.439 | |
Expected value | 195 | |
Skewness | 0 | |
Kurtosis | -1.20926 |
Column | Property | Value |
---|---|---|
PostTime, datetime | Total values | 389 |
Minimum value | 2006-04-26 | |
Arithmetic mean | 2006-04-26 | |
Maximum value | 2006-04-26 | |
Median | 2006-04-26 |
Column | Property | Value |
---|---|---|
DepartmentID, smallint identity | Total values | 16 |
Range | 15 [1;16] | |
Interquartile range | 8 [5;13] | |
Arithmetic mean | 8.5 | |
Arithmetic mean absolute deviation | 3.5 | |
Median value | 8.5 | |
Median absolute deviation | 3.5 | |
Harmonic mean | 4.73271 | |
Geometric mean | 6.80047 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 22.6667 | |
Standard deviation | 4.76095 | |
Expected value | 8.5 | |
Skewness | 0 | |
Kurtosis | -1.42624 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 16 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
EmployeeID, int identity | Total values | 290 |
Range | 289 [1;290] | |
Interquartile range | 146 [73;219] | |
Arithmetic mean | 145.5 | |
Arithmetic mean absolute deviation | 72 | |
Median value | 145.5 | |
Median absolute deviation | 72 | |
Harmonic mean | 46.4088 | |
Geometric mean | 108.075 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 7032.5 | |
Standard deviation | 83.86 | |
Expected value | 145.5 | |
Skewness | 0 | |
Kurtosis | -1.21242 |
Column | Property | Value |
---|---|---|
ContactID, int | Total values | 290 |
Range | 289 [1001;1290] | |
Interquartile range | 146 [1073;1219] | |
Arithmetic mean | 1145.5 | |
Arithmetic mean absolute deviation | 72 | |
Median value | 1145.5 | |
Median absolute deviation | 72 | |
Harmonic mean | 1139.36 | |
Geometric mean | 1142.43 | |
Mode value(s) | 1209, 1030, 1002, 1290, 1009, 1028, 1070, 1071, 1005, 1076... | |
Variance | 7032.5 | |
Standard deviation | 83.86 | |
Expected value | 1145.5 | |
Skewness | 0 | |
Kurtosis | -1.21242 |
Column | Property | Value |
---|---|---|
ManagerID, int | Total values | 289 |
Range | 285 [3;288] | |
Interquartile range | 157 [25;182] | |
Arithmetic mean | 107.838 | |
Arithmetic mean absolute deviation | 73.8858 | |
Median value | 90 | |
Median absolute deviation | 73.9619 | |
Harmonic mean | 29.6099 | |
Geometric mean | 66.119 | |
Mode value(s) | 21 | |
Variance | 7348.83 | |
Standard deviation | 85.7253 | |
Expected value | 108.211 | |
Skewness | 151.652 | |
Kurtosis | -0.946435 |
Column | Property | Value |
---|---|---|
BirthDate, datetime | Total values | 290 |
Minimum value | 1941-11-17 | |
Arithmetic mean | 1968-07-05 | |
Maximum value | 1981-07-01 | |
Median | 1968-11-19 |
Column | Property | Value |
---|---|---|
HireDate, datetime | Total values | 290 |
Minimum value | 1996-08-00 | |
Arithmetic mean | 1999-06-20 | |
Maximum value | 2003-07-01 | |
Median | 1999-03-06 |
Column | Property | Value |
---|---|---|
VacationHours, smallint | Total values | 290 |
Range | 99 [0;99] | |
Interquartile range | 50 [26;76] | |
Arithmetic mean | 50.6138 | |
Arithmetic mean absolute deviation | 24.2241 | |
Median value | 51 | |
Median absolute deviation | 24.7172 | |
Mode value(s) | 48 | |
Variance | 828.646 | |
Standard deviation | 28.7862 | |
Expected value | 50.6138 | |
Skewness | -19.6921 | |
Kurtosis | -1.17184 |
Column | Property | Value |
---|---|---|
SickLeaveHours, smallint | Total values | 290 |
Range | 60 [20;80] | |
Interquartile range | 25 [33;58] | |
Arithmetic mean | 45.3069 | |
Arithmetic mean absolute deviation | 11.9759 | |
Median value | 46 | |
Median absolute deviation | 12.4724 | |
Harmonic mean | 40.0462 | |
Geometric mean | 42.754 | |
Mode value(s) | 64 | |
Variance | 211.425 | |
Standard deviation | 14.5404 | |
Expected value | 45.3069 | |
Skewness | -16.0871 | |
Kurtosis | -1.12748 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 290 |
Minimum value | 2004-08-00 | |
Arithmetic mean | 2004-08-01 | |
Maximum value | 2005-01-26 | |
Median | 2004-08-00 |
Column | Property | Value |
---|---|---|
EmployeeID, int | Total values | 290 |
Range | 289 [1;290] | |
Interquartile range | 146 [73;219] | |
Arithmetic mean | 145.5 | |
Arithmetic mean absolute deviation | 72 | |
Median value | 145.5 | |
Median absolute deviation | 72 | |
Harmonic mean | 46.4088 | |
Geometric mean | 108.075 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 7032.5 | |
Standard deviation | 83.86 | |
Expected value | 145.5 | |
Skewness | 0 | |
Kurtosis | -1.21242 |
Column | Property | Value |
---|---|---|
AddressID, int | Total values | 290 |
Range | 32520 [1;32521] | |
Interquartile range | 156 [88;244] | |
Arithmetic mean | 2127.77 | |
Arithmetic mean absolute deviation | 3689.38 | |
Median value | 160.5 | |
Median absolute deviation | 2040.87 | |
Harmonic mean | 53.8737 | |
Geometric mean | 169.812 | |
Mode value(s) | 61, 234, 224, 11387, 1, 214, 92, 240, 190, 56... | |
Variance | 5.85648e+007 | |
Standard deviation | 7652.77 | |
Expected value | 2127.77 | |
Skewness | 1062.96 | |
Kurtosis | 11.5879 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 290 |
Minimum value | 2004-10-13 | |
Arithmetic mean | 2004-10-13 | |
Maximum value | 2004-10-13 | |
Median | 2004-10-13 |
Column | Property | Value |
---|---|---|
EmployeeID, int | Total values | 296 |
Range | 289 [1;290] | |
Interquartile range | 146 [73;219] | |
Arithmetic mean | 145.233 | |
Arithmetic mean absolute deviation | 72.5338 | |
Median value | 144.5 | |
Median absolute deviation | 72.5304 | |
Harmonic mean | 44.2429 | |
Geometric mean | 106.557 | |
Mode value(s) | 274 | |
Variance | 7143.59 | |
Standard deviation | 84.5198 | |
Expected value | 145.233 | |
Skewness | 0.43337 | |
Kurtosis | -1.21463 |
Column | Property | Value |
---|---|---|
DepartmentID, smallint | Total values | 296 |
Range | 15 [1;16] | |
Interquartile range | 0 [7;7] | |
Arithmetic mean | 7.26689 | |
Arithmetic mean absolute deviation | 1.375 | |
Median value | 7 | |
Median absolute deviation | 1.5777 | |
Harmonic mean | 5.70472 | |
Geometric mean | 6.64037 | |
Mode value(s) | 7 | |
Variance | 7.86412 | |
Standard deviation | 2.8043 | |
Expected value | 7.26689 | |
Skewness | 211.028 | |
Kurtosis | 1.45187 |
Column | Property | Value |
---|---|---|
ShiftID, tinyint | Total values | 296 |
Range | 2 [1;3] | |
Interquartile range | 1 [1;2] | |
Arithmetic mean | 1.56081 | |
Arithmetic mean absolute deviation | 0.175676 | |
Median value | 1 | |
Median absolute deviation | 0.560811 | |
Harmonic mean | 1.28509 | |
Geometric mean | 1.4024 | |
Mode value(s) | 1 | |
Variance | 0.599679 | |
Standard deviation | 0.77439 | |
Expected value | 1.56081 | |
Skewness | 275.978 | |
Kurtosis | -0.713428 |
Column | Property | Value |
---|---|---|
StartDate, datetime | Total values | 296 |
Minimum value | 1996-08-00 | |
Arithmetic mean | 1999-07-06 | |
Maximum value | 2003-12-16 | |
Median | 1999-03-07 |
Column | Property | Value |
---|---|---|
EndDate, datetime | Total values | 6 |
Minimum value | 1999-08-15 | |
Arithmetic mean | 2001-09-06 | |
Maximum value | 2003-12-15 | |
Median | 2001-09-15 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 296 |
Minimum value | 1996-07-30 | |
Arithmetic mean | 1999-07-21 | |
Maximum value | 2003-12-15 | |
Median | 1999-03-08 |
Column | Property | Value |
---|---|---|
EmployeeID, int | Total values | 316 |
Range | 289 [1;290] | |
Interquartile range | 142 [72;214] | |
Arithmetic mean | 143.383 | |
Arithmetic mean absolute deviation | 71.2975 | |
Median value | 142.5 | |
Median absolute deviation | 71.2943 | |
Harmonic mean | 43.1758 | |
Geometric mean | 104.711 | |
Mode value(s) | 4, 6, 24, 62, 96, 113, 134, 140, 146, 171... | |
Variance | 6999.14 | |
Standard deviation | 83.6609 | |
Expected value | 143.383 | |
Skewness | 4.48567 | |
Kurtosis | -1.17309 |
Column | Property | Value |
---|---|---|
RateChangeDate, datetime | Total values | 316 |
Minimum value | 1996-08-00 | |
Arithmetic mean | 1999-09-14 | |
Maximum value | 2003-08-15 | |
Median | 1999-03-12 |
Column | Property | Value |
---|---|---|
Rate, money | Total values | 316 |
Range | 119 [6.5;125.5] | |
Interquartile range | 12.0769 | |
Arithmetic mean | 17.7588 | |
Arithmetic mean absolute deviation | 7.47468 | |
Median value | 14 | |
Median absolute deviation | 6.66456 | |
Harmonic mean | 13.8334 | |
Geometric mean | 15.3791 | |
Mode value(s) | 9.5000 | |
Variance | 150.712 | |
Standard deviation | 12.2765 | |
Expected value | 17.7588 | |
Skewness | 1168.26 | |
Kurtosis | 22.1035 |
Column | Property | Value |
---|---|---|
PayFrequency, tinyint | Total values | 316 |
Range | 1 [1;2] | |
Interquartile range | 1 [1;2] | |
Arithmetic mean | 1.43038 | |
Arithmetic mean absolute deviation | 0 | |
Median value | 1 | |
Median absolute deviation | 0.43038 | |
Harmonic mean | 1.27419 | |
Geometric mean | 1.34759 | |
Mode value(s) | 1 | |
Variance | 0.245931 | |
Standard deviation | 0.495915 | |
Expected value | 1.43038 | |
Skewness | 88.4442 | |
Kurtosis | -1.92773 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 316 |
Minimum value | 1997-12-22 | |
Arithmetic mean | 2004-03-02 | |
Maximum value | 2004-08-00 | |
Median | 2004-08-00 |
Column | Property | Value |
---|---|---|
JobCandidateID, int identity | Total values | 13 |
Range | 12 [1;13] | |
Interquartile range | 7 [4;11] | |
Arithmetic mean | 7 | |
Arithmetic mean absolute deviation | 3.23077 | |
Median value | 7 | |
Median absolute deviation | 3.23077 | |
Harmonic mean | 4.08788 | |
Geometric mean | 5.66769 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 15.1667 | |
Standard deviation | 3.89444 | |
Expected value | 7 | |
Skewness | 0 | |
Kurtosis | -1.47844 |
Column | Property | Value |
---|---|---|
EmployeeID, int | Total values | 2 |
Range | 227 [41;268] | |
Arithmetic mean | 23.7692 | |
Arithmetic mean absolute deviation | 130.5 | |
Median value | 154.5 | |
Median absolute deviation | 113 | |
Harmonic mean | 71.1197 | |
Geometric mean | 104.824 | |
Mode value(s) | 268, 41 | |
Variance | 59945.6 | |
Standard deviation | 244.838 | |
Expected value | 154.5 | |
Skewness | 0.992929 | |
Kurtosis | -2.50493 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 13 |
Minimum value | 1997-07-24 | |
Arithmetic mean | 1998-07-24 | |
Maximum value | 2004-01-23 | |
Median | 1997-07-24 |
Column | Property | Value |
---|---|---|
ShiftID, tinyint identity | Total values | 3 |
Range | 2 [1;3] | |
Arithmetic mean | 2 | |
Arithmetic mean absolute deviation | 0.666667 | |
Median value | 2 | |
Median absolute deviation | 0.666667 | |
Harmonic mean | 1.63636 | |
Geometric mean | 1.81712 | |
Mode value(s) | 1, 2, 3 | |
Variance | 1 | |
Standard deviation | 1 | |
Expected value | 2 | |
Skewness | 0 | |
Kurtosis | -2.33333 |
Column | Property | Value |
---|---|---|
StartTime, datetime | Total values | 3 |
Minimum value | 1901-01-01 | |
Arithmetic mean | 1901-01-01 | |
Maximum value | 1901-01-01 | |
Median | 1901-01-01 |
Column | Property | Value |
---|---|---|
EndTime, datetime | Total values | 3 |
Minimum value | 1901-01-01 | |
Arithmetic mean | 1901-01-01 | |
Maximum value | 1901-01-01 | |
Median | 1901-01-01 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 3 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
AddressID, int identity | Total values | 19614 |
Range | 32520 [1;32521] | |
Interquartile range | 9808 [15190;24998] | |
Arithmetic mean | 19516.3 | |
Arithmetic mean absolute deviation | 5501.74 | |
Median value | 20093.5 | |
Median absolute deviation | 5484.76 | |
Harmonic mean | 2293.97 | |
Geometric mean | 16003.9 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 4.84652e+007 | |
Standard deviation | 6961.7 | |
Expected value | 19516.3 | |
Skewness | -16911.3 | |
Kurtosis | 0.791017 |
Column | Property | Value |
---|---|---|
StateProvinceID, int | Total values | 19614 |
Range | 180 [1;181] | |
Interquartile range | 68 [9;77] | |
Arithmetic mean | 49.2846 | |
Arithmetic mean absolute deviation | 35.8427 | |
Median value | 50 | |
Median absolute deviation | 36.3151 | |
Harmonic mean | 17.5228 | |
Geometric mean | 29.5464 | |
Mode value(s) | 9 | |
Variance | 2126.01 | |
Standard deviation | 46.1086 | |
Expected value | 49.2846 | |
Skewness | 24283.1 | |
Kurtosis | 1.07119 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 19614 |
Minimum value | 1996-07-24 | |
Arithmetic mean | 2003-07-23 | |
Maximum value | 2004-08-00 | |
Median | 2003-11-15 |
Column | Property | Value |
---|---|---|
AddressTypeID, int identity | Total values | 6 |
Range | 5 [1;6] | |
Interquartile range | 4 [2;6] | |
Arithmetic mean | 3.5 | |
Arithmetic mean absolute deviation | 1 | |
Median value | 3.5 | |
Median absolute deviation | 1 | |
Harmonic mean | 2.44898 | |
Geometric mean | 2.9938 | |
Mode value(s) | 1, 2, 3, 4, 5, 6 | |
Variance | 3.5 | |
Standard deviation | 1.87083 | |
Expected value | 3.5 | |
Skewness | 0 | |
Kurtosis | -1.79762 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 6 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
ContactID, int identity | Total values | 19972 |
Range | 19976 [1;19977] | |
Interquartile range | 9986 [4999;14985] | |
Arithmetic mean | 9991.25 | |
Arithmetic mean absolute deviation | 4992.75 | |
Median value | 9991.5 | |
Median absolute deviation | 4992.75 | |
Harmonic mean | 1906.71 | |
Geometric mean | 7354.96 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 3.32465e+007 | |
Standard deviation | 5765.97 | |
Expected value | 9991.25 | |
Skewness | -4.43136 | |
Kurtosis | -1.19992 |
Column | Property | Value |
---|---|---|
EmailPromotion, int | Total values | 19972 |
Range | 2 [0;2] | |
Interquartile range | 1 [0;1] | |
Arithmetic mean | 0.630082 | |
Arithmetic mean absolute deviation | 0.188764 | |
Median value | 0 | |
Median absolute deviation | 0.630082 | |
Mode value(s) | 0 | |
Variance | 0.610638 | |
Standard deviation | 0.781433 | |
Expected value | 0.630082 | |
Skewness | 14997.6 | |
Kurtosis | -0.968253 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 19972 |
Minimum value | 1996-07-24 | |
Arithmetic mean | 2003-06-18 | |
Maximum value | 2005-05-16 | |
Median | 2003-10-15 |
Column | Property | Value |
---|---|---|
ContactTypeID, int identity | Total values | 20 |
Range | 19 [1;20] | |
Interquartile range | 10 [6;16] | |
Arithmetic mean | 10.5 | |
Arithmetic mean absolute deviation | 4.5 | |
Median value | 10.5 | |
Median absolute deviation | 4.5 | |
Harmonic mean | 5.55905 | |
Geometric mean | 8.30436 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 35 | |
Standard deviation | 5.91608 | |
Expected value | 10.5 | |
Skewness | 0 | |
Kurtosis | -1.38093 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 20 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 238 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
StateProvinceID, int identity | Total values | 181 |
Range | 180 [1;181] | |
Interquartile range | 91 [46;137] | |
Arithmetic mean | 91 | |
Arithmetic mean absolute deviation | 45.2486 | |
Median value | 91 | |
Median absolute deviation | 45.2486 | |
Harmonic mean | 31.3232 | |
Geometric mean | 67.8933 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 2745.17 | |
Standard deviation | 52.3943 | |
Expected value | 91 | |
Skewness | 0 | |
Kurtosis | -1.21991 |
Column | Property | Value |
---|---|---|
TerritoryID, int | Total values | 181 |
Range | 9 [1;10] | |
Interquartile range | 2 [5;7] | |
Arithmetic mean | 5.83978 | |
Arithmetic mean absolute deviation | 1.41436 | |
Median value | 7 | |
Median absolute deviation | 1.46961 | |
Harmonic mean | 4.19247 | |
Geometric mean | 5.19013 | |
Mode value(s) | 7 | |
Variance | 4.71308 | |
Standard deviation | 2.17096 | |
Expected value | 5.83978 | |
Skewness | -166.976 | |
Kurtosis | -0.257284 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 181 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 2001-01-23 | |
Maximum value | 2004-03-11 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
BillOfMaterialsID, int identity | Total values | 2679 |
Range | 3481 [1;3482] | |
Interquartile range | 1870 [850;2720] | |
Arithmetic mean | 1760.27 | |
Arithmetic mean absolute deviation | 906.489 | |
Median value | 1770 | |
Median absolute deviation | 906.956 | |
Harmonic mean | 336.309 | |
Geometric mean | 1251.86 | |
Mode value(s) | 893, 271, 34, 830, 2074, 1950, 1761, 3088, 3351, 3246... | |
Variance | 1.0939e+006 | |
Standard deviation | 1045.9 | |
Expected value | 1760.27 | |
Skewness | -24.8892 | |
Kurtosis | -1.24784 |
Column | Property | Value |
---|---|---|
ProductAssemblyID, int | Total values | 2576 |
Range | 996 [3;999] | |
Interquartile range | 192 [762;954] | |
Arithmetic mean | 805.474 | |
Arithmetic mean absolute deviation | 89.8964 | |
Median value | 812 | |
Median absolute deviation | 90.3276 | |
Harmonic mean | 577.422 | |
Geometric mean | 823.996 | |
Mode value(s) | 752, 770, 971, 972 | |
Variance | 13916.8 | |
Standard deviation | 117.97 | |
Expected value | 837.681 | |
Skewness | -491.729 | |
Kurtosis | 3.36372 |
Column | Property | Value |
---|---|---|
ComponentID, int | Total values | 2679 |
Range | 998 [1;999] | |
Interquartile range | 431 [506;937] | |
Arithmetic mean | 701.771 | |
Arithmetic mean absolute deviation | 220.355 | |
Median value | 806 | |
Median absolute deviation | 206.292 | |
Harmonic mean | 251.541 | |
Geometric mean | 642.501 | |
Mode value(s) | 948 | |
Variance | 57650.6 | |
Standard deviation | 240.105 | |
Expected value | 701.771 | |
Skewness | -1201.31 | |
Kurtosis | -1.23948 |
Column | Property | Value |
---|---|---|
StartDate, datetime | Total values | 2679 |
Minimum value | 2000-04-04 | |
Arithmetic mean | 2000-08-13 | |
Maximum value | 2001-01-23 | |
Median | 2000-07-20 |
Column | Property | Value |
---|---|---|
EndDate, datetime | Total values | 199 |
Minimum value | 2000-06-03 | |
Arithmetic mean | 2000-09-09 | |
Maximum value | 2000-12-15 | |
Median | 2000-09-08 |
Column | Property | Value |
---|---|---|
BOMLevel, smallint | Total values | 2679 |
Range | 3 [1;4] | |
Interquartile range | 1 [1;2] | |
Arithmetic mean | 1.35984 | |
Arithmetic mean absolute deviation | 0.0530049 | |
Median value | 1 | |
Median absolute deviation | 0.43673 | |
Mode value(s) | 1 | |
Variance | 0.339477 | |
Standard deviation | 0.582646 | |
Expected value | 1.35984 | |
Skewness | 706.691 | |
Kurtosis | 0.121104 |
Column | Property | Value |
---|---|---|
PerAssemblyQty, decimal | Total values | 2679 |
Range | 40 [1;41] | |
Interquartile range | 0 | |
Arithmetic mean | 2.05412 | |
Arithmetic mean absolute deviation | 1.51138 | |
Median value | 1 | |
Median absolute deviation | 1.05412 | |
Harmonic mean | 1.16678 | |
Geometric mean | 1.32081 | |
Mode value(s) | 1.00 | |
Variance | 20.7032 | |
Standard deviation | 4.55008 | |
Expected value | 2.05412 | |
Skewness | 18486.8 | |
Kurtosis | 49.8569 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 2679 |
Minimum value | 2000-03-21 | |
Arithmetic mean | 2000-08-05 | |
Maximum value | 2001-01-09 | |
Median | 2000-07-25 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 8 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
DocumentID, int identity | Total values | 9 |
Range | 8 [1;9] | |
Interquartile range | 5 [3;8] | |
Arithmetic mean | 5 | |
Arithmetic mean absolute deviation | 2.22222 | |
Median value | 5 | |
Median absolute deviation | 2.22222 | |
Harmonic mean | 3.18137 | |
Geometric mean | 4.14717 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9 | |
Variance | 7.5 | |
Standard deviation | 2.73861 | |
Expected value | 5 | |
Skewness | 0 | |
Kurtosis | -1.60148 |
Column | Property | Value |
---|---|---|
ChangeNumber, int | Total values | 9 |
Range | 280 [8;288] | |
Interquartile range | 44 [11;55] | |
Arithmetic mean | 51.3333 | |
Arithmetic mean absolute deviation | 53 | |
Median value | 25 | |
Median absolute deviation | 41 | |
Mode value(s) | 0, 25, 15, 32, 28, 11, 8, 55, 288 | |
Variance | 8137 | |
Standard deviation | 90.2053 | |
Expected value | 51.3333 | |
Skewness | 17.558 | |
Kurtosis | 2.29122 |
Column | Property | Value |
---|---|---|
Status, tinyint | Total values | 9 |
Range | 2 [1;3] | |
Interquartile range | 0 [2;2] | |
Arithmetic mean | 1.88889 | |
Arithmetic mean absolute deviation | 0.111111 | |
Median value | 2 | |
Median absolute deviation | 0.333333 | |
Harmonic mean | 1.6875 | |
Geometric mean | 1.79349 | |
Mode value(s) | 2 | |
Variance | 0.361111 | |
Standard deviation | 0.600925 | |
Expected value | 1.88889 | |
Skewness | -0.113785 | |
Kurtosis | -0.636643 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 9 |
Minimum value | 1998-05-02 | |
Arithmetic mean | 2002-06-26 | |
Maximum value | 2003-07-01 | |
Median | 2002-11-20 |
Column | Property | Value |
---|---|---|
IllustrationID, int identity | Total values | 5 |
Range | 4 [3;7] | |
Interquartile range | 3 [4;7] | |
Arithmetic mean | 5 | |
Arithmetic mean absolute deviation | 1.2 | |
Median value | 5 | |
Median absolute deviation | 1.2 | |
Harmonic mean | 4.57516 | |
Geometric mean | 4.78939 | |
Mode value(s) | 3, 4, 5, 6, 7 | |
Variance | 2.5 | |
Standard deviation | 1.58114 | |
Expected value | 5 | |
Skewness | 0 | |
Kurtosis | -1.912 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 5 |
Minimum value | 2004-02-10 | |
Arithmetic mean | 2004-02-10 | |
Maximum value | 2004-02-10 | |
Median | 2004-02-10 |
Column | Property | Value |
---|---|---|
LocationID, smallint identity | Total values | 14 |
Range | 59 [1;60] | |
Interquartile range | 41 [4;45] | |
Arithmetic mean | 20.2143 | |
Arithmetic mean absolute deviation | 17.2857 | |
Median value | 8.5 | |
Median absolute deviation | 15.7143 | |
Harmonic mean | 4.89497 | |
Geometric mean | 10.3565 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 10, 20, 30... | |
Variance | 426.489 | |
Standard deviation | 20.6516 | |
Expected value | 20.2143 | |
Skewness | 9.20158 | |
Kurtosis | -1.2833 |
Column | Property | Value |
---|---|---|
CostRate, smallmoney | Total values | 14 |
Range | 12.75 [12.25;25] | |
Interquartile range | 18 | |
Arithmetic mean | 8.58929 | |
Arithmetic mean absolute deviation | 8 | |
Median value | 6.125 | |
Median absolute deviation | 8.28571 | |
Mode value(s) | .0000 | |
Variance | 90.8328 | |
Standard deviation | 9.53062 | |
Expected value | 8.58929 | |
Skewness | 4.82951 | |
Kurtosis | -1.61372 |
Column | Property | Value |
---|---|---|
Availability, decimal | Total values | 14 |
Range | 40 [80;120] | |
Interquartile range | 120 | |
Arithmetic mean | 54.5714 | |
Arithmetic mean absolute deviation | 54.0714 | |
Median value | 40 | |
Median absolute deviation | 54.5714 | |
Mode value(s) | .00 | |
Variance | 3322.11 | |
Standard deviation | 57.6377 | |
Expected value | 54.5714 | |
Skewness | 1.16371 | |
Kurtosis | -2.04926 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 14 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
ProductID, int identity | Total values | 504 |
Range | 998 [1;999] | |
Interquartile range | 426 [448;874] | |
Arithmetic mean | 673.04 | |
Arithmetic mean absolute deviation | 208.841 | |
Median value | 747.5 | |
Median absolute deviation | 199.96 | |
Harmonic mean | 172.47 | |
Geometric mean | 609.963 | |
Mode value(s) | 1, 2, 3, 4, 316, 317, 318, 319, 320, 321... | |
Variance | 52612 | |
Standard deviation | 229.373 | |
Expected value | 673.04 | |
Skewness | -162.542 | |
Kurtosis | -1.15054 |
Column | Property | Value |
---|---|---|
SafetyStockLevel, smallint | Total values | 504 |
Range | 996 [4;1000] | |
Interquartile range | 900 [100;1000] | |
Arithmetic mean | 535.151 | |
Arithmetic mean absolute deviation | 313.637 | |
Median value | 500 | |
Median absolute deviation | 304.135 | |
Harmonic mean | 33.4338 | |
Geometric mean | 271.608 | |
Mode value(s) | 500 | |
Variance | 139961 | |
Standard deviation | 374.113 | |
Expected value | 535.151 | |
Skewness | -9.4338 | |
Kurtosis | -1.4363 |
Column | Property | Value |
---|---|---|
ReorderPoint, smallint | Total values | 504 |
Range | 747 [3;750] | |
Interquartile range | 675 [75;750] | |
Arithmetic mean | 401.363 | |
Arithmetic mean absolute deviation | 235.067 | |
Median value | 375 | |
Median absolute deviation | 228.101 | |
Harmonic mean | 25.0753 | |
Geometric mean | 203.706 | |
Mode value(s) | 375 | |
Variance | 78727.8 | |
Standard deviation | 280.585 | |
Expected value | 401.363 | |
Skewness | -9.4338 | |
Kurtosis | -1.4363 |
Column | Property | Value |
---|---|---|
StandardCost, money | Total values | 504 |
Range | 2171.29 [0;2171.29] | |
Interquartile range | 343.65 | |
Arithmetic mean | 258.603 | |
Arithmetic mean absolute deviation | 326.893 | |
Median value | 23.3722 | |
Median absolute deviation | 255.891 | |
Mode value(s) | .0000 | |
Variance | 213105 | |
Standard deviation | 461.633 | |
Expected value | 258.603 | |
Skewness | 1144.55 | |
Kurtosis | 4.79448 |
Column | Property | Value |
---|---|---|
ListPrice, money | Total values | 504 |
Range | 3578.27 [0;3578.27] | |
Interquartile range | 564.99 | |
Arithmetic mean | 438.666 | |
Arithmetic mean absolute deviation | 545.272 | |
Median value | 49.99 | |
Median absolute deviation | 432.546 | |
Mode value(s) | .0000 | |
Variance | 598461 | |
Standard deviation | 773.603 | |
Expected value | 438.666 | |
Skewness | 1161.74 | |
Kurtosis | 5.06239 |
Column | Property | Value |
---|---|---|
Weight, decimal | Total values | 205 |
Range | 1047.88 [2.12;1050] | |
Interquartile range | 24.54 | |
Arithmetic mean | 30.1274 | |
Arithmetic mean absolute deviation | 71.9268 | |
Median value | 17.9 | |
Median absolute deviation | 67.9415 | |
Harmonic mean | 5.89892 | |
Geometric mean | 14.3639 | |
Mode value(s) | 2.30, 2.96, 3.00, 3.04 | |
Variance | 35125 | |
Standard deviation | 187.417 | |
Expected value | 74.0692 | |
Skewness | 786.949 | |
Kurtosis | 13.7017 |
Column | Property | Value |
---|---|---|
DaysToManufacture, int | Total values | 504 |
Range | 4 [0;4] | |
Interquartile range | 1 [0;1] | |
Arithmetic mean | 1.10317 | |
Arithmetic mean absolute deviation | 0.873016 | |
Median value | 1 | |
Median absolute deviation | 1.07937 | |
Mode value(s) | 0 | |
Variance | 2.2279 | |
Standard deviation | 1.49262 | |
Expected value | 1.10317 | |
Skewness | 611.229 | |
Kurtosis | -0.122065 |
Column | Property | Value |
---|---|---|
ProductSubcategoryID, int | Total values | 295 |
Range | 36 [1;37] | |
Interquartile range | 15 [2;17] | |
Arithmetic mean | 7.19643 | |
Arithmetic mean absolute deviation | 8.24407 | |
Median value | 12 | |
Median absolute deviation | 7.81356 | |
Harmonic mean | 3.91379 | |
Geometric mean | 7.58146 | |
Mode value(s) | 2 | |
Variance | 123.305 | |
Standard deviation | 11.1043 | |
Expected value | 12.2949 | |
Skewness | 502.967 | |
Kurtosis | 0.849904 |
Column | Property | Value |
---|---|---|
ProductModelID, int | Total values | 295 |
Range | 127 [1;128] | |
Interquartile range | 39 [11;50] | |
Arithmetic mean | 21.9167 | |
Arithmetic mean absolute deviation | 24.1763 | |
Median value | 26 | |
Median absolute deviation | 24.2102 | |
Harmonic mean | 13.9181 | |
Geometric mean | 24.2356 | |
Mode value(s) | 9, 30 | |
Variance | 1399.65 | |
Standard deviation | 37.4119 | |
Expected value | 37.4441 | |
Skewness | 596.128 | |
Kurtosis | 1.69449 |
Column | Property | Value |
---|---|---|
SellStartDate, datetime | Total values | 504 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 2000-12-00 | |
Maximum value | 2003-07-01 | |
Median | 2001-07-01 |
Column | Property | Value |
---|---|---|
SellEndDate, datetime | Total values | 98 |
Minimum value | 2002-07-00 | |
Arithmetic mean | 2003-03-13 | |
Maximum value | 2003-07-00 | |
Median | 2003-07-00 |
Column | Property | Value |
---|---|---|
DiscontinuedDate, datetime | Total values | 0 |
Minimum value | 1901-01-00 | |
Maximum value | 1901-01-00 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 504 |
Minimum value | 2004-03-11 | |
Arithmetic mean | 2004-03-11 | |
Maximum value | 2004-03-11 | |
Median | 2004-03-11 |
Column | Property | Value |
---|---|---|
ProductCategoryID, int identity | Total values | 4 |
Range | 3 [1;4] | |
Arithmetic mean | 2.5 | |
Arithmetic mean absolute deviation | 0.5 | |
Median value | 2.5 | |
Median absolute deviation | 0.5 | |
Harmonic mean | 1.92 | |
Geometric mean | 2.21336 | |
Mode value(s) | 1, 2, 3, 4 | |
Variance | 1.66667 | |
Standard deviation | 1.29099 | |
Expected value | 2.5 | |
Skewness | 0 | |
Kurtosis | -2.0775 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 4 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 395 |
Range | 292 [707;999] | |
Interquartile range | 153 [749;902] | |
Arithmetic mean | 828.729 | |
Arithmetic mean absolute deviation | 74.0861 | |
Median value | 814 | |
Median absolute deviation | 74.0203 | |
Harmonic mean | 819.96 | |
Geometric mean | 824.298 | |
Mode value(s) | 707, 708, 711, 712, 713, 714, 715, 716, 717, 718... | |
Variance | 7490.22 | |
Standard deviation | 86.546 | |
Expected value | 828.729 | |
Skewness | 136.864 | |
Kurtosis | -1.12223 |
Column | Property | Value |
---|---|---|
StartDate, datetime | Total values | 395 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2002-10-22 | |
Maximum value | 2003-07-01 | |
Median | 2002-07-01 |
Column | Property | Value |
---|---|---|
EndDate, datetime | Total values | 200 |
Minimum value | 2002-07-00 | |
Arithmetic mean | 2003-02-18 | |
Maximum value | 2003-07-00 | |
Median | 2003-07-00 |
Column | Property | Value |
---|---|---|
StandardCost, money | Total values | 395 |
Range | 2170.44 [0.8565;2171.29] | |
Interquartile range | 623.793 | |
Arithmetic mean | 434.266 | |
Arithmetic mean absolute deviation | 383.643 | |
Median value | 204.625 | |
Median absolute deviation | 360.98 | |
Harmonic mean | 30.9826 | |
Geometric mean | 161.063 | |
Mode value(s) | 413.1463, 486.7066 | |
Variance | 247387 | |
Standard deviation | 497.38 | |
Expected value | 434.266 | |
Skewness | 595.9 | |
Kurtosis | 1.85649 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 395 |
Minimum value | 2002-07-00 | |
Arithmetic mean | 2003-04-18 | |
Maximum value | 2003-07-00 | |
Median | 2003-06-17 |
Column | Property | Value |
---|---|---|
ProductDescriptionID, int identity | Total values | 762 |
Range | 2007 [3;2010] | |
Interquartile range | 387 [1429;1816] | |
Arithmetic mean | 1542.58 | |
Arithmetic mean absolute deviation | 279.755 | |
Median value | 1620.5 | |
Median absolute deviation | 271.77 | |
Harmonic mean | 511.55 | |
Geometric mean | 1432.56 | |
Mode value(s) | 3, 4, 5, 8, 64, 88, 128, 168, 170, 209... | |
Variance | 150955 | |
Standard deviation | 388.529 | |
Expected value | 1542.58 | |
Skewness | -1179.93 | |
Kurtosis | 2.48574 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 762 |
Minimum value | 2003-06-01 | |
Arithmetic mean | 2003-07-17 | |
Maximum value | 2004-03-11 | |
Median | 2003-06-01 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 32 |
Range | 682 [317;999] | |
Interquartile range | 421 [517;938] | |
Arithmetic mean | 740.063 | |
Arithmetic mean absolute deviation | 232.75 | |
Median value | 929.5 | |
Median absolute deviation | 209.25 | |
Harmonic mean | 642.923 | |
Geometric mean | 693.817 | |
Mode value(s) | 506 | |
Variance | 60422.4 | |
Standard deviation | 245.81 | |
Expected value | 740.063 | |
Skewness | -12.2515 | |
Kurtosis | -1.63389 |
Column | Property | Value |
---|---|---|
DocumentID, int | Total values | 32 |
Range | 7 [1;8] | |
Interquartile range | 7 [1;8] | |
Arithmetic mean | 4.21875 | |
Arithmetic mean absolute deviation | 1.875 | |
Median value | 4 | |
Median absolute deviation | 2.28125 | |
Harmonic mean | 2.20563 | |
Geometric mean | 3.14328 | |
Mode value(s) | 1 | |
Variance | 7.78931 | |
Standard deviation | 2.79093 | |
Expected value | 4.21875 | |
Skewness | 6.54115 | |
Kurtosis | -1.48514 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 32 |
Minimum value | 2004-01-30 | |
Arithmetic mean | 2004-01-30 | |
Maximum value | 2004-01-30 | |
Median | 2004-01-30 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 1069 |
Range | 998 [1;999] | |
Interquartile range | 413 [411;824] | |
Arithmetic mean | 611.963 | |
Arithmetic mean absolute deviation | 221.319 | |
Median value | 506 | |
Median absolute deviation | 209.601 | |
Harmonic mean | 130.097 | |
Geometric mean | 541.354 | |
Mode value(s) | 747, 748, 814, 822, 942, 943, 944 | |
Variance | 57301.4 | |
Standard deviation | 239.377 | |
Expected value | 611.963 | |
Skewness | 181.575 | |
Kurtosis | -1.23728 |
Column | Property | Value |
---|---|---|
LocationID, smallint | Total values | 1069 |
Range | 59 [1;60] | |
Interquartile range | 44 [6;50] | |
Arithmetic mean | 23.6848 | |
Arithmetic mean absolute deviation | 21.8718 | |
Median value | 7 | |
Median absolute deviation | 19.304 | |
Harmonic mean | 4.19737 | |
Geometric mean | 10.8663 | |
Mode value(s) | 50 | |
Variance | 553.418 | |
Standard deviation | 23.5248 | |
Expected value | 23.6848 | |
Skewness | 535.973 | |
Kurtosis | -1.61149 |
Column | Property | Value |
---|---|---|
Bin, tinyint | Total values | 1069 |
Range | 61 [0;61] | |
Interquartile range | 13 [0;13] | |
Arithmetic mean | 8.89991 | |
Arithmetic mean absolute deviation | 7.87839 | |
Median value | 5 | |
Median absolute deviation | 7.87558 | |
Mode value(s) | 0 | |
Variance | 128.212 | |
Standard deviation | 11.3231 | |
Expected value | 8.89991 | |
Skewness | 1899.55 | |
Kurtosis | 3.27816 |
Column | Property | Value |
---|---|---|
Quantity, smallint | Total values | 1069 |
Range | 924 [0;924] | |
Interquartile range | 341 [140;481] | |
Arithmetic mean | 314.288 | |
Arithmetic mean absolute deviation | 158.793 | |
Median value | 299 | |
Median absolute deviation | 158.832 | |
Mode value(s) | 99 | |
Variance | 36043.2 | |
Standard deviation | 189.851 | |
Expected value | 314.288 | |
Skewness | 324.27 | |
Kurtosis | -0.887232 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 1069 |
Minimum value | 1998-05-02 | |
Arithmetic mean | 2003-06-27 | |
Maximum value | 2004-09-12 | |
Median | 2004-09-00 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 395 |
Range | 292 [707;999] | |
Interquartile range | 153 [749;902] | |
Arithmetic mean | 828.729 | |
Arithmetic mean absolute deviation | 74.0861 | |
Median value | 814 | |
Median absolute deviation | 74.0203 | |
Harmonic mean | 819.96 | |
Geometric mean | 824.298 | |
Mode value(s) | 707, 708, 711, 712, 713, 714, 715, 716, 717, 718... | |
Variance | 7490.22 | |
Standard deviation | 86.546 | |
Expected value | 828.729 | |
Skewness | 136.864 | |
Kurtosis | -1.12223 |
Column | Property | Value |
---|---|---|
StartDate, datetime | Total values | 395 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2002-10-22 | |
Maximum value | 2003-07-01 | |
Median | 2002-07-01 |
Column | Property | Value |
---|---|---|
EndDate, datetime | Total values | 200 |
Minimum value | 2002-07-00 | |
Arithmetic mean | 2003-02-18 | |
Maximum value | 2003-07-00 | |
Median | 2003-07-00 |
Column | Property | Value |
---|---|---|
ListPrice, money | Total values | 395 |
Range | 3575.98 [2.29;3578.27] | |
Interquartile range | 1144.86 | |
Arithmetic mean | 747.662 | |
Arithmetic mean absolute deviation | 647.651 | |
Median value | 364.09 | |
Median absolute deviation | 608.873 | |
Harmonic mean | 73.3194 | |
Geometric mean | 305.527 | |
Mode value(s) | 306.5636, 337.2200, 699.0982, 782.9900 | |
Variance | 703432 | |
Standard deviation | 838.708 | |
Expected value | 747.662 | |
Skewness | 593.579 | |
Kurtosis | 1.86686 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 395 |
Minimum value | 2002-07-00 | |
Arithmetic mean | 2003-04-14 | |
Maximum value | 2003-07-00 | |
Median | 2003-06-10 |
Column | Property | Value |
---|---|---|
ProductModelID, int identity | Total values | 128 |
Range | 127 [1;128] | |
Interquartile range | 64 [33;97] | |
Arithmetic mean | 64.5 | |
Arithmetic mean absolute deviation | 31.5 | |
Median value | 64.5 | |
Median absolute deviation | 31.5 | |
Harmonic mean | 23.5591 | |
Geometric mean | 48.3356 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 1376 | |
Standard deviation | 37.0945 | |
Expected value | 64.5 | |
Skewness | 0 | |
Kurtosis | -1.22816 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 128 |
Minimum value | 1998-05-02 | |
Arithmetic mean | 2002-12-15 | |
Maximum value | 2005-05-16 | |
Median | 2003-02-24 |
Column | Property | Value |
---|---|---|
ProductModelID, int | Total values | 7 |
Range | 60 [7;67] | |
Interquartile range | 57 [10;67] | |
Arithmetic mean | 39.1429 | |
Arithmetic mean absolute deviation | 16.8571 | |
Median value | 47 | |
Median absolute deviation | 14.1429 | |
Harmonic mean | 20.4677 | |
Geometric mean | 30.3774 | |
Mode value(s) | 47, 48 | |
Variance | 489.81 | |
Standard deviation | 22.1316 | |
Expected value | 39.1429 | |
Skewness | -3.13484 | |
Kurtosis | -1.56443 |
Column | Property | Value |
---|---|---|
IllustrationID, int | Total values | 7 |
Range | 3 [3;6] | |
Interquartile range | 3 [3;6] | |
Arithmetic mean | 4.28571 | |
Arithmetic mean absolute deviation | 0.428571 | |
Median value | 4 | |
Median absolute deviation | 0.857143 | |
Harmonic mean | 4.03846 | |
Geometric mean | 4.1611 | |
Mode value(s) | 3, 4, 5 | |
Variance | 1.2381 | |
Standard deviation | 1.1127 | |
Expected value | 4.28571 | |
Skewness | 1.06661 | |
Kurtosis | -1.63603 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 7 |
Minimum value | 2004-02-10 | |
Arithmetic mean | 2004-02-10 | |
Maximum value | 2004-02-10 | |
Median | 2004-02-10 |
Column | Property | Value |
---|---|---|
ProductModelID, int | Total values | 762 |
Range | 126 [1;127] | |
Interquartile range | 64 [32;96] | |
Arithmetic mean | 64 | |
Arithmetic mean absolute deviation | 31.748 | |
Median value | 64 | |
Median absolute deviation | 31.748 | |
Harmonic mean | 23.4087 | |
Geometric mean | 47.9663 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 1345.77 | |
Standard deviation | 36.6847 | |
Expected value | 64 | |
Skewness | 0 | |
Kurtosis | -1.20487 |
Column | Property | Value |
---|---|---|
ProductDescriptionID, int | Total values | 762 |
Range | 2007 [3;2010] | |
Interquartile range | 387 [1429;1816] | |
Arithmetic mean | 1542.58 | |
Arithmetic mean absolute deviation | 279.755 | |
Median value | 1620.5 | |
Median absolute deviation | 271.77 | |
Harmonic mean | 511.55 | |
Geometric mean | 1432.56 | |
Mode value(s) | 1199, 1467, 1589, 1712, 1838, 1965, 1210, 1476, 1598, 1721... | |
Variance | 150955 | |
Standard deviation | 388.529 | |
Expected value | 1542.58 | |
Skewness | -1179.93 | |
Kurtosis | 2.48574 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 762 |
Minimum value | 2003-06-01 | |
Arithmetic mean | 2003-06-01 | |
Maximum value | 2003-06-01 | |
Median | 2003-06-01 |
Column | Property | Value |
---|---|---|
ProductPhotoID, int identity | Total values | 101 |
Range | 180 [1;181] | |
Interquartile range | 58 [98;156] | |
Arithmetic mean | 125.772 | |
Arithmetic mean absolute deviation | 28.802 | |
Median value | 128 | |
Median absolute deviation | 29.2376 | |
Harmonic mean | 54.6709 | |
Geometric mean | 116.891 | |
Mode value(s) | 1, 69, 70, 72, 73, 76, 77, 78, 79, 80... | |
Variance | 1217.84 | |
Standard deviation | 34.8975 | |
Expected value | 125.772 | |
Skewness | -42.3375 | |
Kurtosis | -0.0420847 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 101 |
Minimum value | 1998-05-02 | |
Arithmetic mean | 2002-07-21 | |
Maximum value | 2003-06-01 | |
Median | 2002-11-20 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 504 |
Range | 998 [1;999] | |
Interquartile range | 426 [448;874] | |
Arithmetic mean | 673.04 | |
Arithmetic mean absolute deviation | 208.841 | |
Median value | 747.5 | |
Median absolute deviation | 199.96 | |
Harmonic mean | 172.47 | |
Geometric mean | 609.963 | |
Mode value(s) | 1, 2, 3, 4, 316, 317, 318, 319, 320, 321... | |
Variance | 52612 | |
Standard deviation | 229.373 | |
Expected value | 673.04 | |
Skewness | -162.542 | |
Kurtosis | -1.15054 |
Column | Property | Value |
---|---|---|
ProductPhotoID, int | Total values | 504 |
Range | 178 [1;179] | |
Interquartile range | 98 [1;99] | |
Arithmetic mean | 41.6706 | |
Arithmetic mean absolute deviation | 55.2778 | |
Median value | 1 | |
Median absolute deviation | 40.6706 | |
Harmonic mean | 1.45126 | |
Geometric mean | 4.56505 | |
Mode value(s) | 1 | |
Variance | 3920.58 | |
Standard deviation | 62.6146 | |
Expected value | 41.6706 | |
Skewness | 515.73 | |
Kurtosis | -0.701555 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 504 |
Minimum value | 1998-05-02 | |
Arithmetic mean | 2000-11-00 | |
Maximum value | 2003-06-01 | |
Median | 2001-06-01 |
Column | Property | Value |
---|---|---|
ProductReviewID, int identity | Total values | 4 |
Range | 3 [1;4] | |
Arithmetic mean | 2.5 | |
Arithmetic mean absolute deviation | 0.5 | |
Median value | 2.5 | |
Median absolute deviation | 0.5 | |
Harmonic mean | 1.92 | |
Geometric mean | 2.21336 | |
Mode value(s) | 1, 2, 3, 4 | |
Variance | 1.66667 | |
Standard deviation | 1.29099 | |
Expected value | 2.5 | |
Skewness | 0 | |
Kurtosis | -2.0775 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 4 |
Range | 228 [709;937] | |
Arithmetic mean | 845.25 | |
Arithmetic mean absolute deviation | 91.25 | |
Median value | 867.5 | |
Median absolute deviation | 91.25 | |
Harmonic mean | 833.673 | |
Geometric mean | 839.522 | |
Mode value(s) | 937 | |
Variance | 12544.3 | |
Standard deviation | 112.001 | |
Expected value | 845.25 | |
Skewness | -0.775908 | |
Kurtosis | -2.2194 |
Column | Property | Value |
---|---|---|
ReviewDate, datetime | Total values | 4 |
Minimum value | 2003-10-20 | |
Arithmetic mean | 2003-12-02 | |
Maximum value | 2003-12-17 | |
Median | 2003-12-16 |
Column | Property | Value |
---|---|---|
Rating, int | Total values | 4 |
Range | 3 [2;5] | |
Arithmetic mean | 4 | |
Arithmetic mean absolute deviation | 1 | |
Median value | 4.5 | |
Median absolute deviation | 0.5 | |
Harmonic mean | 3.47826 | |
Geometric mean | 3.7606 | |
Mode value(s) | 5 | |
Variance | 2 | |
Standard deviation | 1.41421 | |
Expected value | 4 | |
Skewness | -2.12132 | |
Kurtosis | -1.875 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 4 |
Minimum value | 2003-10-20 | |
Arithmetic mean | 2003-12-02 | |
Maximum value | 2003-12-17 | |
Median | 2003-12-16 |
Column | Property | Value |
---|---|---|
ProductSubcategoryID, int identity | Total values | 37 |
Range | 36 [1;37] | |
Interquartile range | 19 [10;29] | |
Arithmetic mean | 19 | |
Arithmetic mean absolute deviation | 9.24324 | |
Median value | 19 | |
Median absolute deviation | 9.24324 | |
Harmonic mean | 8.8062 | |
Geometric mean | 14.6525 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 117.167 | |
Standard deviation | 10.8244 | |
Expected value | 19 | |
Skewness | 0 | |
Kurtosis | -1.29764 |
Column | Property | Value |
---|---|---|
ProductCategoryID, int | Total values | 37 |
Range | 3 [1;4] | |
Interquartile range | 2 [2;4] | |
Arithmetic mean | 2.78378 | |
Arithmetic mean absolute deviation | 0.405405 | |
Median value | 3 | |
Median absolute deviation | 0.864865 | |
Harmonic mean | 2.3617 | |
Geometric mean | 2.58421 | |
Mode value(s) | 2 | |
Variance | 1.00751 | |
Standard deviation | 1.00375 | |
Expected value | 2.78378 | |
Skewness | -2.07592 | |
Kurtosis | -1.35107 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 37 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
ScrapReasonID, smallint identity | Total values | 16 |
Range | 15 [1;16] | |
Interquartile range | 8 [5;13] | |
Arithmetic mean | 8.5 | |
Arithmetic mean absolute deviation | 3.5 | |
Median value | 8.5 | |
Median absolute deviation | 3.5 | |
Harmonic mean | 4.73271 | |
Geometric mean | 6.80047 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 22.6667 | |
Standard deviation | 4.76095 | |
Expected value | 8.5 | |
Skewness | 0 | |
Kurtosis | -1.42624 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 16 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
TransactionID, int identity | Total values | 113443 |
Range | 113442 [100000;213442] | |
Interquartile range | 56723 [128360;185083] | |
Arithmetic mean | 156721 | |
Arithmetic mean absolute deviation | 28360.7 | |
Median value | 156721 | |
Median absolute deviation | 28360.7 | |
Harmonic mean | 149621 | |
Geometric mean | 153196 | |
Mode value(s) | 100000, 100001, 100002, 100003, 100004, 100005, 100006, 100007, 100008, 100009... | |
Variance | 1.07245e+009 | |
Standard deviation | 32748.3 | |
Expected value | 156721 | |
Skewness | -4.66929e-010 | |
Kurtosis | -1.20003 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 113443 |
Range | 998 [1;999] | |
Interquartile range | 181 [748;929] | |
Arithmetic mean | 813.318 | |
Arithmetic mean absolute deviation | 125.404 | |
Median value | 871 | |
Median absolute deviation | 115.278 | |
Harmonic mean | 344.594 | |
Geometric mean | 776.491 | |
Mode value(s) | 870 | |
Variance | 29559.6 | |
Standard deviation | 171.929 | |
Expected value | 813.318 | |
Skewness | -192556 | |
Kurtosis | 2.7912 |
Column | Property | Value |
---|---|---|
ReferenceOrderID, int | Total values | 113443 |
Range | 74706 [417;75123] | |
Interquartile range | 12669 [54994;67663] | |
Arithmetic mean | 57587.8 | |
Arithmetic mean absolute deviation | 10630.9 | |
Median value | 61188 | |
Median absolute deviation | 10153.7 | |
Harmonic mean | 16754.1 | |
Geometric mean | 48088.2 | |
Mode value(s) | 53465 | |
Variance | 2.85366e+008 | |
Standard deviation | 16892.8 | |
Expected value | 57587.8 | |
Skewness | -263640 | |
Kurtosis | 5.18376 |
Column | Property | Value |
---|---|---|
ReferenceOrderLineID, int | Total values | 113443 |
Range | 71 [0;71] | |
Interquartile range | 3 [0;3] | |
Arithmetic mean | 4.67129 | |
Arithmetic mean absolute deviation | 4.89439 | |
Median value | 2 | |
Median absolute deviation | 4.20972 | |
Mode value(s) | 0 | |
Variance | 78.1519 | |
Standard deviation | 8.84035 | |
Expected value | 4.67129 | |
Skewness | 335130 | |
Kurtosis | 9.11342 |
Column | Property | Value |
---|---|---|
TransactionDate, datetime | Total values | 113443 |
Minimum value | 2003-09-01 | |
Arithmetic mean | 2004-02-07 | |
Maximum value | 2004-09-03 | |
Median | 2004-02-08 |
Column | Property | Value |
---|---|---|
Quantity, int | Total values | 113443 |
Range | 39269 [1;39270] | |
Interquartile range | 3 [1;4] | |
Arithmetic mean | 35.0591 | |
Arithmetic mean absolute deviation | 59.2319 | |
Median value | 1 | |
Median absolute deviation | 34.0591 | |
Harmonic mean | 1.48411 | |
Geometric mean | 2.49459 | |
Mode value(s) | 1 | |
Variance | 141813 | |
Standard deviation | 376.581 | |
Expected value | 35.0591 | |
Skewness | 6.41925e+006 | |
Kurtosis | 4357.21 |
Column | Property | Value |
---|---|---|
ActualCost, money | Total values | 113443 |
Range | 2443.35 [0;2443.35] | |
Interquartile range | 53.99 | |
Arithmetic mean | 240.714 | |
Arithmetic mean absolute deviation | 356.441 | |
Median value | 21.49 | |
Median absolute deviation | 236.912 | |
Mode value(s) | .0000 | |
Variance | 305893 | |
Standard deviation | 553.076 | |
Expected value | 240.714 | |
Skewness | 306478 | |
Kurtosis | 6.41419 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 113443 |
Minimum value | 2003-09-01 | |
Arithmetic mean | 2004-02-07 | |
Maximum value | 2004-09-03 | |
Median | 2004-02-08 |
Column | Property | Value |
---|---|---|
TransactionID, int | Total values | 89253 |
Range | 89252 [1;89253] | |
Interquartile range | 44627 [22314;66941] | |
Arithmetic mean | 44627 | |
Arithmetic mean absolute deviation | 22313.2 | |
Median value | 44627 | |
Median absolute deviation | 22313.2 | |
Harmonic mean | 7452.37 | |
Geometric mean | 32836.8 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 6.63849e+008 | |
Standard deviation | 25765.3 | |
Expected value | 44627 | |
Skewness | -8.29122e-009 | |
Kurtosis | -1.20004 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 89253 |
Range | 998 [1;999] | |
Interquartile range | 108 [717;825] | |
Arithmetic mean | 734.889 | |
Arithmetic mean absolute deviation | 122.21 | |
Median value | 779 | |
Median absolute deviation | 113.327 | |
Harmonic mean | 222.774 | |
Geometric mean | 683.674 | |
Mode value(s) | 712 | |
Variance | 30822.9 | |
Standard deviation | 175.565 | |
Expected value | 734.889 | |
Skewness | -134838 | |
Kurtosis | 2.44768 |
Column | Property | Value |
---|---|---|
ReferenceOrderID, int | Total values | 89253 |
Range | 53448 [1;53449] | |
Interquartile range | 27263 [21392;48655] | |
Arithmetic mean | 35121.2 | |
Arithmetic mean absolute deviation | 14540.8 | |
Median value | 44217 | |
Median absolute deviation | 13655.3 | |
Harmonic mean | 3498.46 | |
Geometric mean | 26685.8 | |
Mode value(s) | 51721, 51739 | |
Variance | 2.7341e+008 | |
Standard deviation | 16535.1 | |
Expected value | 35121.2 | |
Skewness | -64891.9 | |
Kurtosis | -0.913542 |
Column | Property | Value |
---|---|---|
ReferenceOrderLineID, int | Total values | 89253 |
Range | 72 [0;72] | |
Interquartile range | 9 [0;9] | |
Arithmetic mean | 6.77298 | |
Arithmetic mean absolute deviation | 7.88767 | |
Median value | 1 | |
Median absolute deviation | 6.70492 | |
Mode value(s) | 0 | |
Variance | 131.79 | |
Standard deviation | 11.48 | |
Expected value | 6.77298 | |
Skewness | 182589 | |
Kurtosis | 3.80655 |
Column | Property | Value |
---|---|---|
TransactionDate, datetime | Total values | 89253 |
Minimum value | 2001-05-17 | |
Arithmetic mean | 2002-10-17 | |
Maximum value | 2003-09-00 | |
Median | 2002-11-01 |
Column | Property | Value |
---|---|---|
Quantity, int | Total values | 89253 |
Range | 39569 [1;39570] | |
Interquartile range | 5 [1;6] | |
Arithmetic mean | 34.26 | |
Arithmetic mean absolute deviation | 57.0965 | |
Median value | 3 | |
Median absolute deviation | 32.9304 | |
Harmonic mean | 1.96476 | |
Geometric mean | 3.18827 | |
Mode value(s) | 1 | |
Variance | 215740 | |
Standard deviation | 464.479 | |
Expected value | 34.26 | |
Skewness | 3.55577e+006 | |
Kurtosis | 2174.37 |
Column | Property | Value |
---|---|---|
ActualCost, money | Total values | 89253 |
Range | 3578.27 [0;3578.27] | |
Interquartile range | 503.351 | |
Arithmetic mean | 396.624 | |
Arithmetic mean absolute deviation | 536.134 | |
Median value | 8.99 | |
Median absolute deviation | 395.594 | |
Mode value(s) | .0000 | |
Variance | 598597 | |
Standard deviation | 773.69 | |
Expected value | 396.624 | |
Skewness | 214570 | |
Kurtosis | 5.41406 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 89253 |
Minimum value | 2001-05-17 | |
Arithmetic mean | 2002-10-17 | |
Maximum value | 2003-09-00 | |
Median | 2002-11-01 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 38 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
WorkOrderID, int identity | Total values | 72591 |
Range | 72590 [1;72591] | |
Interquartile range | 36297 [18148;54445] | |
Arithmetic mean | 36296 | |
Arithmetic mean absolute deviation | 18147.7 | |
Median value | 36296 | |
Median absolute deviation | 18147.7 | |
Harmonic mean | 6167.55 | |
Geometric mean | 26707.1 | |
Mode value(s) | 5561, 5562, 5563, 5564, 5565, 5566, 5567, 5568, 5569, 5570... | |
Variance | 4.39127e+008 | |
Standard deviation | 20955.4 | |
Expected value | 36296 | |
Skewness | 4.0806e-010 | |
Kurtosis | -1.20005 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 72591 |
Range | 996 [3;999] | |
Interquartile range | 299 [529;828] | |
Arithmetic mean | 704.328 | |
Arithmetic mean absolute deviation | 185.541 | |
Median value | 794 | |
Median absolute deviation | 169.036 | |
Harmonic mean | 152.186 | |
Geometric mean | 625.054 | |
Mode value(s) | 945 | |
Variance | 49655.1 | |
Standard deviation | 222.834 | |
Expected value | 704.328 | |
Skewness | -61920 | |
Kurtosis | -0.0146692 |
Column | Property | Value |
---|---|---|
OrderQty, int | Total values | 72591 |
Range | 39569 [1;39570] | |
Interquartile range | 11 [1;12] | |
Arithmetic mean | 62.0975 | |
Arithmetic mean absolute deviation | 101.645 | |
Median value | 4 | |
Median absolute deviation | 60.4543 | |
Harmonic mean | 2.34154 | |
Geometric mean | 4.88229 | |
Mode value(s) | 1 | |
Variance | 468515 | |
Standard deviation | 684.482 | |
Expected value | 62.0975 | |
Skewness | 2.16917e+006 | |
Kurtosis | 1184.12 |
Column | Property | Value |
---|---|---|
StockedQty, int | Total values | 72591 |
Range | 39569 [1;39570] | |
Interquartile range | 11 [1;12] | |
Arithmetic mean | 61.9508 | |
Arithmetic mean absolute deviation | 100.625 | |
Median value | 4 | |
Median absolute deviation | 60.3075 | |
Harmonic mean | 2.34152 | |
Geometric mean | 4.88113 | |
Mode value(s) | 1 | |
Variance | 466917 | |
Standard deviation | 683.313 | |
Expected value | 61.9508 | |
Skewness | 2.17436e+006 | |
Kurtosis | 1189.78 |
Column | Property | Value |
---|---|---|
ScrappedQty, smallint | Total values | 72591 |
Range | 673 [0;673] | |
Interquartile range | 0 [0;0] | |
Arithmetic mean | 0.146726 | |
Arithmetic mean absolute deviation | 0.136684 | |
Median value | 0 | |
Median absolute deviation | 0.146726 | |
Mode value(s) | 0 | |
Variance | 23.1048 | |
Standard deviation | 4.80674 | |
Expected value | 0.146726 | |
Skewness | 4.93949e+006 | |
Kurtosis | 6764.4 |
Column | Property | Value |
---|---|---|
StartDate, datetime | Total values | 72591 |
Minimum value | 2001-07-04 | |
Arithmetic mean | 2003-04-19 | |
Maximum value | 2004-07-03 | |
Median | 2003-06-29 |
Column | Property | Value |
---|---|---|
EndDate, datetime | Total values | 72591 |
Minimum value | 2001-07-14 | |
Arithmetic mean | 2003-05-02 | |
Maximum value | 2004-07-18 | |
Median | 2003-07-12 |
Column | Property | Value |
---|---|---|
DueDate, datetime | Total values | 72591 |
Minimum value | 2001-07-15 | |
Arithmetic mean | 2003-05-00 | |
Maximum value | 2004-07-14 | |
Median | 2003-07-10 |
Column | Property | Value |
---|---|---|
ScrapReasonID, smallint | Total values | 729 |
Range | 15 [1;16] | |
Interquartile range | 9 [4;13] | |
Arithmetic mean | 0.0876142 | |
Arithmetic mean absolute deviation | 7.72428 | |
Median value | 9 | |
Median absolute deviation | 4.14129 | |
Harmonic mean | 4.80046 | |
Geometric mean | 6.94824 | |
Mode value(s) | 13 | |
Variance | 97.1279 | |
Standard deviation | 9.85535 | |
Expected value | 8.72428 | |
Skewness | 926.719 | |
Kurtosis | -1.2856 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 72591 |
Minimum value | 2001-07-14 | |
Arithmetic mean | 2003-05-02 | |
Maximum value | 2004-07-18 | |
Median | 2003-07-12 |
Column | Property | Value |
---|---|---|
WorkOrderID, int | Total values | 67131 |
Range | 72574 [13;72587] | |
Interquartile range | 34547 [21428;55975] | |
Arithmetic mean | 38394.3 | |
Arithmetic mean absolute deviation | 17575.5 | |
Median value | 39353 | |
Median absolute deviation | 17562.3 | |
Harmonic mean | 8538.47 | |
Geometric mean | 29447.3 | |
Mode value(s) | 13, 14, 65, 66, 117, 863, 1099, 1182, 1275, 1276... | |
Variance | 4.18473e+008 | |
Standard deviation | 20456.6 | |
Expected value | 38394.3 | |
Skewness | -8230.32 | |
Kurtosis | -1.12741 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 67131 |
Range | 485 [514;999] | |
Interquartile range | 59 [769;828] | |
Arithmetic mean | 798.93 | |
Arithmetic mean absolute deviation | 88.9964 | |
Median value | 810 | |
Median absolute deviation | 87.0423 | |
Harmonic mean | 772.093 | |
Geometric mean | 786.421 | |
Mode value(s) | 813 | |
Variance | 17473.1 | |
Standard deviation | 132.186 | |
Expected value | 798.93 | |
Skewness | -56458.1 | |
Kurtosis | 0.376545 |
Column | Property | Value |
---|---|---|
OperationSequence, smallint | Total values | 67131 |
Range | 6 [1;7] | |
Interquartile range | 4 [3;7] | |
Arithmetic mean | 5.10996 | |
Arithmetic mean absolute deviation | 1.16767 | |
Median value | 6 | |
Median absolute deviation | 1.44281 | |
Harmonic mean | 3.19179 | |
Geometric mean | 4.30571 | |
Mode value(s) | 6 | |
Variance | 4.71721 | |
Standard deviation | 2.17191 | |
Expected value | 5.10996 | |
Skewness | -69393.4 | |
Kurtosis | -0.609941 |
Column | Property | Value |
---|---|---|
LocationID, smallint | Total values | 67131 |
Range | 50 [10;60] | |
Interquartile range | 30 [30;60] | |
Arithmetic mean | 43.8008 | |
Arithmetic mean absolute deviation | 14.1803 | |
Median value | 50 | |
Median absolute deviation | 11.7269 | |
Harmonic mean | 29.8457 | |
Geometric mean | 37.9814 | |
Mode value(s) | 50 | |
Variance | 306.985 | |
Standard deviation | 17.521 | |
Expected value | 43.8008 | |
Skewness | -68274 | |
Kurtosis | -0.508106 |
Column | Property | Value |
---|---|---|
ScheduledStartDate, datetime | Total values | 67131 |
Minimum value | 2001-07-04 | |
Arithmetic mean | 2003-05-22 | |
Maximum value | 2004-07-03 | |
Median | 2003-08-04 |
Column | Property | Value |
---|---|---|
ScheduledEndDate, datetime | Total values | 67131 |
Minimum value | 2001-07-15 | |
Arithmetic mean | 2003-06-02 | |
Maximum value | 2004-07-14 | |
Median | 2003-08-15 |
Column | Property | Value |
---|---|---|
ActualStartDate, datetime | Total values | 67131 |
Minimum value | 2001-07-04 | |
Arithmetic mean | 2003-05-26 | |
Maximum value | 2004-07-18 | |
Median | 2003-08-10 |
Column | Property | Value |
---|---|---|
ActualEndDate, datetime | Total values | 67131 |
Minimum value | 2001-07-16 | |
Arithmetic mean | 2003-06-07 | |
Maximum value | 2004-07-29 | |
Median | 2003-08-20 |
Column | Property | Value |
---|---|---|
ActualResourceHrs, decimal | Total values | 67131 |
Range | 3.1 [1;4.1] | |
Interquartile range | 1 | |
Arithmetic mean | 3.41068 | |
Arithmetic mean absolute deviation | 0.0665862 | |
Median value | 3.5 | |
Median absolute deviation | 0.0665862 | |
Harmonic mean | 3.20666 | |
Geometric mean | 3.32962 | |
Mode value(s) | 3.0000 | |
Variance | 0.41321 | |
Standard deviation | 0.642814 | |
Expected value | 3.41068 | |
Skewness | -76074.7 | |
Kurtosis | 2.36338 |
Column | Property | Value |
---|---|---|
PlannedCost, money | Total values | 67131 |
Range | 77.75 [14.5;92.25] | |
Interquartile range | 12.25 | |
Arithmetic mean | 51.9577 | |
Arithmetic mean absolute deviation | 17.2835 | |
Median value | 49 | |
Median absolute deviation | 15.9544 | |
Harmonic mean | 44.2619 | |
Geometric mean | 47.8768 | |
Mode value(s) | 36.7500 | |
Variance | 487.755 | |
Standard deviation | 22.0852 | |
Expected value | 51.9577 | |
Skewness | 64735.9 | |
Kurtosis | -0.533056 |
Column | Property | Value |
---|---|---|
ActualCost, money | Total values | 67131 |
Range | 77.75 [14.5;92.25] | |
Interquartile range | 12.25 | |
Arithmetic mean | 51.9577 | |
Arithmetic mean absolute deviation | 17.2835 | |
Median value | 49 | |
Median absolute deviation | 15.9544 | |
Harmonic mean | 44.2619 | |
Geometric mean | 47.8768 | |
Mode value(s) | 36.7500 | |
Variance | 487.755 | |
Standard deviation | 22.0852 | |
Expected value | 51.9577 | |
Skewness | 64735.9 | |
Kurtosis | -0.533056 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 67131 |
Minimum value | 2001-07-16 | |
Arithmetic mean | 2003-06-07 | |
Maximum value | 2004-07-29 | |
Median | 2003-08-20 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 460 |
Range | 951 [1;952] | |
Interquartile range | 140 [383;523] | |
Arithmetic mean | 517.248 | |
Arithmetic mean absolute deviation | 162.85 | |
Median value | 434.5 | |
Median absolute deviation | 138.439 | |
Harmonic mean | 168.317 | |
Geometric mean | 471.915 | |
Mode value(s) | 319, 320, 321, 322, 341, 342, 343, 344, 345, 346... | |
Variance | 42065.9 | |
Standard deviation | 205.1 | |
Expected value | 517.248 | |
Skewness | 481.564 | |
Kurtosis | -0.14331 |
Column | Property | Value |
---|---|---|
VendorID, int | Total values | 460 |
Range | 103 [1;104] | |
Interquartile range | 52 [25;77] | |
Arithmetic mean | 51.3565 | |
Arithmetic mean absolute deviation | 25.1174 | |
Median value | 51 | |
Median absolute deviation | 25.6087 | |
Harmonic mean | 23.0214 | |
Geometric mean | 39.0049 | |
Mode value(s) | 7 | |
Variance | 868.151 | |
Standard deviation | 29.4644 | |
Expected value | 51.3565 | |
Skewness | -17.2248 | |
Kurtosis | -1.25794 |
Column | Property | Value |
---|---|---|
AverageLeadTime, int | Total values | 460 |
Range | 110 [10;120] | |
Interquartile range | 3 [16;19] | |
Arithmetic mean | 19.45 | |
Arithmetic mean absolute deviation | 4.13261 | |
Median value | 17 | |
Median absolute deviation | 3.64565 | |
Harmonic mean | 17.7572 | |
Geometric mean | 18.3585 | |
Mode value(s) | 17 | |
Variance | 86.2916 | |
Standard deviation | 9.28933 | |
Expected value | 19.45 | |
Skewness | 2255.7 | |
Kurtosis | 34.8333 |
Column | Property | Value |
---|---|---|
StandardPrice, money | Total values | 460 |
Range | 78.69 [0.2;78.89] | |
Interquartile range | 12.05 | |
Arithmetic mean | 34.6765 | |
Arithmetic mean absolute deviation | 9.67826 | |
Median value | 39.26 | |
Median absolute deviation | 8.85435 | |
Harmonic mean | 13.3476 | |
Geometric mean | 29.056 | |
Mode value(s) | 39.2100, 37.2100, 41.2100 | |
Variance | 182.3 | |
Standard deviation | 13.5018 | |
Expected value | 34.6765 | |
Skewness | -445.596 | |
Kurtosis | 0.671644 |
Column | Property | Value |
---|---|---|
LastReceiptCost, money | Total values | 460 |
Range | 82.6245 [0.21;82.8345] | |
Interquartile range | 13.9335 | |
Arithmetic mean | 36.2759 | |
Arithmetic mean absolute deviation | 10.3674 | |
Median value | 41.1967 | |
Median absolute deviation | 9.42609 | |
Harmonic mean | 13.8515 | |
Geometric mean | 30.292 | |
Mode value(s) | 41.1705, 39.0705, 43.2705 | |
Variance | 202.978 | |
Standard deviation | 14.247 | |
Expected value | 36.2759 | |
Skewness | -438.194 | |
Kurtosis | 0.631039 |
Column | Property | Value |
---|---|---|
LastReceiptDate, datetime | Total values | 460 |
Minimum value | 2001-08-22 | |
Arithmetic mean | 2002-01-10 | |
Maximum value | 2004-11-22 | |
Median | 2001-09-22 |
Column | Property | Value |
---|---|---|
MinOrderQty, int | Total values | 460 |
Range | 4999 [1;5000] | |
Interquartile range | 99 [1;100] | |
Arithmetic mean | 145.909 | |
Arithmetic mean absolute deviation | 214.617 | |
Median value | 1 | |
Median absolute deviation | 144.909 | |
Harmonic mean | 1.59858 | |
Geometric mean | 6.27504 | |
Mode value(s) | 1 | |
Variance | 400171 | |
Standard deviation | 632.59 | |
Expected value | 145.909 | |
Skewness | 3206.36 | |
Kurtosis | 49.9431 |
Column | Property | Value |
---|---|---|
MaxOrderQty, int | Total values | 460 |
Range | 14995 [5;15000] | |
Interquartile range | 995 [5;1000] | |
Arithmetic mean | 776.467 | |
Arithmetic mean absolute deviation | 1037.98 | |
Median value | 5 | |
Median absolute deviation | 771.467 | |
Harmonic mean | 8.02035 | |
Geometric mean | 37.6175 | |
Mode value(s) | 5 | |
Variance | 4.33389e+006 | |
Standard deviation | 2081.8 | |
Expected value | 776.467 | |
Skewness | 1955.21 | |
Kurtosis | 19.787 |
Column | Property | Value |
---|---|---|
OnOrderQty, int | Total values | 155 |
Range | 7997 [3;8000] | |
Interquartile range | 297 [3;300] | |
Arithmetic mean | 222.639 | |
Arithmetic mean absolute deviation | 645.652 | |
Median value | 150 | |
Median absolute deviation | 643.2 | |
Harmonic mean | 7.23413 | |
Geometric mean | 58.1258 | |
Mode value(s) | 3 | |
Variance | 2.64937e+006 | |
Standard deviation | 1627.69 | |
Expected value | 660.735 | |
Skewness | 587.999 | |
Kurtosis | 12.657 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 460 |
Minimum value | 2001-08-22 | |
Arithmetic mean | 2002-03-07 | |
Maximum value | 2005-09-12 | |
Median | 2001-09-22 |
Column | Property | Value |
---|---|---|
PurchaseOrderID, int | Total values | 8845 |
Range | 4011 [1;4012] | |
Interquartile range | 2011 [994;3005] | |
Arithmetic mean | 1992.32 | |
Arithmetic mean absolute deviation | 1008.18 | |
Median value | 1978 | |
Median absolute deviation | 1008.62 | |
Harmonic mean | 481.268 | |
Geometric mean | 1458.32 | |
Mode value(s) | 1015 | |
Variance | 1.35262e+006 | |
Standard deviation | 1163.02 | |
Expected value | 1992.32 | |
Skewness | 193.147 | |
Kurtosis | -1.20453 |
Column | Property | Value |
---|---|---|
PurchaseOrderDetailID, int identity | Total values | 8845 |
Range | 8844 [1;8845] | |
Interquartile range | 4423 [2212;6635] | |
Arithmetic mean | 4423 | |
Arithmetic mean absolute deviation | 2211.25 | |
Median value | 4423 | |
Median absolute deviation | 2211.25 | |
Harmonic mean | 915.169 | |
Geometric mean | 3255.9 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 6.52024e+006 | |
Standard deviation | 2553.48 | |
Expected value | 4423 | |
Skewness | 0 | |
Kurtosis | -1.20041 |
Column | Property | Value |
---|---|---|
DueDate, datetime | Total values | 8845 |
Minimum value | 2001-06-00 | |
Arithmetic mean | 2004-02-07 | |
Maximum value | 2004-11-22 | |
Median | 2004-03-29 |
Column | Property | Value |
---|---|---|
OrderQty, smallint | Total values | 8845 |
Range | 7997 [3;8000] | |
Interquartile range | 547 [3;550] | |
Arithmetic mean | 265.533 | |
Arithmetic mean absolute deviation | 282.271 | |
Median value | 60 | |
Median absolute deviation | 258.869 | |
Harmonic mean | 6.32129 | |
Geometric mean | 39.8569 | |
Mode value(s) | 3 | |
Variance | 126684 | |
Standard deviation | 355.927 | |
Expected value | 265.533 | |
Skewness | 57391.6 | |
Kurtosis | 114.969 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 8845 |
Range | 951 [1;952] | |
Interquartile range | 160 [367;527] | |
Arithmetic mean | 527.508 | |
Arithmetic mean absolute deviation | 177.813 | |
Median value | 456 | |
Median absolute deviation | 163.515 | |
Harmonic mean | 82.4808 | |
Geometric mean | 454.272 | |
Mode value(s) | 319 | |
Variance | 52007.1 | |
Standard deviation | 228.051 | |
Expected value | 527.508 | |
Skewness | 7038.82 | |
Kurtosis | -0.319387 |
Column | Property | Value |
---|---|---|
UnitPrice, money | Total values | 8845 |
Range | 82.6245 [0.21;82.8345] | |
Interquartile range | 20.0235 | |
Arithmetic mean | 34.743 | |
Arithmetic mean absolute deviation | 12.5548 | |
Median value | 39.2805 | |
Median absolute deviation | 11.8471 | |
Harmonic mean | 8.93068 | |
Geometric mean | 27.0475 | |
Mode value(s) | 31.4895, 48.2895 | |
Variance | 266.194 | |
Standard deviation | 16.3154 | |
Expected value | 34.743 | |
Skewness | -3755.29 | |
Kurtosis | 0.0328029 |
Column | Property | Value |
---|---|---|
LineTotal, money | Total values | 8845 |
Range | 249383 [37.0755;249420] | |
Interquartile range | 14752 | |
Arithmetic mean | 7212.21 | |
Arithmetic mean absolute deviation | 8578.6 | |
Median value | 262.5 | |
Median absolute deviation | 7077.8 | |
Harmonic mean | 238.514 | |
Geometric mean | 1078.03 | |
Mode value(s) | 17319.2250, 26559.2250 | |
Variance | 1.33236e+008 | |
Standard deviation | 11542.8 | |
Expected value | 7212.21 | |
Skewness | 48449.6 | |
Kurtosis | 90.8419 |
Column | Property | Value |
---|---|---|
ReceivedQty, decimal | Total values | 8845 |
Range | 7998 [2;8000] | |
Interquartile range | 547 | |
Arithmetic mean | 263.12 | |
Arithmetic mean absolute deviation | 279.759 | |
Median value | 60 | |
Median absolute deviation | 256.546 | |
Harmonic mean | 6.31902 | |
Geometric mean | 39.6367 | |
Mode value(s) | 3.00 | |
Variance | 125345 | |
Standard deviation | 354.041 | |
Expected value | 263.12 | |
Skewness | 58338.1 | |
Kurtosis | 117.645 |
Column | Property | Value |
---|---|---|
RejectedQty, decimal | Total values | 8845 |
Range | 1250 [0;1250] | |
Interquartile range | 0 | |
Arithmetic mean | 8.21933 | |
Arithmetic mean absolute deviation | 15.2207 | |
Median value | 0 | |
Median absolute deviation | 8.21933 | |
Mode value(s) | .00 | |
Variance | 3400.71 | |
Standard deviation | 58.3156 | |
Expected value | 8.21933 | |
Skewness | 98582.6 | |
Kurtosis | 152.427 |
Column | Property | Value |
---|---|---|
StockedQty, decimal | Total values | 8845 |
Range | 8000 [0;8000] | |
Interquartile range | 547 | |
Arithmetic mean | 254.901 | |
Arithmetic mean absolute deviation | 275.308 | |
Median value | 60 | |
Median absolute deviation | 249.726 | |
Mode value(s) | 3.00 | |
Variance | 123190 | |
Standard deviation | 350.984 | |
Expected value | 254.901 | |
Skewness | 60145.2 | |
Kurtosis | 122.466 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 8845 |
Minimum value | 2001-05-24 | |
Arithmetic mean | 2004-02-03 | |
Maximum value | 2005-09-12 | |
Median | 2004-03-23 |
Column | Property | Value |
---|---|---|
PurchaseOrderID, int identity | Total values | 4012 |
Range | 4011 [1;4012] | |
Interquartile range | 2006 [1004;3010] | |
Arithmetic mean | 2006.5 | |
Arithmetic mean absolute deviation | 1002.5 | |
Median value | 2006.5 | |
Median absolute deviation | 1002.5 | |
Harmonic mean | 452.088 | |
Geometric mean | 1477.8 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 1.34168e+006 | |
Standard deviation | 1158.31 | |
Expected value | 2006.5 | |
Skewness | 0 | |
Kurtosis | -1.2009 |
Column | Property | Value |
---|---|---|
RevisionNumber, tinyint | Total values | 4012 |
Range | 16 [0;16] | |
Interquartile range | 0 [0;0] | |
Arithmetic mean | 0.083001 | |
Arithmetic mean absolute deviation | 0.0333998 | |
Median value | 0 | |
Median absolute deviation | 0.083001 | |
Mode value(s) | 0 | |
Variance | 0.252645 | |
Standard deviation | 0.502638 | |
Expected value | 0.083001 | |
Skewness | 56228.2 | |
Kurtosis | 324.299 |
Column | Property | Value |
---|---|---|
Status, tinyint | Total values | 4012 |
Range | 3 [1;4] | |
Interquartile range | 0 [4;4] | |
Arithmetic mean | 3.80434 | |
Arithmetic mean absolute deviation | 0.115155 | |
Median value | 4 | |
Median absolute deviation | 0.195663 | |
Harmonic mean | 3.39449 | |
Geometric mean | 3.67043 | |
Mode value(s) | 4 | |
Variance | 0.499976 | |
Standard deviation | 0.70709 | |
Expected value | 3.80434 | |
Skewness | -14284 | |
Kurtosis | 11.0434 |
Column | Property | Value |
---|---|---|
EmployeeID, int | Total values | 4012 |
Range | 110 [164;274] | |
Interquartile range | 30 [231;261] | |
Arithmetic mean | 236.584 | |
Arithmetic mean absolute deviation | 20.091 | |
Median value | 238 | |
Median absolute deviation | 20.3225 | |
Harmonic mean | 232.345 | |
Geometric mean | 234.6 | |
Mode value(s) | 266 | |
Variance | 827.988 | |
Standard deviation | 28.7748 | |
Expected value | 236.584 | |
Skewness | -4914.18 | |
Kurtosis | 1.12472 |
Column | Property | Value |
---|---|---|
VendorID, int | Total values | 4012 |
Range | 103 [1;104] | |
Interquartile range | 49 [27;76] | |
Arithmetic mean | 51.4544 | |
Arithmetic mean absolute deviation | 24.2091 | |
Median value | 52 | |
Median absolute deviation | 24.7041 | |
Harmonic mean | 18.0863 | |
Geometric mean | 38.4753 | |
Mode value(s) | 83, 32, 38, 85, 92, 11, 84, 78, 74, 13... | |
Variance | 832.358 | |
Standard deviation | 28.8506 | |
Expected value | 51.4544 | |
Skewness | -171.41 | |
Kurtosis | -1.11541 |
Column | Property | Value |
---|---|---|
ShipMethodID, int | Total values | 4012 |
Range | 4 [1;5] | |
Interquartile range | 3 [2;5] | |
Arithmetic mean | 3.57278 | |
Arithmetic mean absolute deviation | 0.836491 | |
Median value | 4 | |
Median absolute deviation | 1.18644 | |
Harmonic mean | 2.59562 | |
Geometric mean | 3.13568 | |
Mode value(s) | 5 | |
Variance | 2.21185 | |
Standard deviation | 1.48723 | |
Expected value | 3.57278 | |
Skewness | -2461.33 | |
Kurtosis | -1.15636 |
Column | Property | Value |
---|---|---|
OrderDate, datetime | Total values | 4012 |
Minimum value | 2001-05-17 | |
Arithmetic mean | 2004-01-28 | |
Maximum value | 2004-10-23 | |
Median | 2004-03-17 |
Column | Property | Value |
---|---|---|
ShipDate, datetime | Total values | 4012 |
Minimum value | 2001-05-26 | |
Arithmetic mean | 2004-02-06 | |
Maximum value | 2004-11-17 | |
Median | 2004-03-26 |
Column | Property | Value |
---|---|---|
SubTotal, money | Total values | 4012 |
Range | 997643 [37.0755;997680] | |
Interquartile range | 27809.7 | |
Arithmetic mean | 15900.3 | |
Arithmetic mean absolute deviation | 17610.9 | |
Median value | 2934.54 | |
Median absolute deviation | 15370.5 | |
Harmonic mean | 421.545 | |
Geometric mean | 2770.77 | |
Mode value(s) | 43878.4500 | |
Variance | 7.91997e+008 | |
Standard deviation | 28142.4 | |
Expected value | 15900.3 | |
Skewness | 54615.2 | |
Kurtosis | 409.799 |
Column | Property | Value |
---|---|---|
TaxAmt, money | Total values | 4012 |
Range | 79811.4 [2.966;79814.4] | |
Interquartile range | 2224.77 | |
Arithmetic mean | 1272.02 | |
Arithmetic mean absolute deviation | 1408.39 | |
Median value | 234.763 | |
Median absolute deviation | 1229.17 | |
Harmonic mean | 33.7235 | |
Geometric mean | 221.661 | |
Mode value(s) | 3510.2760 | |
Variance | 5.06878e+006 | |
Standard deviation | 2251.4 | |
Expected value | 1272.02 | |
Skewness | 54615.2 | |
Kurtosis | 409.799 |
Column | Property | Value |
---|---|---|
Freight, money | Total values | 4012 |
Range | 19952.7 [0.9269;19953.6] | |
Interquartile range | 695.242 | |
Arithmetic mean | 394.81 | |
Arithmetic mean absolute deviation | 436.424 | |
Median value | 73.3635 | |
Median absolute deviation | 381.056 | |
Harmonic mean | 10.5382 | |
Geometric mean | 69.2231 | |
Mode value(s) | 1096.9613 | |
Variance | 414800 | |
Standard deviation | 644.05 | |
Expected value | 394.81 | |
Skewness | 37712.8 | |
Kurtosis | 235.331 |
Column | Property | Value |
---|---|---|
TotalDue, money | Total values | 4012 |
Range | 1.09741e+006 [40.9684;1.09745e+006] | |
Interquartile range | 30729.7 | |
Arithmetic mean | 17567.1 | |
Arithmetic mean absolute deviation | 19456.6 | |
Median value | 3242.67 | |
Median absolute deviation | 16981.9 | |
Harmonic mean | 465.807 | |
Geometric mean | 3061.66 | |
Mode value(s) | 48485.6873 | |
Variance | 9.63108e+008 | |
Standard deviation | 31034 | |
Expected value | 17567.1 | |
Skewness | 54232.1 | |
Kurtosis | 405.61 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 4012 |
Minimum value | 2001-05-26 | |
Arithmetic mean | 2004-02-07 | |
Maximum value | 2005-09-12 | |
Median | 2004-03-26 |
Column | Property | Value |
---|---|---|
ShipMethodID, int identity | Total values | 5 |
Range | 4 [1;5] | |
Interquartile range | 3 [2;5] | |
Arithmetic mean | 3 | |
Arithmetic mean absolute deviation | 1.2 | |
Median value | 3 | |
Median absolute deviation | 1.2 | |
Harmonic mean | 2.18978 | |
Geometric mean | 2.60517 | |
Mode value(s) | 1, 2, 3, 4, 5 | |
Variance | 2.5 | |
Standard deviation | 1.58114 | |
Expected value | 3 | |
Skewness | 0 | |
Kurtosis | -1.912 |
Column | Property | Value |
---|---|---|
ShipBase, money | Total values | 5 |
Range | 26 [3.95;29.95] | |
Interquartile range | 20.96 | |
Arithmetic mean | 14.958 | |
Arithmetic mean absolute deviation | 8.2 | |
Median value | 9.95 | |
Median absolute deviation | 7.4 | |
Harmonic mean | 9.19373 | |
Geometric mean | 11.8359 | |
Mode value(s) | 3.9500, 9.9500, 29.9500, 21.9500, 8.9900 | |
Variance | 113.88 | |
Standard deviation | 10.6715 | |
Expected value | 14.958 | |
Skewness | 1.67811 | |
Kurtosis | -1.92837 |
Column | Property | Value |
---|---|---|
ShipRate, money | Total values | 5 |
Range | 2 [0.99;2.99] | |
Interquartile range | 1.7 | |
Arithmetic mean | 1.75 | |
Arithmetic mean absolute deviation | 0.2 | |
Median value | 1.49 | |
Median absolute deviation | 0.2 | |
Harmonic mean | 1.51819 | |
Geometric mean | 1.62475 | |
Mode value(s) | .9900, 1.9900, 2.9900, 1.2900, 1.4900 | |
Variance | 0.613 | |
Standard deviation | 0.782943 | |
Expected value | 1.75 | |
Skewness | 2.84733 | |
Kurtosis | -1.53607 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 5 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
VendorID, int identity | Total values | 104 |
Range | 103 [1;104] | |
Interquartile range | 52 [27;79] | |
Arithmetic mean | 52.5 | |
Arithmetic mean absolute deviation | 25.5 | |
Median value | 52.5 | |
Median absolute deviation | 25.5 | |
Harmonic mean | 19.8989 | |
Geometric mean | 39.4709 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 910 | |
Standard deviation | 30.1662 | |
Expected value | 52.5 | |
Skewness | 0 | |
Kurtosis | -1.23467 |
Column | Property | Value |
---|---|---|
CreditRating, tinyint | Total values | 104 |
Range | 4 [1;5] | |
Interquartile range | 0 [1;1] | |
Arithmetic mean | 1.35577 | |
Arithmetic mean absolute deviation | 0.163462 | |
Median value | 1 | |
Median absolute deviation | 0.355769 | |
Harmonic mean | 1.13372 | |
Geometric mean | 1.21111 | |
Mode value(s) | 1 | |
Variance | 0.71686 | |
Standard deviation | 0.846676 | |
Expected value | 1.35577 | |
Skewness | 269.398 | |
Kurtosis | 6.44108 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 104 |
Minimum value | 2001-05-26 | |
Arithmetic mean | 2002-01-28 | |
Maximum value | 2002-03-21 | |
Median | 2002-02-25 |
Column | Property | Value |
---|---|---|
VendorID, int | Total values | 104 |
Range | 103 [1;104] | |
Interquartile range | 52 [27;79] | |
Arithmetic mean | 52.5 | |
Arithmetic mean absolute deviation | 25.5 | |
Median value | 52.5 | |
Median absolute deviation | 25.5 | |
Harmonic mean | 19.8989 | |
Geometric mean | 39.4709 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 910 | |
Standard deviation | 30.1662 | |
Expected value | 52.5 | |
Skewness | 0 | |
Kurtosis | -1.23467 |
Column | Property | Value |
---|---|---|
AddressID, int | Total values | 104 |
Range | 103 [301;404] | |
Interquartile range | 52 [327;379] | |
Arithmetic mean | 352.5 | |
Arithmetic mean absolute deviation | 25.5 | |
Median value | 352.5 | |
Median absolute deviation | 25.5 | |
Harmonic mean | 349.928 | |
Geometric mean | 351.216 | |
Mode value(s) | 357, 335, 381, 323, 373, 344, 377, 328, 346, 363... | |
Variance | 910 | |
Standard deviation | 30.1662 | |
Expected value | 352.5 | |
Skewness | 0 | |
Kurtosis | -1.23467 |
Column | Property | Value |
---|---|---|
AddressTypeID, int | Total values | 104 |
Range | 0 [3;3] | |
Interquartile range | 0 [3;3] | |
Arithmetic mean | 3 | |
Arithmetic mean absolute deviation | 0 | |
Median value | 3 | |
Median absolute deviation | 0 | |
Harmonic mean | 3 | |
Geometric mean | 3 | |
Mode value(s) | 3 | |
Variance | 0 | |
Standard deviation | 0 | |
Expected value | 3 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 104 |
Minimum value | 2001-05-26 | |
Arithmetic mean | 2002-01-28 | |
Maximum value | 2002-03-21 | |
Median | 2002-02-25 |
Column | Property | Value |
---|---|---|
VendorID, int | Total values | 156 |
Range | 103 [1;104] | |
Interquartile range | 52 [26;78] | |
Arithmetic mean | 51.9423 | |
Arithmetic mean absolute deviation | 25.6538 | |
Median value | 50.5 | |
Median absolute deviation | 25.6346 | |
Harmonic mean | 20.1869 | |
Geometric mean | 39.1309 | |
Mode value(s) | 2, 9, 16, 17, 21, 26, 28, 31, 32, 39... | |
Variance | 905.397 | |
Standard deviation | 30.0898 | |
Expected value | 51.9423 | |
Skewness | 5.78383 | |
Kurtosis | -1.25476 |
Column | Property | Value |
---|---|---|
ContactID, int | Total values | 156 |
Range | 394 [601;995] | |
Interquartile range | 317 [640;957] | |
Arithmetic mean | 758.083 | |
Arithmetic mean absolute deviation | 140.417 | |
Median value | 678.5 | |
Median absolute deviation | 118.083 | |
Harmonic mean | 731.06 | |
Geometric mean | 743.944 | |
Mode value(s) | 610, 678, 947, 974, 696, 620, 664, 628, 683, 654... | |
Variance | 23123.1 | |
Standard deviation | 152.063 | |
Expected value | 758.083 | |
Skewness | 98.1988 | |
Kurtosis | -1.48923 |
Column | Property | Value |
---|---|---|
ContactTypeID, int | Total values | 156 |
Range | 17 [2;19] | |
Interquartile range | 2 [17;19] | |
Arithmetic mean | 16.0641 | |
Arithmetic mean absolute deviation | 2.41026 | |
Median value | 18 | |
Median absolute deviation | 2.44872 | |
Harmonic mean | 9.3267 | |
Geometric mean | 13.8866 | |
Mode value(s) | 17 | |
Variance | 26.5636 | |
Standard deviation | 5.15399 | |
Expected value | 16.0641 | |
Skewness | -355.696 | |
Kurtosis | 3.43066 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 156 |
Minimum value | 2001-05-26 | |
Arithmetic mean | 2002-01-18 | |
Maximum value | 2002-03-21 | |
Median | 2002-02-25 |
Column | Property | Value |
---|---|---|
ContactID, int | Total values | 19118 |
Range | 19975 [2;19977] | |
Interquartile range | 9560 [5639;15199] | |
Arithmetic mean | 10388.6 | |
Arithmetic mean absolute deviation | 4808.93 | |
Median value | 10418.5 | |
Median absolute deviation | 4808.89 | |
Harmonic mean | 2298.84 | |
Geometric mean | 8043.65 | |
Mode value(s) | 2, 3, 4, 5, 6, 7, 8, 9, 10, 11... | |
Variance | 3.10334e+007 | |
Standard deviation | 5570.77 | |
Expected value | 10388.6 | |
Skewness | -609.434 | |
Kurtosis | -1.15636 |
Column | Property | Value |
---|---|---|
CreditCardID, int | Total values | 19118 |
Range | 19236 [1;19237] | |
Interquartile range | 9560 [4780;14340] | |
Arithmetic mean | 9567.67 | |
Arithmetic mean absolute deviation | 4787.17 | |
Median value | 9559.5 | |
Median absolute deviation | 4787.17 | |
Harmonic mean | 1832.08 | |
Geometric mean | 7038.43 | |
Mode value(s) | 17038, 15369, 8010, 5316, 6653, 9010, 8937, 16124, 9478, 17600... | |
Variance | 3.06016e+007 | |
Standard deviation | 5531.87 | |
Expected value | 9567.67 | |
Skewness | 125.267 | |
Kurtosis | -1.19364 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 19118 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2003-08-07 | |
Maximum value | 2004-08-00 | |
Median | 2003-10-27 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 109 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 2003-08-30 | |
Maximum value | 2004-03-11 | |
Median | 2004-03-11 |
Column | Property | Value |
---|---|---|
CreditCardID, int identity | Total values | 19118 |
Range | 19236 [1;19237] | |
Interquartile range | 9560 [4780;14340] | |
Arithmetic mean | 9567.67 | |
Arithmetic mean absolute deviation | 4787.17 | |
Median value | 9559.5 | |
Median absolute deviation | 4787.17 | |
Harmonic mean | 1832.08 | |
Geometric mean | 7038.43 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 3.06016e+007 | |
Standard deviation | 5531.87 | |
Expected value | 9567.67 | |
Skewness | 125.267 | |
Kurtosis | -1.19364 |
Column | Property | Value |
---|---|---|
ExpMonth, tinyint | Total values | 19118 |
Range | 11 [1;12] | |
Interquartile range | 6 [4;10] | |
Arithmetic mean | 6.5273 | |
Arithmetic mean absolute deviation | 2.50204 | |
Median value | 7 | |
Median absolute deviation | 2.99681 | |
Harmonic mean | 3.87328 | |
Geometric mean | 5.31033 | |
Mode value(s) | 11 | |
Variance | 11.9412 | |
Standard deviation | 3.4556 | |
Expected value | 6.5273 | |
Skewness | -294.344 | |
Kurtosis | -1.21553 |
Column | Property | Value |
---|---|---|
ExpYear, smallint | Total values | 19118 |
Range | 3 [2005;2008] | |
Interquartile range | 1 [2006;2007] | |
Arithmetic mean | 2006.5 | |
Arithmetic mean absolute deviation | 0.495815 | |
Median value | 2007 | |
Median absolute deviation | 0.995345 | |
Harmonic mean | 2006.5 | |
Geometric mean | 2006.5 | |
Mode value(s) | 2007 | |
Variance | 1.2417 | |
Standard deviation | 1.11431 | |
Expected value | 2006.5 | |
Skewness | -20.2002 | |
Kurtosis | -1.35156 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 19118 |
Minimum value | 1996-07-24 | |
Arithmetic mean | 2003-06-22 | |
Maximum value | 2004-08-00 | |
Median | 2003-10-16 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 105 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
CurrencyRateID, int identity | Total values | 13532 |
Range | 13531 [1;13532] | |
Interquartile range | 6766 [3384;10150] | |
Arithmetic mean | 6766.5 | |
Arithmetic mean absolute deviation | 3382.5 | |
Median value | 6766.5 | |
Median absolute deviation | 3382.5 | |
Harmonic mean | 1341.12 | |
Geometric mean | 4980.23 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 1.52607e+007 | |
Standard deviation | 3906.5 | |
Expected value | 6766.5 | |
Skewness | 0 | |
Kurtosis | -1.20027 |
Column | Property | Value |
---|---|---|
CurrencyRateDate, datetime | Total values | 13532 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2002-12-18 | |
Maximum value | 2004-07-01 | |
Median | 2002-12-16 |
Column | Property | Value |
---|---|---|
AverageRate, money | Total values | 13532 |
Range | 1499.4 [0.6046;1500] | |
Interquartile range | 7.2186 | |
Arithmetic mean | 79.2363 | |
Arithmetic mean absolute deviation | 126.946 | |
Median value | 1.9816 | |
Median absolute deviation | 77.473 | |
Harmonic mean | 1.89959 | |
Geometric mean | 4.82041 | |
Mode value(s) | 1.0000 | |
Variance | 55185.5 | |
Standard deviation | 234.916 | |
Expected value | 79.2363 | |
Skewness | 48499.1 | |
Kurtosis | 13.0754 |
Column | Property | Value |
---|---|---|
EndOfDayRate, money | Total values | 13532 |
Range | 1499.35 [0.6041;1499.95] | |
Interquartile range | 7.2189 | |
Arithmetic mean | 79.2363 | |
Arithmetic mean absolute deviation | 126.942 | |
Median value | 1.982 | |
Median absolute deviation | 77.4615 | |
Harmonic mean | 1.89958 | |
Geometric mean | 4.82041 | |
Mode value(s) | 1.0000 | |
Variance | 55185.3 | |
Standard deviation | 234.915 | |
Expected value | 79.2363 | |
Skewness | 48499 | |
Kurtosis | 13.0753 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 13532 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2003-01-19 | |
Maximum value | 2004-07-01 | |
Median | 2003-02-02 |
Column | Property | Value |
---|---|---|
CustomerID, int identity | Total values | 19185 |
Range | 29482 [1;29483] | |
Interquartile range | 9593 [15095;24688] | |
Arithmetic mean | 19514.7 | |
Arithmetic mean absolute deviation | 5179.42 | |
Median value | 19891 | |
Median absolute deviation | 5172.53 | |
Harmonic mean | 2363.73 | |
Geometric mean | 16655.3 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 4.13626e+007 | |
Standard deviation | 6431.38 | |
Expected value | 19514.7 | |
Skewness | -14211.9 | |
Kurtosis | 0.755039 |
Column | Property | Value |
---|---|---|
TerritoryID, int | Total values | 19185 |
Range | 9 [1;10] | |
Interquartile range | 5 [4;9] | |
Arithmetic mean | 5.85937 | |
Arithmetic mean absolute deviation | 2.2331 | |
Median value | 6 | |
Median absolute deviation | 2.66291 | |
Harmonic mean | 3.1844 | |
Geometric mean | 4.65558 | |
Mode value(s) | 4 | |
Variance | 9.30914 | |
Standard deviation | 3.05109 | |
Expected value | 5.85937 | |
Skewness | -5529.21 | |
Kurtosis | -1.22164 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 19185 |
Minimum value | 2004-10-13 | |
Arithmetic mean | 2004-10-13 | |
Maximum value | 2004-10-13 | |
Median | 2004-10-13 |
Column | Property | Value |
---|---|---|
CustomerID, int | Total values | 19220 |
Range | 29482 [1;29483] | |
Interquartile range | 9597 [15087;24684] | |
Arithmetic mean | 19502.4 | |
Arithmetic mean absolute deviation | 5186.91 | |
Median value | 19881.5 | |
Median absolute deviation | 5179.44 | |
Harmonic mean | 2147.79 | |
Geometric mean | 16608.5 | |
Mode value(s) | 2, 4, 19, 130, 222, 254, 278, 325, 473, 570... | |
Variance | 4.15303e+007 | |
Standard deviation | 6444.4 | |
Expected value | 19502.4 | |
Skewness | -14310.4 | |
Kurtosis | 0.758672 |
Column | Property | Value |
---|---|---|
AddressID, int | Total values | 19220 |
Range | 29874 [9;29883] | |
Interquartile range | 9610 [15469;25079] | |
Arithmetic mean | 19882.3 | |
Arithmetic mean absolute deviation | 5203.61 | |
Median value | 20273.5 | |
Median absolute deviation | 5195.66 | |
Harmonic mean | 6696.7 | |
Geometric mean | 17498 | |
Mode value(s) | 832, 297, 833, 559, 560, 11380, 988, 989, 990, 908... | |
Variance | 4.18944e+007 | |
Standard deviation | 6472.59 | |
Expected value | 19882.3 | |
Skewness | -14485.2 | |
Kurtosis | 0.768928 |
Column | Property | Value |
---|---|---|
AddressTypeID, int | Total values | 19220 |
Range | 3 [2;5] | |
Interquartile range | 0 [2;2] | |
Arithmetic mean | 2.04194 | |
Arithmetic mean absolute deviation | 0.00364204 | |
Median value | 2 | |
Median absolute deviation | 0.0419355 | |
Harmonic mean | 2.02686 | |
Geometric mean | 2.03319 | |
Mode value(s) | 2 | |
Variance | 0.0511057 | |
Standard deviation | 0.226066 | |
Expected value | 2.04194 | |
Skewness | 131653 | |
Kurtosis | 62.15 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 19220 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2003-08-05 | |
Maximum value | 2004-08-00 | |
Median | 2003-10-26 |
Column | Property | Value |
---|---|---|
CustomerID, int | Total values | 18484 |
Range | 18483 [11000;29483] | |
Interquartile range | 9242 [15621;24863] | |
Arithmetic mean | 20241.5 | |
Arithmetic mean absolute deviation | 4620.5 | |
Median value | 20241.5 | |
Median absolute deviation | 4620.5 | |
Harmonic mean | 18746.8 | |
Geometric mean | 19503 | |
Mode value(s) | 26792, 26793, 26794, 26795, 26796, 26797, 26798, 26799, 26800, 26801... | |
Variance | 2.84731e+007 | |
Standard deviation | 5336.02 | |
Expected value | 20241.5 | |
Skewness | -8.22733e-013 | |
Kurtosis | -1.20019 |
Column | Property | Value |
---|---|---|
ContactID, int | Total values | 18484 |
Range | 19272 [705;19977] | |
Interquartile range | 9242 [6115;15357] | |
Arithmetic mean | 10731.8 | |
Arithmetic mean absolute deviation | 4624.17 | |
Median value | 10735.5 | |
Median absolute deviation | 4624.17 | |
Harmonic mean | 6968.06 | |
Geometric mean | 9032.28 | |
Mode value(s) | 18359, 15575, 8221, 4579, 4077, 10388, 3202, 5772, 10861, 12886... | |
Variance | 2.85435e+007 | |
Standard deviation | 5342.61 | |
Expected value | 10731.8 | |
Skewness | -84.8248 | |
Kurtosis | -1.19314 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 18484 |
Minimum value | 2004-10-19 | |
Arithmetic mean | 2004-10-19 | |
Maximum value | 2004-10-19 | |
Median | 2004-10-19 |
Column | Property | Value |
---|---|---|
SalesOrderID, int | Total values | 121317 |
Range | 31464 [43659;75123] | |
Interquartile range | 15606 [49884;65490] | |
Arithmetic mean | 57827.4 | |
Arithmetic mean absolute deviation | 7860.84 | |
Median value | 57029 | |
Median absolute deviation | 7822.33 | |
Harmonic mean | 56451.9 | |
Geometric mean | 57132.9 | |
Mode value(s) | 51721, 51739 | |
Variance | 8.11647e+007 | |
Standard deviation | 9009.15 | |
Expected value | 57827.4 | |
Skewness | 29698.3 | |
Kurtosis | -1.20654 |
Column | Property | Value |
---|---|---|
SalesOrderDetailID, int identity | Total values | 121317 |
Range | 121316 [1;121317] | |
Interquartile range | 60659 [30330;90989] | |
Arithmetic mean | 60659 | |
Arithmetic mean absolute deviation | 30329.2 | |
Median value | 60659 | |
Median absolute deviation | 30329.2 | |
Harmonic mean | 9876.51 | |
Geometric mean | 44632.5 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 1.22649e+009 | |
Standard deviation | 35021.3 | |
Expected value | 60659 | |
Skewness | -2.78441e-010 | |
Kurtosis | -1.20003 |
Column | Property | Value |
---|---|---|
OrderQty, smallint | Total values | 121317 |
Range | 43 [1;44] | |
Interquartile range | 2 [1;3] | |
Arithmetic mean | 2.26608 | |
Arithmetic mean absolute deviation | 1.23664 | |
Median value | 1 | |
Median absolute deviation | 1.26608 | |
Harmonic mean | 1.35603 | |
Geometric mean | 1.63799 | |
Mode value(s) | 1 | |
Variance | 6.20669 | |
Standard deviation | 2.49132 | |
Expected value | 2.26608 | |
Skewness | 445772 | |
Kurtosis | 21.8991 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 121317 |
Range | 292 [707;999] | |
Interquartile range | 153 [768;921] | |
Arithmetic mean | 841.681 | |
Arithmetic mean absolute deviation | 75.0295 | |
Median value | 863 | |
Median absolute deviation | 74.0324 | |
Harmonic mean | 832.682 | |
Geometric mean | 837.196 | |
Mode value(s) | 870 | |
Variance | 7473.97 | |
Standard deviation | 86.4521 | |
Expected value | 841.681 | |
Skewness | -5346.39 | |
Kurtosis | -1.16552 |
Column | Property | Value |
---|---|---|
SpecialOfferID, int | Total values | 121317 |
Range | 15 [1;16] | |
Interquartile range | 0 [1;1] | |
Arithmetic mean | 1.16254 | |
Arithmetic mean absolute deviation | 0.117758 | |
Median value | 1 | |
Median absolute deviation | 0.162541 | |
Harmonic mean | 1.02868 | |
Geometric mean | 1.05433 | |
Mode value(s) | 1 | |
Variance | 1.485 | |
Standard deviation | 1.2186 | |
Expected value | 1.16254 | |
Skewness | 1.1674e+006 | |
Kurtosis | 96.0948 |
Column | Property | Value |
---|---|---|
UnitPrice, money | Total values | 121317 |
Range | 3576.94 [1.3282;3578.27] | |
Interquartile range | 580.856 | |
Arithmetic mean | 465.093 | |
Arithmetic mean absolute deviation | 545.895 | |
Median value | 49.99 | |
Median absolute deviation | 444.526 | |
Harmonic mean | 17.7198 | |
Geometric mean | 87.181 | |
Mode value(s) | 4.9900 | |
Variance | 565331 | |
Standard deviation | 751.885 | |
Expected value | 465.093 | |
Skewness | 252810 | |
Kurtosis | 4.05342 |
Column | Property | Value |
---|---|---|
UnitPriceDiscount, money | Total values | 121317 |
Range | 0.4 [0;0.4] | |
Interquartile range | 0 | |
Arithmetic mean | 0.00282607 | |
Arithmetic mean absolute deviation | 0 | |
Median value | 0 | |
Median absolute deviation | 0 | |
Mode value(s) | .0000 | |
Variance | 0.000615563 | |
Standard deviation | 0.0248105 | |
Expected value | 0.00282607 | |
Skewness | 1.4277e+006 | |
Kurtosis | 156.158 |
Column | Property | Value |
---|---|---|
LineTotal, numeric | Total values | 121317 |
Range | 27892.2 [1.374;27893.6] | |
Interquartile range | 1095.5 | |
Arithmetic mean | 905.449 | |
Arithmetic mean absolute deviation | 1076.22 | |
Median value | 134.982 | |
Median absolute deviation | 872.768 | |
Harmonic mean | 20.6969 | |
Geometric mean | 142.343 | |
Mode value(s) | 4.990000 | |
Variance | 2.86766e+006 | |
Standard deviation | 1693.42 | |
Expected value | 905.449 | |
Skewness | 479484 | |
Kurtosis | 24.2429 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 121317 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2003-08-16 | |
Maximum value | 2004-08-00 | |
Median | 2003-11-01 |
Column | Property | Value |
---|---|---|
SalesOrderID, int identity | Total values | 31465 |
Range | 31464 [43659;75123] | |
Interquartile range | 15733 [51525;67258] | |
Arithmetic mean | 59391 | |
Arithmetic mean absolute deviation | 7866.25 | |
Median value | 59391 | |
Median absolute deviation | 7866.25 | |
Harmonic mean | 57974.8 | |
Geometric mean | 58685.5 | |
Mode value(s) | 43659, 43660, 43661, 43662, 43663, 43664, 43665, 43666, 43667, 43668... | |
Variance | 8.25065e+007 | |
Standard deviation | 9083.31 | |
Expected value | 59391 | |
Skewness | 0 | |
Kurtosis | -1.20011 |
Column | Property | Value |
---|---|---|
RevisionNumber, tinyint | Total values | 31465 |
Range | 1 [1;2] | |
Interquartile range | 0 [1;1] | |
Arithmetic mean | 1.00095 | |
Arithmetic mean absolute deviation | 0 | |
Median value | 1 | |
Median absolute deviation | 0.00095344 | |
Harmonic mean | 1.00048 | |
Geometric mean | 1.00066 | |
Mode value(s) | 1 | |
Variance | 0.000952562 | |
Standard deviation | 0.0308636 | |
Expected value | 1.00095 | |
Skewness | 1.01751e+006 | |
Kurtosis | 1043.77 |
Column | Property | Value |
---|---|---|
OrderDate, datetime | Total values | 31465 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2003-09-22 | |
Maximum value | 2004-08-00 | |
Median | 2003-12-05 |
Column | Property | Value |
---|---|---|
DueDate, datetime | Total values | 31465 |
Minimum value | 2001-07-13 | |
Arithmetic mean | 2003-10-04 | |
Maximum value | 2004-08-12 | |
Median | 2003-12-17 |
Column | Property | Value |
---|---|---|
ShipDate, datetime | Total values | 31465 |
Minimum value | 2001-07-08 | |
Arithmetic mean | 2003-09-29 | |
Maximum value | 2004-08-07 | |
Median | 2003-12-12 |
Column | Property | Value |
---|---|---|
Status, tinyint | Total values | 31465 |
Range | 0 [5;5] | |
Interquartile range | 0 [5;5] | |
Arithmetic mean | 5 | |
Arithmetic mean absolute deviation | 0 | |
Median value | 5 | |
Median absolute deviation | 0 | |
Harmonic mean | 5 | |
Geometric mean | 5 | |
Mode value(s) | 5 | |
Variance | 0 | |
Standard deviation | 0 | |
Expected value | 5 |
Column | Property | Value |
---|---|---|
CustomerID, int | Total values | 31465 |
Range | 29482 [1;29483] | |
Interquartile range | 10243 [12484;22727] | |
Arithmetic mean | 16608.1 | |
Arithmetic mean absolute deviation | 6231.97 | |
Median value | 16785 | |
Median absolute deviation | 6230.98 | |
Harmonic mean | 708.211 | |
Geometric mean | 10758.3 | |
Mode value(s) | 11091, 11176 | |
Variance | 6.28515e+007 | |
Standard deviation | 7927.9 | |
Expected value | 16608.1 | |
Skewness | -18279.7 | |
Kurtosis | -0.18245 |
Column | Property | Value |
---|---|---|
ContactID, int | Total values | 31465 |
Range | 19976 [1;19977] | |
Interquartile range | 10594 [4179;14773] | |
Arithmetic mean | 9503.67 | |
Arithmetic mean absolute deviation | 5272.41 | |
Median value | 9538 | |
Median absolute deviation | 5272.85 | |
Harmonic mean | 660.294 | |
Geometric mean | 5890.14 | |
Mode value(s) | 3715, 15194 | |
Variance | 3.67961e+007 | |
Standard deviation | 6065.98 | |
Expected value | 9503.67 | |
Skewness | 333.351 | |
Kurtosis | -1.23697 |
Column | Property | Value |
---|---|---|
SalesPersonID, int | Total values | 3806 |
Range | 22 [268;290] | |
Interquartile range | 7 [277;284] | |
Arithmetic mean | 33.8958 | |
Arithmetic mean absolute deviation | 246.224 | |
Median value | 279 | |
Median absolute deviation | 3.72596 | |
Harmonic mean | 280.151 | |
Geometric mean | 280.187 | |
Mode value(s) | 277 | |
Variance | 60713.9 | |
Standard deviation | 246.402 | |
Expected value | 280.224 | |
Skewness | 3806.44 | |
Kurtosis | -1.99916 |
Column | Property | Value |
---|---|---|
TerritoryID, int | Total values | 31465 |
Range | 9 [1;10] | |
Interquartile range | 5 [4;9] | |
Arithmetic mean | 6.09077 | |
Arithmetic mean absolute deviation | 2.04777 | |
Median value | 6 | |
Median absolute deviation | 2.53583 | |
Harmonic mean | 3.4879 | |
Geometric mean | 4.97227 | |
Mode value(s) | 9 | |
Variance | 8.75047 | |
Standard deviation | 2.95812 | |
Expected value | 6.09077 | |
Skewness | -12285.6 | |
Kurtosis | -1.08349 |
Column | Property | Value |
---|---|---|
BillToAddressID, int | Total values | 31465 |
Range | 29478 [405;29883] | |
Interquartile range | 10599 [14080;24679] | |
Arithmetic mean | 18263.2 | |
Arithmetic mean absolute deviation | 6485.57 | |
Median value | 19449 | |
Median absolute deviation | 6420.36 | |
Harmonic mean | 4599.27 | |
Geometric mean | 13373.6 | |
Mode value(s) | 13550, 25073 | |
Variance | 6.74052e+007 | |
Standard deviation | 8210.07 | |
Expected value | 18263.2 | |
Skewness | -25926.2 | |
Kurtosis | -0.017815 |
Column | Property | Value |
---|---|---|
ShipToAddressID, int | Total values | 31465 |
Range | 29874 [9;29883] | |
Interquartile range | 10609 [14063;24672] | |
Arithmetic mean | 18249.2 | |
Arithmetic mean absolute deviation | 6492.98 | |
Median value | 19438 | |
Median absolute deviation | 6427.48 | |
Harmonic mean | 3329.45 | |
Geometric mean | 13267.9 | |
Mode value(s) | 13550, 25073 | |
Variance | 6.75426e+007 | |
Standard deviation | 8218.43 | |
Expected value | 18249.2 | |
Skewness | -25897.7 | |
Kurtosis | -0.0215958 |
Column | Property | Value |
---|---|---|
ShipMethodID, int | Total values | 31465 |
Range | 4 [1;5] | |
Interquartile range | 0 [1;1] | |
Arithmetic mean | 1.48384 | |
Arithmetic mean absolute deviation | 0.362879 | |
Median value | 1 | |
Median absolute deviation | 0.483839 | |
Harmonic mean | 1.10714 | |
Geometric mean | 1.21492 | |
Mode value(s) | 1 | |
Variance | 1.70131 | |
Standard deviation | 1.30434 | |
Expected value | 1.48384 | |
Skewness | 73147.2 | |
Kurtosis | 3.40441 |
Column | Property | Value |
---|---|---|
CreditCardID, int | Total values | 30334 |
Range | 19236 [1;19237] | |
Interquartile range | 9617 [4894;14511] | |
Arithmetic mean | 9336.01 | |
Arithmetic mean absolute deviation | 4828.62 | |
Median value | 9719.5 | |
Median absolute deviation | 4821.55 | |
Harmonic mean | 1621.32 | |
Geometric mean | 7130.98 | |
Mode value(s) | 11334, 11843 | |
Variance | 3.11049e+007 | |
Standard deviation | 5577.17 | |
Expected value | 9684.1 | |
Skewness | 5391.5 | |
Kurtosis | -1.19414 |
Column | Property | Value |
---|---|---|
CurrencyRateID, int | Total values | 13976 |
Range | 12429 [2;12431] | |
Interquartile range | 2772 [8510;11282] | |
Arithmetic mean | 4082.64 | |
Arithmetic mean absolute deviation | 5482.16 | |
Median value | 10074 | |
Median absolute deviation | 2077.68 | |
Harmonic mean | 2511.7 | |
Geometric mean | 8166.23 | |
Mode value(s) | 9755 | |
Variance | 3.47763e+007 | |
Standard deviation | 5897.14 | |
Expected value | 9191.5 | |
Skewness | 15735.2 | |
Kurtosis | -1.65224 |
Column | Property | Value |
---|---|---|
SubTotal, money | Total values | 31465 |
Range | 224355 [1.374;224356] | |
Interquartile range | 2313 | |
Arithmetic mean | 4046.95 | |
Arithmetic mean absolute deviation | 5478.09 | |
Median value | 782.99 | |
Median absolute deviation | 3887.38 | |
Harmonic mean | 53.1472 | |
Geometric mean | 434.982 | |
Mode value(s) | 3578.2700 | |
Variance | 1.8396e+008 | |
Standard deviation | 13563.2 | |
Expected value | 4046.95 | |
Skewness | 185900 | |
Kurtosis | 42.102 |
Column | Property | Value |
---|---|---|
TaxAmt, money | Total values | 31465 |
Range | 17948.4 [0.1099;17948.5] | |
Interquartile range | 185.04 | |
Arithmetic mean | 323.756 | |
Arithmetic mean absolute deviation | 437.814 | |
Median value | 62.6392 | |
Median absolute deviation | 310.523 | |
Harmonic mean | 4.25177 | |
Geometric mean | 34.7985 | |
Mode value(s) | 286.2616 | |
Variance | 1.17734e+006 | |
Standard deviation | 1085.05 | |
Expected value | 323.756 | |
Skewness | 185900 | |
Kurtosis | 42.102 |
Column | Property | Value |
---|---|---|
Freight, money | Total values | 31465 |
Range | 5608.88 [0.0344;5608.91] | |
Interquartile range | 57.825 | |
Arithmetic mean | 101.174 | |
Arithmetic mean absolute deviation | 136.47 | |
Median value | 19.5748 | |
Median absolute deviation | 96.6556 | |
Harmonic mean | 1.32897 | |
Geometric mean | 10.8748 | |
Mode value(s) | 89.4568 | |
Variance | 114975 | |
Standard deviation | 339.079 | |
Expected value | 101.174 | |
Skewness | 185900 | |
Kurtosis | 42.102 |
Column | Property | Value |
---|---|---|
TotalDue, money | Total values | 31465 |
Range | 247912 [1.5183;247914] | |
Interquartile range | 2555.86 | |
Arithmetic mean | 4471.88 | |
Arithmetic mean absolute deviation | 6053.54 | |
Median value | 865.204 | |
Median absolute deviation | 4295.45 | |
Harmonic mean | 58.7279 | |
Geometric mean | 480.655 | |
Mode value(s) | 3953.9884 | |
Variance | 2.24619e+008 | |
Standard deviation | 14987.3 | |
Expected value | 4471.88 | |
Skewness | 185900 | |
Kurtosis | 42.102 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 31465 |
Minimum value | 2001-07-08 | |
Arithmetic mean | 2003-09-29 | |
Maximum value | 2004-08-07 | |
Median | 2003-12-12 |
Column | Property | Value |
---|---|---|
SalesOrderID, int | Total values | 27647 |
Range | 31426 [43697;75123] | |
Interquartile range | 14284 [53756;68040] | |
Arithmetic mean | 60458.9 | |
Arithmetic mean absolute deviation | 7605.01 | |
Median value | 60852 | |
Median absolute deviation | 7599.81 | |
Harmonic mean | 59064.6 | |
Geometric mean | 59772.2 | |
Mode value(s) | 51214, 51298, 51303, 51314, 51319, 51452, 51580, 51666, 52275, 52465... | |
Variance | 8.01071e+007 | |
Standard deviation | 8950.26 | |
Expected value | 60458.9 | |
Skewness | -5273.22 | |
Kurtosis | -1.02645 |
Column | Property | Value |
---|---|---|
SalesReasonID, int | Total values | 27647 |
Range | 9 [1;10] | |
Interquartile range | 1 [1;2] | |
Arithmetic mean | 2.58618 | |
Arithmetic mean absolute deviation | 1.60932 | |
Median value | 1 | |
Median absolute deviation | 1.58618 | |
Harmonic mean | 1.3633 | |
Geometric mean | 1.72651 | |
Mode value(s) | 1 | |
Variance | 7.66022 | |
Standard deviation | 2.76771 | |
Expected value | 2.58618 | |
Skewness | 46383 | |
Kurtosis | 1.42672 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 27647 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2003-10-15 | |
Maximum value | 2004-08-00 | |
Median | 2003-12-27 |
Column | Property | Value |
---|---|---|
SalesPersonID, int | Total values | 17 |
Range | 22 [268;290] | |
Interquartile range | 9 [278;287] | |
Arithmetic mean | 281.647 | |
Arithmetic mean absolute deviation | 4.11765 | |
Median value | 282 | |
Median absolute deviation | 4.58824 | |
Harmonic mean | 281.533 | |
Geometric mean | 281.59 | |
Mode value(s) | 268, 275, 276, 277, 278, 279, 280, 281, 282, 283... | |
Variance | 33.6176 | |
Standard deviation | 5.79807 | |
Expected value | 281.647 | |
Skewness | -8.5253 | |
Kurtosis | -0.443551 |
Column | Property | Value |
---|---|---|
TerritoryID, int | Total values | 14 |
Range | 9 [1;10] | |
Interquartile range | 6 [2;8] | |
Arithmetic mean | 3.94118 | |
Arithmetic mean absolute deviation | 2.14286 | |
Median value | 4.5 | |
Median absolute deviation | 2 | |
Harmonic mean | 2.61896 | |
Geometric mean | 3.69097 | |
Mode value(s) | 1 | |
Variance | 9.8725 | |
Standard deviation | 3.14205 | |
Expected value | 4.78571 | |
Skewness | 12.2995 | |
Kurtosis | -1.06665 |
Column | Property | Value |
---|---|---|
SalesQuota, money | Total values | 14 |
Range | 50000 [250000;300000] | |
Interquartile range | 50000 | |
Arithmetic mean | 214706 | |
Arithmetic mean absolute deviation | 46008.3 | |
Median value | 250000 | |
Median absolute deviation | 10714.3 | |
Harmonic mean | 259259 | |
Geometric mean | 259961 | |
Mode value(s) | 250000.0000 | |
Variance | 2.7329e+009 | |
Standard deviation | 52277.1 | |
Expected value | 260714 | |
Skewness | 16.415 | |
Kurtosis | -1.31823 |
Column | Property | Value |
---|---|---|
Bonus, money | Total values | 17 |
Range | 6700 [0;6700] | |
Interquartile range | 4500 | |
Arithmetic mean | 2859.41 | |
Arithmetic mean absolute deviation | 1977.76 | |
Median value | 3500 | |
Median absolute deviation | 1940.59 | |
Mode value(s) | .0000 | |
Variance | 5.16796e+006 | |
Standard deviation | 2273.31 | |
Expected value | 2859.41 | |
Skewness | 0.12918 | |
Kurtosis | -1.55468 |
Column | Property | Value |
---|---|---|
CommissionPct, smallmoney | Total values | 17 |
Range | 0.02 [0;0.02] | |
Interquartile range | 0.008 | |
Arithmetic mean | 0.0117647 | |
Arithmetic mean absolute deviation | 0 | |
Median value | 0.012 | |
Median absolute deviation | 0 | |
Mode value(s) | .0100 | |
Variance | 4.21912e-005 | |
Standard deviation | 0.00649547 | |
Expected value | 0.0117647 | |
Skewness | -12.068 | |
Kurtosis | -0.735647 |
Column | Property | Value |
---|---|---|
SalesYTD, money | Total values | 17 |
Range | 5.20048e+006 [0;5.20048e+006] | |
Interquartile range | 2.09878e+006 | |
Arithmetic mean | 2.60553e+006 | |
Arithmetic mean absolute deviation | 1.36647e+006 | |
Median value | 2.81101e+006 | |
Median absolute deviation | 1.35438e+006 | |
Mode value(s) | 677558.4653, 4557045.0459, 5200475.2313, 3857163.6332, 1764938.9859, 2811012.7151, .0000, 3018725.4858, 3189356.2465, 3587378.4257... | |
Variance | 2.6887e+012 | |
Standard deviation | 1.63972e+006 | |
Expected value | 2.60553e+006 | |
Skewness | -0.843511 | |
Kurtosis | -1.30779 |
Column | Property | Value |
---|---|---|
SalesLastYear, money | Total values | 17 |
Range | 2.39654e+006 [0;2.39654e+006] | |
Interquartile range | 730285 | |
Arithmetic mean | 1.39329e+006 | |
Arithmetic mean absolute deviation | 668254 | |
Median value | 1.63582e+006 | |
Median absolute deviation | 621888 | |
Mode value(s) | .0000 | |
Variance | 7.21216e+011 | |
Standard deviation | 849244 | |
Expected value | 1.39329e+006 | |
Skewness | -13.0519 | |
Kurtosis | -1.03584 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 17 |
Minimum value | 2001-01-28 | |
Arithmetic mean | 2002-01-16 | |
Maximum value | 2003-06-24 | |
Median | 2001-06-24 |
Column | Property | Value |
---|---|---|
SalesPersonID, int | Total values | 163 |
Range | 22 [268;290] | |
Interquartile range | 7 [277;284] | |
Arithmetic mean | 280.153 | |
Arithmetic mean absolute deviation | 3.64417 | |
Median value | 280 | |
Median absolute deviation | 4.12883 | |
Harmonic mean | 280.054 | |
Geometric mean | 280.104 | |
Mode value(s) | 268, 275, 276, 277, 278, 279, 280, 281, 282, 283... | |
Variance | 27.7232 | |
Standard deviation | 5.26529 | |
Expected value | 280.153 | |
Skewness | -71.6998 | |
Kurtosis | 0.068321 |
Column | Property | Value |
---|---|---|
QuotaDate, datetime | Total values | 163 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2003-01-18 | |
Maximum value | 2004-04-01 | |
Median | 2003-04-01 |
Column | Property | Value |
---|---|---|
SalesQuota, money | Total values | 163 |
Range | 1.897e+006 [1000;1.898e+006] | |
Interquartile range | 565000 | |
Arithmetic mean | 587202 | |
Arithmetic mean absolute deviation | 317750 | |
Median value | 507000 | |
Median absolute deviation | 311515 | |
Harmonic mean | 85649.1 | |
Geometric mean | 412347 | |
Mode value(s) | 7000.0000, 116000.0000, 341000.0000, 280000.0000, 390000.0000, 226000.0000, 583000.0000, 707000.0000, 1262000.0000 | |
Variance | 1.58763e+011 | |
Standard deviation | 398451 | |
Expected value | 587202 | |
Skewness | 129.64 | |
Kurtosis | 0.109684 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 163 |
Minimum value | 2001-05-17 | |
Arithmetic mean | 2002-12-04 | |
Maximum value | 2004-02-16 | |
Median | 2003-02-15 |
Column | Property | Value |
---|---|---|
SalesReasonID, int identity | Total values | 10 |
Range | 9 [1;10] | |
Interquartile range | 6 [3;9] | |
Arithmetic mean | 5.5 | |
Arithmetic mean absolute deviation | 2 | |
Median value | 5.5 | |
Median absolute deviation | 2 | |
Harmonic mean | 3.41417 | |
Geometric mean | 4.52873 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 9.16667 | |
Standard deviation | 3.02765 | |
Expected value | 5.5 | |
Skewness | 0 | |
Kurtosis | -1.56164 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 10 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
SalesTaxRateID, int identity | Total values | 29 |
Range | 30 [1;31] | |
Interquartile range | 17 [8;25] | |
Arithmetic mean | 16.1034 | |
Arithmetic mean absolute deviation | 7.65517 | |
Median value | 17 | |
Median absolute deviation | 8.13793 | |
Harmonic mean | 7.45664 | |
Geometric mean | 12.2859 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 88.3818 | |
Standard deviation | 9.40116 | |
Expected value | 16.1034 | |
Skewness | -0.913524 | |
Kurtosis | -1.42509 |
Column | Property | Value |
---|---|---|
StateProvinceID, int | Total values | 29 |
Range | 83 [1;84] | |
Interquartile range | 52 [20;72] | |
Arithmetic mean | 43.8276 | |
Arithmetic mean absolute deviation | 22.8621 | |
Median value | 45 | |
Median absolute deviation | 23.3103 | |
Harmonic mean | 9.59056 | |
Geometric mean | 29.3541 | |
Mode value(s) | 1, 57, 63 | |
Variance | 732.719 | |
Standard deviation | 27.0688 | |
Expected value | 43.8276 | |
Skewness | -3.12199 | |
Kurtosis | -1.41793 |
Column | Property | Value |
---|---|---|
TaxType, tinyint | Total values | 29 |
Range | 2 [1;3] | |
Interquartile range | 2 [1;3] | |
Arithmetic mean | 2 | |
Arithmetic mean absolute deviation | 0.896552 | |
Median value | 2 | |
Median absolute deviation | 0.896552 | |
Harmonic mean | 1.53982 | |
Geometric mean | 1.75802 | |
Mode value(s) | 1, 3 | |
Variance | 0.928571 | |
Standard deviation | 0.963624 | |
Expected value | 2 | |
Skewness | 0 | |
Kurtosis | -1.96021 |
Column | Property | Value |
---|---|---|
TaxRate, smallmoney | Total values | 29 |
Range | 14.6 [5;19.6] | |
Interquartile range | 3 | |
Arithmetic mean | 9.09138 | |
Arithmetic mean absolute deviation | 2.58621 | |
Median value | 7 | |
Median absolute deviation | 2.06897 | |
Harmonic mean | 8.10309 | |
Geometric mean | 8.51972 | |
Mode value(s) | 7.0000 | |
Variance | 14.2355 | |
Standard deviation | 3.773 | |
Expected value | 9.09138 | |
Skewness | 42.0362 | |
Kurtosis | 0.754186 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 29 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
TerritoryID, int identity | Total values | 10 |
Range | 9 [1;10] | |
Interquartile range | 6 [3;9] | |
Arithmetic mean | 5.5 | |
Arithmetic mean absolute deviation | 2 | |
Median value | 5.5 | |
Median absolute deviation | 2 | |
Harmonic mean | 3.41417 | |
Geometric mean | 4.52873 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 9.16667 | |
Standard deviation | 3.02765 | |
Expected value | 5.5 | |
Skewness | 0 | |
Kurtosis | -1.56164 |
Column | Property | Value |
---|---|---|
SalesYTD, money | Total values | 10 |
Range | 6.37382e+006 [1.97747e+006;8.3513e+006] | |
Interquartile range | 4.06585e+006 | |
Arithmetic mean | 4.4294e+006 | |
Arithmetic mean absolute deviation | 1.59908e+006 | |
Median value | 3.8781e+006 | |
Median absolute deviation | 1.49301e+006 | |
Harmonic mean | 3.68841e+006 | |
Geometric mean | 4.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... | |
Variance | 4.12949e+012 | |
Standard deviation | 2.03211e+006 | |
Expected value | 4.4294e+006 | |
Skewness | 6.07331 | |
Kurtosis | -1.03115 |
Column | Property | Value |
---|---|---|
SalesLastYear, money | Total values | 10 |
Range | 4.38604e+006 [1.30795e+006;5.69399e+006] | |
Interquartile range | 3.08803e+006 | |
Arithmetic mean | 3.27154e+006 | |
Arithmetic mean absolute deviation | 1.10676e+006 | |
Median value | 3.25185e+006 | |
Median absolute deviation | 1.10676e+006 | |
Harmonic mean | 2.67299e+006 | |
Geometric mean | 2.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... | |
Variance | 2.12058e+012 | |
Standard deviation | 1.45622e+006 | |
Expected value | 3.27154e+006 | |
Skewness | 3.28086 | |
Kurtosis | -1.27702 |
Column | Property | Value |
---|---|---|
CostYTD, money | Total values | 10 |
Range | 0 [0;0] | |
Interquartile range | 0 | |
Arithmetic mean | 0 | |
Arithmetic mean absolute deviation | 0 | |
Median value | 0 | |
Median absolute deviation | 0 | |
Mode value(s) | .0000 | |
Variance | 0 | |
Standard deviation | 0 | |
Expected value | 0 |
Column | Property | Value |
---|---|---|
CostLastYear, money | Total values | 10 |
Range | 0 [0;0] | |
Interquartile range | 0 | |
Arithmetic mean | 0 | |
Arithmetic mean absolute deviation | 0 | |
Median value | 0 | |
Median absolute deviation | 0 | |
Mode value(s) | .0000 | |
Variance | 0 | |
Standard deviation | 0 | |
Expected value | 0 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 10 |
Minimum value | 1998-06-01 | |
Arithmetic mean | 1998-06-01 | |
Maximum value | 1998-06-01 | |
Median | 1998-06-01 |
Column | Property | Value |
---|---|---|
SalesPersonID, int | Total values | 17 |
Range | 15 [275;290] | |
Interquartile range | 9 [277;286] | |
Arithmetic mean | 281.294 | |
Arithmetic mean absolute deviation | 3.47059 | |
Median value | 281 | |
Median absolute deviation | 3.94118 | |
Harmonic mean | 281.217 | |
Geometric mean | 281.256 | |
Mode value(s) | 275, 277, 282 | |
Variance | 23.0956 | |
Standard deviation | 4.80579 | |
Expected value | 281.294 | |
Skewness | 5.48246 | |
Kurtosis | -1.26077 |
Column | Property | Value |
---|---|---|
TerritoryID, int | Total values | 17 |
Range | 9 [1;10] | |
Interquartile range | 5 [2;7] | |
Arithmetic mean | 4.58824 | |
Arithmetic mean absolute deviation | 1.88235 | |
Median value | 4 | |
Median absolute deviation | 2.35294 | |
Harmonic mean | 2.67901 | |
Geometric mean | 3.61913 | |
Mode value(s) | 6, 1 | |
Variance | 8.13235 | |
Standard deviation | 2.85173 | |
Expected value | 4.58824 | |
Skewness | 5.38653 | |
Kurtosis | -1.2052 |
Column | Property | Value |
---|---|---|
StartDate, datetime | Total values | 17 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2002-03-01 | |
Maximum value | 2003-07-01 | |
Median | 2001-07-01 |
Column | Property | Value |
---|---|---|
EndDate, datetime | Total values | 4 |
Minimum value | 2002-07-00 | |
Arithmetic mean | 2002-10-30 | |
Maximum value | 2003-01-00 | |
Median | 2002-12-00 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 17 |
Minimum value | 2001-06-24 | |
Arithmetic mean | 2002-06-17 | |
Maximum value | 2003-06-24 | |
Median | 2002-06-24 |
Column | Property | Value |
---|---|---|
ShoppingCartItemID, int identity | Total values | 3 |
Range | 3 [2;5] | |
Arithmetic mean | 3.66667 | |
Arithmetic mean absolute deviation | 0.666667 | |
Median value | 4 | |
Median absolute deviation | 1 | |
Harmonic mean | 3.15789 | |
Geometric mean | 3.41995 | |
Mode value(s) | 2, 4, 5 | |
Variance | 2.33333 | |
Standard deviation | 1.52753 | |
Expected value | 3.66667 | |
Skewness | -0.62348 | |
Kurtosis | -2.33333 |
Column | Property | Value |
---|---|---|
Quantity, int | Total values | 3 |
Range | 4 [3;7] | |
Arithmetic mean | 4.66667 | |
Arithmetic mean absolute deviation | 1 | |
Median value | 4 | |
Median absolute deviation | 1.33333 | |
Harmonic mean | 4.13115 | |
Geometric mean | 4.37952 | |
Mode value(s) | 3, 4, 7 | |
Variance | 4.33333 | |
Standard deviation | 2.08167 | |
Expected value | 4.66667 | |
Skewness | 0.862229 | |
Kurtosis | -2.33333 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 3 |
Range | 19 [862;881] | |
Arithmetic mean | 872.333 | |
Arithmetic mean absolute deviation | 6.33333 | |
Median value | 874 | |
Median absolute deviation | 6.33333 | |
Harmonic mean | 872.263 | |
Geometric mean | 872.298 | |
Mode value(s) | 862, 881, 874 | |
Variance | 92.3333 | |
Standard deviation | 9.60902 | |
Expected value | 872.333 | |
Skewness | -0.50469 | |
Kurtosis | -2.33333 |
Column | Property | Value |
---|---|---|
DateCreated, datetime | Total values | 3 |
Minimum value | 2003-12-11 | |
Arithmetic mean | 2003-12-11 | |
Maximum value | 2003-12-11 | |
Median | 2003-12-11 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 3 |
Minimum value | 2003-12-11 | |
Arithmetic mean | 2003-12-11 | |
Maximum value | 2003-12-11 | |
Median | 2003-12-11 |
Column | Property | Value |
---|---|---|
SpecialOfferID, int identity | Total values | 16 |
Range | 15 [1;16] | |
Interquartile range | 8 [5;13] | |
Arithmetic mean | 8.5 | |
Arithmetic mean absolute deviation | 3.5 | |
Median value | 8.5 | |
Median absolute deviation | 3.5 | |
Harmonic mean | 4.73271 | |
Geometric mean | 6.80047 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 22.6667 | |
Standard deviation | 4.76095 | |
Expected value | 8.5 | |
Skewness | 0 | |
Kurtosis | -1.42624 |
Column | Property | Value |
---|---|---|
DiscountPct, smallmoney | Total values | 16 |
Range | 0.48 [0.02;0.5] | |
Interquartile range | 0.25 | |
Arithmetic mean | 0.22 | |
Arithmetic mean absolute deviation | 0 | |
Median value | 0.175 | |
Median absolute deviation | 0 | |
Mode value(s) | .1500 | |
Variance | 0.0260667 | |
Standard deviation | 0.161452 | |
Expected value | 0.22 | |
Skewness | 6.31578 | |
Kurtosis | -1.23209 |
Column | Property | Value |
---|---|---|
StartDate, datetime | Total values | 16 |
Minimum value | 2001-06-01 | |
Arithmetic mean | 2002-08-08 | |
Maximum value | 2004-05-01 | |
Median | 2002-07-01 |
Column | Property | Value |
---|---|---|
EndDate, datetime | Total values | 16 |
Minimum value | 2002-07-00 | |
Arithmetic mean | 2003-11-10 | |
Maximum value | 2005-01-00 | |
Median | 2003-10-00 |
Column | Property | Value |
---|---|---|
MinQty, int | Total values | 16 |
Range | 61 [0;61] | |
Interquartile range | 15 [0;15] | |
Arithmetic mean | 9.5625 | |
Arithmetic mean absolute deviation | 12.625 | |
Median value | 0 | |
Median absolute deviation | 9.5625 | |
Mode value(s) | 0 | |
Variance | 327.329 | |
Standard deviation | 18.0922 | |
Expected value | 9.5625 | |
Skewness | 27.2518 | |
Kurtosis | 1.74054 |
Column | Property | Value |
---|---|---|
MaxQty, int | Total values | 4 |
Range | 46 [14;60] | |
Arithmetic mean | 8.625 | |
Arithmetic mean absolute deviation | 25.5 | |
Median value | 32 | |
Median absolute deviation | 15.5 | |
Harmonic mean | 25.8462 | |
Geometric mean | 29.9666 | |
Mode value(s) | 14, 24, 40, 60 | |
Variance | 1296.35 | |
Standard deviation | 36.0049 | |
Expected value | 34.5 | |
Skewness | 3.64806 | |
Kurtosis | -1.81107 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 16 |
Minimum value | 2001-05-02 | |
Arithmetic mean | 2002-07-09 | |
Maximum value | 2004-04-01 | |
Median | 2002-06-01 |
Column | Property | Value |
---|---|---|
SpecialOfferID, int | Total values | 538 |
Range | 15 [1;16] | |
Interquartile range | 1 [1;2] | |
Arithmetic mean | 2.7119 | |
Arithmetic mean absolute deviation | 1.5632 | |
Median value | 1 | |
Median absolute deviation | 1.7119 | |
Harmonic mean | 1.42086 | |
Geometric mean | 1.76821 | |
Mode value(s) | 1 | |
Variance | 12.0975 | |
Standard deviation | 3.47814 | |
Expected value | 2.7119 | |
Skewness | 1388.05 | |
Kurtosis | 5.5861 |
Column | Property | Value |
---|---|---|
ProductID, int | Total values | 538 |
Range | 319 [680;999] | |
Interquartile range | 153 [775;928] | |
Arithmetic mean | 849.47 | |
Arithmetic mean absolute deviation | 74.0855 | |
Median value | 855.5 | |
Median absolute deviation | 73.9368 | |
Harmonic mean | 840.589 | |
Geometric mean | 845.036 | |
Mode value(s) | 707, 708, 711, 863, 869 | |
Variance | 7497.81 | |
Standard deviation | 86.5899 | |
Expected value | 849.47 | |
Skewness | 2.23844 | |
Kurtosis | -1.20294 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 538 |
Minimum value | 2001-05-02 | |
Arithmetic mean | 2001-07-28 | |
Maximum value | 2004-04-01 | |
Median | 2001-05-02 |
Column | Property | Value |
---|---|---|
CustomerID, int | Total values | 701 |
Range | 700 [1;701] | |
Interquartile range | 351 [176;527] | |
Arithmetic mean | 351 | |
Arithmetic mean absolute deviation | 175.25 | |
Median value | 351 | |
Median absolute deviation | 175.25 | |
Harmonic mean | 98.3109 | |
Geometric mean | 259.431 | |
Mode value(s) | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10... | |
Variance | 41008.5 | |
Standard deviation | 202.506 | |
Expected value | 351 | |
Skewness | 0 | |
Kurtosis | -1.20514 |
Column | Property | Value |
---|---|---|
SalesPersonID, int | Total values | 701 |
Range | 15 [275;290] | |
Interquartile range | 6 [277;283] | |
Arithmetic mean | 280.873 | |
Arithmetic mean absolute deviation | 3.02282 | |
Median value | 281 | |
Median absolute deviation | 3.52211 | |
Harmonic mean | 280.806 | |
Geometric mean | 280.839 | |
Mode value(s) | 279 | |
Variance | 19.051 | |
Standard deviation | 4.36475 | |
Expected value | 280.873 | |
Skewness | 415.257 | |
Kurtosis | -0.537043 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 701 |
Minimum value | 2004-10-13 | |
Arithmetic mean | 2004-10-13 | |
Maximum value | 2004-10-13 | |
Median | 2004-10-13 |
Column | Property | Value |
---|---|---|
CustomerID, int | Total values | 753 |
Range | 700 [1;701] | |
Interquartile range | 377 [137;514] | |
Arithmetic mean | 329.523 | |
Arithmetic mean absolute deviation | 183.254 | |
Median value | 325 | |
Median absolute deviation | 183.726 | |
Harmonic mean | 75.7329 | |
Geometric mean | 223.938 | |
Mode value(s) | 2, 3, 5, 6, 8, 9, 11, 12, 14, 15... | |
Variance | 44434.1 | |
Standard deviation | 210.794 | |
Expected value | 329.523 | |
Skewness | 61.0281 | |
Kurtosis | -1.26857 |
Column | Property | Value |
---|---|---|
ContactID, int | Total values | 753 |
Range | 955 [1;956] | |
Interquartile range | 377 [189;566] | |
Arithmetic mean | 415.623 | |
Arithmetic mean absolute deviation | 228.341 | |
Median value | 377 | |
Median absolute deviation | 226.873 | |
Harmonic mean | 105.287 | |
Geometric mean | 292.989 | |
Mode value(s) | 322, 369, 791, 176, 916, 321, 368, 792, 177, 917... | |
Variance | 76378.5 | |
Standard deviation | 276.367 | |
Expected value | 415.623 | |
Skewness | 348.377 | |
Kurtosis | -0.897987 |
Column | Property | Value |
---|---|---|
ContactTypeID, int | Total values | 753 |
Range | 4 [11;15] | |
Interquartile range | 4 [11;15] | |
Arithmetic mean | 13.2656 | |
Arithmetic mean absolute deviation | 1.03187 | |
Median value | 14 | |
Median absolute deviation | 1.38513 | |
Harmonic mean | 13.0275 | |
Geometric mean | 13.1486 | |
Mode value(s) | 11 | |
Variance | 2.96925 | |
Standard deviation | 1.72315 | |
Expected value | 13.2656 | |
Skewness | -336.031 | |
Kurtosis | -1.59979 |
Column | Property | Value |
---|---|---|
ModifiedDate, datetime | Total values | 753 |
Minimum value | 2001-07-01 | |
Arithmetic mean | 2002-08-22 | |
Maximum value | 2004-06-01 | |
Median | 2002-08-01 |