SQL Call
SELECT * FROM ScaleSummary (
ON scale_stat AS "input" PARTITION BY 1
) AS dt ORDER BY 1;
Output
stattype |
price |
lotsize |
bedrooms |
bathrms |
stories |
avg |
65037.5 |
5067.5 |
2.875 |
1.125 |
1.875 |
count |
8 |
8 |
8 |
8 |
8 |
ignorerow |
2 |
2 |
2 |
2 |
2 |
infinity |
0 |
0 |
0 |
0 |
0 |
max |
88500 |
6650 |
3 |
4 |
4 |
min |
42000 |
3060 |
2 |
1 |
1 |
nan |
0 |
0 |
0 |
0 |
0 |
null |
1 |
0 |
1 |
0 |
0 |
squaresum |
35567190000 |
216159400 |
67 |
11 |
37 |
std |
15712.500710308 |
1237.67927994291 |
0.353553390593274 |
0.353553390593274 |
1.1259916264596 |
sum |
520300 |
40540 |
23 |
9 |
15 |
variance |
246882678.571429 |
1531850 |
0.125 |
0.125 |
1.26785714285714 |