In order to predict how a school district would have scored when accounting for poverty and other income measures, gathered data from the Ohio Department of Educations Education Management Services and the Ohio Department of Taxation ( November 30, 1997). First, the newspaper obtained passage-rate data on the math, reading, science, writing, and citizenship proficiency exams given to 4th-, 6th-, 9th-, and 12th-graders in early 1996. By combining these data, they computed an overall percentage of students that passed the tests for each district. The percentage of a school districts students on Aid for Dependent Children (ADC), the percentage who qualify for free or reduced-price lunches, and the districts median family income were also recorded. Aportion of the data collected for the 608 school districts follows. The complete data set is available on the CD accompanying the text in the data set named Enquirer. The data have been ranked based on
the values in the column labeled % Passed; these data are the overall percentage of students passing the tests. Data in the column labeled % o ADC are the percentage of each school districts students on ADC, and the data in the column labeled % Free Lunch are the percentage of students who qualify for free or reduced price lunches. The column labeled Median Income shows each districts median family income. Also shown for each school district is the county in which the school district is located. Note that in some cases the value in the % Free Lunch column is 0, indicating that the district did not participate in the free lunch program. Managerial Report Use the methods presented in this and previous chapters to analyze this data set. Present a summary of your analysis, including key statistical results, conclusions, and recommendations, in a managerial report. Include any technical material you feel is appropriate in an appendix. [[Case Problem]]