Assignment:
Discuss the below:
You are a member of the Citizen Budget Committee for the school districts in Northwest Ohio. You have been given a data set for analysis. Based on that data set, please answer the following questions.
a. Comment on the Number of Students per District. Create a 300 words or less, write a short narrative describing the data the data. Using a chart, plot the Number of Students per District. The choice of chart-histogram, pie, stem and leaf, box plot, line, etc.-is up to you, but you must justify why you selected the chart that you did.
b. Using Family Income, calculate and comment on the mean, mode, and median, and which is the most appropriate for describing the data. What is the standard deviation of the Family Income data? Describe the shape of the distribution (normal, skewed, bi-modal, etc.). What is the skewness, if any? Interpret your findings and explain why the shape of the distribution is important to the Committee.
Schools |
Students |
Income |
Property |
Welfare |
Salary |
Instruct |
Attend |
Passing |
C30 |
C31 |
C32 |
C33 |
C34 |
Bluffton |
1132 |
24487 |
62678 |
1.8 |
31221 |
2130 |
95.7 |
85 |
30434 |
43256 |
32273 |
32850 |
32273 |
Shawnee |
2472 |
29777 |
130910 |
2.6 |
34860 |
2570 |
94.7 |
73 |
30242 |
33142 |
31221 |
30282 |
29099 |
Spencerville |
1026 |
23161 |
51645 |
5.4 |
30155 |
2262 |
95.5 |
68 |
35042 |
35879 |
39352 |
30919 |
30476 |
Delphos |
1104 |
21792 |
88453 |
6.2 |
32273 |
2506 |
96.5 |
65 |
32296 |
30904 |
33243 |
31978 |
37983 |
Elida |
3204 |
24446 |
65550 |
8.9 |
32876 |
2250 |
94.1 |
62 |
33166 |
30833 |
28975 |
39542 |
33243 |
Lima |
5963 |
18394 |
44138 |
33.8 |
33142 |
2657 |
92.3 |
40 |
34437 |
32296 |
32166 |
41634 |
31244 |
Northeastern |
1194 |
26428 |
88789 |
1.7 |
30919 |
2431 |
96.1 |
72 |
32164 |
29940 |
35742 |
35879 |
29940 |
Ayersville |
921 |
28228 |
82707 |
3.9 |
32850 |
2693 |
95.6 |
68 |
30765 |
29099 |
30904 |
32773 |
31895 |
Defiance |
3046 |
23812 |
56333 |
11.2 |
34750 |
2438 |
94.2 |
63 |
28195 |
32773 |
33142 |
31821 |
32928 |
Hicksville |
990 |
22448 |
56411 |
7 |
34224 |
2351 |
95.7 |
59 |
35742 |
33243 |
39476 |
30434 |
36065 |
Central |
1216 |
24189 |
53923 |
4.6 |
34430 |
2496 |
94.8 |
56 |
|
|
|
|
|
Berlin-Milan |
1593 |
25223 |
76878 |
4 |
32166 |
2564 |
96.1 |
77 |
|
|
|
|
|
Perkins |
2038 |
25586 |
117545 |
3.3 |
39352 |
2861 |
95.8 |
74 |
|
|
|
|
|
Huron |
1494 |
27135 |
105588 |
4.6 |
33433 |
2968 |
95.4 |
74 |
|
|
|
|
|
Margaretta |
1560 |
23849 |
74601 |
2.8 |
37084 |
2464 |
95.5 |
66 |
|
|
|
|
|
Sandusky |
4426 |
19529 |
72425 |
25.2 |
36042 |
2766 |
93 |
37 |
|
|
|
|
|
Kelleys Island |
20 |
19854 |
802081 |
11.4 |
27144 |
11226 |
95 |
100 |
|
|
|
|
|
Pettisville |
503 |
25079 |
53948 |
3.9 |
31159 |
2834 |
96.1 |
78 |
|
|
|
|
|
Wauseon |
1864 |
23408 |
60896 |
4.9 |
32499 |
2252 |
95.3 |
75 |
|
|
|
|
|
Evergreen |
1238 |
23826 |
69432 |
5.2 |
32353 |
2250 |
95 |
72 |
|
|
|
|
|
Archbold-Area |
1401 |
26706 |
107547 |
4.1 |
35982 |
2837 |
96.2 |
69 |
|
|
|
|
|
Pike-Delta-York |
1559 |
23396 |
48638 |
6.1 |
31310 |
2309 |
94.8 |
66 |
|
|
|
|
|
Gorham-Fayette |
487 |
22405 |
57221 |
6.9 |
33166 |
2492 |
94.6 |
51 |
|
|
|
|
|
Swanton |
1725 |
24596 |
69320 |
6.3 |
33690 |
2615 |
94.9 |
50 |
|
|
|
|
|
Arlington |
685 |
26175 |
55478 |
2.7 |
31821 |
2205 |
96.5 |
84 |
|
|
|
|
|
Vanlue |
346 |
24709 |
49606 |
4.1 |
28411 |
2420 |
96.2 |
83 |
|
|
|
|
|
Liberty-Benton |
954 |
28718 |
77503 |
1.5 |
30330 |
2063 |
96.7 |
78 |
|
|
|
|
|
Van Buren |
840 |
28964 |
151992 |
1.8 |
33447 |
2584 |
96.4 |
75 |
|
|
|
|
|
Cory-Rawson |
794 |
23904 |
69242 |
2.4 |
31241 |
2416 |
96.4 |
73 |
|
|
|
|
|
Arcadia |
597 |
24305 |
78102 |
2.5 |
30738 |
2752 |
95.9 |
64 |
|
|
|
|
|
McComb |
805 |
23754 |
69347 |
5.7 |
28986 |
2321 |
95.9 |
61 |
|
|
|
|
|
Findlay |
5758 |
24269 |
92648 |
7.6 |
35879 |
2860 |
94.9 |
60 |
|
|
|
|
|
Ada |
855 |
23029 |
52655 |
5.3 |
28479 |
2380 |
95.9 |
69 |
|
|
|
|
|
Kenton |
2228 |
20418 |
61155 |
13.8 |
30907 |
2512 |
93.7 |
54 |
|
|
|
|
|
Liberty Center |
1009 |
24723 |
57685 |
4.1 |
30904 |
2431 |
95.8 |
82 |
|
|
|
|
|
Patrick Henry |
1176 |
23061 |
63134 |
5.2 |
31895 |
2552 |
95.9 |
75 |
|
|
|
|
|
Napoleon Area |
2331 |
25304 |
84245 |
6.6 |
32773 |
2422 |
94.6 |
73 |
|
|
|
|
|
Holgate |
605 |
23962 |
49709 |
6 |
31324 |
2454 |
94.9 |
71 |
|
|
|
|
|
Monroeville |
686 |
22942 |
63103 |
4.3 |
30838 |
2474 |
95.8 |
64 |
|
|
|
|
|
Bellevue |
2276 |
24025 |
66912 |
6.9 |
32164 |
2374 |
95.1 |
55 |
|
|
|
|
|
Willard |
2300 |
23304 |
58832 |
14.3 |
35042 |
2347 |
94.6 |
53 |
|
|
|
|
|
Norwalk |
2650 |
21551 |
72266 |
12.2 |
37145 |
2384 |
94 |
50 |
|
|
|
|
|
Ottawa Hills |
933 |
45723 |
122356 |
0.2 |
43256 |
4150 |
95.7 |
95 |
|
|
|
|
|
Anthony Wayne |
3178 |
29215 |
88004 |
3.1 |
35617 |
2844 |
95.3 |
75 |
|
|
|
|
|
Sylvania |
7822 |
32114 |
101503 |
3.8 |
39684 |
2943 |
95.5 |
72 |
|
|
|
|
|
Maumee |
3009 |
27604 |
117921 |
3.9 |
41634 |
3933 |
95 |
69 |
|
|
|
|
|
Oregon |
3594 |
24525 |
123599 |
8.7 |
35848 |
2941 |
94.7 |
52 |
|
|
|
|
|
Washington |
7154 |
23507 |
102485 |
11.8 |
39155 |
2997 |
93.7 |
51 |
|
|
|
|
|
Springfield |
3575 |
26048 |
98346 |
12.2 |
34437 |
2774 |
93.8 |
49 |
|
|
|
|
|
Toledo |
36790 |
21079 |
62668 |
42.8 |
36190 |
2611 |
90.7 |
28 |
|
|
|
|
|
Benton Carroll Salem |
2063 |
23899 |
237206 |
4.7 |
42734 |
3444 |
95.6 |
81 |
|
|
|
|
|
Danbury |
635 |
21325 |
182360 |
3.2 |
34971 |
3158 |
95.3 |
65 |
|
|
|
|
|
Genoa |
1584 |
25321 |
53120 |
4.8 |
34661 |
2845 |
95.9 |
65 |
|
|
|
|
|
Port Clinton |
2238 |
20941 |
129961 |
10.5 |
39542 |
2926 |
94.5 |
50 |
|
|
|
|
|
Put-in-Bay |
70 |
19266 |
426419 |
1.4 |
30242 |
7824 |
94.5 |
33 |
|
|
|
|
|
Paulding |
1993 |
22677 |
46163 |
8.6 |
32928 |
2560 |
94.5 |
59 |
|
|
|
|
|
Ottoville |
610 |
24128 |
46582 |
0.2 |
26125 |
2588 |
99.8 |
86 |
|
|
|
|
|
Columbus Grove |
866 |
23562 |
55568 |
8.4 |
30476 |
2174 |
96.2 |
84 |
|
|
|
|
|
Kalida |
775 |
24456 |
44267 |
0.7 |
28962 |
2274 |
96.8 |
81 |
|
|
|
|
|
Continental |
792 |
23625 |
37277 |
10 |
28945 |
2225 |
95.5 |
79 |
|
|
|
|
|
Ottawa-glandorf |
1749 |
25363 |
64288 |
6.5 |
31185 |
2154 |
96.5 |
77 |
|
|
|
|
|
Pandora-Gilboa |
632 |
23806 |
55446 |
1.2 |
27693 |
2078 |
96.5 |
67 |
|
|
|
|
|
Leipsic |
748 |
20941 |
62648 |
16.1 |
30282 |
2811 |
93.9 |
47 |
|
|
|
|
|
Gibsonburg |
983 |
23312 |
46098 |
17.8 |
31244 |
2242 |
94.4 |
71 |
|
|
|
|
|
Lakota |
1332 |
22678 |
55933 |
10.5 |
30765 |
2306 |
95.2 |
66 |
|
|
|
|
|
Fremont |
5156 |
22327 |
74874 |
16.2 |
37759 |
2616 |
94.7 |
57 |
|
|
|
|
|
Woodmore |
1141 |
26460 |
90484 |
10.9 |
32296 |
2227 |
96.5 |
56 |
|
|
|
|
|
Clyde-Green Springs |
2368 |
23854 |
55724 |
7 |
33998 |
2383 |
94.6 |
47 |
|
|
|
|
|
Bettsville |
347 |
22103 |
37269 |
6.1 |
27466 |
2394 |
95.8 |
83 |
|
|
|
|
|
Seneca East |
1183 |
22656 |
50895 |
4.8 |
29940 |
2435 |
95.9 |
80 |
|
|
|
|
|
Old Fort |
540 |
23208 |
50712 |
19.3 |
28195 |
2743 |
96 |
78 |
|
|
|
|
|
Hopewell-Loudon |
870 |
22103 |
72201 |
4.7 |
30644 |
2564 |
94.6 |
74 |
|
|
|
|
|
New Riegel |
459 |
23314 |
41376 |
2.7 |
29099 |
2501 |
97 |
73 |
|
|
|
|
|
Tiffin |
3632 |
21246 |
65291 |
9 |
35513 |
2506 |
94.7 |
67 |
|
|
|
|
|
Fostoria |
2742 |
20809 |
62268 |
20.4 |
34241 |
2455 |
92.7 |
34 |
|
|
|
|
|
Van Wert |
2504 |
22728 |
67932 |
7.1 |
33885 |
2511 |
95.3 |
61 |
|
|
|
|
|
Edon-Northwest |
744 |
23035 |
38462 |
2.7 |
30833 |
1916 |
95.1 |
73 |
|
|
|
|
|
Milcreek-West Unity |
788 |
21302 |
40239 |
3.2 |
31582 |
2382 |
95.9 |
71 |
|
|
|
|
|
Bryan |
2266 |
22607 |
81152 |
4.2 |
32643 |
2706 |
95.2 |
69 |
|
|
|
|
|
North Central |
757 |
21871 |
59396 |
2.9 |
31978 |
2349 |
95.6 |
68 |
|
|
|
|
|
Montpelier |
1172 |
20787 |
44383 |
8.2 |
33243 |
2654 |
94.8 |
67 |
|
|
|
|
|
Edgerton |
767 |
22429 |
54040 |
4.1 |
28975 |
2470 |
95.9 |
61 |
|
|
|
|
|
Stryker |
579 |
24084 |
65532 |
3.4 |
33855 |
2617 |
95.7 |
47 |
|
|
|
|
|
Perrysburg |
3839 |
32773 |
97888 |
2.6 |
40320 |
3011 |
96.1 |
98 |
|
|
|
|
|
Elmwood |
1237 |
22179 |
47644 |
7.5 |
30434 |
2643 |
95.2 |
68 |
|
|
|
|
|
Bowling Green |
3534 |
21307 |
84682 |
7.5 |
37983 |
2849 |
94.7 |
68 |
|
|
|
|
|
Otsego |
1643 |
24614 |
57601 |
5 |
36065 |
2539 |
95.4 |
64 |
|
|
|
|
|
Northwood |
1091 |
25905 |
77077 |
7.9 |
35536 |
2979 |
94.9 |
61 |
|
|
|
|
|
Eastwood |
1739 |
25043 |
67929 |
4.7 |
35742 |
2499 |
95.9 |
60 |
|
|
|
|
|
Lake |
1665 |
23559 |
95859 |
6.2 |
38046 |
2820 |
95.2 |
55 |
|
|
|
|
|
Rossford |
2087 |
25360 |
123725 |
7.2 |
39476 |
3258 |
94.9 |
54 |
|
|
|
|
|
North Baltimore |
839 |
22075 |
58383 |
10.6 |
29579 |
2331 |
94.5 |
50 |
|
|
|
|
|
Upper Sandusky |
1801 |
21063 |
68348 |
3.9 |
32778 |
2267 |
95.6 |
62 |
|
|
|
|
|
Carey |
915 |
21658 |
51497 |
6 |
30968 |
2513 |
95.5 |
59 |
|
|
|
|
|