Data Parsing and Central Limit Thm [CLT] Exercise

zoy
data.xlsx
Home>Business & Finance homework help>Management homework help>Data Parsing and Central Limit Thm [CLT] Exercise

Parce Computation

NBRHOOD LANDVAL IMPROVAL SALEPRIC SALTOAPR Freequecy Bin Interval
A 49974 41493 182000 0.95 82 110000 100000-110000
A 55792 21736 180800 1.02 103 125000 111000-125000
A 93200 11121 422000 1.04 112 160000 126000-160000
A 54360 61934 237000 1.1 80 210000 161000-210000
A 42742 82397 139000 1.11 34 300000 210000-300000
A 66429 17771 205000 1.11 10 445000 300000-445000
A 36454 92442 145000 1.12 0
A 31270 79233 125000 1.13
A 30602 82498 128500 1.14
A 76125 78172 290000 1.14
A 46651 18573 191500 1.16
A 54077 21848 205000 1.17
A 51428 72451 264000 1.18
A 30720 85244 138000 1.19
A 42394 98181 168000 1.2
A 43494 13757 189000 1.2
A 30600 80858 135000 1.21
A 56658 53806 255000 1.21
A 30720 87738 145000 1.22
A 44730 99047 176000 1.22
A 50563 92615 176500 1.23
A 25200 79938 130500 1.24
A 48112 13269 199500 1.24
A 30000 64831 118500 1.25
A 50275 12207 202500 1.25
A 40800 92606 168000 1.26
A 42400 15046 202500 1.29
A 45990 91402 184000 1.34
A 31270 85479 162000 1.39
A 65376 34458 286500 1.43
A 24637 90598 169900 1.47
B 57446 21702 145000 0.81
B 36173 92463 111000 0.86
B 48325 80974 198000 0.86
B 37224 93145 113500 0.87
B 51469 92523 220000 0.9
B 54506 25062 164500 0.92
B 27640 85347 106000 0.94
B 46117 14159 151000 0.94
B 26331 78907 193000 0.94
B 54398 26121 174000 0.96
B 26614 81469 105000 0.97
B 47725 81460 125500 0.97
B 32456 37480 165000 0.97
B 24864 99186 121500 0.98
B 19911 91286 110000 0.99
B 15000 99392 112900 0.99
B 29900 85451 114000 0.99
B 33922 86714 120000 0.99
B 35665 91206 125000 0.99
B 19256 92299 112000 1
B 19475 93133 114000 1.01
B 23202 97729 122000 1.01
B 46800 24364 172100 1.01
B 53421 19792 175000 1.01
B 20821 79466 102000 1.02
B 26817 78726 108000 1.02
B 25751 82259 110000 1.02
B 31941 90129 125000 1.02
B 27043 96286 126000 1.02
B 43165 89063 134800 1.02
B 25979 76003 105000 1.03
B 35528 84588 123500 1.03
B 44067 11003 160000 1.03
B 22770 85812 112800 1.04
B 31310 96018 132000 1.04
B 42181 92693 140000 1.04
B 25166 30412 162500 1.04
B 28485 96686 132000 1.05
B 66444 76504 255000 1.05
B 20701 85513 113000 1.06
B 49688 87105 145000 1.06
B 46589 99862 155000 1.06
B 15088 79752 101300 1.07
B 26695 71524 105000 1.07
B 30608 88669 127500 1.07
B 22425 96828 127500 1.07
B 24592 77232 110000 1.08
B 63478 35345 215000 1.08
B 31472 83887 126000 1.09
B 24522 98733 134300 1.09
B 74804 40319 234900 1.09
B 24429 86087 121500 1.1
B 45255 27879 190000 1.1
B 52479 26092 197000 1.1
B 25751 64568 100500 1.11
B 20050 84233 116000 1.11
B 24288 93114 129900 1.11
B 26695 90051 130000 1.11
B 28839 95959 139000 1.11
B 44006 13616 175000 1.11
B 41663 21690 181000 1.11
B 20050 80734 113000 1.12
B 26695 80639 120000 1.12
B 30130 85409 129900 1.12
B 31900 87743 134000 1.12
B 27221 93096 135000 1.12
B 22194 11917 150000 1.12
B 42225 11619 172500 1.12
B 47970 19452 187500 1.12
B 44179 28280 192500 1.12
B 23162 23422 165000 1.13
B 50000 13504 185000 1.13
B 21412 75812 111000 1.14
B 20098 85446 120000 1.14
B 23460 83276 122000 1.14
B 20852 86394 122500 1.14
B 32311 75343 123000 1.14
B 22194 96214 134900 1.14
B 40068 86171 144000 1.14
B 48604 93236 161000 1.14
B 20624 72357 107000 1.15
B 19289 83953 118500 1.15
B 37290 72782 126900 1.15
B 22194 95211 135000 1.15
B 27488 96298 142500 1.15
B 28077 16925 167000 1.15
B 20808 93632 133000 1.16
B 29100 23120 177000 1.16
B 22262 69827 107500 1.17
B 41392 21288 191000 1.17
B 57173 18211 206000 1.17
B 18933 75945 111500 1.18
B 24564 71149 112900 1.18
B 29172 90410 141000 1.18
B 29700 25458 183300 1.18
B 41608 17845 187500 1.18
B 24564 66533 108000 1.19
B 26695 70197 115000 1.19
B 24095 76651 119900 1.19
B 31853 89381 144000 1.19
B 27636 10295 163900 1.19
B 33492 26307 190000 1.19
B 43306 21090 195000 1.19
B 14868 72621 105000 1.2
B 18248 77937 115900 1.2
B 19732 84260 125300 1.2
B 20098 96149 139000 1.2
B 40772 25884 199500 1.2
B 14838 92368 130000 1.21
B 22194 87696 133000 1.21
B 17325 97991 139000 1.21
B 28274 91797 145000 1.21
B 25027 96370 146500 1.21
B 30279 24335 187500 1.21
B 39923 37288 215000 1.21
B 49920 48259 240000 1.21
B 85065 22247 250000 1.21
B 18191 92708 134900 1.22
B 30388 88946 145000 1.22
B 16256 72639 109500 1.23
B 18039 74920 114000 1.23
B 19082 71387 112500 1.24
B 28634 76439 129900 1.24
B 30316 84901 143000 1.24
B 27554 77837 132000 1.25
B 25481 98278 155000 1.25
B 33820 12340 183000 1.25
B 20050 72965 117000 1.26
B 14494 79407 118000 1.26
B 23409 75700 124500 1.26
B 22194 86457 137000 1.26
B 23227 87343 138800 1.26
B 32693 10918 181000 1.26
B 32041 19129 190000 1.26
B 39865 41774 229000 1.26
B 22440 75004 123500 1.27
B 16762 89293 135000 1.27
B 33465 85570 151000 1.27
B 29553 89361 151000 1.27
B 33492 17640 192500 1.27
B 42016 42654 235000 1.27
B 66238 25658 243000 1.27
B 63400 33354 250000 1.27
B 61005 52168 270000 1.27
B 17368 64696 105000 1.28
B 17500 72090 115000 1.28
B 16256 74116 116000 1.28
B 17963 81211 126800 1.28
B 61530 40913 260000 1.28
B 20852 85701 137000 1.29
B 14700 71989 113000 1.3
B 30455 88315 155000 1.31
B 30724 11907 187500 1.31
B 32855 10064 189000 1.32
B 33492 24188 208000 1.32
B 31680 97940 173500 1.34
B 29488 18532 198900 1.34
B 47250 91666 320000 1.34
B 26209 21506 199000 1.35
B 38784 11499 202500 1.35
B 29656 78968 147500 1.36
B 37071 24209 220000 1.36
B 17500 79493 133000 1.37
B 49298 18926 230000 1.37
B 55765 66615 305000 1.37
B 53932 97009 210000 1.39
B 18431 84099 143300 1.4
B 31417 99413 185000 1.41
B 22656 91701 164000 1.43
B 30575 16329 210000 1.43
B 55300 52996 445000 1.44
B 31680 99015 192000 1.47
B 15060 78809 138500 1.48
B 16975 68936 128000 1.49
B 67468 80079 375000 1.51
B 17325 69265 135000 1.56
B 47250 33593 288000 1.59
B 45765 81227 440000 1.94
C 54000 87387 100000 0.71
C 40838 10400 122000 0.81
C 39015 99450 120600 0.87
C 49578 13123 151900 0.93
C 73528 57363 123000 0.94
C 27428 10276 130000 0.94
C 25200 93291 113000 0.95
C 60653 89273 142000 0.95
C 14563 18788 130000 0.97
C 21218 80688 100000 0.98
C 40838 98945 140500 1.01
C 15400 94057 115000 1.05
C 29700 94833 131500 1.06
C 46406 99954 155000 1.06
C 34650 64754 105900 1.07
C 29441 70548 108000 1.08
C 32909 82257 123900 1.08
C 47700 77448 135000 1.08
C 30360 92164 133000 1.09
C 40500 10470 165000 1.09
C 16000 77063 103000 1.11
C 26500 92568 132500 1.11
C 41663 67106 231000 1.11
C 15840 76668 103700 1.12
C 31719 62014 105000 1.12
C 15115 89224 117500 1.13
C 15744 78001 107000 1.14
C 34650 78908 130000 1.14
C 45000 77899 140000 1.14
C 36720 13004 171000 1.14
C 15529 97910 131000 1.15
C 21726 70897 107000 1.16
C 29948 66055 112000 1.17
C 15340 85552 118000 1.17
C 33605 14317 173000 1.17
C 29610 58352 104000 1.18
C 40250 52022 109000 1.18
C 13989 91427 123900 1.18
C 35000 99911 159000 1.18
C 19354 78948 117000 1.19
C 20100 84542 125000 1.19
C 15115 79174 113000 1.2
C 16433 83880 120000 1.2
C 17560 98445 140000 1.21
C 18216 63915 100000 1.22
C 15435 70309 105000 1.22
C 28325 70028 120200 1.22
C 25338 55726 100000 1.23
C 33072 63587 119000 1.23
C 15444 90852 131000 1.23
C 14366 78432 115000 1.24
C 48670 49465 245000 1.24
C 18216 87754 132500 1.25
C 45675 66334 140000 1.25
C 17976 77126 120000 1.26
C 42000 79667 155000 1.27
C 16694 66357 106000 1.28
C 41852 10269 195000 1.28
C 21218 89179 142000 1.29
C 33120 82148 148500 1.29
C 19002 58738 101000 1.3
C 45000 92872 179900 1.3
C 32100 21478 200000 1.3
C 74129 89931 347500 1.32
C 48195 20115 224000 1.33
C 30000 63337 125000 1.34
C 49335 61294 148000 1.34
C 27428 70867 132500 1.35
C 30408 73209 140000 1.35
C 20000 41414 355000 1.36
C 23520 55874 109000 1.37
C 30561 68052 135000 1.37
C 30360 79451 150000 1.37
C 35226 80288 295000 1.37
C 31615 20872 210000 1.38
C 40810 19912 222000 1.38
C 51975 20025 239000 1.39
C 32111 74245 148900 1.4
C 53678 52493 150000 1.41
C 30000 97502 180000 1.41
C 26500 66551 132500 1.42
C 41923 89390 187000 1.42
C 51893 87530 198000 1.42
C 41663 37019 253500 1.42
C 47723 22599 246000 1.44
C 30000 77774 156000 1.45
C 30000 79635 160000 1.46
C 20800 49959 105000 1.48
C 31170 84791 175000 1.51
C 91397 62043 235000 1.53
C 55000 39955 308000 1.58
C 56417 40046 312000 1.59
C 22922 89618 180000 1.6
C 46035 51723 160000 1.64
C 47850 78941 300000 2.37
D 26885 77655 100000 0.96
D 28416 86777 110500 0.96
D 27770 95662 118000 0.96
D 19350 84354 102000 0.98
D 34927 78537 111500 0.98
D 42636 75215 115000 0.98
D 17600 86690 104000 1
D 19339 92928 112300 1
D 33324 99167 132536 1
D 27713 91220 120000 1.01
D 21978 91140 115000 1.02
D 25728 90319 118500 1.02
D 17533 82195 102500 1.03
D 22409 79581 105000 1.03
D 17710 87051 108000 1.03
D 16100 94973 114500 1.03
D 25097 89630 118000 1.03
D 29876 77456 111900 1.04
D 17072 78786 101000 1.05
D 30492 67596 103000 1.05
D 20807 76547 103500 1.06
D 28861 73059 107900 1.06
D 30887 76002 113500 1.06
D 23361 93968 124600 1.06
D 23005 79691 110000 1.07
D 30492 91651 130500 1.07
D 17375 79588 104500 1.08
D 15768 84351 107700 1.08
D 17917 82034 108000 1.08
D 17002 85444 110500 1.08
D 29030 89021 127000 1.08
D 15151 77042 100300 1.09
D 20520 88009 118000 1.09
D 22694 91417 124000 1.09
D 21948 71851 103300 1.1
D 15310 84172 109900 1.1
D 19719 87151 117700 1.1
D 30029 95149 138000 1.1
D 30866 63395 105000 1.11
D 17285 79542 107000 1.11
D 18246 80783 110000 1.11
D 23254 77409 111500 1.11
D 21321 92020 125500 1.11
D 22725 26422 165000 1.11
D 39397 53645 216500 1.12
D 17280 80769 110900 1.13
D 15776 89736 119000 1.13
D 30153 75980 120000 1.13
D 16848 81749 112500 1.14
D 30492 87704 135000 1.14
D 34644 31430 189900 1.14
D 18883 68293 100000 1.15
D 21011 66839 101000 1.15
D 30030 89146 137000 1.15
D 37145 11152 170000 1.15
D 18080 70350 102500 1.16
D 17072 77191 109000 1.16
D 24276 74913 115500 1.16
D 17726 83338 116900 1.16
D 29896 90721 140000 1.16
D 19423 66323 100000 1.17
D 21883 76287 114900 1.17
D 29896 77303 125000 1.17
D 35788 86089 142000 1.17
D 29896 62297 109000 1.18
D 19035 80335 117000 1.18
D 15120 85722 118600 1.18
D 19254 68353 104000 1.19
D 20045 68444 105000 1.19
D 17595 77935 114000 1.19
D 22877 84293 128000 1.19
D 16896 66469 100000 1.2
D 15456 73764 107500 1.2
D 22658 72133 113500 1.2
D 30192 66919 239900 1.22
D 20807 64547 105000 1.23
D 16587 73200 110000 1.23
D 21883 74377 118500 1.23
D 18584 79027 120000 1.23
D 17250 84268 124600 1.23
D 55932 40924 243800 1.24
D 17021 68573 108000 1.26
D 16385 76917 118000 1.26
D 19558 58925 104400 1.33
D 31450 97357 171500 1.33
D 15278 55980 100000 1.4
D 17280 76526 133300 1.42
D 67573 33916 144000 1.42
E 40590 93149 120000 0.9
E 15582 90547 110000 1.04
E 59796 77258 144000 1.05
E 59796 95442 165000 1.06
E 17136 80518 105000 1.08
E 16800 81739 106000 1.08
E 20568 77276 107500 1.1
E 17600 69579 100000 1.15
E 19200 76415 109900 1.15
E 20400 77702 112900 1.15
E 18816 72580 109700 1.2
E 19781 68694 107000 1.21
E 18309 76591 115000 1.21
E 17387 71084 108000 1.22
E 21600 68463 110800 1.23
E 18260 67165 107000 1.25
E 18304 59669 100000 1.28
E 33286 52629 110000 1.28
E 17472 75902 120000 1.29
E 22876 69052 120500 1.31
E 59796 86115 205000 1.4
E 28824 59921 125000 1.41
E 31120 78118 159500 1.46
E 26640 68859 150000 1.57
E 18840 46918 123000 1.87
F 53950 25233 112500 1.42
F 68250 16664 165000 1.94
G 51192 37486 129900 1.46
G 29754 12950 115000 2.69

Freequency Chart

100000-110000 111000-125000 126000-160000 161000-210000 210000-300000 300000-445000 82 103 112 80 34 10 0

Pivot Computation

Row Labels Sum of LANDVAL Sum of IMPROVAL Sum of SALEPRIC Sum of SALTOAPR
A 1423043 1872749 5921200 37.21
B 5766363 11704649 28190500 208.84
C 3168798 6340047 14711900 117.98
D 2105839 6762809 10641336 99.21
E 658779 1841385 3050800 30.95
F 122200 41897 277500 3.36
G 80946 50436 244900 4.15
Grand Total 13325968 28613972 63038136 501.7
Sum of LANDVAL A B C D E F G 1423043 5766363 3168798 2105839 658779 122200 80946 Sum of IMPROVAL A B C D E F G 1872749 11704649 6340047 6762809 1841385 41897 50436 Sum of SALEPRIC A B C D E F G 5921200 28190500 14711900 10641336 3050800 277500 244900 Sum of SALTOAPR A B C D E F G 37.21 208.84000000000012 117.98 99.210000000000036 30.950000000000003 3.36 4.1500000000000004