Business Analytics AG1

Chrisyanqu
CH2.xlsx
Home>Business & Finance homework help>Business Analytics AG1

Data

Selling Price ($) Size (ft2) Location Area Population Jobless Rate Type
787,000 2301 Fairview 59000 0.03 Detached
703,000 1871 Fairview 59000 0.03 Detached
538,000 1432 Fairview 59000 0.03 Detached
661,000 1629 Fairview 59000 0.03 Detached
560,000 1410 Fairview 59000 0.03 Detached
521,000 1436 Fairview 59000 0.03 Detached
653,000 1666 Fairview 59000 0.03 Condo
750,000 1995 Fairview 59000 0.03 Condo
736,000 1710 Fairview 59000 0.03 Detached
754,000 1766 Fairview 59000 0.03 Detached
526,000 1698 Shadyside 11000 0.01 Condo
655,000 1794 Shadyside 11000 0.01 Condo
610,000 1727 Shadyside 11000 0.01 Condo
728,000 1648 Shadyside 11000 0.01 Detached
682,000 2048 Shadyside 11000 0.01 Detached
654,000 1655 Shadyside 11000 0.01 Condo
719,000 1908 Shadyside 11000 0.01 Condo
634,000 1870 Shadyside 11000 0.01 Detached
575,000 1555 Shadyside 11000 0.01 Detached
530,000 1422 Shadyside 11000 0.01 Detached
767,000 1768 Groton 81000 0.04 Detached
538,000 1357 Groton 81000 0.04 Detached
584,000 1320 Groton 81000 0.04 Detached
715,000 1782 Groton 81000 0.04 Detached
534,000 1349 Groton 81000 0.04 Detached
464,000 1377 Groton 81000 0.04 Condo
413,000 1274 Groton 81000 0.04 Condo
609,000 1404 Groton 81000 0.04 Detached
533,000 1406 Groton 81000 0.04 Detached
587,000 1607 Groton 81000 0.04 Detached
772,000 1767 Irving 65000 0.04 Detached
862,000 2153 Irving 65000 0.04 Detached
418,000 1111 Irving 65000 0.04 Detached
450,000 1162 Irving 65000 0.04 Detached
864,000 2067 Irving 65000 0.04 Detached
589,000 1326 Irving 65000 0.04 Detached
426,000 1150 Irving 65000 0.04 Detached
746,000 1684 Irving 65000 0.04 Detached
755,000 2139 Irving 65000 0.04 Condo
513,000 1173 Irving 65000 0.04 Detached
583,000 1378 Hamilton 85000 0.06 Detached
665,000 1470 Hamilton 85000 0.06 Detached
381,000 1019 Hamilton 85000 0.06 Detached
305,000 979 Hamilton 85000 0.06 Condo
340,000 903 Hamilton 85000 0.06 Condo
486,000 1023 Hamilton 85000 0.06 Detached
484,000 1040 Hamilton 85000 0.06 Detached
515,000 1188 Hamilton 85000 0.06 Detached
496,000 1166 Hamilton 85000 0.06 Detached
394,000 945 Hamilton 85000 0.06 Detached

XLM_BoxPlot1

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 272000 10 92000 10 103500 10 96750 10 0.5 302000 336000 89000 201000 102000 0.5113636364 0 q0.5
Median 203000 284000 103000 158000 108000 0.5 265000 305000 78000 387000 145000
Quartile-3 253750 299500 151500 266250 121500 0.5 280000 278000 105000 78000 88000
Mean 209400 286500 151200 203500 110100 0.5 220000 298000 158000 105000 111000
Minimum 105000 245000 78000 78000 87000 0.5 105000 270000 132000 225000 105000
Maximum 280000 305000 158000 454000 145000 0.5 155000 245000 101000 115000 87000
Mean plus d 209400 286500 151200 203500 110100 0.5 198000 288000 345000 87000 95000
Mean minus d 209400 286500 151200 203500 110100 0.5 187000 300000 325000 280000 111000
No of Outliers 1 1 2 9999 9999 0.5 208000 280000 101000 454000 132000
Outlier-1 302000 336000 345000 0.5 174000 265000 78000 103000 125000
Outlier-2 325000
0.1704545455 280000 0.3068181818 305000 0.4431818182 158000 0.5795454545 454000 0.7159090909 145000
0.2840909091 280000 0.4204545455 305000 0.5568181818 158000 0.6931818182 454000 0.8295454545 145000
0.2272727273 280000 0.3636363636 305000 0.5 158000 0.6363636364 454000 0.7727272727 145000
0.2272727273 253750 0.3636363636 299500 0.5 151500 0.6363636364 266250 0.7727272727 121500
0.1704545455 253750 0.3068181818 299500 0.4431818182 151500 0.5795454545 266250 0.7159090909 121500
0.1704545455 209400 0.3068181818 286500 0.4431818182 151200 0.5795454545 203500 0.7159090909 110100
0.1704545455 209400 0.3068181818 286500 0.4431818182 151200 0.5795454545 203500 0.7159090909 110100
0.1704545455 209400 0.3068181818 286500 0.4431818182 151200 0.5795454545 203500 0.7159090909 110100
0.1704545455 177250 0.3068181818 272000 0.4431818182 92000 0.5795454545 103500 0.7159090909 96750
0.2272727273 177250 0.3636363636 272000 0.5 92000 0.6363636364 103500 0.7727272727 96750
0.2272727273 105000 0.3636363636 245000 0.5 78000 0.6363636364 78000 0.7727272727 87000
0.1704545455 105000 0.3068181818 245000 0.4431818182 78000 0.5795454545 78000 0.7159090909 87000
0.2840909091 105000 0.4204545455 245000 0.5568181818 78000 0.6931818182 78000 0.8295454545 87000
0.2272727273 105000 0.3636363636 245000 0.5 78000 0.6363636364 78000 0.7727272727 87000
0.2272727273 177250 0.3636363636 272000 0.5 92000 0.6363636364 103500 0.7727272727 96750
0.2840909091 177250 0.4204545455 272000 0.5568181818 92000 0.6931818182 103500 0.8295454545 96750
0.2840909091 209400 0.4204545455 286500 0.5568181818 151200 0.6931818182 203500 0.8295454545 110100
0.2840909091 209400 0.4204545455 286500 0.5568181818 151200 0.6931818182 203500 0.8295454545 110100
0.2840909091 209400 0.4204545455 286500 0.5568181818 151200 0.6931818182 203500 0.8295454545 110100
0.2840909091 253750 0.4204545455 299500 0.5568181818 151500 0.6931818182 266250 0.8295454545 121500
0.2272727273 253750 0.3636363636 299500 0.5 151500 0.6363636364 266250 0.7727272727 121500
0.2272727273 209400 0.3636363636 286500 0.5 151200 0.6363636364 203500 0.7727272727 110100
0.1704545455 203000 0.3068181818 284000 0.4431818182 103000 0.5795454545 158000 0.7159090909 108000
0.2840909091 203000 0.4204545455 284000 0.5568181818 103000 0.6931818182 158000 0.8295454545 108000
0.2272727273 302000 0.3636363636 336000 0.5 345000
0.5 325000

XLM_BoxPlot2

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 298500 10 113000 10 109750 10 96750 10 0.5 302000 336000 98000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 143000 158000 108000 0.5 265000 398000 158000 365000 145000
Quartile-3 253750 369500 158000 223250 121500 0.5 280000 378000 154000 115000 88000
Mean 209400 338900 170600 200900 110100 0.5 220000 298000 158000 105000 111000
Minimum 105000 280000 110000 103000 87000 0.5 105000 425000 132000 225000 105000
Maximum 280000 425000 158000 365000 145000 0.5 155000 344000 110000 115000 87000
Mean plus d 228024.929524598 354125.646194433 198301.97992987 238718.065313146 116000.634614185 0.5 198000 288000 345000 108000 95000
Mean minus d 190775.070475402 323674.353805567 142898.02007013 163081.934686854 104199.365385815 0.5 187000 300000 325000 218000 111000
No of Outliers 1 9999 3 1 9999 0.5 208000 280000 113000 454000 132000
Outlier-1 302000 98000 454000 0.5 174000 342000 113000 103000 125000
Outlier-2 345000
Outlier-3 325000
0.1704545455 280000 0.3068181818 425000 0.4431818182 158000 0.5795454545 365000 0.7159090909 145000
0.2840909091 280000 0.4204545455 425000 0.5568181818 158000 0.6931818182 365000 0.8295454545 145000
0.2272727273 280000 0.3636363636 425000 0.5 158000 0.6363636364 365000 0.7727272727 145000
0.2272727273 253750 0.3636363636 369500 0.5 158000 0.6363636364 223250 0.7727272727 121500
0.1704545455 253750 0.3068181818 369500 0.4431818182 158000 0.5795454545 223250 0.7159090909 121500
0.1704545455 228024.929524598 0.3068181818 354125.646194433 0.4431818182 198301.97992987 0.5795454545 238718.065313146 0.7159090909 116000.634614185
0.2083333333 209400 0.3446969697 338900 0.4810606061 170600 0.6174242424 200900 0.7537878788 110100
0.1704545455 190775.070475402 0.3068181818 323674.353805567 0.4431818182 142898.02007013 0.5795454545 163081.934686854 0.7159090909 104199.365385815
0.1704545455 177250 0.3068181818 298500 0.4431818182 113000 0.5795454545 109750 0.7159090909 96750
0.2272727273 177250 0.3636363636 298500 0.5 113000 0.6363636364 109750 0.7727272727 96750
0.2272727273 105000 0.3636363636 280000 0.5 110000 0.6363636364 103000 0.7727272727 87000
0.1704545455 105000 0.3068181818 280000 0.4431818182 110000 0.5795454545 103000 0.7159090909 87000
0.2840909091 105000 0.4204545455 280000 0.5568181818 110000 0.6931818182 103000 0.8295454545 87000
0.2272727273 105000 0.3636363636 280000 0.5 110000 0.6363636364 103000 0.7727272727 87000
0.2272727273 177250 0.3636363636 298500 0.5 113000 0.6363636364 109750 0.7727272727 96750
0.2840909091 177250 0.4204545455 298500 0.5568181818 113000 0.6931818182 109750 0.8295454545 96750
0.2840909091 190775.070475402 0.4204545455 323674.353805567 0.5568181818 142898.02007013 0.6931818182 163081.934686854 0.8295454545 104199.365385815
0.2462121212 209400 0.3825757576 338900 0.5189393939 170600 0.6553030303 200900 0.7916666667 110100
0.2840909091 228024.929524598 0.4204545455 354125.646194433 0.5568181818 198301.97992987 0.6931818182 238718.065313146 0.8295454545 116000.634614185
0.2840909091 253750 0.4204545455 369500 0.5568181818 158000 0.6931818182 223250 0.8295454545 121500
0.2272727273 253750 0.3636363636 369500 0.5 158000 0.6363636364 223250 0.7727272727 121500
0.2272727273 209400 0.3636363636 338900 0.5 170600 0.6363636364 200900 0.7727272727 110100
0.1953172174 203000 0.3444481869 339000 0.4433212622 143000 0.5795454545 158000 0.7403070484 108000
0.2592282372 203000 0.3828245404 339000 0.5566787378 143000 0.6931818182 158000 0.8051474971 108000
0.2272727273 302000 0.5 98000 0.6363636364 454000
0.5 345000
0.5 325000

XLM_BoxPlot3

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 298500 10 119250 10 109750 10 96750 10 0.5 302000 336000 115000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 151500 158000 108000 0.5 265000 398000 158000 365000 145000
Quartile-3 253750 369500 158000 223250 121500 0.5 280000 378000 154000 115000 88000
Mean 209400 338900 159200 200900 110100 0.5 220000 298000 158000 105000 111000
Minimum 105000 280000 110000 103000 87000 0.5 105000 425000 132000 225000 105000
Maximum 280000 425000 158000 365000 145000 0.5 155000 344000 110000 115000 87000
Mean plus d 209400 338900 159200 200900 110100 0.5 198000 288000 345000 108000 95000
Mean minus d 209400 338900 159200 200900 110100 0.5 187000 300000 158000 218000 111000
No of Outliers 1 9999 1 1 9999 0.5 208000 280000 149000 454000 132000
Outlier-1 302000 345000 454000 0.5 174000 342000 113000 103000 125000
0.1704545455 280000 0.3068181818 425000 0.4431818182 158000 0.5795454545 365000 0.7159090909 145000
0.2840909091 280000 0.4204545455 425000 0.5568181818 158000 0.6931818182 365000 0.8295454545 145000
0.2272727273 280000 0.3636363636 425000 0.5 158000 0.6363636364 365000 0.7727272727 145000
0.2272727273 253750 0.3636363636 369500 0.5 158000 0.6363636364 223250 0.7727272727 121500
0.1704545455 253750 0.3068181818 369500 0.4431818182 158000 0.5795454545 223250 0.7159090909 121500
0.1704545455 209400 0.3068181818 338900 0.4431818182 159200 0.5795454545 200900 0.7159090909 110100
0.1704545455 209400 0.3068181818 338900 0.4431818182 159200 0.5795454545 200900 0.7159090909 110100
0.1704545455 209400 0.3068181818 338900 0.4431818182 159200 0.5795454545 200900 0.7159090909 110100
0.1704545455 177250 0.3068181818 298500 0.4431818182 119250 0.5795454545 109750 0.7159090909 96750
0.2272727273 177250 0.3636363636 298500 0.5 119250 0.6363636364 109750 0.7727272727 96750
0.2272727273 105000 0.3636363636 280000 0.5 110000 0.6363636364 103000 0.7727272727 87000
0.1704545455 105000 0.3068181818 280000 0.4431818182 110000 0.5795454545 103000 0.7159090909 87000
0.2840909091 105000 0.4204545455 280000 0.5568181818 110000 0.6931818182 103000 0.8295454545 87000
0.2272727273 105000 0.3636363636 280000 0.5 110000 0.6363636364 103000 0.7727272727 87000
0.2272727273 177250 0.3636363636 298500 0.5 119250 0.6363636364 109750 0.7727272727 96750
0.2840909091 177250 0.4204545455 298500 0.5568181818 119250 0.6931818182 109750 0.8295454545 96750
0.2840909091 209400 0.4204545455 338900 0.5568181818 159200 0.6931818182 200900 0.8295454545 110100
0.2840909091 209400 0.4204545455 338900 0.5568181818 159200 0.6931818182 200900 0.8295454545 110100
0.2840909091 209400 0.4204545455 338900 0.5568181818 159200 0.6931818182 200900 0.8295454545 110100
0.2840909091 253750 0.4204545455 369500 0.5568181818 158000 0.6931818182 223250 0.8295454545 121500
0.2272727273 253750 0.3636363636 369500 0.5 158000 0.6363636364 223250 0.7727272727 121500
0.2272727273 209400 0.3636363636 338900 0.5 159200 0.6363636364 200900 0.7727272727 110100
0.1704545455 203000 0.3068181818 339000 0.4431818182 151500 0.5795454545 158000 0.7159090909 108000
0.2840909091 203000 0.4204545455 339000 0.5568181818 151500 0.6931818182 158000 0.8295454545 108000
0.2272727273 302000 0.5 345000 0.6363636364 454000

XLM_BoxPlot4

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 298500 10 137000 10 109750 10 96750 10 0.5 302000 336000 115000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 156000 158000 108000 0.5 265000 398000 158000 365000 145000
Quartile-3 253750 369500 158000 223250 121500 0.5 280000 378000 154000 115000 88000
Mean 209400 338900 158100 200900 110100 0.5 220000 298000 158000 105000 111000
Minimum 105000 280000 132000 103000 87000 0.5 105000 425000 132000 225000 105000
Maximum 280000 425000 179000 365000 145000 0.5 155000 344000 179000 115000 87000
Mean plus d 209400 338900 158100 200900 110100 0.5 198000 288000 245000 108000 95000
Mean minus d 209400 338900 158100 200900 110100 0.5 187000 300000 158000 218000 111000
No of Outliers 1 9999 2 1 9999 0.5 208000 280000 149000 454000 132000
Outlier-1 302000 115000 454000 0.5 174000 342000 133000 103000 125000
Outlier-2 245000
0.1704545455 280000 0.3068181818 425000 0.4431818182 179000 0.5795454545 365000 0.7159090909 145000
0.2840909091 280000 0.4204545455 425000 0.5568181818 179000 0.6931818182 365000 0.8295454545 145000
0.2272727273 280000 0.3636363636 425000 0.5 179000 0.6363636364 365000 0.7727272727 145000
0.2272727273 253750 0.3636363636 369500 0.5 158000 0.6363636364 223250 0.7727272727 121500
0.1704545455 253750 0.3068181818 369500 0.4431818182 158000 0.5795454545 223250 0.7159090909 121500
0.1704545455 209400 0.3068181818 338900 0.4431818182 158100 0.5795454545 200900 0.7159090909 110100
0.1704545455 209400 0.3068181818 338900 0.4431818182 158100 0.5795454545 200900 0.7159090909 110100
0.1704545455 209400 0.3068181818 338900 0.4431818182 158100 0.5795454545 200900 0.7159090909 110100
0.1704545455 177250 0.3068181818 298500 0.4431818182 137000 0.5795454545 109750 0.7159090909 96750
0.2272727273 177250 0.3636363636 298500 0.5 137000 0.6363636364 109750 0.7727272727 96750
0.2272727273 105000 0.3636363636 280000 0.5 132000 0.6363636364 103000 0.7727272727 87000
0.1704545455 105000 0.3068181818 280000 0.4431818182 132000 0.5795454545 103000 0.7159090909 87000
0.2840909091 105000 0.4204545455 280000 0.5568181818 132000 0.6931818182 103000 0.8295454545 87000
0.2272727273 105000 0.3636363636 280000 0.5 132000 0.6363636364 103000 0.7727272727 87000
0.2272727273 177250 0.3636363636 298500 0.5 137000 0.6363636364 109750 0.7727272727 96750
0.2840909091 177250 0.4204545455 298500 0.5568181818 137000 0.6931818182 109750 0.8295454545 96750
0.2840909091 209400 0.4204545455 338900 0.5568181818 158100 0.6931818182 200900 0.8295454545 110100
0.2840909091 209400 0.4204545455 338900 0.5568181818 158100 0.6931818182 200900 0.8295454545 110100
0.2840909091 209400 0.4204545455 338900 0.5568181818 158100 0.6931818182 200900 0.8295454545 110100
0.2840909091 253750 0.4204545455 369500 0.5568181818 158000 0.6931818182 223250 0.8295454545 121500
0.2272727273 253750 0.3636363636 369500 0.5 158000 0.6363636364 223250 0.7727272727 121500
0.2272727273 209400 0.3636363636 338900 0.5 158100 0.6363636364 200900 0.7727272727 110100
0.1704545455 203000 0.3068181818 339000 0.4431818182 156000 0.5795454545 158000 0.7159090909 108000
0.2840909091 203000 0.4204545455 339000 0.5568181818 156000 0.6931818182 158000 0.8295454545 108000
0.2272727273 302000 0.5 115000 0.6363636364 454000
0.5 245000

XLM_BoxPlot5

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 298500 10 150250 10 109750 10 96750 10 0.5 302000 336000 115000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 158000 158000 108000 0.5 265000 398000 158000 365000 145000
Quartile-3 253750 369500 161000 223250 121500 0.5 280000 378000 154000 115000 88000
Mean 209400 338900 161000 200900 110100 0.5 220000 298000 158000 105000 111000
Minimum 105000 280000 149000 103000 87000 0.5 105000 425000 132000 225000 105000
Maximum 280000 425000 162000 365000 145000 0.5 155000 344000 179000 115000 87000
Mean plus d 209400 338900 161000 200900 110100 0.5 198000 288000 245000 108000 95000
Mean minus d 209400 338900 161000 200900 110100 0.5 187000 300000 158000 218000 111000
No of Outliers 1 9999 4 1 9999 0.5 208000 280000 149000 454000 132000
Outlier-1 302000 115000 454000 0.5 174000 342000 162000 103000 125000
Outlier-2 132000
Outlier-3 179000
Outlier-4 245000
0.1704545455 280000 0.3068181818 425000 0.4431818182 162000 0.5795454545 365000 0.7159090909 145000
0.2840909091 280000 0.4204545455 425000 0.5568181818 162000 0.6931818182 365000 0.8295454545 145000
0.2272727273 280000 0.3636363636 425000 0.5 162000 0.6363636364 365000 0.7727272727 145000
0.2272727273 253750 0.3636363636 369500 0.5 161000 0.6363636364 223250 0.7727272727 121500
0.1704545455 253750 0.3068181818 369500 0.4431818182 161000 0.5795454545 223250 0.7159090909 121500
0.1704545455 209400 0.3068181818 338900 0.4431818182 161000 0.5795454545 200900 0.7159090909 110100
0.1704545455 209400 0.3068181818 338900 0.4431818182 161000 0.5795454545 200900 0.7159090909 110100
0.1704545455 209400 0.3068181818 338900 0.4431818182 161000 0.5795454545 200900 0.7159090909 110100
0.1704545455 177250 0.3068181818 298500 0.4431818182 150250 0.5795454545 109750 0.7159090909 96750
0.2272727273 177250 0.3636363636 298500 0.5 150250 0.6363636364 109750 0.7727272727 96750
0.2272727273 105000 0.3636363636 280000 0.5 149000 0.6363636364 103000 0.7727272727 87000
0.1704545455 105000 0.3068181818 280000 0.4431818182 149000 0.5795454545 103000 0.7159090909 87000
0.2840909091 105000 0.4204545455 280000 0.5568181818 149000 0.6931818182 103000 0.8295454545 87000
0.2272727273 105000 0.3636363636 280000 0.5 149000 0.6363636364 103000 0.7727272727 87000
0.2272727273 177250 0.3636363636 298500 0.5 150250 0.6363636364 109750 0.7727272727 96750
0.2840909091 177250 0.4204545455 298500 0.5568181818 150250 0.6931818182 109750 0.8295454545 96750
0.2840909091 209400 0.4204545455 338900 0.5568181818 161000 0.6931818182 200900 0.8295454545 110100
0.2840909091 209400 0.4204545455 338900 0.5568181818 161000 0.6931818182 200900 0.8295454545 110100
0.2840909091 209400 0.4204545455 338900 0.5568181818 161000 0.6931818182 200900 0.8295454545 110100
0.2840909091 253750 0.4204545455 369500 0.5568181818 161000 0.6931818182 223250 0.8295454545 121500
0.2272727273 253750 0.3636363636 369500 0.5 161000 0.6363636364 223250 0.7727272727 121500
0.2272727273 209400 0.3636363636 338900 0.5 161000 0.6363636364 200900 0.7727272727 110100
0.1704545455 203000 0.3068181818 339000 0.4431818182 158000 0.5795454545 158000 0.7159090909 108000
0.2840909091 203000 0.4204545455 339000 0.5568181818 158000 0.6931818182 158000 0.8295454545 108000
0.2272727273 302000 0.5 115000 0.6363636364 454000
0.5 132000
0.5 179000
0.5 245000

XLM_BoxPlot6

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 300500 10 150250 10 109750 10 89750 10 0.5 302000 336000 129000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 158000 158000 100000 0.5 265000 398000 158000 365000 108000
Quartile-3 253750 369500 161000 223250 107250 0.5 280000 378000 154000 115000 88000
Mean 213800 342100 162400 200900 98300 0.5 220000 298000 158000 105000 111000
Minimum 149000 298000 149000 103000 78000 0.5 149000 425000 132000 225000 105000
Maximum 280000 425000 162000 365000 111000 0.5 155000 344000 179000 115000 87000
Mean plus d 230153.795626224 356186.954716112 172439.914315123 238718.065313146 101775.67560615 0.5 198000 302000 245000 108000 95000
Mean minus d 197446.204373776 328013.045283888 152360.085684877 163081.934686854 94824.3243938497 0.5 187000 300000 158000 218000 111000
No of Outliers 1 9999 4 1 9999 0.5 208000 298000 149000 454000 98000
Outlier-1 302000 129000 454000 0.5 174000 342000 162000 103000 78000
Outlier-2 132000
Outlier-3 179000
Outlier-4 245000
0.1704545455 280000 0.3068181818 425000 0.4431818182 162000 0.5795454545 365000 0.7159090909 111000
0.2840909091 280000 0.4204545455 425000 0.5568181818 162000 0.6931818182 365000 0.8295454545 111000
0.2272727273 280000 0.3636363636 425000 0.5 162000 0.6363636364 365000 0.7727272727 111000
0.2272727273 253750 0.3636363636 369500 0.5 161000 0.6363636364 223250 0.7727272727 107250
0.1704545455 253750 0.3068181818 369500 0.4431818182 161000 0.5795454545 223250 0.7159090909 107250
0.1704545455 230153.795626224 0.3068181818 356186.954716112 0.4431818182 172439.914315123 0.5795454545 238718.065313146 0.7159090909 101775.67560615
0.2083333333 213800 0.3446969697 342100 0.4810606061 162400 0.6174242424 200900 0.7537878788 98300
0.1704545455 197446.204373776 0.3068181818 328013.045283888 0.4431818182 152360.085684877 0.5795454545 163081.934686854 0.7159090909 94824.3243938497
0.1704545455 177250 0.3068181818 300500 0.4431818182 150250 0.5795454545 109750 0.7159090909 89750
0.2272727273 177250 0.3636363636 300500 0.5 150250 0.6363636364 109750 0.7727272727 89750
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.1704545455 149000 0.3068181818 298000 0.4431818182 149000 0.5795454545 103000 0.7159090909 78000
0.2840909091 149000 0.4204545455 298000 0.5568181818 149000 0.6931818182 103000 0.8295454545 78000
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.2272727273 177250 0.3636363636 300500 0.5 150250 0.6363636364 109750 0.7727272727 89750
0.2840909091 177250 0.4204545455 300500 0.5568181818 150250 0.6931818182 109750 0.8295454545 89750
0.2840909091 197446.204373776 0.4204545455 328013.045283888 0.5568181818 152360.085684877 0.6931818182 163081.934686854 0.8295454545 94824.3243938497
0.2462121212 213800 0.3825757576 342100 0.5189393939 162400 0.6553030303 200900 0.7916666667 98300
0.2840909091 230153.795626224 0.4204545455 356186.954716112 0.5568181818 172439.914315123 0.6931818182 238718.065313146 0.8295454545 101775.67560615
0.2840909091 253750 0.4204545455 369500 0.5568181818 161000 0.6931818182 223250 0.8295454545 107250
0.2272727273 253750 0.3636363636 369500 0.5 161000 0.6363636364 223250 0.7727272727 107250
0.2272727273 213800 0.3636363636 342100 0.5 162400 0.6363636364 200900 0.7727272727 98300
0.1833182898 203000 0.3363612971 339000 0.4644601988 158000 0.5795454545 158000 0.7352608508 100000
0.2712271647 203000 0.3909114302 339000 0.5355398012 158000 0.6931818182 158000 0.8101936947 100000
0.2272727273 302000 0.5 129000 0.6363636364 454000
0.5 132000
0.5 179000
0.5 245000

XLM_BoxPlot7

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 300500 10 152500 10 109750 10 89750 10 0.5 302000 336000 152000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 158000 158000 100000 0.5 265000 398000 158000 365000 108000
Quartile-3 253750 369500 161000 223250 107250 0.5 280000 378000 154000 115000 88000
Mean 213800 342100 164700 200900 98300 0.5 220000 298000 158000 105000 111000
Minimum 149000 298000 149000 103000 78000 0.5 149000 425000 132000 225000 105000
Maximum 280000 425000 162000 365000 111000 0.5 155000 344000 179000 115000 87000
Mean plus d 213800 342100 164700 200900 98300 0.5 198000 302000 245000 108000 95000
Mean minus d 213800 342100 164700 200900 98300 0.5 187000 300000 158000 218000 111000
No of Outliers 1 9999 3 1 9999 0.5 208000 298000 149000 454000 98000
Outlier-1 302000 132000 454000 0.5 174000 342000 162000 103000 78000
Outlier-2 179000
Outlier-3 245000
0.1704545455 280000 0.3068181818 425000 0.4431818182 162000 0.5795454545 365000 0.7159090909 111000
0.2840909091 280000 0.4204545455 425000 0.5568181818 162000 0.6931818182 365000 0.8295454545 111000
0.2272727273 280000 0.3636363636 425000 0.5 162000 0.6363636364 365000 0.7727272727 111000
0.2272727273 253750 0.3636363636 369500 0.5 161000 0.6363636364 223250 0.7727272727 107250
0.1704545455 253750 0.3068181818 369500 0.4431818182 161000 0.5795454545 223250 0.7159090909 107250
0.1704545455 213800 0.3068181818 342100 0.4431818182 164700 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 164700 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 164700 0.5795454545 200900 0.7159090909 98300
0.1704545455 177250 0.3068181818 300500 0.4431818182 152500 0.5795454545 109750 0.7159090909 89750
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.1704545455 149000 0.3068181818 298000 0.4431818182 149000 0.5795454545 103000 0.7159090909 78000
0.2840909091 149000 0.4204545455 298000 0.5568181818 149000 0.6931818182 103000 0.8295454545 78000
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2840909091 177250 0.4204545455 300500 0.5568181818 152500 0.6931818182 109750 0.8295454545 89750
0.2840909091 213800 0.4204545455 342100 0.5568181818 164700 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 164700 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 164700 0.6931818182 200900 0.8295454545 98300
0.2840909091 253750 0.4204545455 369500 0.5568181818 161000 0.6931818182 223250 0.8295454545 107250
0.2272727273 253750 0.3636363636 369500 0.5 161000 0.6363636364 223250 0.7727272727 107250
0.2272727273 213800 0.3636363636 342100 0.5 164700 0.6363636364 200900 0.7727272727 98300
0.1704545455 203000 0.3068181818 339000 0.4431818182 158000 0.5795454545 158000 0.7159090909 100000
0.2840909091 203000 0.4204545455 339000 0.5568181818 158000 0.6931818182 158000 0.8295454545 100000
0.2272727273 302000 0.5 132000 0.6363636364 454000
0.5 179000
0.5 245000

XLM_BoxPlot8

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 300500 10 152500 10 109750 10 89750 10 0.5 302000 336000 152000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 158000 158000 100000 0.5 265000 398000 158000 365000 108000
Quartile-3 253750 369500 158750 223250 107250 0.5 280000 378000 154000 115000 88000
Mean 213800 342100 158000 200900 98300 0.5 220000 298000 158000 105000 111000
Minimum 149000 298000 149000 103000 78000 0.5 149000 425000 132000 225000 105000
Maximum 280000 425000 162000 365000 111000 0.5 155000 344000 159000 115000 87000
Mean plus d 213800 342100 158000 200900 98300 0.5 198000 302000 198000 108000 95000
Mean minus d 213800 342100 158000 200900 98300 0.5 187000 300000 158000 218000 111000
No of Outliers 1 9999 2 1 9999 0.5 208000 298000 149000 454000 98000
Outlier-1 302000 132000 454000 0.5 174000 342000 162000 103000 78000
Outlier-2 198000
0.1704545455 280000 0.3068181818 425000 0.4431818182 162000 0.5795454545 365000 0.7159090909 111000
0.2840909091 280000 0.4204545455 425000 0.5568181818 162000 0.6931818182 365000 0.8295454545 111000
0.2272727273 280000 0.3636363636 425000 0.5 162000 0.6363636364 365000 0.7727272727 111000
0.2272727273 253750 0.3636363636 369500 0.5 158750 0.6363636364 223250 0.7727272727 107250
0.1704545455 253750 0.3068181818 369500 0.4431818182 158750 0.5795454545 223250 0.7159090909 107250
0.1704545455 213800 0.3068181818 342100 0.4431818182 158000 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 158000 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 158000 0.5795454545 200900 0.7159090909 98300
0.1704545455 177250 0.3068181818 300500 0.4431818182 152500 0.5795454545 109750 0.7159090909 89750
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.1704545455 149000 0.3068181818 298000 0.4431818182 149000 0.5795454545 103000 0.7159090909 78000
0.2840909091 149000 0.4204545455 298000 0.5568181818 149000 0.6931818182 103000 0.8295454545 78000
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2840909091 177250 0.4204545455 300500 0.5568181818 152500 0.6931818182 109750 0.8295454545 89750
0.2840909091 213800 0.4204545455 342100 0.5568181818 158000 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 158000 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 158000 0.6931818182 200900 0.8295454545 98300
0.2840909091 253750 0.4204545455 369500 0.5568181818 158750 0.6931818182 223250 0.8295454545 107250
0.2272727273 253750 0.3636363636 369500 0.5 158750 0.6363636364 223250 0.7727272727 107250
0.2272727273 213800 0.3636363636 342100 0.5 158000 0.6363636364 200900 0.7727272727 98300
0.1704545455 203000 0.3068181818 339000 0.4431818182 158000 0.5795454545 158000 0.7159090909 100000
0.2840909091 203000 0.4204545455 339000 0.5568181818 158000 0.6931818182 158000 0.8295454545 100000
0.2272727273 302000 0.5 132000 0.6363636364 454000
0.5 198000

XLM_BoxPlot9

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 300500 10 152500 10 109750 10 89750 10 0.5 302000 336000 152000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 158000 158000 100000 0.5 265000 398000 158000 365000 108000
Quartile-3 253750 369500 163500 223250 107250 0.5 280000 378000 154000 115000 88000
Mean 213800 342100 159200 200900 98300 0.5 220000 298000 162000 105000 111000
Minimum 149000 298000 149000 103000 78000 0.5 149000 425000 132000 225000 105000
Maximum 280000 425000 165000 365000 111000 0.5 155000 344000 164000 115000 87000
Mean plus d 213800 342100 159200 200900 98300 0.5 198000 302000 198000 108000 95000
Mean minus d 213800 342100 159200 200900 98300 0.5 187000 300000 158000 218000 111000
No of Outliers 1 9999 2 1 9999 0.5 208000 298000 149000 454000 98000
Outlier-1 302000 132000 454000 0.5 174000 342000 165000 103000 78000
Outlier-2 198000
0.1704545455 280000 0.3068181818 425000 0.4431818182 165000 0.5795454545 365000 0.7159090909 111000
0.2840909091 280000 0.4204545455 425000 0.5568181818 165000 0.6931818182 365000 0.8295454545 111000
0.2272727273 280000 0.3636363636 425000 0.5 165000 0.6363636364 365000 0.7727272727 111000
0.2272727273 253750 0.3636363636 369500 0.5 163500 0.6363636364 223250 0.7727272727 107250
0.1704545455 253750 0.3068181818 369500 0.4431818182 163500 0.5795454545 223250 0.7159090909 107250
0.1704545455 213800 0.3068181818 342100 0.4431818182 159200 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 159200 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 159200 0.5795454545 200900 0.7159090909 98300
0.1704545455 177250 0.3068181818 300500 0.4431818182 152500 0.5795454545 109750 0.7159090909 89750
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.1704545455 149000 0.3068181818 298000 0.4431818182 149000 0.5795454545 103000 0.7159090909 78000
0.2840909091 149000 0.4204545455 298000 0.5568181818 149000 0.6931818182 103000 0.8295454545 78000
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2840909091 177250 0.4204545455 300500 0.5568181818 152500 0.6931818182 109750 0.8295454545 89750
0.2840909091 213800 0.4204545455 342100 0.5568181818 159200 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 159200 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 159200 0.6931818182 200900 0.8295454545 98300
0.2840909091 253750 0.4204545455 369500 0.5568181818 163500 0.6931818182 223250 0.8295454545 107250
0.2272727273 253750 0.3636363636 369500 0.5 163500 0.6363636364 223250 0.7727272727 107250
0.2272727273 213800 0.3636363636 342100 0.5 159200 0.6363636364 200900 0.7727272727 98300
0.1704545455 203000 0.3068181818 339000 0.4431818182 158000 0.5795454545 158000 0.7159090909 100000
0.2840909091 203000 0.4204545455 339000 0.5568181818 158000 0.6931818182 158000 0.8295454545 100000
0.2272727273 302000 0.5 132000 0.6363636364 454000
0.5 198000

XLM_BoxPlot10

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 300500 10 152500 10 109750 10 89750 10 0.5 302000 336000 152000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 158000 158000 100000 0.5 265000 398000 158000 365000 108000
Quartile-3 253750 369500 164750 223250 107250 0.5 280000 378000 154000 115000 88000
Mean 213800 342100 159700 200900 98300 0.5 220000 298000 167000 105000 111000
Minimum 149000 298000 149000 103000 78000 0.5 149000 425000 132000 225000 105000
Maximum 280000 425000 167000 365000 111000 0.5 155000 344000 164000 115000 87000
Mean plus d 213800 342100 159700 200900 98300 0.5 198000 302000 198000 108000 95000
Mean minus d 213800 342100 159700 200900 98300 0.5 187000 300000 158000 218000 111000
No of Outliers 1 9999 2 1 9999 0.5 208000 298000 149000 454000 98000
Outlier-1 302000 132000 454000 0.5 174000 342000 165000 103000 78000
Outlier-2 198000
0.1704545455 280000 0.3068181818 425000 0.4431818182 167000 0.5795454545 365000 0.7159090909 111000
0.2840909091 280000 0.4204545455 425000 0.5568181818 167000 0.6931818182 365000 0.8295454545 111000
0.2272727273 280000 0.3636363636 425000 0.5 167000 0.6363636364 365000 0.7727272727 111000
0.2272727273 253750 0.3636363636 369500 0.5 164750 0.6363636364 223250 0.7727272727 107250
0.1704545455 253750 0.3068181818 369500 0.4431818182 164750 0.5795454545 223250 0.7159090909 107250
0.1704545455 213800 0.3068181818 342100 0.4431818182 159700 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 159700 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 159700 0.5795454545 200900 0.7159090909 98300
0.1704545455 177250 0.3068181818 300500 0.4431818182 152500 0.5795454545 109750 0.7159090909 89750
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.1704545455 149000 0.3068181818 298000 0.4431818182 149000 0.5795454545 103000 0.7159090909 78000
0.2840909091 149000 0.4204545455 298000 0.5568181818 149000 0.6931818182 103000 0.8295454545 78000
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2840909091 177250 0.4204545455 300500 0.5568181818 152500 0.6931818182 109750 0.8295454545 89750
0.2840909091 213800 0.4204545455 342100 0.5568181818 159700 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 159700 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 159700 0.6931818182 200900 0.8295454545 98300
0.2840909091 253750 0.4204545455 369500 0.5568181818 164750 0.6931818182 223250 0.8295454545 107250
0.2272727273 253750 0.3636363636 369500 0.5 164750 0.6363636364 223250 0.7727272727 107250
0.2272727273 213800 0.3636363636 342100 0.5 159700 0.6363636364 200900 0.7727272727 98300
0.1704545455 203000 0.3068181818 339000 0.4431818182 158000 0.5795454545 158000 0.7159090909 100000
0.2840909091 203000 0.4204545455 339000 0.5568181818 158000 0.6931818182 158000 0.8295454545 100000
0.2272727273 302000 0.5 132000 0.6363636364 454000
0.5 198000

XLM_BoxPlot11

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 300500 10 152500 10 109750 10 89750 10 0.5 302000 336000 152000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 158000 158000 100000 0.5 265000 398000 158000 365000 108000
Quartile-3 253750 369500 164750 223250 107250 0.5 280000 378000 154000 115000 88000
Mean 213800 342100 160000 200900 98300 0.5 220000 298000 170000 105000 111000
Minimum 149000 298000 149000 103000 78000 0.5 149000 425000 132000 225000 105000
Maximum 280000 425000 170000 365000 111000 0.5 155000 344000 164000 115000 87000
Mean plus d 213800 342100 160000 200900 98300 0.5 198000 302000 198000 108000 95000
Mean minus d 213800 342100 160000 200900 98300 0.5 187000 300000 158000 218000 111000
No of Outliers 1 9999 2 1 9999 0.5 208000 298000 149000 454000 98000
Outlier-1 302000 132000 454000 0.5 174000 342000 165000 103000 78000
Outlier-2 198000
0.1704545455 280000 0.3068181818 425000 0.4431818182 170000 0.5795454545 365000 0.7159090909 111000
0.2840909091 280000 0.4204545455 425000 0.5568181818 170000 0.6931818182 365000 0.8295454545 111000
0.2272727273 280000 0.3636363636 425000 0.5 170000 0.6363636364 365000 0.7727272727 111000
0.2272727273 253750 0.3636363636 369500 0.5 164750 0.6363636364 223250 0.7727272727 107250
0.1704545455 253750 0.3068181818 369500 0.4431818182 164750 0.5795454545 223250 0.7159090909 107250
0.1704545455 213800 0.3068181818 342100 0.4431818182 160000 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 160000 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 160000 0.5795454545 200900 0.7159090909 98300
0.1704545455 177250 0.3068181818 300500 0.4431818182 152500 0.5795454545 109750 0.7159090909 89750
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.1704545455 149000 0.3068181818 298000 0.4431818182 149000 0.5795454545 103000 0.7159090909 78000
0.2840909091 149000 0.4204545455 298000 0.5568181818 149000 0.6931818182 103000 0.8295454545 78000
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2840909091 177250 0.4204545455 300500 0.5568181818 152500 0.6931818182 109750 0.8295454545 89750
0.2840909091 213800 0.4204545455 342100 0.5568181818 160000 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 160000 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 160000 0.6931818182 200900 0.8295454545 98300
0.2840909091 253750 0.4204545455 369500 0.5568181818 164750 0.6931818182 223250 0.8295454545 107250
0.2272727273 253750 0.3636363636 369500 0.5 164750 0.6363636364 223250 0.7727272727 107250
0.2272727273 213800 0.3636363636 342100 0.5 160000 0.6363636364 200900 0.7727272727 98300
0.1704545455 203000 0.3068181818 339000 0.4431818182 158000 0.5795454545 158000 0.7159090909 100000
0.2840909091 203000 0.4204545455 339000 0.5568181818 158000 0.6931818182 158000 0.8295454545 100000
0.2272727273 302000 0.5 132000 0.6363636364 454000
0.5 198000

XLM_BoxPlot12

X-Distinct Values Start Row No of Records No of Distinct Values of X Statistical Value Type X1 Y1 X1 Y2 X1 Y3 X1 Y4 X1 Y5 X-Values Y-1-Values Y-2-Values Y-3-Values Y-4-Values Y-5-Values 0 0 q
0.5 2 10 1 Quartile-1 177250 10 300500 10 152500 10 109750 10 89750 10 0.5 302000 336000 152000 201000 102000 0.5113636364 0 q0.5
Median 203000 339000 158000 158000 100000 0.5 265000 398000 158000 365000 108000
Quartile-3 253750 369500 164750 223250 107250 0.5 280000 378000 154000 115000 88000
Mean 213800 342100 160000 200900 98300 0.5 220000 298000 170000 105000 111000
Minimum 149000 298000 149000 103000 78000 0.5 149000 425000 132000 225000 105000
Maximum 280000 425000 170000 365000 111000 0.5 155000 344000 164000 115000 87000
Mean plus d 213800 342100 160000 200900 98300 0.5 198000 302000 198000 108000 95000
Mean minus d 213800 342100 160000 200900 98300 0.5 187000 300000 158000 218000 111000
No of Outliers 1 9999 2 1 9999 0.5 208000 298000 149000 454000 98000
Outlier-1 302000 132000 454000 0.5 174000 342000 165000 103000 78000
Outlier-2 198000
0.1704545455 280000 0.3068181818 425000 0.4431818182 170000 0.5795454545 365000 0.7159090909 111000
0.2840909091 280000 0.4204545455 425000 0.5568181818 170000 0.6931818182 365000 0.8295454545 111000
0.2272727273 280000 0.3636363636 425000 0.5 170000 0.6363636364 365000 0.7727272727 111000
0.2272727273 253750 0.3636363636 369500 0.5 164750 0.6363636364 223250 0.7727272727 107250
0.1704545455 253750 0.3068181818 369500 0.4431818182 164750 0.5795454545 223250 0.7159090909 107250
0.1704545455 213800 0.3068181818 342100 0.4431818182 160000 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 160000 0.5795454545 200900 0.7159090909 98300
0.1704545455 213800 0.3068181818 342100 0.4431818182 160000 0.5795454545 200900 0.7159090909 98300
0.1704545455 177250 0.3068181818 300500 0.4431818182 152500 0.5795454545 109750 0.7159090909 89750
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.1704545455 149000 0.3068181818 298000 0.4431818182 149000 0.5795454545 103000 0.7159090909 78000
0.2840909091 149000 0.4204545455 298000 0.5568181818 149000 0.6931818182 103000 0.8295454545 78000
0.2272727273 149000 0.3636363636 298000 0.5 149000 0.6363636364 103000 0.7727272727 78000
0.2272727273 177250 0.3636363636 300500 0.5 152500 0.6363636364 109750 0.7727272727 89750
0.2840909091 177250 0.4204545455 300500 0.5568181818 152500 0.6931818182 109750 0.8295454545 89750
0.2840909091 213800 0.4204545455 342100 0.5568181818 160000 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 160000 0.6931818182 200900 0.8295454545 98300
0.2840909091 213800 0.4204545455 342100 0.5568181818 160000 0.6931818182 200900 0.8295454545 98300
0.2840909091 253750 0.4204545455 369500 0.5568181818 164750 0.6931818182 223250 0.8295454545 107250
0.2272727273 253750 0.3636363636 369500 0.5 164750 0.6363636364 223250 0.7727272727 107250
0.2272727273 213800 0.3636363636 342100 0.5 160000 0.6363636364 200900 0.7727272727 98300
0.1704545455 203000 0.3068181818 339000 0.4431818182 158000 0.5795454545 158000 0.7159090909 100000
0.2840909091 203000 0.4204545455 339000 0.5568181818 158000 0.6931818182 158000 0.8295454545 100000
0.2272727273 302000 0.5 132000 0.6363636364 454000
0.5 198000