The accompanying data file shows the median house values (in $) for the 50 states as reported by the U.S. Census Bureau in 2010.
Click here for the Excel Data File
a-1. Construct the frequency distribution for the median house values. Use six intervals with widths of 0 < x <= 100,000, 100,000 < x <= 200,000, etc.
a-2. Which interval had the highest frequency?
multiple choice 1
0 < x <= 100,000
100,000 < x <= 200,000
200,000 < x <= 300,000
300,000 < x <= 400,000
400,000 < x <= 500,000
500,000 < x <= 600,000
a-3. How many of the states had median house values of $300,000 or less?
b. Construct the histogram. Is the distribution symmetric? If not, is it positively or negatively skewed?
multiple choice 2
The distribution is relatively symmetric.
The distribution is positively skewed.
The distribution is negatively skewed.
Symmetry or skewness cannot be determined with the available information.
able[[A,B,c,D,E],[State,Income,House_Value,Foreign Born (,No HS Diploma (W)],[Alabama,42081,117600,3.4,18.6],[Alaska,66521,229100,72,93],[Arizona,50448,215000,14.2,15],[Arkansas,39267,102300,4.3,18.1],[California,60883,458500,272,193],[Colorado,56456,236600,9.8,10.7],[Connecticut,67740,295500,132,116],[Delaware,57599,242300,8.2,13],[Florida,47651,205600,192,14.7],[Georgia,49347,161400,9.6,16.5],[Hawaii,66420,537400,17.7,102],[Idaho,46423,172700,59,118],[Illinois,55735,202500,13.6,13.8],[Indiana,47697,123000,4.4,13.8],[Iowa,48872,119200,4.1,10.1],[Kansas,49424,122600,63,10.8],[Kentucky,41576,116900,3.1,19],[Louisiana,43445,130000,3.6,19],[Maine,46933,176200,33,102],[Maryland,70547,329400,132,122],[Massachusetts,64509,352300,14.5,113],[Michigan,48432,144200,59,12],[Minnesota,57243,205200,7,8.7],[Mississippi,37881,96500,22,20.4],[Missouri,46262,137700,3.7,13.8],[Montana,43872,173300,2,9],[Nebraska,49342,123900,59,10],[Nevada,55726,254200,193,15.7],[New Hampshire,63277,253200,53,9.1],[New Jersey,69811,357000,203,127],[New Mexico,43820,158400,9.7,173],[New York,55603,303900,217,15.6],[North Carolina,45570,149100,7.4,16.4],[North Dakota,46781,111300,24,10.6],[Ohio,47358,136400,3.8,126],[Oklahoma,42979,104300,52,14.6],[Oregon,49260,252600,9.7,114],[Pennsylvania,50398,159300,5.6,126],[Rhode Island,54902,279300,126,163],[South Carolina,43939,134100,4.7,17],[South Dakota,46369,122200,23,10.7],[Tennessee,43314,134100,4.4,175],[Texas,49546,123500,16.1,20],[Utah,56330,218100,8.2,9.4],[Vermont,51841,208400,4,9.4],[Virginia,61405,255100,10.8,13.9],[Washington,57244,285400,127,10.4],[West Virginia,38380,94500,13,18.1],[Wisconsin,51598,169000,4.6,10.6],[Wyoming,53902,174000,3.1,8.7]]
A
B C D State| Income House_Value Foreign Born (K) Alabama 42081 117600 3.4 Alaska 66521 229100 7.2 Arizona 50448 215000 14.2 Arkansas 39267 102300 4.3 | California 60883 458500 27.2 Colorado 56456 236600 9.8 Connecticut 67740 296500 13.2 Delaware 57599 242300 8.2 Florida 47661 205600 19.2 Georgia 49347 161400 9.6 Hawaii 66420 537400 17.7 Idaho 46423 172700 5.9 Illinois 55735 202500 13.6 Indiana 47697 123000 4.4 Iowa 48872 119200 4.1 Kansas 49424 122600 6.3 Kentucky 41576 116800 3.1 Louisiana 43445 130000 3.6 Maine 46933 176200 3.3 Maryland 70647 329400 13.2 Massachusetts 64509 352300 14.5 Michigan 48432 144200 5.9 Minnesota 57243 205200 7 Mississippi 37881 96500 2.2 Missouri 46262 137700 3.7 Montana 43872 173300 2 Nebraska 49342 123900 5.9 Nevada 55726 254200 19.3 New Hampshire 63277 253200 5.3 New Jersey 69811 357000 20.3 New Mexico 43820 158400 9.7 New York 55603 303900 21.7 North Carolina 45570 149100 7.4 North Dakota 46781 111300 2.4 Ohio 47358 136400 3.8 Oklahoma 42979 104300 5.2 Oregon 49260 252600 Pennsylvania 50398 159300 5.6 Rhode Island 54902 279300 12.6 South Carolina 43939 134100 4.7 South Dakota 46369 122200 2.3 Tennessee 43314 134100 4.4 Texas 49646 123500 16.1 Utah 56330 218100 8.2 Vermont 51841 208400 4 Virginia 61406 255100 10.8 Washington 57244 285400 12.7 West Virginia 38380 94500 1.3 Wisconsin 51598 169000 4.6 Wyoming 53802 174000 3.1
E
No HS Diploma (%) 18.6 9.3 15 18.1 19.3 10.7 11.6 13 14.7 16 5 10.2 11.8 13.8 13.8 10.1 10.8 19 19 10.2 12.2 20.4 13.8 10 15.7 9.1 12.7 17.3 15.6 16.4 10.6 12.6 14.6 11.4 12.6 16.3 17 10.7 9.4 9.4 13.9 10.4 18.1 10.6 8.7