6 assignments
usa94
SchoolsData.xlsxSchoolData
| Schools | Number of Students | Average Family Income | Average Property Value | Welfare Percent | Avg Salary | Spend per Student | Average Attendance Percent | Passing Percent | Example Descriptive Statistics | |||
| Bluffton | 1132 | $ 24,487 | $ 62,678.00 | 1.80 | $ 31,221 | $ 2,130 | 95.7 | 85 | ||||
| Shawnee | 2472 | $ 29,777 | $ 130,910.00 | 2.60 | $ 34,860 | $ 2,570 | 94.7 | 73 | Teachers Salary | |||
| Spencerville | 1026 | $ 23,161 | $ 51,645.00 | 5.40 | $ 30,155 | $ 2,262 | 95.5 | 68 | ||||
| Delphos | 1104 | $ 21,792 | $ 88,453.00 | 6.20 | $ 32,273 | $ 2,506 | 96.5 | 65 | Mean Teachers Salary | $ 33,181.40 | ||
| Elida | 3204 | $ 24,446 | $ 65,550.00 | 8.90 | $ 32,876 | $ 2,250 | 94.1 | 62 | Median Teachers Salary | $ 32,708.00 | ||
| Lima | 5963 | $ 18,394 | $ 44,138.00 | 33.80 | $ 33,142 | $ 2,657 | 92.3 | 40 | Standard Deviation | $ 3,548.50 | ||
| Northeastern | 1194 | $ 26,428 | $ 88,789.00 | 1.70 | $ 30,919 | $ 2,431 | 96.1 | 72 | Coefficient of Skew | 0.67 | ||
| Ayersville | 921 | $ 28,228 | $ 82,707.00 | 3.90 | $ 32,850 | $ 2,693 | 95.6 | 68 | ||||
| Defiance | 3046 | $ 23,812 | $ 56,333.00 | 11.20 | $ 34,750 | $ 2,438 | 94.2 | 63 | Number of Students | |||
| Hicksville | 990 | $ 22,448 | $ 56,411.00 | 7.00 | $ 34,224 | $ 2,351 | 95.7 | 59 | ||||
| Central | 1216 | $ 24,189 | $ 53,923.00 | 4.60 | $ 34,430 | $ 2,496 | 94.8 | 56 | Mean Number of Students | 2,134 | ||
| Berlin-Milan | 1593 | $ 25,223 | $ 76,878.00 | 4.00 | $ 32,166 | $ 2,564 | 96.1 | 77 | Median Number of Students | 1,227 | ||
| Perkins | 2038 | $ 25,586 | $ 117,545.00 | 3.30 | $ 39,352 | $ 2,861 | 95.8 | 74 | Standard Deviation | 3,880 | ||
| Huron | 1494 | $ 27,135 | $ 105,588.00 | 4.60 | $ 33,433 | $ 2,968 | 95.4 | 74 | Coefficient of Skew | 7.80 | ||
| Margaretta | 1560 | $ 23,849 | $ 74,601.00 | 2.80 | $ 37,084 | $ 2,464 | 95.5 | 66 | ||||
| Sandusky | 4426 | $ 19,529 | $ 72,425.00 | 25.20 | $ 36,042 | $ 2,766 | 93 | 37 | ||||
| Kelleys Island | 20 | $ 19,854 | $ 802,081.00 | 11.40 | $ 27,144 | $ 11,226 | 95 | 100 | ||||
| Pettisville | 503 | $ 25,079 | $ 53,948.00 | 3.90 | $ 31,159 | $ 2,834 | 96.1 | 78 | ||||
| Wauseon | 1864 | $ 23,408 | $ 60,896.00 | 4.90 | $ 32,499 | $ 2,252 | 95.3 | 75 | ||||
| Evergreen | 1238 | $ 23,826 | $ 69,432.00 | 5.20 | $ 32,353 | $ 2,250 | 95 | 72 | ||||
| Archbold-Area | 1401 | $ 26,706 | $ 107,547.00 | 4.10 | $ 35,982 | $ 2,837 | 96.2 | 69 | ||||
| Pike-Delta-York | 1559 | $ 23,396 | $ 48,638.00 | 6.10 | $ 31,310 | $ 2,309 | 94.8 | 66 | ||||
| Gorham-Fayette | 487 | $ 22,405 | $ 57,221.00 | 6.90 | $ 33,166 | $ 2,492 | 94.6 | 51 | ||||
| Swanton | 1725 | $ 24,596 | $ 69,320.00 | 6.30 | $ 33,690 | $ 2,615 | 94.9 | 50 | ||||
| Arlington | 685 | $ 26,175 | $ 55,478.00 | 2.70 | $ 31,821 | $ 2,205 | 96.5 | 84 | ||||
| Vanlue | 346 | $ 24,709 | $ 49,606.00 | 4.10 | $ 28,411 | $ 2,420 | 96.2 | 83 | ||||
| Liberty-Benton | 954 | $ 28,718 | $ 77,503.00 | 1.50 | $ 30,330 | $ 2,063 | 96.7 | 78 | ||||
| Van Buren | 840 | $ 28,964 | $ 151,992.00 | 1.80 | $ 33,447 | $ 2,584 | 96.4 | 75 | ||||
| Cory-Rawson | 794 | $ 23,904 | $ 69,242.00 | 2.40 | $ 31,241 | $ 2,416 | 96.4 | 73 | ||||
| Arcadia | 597 | $ 24,305 | $ 78,102.00 | 2.50 | $ 30,738 | $ 2,752 | 95.9 | 64 | ||||
| McComb | 805 | $ 23,754 | $ 69,347.00 | 5.70 | $ 28,986 | $ 2,321 | 95.9 | 61 | ||||
| Findlay | 5758 | $ 24,269 | $ 92,648.00 | 7.60 | $ 35,879 | $ 2,860 | 94.9 | 60 | ||||
| Ada | 855 | $ 23,029 | $ 52,655.00 | 5.30 | $ 28,479 | $ 2,380 | 95.9 | 69 | ||||
| Kenton | 2228 | $ 20,418 | $ 61,155.00 | 13.80 | $ 30,907 | $ 2,512 | 93.7 | 54 | ||||
| Liberty Center | 1009 | $ 24,723 | $ 57,685.00 | 4.10 | $ 30,904 | $ 2,431 | 95.8 | 82 | ||||
| Patrick Henry | 1176 | $ 23,061 | $ 63,134.00 | 5.20 | $ 31,895 | $ 2,552 | 95.9 | 75 | ||||
| Napoleon Area | 2331 | $ 25,304 | $ 84,245.00 | 6.60 | $ 32,773 | $ 2,422 | 94.6 | 73 | ||||
| Holgate | 605 | $ 23,962 | $ 49,709.00 | 6.00 | $ 31,324 | $ 2,454 | 94.9 | 71 | ||||
| Monroeville | 686 | $ 22,942 | $ 63,103.00 | 4.30 | $ 30,838 | $ 2,474 | 95.8 | 64 | ||||
| Bellevue | 2276 | $ 24,025 | $ 66,912.00 | 6.90 | $ 32,164 | $ 2,374 | 95.1 | 55 | ||||
| Willard | 2300 | $ 23,304 | $ 58,832.00 | 14.30 | $ 35,042 | $ 2,347 | 94.6 | 53 | ||||
| Norwalk | 2650 | $ 21,551 | $ 72,266.00 | 12.20 | $ 37,145 | $ 2,384 | 94 | 50 | ||||
| Ottawa Hills | 933 | $ 45,723 | $ 122,356.00 | 0.20 | $ 43,256 | $ 4,150 | 95.7 | 95 | ||||
| Anthony Wayne | 3178 | $ 29,215 | $ 88,004.00 | 3.10 | $ 35,617 | $ 2,844 | 95.3 | 75 | ||||
| Sylvania | 7822 | $ 32,114 | $ 101,503.00 | 3.80 | $ 39,684 | $ 2,943 | 95.5 | 72 | ||||
| Maumee | 3009 | $ 27,604 | $ 117,921.00 | 3.90 | $ 41,634 | $ 3,933 | 95 | 69 | ||||
| Oregon | 3594 | $ 24,525 | $ 123,599.00 | 8.70 | $ 35,848 | $ 2,941 | 94.7 | 52 | ||||
| Washington | 7154 | $ 23,507 | $ 102,485.00 | 11.80 | $ 39,155 | $ 2,997 | 93.7 | 51 | ||||
| Springfield | 3575 | $ 26,048 | $ 98,346.00 | 12.20 | $ 34,437 | $ 2,774 | 93.8 | 49 | ||||
| Toledo | 36790 | $ 21,079 | $ 62,668.00 | 42.80 | $ 36,190 | $ 2,611 | 90.7 | 28 | ||||
| Benton Carroll Salem | 2063 | $ 23,899 | $ 237,206.00 | 4.70 | $ 42,734 | $ 3,444 | 95.6 | 81 | ||||
| Danbury | 635 | $ 21,325 | $ 182,360.00 | 3.20 | $ 34,971 | $ 3,158 | 95.3 | 65 | ||||
| Genoa | 1584 | $ 25,321 | $ 53,120.00 | 4.80 | $ 34,661 | $ 2,845 | 95.9 | 65 | ||||
| Port Clinton | 2238 | $ 20,941 | $ 129,961.00 | 10.50 | $ 39,542 | $ 2,926 | 94.5 | 50 | ||||
| Put-in-Bay | 70 | $ 19,266 | $ 426,419.00 | 1.40 | $ 30,242 | $ 7,824 | 94.5 | 33 | ||||
| Paulding | 1993 | $ 22,677 | $ 46,163.00 | 8.60 | $ 32,928 | $ 2,560 | 94.5 | 59 | ||||
| Ottoville | 610 | $ 24,128 | $ 46,582.00 | 0.20 | $ 26,125 | $ 2,588 | 99.8 | 86 | ||||
| Columbus Grove | 866 | $ 23,562 | $ 55,568.00 | 8.40 | $ 30,476 | $ 2,174 | 96.2 | 84 | ||||
| Kalida | 775 | $ 24,456 | $ 44,267.00 | 0.70 | $ 28,962 | $ 2,274 | 96.8 | 81 | ||||
| Continental | 792 | $ 23,625 | $ 37,277.00 | 10.00 | $ 28,945 | $ 2,225 | 95.5 | 79 | ||||
| Ottawa-glandorf | 1749 | $ 25,363 | $ 64,288.00 | 6.50 | $ 31,185 | $ 2,154 | 96.5 | 77 | ||||
| Pandora-Gilboa | 632 | $ 23,806 | $ 55,446.00 | 1.20 | $ 27,693 | $ 2,078 | 96.5 | 67 | ||||
| Leipsic | 748 | $ 20,941 | $ 62,648.00 | 16.10 | $ 30,282 | $ 2,811 | 93.9 | 47 | ||||
| Gibsonburg | 983 | $ 23,312 | $ 46,098.00 | 17.80 | $ 31,244 | $ 2,242 | 94.4 | 71 | ||||
| Lakota | 1332 | $ 22,678 | $ 55,933.00 | 10.50 | $ 30,765 | $ 2,306 | 95.2 | 66 | ||||
| Fremont | 5156 | $ 22,327 | $ 74,874.00 | 16.20 | $ 37,759 | $ 2,616 | 94.7 | 57 | ||||
| Woodmore | 1141 | $ 26,460 | $ 90,484.00 | 10.90 | $ 32,296 | $ 2,227 | 96.5 | 56 | ||||
| Clyde-Green Springs | 2368 | $ 23,854 | $ 55,724.00 | 7.00 | $ 33,998 | $ 2,383 | 94.6 | 47 | ||||
| Bettsville | 347 | $ 22,103 | $ 37,269.00 | 6.10 | $ 27,466 | $ 2,394 | 95.8 | 83 | ||||
| Seneca East | 1183 | $ 22,656 | $ 50,895.00 | 4.80 | $ 29,940 | $ 2,435 | 95.9 | 80 | ||||
| Old Fort | 540 | $ 23,208 | $ 50,712.00 | 19.30 | $ 28,195 | $ 2,743 | 96 | 78 | ||||
| Hopewell-Loudon | 870 | $ 22,103 | $ 72,201.00 | 4.70 | $ 30,644 | $ 2,564 | 94.6 | 74 | ||||
| New Riegel | 459 | $ 23,314 | $ 41,376.00 | 2.70 | $ 29,099 | $ 2,501 | 97 | 73 | ||||
| Tiffin | 3632 | $ 21,246 | $ 65,291.00 | 9.00 | $ 35,513 | $ 2,506 | 94.7 | 67 | ||||
| Fostoria | 2742 | $ 20,809 | $ 62,268.00 | 20.40 | $ 34,241 | $ 2,455 | 92.7 | 34 | ||||
| Van Wert | 2504 | $ 22,728 | $ 67,932.00 | 7.10 | $ 33,885 | $ 2,511 | 95.3 | 61 | ||||
| Edon-Northwest | 744 | $ 23,035 | $ 38,462.00 | 2.70 | $ 30,833 | $ 1,916 | 95.1 | 73 | ||||
| Milcreek-West Unity | 788 | $ 21,302 | $ 40,239.00 | 3.20 | $ 31,582 | $ 2,382 | 95.9 | 71 | ||||
| Bryan | 2266 | $ 22,607 | $ 81,152.00 | 4.20 | $ 32,643 | $ 2,706 | 95.2 | 69 | ||||
| North Central | 757 | $ 21,871 | $ 59,396.00 | 2.90 | $ 31,978 | $ 2,349 | 95.6 | 68 | ||||
| Montpelier | 1172 | $ 20,787 | $ 44,383.00 | 8.20 | $ 33,243 | $ 2,654 | 94.8 | 67 | ||||
| Edgerton | 767 | $ 22,429 | $ 54,040.00 | 4.10 | $ 28,975 | $ 2,470 | 95.9 | 61 | ||||
| Stryker | 579 | $ 24,084 | $ 65,532.00 | 3.40 | $ 33,855 | $ 2,617 | 95.7 | 47 | ||||
| Perrysburg | 3839 | $ 32,773 | $ 97,888.00 | 2.60 | $ 40,320 | $ 3,011 | 96.1 | 98 | ||||
| Elmwood | 1237 | $ 22,179 | $ 47,644.00 | 7.50 | $ 30,434 | $ 2,643 | 95.2 | 68 | ||||
| Bowling Green | 3534 | $ 21,307 | $ 84,682.00 | 7.50 | $ 37,983 | $ 2,849 | 94.7 | 68 | ||||
| Otsego | 1643 | $ 24,614 | $ 57,601.00 | 5.00 | $ 36,065 | $ 2,539 | 95.4 | 64 | ||||
| Northwood | 1091 | $ 25,905 | $ 77,077.00 | 7.90 | $ 35,536 | $ 2,979 | 94.9 | 61 | ||||
| Eastwood | 1739 | $ 25,043 | $ 67,929.00 | 4.70 | $ 35,742 | $ 2,499 | 95.9 | 60 | ||||
| Lake | 1665 | $ 23,559 | $ 95,859.00 | 6.20 | $ 38,046 | $ 2,820 | 95.2 | 55 | ||||
| Rossford | 2087 | $ 25,360 | $ 123,725.00 | 7.20 | $ 39,476 | $ 3,258 | 94.9 | 54 | ||||
| North Baltimore | 839 | $ 22,075 | $ 58,383.00 | 10.60 | $ 29,579 | $ 2,331 | 94.5 | 50 | ||||
| Upper Sandusky | 1801 | $ 21,063 | $ 68,348.00 | 3.90 | $ 32,778 | $ 2,267 | 95.6 | 62 | ||||
| Carey | 915 | $ 21,658 | $ 51,497.00 | 6.00 | $ 30,968 | $ 2,513 | 95.5 | 59 |
Variables
| Variables |
| X1 = Name of district |
| X2 = Number of students |
| X3 = Mean family income in the district ($) |
| X4 = Mean property value in the district ($) |
| X5 = Percent of families receiving welfare |
| X6 = Mean salary of classroom teachers ($) |
| X7 = Amount spent per pupil ($) |
| X8 = Mean daily attendance |
| X9 = Percent passing 12th grade proficiency exam |
