Data Overview
The data pertains exclusively to schools in Manhattan, specifically those with the system code "M", and schools in Brooklyn, system code "K".The current dataset includes all such schools, with enrollment numbers ranging from 51 (Judith S. Kaye School) to 3,331 (Stuyvesant High School) for schools with system code “M”, and from 51 (G. Westinghouse Evening H.S.) to 5,942 (Brooklyn Technical High School) for schools with system code “K”.
Manhattan Schools
Removal Rate
The schools with the highest removal rates are as follows. Where the removal rates were calculated with the formula: Removal/Total Enrollment:
- The Urban Assembly School for Emergency Management: 118 removals (39.33%)
- Isaac Newton Middle School for Math & Science: 67 removals (21.20%)
- City Knoll Middle School: 37 removals (20.11%)
- P.S. 030 Hernandez/Hughes: 29 removals (16.86%)
- Mott Hall II: 55 removals (15.28%)
- Teachers College Community School: 40 removals (12.27%)
- Mosaic Preparatory Academy: 20 removals (10.87%)
- P.S. 015 Roberto Clemente: 15 removals (8.33%)
- P.S. 108 Assemblyman Angelo Del Toro Educational Center: 25 removals (7.23%)
- P.S. 242 - The Young Diplomats Magnet Academy: 7 removals (7.14%)
- P.S. 111 Adolph S. Ochs: 28 removals (6.98%)
- P.S. 096 Joseph Lanzetta: 22 removals (6.73%)
- M.S. 297: 32 removals (6.67%)
- J.H.S. 167 Robert F. Wagner: 62 removals (6.08%)
- Community Action School - MS 258: 7 removals (5.69%)
- P.S. 076 A. Philip Randolph: 17 removals (5.61%)
- P.S. 134 Henrietta Szold: 9 removals (4.95%)
- P.S. 092 Mary McLeod Bethune: 9 removals (4.89%)
- Frederick Douglass Academy II Secondary School: 16 removals (4.88%)
- The Urban Assembly School for Global Commerce: (0, 14) removals (4.61%)
- P.S./I.S. 217 Roosevelt Island: 32 removals (4.44%)
Principal Suspension Rate
The schools with the highest “Principal Rate” are as follows. Where the rates were calculated with the formula: #Principal/Total Enrollment:
- The Maxine Greene HS for Imaginative Inquiry: 53.64% Principal Suspension Rate
- High School of Hospitality Management: 25.71% Principal Suspension Rate
- Heritage School, The: 24.45% Principal Suspension Rate
- City Knoll Middle School: 23.91% Principal Suspension Rate
- M.S. 224 Manhattan East School for Arts & Academic: 16.94% Principal Suspension Rate
- The Urban Assembly School for Green Careers: 16.94% Principal Suspension Rate
- Thurgood Marshall Academy for Learning and Social: 16.35% Principal Suspension Rate
- Academy for Software Engineering: 16.26% Principal Suspension Rate
- Esperanza Preparatory Academy: 15.20% Principal Suspension Rate
- M.S. 297: 14.38% Principal Suspension Rate
- The Urban Assembly School for Emergency Management: 14.00% Principal Suspension Rate
- Murry Bergtraum High School for Business Careers: 13.73% Principal Suspension Rate
- M.S. 250 West Side Collaborative Middle School: 13.33% Principal Suspension Rate
- Urban Assembly Academy of Government and Law, The: 12.07% Principal Suspension Rate
- School of Earth Exploration and Discovery Harlem: 11.20% Principal Suspension Rate
- Harold O. Levy School: 11.03% Principal Suspension Rate
- The High School for Climate Justice: 10.32% Principal Suspension Rate
- Mott Hall II: 10.00% Principal Suspension Rate
- M.S. 324 - Patria Mirabal: 9.91% Principal Suspension Rate
Superintendent Suspension Rate
The schools with the highest “Superintendent Rate” are as follows. Where the rates were calculated with the formula: #Superintendent/Total Enrollment:
- City Knoll Middle School: 14.67% Superintendent Suspension Rate
- The Urban Assembly School for Global Commerce: 13.16% Superintendent Suspension Rate
- The High School For Language And Diplomacy: 11.92% Superintendent Suspension Rate
- Harold O. Levy School: 10.34% Superintendent Suspension Rate
- M.S. 224 Manhattan East School for Arts & Academic: 8.20% Superintendent Suspension Rate
- Urban Assembly Academy for Future Leaders: 7.89% Superintendent Suspension Rate
- Community Health Academy of the Heights: 7.52% Superintendent Suspension Rate
- Frederick Douglass Academy II Secondary School: 7.32% Superintendent Suspension Rate
- School for Global Leaders: 6.16% Superintendent Suspension Rate
- P.S. 206 Jose Celso Barbosa: 5.71% Superintendent Suspension Rate
- School of Earth Exploration and Discovery Harlem: 5.60% Superintendent Suspension Rate
- M.S. 297: 5.00% Superintendent Suspension Rate
- P.S. 123 Mahalia Jackson: 5.00% Superintendent Suspension Rate
- P.S. 046 Arthur Tappan: 4.85% Superintendent Suspension Rate
- Frederick Douglass Academy: 4.78% Superintendent Suspension Rate
- The Urban Assembly School for Emergency Management: 4.67% Superintendent Suspension Rate
- P.S. 076 A. Philip Randolph: 4.62% Superintendent Suspension Rate
- P.S. 034 Franklin D. Roosevelt: 4.55% Superintendent Suspension Rate
- Heritage School, The: 4.39% Superintendent Suspension Rate
- Business Of Sports School: 4.38% Superintendent Suspension Rate
- New Design Middle School: 4.11% Superintendent Suspension Rate
Total Suspension Rate
The schools with the highest “Total Suspension Rate” are as follows. Where the rates were calculated with the formula: #TotalSuspension /Total Enrollment. Total suspension is derived from adding Principal and Superintendent count together. In the case where there are “R” values, a max, min, and avg is derived from subtracting the total removal + suspension – “R”:
- The Maxine Greene HS for Imaginative Inquiry: 54.09%
- City Knoll Middle School: 38.59%
- Heritage School, The: 28.84%
- High School of Hospitality Management: 26.43%
- M.S. 224 Manhattan East School for Arts & Academic: 25.14%
- Harold O. Levy School: 21.38%
- The Urban Assembly School for Green Careers: 19.87%
- Thurgood Marshall Academy for Learning and Social: 19.50%
- M.S. 297: 19.38%
- The Urban Assembly School for Emergency Management: 18.67%
- The Urban Assembly School for Global Commerce: 17.76%
- Academy for Software Engineering: 17.35%
- School of Earth Exploration and Discovery Harlem: 16.80%
- Esperanza Preparatory Academy: 16.00%
- Frederick Douglass Academy II Secondary School: 15.24%
- P.S. 206 Jose Celso Barbosa: 14.52%
- The High School For Language And Diplomacy: 13.91%
- Murry Bergtraum High School for Business Careers: 13.73%
- Manhattan Early College School for Advertising: 13.52%
- M.S. 250 West Side Collaborative Middle School: 13.33%
- M.S. 324 - Patria Mirabal: 13.06%
- Mott Hall II: 13.06%
- Urban Assembly Academy of Government and Law, The: 12.93%
- P.S. 076 A. Philip Randolph: 11.55%
- The High School for Climate Justice: 11.29%
- Community Health Academy of the Heights: 11.27%
- P.S. 123 Mahalia Jackson: 11.00%
SWD Principal Suspension Rate
- The Maxine Greene HS for Imaginative Inquiry: 77.14%
- High School of Hospitality Management: 57.45%
- City Knoll Middle School: 35.42%
- Heritage School, The: 34.12%
- The Urban Assembly School for Green Careers: 31.94%
- Academy for Software Engineering: 26.73%
- M.S. 297: 25.23%
- The Urban Assembly School for Emergency Management: 22.73%
- Harvest Collegiate High School: 22.34%
- Esperanza Preparatory Academy: 22.22%
- M.S. 324 - Patria Mirabal: 22.22%
- Repertory Company High School for Theatre Arts: 22.22%
- Thurgood Marshall Academy for Learning and Social: 20.29%
- P.S. 076 A. Philip Randolph: 20.29%
- Manhattan Early College School for Advertising: 18.67%
- Urban Assembly Academy of Government and Law, The: 18.18%
- Urban Assembly New York Harbor School: 17.04%
- Mott Hall II: 15.79%
- Middle School 322: 14.58%
- High School of Arts and Technology: 14.04%
- Talent Unlimited High School: 13.24%
- P.S. 123 Mahalia Jackson: 13.18%
- Community Health Academy of the Heights: 12.50%
- J.H.S. 104 Simon Baruch: 12.21%
- The High School for Climate Justice: 12.00%
- Food and Finance High School: 11.82%
- Urban Assembly School of Design and Construction: 11.67%
- I.S. 528 Bea Fuller Rodgers School: 11.48%
- New Explorations into Science, Technology and Math: 11.01%
- High School for Environmental Studies: 10.93%
SWD Superintendent Suspension Rate
- City Knoll Middle School: 33.33%
- The Urban Assembly School for Global Commerce: 22.81%
- The High School For Language And Diplomacy: 18.75%
- M.S. 224 Manhattan East School for Arts & Academic: 18.37%
- Gregorio Luperon High School for Science and Mathematics: 17.39%
- Community Health Academy of the Heights: 13.89%
- Thurgood Marshall Academy for Learning and Social: 12.32%
- M.S. 297: 12.15%
- The Urban Assembly School for Emergency Management: 10.61%
- P.S. 123 Mahalia Jackson: 9.30%
- Frederick Douglass Academy II Secondary School: 9.00%
- Urban Assembly New York Harbor School: 8.15%
- Frederick Douglass Academy: 7.85%
- James Weldon Johnson: 6.85%
- P.S. 046 Arthur Tappan: 6.82%
- J.H.S. 104 Simon Baruch: 6.11%
- School of the Future High School: 5.46%
- P.S. 206 Jose Celso Barbosa: 4.32%
- High School for Health Professions and Human Services: 2.79%
Estimated SWD Total Suspension Rate
- The Maxine Greene HS for Imaginative Inquiry: 78.57%
- City Knoll Middle School: 68.75%
- Harold O. Levy School: 62.00%
- High School of Hospitality Management: 60.64%
- M.S. 224 Manhattan East School for Arts & Academic: 57.14%
- Heritage School, The: 50.59%
- The Urban Assembly School for Green Careers: 44.44%
- Gregorio Luperon High School for Science and Mathematics: 43.48%
- School of Earth Exploration and Discovery Harlem: 42.86%
- Special Music School: 42.31%
- P.S. 076 A. Philip Randolph: 40.58%
- Manhattan Bridges High School: 39.58%
- Manhattan Early College School for Advertising: 38.67%
- M.S. 297: 37.38%
- The Urban Assembly School for Global Commerce: 35.09%
- Jacqueline Kennedy Onassis High School: 34.62%
- High School for Law and Public Service: 33.77%
- M.S. 324 - Patria Mirabal: 33.33%
- The Urban Assembly School for Emergency Management: 33.33%
- Academy for Software Engineering: 31.19%
Weighted Suspension Count per 100K Students
- Heritage School, The: 62.83 Principal, 74.10 Total Suspension
- Thurgood Marshall Academy for Learning and Social: 62.83 Principal, 74.91 Total Suspension
- Esperanza Preparatory Academy: 61.22 Principal, 64.44 Suspension
- M.S. 297: 55.58 Principal, 74.91 Total Suspension
- Academy for Software Engineering: 53.97 Principal, 57.59 Total Suspension
- A. Philip Randolph Campus High School: 49.13 Principal, 61.22 Total Suspension
- The Maxine Greene HS for Imaginative Inquiry: 47.52 Principal, 47.93 Total Suspension
- High School of Hospitality Management: 43.50 Principal, 44.70 Total Suspension
- The Urban Assembly School for Green Careers: 41.88 Principal, 49.13 Total Suspension
- Frederick Douglass Academy: 36.25 Principal, 67.66 Total Suspension
- City Knoll Middle School: 35.44 Principal, 57.19 Total Suspension
- The Urban Assembly School for Emergency Management: 33.83 Principal, 45.11 Total Suspension
- Gramercy Arts High School: 33.02 Principal, 33.02 Total Suspension
- Urban Assembly New York Harbor School: 31.41 Principal, 39.07 Total Suspension
- Pace High School: 31.41 Principal, 36.25 Total Suspension
- School of the Future High School: 31.41 Principal, 45.11 Total Suspension
- High School for Environmental Studies: 30.61 Principal, 45.91 Total Suspension
- Manhattan Early College School for Advertising: 30.61 Principal, 42.69 Total Suspension
- P.S. 206 Jose Celso Barbosa: 29.80 Principal, 49.13 Total Suspension
- Mott Hall II: 29.00 Principal, 37.86 Total Suspension
- Urban Assembly Academy of Government and Law, The: 28.19 Principal, 30.20 Total Suspension
- High School of Arts and Technology: 26.58 Principal, 26.98 Total Suspension
- New Explorations into Science, Technology and Math: 26.58 Principal, 28.19 Total Suspension
- Harvest Collegiate High School: 25.77 Principal, 27.79 Total Suspension
Brooklyn Schools
Removal Rate
The schools with the highest removal rates are as follows. Removal Rates were calculated with the formula: Removal/Total Enrollment:
- P.S. 109: 21.91%
- Cultural Academy for the Arts and Sciences: 18.30%
- P.S. 213 New Lots: 11.71%
- Academy for College Preparation and Career Exploration: 9.27%
- I.S. 285 Meyer Levin: 9.17%
- I.S. 096 Seth Low: 9.09%
- P.S. 153 Homecrest: 8.85%
- Bridges: A School for Exploration and Equity: 8.70%
- Mott Hall Bridges Academy: 8.14%
- Middle School for Art and Philosophy: 8.11%
- P.S. 206 Joseph F Lamb: 7.48%
- P.S. 184 Newport: 6.80%
- P.S. 770 New American Academy: 6.73%
- Urban Assembly Institute of Math and Science for Young Women: 6.65%
- East New York Family Academy: 6.27%
- P.S. 089 Cypress Hills: 6.11%
- Academy for Young Writers: 5.91%
- J.H.S. 078 Roy H. Mann: 5.90%
- Ronald Edmonds Learning Center II: 5.76%
- The Urban Assembly School for Law and Justice: 5.66%
- I.S. 171 Abraham Lincoln: 5.64%
- Red Hook Neighborhood School: 4.96%
- Academy for Health Careers: 4.80%
- Millennium Brooklyn HS: 4.62%
Principal Suspension Rate
The schools with the highest “Principal Rate” are as follows. Rates were calculated with the formula: #Principal/Total Enrollment:
- Brownsville Academy High School: 60.47%
- Bushwick Community High School: 38.00%
- Brooklyn High School of the Arts: 34.48%
- Brooklyn Academy High School: 27.62%
- Life Academy High School for Film and Music: 25.51%
- East Brooklyn Community High School: 25.33%
- Cobble Hill School of American Studies: 25.19%
- The Urban Assembly Unison School: 24.42%
- Kurt Hahn Expeditionary Learning School: 20.89%
- Brooklyn Collegiate: A College Board School: 20.86%
- Bushwick Leaders High School for Academic Excellence: 20.05%
- Teachers Preparatory High School: 17.71%
- The Brooklyn Academy of Global Finance: 17.55%
- Nelson Mandela High School: 17.29%
- J.H.S. 227 Edward B. Shallow: 17.13%
- Boys and Girls High School: 16.54%
- Frederick Douglass Academy VIII Middle School: 16.41%
- Restoration Academy: 15.79%
- Brooklyn High School for Leadership and Community: 15.53%
- Brooklyn Lab School: 15.48%
- High School for Public Service: Heroes of Tomorrow: 14.41%
- P.S. 371 - Lillian L. Rashkis: 14.35%
- Sunset Park High School: 14.05%
- Millennium Brooklyn HS: 13.29%
- School for Classics High School: 13.24%
- High School for Medical Professions: 13.23%
- Spring Creek Community School: 13.20%
- Middle School for Art and Philosophy: 12.84%
- The East New York Arts and Civics High School: 12.58%
- School for Human Rights, The: 12.11%
- George Westinghouse Career and Technical Education: 11.92%
- Brooklyn Academy of Science and the Environment: 11.88%
- High School for Civil Rights: 11.43%
Superintendent Suspension Rate
The schools with the highest “Superintendent Rate” are as follows. Rates were calculated with the formula: #Superintendent/Total Enrollment:
- Van Siclen Community Middle School: 22.03%
- Legacy School of the Arts: 14.29%
- High School of Sports Management: 11.41%
- Olympus Academy: 11.29%
- Mott Hall Bridges Academy: 10.47%
- P.S. 213 New Lots: 10.36%
- The East New York Arts and Civics High School: 10.06%
- Teachers Preparatory High School: 9.38%
- The Brooklyn Academy of Global Finance: 9.04%
- Nelson Mandela High School: 9.02%
- I.S. 340: 8.72%
- School of the Future Brooklyn: 8.33%
- J.H.S. 292 Margaret S. Douglas: 7.78%
- Middle School for Art and Philosophy: 7.43%
- Whitelaw Reid Academy of Arts and Business: 7.29%
- Ronald Edmonds Learning Center II: 7.19%
- Pathways in Technology Early College High School (P-TECH): 6.60%
- Brownsville Collaborative Middle School: 6.41%
- J.H.S. 162 The Willoughby: 6.29%
- Life Academy High School for Film and Music: 6.07%
- Madiba Prep Middle School: 5.91%
- P.S. 178 Saint Clair Mckelway: 5.73%
- Dr. Susan S. McKinney Secondary School of the Arts: 5.71%
Total Suspension Rate
- Brownsville Academy High School: 67.44%
- Brooklyn High School of the Arts: 42.53%
- Bushwick Community High School: 41.50%
- Life Academy High School for Film and Music: 31.58%
- Brooklyn Academy High School: 30.95%
- The Urban Assembly Unison School: 30.52%
- Van Siclen Community Middle School: 29.07%
- Teachers Preparatory High School: 28.13%
- East Brooklyn Community High School: 27.33%
- The Brooklyn Academy of Global Finance: 26.60%
- Nelson Mandela High School: 26.32%
- Brooklyn Collegiate: A College Board School: 25.90%
- Bushwick Leaders High School for Academic Excellence: 22.80%
- The East New York Arts and Civics High School: 22.64%
- Kurt Hahn Expeditionary Learning School: 22.47%
- Frederick Douglass Academy VIII Middle School: 21.28%
- Middle School for Art and Philosophy: 20.27%
- Boys and Girls High School: 20.18%
- Brooklyn Lab School: 19.80%
- Brooklyn High School for Leadership and Community: 18.32%
- J.H.S. 227 Edward B. Shallow: 18.21%
- Mott Hall Bridges Academy: 16.86%
- Brooklyn Academy of Science and the Environment: 16.86%
- Restoration Academy: 16.84%
- P.S. 213 New Lots: 16.67%
- High School for Public Service: Heroes of Tomorrow: 15.74%
- School for Classics High School: 15.26%
- Sunset Park High School: 15.16%
- P.S. 178 Saint Clair Mckelway: 15.05%
- Olympus Academy: 14.92%
- P.S. 371 - Lillian L. Rashkis: 14.80%
- High School of Sports Management: 14.71%
- FDNY - Captain Vernon A. Richard High School for Fire: 14.61%
- Legacy School of the Arts: 14.29%
- Gotham Professional Arts Academy: 14.22%
- Spring Creek Community School: 14.07%
- High School for Civil Rights: 13.93%
- Academy of Innovative Technology: 13.76%
- George Westinghouse Career and Technical Education: 13.70%
- Lyons Community School: 13.58%
- School for Human Rights, The: 13.42%
- Millennium Brooklyn HS: 13.29%
- High School for Medical Professions: 13.23%
- Williamsburg Preparatory School: 13.20%
- I.S. 171 Abraham Lincoln: 13.16%
SWD Principal Suspension Rate
- Brownsville Academy High School: 59.38%
- Life Academy High School for Film and Music: 58.49%
- The Urban Assembly Unison School: 44.26%
- Bushwick Community High School: 41.94%
- J.H.S. 227 Edward B. Shallow: 38.50%
- Brooklyn Academy High School: 38.24%
- Sunset Park High School: 36.28%
- Cultural Academy for the Arts and Sciences: 32.20%
- Brooklyn High School of the Arts: 31.71%
- Brooklyn Collegiate: A College Board School: 27.08%
- Bushwick Leaders High School for Academic Excellence: 27.08%
- Restoration Academy: 26.47%
- Boys and Girls High School: 26.36%
- Brooklyn Theatre Arts High School: 26.32%
- East Brooklyn Community High School: 25.49%
- Kurt Hahn Expeditionary Learning School: 25.45%
- Van Siclen Community Middle School: 23.44%
- School for Classics High School: 23.08%
- Spring Creek Community School: 22.81%
- Cypress Hills Collegiate Preparatory School: 22.08%
- I.S. 303 Herbert S. Eisenberg: 21.43%
- Middle School for Art and Philosophy: 19.57%
- Brooklyn High School for Leadership and Community: 18.97%
- P.S. 226 Alfred De B. Mason: 18.89%
- Urban Assembly Institute of Math and Science for Young Women: 18.67%
- Brooklyn Academy of Science and the Environment: 18.52%
- The Urban Assembly School for Law and Justice: 18.18%
SWD Superintendent Suspension Rate
- Van Siclen Community Middle School: 34.38%
- Bedford Academy High School: 25.53%
- High School of Sports Management: 24.66%
- Mott Hall Bridges Academy: 18.18%
- Teachers Preparatory High School: 16.22%
- The Brooklyn Academy of Global Finance: 16.00%
- J.H.S. 162 The Willoughby: 14.75%
- Pathways in Technology Early College High School (P-TECH): 14.29%
- Nelson Mandela High School: 13.33%
- The Boerum Hill School for International Studies: 13.33%
- J.H.S. 292 Margaret S. Douglas: 12.77%
- I.S. 347 School of Humanities: 12.24%
- J.H.S. 218 James P. Sinnott: 12.20%
- Brooklyn Lab School: 11.11%
- J.H.S. 050 John D. Wells: 10.39%
- Brownsville Collaborative Middle School: 9.68%
- I.S. 303 Herbert S. Eisenberg: 8.57%
- M.S. 061 Dr. Gladstone H. Atwell: 8.51%
- P.S. 138 Brooklyn: 7.92%
- M.S. 582: 6.77%
- J.H.S. 278 Marine Park: 5.94%
- J.H.S. 223 The Montauk: 5.93%
- I.S. 096 Seth Low: 5.50%
Weighted Suspension Count per 245K Students
- J.H.S. 227 Edward B. Shallow: 25,095.90
- J.H.S. 220 John J. Pershing: 14,297.67
- J.H.S. 259 William McKinley: 12,797.91
- James Madison High School: 12,297.99
- Franklin Delano Roosevelt High School: 11,998.04
- Sunset Park High School: 10,898.22
- Brooklyn Collegiate: A College Board School: 10,798.24
- J.H.S. 234 Arthur W. Cunningham: 10,598.27
- J.H.S. 062 Ditmas: 10,398.30
- I.S. 096 Seth Low: 9,998.37
- I.S. 281 Joseph B Cavallaro: 9,298.48
- I.S. 98 Bay Academy: 8,998.53
- Edward R. Murrow High School: 8,548.60
- I.S. 228 David A. Boody: 8,498.61
- Bushwick Leaders High School for Academic Excellence: 8,298.65
- John Dewey High School: 8,298.65
- Brooklyn Studio Secondary School: 8,098.68
- P.S. 226 Alfred De B. Mason: 8,098.68
- Boys and Girls High School: 8,048.69
- Brooklyn Lab School: 7,798.73
- Life Academy High School for Film and Music: 7,798.73
- Fort Hamilton High School: 7,798.73
- George Westinghouse Career and Technical Education: 7,698.74
- Benjamin Banneker Academy: 7,348.80
- High School for Public Service: Heroes of Tomorrow: 7,098.84
- The SEEALL Academy: 6,698.91
- Van Siclen Community Middle School: 6,598.92
- Spring Creek Community School: 6,498.94
- Transit Tech Career and Technical Education High School: 6,398.96
- Midwood High School: 5,899.04
- Brownsville Academy High School: 5,799.05
Methodology
The dataset was obtained by combining 2022-2023 data from NYC Infohub with the Demographic Snapshot by filtering the letter “M” and the letter "K" and year “2022-2023” in the Demographic Snapshot Data. The dataset, containing school information, including removal, Principal Suspension count, Superintendent count, and other demographics, was analyzed to determine a ranked list of schools based on various rates.
Initial columns such as the original data obtained through info hub: REMOVAL, PRINCIPAL, and SUPERINTENDENT contained numeric values and occasional “R”. If any column contained non-numeric data (such as "R"), it was either handled by skipping calculations or replaced with appropriate placeholder values.
The various rates were calculated by dividing the variables Removal, Principal, Superintendent by the total enrollment or suspension values. Next, a Min and a Max as well as an average was calculated to take into account the various ranges of the data. The ranges were calculated by using the Excel formula function, where the value displayed in cases where the values are not all “0”. This rate or decimal range was calculated for certain schools to show variability in the removal/suspension data, with results displayed in both decimal and percentage formats depending on the context.
Special cases, such as schools with "R" values (indicating missing or undefined data), were handled by excluding those from calculations or displaying an empty result.
For weights, a total weight was calculated alongside weights for the three categories of schools. Weights were calculated by Enrollment (School)/Sum of all enrollments, where total enrollment for schools 500-100 was 33,303, for schools with 1000+ enrollments, the total enrollment was 18461, for schools with less than 500 students, total enrollment was 72388.