Data Parsing and Central Limit Thm [CLT] Exercise

profilezoy
CLTParseFileExercise--homeprices-5.xlsx
Home>Business & Finance homework help>Management homework help>Data Parsing and Central Limit Thm [CLT] Exercise

Instructions

This exercise is designed to for gaining experience in handling data. Use the SALES PRICE data to create a histogram. A histogram function exists in the ‘Data Analysis’ tool pack. If that is not available, you will need to create a frequency chart as has been presented in class. Given that the distribution of the data is skewed to the right we need to use the central limit theorem concept to demonstrate that sampling will result in a normal distribution of sample means. Create a column to the left of NBRHOOD and number each record from 1 to 420. Use the RANDBETWEEN function to create a random starting point in the records for each of five samples of 30 each. Use systematic sampling to create the samples. Calculate the sample means for each and graphically compare them to the mean for the population. State whether you think that this exercise validated the Central Limit Theorem? Why or why not? THIS IS AN INDIVIDUAL ASSIGNMENT

homeprices Parse File-txt

NBRHOOD LANDVAL IMPROVAL SALE PRICE SALTOAPR
A 49974 41493 182000 0.95
A 55792 21736 180800 1.02
A 93200 11121 422000 1.04
A 54360 61934 237000 1.1
A 42742 82397 139000 1.11
A 66429 17771 205000 1.11
A 36454 92442 145000 1.12
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