X fx Data Set OhioEdPerf (Week 5).xlsx File Edit Insert Format Help A Q Helv B C 10 BIU D E F G H I J K L M N Download a Share P Q R S T U V 1 Ohio Education Performance Results Year 2000 2 3 School District Writin Scien Readin Citizensh Scienc Al Math 4 Indian Hill 95 91 98 95 91 83 89 5 Wyoming 98 87 96 93 6 Mason City 96 86 92 7 Madiera 94 88 95 8 Mariemont 99 88 92 89 9 Sycamore 85 84 88 10 Forest Hills 93 88 91 85 11 Kings Local 92 78 86 12 Lakota 90 81 88 85 13 Loveland 85 86 93 86 14 Southwest 92 73 82 15 Fairfield 90 77 86 16 Oak Hills 88 79 86 17 Three Rivers 87 77 85 18 Milford 82 76 86 19 Ross 84 78 85 20 West Clermont 88 70 83 21 Reading 88 75 80 22 Princeton 83 63 75 23 Finneytown 79 62 71 24 Norwood 86 67 77 25 Lockland 88 64 79 26 Franklin City 85 67 79 27 Winton Woods 82 59 77 65 28 Northwest 75 61 74 29 North College Hil 77 57 76 30 Mount Healthy 87 53 72 31 Felicity Franklin 52 64 64 32 St. Bernard 81 48 59 33 Deer Park 69 52 66 21 Cincinnati Public 63 ^^ 50 SARGSRZAZ2772182888888 87 81 86 94 86 72 85 88 69 88 88 68 74 84 68 80 88 67 73 Column1 Column2 Column3 Column4 Column5 Column6 78 64 78 81 64 73 Mean 86 61 72 73 58 73 83 77 57 71 Mode 87 Median 88 Mode 4.93548387 Mean 1.29032258 Mean Standard E 793618007 Standard E 867200508 Standard E Median 83 Median 86 Mode 4.19354839 Mean 708973283 Standard E 66 Median 73 Mode 79 57 75 84 77 56 66 76 53 72 Kurtosis 75 78 52 66 Skewness .47345E-01 Kurtosis .46141E-01 Skewness 70 48 63 Range 76 75 46 58 76 63 46 59 67 62 45 61 Minimum Maximum Sum 39 Range 59 Minimum 99 Maximum 2633 Sum 98 Maximum 2520 Sum 67 44 64 Count 31 Count 31 Count 52 68 5.67741935 Mean 1.70967742 Mean 1.19354839 440864952 Standard E 356502579 Standard Ei 932362751 78 Median 75 Median 82 Mode 88 Mode Standard D 986442423 Standard D 0.39613245 Standard D 15.0829249 Standard D 3.59016089 Standard D 3.12045108 Standard D 5.32670482 Sample Var 9.72903226 Sample Var 08.0795699 Sample Var 27.4946237 Sample Var 34.6924731 Sample Var 72.1462366 Sample Var 56.5612903 222703169 Kurtosis 516355068 Skewness 47 Range 52 Minimum .11375E-01 Kurtosis .13869E-01 Skewness .14071E-01 Kurtosis 055832818 Skewness 54 Range 41 Minimum .32607E-01 Kurtosis .64363E-01 .85979E-01 Skewness .48052E-02 47 Range 60 44 Minimum 23 95 Maximum 91 Maximum 83 2346 Sum 31 Count 2223 Sum 1587 31 Count 31 54 Range 35 Minimum 89 Maximum 1990 Sum 31 Count 64 41 52 67 40 49 Writing Reading Math Citizenship Science 59 40 55 Writing 1 62 61 38 51 Reading .00928E-01 1 66 57 35 50 Math .97846E-01.09257E-01 1 62 53 32 40 64 28 52 Citizenship .93477E-01 .59704E-01 .57962E-01 Science .98438E-01 .48817E-01 .35302E-01 .95093E-01 48 26 40 43 52 25 40 SUMMARY OUTPUT 50 44 23 35 Data X fx Data Set OhioEdPerf (Week 5).xlsx File Edit Insert Format Help Q Q Helv 10 BIUS Download 8 Share A B C D E FL G H I 23 Finneytown 79 62 24 Norwood 86 67 25 Lockland 88 64 26 Franklin City 85 67 27 Winton Woods 82 59 28 Northwest 75 61 29 North College Hil 77 57 30 Mount Healthy 87 53 31 Felicity Franklin 52 64 32 St. Bernard 81 48 33 Deer Park 69 52 34 Cincinnati Public 63 44 FFRR77621565 67 62 45 61 Sum 75 67 44 64 Count J K L M N P Q R S T U V 2633 Sum 2520 Sum 1990 Sum 2346 Sum 2223 Sum 1587 31 Count 31 Count 31 Count 31 Count 31 Count 31 79 82 64 41 52 79 70 67 40 49 Writing Reading Math Citizenship Science 65 59 40 55 Writing 1 74 62 61 38 51 Reading .00928E-01 1 66 57 35 50 Math .97846E-01.09257E-01 1 62 53 32 40 Citizenship .93477E-01 .59704E-01 .57962E-01 64 81 64 28 52 Science .98438E-01 .48817E-01 .35302E-01 .95093E-01 1 59 41 48 26 40 43 52 25 40 SUMMARY OUTPUT 59 50 44 23 35 35 36 State Averages 79 79 72 68 46 660 37 egression Statistic Multiple R .37852E-01 R Square .79566E-01 38 Adjusted R 70964E-01 39 Standard E 418026404 Observation 31 40 41 42 ANOVA 43 df 44 45 46 Regression Residual Total SS 2002.898426 001.449213 102.246574.35042E-13 MS F ignificance 28 21.9402832 9.35501012 30 5824.83871 47 Math=-21.60068 +0.8365178 Science + 0.317477 Reading 48 49 50 51 Intercept Science Reading Coefficients tandard Erro t Stat P-value Lower 95% Upper 95% ower 95.0% Jpper 95.0% 1.60067987 910221626 179636408 .78528E-02 1.90084862 .300511113 1.90084862 .300511113 .36518E-01 .38716E-01 3.50423766 .55919E-03 3.4753E-01 325505439 3.4753E-01 .325505439 .17477E-01.01272E-01 .053789083 .00989E-01 2.9965E-01 .34604E-01 2.9965E-01 .34604E-01 52 53 54 55 Data