| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !select_data -- |
| 1 A 10.5 85 alpha |
| 2 A 20.3 92 beta |
| 3 A 15.7 78 gamma |
| 4 A 30.2 95 delta |
| 5 A 25.1 88 alpha |
| 6 B 12.4 70 beta |
| 7 B 18.9 85 gamma |
| 8 B 22.5 90 alpha |
| 9 B 16.3 82 beta |
| 10 C 35.7 98 delta |
| 11 C 28.4 91 gamma |
| 12 C 31.2 87 alpha |
| 13 C 26.8 93 beta |
| 14 C 29.5 89 delta |
| 15 C 33.1 95 gamma |
| |
| -- !variance_all -- |
| 56.98728888888877 |
| |
| -- !variance_group -- |
| A 47.64639999999991 |
| B 13.60187500000001 |
| C 8.818055555555702 |
| |
| -- !stddev_all -- |
| 7.548992574435927 |
| |
| -- !stddev_group -- |
| A 6.902637177195388 |
| B 3.688071989535997 |
| C 2.969521098688424 |
| |
| -- !median_all -- |
| 25.1 |
| |
| -- !median_group -- |
| A 20.3 |
| B 17.6 |
| C 30.35 |
| |
| -- !collect_all -- |
| alpha,alpha,alpha,alpha,beta,beta,beta,beta,delta,delta,delta,gamma,gamma,gamma,gamma |
| |
| -- !collect_group -- |
| A alpha,alpha,beta,delta,gamma |
| B alpha,beta,beta,gamma |
| C alpha,beta,delta,delta,gamma,gamma |
| |
| -- !range_all -- |
| 28 |
| |
| -- !range_group -- |
| A 17 |
| B 20 |
| C 11 |
| |
| -- !geomean_all -- |
| 22.40937175581814 |
| |
| -- !geomean_group -- |
| A 19.09207495673589 |
| B 17.12235128890801 |
| C 30.64227404617737 |
| |
| -- !weighted_avg_all -- |
| 24.24764795144158 |
| |
| -- !weighted_avg_group -- |
| A 20.69063926940639 |
| B 17.8474006116208 |
| C 30.849547920434 |
| |
| -- !multi_agg -- |
| A 47.64639999999991 6.902637177195388 20.3 17 19.09207495673589 20.69063926940639 |
| B 13.60187500000001 3.688071989535997 17.6 20 17.12235128890801 17.8474006116208 |
| C 8.818055555555702 2.969521098688424 30.35 11 30.64227404617737 30.849547920434 |
| |
| -- !window_partition -- |
| 1 A 10.5 47.64639999999991 20.3 |
| 2 A 20.3 47.64639999999991 20.3 |
| 3 A 15.7 47.64639999999991 20.3 |
| 4 A 30.2 47.64639999999991 20.3 |
| 5 A 25.1 47.64639999999991 20.3 |
| 6 B 12.4 13.60187500000001 17.6 |
| 7 B 18.9 13.60187500000001 17.6 |
| 8 B 22.5 13.60187500000001 17.6 |
| 9 B 16.3 13.60187500000001 17.6 |
| 10 C 35.7 8.818055555555702 30.35 |
| 11 C 28.4 8.818055555555702 30.35 |
| 12 C 31.2 8.818055555555702 30.35 |
| 13 C 26.8 8.818055555555702 30.35 |
| 14 C 29.5 8.818055555555702 30.35 |
| 15 C 33.1 8.818055555555702 30.35 |
| |
| -- !window_order -- |
| 1 A 10.5 0 10.5 |
| 2 A 20.3 24.00999999999999 15.4 |
| 3 A 15.7 16.0266666666667 15.7 |
| 4 A 30.2 52.53687499999995 18 |
| 5 A 25.1 47.64639999999991 20.3 |
| 6 B 12.4 0 12.4 |
| 7 B 18.9 10.5625 15.65 |
| 8 B 22.5 17.4688888888889 18.9 |
| 9 B 16.3 13.60187500000001 17.6 |
| 10 C 35.7 0 35.7 |
| 11 C 28.4 13.32250000000022 32.05 |
| 12 C 31.2 9.042222222222335 31.2 |
| 13 C 26.8 11.40687500000024 29.8 |
| 14 C 29.5 9.293600000000083 29.5 |
| 15 C 33.1 8.818055555555702 30.35 |
| |
| -- !compare_native -- |
| A 6.902637177195388 6.902637177195394 47.64639999999991 47.64639999999999 |
| B 3.688071989535997 3.688071989535996 13.60187500000001 13.601875 |
| C 2.969521098688424 2.9695210986884 8.818055555555702 8.81805555555556 |
| |
| -- !null_handling -- |
| 66.66666666666669 20 10 alpha,alpha,beta |
| |
| -- !global_variance -- |
| 56.98728888888877 |
| |
| -- !global_variance_group -- |
| A 47.64639999999991 |
| B 13.60187500000001 |
| C 8.818055555555702 |
| |
| -- !empty -- |
| \N |
| |
| -- !single -- |
| 0 |
| |
| -- !two -- |
| 15.4 |
| |
