Hello, you assisted one of my classmates previously with 3 answers to this question

profiletutor4helpyou
data.xls
Home>Mathematics homework help>Numerical analysis homework help>Hello, you assisted one of my classmates previously with 3 answers to this question

Output

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.2522968983
R Square 0.0636537249
Adjusted R Square 0.0229430173
Standard Error 8.4353295979
Observations 25
ANOVA
df SS MS F Significance F
Regression 1 111.2549352066 111.2549352066 1.5635622332 0.2237169222
Residual 23 1636.5600647933 71.1547854258 2.069
Total 24 1747.815
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -4.2796968612 18.3512592201 -0.2332099836 0.817661377 -42.2421689077 33.6827751853 -42.2421689077 33.6827751853
Sagarin mean (x) 0.2987372706 0.2389086218 1.2504248211 0.2237169222 -0.195482868 0.7929574092 -0.195482868 0.7929574092

Sheet1

Federal Graduation Rate (FGR) ACC and SEC
Sagarin football ratings
Football FGR 2012 Football FGR 2011 Football FGR 2010 Football FGR 2009 Football FGR mean all student; 4 yr average FGR gap: all student FGR minus football FGR (y) Sagarin mean (x) 2012 2011 2010 2009
Boston College Atlantic Coast Conference 86 90 87 87 87.5 91 3.5 68.515 60.42 64.4 73.1 76.14
Clemson University Atlantic Coast Conference 59 61 53 54 56.75 79 22.25 79.3375 85.21 77.78 72.82 81.54
Duke University Atlantic Coast Conference 81 80 79 86 81.5 94 12.5 64.88 67.97 60.07 63.61 67.87
Florida State University Atlantic Coast Conference 47 45 49 58 49.75 73 23.25 83.1025 87.5 81.16 85.19 78.56
Georgia Institute of Technology Atlantic Coast Conference 53 45 47 42 46.75 79 32.25 75.2875 75.92 72.31 68.32 84.6
University of Maryland, College Park Atlantic Coast Conference 63 60 56 57 59 82 23 66.68 63.28 61.76 77.85 63.83
University of Miami (Florida) Atlantic Coast Conference 69 72 71 64 69 80 11 76.8775 75.27 73.61 76.91 81.72
University of North Carolina, Chapel Hill Atlantic Coast Conference 52 57 58 56 55.75 88 32.25 76.2 76.7 72.86 76.77 78.47
North Carolina State University Atlantic Coast Conference 57 52 50 54 53.25 72 18.75 73.5125 70.65 71.7 82.85 68.85
Virginia Polytechnic Institute & State University Atlantic Coast Conference 62 60 59 67 62 81 19 81.825 74.37 79.14 86.1 87.69
University of Virginia Atlantic Coast Conference 69 62 60 66 64.25 93 28.75 66.9575 64.65 69.17 65 69.01
Wake Forest University Atlantic Coast Conference 77 78 68 65 72 89 17 65.9275 61.11 68.42 61.63 72.55
University of Arkansas, Fayetteville Southeastern Conference 39 39 41 43 40.5 59 18.5 83.24 70.64 91.06 88.77 82.49
Auburn University Southeastern Conference 61 52 50 51 53.5 67 13.5 80.1875 65.86 77.4 98.06 79.43
University of Florida Southeastern Conference 49 49 48 42 47 84 37 86.4275 89.84 78.78 81.34 95.75
University of Georgia Southeastern Conference 70 60 55 55 60 82 22 82.2525 92.15 84.01 72.77 80.08
University of Kentucky Southeastern Conference 55 54 52 55 54 59 5 68.2475 63.99 66.03 67.62 75.35
Mississippi State University Southeastern Conference 46 45 46 48 46.25 59 12.75 79.02 76.8 78.43 84.81 76.04
University of Mississippi Southeastern Conference 42 45 48 54 47.25 59 11.75 72.7275 80.91 61.77 65.85 82.38
University of Missouri, Columbia Southeastern Conference 57 59 54 57 56.75 69 12.25 79.7125 77.14 85.25 83.04 73.42
University of South Carolina, Columbia Southeastern Conference 51 44 47 49 47.75 70 22.25 83.9675 90.1 88.23 81.11 76.43
University of Tennessee, Knoxville Southeastern Conference 61 59 56 46 55.5 62 6.5 74.065 73.5 74.09 70.71 77.96
Texas A&M University, College Station Southeastern Conference 64 62 52 50 57 80 23 83.3175 93.31 85.87 82.37 71.72
Vanderbilt University Southeastern Conference 68 70 67 71 69 91 22 69.095 80.77 74.94 58.2 62.47
Louisiana State University Southeastern Conference 44 49 48 42 45.75 60 14.25 90.8275 87.63 100.3 91.16 84.22
University of Alabama Southeastern Conference 57 60 64 61 60.5 66 5.5 99.53 99.4 104.17 94.3 100.25
76.4876
51.94326275