MGT 555 - BUSINESS ANALYTICS

Q2. The State of Ohio Department of Education has a mandated ninth-grade proficiency test that covers writing, reading, mathematics, social studies and science. The Excel file Ohio Education Performance provides data on success rates (defined as the percent of students passing) in school districts of the great Cincinnati metropolitan area. The State of Ohio averages are also given. Ohio Education Performance Results Year 2000 School District Math Writing Science Reading Social Indian Hil 9! 98 95 Wyoming 86 98 37 96 6 Mason City 85 96 86 92 94 Madiera 38 94 88 95 82 Mariemont 74 99 B8 92 89 Sycamore 30 85 84 87 Forest Hills 73 93 88 91 85 Kings Local 78 92 78 86 82 Lakota 73 90 31 88 85 Loveland 72 85 86 95 86 Southwest 73 92 73 82 78 Fairfield 71 90 77 86 83 Oak Hills 79 77 Three Rivers 56 87 77 85 84 Milford 72 82 76 86 82 Ross 56 84 78 85 75 West Clermont 63 70 85 73 Reading 58 88 75 80 76 Princeton 59 83 63 75 76 Finneytown 61 79 62 71 67 Norwood 54 86 67 77 75 Lockland 52 88 64 79 82 Franklin City 49 85 57 79 70 Winton Wood 55 59 77 65 Northwest 51 75 61 74 62 North College Hill 50 77 57 76 66 Mount Healthy 40 87 53 62 Felicity Franklin 52 52 64 64 81 St. Bernard 40 81 48 59 41 Deer Park 40 59 52 56 43 Cincinnati Public 35 63 44 59 50 Copy the given data into an excel file and use it to perform the following tasks