--Human Error In Recognition
SELECT SUM(0.8244 +0.8309 +0.3415 +0.7287 +0.4206 +0.8229 +0.8099 +0.4730 +0.7693 +0.7238 +0.7982 +0.4803 +0.9401 )
--8.9636
SELECT AVG(0.8244 +0.8309 +0.3415 +0.7287 +0.4206 +0.8229 +0.8099 +0.4730 +0.7693 +0.7238 +0.7982 +0.4803 +0.9401 )
--8.963600
SELECT AVG(8.9636 )
--8.936000
--Average
SELECT 8.9636/13
DROP TABLE Temp
CREATE TABLE Temp (
Col DECIMAL(10, 4)
);
INSERT INTO Temp (Col) VALUES
(0.8244),(0.8309),(NULL),(0.3415),(NULL),
(0.7287),(0.4206),(NULL),(0.8229),(0.8099),
(NULL),(0.4730),(0.7693),(0.7238),(NULL),
(NULL),(NULL),(NULL),(0.7982),(NULL),
(0.4803),(NULL),(0.9401),(NULL)
SELECT SUM(Col) FROM Temp
--8.936000
SELECT AVG(Col) FROM Temp
--0.689507
|
Excel |
|
0.8244 |
|
0.8309 |
|
NULL |
|
0.3415 |
|
NULL |
|
0.7287 |
|
0.4206 |
|
NULL |
|
0.8229 |
|
0.8099 |
|
NULL |
|
0.473 |
|
0.7693 |
|
0.7238 |
|
NULL |
|
NULL |
|
NULL |
|
NULL |
|
0.7982 |
|
NULL |
|
0.4803 |
|
NULL |
|
0.9401 |
|
0.689508 |
