6 assignments

usa94
SchoolsData.xlsx

SchoolData

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