+1443 776-2705 panelessays@gmail.com

Bonus  #1:  Tableau Project
Page 141
Data files required: Attached below

Assignment: Install Tableau and complete the activities:

  • Tableau Free Installation: https://www.tableau.com/academic/students 
  • “Data Visualization in Tableau Appendix” – p.141 

Submit:

  • All Tableau Files created in the exercise
  • 1-page .doc/.pdf – Explain how Tableau could be useful for making managerial/business decisions in the workplace.  Identify one use case where you could use this tool in your profession to make better decisions.

Data

Week No. of Commercials Sales Volume
1 2 50
2 5 57
3 1 41
4 3 54
5 4 54
6 1 38
7 5 63
8 3 48
9 4 59
10 2 46

Data

Sales ($100s)
Month North South
Jan 95 40
Feb 100 45
Mar 120 55
Apr 115 65
May 100 60
Jun 85 50
Jul 135 75
Aug 110 65
Sep 100 60
Oct 50 70
Nov 40 75
Dec 40 80

BarChart

Manager Accounts Managed
Davis 24
Edwards 11
Francois 28
Gentry 37
Jones 15
Lopez 29
Smith 21
Williams 6

Data

Area (Sub-Borough) Median Monthy Rent ($) Percentage College Graduates (%) Poverty Rate (%) Travel Time (min)
Astoria 1106 36.8 15.9 35.4
Bay Ridge 1082 34.3 15.6 41.9
Bayside/Little Neck 1243 41.3 7.6 40.6
Bedford Stuyvesant 822 21.0 34.2 40.5
Bensonhurst 876 17.7 14.4 44.0
Borough Park 980 26.0 27.6 35.3
Brooklyn Heights/Fort Greene 1086 55.3 17.4 34.5
Brownsville/Ocean Hill 714 11.6 36.0 40.3
Bushwick 945 13.3 33.5 35.5
Central Harlem 665 30.6 27.1 25.0
Chelsea/Clinton/Midtown 1624 66.1 12.7 43.7
Coney Island 786 27.2 20.0 46.3
East Flatbush 940 18.4 11.7 33.2
East Harlem 677 23.7 30.0 44.2
East New York/Starrett City 890 13.7 29.2 43.9
Elmhurst/Corona 1121 21.8 22.3 41.1
Flatbush 931 28.3 25.1 43.9
Flatlands/Canarsie 1052 26.6 9.3 42.0
Flushing/Whitestone 1170 32.5 11.4 23.4
Greenwich Village/Financial District 1965 78.3 7.9 44.0
Highbridge/South Concourse 781 11.2 31.4 44.6
Hillcrest/Fresh Meadows 1138 39.6 12.9 41.6
Jackson Heights 1114 19.8 16.0 47.3
Jamaica 980 19.8 12.7 42.8
Kingsbridge Heights/Moshulu 860 16.0 35.0 31.6
Lower East Side/Chinatown 821 34.2 25.9 39.0
Middle Village/Ridgewood 1078 20.1 12.1 39.7
Mid-Island 999 28.4 11.3 32.5
Morningside Heights/Hamilton Heights 949 38.1 25.3 44.8
Morrisania/Belmont 727 11.3 38.9 39.7
Mott Haven/Hunts Point 625 8.3 41.6 41.3
North Crown Heights/Prospect Heights 872 29.7 24.8 42.8
North Shore 889 26.5 17.4 43.0
Ozone Park/Woodhaven 1114 21.7 11.6 35.6
Park Slope/Carroll Gardens 1566 61.8 8.4 37.5
Pelham Parkway 929 22.7 17.4 44.8
Queens Village 1184 30.2 6.2 41.3
Rego Park/Forest Hills 1192 51.2 10.4 42.5
Riverdale/Kingsbridge 969 41.4 13.4 48.6
Rockaways 875 22.2 20.1 40.4
Sheepshead Bay/Gravesend 945 32.5 11.9 44.4
Soundview/Parkchester 848 15.8 27.9 42.4
South Crown Heights 874 19.9 19.7 44.6
South Ozone Park/Howard Beach 1148 17.3 8.1 42.0
South Shore 999 27.6 4.3 25.9
Stuyvesant Town/Turtle Bay 1849 78.0 6.9 36.7
Sunnyside/Woodside 1137 31.8 10.2 44.7
Sunset Park 995 21.8 27.6 43.1
Throgs Neck/Co-op City 892 22.3 13.6 39.7
University Heights/Fordham 813 11.6 40.9 29.2
Upper East Side 1706 78.2 5.9 29.1
Upper West Side 1635 74.6 8.8 38.7
Washington Heights/Inwood 874 28.8 25.9 42.5
Williamsbridge/Baychester 950 20.1 16.7 31.9
Williamsburg/Greenpoint 959 33.9 31.7 33.8

Data

Country Name GDP 2014 (Billions US $) GDP Growth 2014 (%)
Afghanistan 20.050 -1.715
Albania 13.220 1.905
Algeria 213.518 1.805
Angola 126.777 1.433
Antigua and Barbuda 1.221 3.550
Argentina 529.726 -3.560
Armenia 11.610 3.119
Australia 1454.675 0.985
Austria 438.376 -0.088
Azerbaijan 75.198 0.735
Bahamas, The 8.618 -1.878
Bahrain 33.388 3.393
Bangladesh 172.885 4.781
Barbados 4.353 -0.112
Belarus 76.104 1.541
Belgium 531.762 1.215
Belize 1.718 1.860
Benin 9.707 3.585
Bhutan 1.959 4.312
Bolivia 32.996 3.842
Bosnia and Herzegovina 18.524 1.240
Botswana 15.880 1.186
Brazil 2417.046 -0.780
Brunei Darussalam 17.123 -3.729
Bulgaria 56.732 1.906
Burkina Faso 12.257 1.046
Burundi 3.094 1.266
Cabo Verde 1.881 0.547
Cambodia 16.778 5.328
Cameroon 32.051 3.314
Canada 1783.776 1.354
Central African Republic 1.703 -0.929
Chad 13.922 3.428
Chile 258.733 0.805
China 10482.371 6.756
Colombia 378.416 3.405
Comoros 0.648 -0.363
Congo, Dem. Rep. 32.782 5.587
Congo, Rep. 14.177 4.158
Costa Rica 50.168 1.868
Cote d’Ivoire 34.218 5.869
Croatia 57.136 0.046
Cyprus 23.308 -0.442
Czech Republic 207.818 2.607
Denmark 346.119 0.750
Djibouti 1.588 4.594
Dominica 0.528 3.703
Dominican Republic 65.231 6.321
Ecuador 102.292 2.413
Egypt, Arab Rep. 301.499 -0.015
El Salvador 25.054 1.125
Equatorial Guinea 21.462 -3.557
Estonia 26.214 3.093
Ethiopia 55.612 7.549
Fiji 4.470 4.737
Finland 272.463 -1.118
France 2839.162 -0.156
Gabon 18.180 2.008
Gambia, The 0.849 -2.331
Georgia 16.509 5.999
Germany 3879.277 3.038
Ghana 38.617 1.571
Greece 236.080 1.024
Greenland 2.441
Grenada 0.911 6.906
Guatemala 58.722 2.062
Guinea 6.624 -2.273
Guinea-Bissau 1.109 0.071
Guyana 3.077 3.452
Haiti 8.792 1.428
Honduras 19.381 1.627
Hong Kong SAR, China 291.229 1.913
Hungary 139.295 4.328
Iceland 17.036 0.700
India 2042.439 5.936
Indonesia 890.487 3.709
Iran, Islamic Rep. 425.326 3.020
Iraq 228.731 -3.247
Ireland 256.271 8.018
Isle of Man 7.428 4.229
Israel 308.769 1.202
Italy 2149.814 -0.822
Jamaica 13.898 0.477
Japan 4848.733 0.499
Jordan 35.827 0.299
Kazakhstan 221.416 2.669
Kenya 61.395 2.583
Kiribati 0.186 0.623
Korea, Rep. 1411.334 2.923
Kosovo 7.385 1.517
Kuwait 162.632 -3.769
Kyrgyz Republic 7.468 1.958
Lao PDR 11.739 5.760
Latvia 31.323 3.066
Lebanon 45.731 -4.097
Lesotho 2.539 3.246
Liberia 2.013 -1.655
Liechtenstein 6.664
Lithuania 48.354 3.922
Luxembourg 64.874 1.645
Macao SAR, China 55.523 -2.543
Macedonia, FYR 11.319 3.387
Madagascar 10.674 0.479
Malawi 6.055 2.502
Malaysia 338.069 4.464
Maldives 3.094 3.883
Mali 14.004 3.949
Malta 10.738 2.495
Marshall Islands 0.183 -1.159
Mauritania 5.442 1.661
Mauritius 12.803 3.557
Mexico 1298.176 0.903
Micronesia, Fed. Sts. 0.318 -3.706
Moldova 7.983 4.864
Mongolia 12.227 6.006
Montenegro 4.588 1.685
Morocco 109.881 1.123
Mozambique 16.961 4.487
Myanmar 65.575 7.075
Namibia 12.854 3.966
Nepal 19.812 4.711
Netherlands 879.635 1.055
New Zealand 200.142 2.024
Nicaragua 11.790 3.378
Niger 8.245 2.822
Nigeria 568.499 3.519
Norway 498.340 0.776
Oman 81.035 -5.425
Pakistan 244.361 2.496
Palau 0.251 3.377
Panama 49.166 4.357
Papua New Guinea 16.929 6.284
Paraguay 30.881 3.334
Peru 201.021 1.007
Philippines 284.834 4.540
Poland 545.159 3.360
Portugal 230.117 1.451
Qatar 206.225 0.591
Romania 199.493 3.463
Russian Federation 2052.807 -1.075
Rwanda 7.912 4.523
Samoa 0.800 0.429
Sao Tome and Principe 0.348 3.953
Saudi Arabia 753.832 1.339
Senegal 15.285 1.101
Serbia 44.211 -1.369
Seychelles 1.423 1.621
Sierra Leone 5.015 2.293
Singapore 306.344 1.928
Slovak Republic 100.761 2.471
Slovenia 49.530 3.005
Solomon Islands 1.157 -0.530
Somalia 5.647
South Africa 351.305 0.000
South Sudan 13.282 -0.596
Spain 1381.342 1.664
Sri Lanka 80.025 3.909
St. Kitts and Nevis 0.848 4.723
St. Lucia 1.386 -0.296
St. Vincent and the Grenadines 0.728 1.122
Sudan 82.152 0.500
Suriname 5.210 0.935
Swaziland 4.493 1.253
Sweden 573.818 1.591
Switzerland 702.706 0.760
Tajikistan 9.236 4.333
Tanzania 48.197 3.649
Thailand 404.320 0.409
Timor-Leste 1.399 3.063
Togo 4.483 3.097
Tonga 0.443 1.633
Trinidad and Tobago 26.176 -1.034
Tunisia 47.603 1.838
Turkey 798.782 1.292
Turkmenistan 43.514 8.905
Tuvalu 0.037 2.060
Uganda 27.761 1.816
Ukraine 133.503 -1.145
United Arab Emirates 401.958 2.556
United Kingdom 2998.834 2.297
United States 17393.103 1.574
Uruguay 57.236 2.890
Uzbekistan 62.644 6.292
Vanuatu 0.815 0.071
Venezuela, RB -5.203
Vietnam 186.205 4.851
West Bank and Gaza 12.716 -3.974
Yemen, Rep. 43.229 -2.668
Zambia 27.151 1.531
Zimbabwe 14.197 1.479

Data

Audit Times (in Days)
12
15
20
22
14
14
15
27
21
18
19
18
22
33
16
18
17
23
28
13

Data

Selling Price ($) Size (ft2) Location Type
302,000 2150 Fairview Detached
265,000 1890 Fairview Detached
280,000 1540 Fairview Detached
220,000 1790 Fairview Detached
149,000 1500 Fairview Detached
155,000 1450 Fairview Detached
198,000 1700 Fairview Condo
187,000 1900 Fairview Condo
208,000 1800 Fairview Detached
174,000 1650 Fairview Detached
336,000 1750 Shadyside Condo
398,000 1950 Shadyside Condo
378,000 1780 Shadyside Condo
298,000 1600 Shadyside Detached
425,000 2250 Shadyside Detached
344,000 1780 Shadyside Condo
302,000 1750 Shadyside Condo
300,000 1700 Shadyside Detached
298,000 1540 Shadyside Detached
342,000 1580 Shadyside Detached
152,000 1700 Groton Detached
158,000 1280 Groton Detached
154,000 1450 Groton Detached
170,000 1800 Groton Detached
132,000 1450 Groton Detached
164,000 1350 Groton Condo
198,000 1400 Groton Condo
158,000 1560 Groton Detached
149,000 1480 Groton Detached
165,000 1710 Groton Detached
201,000 1900 Irving Detached
365,000 2340 Irving Detached
115,000 1100 Irving Detached
105,000 1210 Irving Detached
225,000 1950 Irving Detached
115,000 1300 Irving Detached
108,000 1250 Irving Detached
218,000 1850 Irving Detached
454,000 2300 Irving Condo
103,000 1150 Irving Detached
102,000 1450 Hamilton Detached
108,000 1500 Hamilton Detached
88,000 1050 Hamilton Detached
111,000 950 Hamilton Condo
105,000 950 Hamilton Condo
87,000 1100 Hamilton Detached
95,000 1000 Hamilton Detached
111,000 1200 Hamilton Detached
98,000 1100 Hamilton Detached
78,000 1050 Hamilton 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