Spreadsheet: 269499d1381174421-formatting-a-table-to-pull-data-array-formula-sampletable_student1990-2-pt-oeldere-
Sheet: total

choise | Approach | Size Group | Style Group | 3-Year | 5-Year | 7-Year | 10-Year
Returns | Fundamental | A | 1 | 18.90175 | 12.23905 | 7.9872 | 11.8018
Returns | Fundamental | A | 2 | 18.5154 | 10.455 | 7.663 | 11.6263
Returns | Fundamental | A | 3 | 18.6113 | 10.63335 | 7.7311 | 11.6924
Returns | Fundamental | A | 4 | 21.25335 | 10.3921 | 7.4827 | 10.83215
Returns | Fundamental | A | 5 | 19.1644 | 10.1331 | 7.7625 | 11.55375
Returns | Fundamental | B | 1 | 17.9256 | 10.93085 | 7.8427 | 11.9159
Returns | Fundamental | B | 2 | 18.96405 | 9.496 | 7.3349 | 11.8461
Returns | Fundamental | B | 3 | 18.92075 | 9.68975 | 7.4597 | 11.8461
Returns | Fundamental | B | 4 | 20.3333 | 9.0752 | 8.27125 | 11.52885
Returns | Fundamental | B | 5 | 18.41695 | 10.1495 | 8.29 | 11.0013
Returns | Fundamental | C | 1 | 18.8 | 11.61 | 7.76 | 11.73
Returns | Fundamental | C | 2 | 19.33 | 9.72 | 7.5 | 11.27
Returns | Fundamental | C | 3 | 19.28 | 10.1 | 7.5 | 11.38
Returns | Fundamental | C | 4 | 18.44 | 7.64 | 7.8 | 10.4
Returns | Fundamental | C | 5 | 18 | 8.27 | 7.55 | 10.29
Returns | Fundamental | D | 1 | 17.98 | 7.41 | 5 | 8.14
Returns | Fundamental | D | 2 | 17.87 | 7.23 | 5.92 | 8.43
Returns | Fundamental | D | 3 | 17.89 | 7.24 | 5.83 | 8.39
Returns | Fundamental | D | 4 | 17.42 | 6.62 | 6.7 | 7.86
Returns | Fundamental | D | 5 | 17.24 | 7.06 | 6.28 | 8.14
Returns | Quantitative | A | 1 | 20.4263 | 10.3254 | 4.5492 | 10.2025
Returns | Quantitative | A | 2 | 19.97285 | 9.4279 | 5.8862 | 10.7941
Returns | Quantitative | A | 3 | 20.2478 | 9.72265 | 5.88035 | 10.7362
Returns | Quantitative | A | 4 | 21.8099 | 9.0582 | 5.7229 | 9.3709
Returns | Quantitative | A | 5 | 21.0211 | 9.4342 | 5.3714 | 9.85245
Returns | Quantitative | B | 1 | 18.99385 | 11.9815 | 6.61005 | 11.221
Returns | Quantitative | B | 2 | 21.9318 | 9.991 | 5.2617 | 9.0521
Returns | Quantitative | B | 3 | 21.1401 | 9.991 | 5.4307 | 10.13655
Returns | Quantitative | B | 4 | 18.1143 | -1.2061 | 2.0133 | 8.9885
Returns | Quantitative | B | 5 | 21.3699 | 9.33405 | 6.5921 | 10.7658
Returns | Quantitative | C | 1 | 21.72 | 10.76 | 7.73 | 12.11
Returns | Quantitative | C | 2 | 19.67 | 8.77 | 6.39 | 10.14
Returns | Quantitative | C | 3 | 19.81 | 9.15 | 6.83 | 10.85
Returns | Quantitative | C | 4 | 18.05 | 5.18 | 5.92 | 8.46
Returns | Quantitative | C | 5 | 20.98 | 8.58 | 7.1 | 10.55
Returns | Quantitative | D | 1 | 20.05 | 7.77 | 5.36 | 9.02
Returns | Quantitative | D | 2 | 19.02 | 7.61 | 5.38 | 8.19
Returns | Quantitative | D | 3 | 19.51 | 7.68 | 5.37 | 8.66
Returns | Quantitative | D | 4 | 19.07 | 7.13 | 6.41 | 7.8
Returns | Quantitative | D | 5 | 19.33 | 7.36 | 6 | 8.15
StdDev | Fundamental | A | 1 | 21.6792 | 27.41025 | 23.7802 | 21.8979
StdDev | Fundamental | A | 2 | 20.9917 | 25.97115 | 22.9961 | 20.41875
StdDev | Fundamental | A | 3 | 21.2077 | 26.2614 | 23.0701 | 20.8024
StdDev | Fundamental | A | 4 | 22.31805 | 26.1391 | 23.8544 | 21.51135
StdDev | Fundamental | A | 5 | 21.1101 | 25.5895 | 22.5842 | 20.4854
StdDev | Fundamental | B | 1 | 20.4094 | 25.7541 | 23.3766 | 21.49235
StdDev | Fundamental | B | 2 | 21.46855 | 25.9913 | 22.7574 | 20.8926
StdDev | Fundamental | B | 3 | 20.9183 | 25.92355 | 22.9604 | 21.0843
StdDev | Fundamental | B | 4 | 21.04805 | 25.8812 | 23.57615 | 20.62985
StdDev | Fundamental | B | 5 | 20.0782 | 24.6071 | 21.61265 | 19.485
StdDev | Fundamental | C | 1 | 20.72 | 26.35 | 23.08 | 20.51
StdDev | Fundamental | C | 2 | 19.46 | 24.56 | 21.76 | 19.11
StdDev | Fundamental | C | 3 | 19.61 | 24.75 | 21.95 | 19.2
StdDev | Fundamental | C | 4 | 20.37 | 25.55 | 22.63 | 20.24
StdDev | Fundamental | C | 5 | 20.01 | 24.59 | 21.4 | 18.75
StdDev | Fundamental | D | 1 | 18.08 | 23.81 | 20.89 | 18.45
StdDev | Fundamental | D | 2 | 16.44 | 21.83 | 19.36 | 17.11
StdDev | Fundamental | D | 3 | 16.65 | 22.18 | 19.57 | 17.2
StdDev | Fundamental | D | 4 | 17.68 | 22.57 | 19.85 | 17.34
StdDev | Fundamental | D | 5 | 16.54 | 21.5 | 18.99 | 16.55
StdDev | Quantitative | A | 1 | 21.1741 | 28.70245 | 25.3919 | 22.491
StdDev | Quantitative | A | 2 | 20.38605 | 25.8365 | 23.103 | 20.6264
StdDev | Quantitative | A | 3 | 20.9599 | 27.2932 | 23.94245 | 21.8869
StdDev | Quantitative | A | 4 | 23.2218 | 27.5121 | 24.3167 | 22.4947
StdDev | Quantitative | A | 5 | 22.13225 | 26.696 | 23.6501 | 20.9523
StdDev | Quantitative | B | 1 | 21.64085 | 27.8267 | 24.7484 | 21.8639
StdDev | Quantitative | B | 2 | 19.4184 | 23.5037 | 21.0775 | 18.9932
StdDev | Quantitative | B | 3 | 21.47 | 27.5887 | 24.28 | 20.42855
StdDev | Quantitative | B | 4 | 21.6662 | 28.3651 | 25.3298 | 22.5106
StdDev | Quantitative | B | 5 | 21.4191 | 26.30015 | 23.3964 | 20.525
StdDev | Quantitative | C | 1 | 19.45 | 26.26 | 23.06 | 20.2
StdDev | Quantitative | C | 2 | 19.67 | 25.55 | 22.36 | 19.26
StdDev | Quantitative | C | 3 | 19.56 | 25.68 | 22.36 | 19.43
StdDev | Quantitative | C | 4 | 20.63 | 24.91 | 22.05 | 19.66
StdDev | Quantitative | C | 5 | 20.33 | 26.02 | 22.75 | 19.68
StdDev | Quantitative | D | 1 | 17.4 | 22.87 | 20.36 | 17.71
StdDev | Quantitative | D | 2 | 16.79 | 22.6 | 20.03 | 17.4
StdDev | Quantitative | D | 3 | 17.08 | 22.85 | 20.19 | 17.52
StdDev | Quantitative | D | 4 | 16.72 | 22.15 | 19.51 | 17.21
StdDev | Quantitative | D | 5 | 16.27 | 21.45 | 19.05 | 16.45
Shape | Fundamental | A | 1 | 0.8926 | 0.43575 | 0.2836 | 0.4622
Shape | Fundamental | A | 2 | 0.8897 | 0.38375 | 0.2773 | 0.49465
Shape | Fundamental | A | 3 | 0.8925 | 0.39285 | 0.2777 | 0.4885
Shape | Fundamental | A | 4 | 0.93175 | 0.3969 | 0.2663 | 0.43275
Shape | Fundamental | A | 5 | 0.91065 | 0.3896 | 0.2873 | 0.48425
Shape | Fundamental | B | 1 | 0.8617 | 0.43775 | 0.2779 | 0.4846
Shape | Fundamental | B | 2 | 0.92095 | 0.3511 | 0.2797 | 0.4808
Shape | Fundamental | B | 3 | 0.91025 | 0.3632 | 0.2779 | 0.4808
Shape | Fundamental | B | 4 | 0.9381 | 0.3461 | 0.28445 | 0.4904
Shape | Fundamental | B | 5 | 0.9092 | 0.4167 | 0.33645 | 0.4804
Shape | Fundamental | C | 1 | 0.94 | 0.41 | 0.26 | 0.47
Shape | Fundamental | C | 2 | 1.01 | 0.38 | 0.29 | 0.52
Shape | Fundamental | C | 3 | 0.98 | 0.39 | 0.29 | 0.52
Shape | Fundamental | C | 4 | 0.91 | 0.31 | 0.3 | 0.45
Shape | Fundamental | C | 5 | 0.9 | 0.32 | 0.32 | 0.48
Shape | Fundamental | D | 1 | 1.02 | 0.28 | 0.17 | 0.38
Shape | Fundamental | D | 2 | 1.08 | 0.32 | 0.23 | 0.39
Shape | Fundamental | D | 3 | 1.06 | 0.32 | 0.23 | 0.39
Shape | Fundamental | D | 4 | 0.98 | 0.29 | 0.27 | 0.37
Shape | Fundamental | D | 5 | 1.05 | 0.31 | 0.26 | 0.4
Shape | Quantitative | A | 1 | 0.9669 | 0.37605 | 0.1376 | 0.381
Shape | Quantitative | A | 2 | 0.9776 | 0.36395 | 0.2006 | 0.4589
Shape | Quantitative | A | 3 | 0.9679 | 0.3653 | 0.1905 | 0.4223
Shape | Quantitative | A | 4 | 0.9609 | 0.2992 | 0.17255 | 0.3576
Shape | Quantitative | A | 5 | 0.9631 | 0.329 | 0.1682 | 0.3933
Shape | Quantitative | B | 1 | 0.896 | 0.42155 | 0.21185 | 0.4385
Shape | Quantitative | B | 2 | 1.125 | 0.4152 | 0.1857 | 0.3906
Shape | Quantitative | B | 3 | 0.9806 | 0.4152 | 0.1857 | 0.41455
Shape | Quantitative | B | 4 | 0.7969 | -0.0546 | 0.0259 | 0.3203
Shape | Quantitative | B | 5 | 1.0513 | 0.33485 | 0.2034 | 0.4558
Shape | Quantitative | C | 1 | 1.07 | 0.4 | 0.28 | 0.52
Shape | Quantitative | C | 2 | 0.99 | 0.34 | 0.24 | 0.46
Shape | Quantitative | C | 3 | 1.04 | 0.37 | 0.24 | 0.47
Shape | Quantitative | C | 4 | 0.89 | 0.19 | 0.21 | 0.34
Shape | Quantitative | C | 5 | 1.03 | 0.33 | 0.25 | 0.47
Shape | Quantitative | D | 1 | 1.16 | 0.32 | 0.2 | 0.42
Shape | Quantitative | D | 2 | 1.17 | 0.32 | 0.2 | 0.38
Shape | Quantitative | D | 3 | 1.17 | 0.32 | 0.2 | 0.4
Shape | Quantitative | D | 4 | 1.1 | 0.3 | 0.27 | 0.37
Shape | Quantitative | D | 5 | 1.2 | 0.33 | 0.24 | 0.4