project

profilenirmak
QMBProjectCExampleCollegegradrates15-1.pptx
Home>Business & Finance homework help>Accounting homework help>project

Top 20 Private Colleges’ 6-Year Graduation Rate

Spring 2015

Note: Your project should have more creative background.

Original Data Table

http://mathforum.org/workshops/sum96/data.collections/datalibrary/data.set6.html

New Data Table

6-year Grad. Rate State Student/faculty Ratio Aid From Grants West South East Undergrad. Enrollment Republican State Football team 4-year Grad. Rate Total Costs
California Institute of Technology 0.85 CA 3 0.93 1 0 939 0 0 0.71 32682
Rice University 0.89 TX 5 0.88 1 0 2787 1 1 0.68 28350
Williams College 0.94 MA 8 0.89 0 0 1985 0 1 0.89 36550
Swarthmore College 0.92 PA 8 0.85 0 0 1479 1 0 0.86 38676
Amherst College 0.94 MA 9 0.92 0 0 1618 0 1 0.84 38492
Webb Institute 0.83 NY 7 1 0 0 67 1 1 0.79 8079
Yale University 0.95 CT 7 0.89 0 0 5339 0 1 0.88 38432
Washington and Lee University 0.89 VA 11 0.87 0 1 1750 1 1 0.86 30225
Harvard University 0.97 MA 8 0.9 0 0 6637 0 1 0.86 38831
Stanford University 0.93 CA 7 0.86 1 0 7360 0 1 0.77 38875
Princeton University 0.97 NJ 5 0.94 0 0 4779 0 1 0.91 40169
Massachusetts Institute of Technology 0.91 MA 6 0.85 0 0 4178 0 1 0.82 39213
Pomona College 0.88 CA 9 0.8 1 0 1551 0 1 0.83 38130
Emory University 0.87 GA 7 0.73 0 1 6302 1 0 0.82 37272
Columbia University 0.93 NY 7 0.86 0 0 4109 1 1 0.83 39493
Duke University 0.93 NC 11 0.8 0 1 6206 1 1 0.88 40080
Davidson College 0.91 NC 10 0.82 0 1 1645 1 1 0.89 34706
Wellesley College 0.88 MA 9 0.88 0 0 2300 0 0 0.84 37419
Vassar College 0.87 NY 9 0.78 0 0 2472 1 0 0.81 37870
Haverford College 0.92 PA 8 0.9 0 0 1105 1 0 0.89 38928

Dependent variable

Independent variables

Independent

Binary

Independent

Categorical

Categorical Variables

Binary variables included: if the State

was majority Republican and if the school

had a football team. “0” or “1” representing

“no” or ”yes”.

Categorical variables include West, South West and North West. North East will become my reference level.

West South East
1 0
1 0
0 0
0 0
0 0
0 0
0 0
0 1
0 0
1 0
0 0
0 0
1 0
0 1
0 0
0 1
0 1
0 0
0 0
0 0

Reference level

The reference level selected was North East due to the fact the North East region had the highest number of schools out of the top 20.

West South East
1 0
1 0
0 0
0 0
0 0
0 0
0 0
0 1
0 0
1 0
0 0
0 0
1 0
0 1
0 0
0 1
0 1
0 0
0 0
0 0

Depending on how you define regions in

the U.S. calculations on specific school

regions my differ. I kept it simple and only used key

regions relating to my data. Calculating all the regions

may cause the data to produce an error.

Removing 2 Variables due to Multicollinearty

I removed “Aid from Grants” because we already have “Total Cost”. The amount of student aid paying for school doesn’t really pertain when the table already gives the total cost of a 6-year graduation rate.

I removed “4-year Grad. Rate” because this model gave us both 4-year and 6-year rates. Since we are looking for a 6-year rate of graduation, they have already passed their 4-year

6

Keeping my variables

I left the States variable because its easier to read the model. Also it helps relate my regions.

Student/faculty ratio was saved because it deals with real numbers relating to how many students are on campus vs. how many faculty members. In my opinion this is interesting and important.

Undergraduate enrollment was left because it represents real data of how many students are in the undergraduate enrollment. Also I'm an undergraduate, so I can relate more to this data.

Total cost was left because I believe this variable is what majority of students look at when choosing a college.

State
CA
TX
MA
PA
MA
NY
CT
VA
MA
CA
NJ
MA
CA
GA
NY
NC
NC
MA
NY
PA
Student/faculty Ratio
3
5
8
8
9
7
7
11
8
7
5
6
9
7
7
11
10
9
9
8
Undergrad. Enrollment
939
2787
1985
1479
1618
67
5339
1750
6637
7360
4779
4178
1551
6302
4109
6206
1645
2300
2472
1105
Total Costs
32682
28350
36550
38676
38492
8079
38432
30225
38831
38875
40169
39213
38130
37272
39493
40080
34706
37419
37870
38928

Lets Run It!

Alpha= 0.05

P-Value of Model=

0.0016

R= .8985

Adjusted R squared=

.6949

Adjusted R squared is used instead of R Square because dealing with multiple regression, multiple variables calculated together will cause inflation in the model.

69% of the variance can be explained by the model.

What is significant?

Alpha = 0.05

West has a p-value of 0.0318

Total Costs has a P-value of 0.0026

Football team

has a p-value of 0.0039

Outliers

The model did not have any outliers ( absence of outliers). All variables had a reasonable p-value

The highest variable p-value was the “Republican State”, at .7026 this is not enough to consider this variable an outlier.

If all the original variables were still included in my model, then the number of outliers would have increased, but since I shorted the list to only specific variables I thought pertained to this model, I must of pulled out all possible outliers.

New model with only significant variables

6-year Grad. Rate State West Total Costs Football team
California Institute of Technology 0.85 CA 1 32682 0
Rice University 0.89 TX 1 28350 1
Williams College 0.94 MA 0 36550 1
Swarthmore College 0.92 PA 0 38676 0
Amherst College 0.94 MA 0 38492 1
Webb Institute 0.83 NY 0 8079 1
Yale University 0.95 CT 0 38432 1
Washington and Lee University 0.89 VA 0 30225 1
Harvard University 0.97 MA 0 38831 1
Stanford University 0.93 CA 1 38875 1
Princeton University 0.97 NJ 0 40169 1
Massachusetts Institute of Technology 0.91 MA 0 39213 1
Pomona College 0.88 CA 1 38130 1
Emory University 0.87 GA 0 37272 0
Columbia University 0.93 NY 0 39493 1
Duke University 0.93 NC 0 40080 1
Davidson College 0.91 NC 0 34706 1
Wellesley College 0.88 MA 0 37419 0
Vassar College 0.87 NY 0 37870 0
Haverford College 0.92 PA 0 38928 0
  binary varibales
  categorical with 3 levels
  independent variables
  dependent variable

I left the “States” variable because it

makes it easier to read the model and

there is no numerical value.

South East
0
0
0
0
0
0
0
1
0
0
0
0
0
1
0
1
1
0
0
0
Republican State
0
1
0
1
0
1
0
1
0
0
0
0
0
1
1
1
1
0
1
1
Undergrad. Enrollment
939
2787
1985
1479
1618
67
5339
1750
6637
7360
4779
4178
1551
6302
4109
6206
1645
2300
2472
1105
Student/faculty Ratio
3
5
8
8
9
7
7
11
8
7
5
6
9
7
7
11
10
9
9
8

Non-significant variables that were removed.

New model

Now lets run the model with significant levels only

Alpha= 0.05

R= .8590

Adjusted R squared= .6887

69% of the variance is explained

with this model

P-value= 0 or 6.5118E-05

Looks like “Total Cost” carries the best significant level (0) according to this model.

Having a football team carries a p-value of 0.0008

Results of new model using only significant variables.

Using only significant variables changed how significant each variable was.

At first, “West” had a p-value of 0.03179 and now it carries a p-value of 0.0575. Not that much of a change but still a change.

“Total Cost” started at a p-value of 0.0026 and now it carries a p-value of a value so small we consider it 0. Making “total Cost” the most significant variable

Having a football team originally had a p-value of 0.0039 and now carries a p-value of 0.0008.

Adjusted R squared = .6887 this number actually decreased form original Adjusted R squared which was 0.6949. Not too far off from the original, telling us that 68.8 or 69% of the variance can be explained by this model.

Coefficients of new model

For every change in the X variable (independent variables), the Y variable (independent variable) will change as well.

For total cost, the coefficient is 0.00000364. Since total coast is calculated in $1000s, lets multiply the coefficient by 1000 and you get a coefficient of 0.00364

It does look like having a football team will increase a 6-year graduation rate by 4.3 %.

Total cost will increase the 6-year graduation rate by.36%

3 Predictions

My original data was out of 100 top private schools. For the purpose of this model I only used the top 20. I will be using the next three schools from my original table to make predictions.

Predictions will be based on my final table using only my significant variables

Schools chosen: Northwestern University, Bowdoin College and University of Pennsylvania

3 Predictions

Northwestern University

Has a football team which gives a value of “1” for “yes”

Lets call this region West which gives a value of “1” for “Yes”

Has a total cost of $38,817

Calculating my predictions I took the total cost and multiplied it by the coefficient of the total cost.

38,817 x .000003643 = .141 or 14%

According to the original data the actual % was 92%, indicating something is wrong with my variable units. Or this model is bogus, but I would conclude that using data that carries several different units such as % vs. $ amounts. Some conversions may have to be re converted so all variables could be represented by the same units.

The residual for this prediction was -78%

3 Predictions

Bowdoin College

Has a football team so they get a 1

Region located is North East which is my reference level so they get a 0

Has a total cost of $38,663

Calculations

$38,663 x 0.000003643 = .1408 or 14%

Again my predictions are way off this has a residual of -76%

Original data indicated a 90%

3 Predictions Prof. Decker Note: There are some issues with these predictions. This project was used as an example because the previous slides do such a good job clearly explaining variables and the process of the project.

University of Pennsylvania

Has a football team so they get a 1

Located in the North East region so they get a 0

Total cost is $39,040

Calculating predictions:

39,040 x .000003643 = .142 or 14%

After looking at my predictions and the actual values I would conclude some or all of my variables need to be converted into the same unit of measurement. I would have to say some of the values that were given may have been calculated using other models and variables which may have thrown my predictions off.

binary varibales

categorical with 3 levels

independent variables

dependent variable

Sheet1

Top 100 Private Colleges
Quality Measures Financial Measures
Overall Rank School State Undergrad. Enrollment Admission Rate *SAT or ACT Student/faculty Ratio 4-year Grad. Rate 6-year Grad. Rate Quality Rank Total Costs Cost After Need-based Aid Need Met Aid From Grants Cost After Non-Need-Based Aid Non-Need-Based Aid+ Average Debt Cost Rank
1 California Institute of Technology CA 939 21% 99/100% 3 71% 85% 10 $32,682 $10,981 100% 93% $18,553 15% $10,244 4
2 Rice University TX 2,787 24% 89/92% 5 68% 89% 19 $28,350 $14,779 100% 88% $22,418 34% $12,705 5
3 Williams College MA 1,985 23% 93/93% 8 89% 94% 1 $36,550 $14,737 100% 89% $33,251 NA $12,316 26
4 Swarthmore College PA 1,479 24% 94/98% 8 86% 92% 4 $38,676 $17,386 100% 85% $11,404 2% $12,759 21
5 Amherst College MA 1,618 18% 94/92% 9 84% 94% 5 $38,492 $14,453 100% 92% $33,411 NA $11,544 38
6 Webb Institute NY 67 42% 100/100% 7 79% 83% 39 $8,079 $5,579 20% 100% $8,079 100% $5,700 1
7 Yale University CT 5,339 8% 96/97% 7 88% 95% 3 $38,432 $15,729 100% 89% $38,432 NA $19,228 53
8 Washington and Lee University VA 1,750 31% 89/89% 11 86% 89% 30 $30,225 $15,452 99% 87% $22,063 31% $15,634 9
9 Harvard University MA 6,637 11% 90*/90*% 8 86% 97% 8 $38,831 $17,456 100% 90% $33,201 NA $10,465 46
10 Stanford University CA 7,360 13% 93/95% 7 77% 93% 6 $38,875 $17,746 100% 86% $33,709 NA $15,782 62
11 Princeton University NJ 4,779 11% 95/97% 5 91% 97% 7 $40,169 $18,325 100% 94% $40,169 NA $12,000 59
12 Massachusetts Institute of Technology MA 4,178 16% 95/100% 6 82% 91% 2 $39,213 $19,609 100% 85% $30,337 NA $22,855 82
13 Pomona College CA 1,551 23% 98/97% 9 83% 88% 21 $38,130 $17,411 100% 80% $35,702 NA $15,600 43
14 Emory University GA 6,302 42% 89/94% 7 82% 87% 15 $37,272 $19,657 100% 73% $23,615 19% $17,675 54
15 Columbia University NY 4,109 12% 91/93% 7 83% 93% 13 $39,493 $17,778 100% 86% $39,493 NA $15,331 65
16 Duke University NC 6,206 25% 91/94% 11 88% 93% 11 $40,080 $19,996 100% 80% $26,599 6% $20,025 68
17 Davidson College NC 1,645 34% 86/89% 10 89% 91% 27 $34,706 $21,455 100% 82% $28,630 35% $13,697 37
18 Wellesley College MA 2,300 47% 88/89% 9 84% 88% 32 $37,419 $17,526 100% 88% $32,919 NA $15,697 35
19 Vassar College NY 2,472 31% 93/89% 9 81% 87% 22 $37,870 $19,404 100% 78% $34,669 NA $17,170 64
20 Haverford College PA 1,105 32% 89/90% 8 89% 92% 20 $38,928 $17,826 100% 90% $38,928 NA $15,253 66
21 Northwestern University IL 7,946 33% 88/92% 7 83% 92% 17 $38,817 $20,376 100% 79% $36,538 12% $14,551 74
22 Bowdoin College ME 1,657 25% 87/92% 10 83% 90% 25 $38,663 $17,773 100% 85% $37,663 4% $15,307 58
23 University of Pennsylvania PA 9,742 21% 91/96% 6 83% 91% 9 $39,040 $20,596 100% 77% $39,040 NA $20,247 93
24 Johns Hopkins University MD 4,112 35% 85/93% 8 81% 88% 29 $39,188 $19,142 95% 80% $24,206 9% $13,600 48
25 Cooper Union NY 917 14% 81/83% 7 57% 78% 61 $14,652 $11,167 92% 62% $14,653 100% $9,250 3
26 Washington University MO 7,219 24% 93/98% 7 75% 86% 16 $39,253 $20,700 100% 81% $30,581 19% $0 87
27 Dartmouth College NH 4,118 23% 92/96% 9 87% 95% 12 $38,898 $19,546 100% 76% $36,482 NA $0 92
28 Claremont McKenna College CA 1,024 28% 89/95% 7 82% 86% 37 $37,730 $17,988 100% 86% $31,570 24% $16,914 41
29 University of Notre Dame IN 8,261 34% 83/91% 12 88% 95% 36 $35,392 $18,011 100% 74% $26,304 5% $25,595 45
30 Colgate University NY 2,827 34% 80/86% 10 85% 89% 31 $38,820 $18,856 100% 85% $38,820 NA $12,984 67
31 The Colorado College CO 1,902 53% 66/70% 9 72% 79% 57 $35,275 $16,516 95% 88% $19,645 23% $13,500 10
32 University of Richmond VA 2,998 41% 74/83% 10 79% 84% 48 $31,679 $17,588 96% 80% $21,227 40% $16,115 12
33 Georgetown University DC 6,332 21% 87/89% 11 86% 91% 14 $39,182 $24,382 100% 68% $32,832 NA $20,000 97
34 Brown University RI 6,030 17% 86/90% 8 79% 94% 23 $40,248 $20,838 100% 83% $37,243 NA $21,700 91
35 Carleton College MN 1,932 35% 88/89% 9 82% 86% 34 $35,288 $21,677 100% 72% $32,968 17% $14,543 56
36 Lafayette College PA 2,300 36% 63/78% 11 79% 84% 47 $35,713 $15,147 94% 100% $25,050 17% $17,380 19
37 Middlebury College VT 2,297 27% 93/96% 11 81% 87% 18 $39,532 $18,288 100% 79% $39,532 NA $21,751 98
38 Grinnell College IA 1,485 65% 87/85% 10 78% 84% 55 $31,460 $16,585 100% 76% $23,312 65% $13,854 17
39 Illinois Wesleyan University IL 2,107 48% 96% 12 76% 81% 44 $30,780 $18,858 95% 72% $23,095 76% $17,722 27
40 Bates College ME 1,738 28% 90/91% 10 82% 87% 28 $38,932 $18,258 100% 85% $38,932 NA $17,045 88
41 Cornell University NY 13,725 29% 85/92% 9 82% 90% 26 $38,974 $23,122 100% 69% $38,974 NA $15,587 95
42 Wesleyan University CT 2,733 28% 89/92% 9 76% 81% 24 $39,127 $21,401 100% 72% $39,127 NA $23,753 99
43 Colby College ME 1,830 33% 84/89% 11 85% 88% 33 $38,699 $18,168 100% 93% $38,699 NA $17,270 84
44 Bucknell University PA 3,440 39% 72/84% 12 83% 87% 43 $36,165 $19,165 100% 94% $36,165 NA $16,000 44
45 Kenyon College OH 1,576 52% 87/81% 9 80% 84% 51 $36,273 $17,905 98% 85% $25,183 39% $20,850 32
46 Centre College KY 1,055 78% 89% 11 71% 73% 68 $28,529 $15,842 100% 65% $19,002 23% $14,300 11
47 Rhodes College TN 1,541 70% 95% 11 71% 73% 64 $30,080 $18,899 84% 70% $21,296 50% $15,100 15
48 Macalester College MN 1,840 44% 87/88% 10 71% 77% 58 $32,847 $16,394 100% 80% $27,419 26% $0 29
49 Barnard College NY 2,297 34% 88/88% 10 72% 84% 46 $37,940 $17,826 100% 82% $33,701 8% $14,030 42
50 Brandeis University MA 3,057 42% 88/88% 8 79% 85% 38 $39,101 $22,257 84% 80% $24,255 42% $0 81
51 College of the Holy Cross MA 2,801 43% 71/76% 11 88% 90% 41 $36,851 $23,846 100% 71% $28,381 15% $16,063 69
52 Harvey Mudd College CA 699 37% 97/100% 9 75% 83% 35 $38,880 $22,041 100% 79% $32,890 58% $20,219 90
53 Wake Forest University NC 4,045 41% 79/86% 10 77% 87% 42 $36,079 $21,196 90% 77% $27,438 45% $24,769 61
54 Bryn Mawr College PA 1,321 50% 86/75% 9 76% 80% 45 $37,890 $18,609 96% 86% $36,160 NA $0 57
54 Wheaton College IL 2,395 54% 84/83% 11 70% 84% 66 $27,076 $17,341 97% 74% $22,678 11% $15,864 24
55 Tufts University MA 4,910 27% 81/90% 9 81% 88% 40 $39,173 $20,115 100% 85% $37,477 4% $15,499 79
56 Oberlin College OH 2,848 33% 87/80% 10 63% 76% 50 $37,688 $21,081 100% 72% $26,683 26% $13,926 50
57 Mount Holyoke College MA 2,191 52% 80/70% 10 75% 79% 49 $38,668 $19,268 100% 76% $28,368 10% $14,200 51
58 Furman University SC 2,772 58% 65/70% 11 74% 81% 69 $29,430 $16,296 90% 72% $20,230 55% $17,741 14
59 St. Olaf College MN 3,041 73% 84% 13 71% 75% 67 $29,879 $17,458 100% 74% $25,254 48% $18,806 25
60 Brigham Young University UT 29,379 73% 86% 18 31% 73% 95 $9,663 $7,621 40% 53% $6,523 38% $11,000 2
61 Lehigh University PA 4,706 44% 59/85% 11 70% 84% 65 $35,670 $19,123 99% 75% $23,231 14% $16,972 30
62 Smith College MA 2,647 53% 72/66% 9 76% 80% 56 $37,937 $18,466 100% 76% $28,306 11% $19,911 52
63 Beloit College WI 1,281 70% 82% 11 60% 72% 70 $30,264 $17,452 100% 72% $23,690 19% $14,942 24
64 Taylor University IN 1,869 78% 74% 15 71% 75% 90 $24,723 $15,678 81% 73% $20,538 60% $15,117 7
65 Union College NY 2,147 45% 56/71% 11 75% 80% 72 $36,455 $18,431 97% 79% $16,455 1% $15,725 22
66 Hamilton College NY 1,851 35% 77/82% 10 79% 84% 54 $38,463 $19,474 99% 85% $29,638 8% $16,856 55
67 DePauw University IN 2,338 61% 55/60% 11 75% 79% 88 $32,150 $15,531 99% 82% $21,813 81% $14,481 8
68 Hillsdale College MI 1,220 82% 74% 11 53% 71% 99 $23,353 $13,853 77% 68% $16,853 45% $14,500 6
69 Knox College IL 1,121 72% 72% 12 67% 74% 80 $30,894 $15,494 99% 76% $21,205 67% $16,920 13
70 University of Southern California CA 16,145 30% 79/91% 10 51% 73% 59 $37,968 $21,606 99% 68% $25,660 25% $20,619 70
71 Trinity College CT 2,098 36% 73/79% 9 77% 83% 53 $38,890 $19,667 100% 85% $33,390 1% $17,000 78
72 Trinity University TX 2,406 69% 71/80% 11 65% 75% 86 $27,086 $16,706 86% 71% $21,193 54% $0 20
73 Gustavus Adolphus College MN 2,536 77% 70% 13 72% 75% 89 $27,820 $17,609 92% 70% $21,977 82% $17,400 18
74 Vanderbilt University TN 6,146 46% 83/90% 9 78% 84% 52 $38,847 $20,971 99% 64% $23,049 27% $24,023 86
75 Whitman College WA 1,454 50% 80/81% 10 60% 71% 74 $33,776 $21,176 94% 70% $25,776 72% $15,000 36
76 Scripps College CA 798 58% 85/78% 12 63% 68% 91 $36,500 $17,984 100% 78% $21,355 13% $12,941 23
77 Franklin and Marshall College PA 1,926 62% 62/71% 11 78% 83% 73 $36,580 $20,925 98% 80% $24,751 33% $19,656 40
78 Saint Louis University MO 7,178 72% 72% 12 52% 67% 100 $29,983 $16,902 71% 63% $21,714 36% $14,989 16
79 Carnegie Mellon University PA 5,475 38% 75/95% 11 61% 77% 63 $38,460 $24,689 83% 70% $25,952 22% $19,195 76
80 Lawrence University WI 1,389 68% 83% 11 58% 68% 83 $32,875 $17,882 100% 74% $25,093 65% $18,311 34
81 Connecticut College CT 1,890 35% 83/84% 11 75% 81% 62 $37,057 $16,930 100% 86% $37,057 NA $17,250 85
82 Case Western Reserve University OH 3,457 78% 74/85% 8 49% 75% 87 $32,802 $18,323 96% 66% $20,907 66% $21,830 31
84 Dickinson College PA 2,261 51% 65/64% 13 74% 78% 79 $36,600 $19,753 98% 76% $24,515 30% $17,586 39
85 Kalamazoo College MI 1,265 73% 91% 12 60% 69% 92 $30,917 $17,947 NA% 68% $21,467 92% $20,000 33
86 Saint John's University MN 1,897 87% 66% 13 67% 74% 97 $27,272 $19,544 88% 46% $21,687 68% $20,680 28
87 Boston College MA 9,000 34% 78/85% 13 0% 86% 71 $37,745 $24,470 100% 70% $32,160 7% $16,732 73
88 Reed College OR 1,363 55% 95/86% 10 45% 67% 85 $37,900 $18,804 100% 90% $37,900 NA $16,758 47
89 Bard College NY 1,454 36% 85/67% 9 59% 71% 82 $38,282 $20,558 87% 83% $23,338 11% $15,400 49
90 University of Rochester NY 4,695 50% 79/87% 12 65% 76% 76 $37,246 $20,297 100% 78% $27,245 53% $0 60
91 New York University NY 19,490 28% 87/86% 11 65% 74% 60 $40,105 $28,282 70% 67% $33,355 26% $21,495 100
92 Villanova University PA 7,375 47% 57/74% 13 79% 84% 75 $36,560 $26,463 76% 57% $29,161 20% $28,217 72
93 Skidmore College NY 2,506 46% 70/69% 11 71% 75% 78 $38,838 $21,023 98% 77% $29,438 1% $15,560 71
94 Rose-Hulman Institute of Technology IN 1,642 65% 62/91% 13 58% 71% 93 $32,625 $28,677 60% 27% $28,720 65% $27,000 63
95 St. John's College MD 465 71% 95/75% 8 63% 71% 81 $36,635 $21,940 91% 72% $34,477 4% $20,753 75
96 Babson College MA 1,735 48% 50/77% 13 77% 81% 77 $38,443 $21,316 98% 78% $30,308 11% $0 83
97 Rhode Island School of Design RI 1,882 32% 49/55% 11 0% 87% 96 $34,472 $26,447 69% 53% $33,222 4% $21,125 80
98 Rensselaer Polytechnic Institute NY 5,139 70% 68/92% 17 48% 75% 84 $39,200 $22,360 90% 74% $28,411 45% $24,590 94
99 Sarah Lawrence College NY 1,226 40% 79/44% 6 51% 66% 94 $42,121 $22,847 94% 73% $33,610 NA $14,864 89
100 The George Washington University DC 10,328 40% 68/72% 14 62% 73% 98 $40,240 $25,866 94% 56% $29,916 25% $0 96
*SAT or ACT. Shows the percentage of the 2002-2003 freshman class who scored above 600 on the verbal component of the SAT I and the percentage of those students that scored above 600 on the math component, separated by a slash, or the percentage that scor
From Kiplinger: http://www.kiplinger.com/tools/colleges/

Sheet2

6-year Grad. Rate State Student/faculty Ratio Aid From Grants West South East Undergrad. Enrollment Republican State Football team 4-year Grad. Rate Total Costs
California Institute of Technology 0.85 CA 3 0.93 1 0 939 0 0 0.71 32682
Rice University 0.89 TX 5 0.88 1 0 2787 1 1 0.68 28350
Williams College 0.94 MA 8 0.89 0 0 1985 0 1 0.89 36550
Swarthmore College 0.92 PA 8 0.85 0 0 1479 1 0 0.86 38676
Amherst College 0.94 MA 9 0.92 0 0 1618 0 1 0.84 38492
Webb Institute 0.83 NY 7 1 0 0 67 1 1 0.79 8079
Yale University 0.95 CT 7 0.89 0 0 5339 0 1 0.88 38432
Washington and Lee University 0.89 VA 11 0.87 0 1 1750 1 1 0.86 30225
Harvard University 0.97 MA 8 0.9 0 0 6637 0 1 0.86 38831
Stanford University 0.93 CA 7 0.86 1 0 7360 0 1 0.77 38875
Princeton University 0.97 NJ 5 0.94 0 0 4779 0 1 0.91 40169
Massachusetts Institute of Technology 0.91 MA 6 0.85 0 0 4178 0 1 0.82 39213
Pomona College 0.88 CA 9 0.8 1 0 1551 0 1 0.83 38130
Emory University 0.87 GA 7 0.73 0 1 6302 1 0 0.82 37272
Columbia University 0.93 NY 7 0.86 0 0 4109 1 1 0.83 39493
Duke University 0.93 NC 11 0.8 0 1 6206 1 1 0.88 40080
Davidson College 0.91 NC 10 0.82 0 1 1645 1 1 0.89 34706
Wellesley College 0.88 MA 9 0.88 0 0 2300 0 0 0.84 37419
Vassar College 0.87 NY 9 0.78 0 0 2472 1 0 0.81 37870
Haverford College 0.92 PA 8 0.9 0 0 1105 1 0 0.89 38928
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet3

6-year Grad. Rate State West South East Total Costs Republican State Football team Student/faculty Ratio Undergrad. Enrollment
California Institute of Technology 0.85 CA 1 0 32682 0 0 3 939
Rice University 0.89 TX 1 0 28350 1 1 5 2787
Williams College 0.94 MA 0 0 36550 0 1 8 1985
Swarthmore College 0.92 PA 0 0 38676 1 0 8 1479
Amherst College 0.94 MA 0 0 38492 0 1 9 1618
Webb Institute 0.83 NY 0 0 8079 1 1 7 67
Yale University 0.95 CT 0 0 38432 0 1 7 5339
Washington and Lee University 0.89 VA 0 1 30225 1 1 11 1750
Harvard University 0.97 MA 0 0 38831 0 1 8 6637
Stanford University 0.93 CA 1 0 38875 0 1 7 7360
Princeton University 0.97 NJ 0 0 40169 0 1 5 4779
Massachusetts Institute of Technology 0.91 MA 0 0 39213 0 1 6 4178
Pomona College 0.88 CA 1 0 38130 0 1 9 1551
Emory University 0.87 GA 0 1 37272 1 0 7 6302
Columbia University 0.93 NY 0 0 39493 1 1 7 4109
Duke University 0.93 NC 0 1 40080 1 1 11 6206
Davidson College 0.91 NC 0 1 34706 1 1 10 1645
Wellesley College 0.88 MA 0 0 37419 0 0 9 2300
Vassar College 0.87 NY 0 0 37870 1 0 9 2472
Haverford College 0.92 PA 0 0 38928 1 0 8 1105

Sheet4

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8985094613
R Square 0.807319252
Adjusted R Square 0.6949221491
Standard Error 0.0211200363
Observations 20
ANOVA
df SS MS F Significance F
Regression 7 0.0224273288 0.0032039041 7.1827407529 0.001627108
Residual 12 0.0053526712 0.0004460559
Total 19 0.02778
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.7694264783 0.037399937 20.5729351692 0.0000000001 0.6879390158 0.8509139407 0.6879390158 0.8509139407
West -0.0324817959 0.0133721228 -2.4290680165 0.0317866019 -0.0616171487 -0.0033464431 -0.0616171487 -0.0033464431
South East -0.0223152775 0.0164678937 -1.3550778203 0.20035267 -0.0581957357 0.0135651806 -0.0581957357 0.0135651806
Total Costs 0.000003492 0.0000009221 3.7869738942 0.0025904833 0.0000014829 0.0000055011 0.0000014829 0.0000055011
Republican State 0.0050589309 0.0129398072 0.3909587553 0.7026802342 -0.0231344869 0.0332523487 -0.0231344869 0.0332523487
Football team 0.0442552326 0.0124103327 3.5659988814 0.0038808196 0.0172154404 0.0712950247 0.0172154404 0.0712950247
Student/faculty Ratio -0.0018317178 0.0033926611 -0.5399059334 0.599138383 -0.0092236913 0.0055602556 -0.0092236913 0.0055602556
Undergrad. Enrollment 0.0000020839 0.0000029468 0.7071646151 0.4929690742 -0.0000043366 0.0000085044 -0.0000043366 0.0000085044
RESIDUAL OUTPUT
Observation Predicted 6-year Grad. Rate Residuals
1 0.8475315523 0.0024684477
2 0.8819059552 0.0080940448
3 0.9307967388 0.0092032612
4 0.8979699757 0.0220300243
5 0.9349816903 0.0050183097
6 0.8342700371 -0.0042700371
7 0.9461896697 0.0038103303
8 0.8854686826 0.0045313174
9 0.9484561139 0.0215438861
10 0.9194663182 0.0105336818
11 0.9547517304 0.0152482696
12 0.9483292653 -0.0383292653
13 0.9010961744 -0.0210961744
14 0.8826341425 -0.0126341425
15 0.9523904494 -0.0223904494
16 0.9291679654 0.0008320346
17 0.9027292095 0.0072707905
18 0.8884007468 -0.0084007468
19 0.8953929908 -0.0253929908
20 0.8980705919 0.0219294081

6-year Grad. RateStateStudent/faculty RatioAid From GrantsWestSouth EastUndergrad. EnrollmentRepublican StateFootball team4-year Grad. RateTotal Costs

0.85CA30.9310939000.7132682

0.89TX50.88102787110.6828350

0.94MA80.89001985010.8936550

0.92PA80.85001479100.8638676

0.94MA90.92001618010.8438492

0.83NY710067110.798079

0.95CT70.89005339010.8838432

0.89VA110.87011750110.8630225

0.97MA80.9006637010.8638831

0.93CA70.86107360010.7738875

0.97NJ50.94004779010.9140169

0.91MA60.85004178010.8239213

0.88CA90.8101551010.8338130

0.87GA70.73016302100.8237272

0.93NY70.86004109110.8339493

0.93NC110.8016206110.8840080

0.91NC100.82011645110.8934706

0.88MA90.88002300000.8437419

0.87NY90.78002472100.8137870

0.92PA80.9001105100.8938928

SUMMARY OUTPUT

Regression Statistics

Multiple R0.898509461

R Square0.807319252

Adjusted R Square0.694922149

Standard Error0.021120036

Observations20

ANOVA

dfSSMSFSignificance F

Regression70.0224273290.0032039047.1827407530.001627108

Residual120.0053526710.000446056

Total190.02778

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%

Intercept0.7694264780.03739993720.572935171.00274E-100.6879390160.8509139410.6879390160.850913941

West-0.0324817960.013372123-2.4290680160.031786602-0.061617149-0.003346443-0.061617149-0.003346443

South East-0.0223152780.016467894-1.355077820.20035267-0.0581957360.013565181-0.0581957360.013565181

Total Costs3.49199E-069.22106E-073.7869738940.0025904831.4829E-065.50109E-061.4829E-065.50109E-06

Republican State0.0050589310.0129398070.3909587550.702680234-0.0231344870.033252349-0.0231344870.033252349

Football team0.0442552330.0124103333.5659988810.003880820.017215440.0712950250.017215440.071295025

Student/faculty Ratio-0.0018317180.003392661-0.5399059330.599138383-0.0092236910.005560256-0.0092236910.005560256

Undergrad. Enrollment2.08387E-062.94679E-060.7071646150.492969074-4.33664E-068.50437E-06-4.33664E-068.50437E-06

RESIDUAL OUTPUT

ObservationPredicted 6-year Grad. RateResiduals

10.8475315520.002468448

20.8819059550.008094045

30.9307967390.009203261

40.8979699760.022030024

50.934981690.00501831

60.834270037-0.004270037

70.946189670.00381033

80.8854686830.004531317

90.9484561140.021543886

100.9194663180.010533682

110.954751730.01524827

120.948329265-0.038329265

130.901096174-0.021096174

140.882634143-0.012634143

150.952390449-0.022390449

160.9291679650.000832035

170.9027292090.007270791

180.888400747-0.008400747

190.895392991-0.025392991

200.8980705920.021929408

SUMMARY OUTPUT

Regression Statistics

Multiple R0.898509461

R Square0.807319252

Adjusted R Square0.694922149

Standard Error0.021120036

Observations20

ANOVA

dfSSMSFSignificance F

Regression70.0224273290.0032039047.1827407530.001627108

Residual120.0053526710.000446056

Total190.02778

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%

Intercept0.7694264780.03739993720.572935171.00274E-100.6879390160.8509139410.6879390160.850913941

West-0.0324817960.013372123-2.4290680160.031786602-0.061617149-0.003346443-0.061617149-0.003346443

South East-0.0223152780.016467894-1.355077820.20035267-0.0581957360.013565181-0.0581957360.013565181

Total Costs3.49199E-069.22106E-073.7869738940.0025904831.4829E-065.50109E-061.4829E-065.50109E-06

Republican State0.0050589310.0129398070.3909587550.702680234-0.0231344870.033252349-0.0231344870.033252349

Football team0.0442552330.0124103333.5659988810.003880820.017215440.0712950250.017215440.071295025

Student/faculty Ratio-0.0018317180.003392661-0.5399059330.599138383-0.0092236910.005560256-0.0092236910.005560256

Undergrad. Enrollment2.08387E-062.94679E-060.7071646150.492969074-4.33664E-068.50437E-06-4.33664E-068.50437E-06

RESIDUAL OUTPUT

ObservationPredicted 6-year Grad. RateResiduals

10.8475315520.002468448

20.8819059550.008094045

30.9307967390.009203261

40.8979699760.022030024

50.934981690.00501831

60.834270037-0.004270037

70.946189670.00381033

80.8854686830.004531317

90.9484561140.021543886

100.9194663180.010533682

110.954751730.01524827

120.948329265-0.038329265

130.901096174-0.021096174

140.882634143-0.012634143

150.952390449-0.022390449

160.9291679650.000832035

170.9027292090.007270791

180.888400747-0.008400747

190.895392991-0.025392991

200.8980705920.021929408

SUMMARY OUTPUT

Regression Statistics

Multiple R0.898509461

R Square0.807319252

Adjusted R Square0.694922149

Standard Error0.021120036

Observations20

ANOVA

dfSSMSFSignificance F

Regression70.0224273290.0032039047.1827407530.001627108

Residual120.0053526710.000446056

Total190.02778

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%

Intercept0.7694264780.03739993720.572935171.00274E-100.6879390160.8509139410.6879390160.850913941

West-0.0324817960.013372123-2.4290680160.031786602-0.061617149-0.003346443-0.061617149-0.003346443

South East-0.0223152780.016467894-1.355077820.20035267-0.0581957360.013565181-0.0581957360.013565181

Total Costs3.49199E-069.22106E-073.7869738940.0025904831.4829E-065.50109E-061.4829E-065.50109E-06

Republican State0.0050589310.0129398070.3909587550.702680234-0.0231344870.033252349-0.0231344870.033252349

Football team0.0442552330.0124103333.5659988810.003880820.017215440.0712950250.017215440.071295025

Student/faculty Ratio-0.0018317180.003392661-0.5399059330.599138383-0.0092236910.005560256-0.0092236910.005560256

Undergrad. Enrollment2.08387E-062.94679E-060.7071646150.492969074-4.33664E-068.50437E-06-4.33664E-068.50437E-06

RESIDUAL OUTPUT

ObservationPredicted 6-year Grad. RateResiduals

10.8475315520.002468448

20.8819059550.008094045

30.9307967390.009203261

40.8979699760.022030024

50.934981690.00501831

60.834270037-0.004270037

70.946189670.00381033

80.8854686830.004531317

90.9484561140.021543886

100.9194663180.010533682

110.954751730.01524827

120.948329265-0.038329265

130.901096174-0.021096174

140.882634143-0.012634143

150.952390449-0.022390449

160.9291679650.000832035

170.9027292090.007270791

180.888400747-0.008400747

190.895392991-0.025392991

200.8980705920.021929408

Sheet1

Top 100 Private Colleges
Quality Measures Financial Measures
Overall Rank School State Undergrad. Enrollment Admission Rate *SAT or ACT Student/faculty Ratio 4-year Grad. Rate 6-year Grad. Rate Quality Rank Total Costs Cost After Need-based Aid Need Met Aid From Grants Cost After Non-Need-Based Aid Non-Need-Based Aid+ Average Debt Cost Rank
1 California Institute of Technology CA 939 21% 99/100% 3 71% 85% 10 $32,682 $10,981 100% 93% $18,553 15% $10,244 4
2 Rice University TX 2,787 24% 89/92% 5 68% 89% 19 $28,350 $14,779 100% 88% $22,418 34% $12,705 5
3 Williams College MA 1,985 23% 93/93% 8 89% 94% 1 $36,550 $14,737 100% 89% $33,251 NA $12,316 26
4 Swarthmore College PA 1,479 24% 94/98% 8 86% 92% 4 $38,676 $17,386 100% 85% $11,404 2% $12,759 21
5 Amherst College MA 1,618 18% 94/92% 9 84% 94% 5 $38,492 $14,453 100% 92% $33,411 NA $11,544 38
6 Webb Institute NY 67 42% 100/100% 7 79% 83% 39 $8,079 $5,579 20% 100% $8,079 100% $5,700 1
7 Yale University CT 5,339 8% 96/97% 7 88% 95% 3 $38,432 $15,729 100% 89% $38,432 NA $19,228 53
8 Washington and Lee University VA 1,750 31% 89/89% 11 86% 89% 30 $30,225 $15,452 99% 87% $22,063 31% $15,634 9
9 Harvard University MA 6,637 11% 90*/90*% 8 86% 97% 8 $38,831 $17,456 100% 90% $33,201 NA $10,465 46
10 Stanford University CA 7,360 13% 93/95% 7 77% 93% 6 $38,875 $17,746 100% 86% $33,709 NA $15,782 62
11 Princeton University NJ 4,779 11% 95/97% 5 91% 97% 7 $40,169 $18,325 100% 94% $40,169 NA $12,000 59
12 Massachusetts Institute of Technology MA 4,178 16% 95/100% 6 82% 91% 2 $39,213 $19,609 100% 85% $30,337 NA $22,855 82
13 Pomona College CA 1,551 23% 98/97% 9 83% 88% 21 $38,130 $17,411 100% 80% $35,702 NA $15,600 43
14 Emory University GA 6,302 42% 89/94% 7 82% 87% 15 $37,272 $19,657 100% 73% $23,615 19% $17,675 54
15 Columbia University NY 4,109 12% 91/93% 7 83% 93% 13 $39,493 $17,778 100% 86% $39,493 NA $15,331 65
16 Duke University NC 6,206 25% 91/94% 11 88% 93% 11 $40,080 $19,996 100% 80% $26,599 6% $20,025 68
17 Davidson College NC 1,645 34% 86/89% 10 89% 91% 27 $34,706 $21,455 100% 82% $28,630 35% $13,697 37
18 Wellesley College MA 2,300 47% 88/89% 9 84% 88% 32 $37,419 $17,526 100% 88% $32,919 NA $15,697 35
19 Vassar College NY 2,472 31% 93/89% 9 81% 87% 22 $37,870 $19,404 100% 78% $34,669 NA $17,170 64
20 Haverford College PA 1,105 32% 89/90% 8 89% 92% 20 $38,928 $17,826 100% 90% $38,928 NA $15,253 66
21 Northwestern University IL 7,946 33% 88/92% 7 83% 92% 17 $38,817 $20,376 100% 79% $36,538 12% $14,551 74
22 Bowdoin College ME 1,657 25% 87/92% 10 83% 90% 25 $38,663 $17,773 100% 85% $37,663 4% $15,307 58
23 University of Pennsylvania PA 9,742 21% 91/96% 6 83% 91% 9 $39,040 $20,596 100% 77% $39,040 NA $20,247 93
24 Johns Hopkins University MD 4,112 35% 85/93% 8 81% 88% 29 $39,188 $19,142 95% 80% $24,206 9% $13,600 48
25 Cooper Union NY 917 14% 81/83% 7 57% 78% 61 $14,652 $11,167 92% 62% $14,653 100% $9,250 3
26 Washington University MO 7,219 24% 93/98% 7 75% 86% 16 $39,253 $20,700 100% 81% $30,581 19% $0 87
27 Dartmouth College NH 4,118 23% 92/96% 9 87% 95% 12 $38,898 $19,546 100% 76% $36,482 NA $0 92
28 Claremont McKenna College CA 1,024 28% 89/95% 7 82% 86% 37 $37,730 $17,988 100% 86% $31,570 24% $16,914 41
29 University of Notre Dame IN 8,261 34% 83/91% 12 88% 95% 36 $35,392 $18,011 100% 74% $26,304 5% $25,595 45
30 Colgate University NY 2,827 34% 80/86% 10 85% 89% 31 $38,820 $18,856 100% 85% $38,820 NA $12,984 67
31 The Colorado College CO 1,902 53% 66/70% 9 72% 79% 57 $35,275 $16,516 95% 88% $19,645 23% $13,500 10
32 University of Richmond VA 2,998 41% 74/83% 10 79% 84% 48 $31,679 $17,588 96% 80% $21,227 40% $16,115 12
33 Georgetown University DC 6,332 21% 87/89% 11 86% 91% 14 $39,182 $24,382 100% 68% $32,832 NA $20,000 97
34 Brown University RI 6,030 17% 86/90% 8 79% 94% 23 $40,248 $20,838 100% 83% $37,243 NA $21,700 91
35 Carleton College MN 1,932 35% 88/89% 9 82% 86% 34 $35,288 $21,677 100% 72% $32,968 17% $14,543 56
36 Lafayette College PA 2,300 36% 63/78% 11 79% 84% 47 $35,713 $15,147 94% 100% $25,050 17% $17,380 19
37 Middlebury College VT 2,297 27% 93/96% 11 81% 87% 18 $39,532 $18,288 100% 79% $39,532 NA $21,751 98
38 Grinnell College IA 1,485 65% 87/85% 10 78% 84% 55 $31,460 $16,585 100% 76% $23,312 65% $13,854 17
39 Illinois Wesleyan University IL 2,107 48% 96% 12 76% 81% 44 $30,780 $18,858 95% 72% $23,095 76% $17,722 27
40 Bates College ME 1,738 28% 90/91% 10 82% 87% 28 $38,932 $18,258 100% 85% $38,932 NA $17,045 88
41 Cornell University NY 13,725 29% 85/92% 9 82% 90% 26 $38,974 $23,122 100% 69% $38,974 NA $15,587 95
42 Wesleyan University CT 2,733 28% 89/92% 9 76% 81% 24 $39,127 $21,401 100% 72% $39,127 NA $23,753 99
43 Colby College ME 1,830 33% 84/89% 11 85% 88% 33 $38,699 $18,168 100% 93% $38,699 NA $17,270 84
44 Bucknell University PA 3,440 39% 72/84% 12 83% 87% 43 $36,165 $19,165 100% 94% $36,165 NA $16,000 44
45 Kenyon College OH 1,576 52% 87/81% 9 80% 84% 51 $36,273 $17,905 98% 85% $25,183 39% $20,850 32
46 Centre College KY 1,055 78% 89% 11 71% 73% 68 $28,529 $15,842 100% 65% $19,002 23% $14,300 11
47 Rhodes College TN 1,541 70% 95% 11 71% 73% 64 $30,080 $18,899 84% 70% $21,296 50% $15,100 15
48 Macalester College MN 1,840 44% 87/88% 10 71% 77% 58 $32,847 $16,394 100% 80% $27,419 26% $0 29
49 Barnard College NY 2,297 34% 88/88% 10 72% 84% 46 $37,940 $17,826 100% 82% $33,701 8% $14,030 42
50 Brandeis University MA 3,057 42% 88/88% 8 79% 85% 38 $39,101 $22,257 84% 80% $24,255 42% $0 81
51 College of the Holy Cross MA 2,801 43% 71/76% 11 88% 90% 41 $36,851 $23,846 100% 71% $28,381 15% $16,063 69
52 Harvey Mudd College CA 699 37% 97/100% 9 75% 83% 35 $38,880 $22,041 100% 79% $32,890 58% $20,219 90
53 Wake Forest University NC 4,045 41% 79/86% 10 77% 87% 42 $36,079 $21,196 90% 77% $27,438 45% $24,769 61
54 Bryn Mawr College PA 1,321 50% 86/75% 9 76% 80% 45 $37,890 $18,609 96% 86% $36,160 NA $0 57
54 Wheaton College IL 2,395 54% 84/83% 11 70% 84% 66 $27,076 $17,341 97% 74% $22,678 11% $15,864 24
55 Tufts University MA 4,910 27% 81/90% 9 81% 88% 40 $39,173 $20,115 100% 85% $37,477 4% $15,499 79
56 Oberlin College OH 2,848 33% 87/80% 10 63% 76% 50 $37,688 $21,081 100% 72% $26,683 26% $13,926 50
57 Mount Holyoke College MA 2,191 52% 80/70% 10 75% 79% 49 $38,668 $19,268 100% 76% $28,368 10% $14,200 51
58 Furman University SC 2,772 58% 65/70% 11 74% 81% 69 $29,430 $16,296 90% 72% $20,230 55% $17,741 14
59 St. Olaf College MN 3,041 73% 84% 13 71% 75% 67 $29,879 $17,458 100% 74% $25,254 48% $18,806 25
60 Brigham Young University UT 29,379 73% 86% 18 31% 73% 95 $9,663 $7,621 40% 53% $6,523 38% $11,000 2
61 Lehigh University PA 4,706 44% 59/85% 11 70% 84% 65 $35,670 $19,123 99% 75% $23,231 14% $16,972 30
62 Smith College MA 2,647 53% 72/66% 9 76% 80% 56 $37,937 $18,466 100% 76% $28,306 11% $19,911 52
63 Beloit College WI 1,281 70% 82% 11 60% 72% 70 $30,264 $17,452 100% 72% $23,690 19% $14,942 24
64 Taylor University IN 1,869 78% 74% 15 71% 75% 90 $24,723 $15,678 81% 73% $20,538 60% $15,117 7
65 Union College NY 2,147 45% 56/71% 11 75% 80% 72 $36,455 $18,431 97% 79% $16,455 1% $15,725 22
66 Hamilton College NY 1,851 35% 77/82% 10 79% 84% 54 $38,463 $19,474 99% 85% $29,638 8% $16,856 55
67 DePauw University IN 2,338 61% 55/60% 11 75% 79% 88 $32,150 $15,531 99% 82% $21,813 81% $14,481 8
68 Hillsdale College MI 1,220 82% 74% 11 53% 71% 99 $23,353 $13,853 77% 68% $16,853 45% $14,500 6
69 Knox College IL 1,121 72% 72% 12 67% 74% 80 $30,894 $15,494 99% 76% $21,205 67% $16,920 13
70 University of Southern California CA 16,145 30% 79/91% 10 51% 73% 59 $37,968 $21,606 99% 68% $25,660 25% $20,619 70
71 Trinity College CT 2,098 36% 73/79% 9 77% 83% 53 $38,890 $19,667 100% 85% $33,390 1% $17,000 78
72 Trinity University TX 2,406 69% 71/80% 11 65% 75% 86 $27,086 $16,706 86% 71% $21,193 54% $0 20
73 Gustavus Adolphus College MN 2,536 77% 70% 13 72% 75% 89 $27,820 $17,609 92% 70% $21,977 82% $17,400 18
74 Vanderbilt University TN 6,146 46% 83/90% 9 78% 84% 52 $38,847 $20,971 99% 64% $23,049 27% $24,023 86
75 Whitman College WA 1,454 50% 80/81% 10 60% 71% 74 $33,776 $21,176 94% 70% $25,776 72% $15,000 36
76 Scripps College CA 798 58% 85/78% 12 63% 68% 91 $36,500 $17,984 100% 78% $21,355 13% $12,941 23
77 Franklin and Marshall College PA 1,926 62% 62/71% 11 78% 83% 73 $36,580 $20,925 98% 80% $24,751 33% $19,656 40
78 Saint Louis University MO 7,178 72% 72% 12 52% 67% 100 $29,983 $16,902 71% 63% $21,714 36% $14,989 16
79 Carnegie Mellon University PA 5,475 38% 75/95% 11 61% 77% 63 $38,460 $24,689 83% 70% $25,952 22% $19,195 76
80 Lawrence University WI 1,389 68% 83% 11 58% 68% 83 $32,875 $17,882 100% 74% $25,093 65% $18,311 34
81 Connecticut College CT 1,890 35% 83/84% 11 75% 81% 62 $37,057 $16,930 100% 86% $37,057 NA $17,250 85
82 Case Western Reserve University OH 3,457 78% 74/85% 8 49% 75% 87 $32,802 $18,323 96% 66% $20,907 66% $21,830 31
84 Dickinson College PA 2,261 51% 65/64% 13 74% 78% 79 $36,600 $19,753 98% 76% $24,515 30% $17,586 39
85 Kalamazoo College MI 1,265 73% 91% 12 60% 69% 92 $30,917 $17,947 NA% 68% $21,467 92% $20,000 33
86 Saint John's University MN 1,897 87% 66% 13 67% 74% 97 $27,272 $19,544 88% 46% $21,687 68% $20,680 28
87 Boston College MA 9,000 34% 78/85% 13 0% 86% 71 $37,745 $24,470 100% 70% $32,160 7% $16,732 73
88 Reed College OR 1,363 55% 95/86% 10 45% 67% 85 $37,900 $18,804 100% 90% $37,900 NA $16,758 47
89 Bard College NY 1,454 36% 85/67% 9 59% 71% 82 $38,282 $20,558 87% 83% $23,338 11% $15,400 49
90 University of Rochester NY 4,695 50% 79/87% 12 65% 76% 76 $37,246 $20,297 100% 78% $27,245 53% $0 60
91 New York University NY 19,490 28% 87/86% 11 65% 74% 60 $40,105 $28,282 70% 67% $33,355 26% $21,495 100
92 Villanova University PA 7,375 47% 57/74% 13 79% 84% 75 $36,560 $26,463 76% 57% $29,161 20% $28,217 72
93 Skidmore College NY 2,506 46% 70/69% 11 71% 75% 78 $38,838 $21,023 98% 77% $29,438 1% $15,560 71
94 Rose-Hulman Institute of Technology IN 1,642 65% 62/91% 13 58% 71% 93 $32,625 $28,677 60% 27% $28,720 65% $27,000 63
95 St. John's College MD 465 71% 95/75% 8 63% 71% 81 $36,635 $21,940 91% 72% $34,477 4% $20,753 75
96 Babson College MA 1,735 48% 50/77% 13 77% 81% 77 $38,443 $21,316 98% 78% $30,308 11% $0 83
97 Rhode Island School of Design RI 1,882 32% 49/55% 11 0% 87% 96 $34,472 $26,447 69% 53% $33,222 4% $21,125 80
98 Rensselaer Polytechnic Institute NY 5,139 70% 68/92% 17 48% 75% 84 $39,200 $22,360 90% 74% $28,411 45% $24,590 94
99 Sarah Lawrence College NY 1,226 40% 79/44% 6 51% 66% 94 $42,121 $22,847 94% 73% $33,610 NA $14,864 89
100 The George Washington University DC 10,328 40% 68/72% 14 62% 73% 98 $40,240 $25,866 94% 56% $29,916 25% $0 96
*SAT or ACT. Shows the percentage of the 2002-2003 freshman class who scored above 600 on the verbal component of the SAT I and the percentage of those students that scored above 600 on the math component, separated by a slash, or the percentage that scor
From Kiplinger: http://www.kiplinger.com/tools/colleges/

Sheet2

6-year Grad. Rate State Student/faculty Ratio Aid From Grants West South East Undergrad. Enrollment Republican State Football team 4-year Grad. Rate Total Costs
California Institute of Technology 0.85 CA 3 0.93 1 0 939 0 0 0.71 32682
Rice University 0.89 TX 5 0.88 1 0 2787 1 1 0.68 28350
Williams College 0.94 MA 8 0.89 0 0 1985 0 1 0.89 36550
Swarthmore College 0.92 PA 8 0.85 0 0 1479 1 0 0.86 38676
Amherst College 0.94 MA 9 0.92 0 0 1618 0 1 0.84 38492
Webb Institute 0.83 NY 7 1 0 0 67 1 1 0.79 8079
Yale University 0.95 CT 7 0.89 0 0 5339 0 1 0.88 38432
Washington and Lee University 0.89 VA 11 0.87 0 1 1750 1 1 0.86 30225
Harvard University 0.97 MA 8 0.9 0 0 6637 0 1 0.86 38831
Stanford University 0.93 CA 7 0.86 1 0 7360 0 1 0.77 38875
Princeton University 0.97 NJ 5 0.94 0 0 4779 0 1 0.91 40169
Massachusetts Institute of Technology 0.91 MA 6 0.85 0 0 4178 0 1 0.82 39213
Pomona College 0.88 CA 9 0.8 1 0 1551 0 1 0.83 38130
Emory University 0.87 GA 7 0.73 0 1 6302 1 0 0.82 37272
Columbia University 0.93 NY 7 0.86 0 0 4109 1 1 0.83 39493
Duke University 0.93 NC 11 0.8 0 1 6206 1 1 0.88 40080
Davidson College 0.91 NC 10 0.82 0 1 1645 1 1 0.89 34706
Wellesley College 0.88 MA 9 0.88 0 0 2300 0 0 0.84 37419
Vassar College 0.87 NY 9 0.78 0 0 2472 1 0 0.81 37870
Haverford College 0.92 PA 8 0.9 0 0 1105 1 0 0.89 38928
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet3

6-year Grad. Rate State West South East Total Costs Republican State Football team Student/faculty Ratio Undergrad. Enrollment
California Institute of Technology 0.85 CA 1 0 32682 0 0 3 939
Rice University 0.89 TX 1 0 28350 1 1 5 2787
Williams College 0.94 MA 0 0 36550 0 1 8 1985
Swarthmore College 0.92 PA 0 0 38676 1 0 8 1479
Amherst College 0.94 MA 0 0 38492 0 1 9 1618
Webb Institute 0.83 NY 0 0 8079 1 1 7 67
Yale University 0.95 CT 0 0 38432 0 1 7 5339
Washington and Lee University 0.89 VA 0 1 30225 1 1 11 1750
Harvard University 0.97 MA 0 0 38831 0 1 8 6637
Stanford University 0.93 CA 1 0 38875 0 1 7 7360
Princeton University 0.97 NJ 0 0 40169 0 1 5 4779
Massachusetts Institute of Technology 0.91 MA 0 0 39213 0 1 6 4178
Pomona College 0.88 CA 1 0 38130 0 1 9 1551
Emory University 0.87 GA 0 1 37272 1 0 7 6302
Columbia University 0.93 NY 0 0 39493 1 1 7 4109
Duke University 0.93 NC 0 1 40080 1 1 11 6206
Davidson College 0.91 NC 0 1 34706 1 1 10 1645
Wellesley College 0.88 MA 0 0 37419 0 0 9 2300
Vassar College 0.87 NY 0 0 37870 1 0 9 2472
Haverford College 0.92 PA 0 0 38928 1 0 8 1105
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet4

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8985094613
R Square 0.807319252
Adjusted R Square 0.6949221491
Standard Error 0.0211200363
Observations 20
ANOVA
df SS MS F Significance F
Regression 7 0.0224273288 0.0032039041 7.1827407529 0.001627108
Residual 12 0.0053526712 0.0004460559
Total 19 0.02778
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.7694264783 0.037399937 20.5729351692 0.0000000001 0.6879390158 0.8509139407 0.6879390158 0.8509139407
West -0.0324817959 0.0133721228 -2.4290680165 0.0317866019 -0.0616171487 -0.0033464431 -0.0616171487 -0.0033464431
South East -0.0223152775 0.0164678937 -1.3550778203 0.20035267 -0.0581957357 0.0135651806 -0.0581957357 0.0135651806
Total Costs 0.000003492 0.0000009221 3.7869738942 0.0025904833 0.0000014829 0.0000055011 0.0000014829 0.0000055011
Republican State 0.0050589309 0.0129398072 0.3909587553 0.7026802342 -0.0231344869 0.0332523487 -0.0231344869 0.0332523487
Football team 0.0442552326 0.0124103327 3.5659988814 0.0038808196 0.0172154404 0.0712950247 0.0172154404 0.0712950247
Student/faculty Ratio -0.0018317178 0.0033926611 -0.5399059334 0.599138383 -0.0092236913 0.0055602556 -0.0092236913 0.0055602556
Undergrad. Enrollment 0.0000020839 0.0000029468 0.7071646151 0.4929690742 -0.0000043366 0.0000085044 -0.0000043366 0.0000085044
RESIDUAL OUTPUT
Observation Predicted 6-year Grad. Rate Residuals
1 0.8475315523 0.0024684477
2 0.8819059552 0.0080940448
3 0.9307967388 0.0092032612
4 0.8979699757 0.0220300243
5 0.9349816903 0.0050183097
6 0.8342700371 -0.0042700371
7 0.9461896697 0.0038103303
8 0.8854686826 0.0045313174
9 0.9484561139 0.0215438861
10 0.9194663182 0.0105336818
11 0.9547517304 0.0152482696
12 0.9483292653 -0.0383292653
13 0.9010961744 -0.0210961744
14 0.8826341425 -0.0126341425
15 0.9523904494 -0.0223904494
16 0.9291679654 0.0008320346
17 0.9027292095 0.0072707905
18 0.8884007468 -0.0084007468
19 0.8953929908 -0.0253929908
20 0.8980705919 0.0219294081

Sheet5

6-year Grad. Rate State West Total Costs Football team
California Institute of Technology 0.85 CA 1 32682 0
Rice University 0.89 TX 1 28350 1
Williams College 0.94 MA 0 36550 1
Swarthmore College 0.92 PA 0 38676 0
Amherst College 0.94 MA 0 38492 1
Webb Institute 0.83 NY 0 8079 1
Yale University 0.95 CT 0 38432 1
Washington and Lee University 0.89 VA 0 30225 1
Harvard University 0.97 MA 0 38831 1
Stanford University 0.93 CA 1 38875 1
Princeton University 0.97 NJ 0 40169 1
Massachusetts Institute of Technology 0.91 MA 0 39213 1
Pomona College 0.88 CA 1 38130 1
Emory University 0.87 GA 0 37272 0
Columbia University 0.93 NY 0 39493 1
Duke University 0.93 NC 0 40080 1
Davidson College 0.91 NC 0 34706 1
Wellesley College 0.88 MA 0 37419 0
Vassar College 0.87 NY 0 37870 0
Haverford College 0.92 PA 0 38928 0
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet6

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8590077331
R Square 0.7378942855
Adjusted R Square 0.6887494641
Standard Error 0.0213326287
Observations 20
ANOVA
df SS MS F Significance F
Regression 3 0.0204987033 0.0068329011 15.0146905316 0.000065118
Residual 16 0.0072812967 0.000455081
Total 19 0.02778
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.7537956263 0.0271093071 27.805787313 0 0.6963264626 0.81126479 0.6963264626 0.81126479
West -0.0245104848 0.0119743159 -2.046921504 0.0574568751 -0.0498949006 0.000873931 -0.0498949006 0.000873931
Total Costs 0.0000036426 0.0000006853 5.3156851999 0.0000696391 0.0000021899 0.0000050952 0.0000021899 0.0000050952
Football team 0.0433498076 0.0105243748 4.1189912265 0.0008039005 0.0210391296 0.0656604856 0.0210391296 0.0656604856
RESIDUAL OUTPUT
Observation Predicted 6-year Grad. Rate Residuals
1 0.8483317507 0.0016682493
2 0.8759019269 0.0140980731
3 0.93028152 0.00971848
4 0.8946758251 0.0253241749
5 0.937355399 0.002644601
6 0.8265737906 0.0034262094
7 0.9371368445 0.0128631555
8 0.9072422383 -0.0172422383
9 0.9385902316 0.0314097684
10 0.9142400201 0.0157599799
11 0.9434639959 0.0265360041
12 0.939981695 -0.029981695
13 0.9115263023 -0.0315263023
14 0.8895616509 -0.0195616509
15 0.9410016157 -0.0110016157
16 0.9431398068 -0.0131398068
17 0.9235646132 -0.0135646132
18 0.8900971093 -0.0100971093
19 0.8917399103 -0.0217399103
20 0.8955937538 0.0244062462

SUMMARY OUTPUT

Regression Statistics

Multiple R0.859007733

R Square0.737894286

Adjusted R Square0.688749464

Standard Error0.021332629

Observations20

ANOVA

dfSSMSFSignificance F

Regression30.0204987030.00683290115.014690536.5118E-05

Residual160.0072812970.000455081

Total190.02778

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%

Intercept0.7537956260.02710930727.805787315.65822E-150.6963264630.811264790.6963264630.81126479

West-0.0245104850.011974316-2.0469215040.057456875-0.0498949010.000873931-0.0498949010.000873931

Total Costs3.64257E-066.8525E-075.31568526.96391E-052.18991E-065.09524E-062.18991E-065.09524E-06

Football team0.0433498080.0105243754.1189912260.0008039010.021039130.0656604860.021039130.065660486

RESIDUAL OUTPUT

ObservationPredicted 6-year Grad. RateResiduals

10.8483317510.001668249

20.8759019270.014098073

30.930281520.00971848

40.8946758250.025324175

50.9373553990.002644601

60.8265737910.003426209

70.9371368450.012863155

80.907242238-0.017242238

90.9385902320.031409768

100.914240020.01575998

110.9434639960.026536004

120.939981695-0.029981695

130.911526302-0.031526302

140.889561651-0.019561651

150.941001616-0.011001616

160.943139807-0.013139807

170.923564613-0.013564613

180.890097109-0.010097109

190.89173991-0.02173991

200.8955937540.024406246

Sheet1

Top 100 Private Colleges
Quality Measures Financial Measures
Overall Rank School State Undergrad. Enrollment Admission Rate *SAT or ACT Student/faculty Ratio 4-year Grad. Rate 6-year Grad. Rate Quality Rank Total Costs Cost After Need-based Aid Need Met Aid From Grants Cost After Non-Need-Based Aid Non-Need-Based Aid+ Average Debt Cost Rank
1 California Institute of Technology CA 939 21% 99/100% 3 71% 85% 10 $32,682 $10,981 100% 93% $18,553 15% $10,244 4
2 Rice University TX 2,787 24% 89/92% 5 68% 89% 19 $28,350 $14,779 100% 88% $22,418 34% $12,705 5
3 Williams College MA 1,985 23% 93/93% 8 89% 94% 1 $36,550 $14,737 100% 89% $33,251 NA $12,316 26
4 Swarthmore College PA 1,479 24% 94/98% 8 86% 92% 4 $38,676 $17,386 100% 85% $11,404 2% $12,759 21
5 Amherst College MA 1,618 18% 94/92% 9 84% 94% 5 $38,492 $14,453 100% 92% $33,411 NA $11,544 38
6 Webb Institute NY 67 42% 100/100% 7 79% 83% 39 $8,079 $5,579 20% 100% $8,079 100% $5,700 1
7 Yale University CT 5,339 8% 96/97% 7 88% 95% 3 $38,432 $15,729 100% 89% $38,432 NA $19,228 53
8 Washington and Lee University VA 1,750 31% 89/89% 11 86% 89% 30 $30,225 $15,452 99% 87% $22,063 31% $15,634 9
9 Harvard University MA 6,637 11% 90*/90*% 8 86% 97% 8 $38,831 $17,456 100% 90% $33,201 NA $10,465 46
10 Stanford University CA 7,360 13% 93/95% 7 77% 93% 6 $38,875 $17,746 100% 86% $33,709 NA $15,782 62
11 Princeton University NJ 4,779 11% 95/97% 5 91% 97% 7 $40,169 $18,325 100% 94% $40,169 NA $12,000 59
12 Massachusetts Institute of Technology MA 4,178 16% 95/100% 6 82% 91% 2 $39,213 $19,609 100% 85% $30,337 NA $22,855 82
13 Pomona College CA 1,551 23% 98/97% 9 83% 88% 21 $38,130 $17,411 100% 80% $35,702 NA $15,600 43
14 Emory University GA 6,302 42% 89/94% 7 82% 87% 15 $37,272 $19,657 100% 73% $23,615 19% $17,675 54
15 Columbia University NY 4,109 12% 91/93% 7 83% 93% 13 $39,493 $17,778 100% 86% $39,493 NA $15,331 65
16 Duke University NC 6,206 25% 91/94% 11 88% 93% 11 $40,080 $19,996 100% 80% $26,599 6% $20,025 68
17 Davidson College NC 1,645 34% 86/89% 10 89% 91% 27 $34,706 $21,455 100% 82% $28,630 35% $13,697 37
18 Wellesley College MA 2,300 47% 88/89% 9 84% 88% 32 $37,419 $17,526 100% 88% $32,919 NA $15,697 35
19 Vassar College NY 2,472 31% 93/89% 9 81% 87% 22 $37,870 $19,404 100% 78% $34,669 NA $17,170 64
20 Haverford College PA 1,105 32% 89/90% 8 89% 92% 20 $38,928 $17,826 100% 90% $38,928 NA $15,253 66
21 Northwestern University IL 7,946 33% 88/92% 7 83% 92% 17 $38,817 $20,376 100% 79% $36,538 12% $14,551 74
22 Bowdoin College ME 1,657 25% 87/92% 10 83% 90% 25 $38,663 $17,773 100% 85% $37,663 4% $15,307 58
23 University of Pennsylvania PA 9,742 21% 91/96% 6 83% 91% 9 $39,040 $20,596 100% 77% $39,040 NA $20,247 93
24 Johns Hopkins University MD 4,112 35% 85/93% 8 81% 88% 29 $39,188 $19,142 95% 80% $24,206 9% $13,600 48
25 Cooper Union NY 917 14% 81/83% 7 57% 78% 61 $14,652 $11,167 92% 62% $14,653 100% $9,250 3
26 Washington University MO 7,219 24% 93/98% 7 75% 86% 16 $39,253 $20,700 100% 81% $30,581 19% $0 87
27 Dartmouth College NH 4,118 23% 92/96% 9 87% 95% 12 $38,898 $19,546 100% 76% $36,482 NA $0 92
28 Claremont McKenna College CA 1,024 28% 89/95% 7 82% 86% 37 $37,730 $17,988 100% 86% $31,570 24% $16,914 41
29 University of Notre Dame IN 8,261 34% 83/91% 12 88% 95% 36 $35,392 $18,011 100% 74% $26,304 5% $25,595 45
30 Colgate University NY 2,827 34% 80/86% 10 85% 89% 31 $38,820 $18,856 100% 85% $38,820 NA $12,984 67
31 The Colorado College CO 1,902 53% 66/70% 9 72% 79% 57 $35,275 $16,516 95% 88% $19,645 23% $13,500 10
32 University of Richmond VA 2,998 41% 74/83% 10 79% 84% 48 $31,679 $17,588 96% 80% $21,227 40% $16,115 12
33 Georgetown University DC 6,332 21% 87/89% 11 86% 91% 14 $39,182 $24,382 100% 68% $32,832 NA $20,000 97
34 Brown University RI 6,030 17% 86/90% 8 79% 94% 23 $40,248 $20,838 100% 83% $37,243 NA $21,700 91
35 Carleton College MN 1,932 35% 88/89% 9 82% 86% 34 $35,288 $21,677 100% 72% $32,968 17% $14,543 56
36 Lafayette College PA 2,300 36% 63/78% 11 79% 84% 47 $35,713 $15,147 94% 100% $25,050 17% $17,380 19
37 Middlebury College VT 2,297 27% 93/96% 11 81% 87% 18 $39,532 $18,288 100% 79% $39,532 NA $21,751 98
38 Grinnell College IA 1,485 65% 87/85% 10 78% 84% 55 $31,460 $16,585 100% 76% $23,312 65% $13,854 17
39 Illinois Wesleyan University IL 2,107 48% 96% 12 76% 81% 44 $30,780 $18,858 95% 72% $23,095 76% $17,722 27
40 Bates College ME 1,738 28% 90/91% 10 82% 87% 28 $38,932 $18,258 100% 85% $38,932 NA $17,045 88
41 Cornell University NY 13,725 29% 85/92% 9 82% 90% 26 $38,974 $23,122 100% 69% $38,974 NA $15,587 95
42 Wesleyan University CT 2,733 28% 89/92% 9 76% 81% 24 $39,127 $21,401 100% 72% $39,127 NA $23,753 99
43 Colby College ME 1,830 33% 84/89% 11 85% 88% 33 $38,699 $18,168 100% 93% $38,699 NA $17,270 84
44 Bucknell University PA 3,440 39% 72/84% 12 83% 87% 43 $36,165 $19,165 100% 94% $36,165 NA $16,000 44
45 Kenyon College OH 1,576 52% 87/81% 9 80% 84% 51 $36,273 $17,905 98% 85% $25,183 39% $20,850 32
46 Centre College KY 1,055 78% 89% 11 71% 73% 68 $28,529 $15,842 100% 65% $19,002 23% $14,300 11
47 Rhodes College TN 1,541 70% 95% 11 71% 73% 64 $30,080 $18,899 84% 70% $21,296 50% $15,100 15
48 Macalester College MN 1,840 44% 87/88% 10 71% 77% 58 $32,847 $16,394 100% 80% $27,419 26% $0 29
49 Barnard College NY 2,297 34% 88/88% 10 72% 84% 46 $37,940 $17,826 100% 82% $33,701 8% $14,030 42
50 Brandeis University MA 3,057 42% 88/88% 8 79% 85% 38 $39,101 $22,257 84% 80% $24,255 42% $0 81
51 College of the Holy Cross MA 2,801 43% 71/76% 11 88% 90% 41 $36,851 $23,846 100% 71% $28,381 15% $16,063 69
52 Harvey Mudd College CA 699 37% 97/100% 9 75% 83% 35 $38,880 $22,041 100% 79% $32,890 58% $20,219 90
53 Wake Forest University NC 4,045 41% 79/86% 10 77% 87% 42 $36,079 $21,196 90% 77% $27,438 45% $24,769 61
54 Bryn Mawr College PA 1,321 50% 86/75% 9 76% 80% 45 $37,890 $18,609 96% 86% $36,160 NA $0 57
54 Wheaton College IL 2,395 54% 84/83% 11 70% 84% 66 $27,076 $17,341 97% 74% $22,678 11% $15,864 24
55 Tufts University MA 4,910 27% 81/90% 9 81% 88% 40 $39,173 $20,115 100% 85% $37,477 4% $15,499 79
56 Oberlin College OH 2,848 33% 87/80% 10 63% 76% 50 $37,688 $21,081 100% 72% $26,683 26% $13,926 50
57 Mount Holyoke College MA 2,191 52% 80/70% 10 75% 79% 49 $38,668 $19,268 100% 76% $28,368 10% $14,200 51
58 Furman University SC 2,772 58% 65/70% 11 74% 81% 69 $29,430 $16,296 90% 72% $20,230 55% $17,741 14
59 St. Olaf College MN 3,041 73% 84% 13 71% 75% 67 $29,879 $17,458 100% 74% $25,254 48% $18,806 25
60 Brigham Young University UT 29,379 73% 86% 18 31% 73% 95 $9,663 $7,621 40% 53% $6,523 38% $11,000 2
61 Lehigh University PA 4,706 44% 59/85% 11 70% 84% 65 $35,670 $19,123 99% 75% $23,231 14% $16,972 30
62 Smith College MA 2,647 53% 72/66% 9 76% 80% 56 $37,937 $18,466 100% 76% $28,306 11% $19,911 52
63 Beloit College WI 1,281 70% 82% 11 60% 72% 70 $30,264 $17,452 100% 72% $23,690 19% $14,942 24
64 Taylor University IN 1,869 78% 74% 15 71% 75% 90 $24,723 $15,678 81% 73% $20,538 60% $15,117 7
65 Union College NY 2,147 45% 56/71% 11 75% 80% 72 $36,455 $18,431 97% 79% $16,455 1% $15,725 22
66 Hamilton College NY 1,851 35% 77/82% 10 79% 84% 54 $38,463 $19,474 99% 85% $29,638 8% $16,856 55
67 DePauw University IN 2,338 61% 55/60% 11 75% 79% 88 $32,150 $15,531 99% 82% $21,813 81% $14,481 8
68 Hillsdale College MI 1,220 82% 74% 11 53% 71% 99 $23,353 $13,853 77% 68% $16,853 45% $14,500 6
69 Knox College IL 1,121 72% 72% 12 67% 74% 80 $30,894 $15,494 99% 76% $21,205 67% $16,920 13
70 University of Southern California CA 16,145 30% 79/91% 10 51% 73% 59 $37,968 $21,606 99% 68% $25,660 25% $20,619 70
71 Trinity College CT 2,098 36% 73/79% 9 77% 83% 53 $38,890 $19,667 100% 85% $33,390 1% $17,000 78
72 Trinity University TX 2,406 69% 71/80% 11 65% 75% 86 $27,086 $16,706 86% 71% $21,193 54% $0 20
73 Gustavus Adolphus College MN 2,536 77% 70% 13 72% 75% 89 $27,820 $17,609 92% 70% $21,977 82% $17,400 18
74 Vanderbilt University TN 6,146 46% 83/90% 9 78% 84% 52 $38,847 $20,971 99% 64% $23,049 27% $24,023 86
75 Whitman College WA 1,454 50% 80/81% 10 60% 71% 74 $33,776 $21,176 94% 70% $25,776 72% $15,000 36
76 Scripps College CA 798 58% 85/78% 12 63% 68% 91 $36,500 $17,984 100% 78% $21,355 13% $12,941 23
77 Franklin and Marshall College PA 1,926 62% 62/71% 11 78% 83% 73 $36,580 $20,925 98% 80% $24,751 33% $19,656 40
78 Saint Louis University MO 7,178 72% 72% 12 52% 67% 100 $29,983 $16,902 71% 63% $21,714 36% $14,989 16
79 Carnegie Mellon University PA 5,475 38% 75/95% 11 61% 77% 63 $38,460 $24,689 83% 70% $25,952 22% $19,195 76
80 Lawrence University WI 1,389 68% 83% 11 58% 68% 83 $32,875 $17,882 100% 74% $25,093 65% $18,311 34
81 Connecticut College CT 1,890 35% 83/84% 11 75% 81% 62 $37,057 $16,930 100% 86% $37,057 NA $17,250 85
82 Case Western Reserve University OH 3,457 78% 74/85% 8 49% 75% 87 $32,802 $18,323 96% 66% $20,907 66% $21,830 31
84 Dickinson College PA 2,261 51% 65/64% 13 74% 78% 79 $36,600 $19,753 98% 76% $24,515 30% $17,586 39
85 Kalamazoo College MI 1,265 73% 91% 12 60% 69% 92 $30,917 $17,947 NA% 68% $21,467 92% $20,000 33
86 Saint John's University MN 1,897 87% 66% 13 67% 74% 97 $27,272 $19,544 88% 46% $21,687 68% $20,680 28
87 Boston College MA 9,000 34% 78/85% 13 0% 86% 71 $37,745 $24,470 100% 70% $32,160 7% $16,732 73
88 Reed College OR 1,363 55% 95/86% 10 45% 67% 85 $37,900 $18,804 100% 90% $37,900 NA $16,758 47
89 Bard College NY 1,454 36% 85/67% 9 59% 71% 82 $38,282 $20,558 87% 83% $23,338 11% $15,400 49
90 University of Rochester NY 4,695 50% 79/87% 12 65% 76% 76 $37,246 $20,297 100% 78% $27,245 53% $0 60
91 New York University NY 19,490 28% 87/86% 11 65% 74% 60 $40,105 $28,282 70% 67% $33,355 26% $21,495 100
92 Villanova University PA 7,375 47% 57/74% 13 79% 84% 75 $36,560 $26,463 76% 57% $29,161 20% $28,217 72
93 Skidmore College NY 2,506 46% 70/69% 11 71% 75% 78 $38,838 $21,023 98% 77% $29,438 1% $15,560 71
94 Rose-Hulman Institute of Technology IN 1,642 65% 62/91% 13 58% 71% 93 $32,625 $28,677 60% 27% $28,720 65% $27,000 63
95 St. John's College MD 465 71% 95/75% 8 63% 71% 81 $36,635 $21,940 91% 72% $34,477 4% $20,753 75
96 Babson College MA 1,735 48% 50/77% 13 77% 81% 77 $38,443 $21,316 98% 78% $30,308 11% $0 83
97 Rhode Island School of Design RI 1,882 32% 49/55% 11 0% 87% 96 $34,472 $26,447 69% 53% $33,222 4% $21,125 80
98 Rensselaer Polytechnic Institute NY 5,139 70% 68/92% 17 48% 75% 84 $39,200 $22,360 90% 74% $28,411 45% $24,590 94
99 Sarah Lawrence College NY 1,226 40% 79/44% 6 51% 66% 94 $42,121 $22,847 94% 73% $33,610 NA $14,864 89
100 The George Washington University DC 10,328 40% 68/72% 14 62% 73% 98 $40,240 $25,866 94% 56% $29,916 25% $0 96
*SAT or ACT. Shows the percentage of the 2002-2003 freshman class who scored above 600 on the verbal component of the SAT I and the percentage of those students that scored above 600 on the math component, separated by a slash, or the percentage that scor
From Kiplinger: http://www.kiplinger.com/tools/colleges/

Sheet2

6-year Grad. Rate State Student/faculty Ratio Aid From Grants West South East Undergrad. Enrollment Republican State Football team 4-year Grad. Rate Total Costs
California Institute of Technology 0.85 CA 3 0.93 1 0 939 0 0 0.71 32682
Rice University 0.89 TX 5 0.88 1 0 2787 1 1 0.68 28350
Williams College 0.94 MA 8 0.89 0 0 1985 0 1 0.89 36550
Swarthmore College 0.92 PA 8 0.85 0 0 1479 1 0 0.86 38676
Amherst College 0.94 MA 9 0.92 0 0 1618 0 1 0.84 38492
Webb Institute 0.83 NY 7 1 0 0 67 1 1 0.79 8079
Yale University 0.95 CT 7 0.89 0 0 5339 0 1 0.88 38432
Washington and Lee University 0.89 VA 11 0.87 0 1 1750 1 1 0.86 30225
Harvard University 0.97 MA 8 0.9 0 0 6637 0 1 0.86 38831
Stanford University 0.93 CA 7 0.86 1 0 7360 0 1 0.77 38875
Princeton University 0.97 NJ 5 0.94 0 0 4779 0 1 0.91 40169
Massachusetts Institute of Technology 0.91 MA 6 0.85 0 0 4178 0 1 0.82 39213
Pomona College 0.88 CA 9 0.8 1 0 1551 0 1 0.83 38130
Emory University 0.87 GA 7 0.73 0 1 6302 1 0 0.82 37272
Columbia University 0.93 NY 7 0.86 0 0 4109 1 1 0.83 39493
Duke University 0.93 NC 11 0.8 0 1 6206 1 1 0.88 40080
Davidson College 0.91 NC 10 0.82 0 1 1645 1 1 0.89 34706
Wellesley College 0.88 MA 9 0.88 0 0 2300 0 0 0.84 37419
Vassar College 0.87 NY 9 0.78 0 0 2472 1 0 0.81 37870
Haverford College 0.92 PA 8 0.9 0 0 1105 1 0 0.89 38928
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet3

6-year Grad. Rate State West South East Total Costs Republican State Football team Student/faculty Ratio Undergrad. Enrollment
California Institute of Technology 0.85 CA 1 0 32682 0 0 3 939
Rice University 0.89 TX 1 0 28350 1 1 5 2787
Williams College 0.94 MA 0 0 36550 0 1 8 1985
Swarthmore College 0.92 PA 0 0 38676 1 0 8 1479
Amherst College 0.94 MA 0 0 38492 0 1 9 1618
Webb Institute 0.83 NY 0 0 8079 1 1 7 67
Yale University 0.95 CT 0 0 38432 0 1 7 5339
Washington and Lee University 0.89 VA 0 1 30225 1 1 11 1750
Harvard University 0.97 MA 0 0 38831 0 1 8 6637
Stanford University 0.93 CA 1 0 38875 0 1 7 7360
Princeton University 0.97 NJ 0 0 40169 0 1 5 4779
Massachusetts Institute of Technology 0.91 MA 0 0 39213 0 1 6 4178
Pomona College 0.88 CA 1 0 38130 0 1 9 1551
Emory University 0.87 GA 0 1 37272 1 0 7 6302
Columbia University 0.93 NY 0 0 39493 1 1 7 4109
Duke University 0.93 NC 0 1 40080 1 1 11 6206
Davidson College 0.91 NC 0 1 34706 1 1 10 1645
Wellesley College 0.88 MA 0 0 37419 0 0 9 2300
Vassar College 0.87 NY 0 0 37870 1 0 9 2472
Haverford College 0.92 PA 0 0 38928 1 0 8 1105
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet4

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8985094613
R Square 0.807319252
Adjusted R Square 0.6949221491
Standard Error 0.0211200363
Observations 20
ANOVA
df SS MS F Significance F
Regression 7 0.0224273288 0.0032039041 7.1827407529 0.001627108
Residual 12 0.0053526712 0.0004460559
Total 19 0.02778
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.7694264783 0.037399937 20.5729351692 0.0000000001 0.6879390158 0.8509139407 0.6879390158 0.8509139407
West -0.0324817959 0.0133721228 -2.4290680165 0.0317866019 -0.0616171487 -0.0033464431 -0.0616171487 -0.0033464431
South East -0.0223152775 0.0164678937 -1.3550778203 0.20035267 -0.0581957357 0.0135651806 -0.0581957357 0.0135651806
Total Costs 0.000003492 0.0000009221 3.7869738942 0.0025904833 0.0000014829 0.0000055011 0.0000014829 0.0000055011
Republican State 0.0050589309 0.0129398072 0.3909587553 0.7026802342 -0.0231344869 0.0332523487 -0.0231344869 0.0332523487
Football team 0.0442552326 0.0124103327 3.5659988814 0.0038808196 0.0172154404 0.0712950247 0.0172154404 0.0712950247
Student/faculty Ratio -0.0018317178 0.0033926611 -0.5399059334 0.599138383 -0.0092236913 0.0055602556 -0.0092236913 0.0055602556
Undergrad. Enrollment 0.0000020839 0.0000029468 0.7071646151 0.4929690742 -0.0000043366 0.0000085044 -0.0000043366 0.0000085044
RESIDUAL OUTPUT
Observation Predicted 6-year Grad. Rate Residuals
1 0.8475315523 0.0024684477
2 0.8819059552 0.0080940448
3 0.9307967388 0.0092032612
4 0.8979699757 0.0220300243
5 0.9349816903 0.0050183097
6 0.8342700371 -0.0042700371
7 0.9461896697 0.0038103303
8 0.8854686826 0.0045313174
9 0.9484561139 0.0215438861
10 0.9194663182 0.0105336818
11 0.9547517304 0.0152482696
12 0.9483292653 -0.0383292653
13 0.9010961744 -0.0210961744
14 0.8826341425 -0.0126341425
15 0.9523904494 -0.0223904494
16 0.9291679654 0.0008320346
17 0.9027292095 0.0072707905
18 0.8884007468 -0.0084007468
19 0.8953929908 -0.0253929908
20 0.8980705919 0.0219294081

Sheet5

6-year Grad. Rate State West Total Costs Football team
California Institute of Technology 0.85 CA 1 32682 0
Rice University 0.89 TX 1 28350 1
Williams College 0.94 MA 0 36550 1
Swarthmore College 0.92 PA 0 38676 0
Amherst College 0.94 MA 0 38492 1
Webb Institute 0.83 NY 0 8079 1
Yale University 0.95 CT 0 38432 1
Washington and Lee University 0.89 VA 0 30225 1
Harvard University 0.97 MA 0 38831 1
Stanford University 0.93 CA 1 38875 1
Princeton University 0.97 NJ 0 40169 1
Massachusetts Institute of Technology 0.91 MA 0 39213 1
Pomona College 0.88 CA 1 38130 1
Emory University 0.87 GA 0 37272 0
Columbia University 0.93 NY 0 39493 1
Duke University 0.93 NC 0 40080 1
Davidson College 0.91 NC 0 34706 1
Wellesley College 0.88 MA 0 37419 0
Vassar College 0.87 NY 0 37870 0
Haverford College 0.92 PA 0 38928 0
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet6

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8590077331
R Square 0.7378942855
Adjusted R Square 0.6887494641
Standard Error 0.0213326287
Observations 20
ANOVA
df SS MS F Significance F
Regression 3 0.0204987033 0.0068329011 15.0146905316 0.000065118
Residual 16 0.0072812967 0.000455081
Total 19 0.02778
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.7537956263 0.0271093071 27.805787313 0 0.6963264626 0.81126479 0.6963264626 0.81126479
West -0.0245104848 0.0119743159 -2.046921504 0.0574568751 -0.0498949006 0.000873931 -0.0498949006 0.000873931
Total Costs 0.0000036426 0.0000006853 5.3156851999 0.0000696391 0.0000021899 0.0000050952 0.0000021899 0.0000050952
Football team 0.0433498076 0.0105243748 4.1189912265 0.0008039005 0.0210391296 0.0656604856 0.0210391296 0.0656604856
RESIDUAL OUTPUT
Observation Predicted 6-year Grad. Rate Residuals
1 0.8483317507 0.0016682493
2 0.8759019269 0.0140980731
3 0.93028152 0.00971848
4 0.8946758251 0.0253241749
5 0.937355399 0.002644601
6 0.8265737906 0.0034262094
7 0.9371368445 0.0128631555
8 0.9072422383 -0.0172422383
9 0.9385902316 0.0314097684
10 0.9142400201 0.0157599799
11 0.9434639959 0.0265360041
12 0.939981695 -0.029981695
13 0.9115263023 -0.0315263023
14 0.8895616509 -0.0195616509
15 0.9410016157 -0.0110016157
16 0.9431398068 -0.0131398068
17 0.9235646132 -0.0135646132
18 0.8900971093 -0.0100971093
19 0.8917399103 -0.0217399103
20 0.8955937538 0.0244062462

SUMMARY OUTPUT

Regression Statistics

Multiple R0.859007733

R Square0.737894286

Adjusted R Square0.688749464

Standard Error0.021332629

Observations20

ANOVA

dfSSMSFSignificance F

Regression30.0204987030.00683290115.014690536.5118E-05

Residual160.0072812970.000455081

Total190.02778

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%

Intercept0.7537956260.02710930727.805787315.65822E-150.6963264630.811264790.6963264630.81126479

West-0.0245104850.011974316-2.0469215040.057456875-0.0498949010.000873931-0.0498949010.000873931

Total Costs3.64257E-066.8525E-075.31568526.96391E-052.18991E-065.09524E-062.18991E-065.09524E-06

Football team0.0433498080.0105243754.1189912260.0008039010.021039130.0656604860.021039130.065660486

RESIDUAL OUTPUT

ObservationPredicted 6-year Grad. RateResiduals

10.8483317510.001668249

20.8759019270.014098073

30.930281520.00971848

40.8946758250.025324175

50.9373553990.002644601

60.8265737910.003426209

70.9371368450.012863155

80.907242238-0.017242238

90.9385902320.031409768

100.914240020.01575998

110.9434639960.026536004

120.939981695-0.029981695

130.911526302-0.031526302

140.889561651-0.019561651

150.941001616-0.011001616

160.943139807-0.013139807

170.923564613-0.013564613

180.890097109-0.010097109

190.89173991-0.02173991

200.8955937540.024406246

Sheet1

Top 100 Private Colleges
Quality Measures Financial Measures
Overall Rank School State Undergrad. Enrollment Admission Rate *SAT or ACT Student/faculty Ratio 4-year Grad. Rate 6-year Grad. Rate Quality Rank Total Costs Cost After Need-based Aid Need Met Aid From Grants Cost After Non-Need-Based Aid Non-Need-Based Aid+ Average Debt Cost Rank
1 California Institute of Technology CA 939 21% 99/100% 3 71% 85% 10 $32,682 $10,981 100% 93% $18,553 15% $10,244 4
2 Rice University TX 2,787 24% 89/92% 5 68% 89% 19 $28,350 $14,779 100% 88% $22,418 34% $12,705 5
3 Williams College MA 1,985 23% 93/93% 8 89% 94% 1 $36,550 $14,737 100% 89% $33,251 NA $12,316 26
4 Swarthmore College PA 1,479 24% 94/98% 8 86% 92% 4 $38,676 $17,386 100% 85% $11,404 2% $12,759 21
5 Amherst College MA 1,618 18% 94/92% 9 84% 94% 5 $38,492 $14,453 100% 92% $33,411 NA $11,544 38
6 Webb Institute NY 67 42% 100/100% 7 79% 83% 39 $8,079 $5,579 20% 100% $8,079 100% $5,700 1
7 Yale University CT 5,339 8% 96/97% 7 88% 95% 3 $38,432 $15,729 100% 89% $38,432 NA $19,228 53
8 Washington and Lee University VA 1,750 31% 89/89% 11 86% 89% 30 $30,225 $15,452 99% 87% $22,063 31% $15,634 9
9 Harvard University MA 6,637 11% 90*/90*% 8 86% 97% 8 $38,831 $17,456 100% 90% $33,201 NA $10,465 46
10 Stanford University CA 7,360 13% 93/95% 7 77% 93% 6 $38,875 $17,746 100% 86% $33,709 NA $15,782 62
11 Princeton University NJ 4,779 11% 95/97% 5 91% 97% 7 $40,169 $18,325 100% 94% $40,169 NA $12,000 59
12 Massachusetts Institute of Technology MA 4,178 16% 95/100% 6 82% 91% 2 $39,213 $19,609 100% 85% $30,337 NA $22,855 82
13 Pomona College CA 1,551 23% 98/97% 9 83% 88% 21 $38,130 $17,411 100% 80% $35,702 NA $15,600 43
14 Emory University GA 6,302 42% 89/94% 7 82% 87% 15 $37,272 $19,657 100% 73% $23,615 19% $17,675 54
15 Columbia University NY 4,109 12% 91/93% 7 83% 93% 13 $39,493 $17,778 100% 86% $39,493 NA $15,331 65
16 Duke University NC 6,206 25% 91/94% 11 88% 93% 11 $40,080 $19,996 100% 80% $26,599 6% $20,025 68
17 Davidson College NC 1,645 34% 86/89% 10 89% 91% 27 $34,706 $21,455 100% 82% $28,630 35% $13,697 37
18 Wellesley College MA 2,300 47% 88/89% 9 84% 88% 32 $37,419 $17,526 100% 88% $32,919 NA $15,697 35
19 Vassar College NY 2,472 31% 93/89% 9 81% 87% 22 $37,870 $19,404 100% 78% $34,669 NA $17,170 64
20 Haverford College PA 1,105 32% 89/90% 8 89% 92% 20 $38,928 $17,826 100% 90% $38,928 NA $15,253 66
21 Northwestern University IL 7,946 33% 88/92% 7 83% 92% 17 $38,817 $20,376 100% 79% $36,538 12% $14,551 74
22 Bowdoin College ME 1,657 25% 87/92% 10 83% 90% 25 $38,663 $17,773 100% 85% $37,663 4% $15,307 58
23 University of Pennsylvania PA 9,742 21% 91/96% 6 83% 91% 9 $39,040 $20,596 100% 77% $39,040 NA $20,247 93
24 Johns Hopkins University MD 4,112 35% 85/93% 8 81% 88% 29 $39,188 $19,142 95% 80% $24,206 9% $13,600 48
25 Cooper Union NY 917 14% 81/83% 7 57% 78% 61 $14,652 $11,167 92% 62% $14,653 100% $9,250 3
26 Washington University MO 7,219 24% 93/98% 7 75% 86% 16 $39,253 $20,700 100% 81% $30,581 19% $0 87
27 Dartmouth College NH 4,118 23% 92/96% 9 87% 95% 12 $38,898 $19,546 100% 76% $36,482 NA $0 92
28 Claremont McKenna College CA 1,024 28% 89/95% 7 82% 86% 37 $37,730 $17,988 100% 86% $31,570 24% $16,914 41
29 University of Notre Dame IN 8,261 34% 83/91% 12 88% 95% 36 $35,392 $18,011 100% 74% $26,304 5% $25,595 45
30 Colgate University NY 2,827 34% 80/86% 10 85% 89% 31 $38,820 $18,856 100% 85% $38,820 NA $12,984 67
31 The Colorado College CO 1,902 53% 66/70% 9 72% 79% 57 $35,275 $16,516 95% 88% $19,645 23% $13,500 10
32 University of Richmond VA 2,998 41% 74/83% 10 79% 84% 48 $31,679 $17,588 96% 80% $21,227 40% $16,115 12
33 Georgetown University DC 6,332 21% 87/89% 11 86% 91% 14 $39,182 $24,382 100% 68% $32,832 NA $20,000 97
34 Brown University RI 6,030 17% 86/90% 8 79% 94% 23 $40,248 $20,838 100% 83% $37,243 NA $21,700 91
35 Carleton College MN 1,932 35% 88/89% 9 82% 86% 34 $35,288 $21,677 100% 72% $32,968 17% $14,543 56
36 Lafayette College PA 2,300 36% 63/78% 11 79% 84% 47 $35,713 $15,147 94% 100% $25,050 17% $17,380 19
37 Middlebury College VT 2,297 27% 93/96% 11 81% 87% 18 $39,532 $18,288 100% 79% $39,532 NA $21,751 98
38 Grinnell College IA 1,485 65% 87/85% 10 78% 84% 55 $31,460 $16,585 100% 76% $23,312 65% $13,854 17
39 Illinois Wesleyan University IL 2,107 48% 96% 12 76% 81% 44 $30,780 $18,858 95% 72% $23,095 76% $17,722 27
40 Bates College ME 1,738 28% 90/91% 10 82% 87% 28 $38,932 $18,258 100% 85% $38,932 NA $17,045 88
41 Cornell University NY 13,725 29% 85/92% 9 82% 90% 26 $38,974 $23,122 100% 69% $38,974 NA $15,587 95
42 Wesleyan University CT 2,733 28% 89/92% 9 76% 81% 24 $39,127 $21,401 100% 72% $39,127 NA $23,753 99
43 Colby College ME 1,830 33% 84/89% 11 85% 88% 33 $38,699 $18,168 100% 93% $38,699 NA $17,270 84
44 Bucknell University PA 3,440 39% 72/84% 12 83% 87% 43 $36,165 $19,165 100% 94% $36,165 NA $16,000 44
45 Kenyon College OH 1,576 52% 87/81% 9 80% 84% 51 $36,273 $17,905 98% 85% $25,183 39% $20,850 32
46 Centre College KY 1,055 78% 89% 11 71% 73% 68 $28,529 $15,842 100% 65% $19,002 23% $14,300 11
47 Rhodes College TN 1,541 70% 95% 11 71% 73% 64 $30,080 $18,899 84% 70% $21,296 50% $15,100 15
48 Macalester College MN 1,840 44% 87/88% 10 71% 77% 58 $32,847 $16,394 100% 80% $27,419 26% $0 29
49 Barnard College NY 2,297 34% 88/88% 10 72% 84% 46 $37,940 $17,826 100% 82% $33,701 8% $14,030 42
50 Brandeis University MA 3,057 42% 88/88% 8 79% 85% 38 $39,101 $22,257 84% 80% $24,255 42% $0 81
51 College of the Holy Cross MA 2,801 43% 71/76% 11 88% 90% 41 $36,851 $23,846 100% 71% $28,381 15% $16,063 69
52 Harvey Mudd College CA 699 37% 97/100% 9 75% 83% 35 $38,880 $22,041 100% 79% $32,890 58% $20,219 90
53 Wake Forest University NC 4,045 41% 79/86% 10 77% 87% 42 $36,079 $21,196 90% 77% $27,438 45% $24,769 61
54 Bryn Mawr College PA 1,321 50% 86/75% 9 76% 80% 45 $37,890 $18,609 96% 86% $36,160 NA $0 57
54 Wheaton College IL 2,395 54% 84/83% 11 70% 84% 66 $27,076 $17,341 97% 74% $22,678 11% $15,864 24
55 Tufts University MA 4,910 27% 81/90% 9 81% 88% 40 $39,173 $20,115 100% 85% $37,477 4% $15,499 79
56 Oberlin College OH 2,848 33% 87/80% 10 63% 76% 50 $37,688 $21,081 100% 72% $26,683 26% $13,926 50
57 Mount Holyoke College MA 2,191 52% 80/70% 10 75% 79% 49 $38,668 $19,268 100% 76% $28,368 10% $14,200 51
58 Furman University SC 2,772 58% 65/70% 11 74% 81% 69 $29,430 $16,296 90% 72% $20,230 55% $17,741 14
59 St. Olaf College MN 3,041 73% 84% 13 71% 75% 67 $29,879 $17,458 100% 74% $25,254 48% $18,806 25
60 Brigham Young University UT 29,379 73% 86% 18 31% 73% 95 $9,663 $7,621 40% 53% $6,523 38% $11,000 2
61 Lehigh University PA 4,706 44% 59/85% 11 70% 84% 65 $35,670 $19,123 99% 75% $23,231 14% $16,972 30
62 Smith College MA 2,647 53% 72/66% 9 76% 80% 56 $37,937 $18,466 100% 76% $28,306 11% $19,911 52
63 Beloit College WI 1,281 70% 82% 11 60% 72% 70 $30,264 $17,452 100% 72% $23,690 19% $14,942 24
64 Taylor University IN 1,869 78% 74% 15 71% 75% 90 $24,723 $15,678 81% 73% $20,538 60% $15,117 7
65 Union College NY 2,147 45% 56/71% 11 75% 80% 72 $36,455 $18,431 97% 79% $16,455 1% $15,725 22
66 Hamilton College NY 1,851 35% 77/82% 10 79% 84% 54 $38,463 $19,474 99% 85% $29,638 8% $16,856 55
67 DePauw University IN 2,338 61% 55/60% 11 75% 79% 88 $32,150 $15,531 99% 82% $21,813 81% $14,481 8
68 Hillsdale College MI 1,220 82% 74% 11 53% 71% 99 $23,353 $13,853 77% 68% $16,853 45% $14,500 6
69 Knox College IL 1,121 72% 72% 12 67% 74% 80 $30,894 $15,494 99% 76% $21,205 67% $16,920 13
70 University of Southern California CA 16,145 30% 79/91% 10 51% 73% 59 $37,968 $21,606 99% 68% $25,660 25% $20,619 70
71 Trinity College CT 2,098 36% 73/79% 9 77% 83% 53 $38,890 $19,667 100% 85% $33,390 1% $17,000 78
72 Trinity University TX 2,406 69% 71/80% 11 65% 75% 86 $27,086 $16,706 86% 71% $21,193 54% $0 20
73 Gustavus Adolphus College MN 2,536 77% 70% 13 72% 75% 89 $27,820 $17,609 92% 70% $21,977 82% $17,400 18
74 Vanderbilt University TN 6,146 46% 83/90% 9 78% 84% 52 $38,847 $20,971 99% 64% $23,049 27% $24,023 86
75 Whitman College WA 1,454 50% 80/81% 10 60% 71% 74 $33,776 $21,176 94% 70% $25,776 72% $15,000 36
76 Scripps College CA 798 58% 85/78% 12 63% 68% 91 $36,500 $17,984 100% 78% $21,355 13% $12,941 23
77 Franklin and Marshall College PA 1,926 62% 62/71% 11 78% 83% 73 $36,580 $20,925 98% 80% $24,751 33% $19,656 40
78 Saint Louis University MO 7,178 72% 72% 12 52% 67% 100 $29,983 $16,902 71% 63% $21,714 36% $14,989 16
79 Carnegie Mellon University PA 5,475 38% 75/95% 11 61% 77% 63 $38,460 $24,689 83% 70% $25,952 22% $19,195 76
80 Lawrence University WI 1,389 68% 83% 11 58% 68% 83 $32,875 $17,882 100% 74% $25,093 65% $18,311 34
81 Connecticut College CT 1,890 35% 83/84% 11 75% 81% 62 $37,057 $16,930 100% 86% $37,057 NA $17,250 85
82 Case Western Reserve University OH 3,457 78% 74/85% 8 49% 75% 87 $32,802 $18,323 96% 66% $20,907 66% $21,830 31
84 Dickinson College PA 2,261 51% 65/64% 13 74% 78% 79 $36,600 $19,753 98% 76% $24,515 30% $17,586 39
85 Kalamazoo College MI 1,265 73% 91% 12 60% 69% 92 $30,917 $17,947 NA% 68% $21,467 92% $20,000 33
86 Saint John's University MN 1,897 87% 66% 13 67% 74% 97 $27,272 $19,544 88% 46% $21,687 68% $20,680 28
87 Boston College MA 9,000 34% 78/85% 13 0% 86% 71 $37,745 $24,470 100% 70% $32,160 7% $16,732 73
88 Reed College OR 1,363 55% 95/86% 10 45% 67% 85 $37,900 $18,804 100% 90% $37,900 NA $16,758 47
89 Bard College NY 1,454 36% 85/67% 9 59% 71% 82 $38,282 $20,558 87% 83% $23,338 11% $15,400 49
90 University of Rochester NY 4,695 50% 79/87% 12 65% 76% 76 $37,246 $20,297 100% 78% $27,245 53% $0 60
91 New York University NY 19,490 28% 87/86% 11 65% 74% 60 $40,105 $28,282 70% 67% $33,355 26% $21,495 100
92 Villanova University PA 7,375 47% 57/74% 13 79% 84% 75 $36,560 $26,463 76% 57% $29,161 20% $28,217 72
93 Skidmore College NY 2,506 46% 70/69% 11 71% 75% 78 $38,838 $21,023 98% 77% $29,438 1% $15,560 71
94 Rose-Hulman Institute of Technology IN 1,642 65% 62/91% 13 58% 71% 93 $32,625 $28,677 60% 27% $28,720 65% $27,000 63
95 St. John's College MD 465 71% 95/75% 8 63% 71% 81 $36,635 $21,940 91% 72% $34,477 4% $20,753 75
96 Babson College MA 1,735 48% 50/77% 13 77% 81% 77 $38,443 $21,316 98% 78% $30,308 11% $0 83
97 Rhode Island School of Design RI 1,882 32% 49/55% 11 0% 87% 96 $34,472 $26,447 69% 53% $33,222 4% $21,125 80
98 Rensselaer Polytechnic Institute NY 5,139 70% 68/92% 17 48% 75% 84 $39,200 $22,360 90% 74% $28,411 45% $24,590 94
99 Sarah Lawrence College NY 1,226 40% 79/44% 6 51% 66% 94 $42,121 $22,847 94% 73% $33,610 NA $14,864 89
100 The George Washington University DC 10,328 40% 68/72% 14 62% 73% 98 $40,240 $25,866 94% 56% $29,916 25% $0 96
*SAT or ACT. Shows the percentage of the 2002-2003 freshman class who scored above 600 on the verbal component of the SAT I and the percentage of those students that scored above 600 on the math component, separated by a slash, or the percentage that scor
From Kiplinger: http://www.kiplinger.com/tools/colleges/

Sheet2

6-year Grad. Rate State Student/faculty Ratio Aid From Grants West South East Undergrad. Enrollment Republican State Football team 4-year Grad. Rate Total Costs
California Institute of Technology 0.85 CA 3 0.93 1 0 939 0 0 0.71 32682
Rice University 0.89 TX 5 0.88 1 0 2787 1 1 0.68 28350
Williams College 0.94 MA 8 0.89 0 0 1985 0 1 0.89 36550
Swarthmore College 0.92 PA 8 0.85 0 0 1479 1 0 0.86 38676
Amherst College 0.94 MA 9 0.92 0 0 1618 0 1 0.84 38492
Webb Institute 0.83 NY 7 1 0 0 67 1 1 0.79 8079
Yale University 0.95 CT 7 0.89 0 0 5339 0 1 0.88 38432
Washington and Lee University 0.89 VA 11 0.87 0 1 1750 1 1 0.86 30225
Harvard University 0.97 MA 8 0.9 0 0 6637 0 1 0.86 38831
Stanford University 0.93 CA 7 0.86 1 0 7360 0 1 0.77 38875
Princeton University 0.97 NJ 5 0.94 0 0 4779 0 1 0.91 40169
Massachusetts Institute of Technology 0.91 MA 6 0.85 0 0 4178 0 1 0.82 39213
Pomona College 0.88 CA 9 0.8 1 0 1551 0 1 0.83 38130
Emory University 0.87 GA 7 0.73 0 1 6302 1 0 0.82 37272
Columbia University 0.93 NY 7 0.86 0 0 4109 1 1 0.83 39493
Duke University 0.93 NC 11 0.8 0 1 6206 1 1 0.88 40080
Davidson College 0.91 NC 10 0.82 0 1 1645 1 1 0.89 34706
Wellesley College 0.88 MA 9 0.88 0 0 2300 0 0 0.84 37419
Vassar College 0.87 NY 9 0.78 0 0 2472 1 0 0.81 37870
Haverford College 0.92 PA 8 0.9 0 0 1105 1 0 0.89 38928
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet3

6-year Grad. Rate State West South East Total Costs Republican State Football team Student/faculty Ratio Undergrad. Enrollment
California Institute of Technology 0.85 CA 1 0 32682 0 0 3 939
Rice University 0.89 TX 1 0 28350 1 1 5 2787
Williams College 0.94 MA 0 0 36550 0 1 8 1985
Swarthmore College 0.92 PA 0 0 38676 1 0 8 1479
Amherst College 0.94 MA 0 0 38492 0 1 9 1618
Webb Institute 0.83 NY 0 0 8079 1 1 7 67
Yale University 0.95 CT 0 0 38432 0 1 7 5339
Washington and Lee University 0.89 VA 0 1 30225 1 1 11 1750
Harvard University 0.97 MA 0 0 38831 0 1 8 6637
Stanford University 0.93 CA 1 0 38875 0 1 7 7360
Princeton University 0.97 NJ 0 0 40169 0 1 5 4779
Massachusetts Institute of Technology 0.91 MA 0 0 39213 0 1 6 4178
Pomona College 0.88 CA 1 0 38130 0 1 9 1551
Emory University 0.87 GA 0 1 37272 1 0 7 6302
Columbia University 0.93 NY 0 0 39493 1 1 7 4109
Duke University 0.93 NC 0 1 40080 1 1 11 6206
Davidson College 0.91 NC 0 1 34706 1 1 10 1645
Wellesley College 0.88 MA 0 0 37419 0 0 9 2300
Vassar College 0.87 NY 0 0 37870 1 0 9 2472
Haverford College 0.92 PA 0 0 38928 1 0 8 1105
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet4

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8985094613
R Square 0.807319252
Adjusted R Square 0.6949221491
Standard Error 0.0211200363
Observations 20
ANOVA
df SS MS F Significance F
Regression 7 0.0224273288 0.0032039041 7.1827407529 0.001627108
Residual 12 0.0053526712 0.0004460559
Total 19 0.02778
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.7694264783 0.037399937 20.5729351692 0.0000000001 0.6879390158 0.8509139407 0.6879390158 0.8509139407
West -0.0324817959 0.0133721228 -2.4290680165 0.0317866019 -0.0616171487 -0.0033464431 -0.0616171487 -0.0033464431
South East -0.0223152775 0.0164678937 -1.3550778203 0.20035267 -0.0581957357 0.0135651806 -0.0581957357 0.0135651806
Total Costs 0.000003492 0.0000009221 3.7869738942 0.0025904833 0.0000014829 0.0000055011 0.0000014829 0.0000055011
Republican State 0.0050589309 0.0129398072 0.3909587553 0.7026802342 -0.0231344869 0.0332523487 -0.0231344869 0.0332523487
Football team 0.0442552326 0.0124103327 3.5659988814 0.0038808196 0.0172154404 0.0712950247 0.0172154404 0.0712950247
Student/faculty Ratio -0.0018317178 0.0033926611 -0.5399059334 0.599138383 -0.0092236913 0.0055602556 -0.0092236913 0.0055602556
Undergrad. Enrollment 0.0000020839 0.0000029468 0.7071646151 0.4929690742 -0.0000043366 0.0000085044 -0.0000043366 0.0000085044
RESIDUAL OUTPUT
Observation Predicted 6-year Grad. Rate Residuals
1 0.8475315523 0.0024684477
2 0.8819059552 0.0080940448
3 0.9307967388 0.0092032612
4 0.8979699757 0.0220300243
5 0.9349816903 0.0050183097
6 0.8342700371 -0.0042700371
7 0.9461896697 0.0038103303
8 0.8854686826 0.0045313174
9 0.9484561139 0.0215438861
10 0.9194663182 0.0105336818
11 0.9547517304 0.0152482696
12 0.9483292653 -0.0383292653
13 0.9010961744 -0.0210961744
14 0.8826341425 -0.0126341425
15 0.9523904494 -0.0223904494
16 0.9291679654 0.0008320346
17 0.9027292095 0.0072707905
18 0.8884007468 -0.0084007468
19 0.8953929908 -0.0253929908
20 0.8980705919 0.0219294081

Sheet5

6-year Grad. Rate State West Total Costs Football team
California Institute of Technology 0.85 CA 1 32682 0
Rice University 0.89 TX 1 28350 1
Williams College 0.94 MA 0 36550 1
Swarthmore College 0.92 PA 0 38676 0
Amherst College 0.94 MA 0 38492 1
Webb Institute 0.83 NY 0 8079 1
Yale University 0.95 CT 0 38432 1
Washington and Lee University 0.89 VA 0 30225 1
Harvard University 0.97 MA 0 38831 1
Stanford University 0.93 CA 1 38875 1
Princeton University 0.97 NJ 0 40169 1
Massachusetts Institute of Technology 0.91 MA 0 39213 1
Pomona College 0.88 CA 1 38130 1
Emory University 0.87 GA 0 37272 0
Columbia University 0.93 NY 0 39493 1
Duke University 0.93 NC 0 40080 1
Davidson College 0.91 NC 0 34706 1
Wellesley College 0.88 MA 0 37419 0
Vassar College 0.87 NY 0 37870 0
Haverford College 0.92 PA 0 38928 0
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet6

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8590077331
R Square 0.7378942855
Adjusted R Square 0.6887494641
Standard Error 0.0213326287
Observations 20
ANOVA
df SS MS F Significance F
Regression 3 0.0204987033 0.0068329011 15.0146905316 0.000065118
Residual 16 0.0072812967 0.000455081
Total 19 0.02778
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.7537956263 0.0271093071 27.805787313 0 0.6963264626 0.81126479 0.6963264626 0.81126479
West -0.0245104848 0.0119743159 -2.046921504 0.0574568751 -0.0498949006 0.000873931 -0.0498949006 0.000873931
Total Costs 0.0000036426 0.0000006853 5.3156851999 0.0000696391 0.0000021899 0.0000050952 0.0000021899 0.0000050952
Football team 0.0433498076 0.0105243748 4.1189912265 0.0008039005 0.0210391296 0.0656604856 0.0210391296 0.0656604856
RESIDUAL OUTPUT
Observation Predicted 6-year Grad. Rate Residuals
1 0.8483317507 0.0016682493
2 0.8759019269 0.0140980731
3 0.93028152 0.00971848
4 0.8946758251 0.0253241749
5 0.937355399 0.002644601
6 0.8265737906 0.0034262094
7 0.9371368445 0.0128631555
8 0.9072422383 -0.0172422383
9 0.9385902316 0.0314097684
10 0.9142400201 0.0157599799
11 0.9434639959 0.0265360041
12 0.939981695 -0.029981695
13 0.9115263023 -0.0315263023
14 0.8895616509 -0.0195616509
15 0.9410016157 -0.0110016157
16 0.9431398068 -0.0131398068
17 0.9235646132 -0.0135646132
18 0.8900971093 -0.0100971093
19 0.8917399103 -0.0217399103
20 0.8955937538 0.0244062462

SUMMARY OUTPUT

Regression Statistics

Multiple R0.859007733

R Square0.737894286

Adjusted R Square0.688749464

Standard Error0.021332629

Observations20

ANOVA

dfSSMSFSignificance F

Regression30.0204987030.00683290115.014690536.5118E-05

Residual160.0072812970.000455081

Total190.02778

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%

Intercept0.7537956260.02710930727.805787315.65822E-150.6963264630.811264790.6963264630.81126479

West-0.0245104850.011974316-2.0469215040.057456875-0.0498949010.000873931-0.0498949010.000873931

Total Costs3.64257E-066.8525E-075.31568526.96391E-052.18991E-065.09524E-062.18991E-065.09524E-06

Football team0.0433498080.0105243754.1189912260.0008039010.021039130.0656604860.021039130.065660486

significant variables

RESIDUAL OUTPUT

ObservationPredicted 6-year Grad. RateResiduals

10.8483317510.001668249

20.8759019270.014098073

30.930281520.00971848

40.8946758250.025324175

50.9373553990.002644601

60.8265737910.003426209

70.9371368450.012863155

80.907242238-0.017242238

90.9385902320.031409768

100.914240020.01575998

110.9434639960.026536004

120.939981695-0.029981695

130.911526302-0.031526302

140.889561651-0.019561651

150.941001616-0.011001616

160.943139807-0.013139807

170.923564613-0.013564613

180.890097109-0.010097109

190.89173991-0.02173991

200.8955937540.024406246

Sheet1

Top 100 Private Colleges
Quality Measures Financial Measures
Overall Rank School State Undergrad. Enrollment Admission Rate *SAT or ACT Student/faculty Ratio 4-year Grad. Rate 6-year Grad. Rate Quality Rank Total Costs Cost After Need-based Aid Need Met Aid From Grants Cost After Non-Need-Based Aid Non-Need-Based Aid+ Average Debt Cost Rank
1 California Institute of Technology CA 939 21% 99/100% 3 71% 85% 10 $32,682 $10,981 100% 93% $18,553 15% $10,244 4
2 Rice University TX 2,787 24% 89/92% 5 68% 89% 19 $28,350 $14,779 100% 88% $22,418 34% $12,705 5
3 Williams College MA 1,985 23% 93/93% 8 89% 94% 1 $36,550 $14,737 100% 89% $33,251 NA $12,316 26
4 Swarthmore College PA 1,479 24% 94/98% 8 86% 92% 4 $38,676 $17,386 100% 85% $11,404 2% $12,759 21
5 Amherst College MA 1,618 18% 94/92% 9 84% 94% 5 $38,492 $14,453 100% 92% $33,411 NA $11,544 38
6 Webb Institute NY 67 42% 100/100% 7 79% 83% 39 $8,079 $5,579 20% 100% $8,079 100% $5,700 1
7 Yale University CT 5,339 8% 96/97% 7 88% 95% 3 $38,432 $15,729 100% 89% $38,432 NA $19,228 53
8 Washington and Lee University VA 1,750 31% 89/89% 11 86% 89% 30 $30,225 $15,452 99% 87% $22,063 31% $15,634 9
9 Harvard University MA 6,637 11% 90*/90*% 8 86% 97% 8 $38,831 $17,456 100% 90% $33,201 NA $10,465 46
10 Stanford University CA 7,360 13% 93/95% 7 77% 93% 6 $38,875 $17,746 100% 86% $33,709 NA $15,782 62
11 Princeton University NJ 4,779 11% 95/97% 5 91% 97% 7 $40,169 $18,325 100% 94% $40,169 NA $12,000 59
12 Massachusetts Institute of Technology MA 4,178 16% 95/100% 6 82% 91% 2 $39,213 $19,609 100% 85% $30,337 NA $22,855 82
13 Pomona College CA 1,551 23% 98/97% 9 83% 88% 21 $38,130 $17,411 100% 80% $35,702 NA $15,600 43
14 Emory University GA 6,302 42% 89/94% 7 82% 87% 15 $37,272 $19,657 100% 73% $23,615 19% $17,675 54
15 Columbia University NY 4,109 12% 91/93% 7 83% 93% 13 $39,493 $17,778 100% 86% $39,493 NA $15,331 65
16 Duke University NC 6,206 25% 91/94% 11 88% 93% 11 $40,080 $19,996 100% 80% $26,599 6% $20,025 68
17 Davidson College NC 1,645 34% 86/89% 10 89% 91% 27 $34,706 $21,455 100% 82% $28,630 35% $13,697 37
18 Wellesley College MA 2,300 47% 88/89% 9 84% 88% 32 $37,419 $17,526 100% 88% $32,919 NA $15,697 35
19 Vassar College NY 2,472 31% 93/89% 9 81% 87% 22 $37,870 $19,404 100% 78% $34,669 NA $17,170 64
20 Haverford College PA 1,105 32% 89/90% 8 89% 92% 20 $38,928 $17,826 100% 90% $38,928 NA $15,253 66
21 Northwestern University IL 7,946 33% 88/92% 7 83% 92% 17 $38,817 $20,376 100% 79% $36,538 12% $14,551 74
22 Bowdoin College ME 1,657 25% 87/92% 10 83% 90% 25 $38,663 $17,773 100% 85% $37,663 4% $15,307 58
23 University of Pennsylvania PA 9,742 21% 91/96% 6 83% 91% 9 $39,040 $20,596 100% 77% $39,040 NA $20,247 93
24 Johns Hopkins University MD 4,112 35% 85/93% 8 81% 88% 29 $39,188 $19,142 95% 80% $24,206 9% $13,600 48
25 Cooper Union NY 917 14% 81/83% 7 57% 78% 61 $14,652 $11,167 92% 62% $14,653 100% $9,250 3
26 Washington University MO 7,219 24% 93/98% 7 75% 86% 16 $39,253 $20,700 100% 81% $30,581 19% $0 87
27 Dartmouth College NH 4,118 23% 92/96% 9 87% 95% 12 $38,898 $19,546 100% 76% $36,482 NA $0 92
28 Claremont McKenna College CA 1,024 28% 89/95% 7 82% 86% 37 $37,730 $17,988 100% 86% $31,570 24% $16,914 41
29 University of Notre Dame IN 8,261 34% 83/91% 12 88% 95% 36 $35,392 $18,011 100% 74% $26,304 5% $25,595 45
30 Colgate University NY 2,827 34% 80/86% 10 85% 89% 31 $38,820 $18,856 100% 85% $38,820 NA $12,984 67
31 The Colorado College CO 1,902 53% 66/70% 9 72% 79% 57 $35,275 $16,516 95% 88% $19,645 23% $13,500 10
32 University of Richmond VA 2,998 41% 74/83% 10 79% 84% 48 $31,679 $17,588 96% 80% $21,227 40% $16,115 12
33 Georgetown University DC 6,332 21% 87/89% 11 86% 91% 14 $39,182 $24,382 100% 68% $32,832 NA $20,000 97
34 Brown University RI 6,030 17% 86/90% 8 79% 94% 23 $40,248 $20,838 100% 83% $37,243 NA $21,700 91
35 Carleton College MN 1,932 35% 88/89% 9 82% 86% 34 $35,288 $21,677 100% 72% $32,968 17% $14,543 56
36 Lafayette College PA 2,300 36% 63/78% 11 79% 84% 47 $35,713 $15,147 94% 100% $25,050 17% $17,380 19
37 Middlebury College VT 2,297 27% 93/96% 11 81% 87% 18 $39,532 $18,288 100% 79% $39,532 NA $21,751 98
38 Grinnell College IA 1,485 65% 87/85% 10 78% 84% 55 $31,460 $16,585 100% 76% $23,312 65% $13,854 17
39 Illinois Wesleyan University IL 2,107 48% 96% 12 76% 81% 44 $30,780 $18,858 95% 72% $23,095 76% $17,722 27
40 Bates College ME 1,738 28% 90/91% 10 82% 87% 28 $38,932 $18,258 100% 85% $38,932 NA $17,045 88
41 Cornell University NY 13,725 29% 85/92% 9 82% 90% 26 $38,974 $23,122 100% 69% $38,974 NA $15,587 95
42 Wesleyan University CT 2,733 28% 89/92% 9 76% 81% 24 $39,127 $21,401 100% 72% $39,127 NA $23,753 99
43 Colby College ME 1,830 33% 84/89% 11 85% 88% 33 $38,699 $18,168 100% 93% $38,699 NA $17,270 84
44 Bucknell University PA 3,440 39% 72/84% 12 83% 87% 43 $36,165 $19,165 100% 94% $36,165 NA $16,000 44
45 Kenyon College OH 1,576 52% 87/81% 9 80% 84% 51 $36,273 $17,905 98% 85% $25,183 39% $20,850 32
46 Centre College KY 1,055 78% 89% 11 71% 73% 68 $28,529 $15,842 100% 65% $19,002 23% $14,300 11
47 Rhodes College TN 1,541 70% 95% 11 71% 73% 64 $30,080 $18,899 84% 70% $21,296 50% $15,100 15
48 Macalester College MN 1,840 44% 87/88% 10 71% 77% 58 $32,847 $16,394 100% 80% $27,419 26% $0 29
49 Barnard College NY 2,297 34% 88/88% 10 72% 84% 46 $37,940 $17,826 100% 82% $33,701 8% $14,030 42
50 Brandeis University MA 3,057 42% 88/88% 8 79% 85% 38 $39,101 $22,257 84% 80% $24,255 42% $0 81
51 College of the Holy Cross MA 2,801 43% 71/76% 11 88% 90% 41 $36,851 $23,846 100% 71% $28,381 15% $16,063 69
52 Harvey Mudd College CA 699 37% 97/100% 9 75% 83% 35 $38,880 $22,041 100% 79% $32,890 58% $20,219 90
53 Wake Forest University NC 4,045 41% 79/86% 10 77% 87% 42 $36,079 $21,196 90% 77% $27,438 45% $24,769 61
54 Bryn Mawr College PA 1,321 50% 86/75% 9 76% 80% 45 $37,890 $18,609 96% 86% $36,160 NA $0 57
54 Wheaton College IL 2,395 54% 84/83% 11 70% 84% 66 $27,076 $17,341 97% 74% $22,678 11% $15,864 24
55 Tufts University MA 4,910 27% 81/90% 9 81% 88% 40 $39,173 $20,115 100% 85% $37,477 4% $15,499 79
56 Oberlin College OH 2,848 33% 87/80% 10 63% 76% 50 $37,688 $21,081 100% 72% $26,683 26% $13,926 50
57 Mount Holyoke College MA 2,191 52% 80/70% 10 75% 79% 49 $38,668 $19,268 100% 76% $28,368 10% $14,200 51
58 Furman University SC 2,772 58% 65/70% 11 74% 81% 69 $29,430 $16,296 90% 72% $20,230 55% $17,741 14
59 St. Olaf College MN 3,041 73% 84% 13 71% 75% 67 $29,879 $17,458 100% 74% $25,254 48% $18,806 25
60 Brigham Young University UT 29,379 73% 86% 18 31% 73% 95 $9,663 $7,621 40% 53% $6,523 38% $11,000 2
61 Lehigh University PA 4,706 44% 59/85% 11 70% 84% 65 $35,670 $19,123 99% 75% $23,231 14% $16,972 30
62 Smith College MA 2,647 53% 72/66% 9 76% 80% 56 $37,937 $18,466 100% 76% $28,306 11% $19,911 52
63 Beloit College WI 1,281 70% 82% 11 60% 72% 70 $30,264 $17,452 100% 72% $23,690 19% $14,942 24
64 Taylor University IN 1,869 78% 74% 15 71% 75% 90 $24,723 $15,678 81% 73% $20,538 60% $15,117 7
65 Union College NY 2,147 45% 56/71% 11 75% 80% 72 $36,455 $18,431 97% 79% $16,455 1% $15,725 22
66 Hamilton College NY 1,851 35% 77/82% 10 79% 84% 54 $38,463 $19,474 99% 85% $29,638 8% $16,856 55
67 DePauw University IN 2,338 61% 55/60% 11 75% 79% 88 $32,150 $15,531 99% 82% $21,813 81% $14,481 8
68 Hillsdale College MI 1,220 82% 74% 11 53% 71% 99 $23,353 $13,853 77% 68% $16,853 45% $14,500 6
69 Knox College IL 1,121 72% 72% 12 67% 74% 80 $30,894 $15,494 99% 76% $21,205 67% $16,920 13
70 University of Southern California CA 16,145 30% 79/91% 10 51% 73% 59 $37,968 $21,606 99% 68% $25,660 25% $20,619 70
71 Trinity College CT 2,098 36% 73/79% 9 77% 83% 53 $38,890 $19,667 100% 85% $33,390 1% $17,000 78
72 Trinity University TX 2,406 69% 71/80% 11 65% 75% 86 $27,086 $16,706 86% 71% $21,193 54% $0 20
73 Gustavus Adolphus College MN 2,536 77% 70% 13 72% 75% 89 $27,820 $17,609 92% 70% $21,977 82% $17,400 18
74 Vanderbilt University TN 6,146 46% 83/90% 9 78% 84% 52 $38,847 $20,971 99% 64% $23,049 27% $24,023 86
75 Whitman College WA 1,454 50% 80/81% 10 60% 71% 74 $33,776 $21,176 94% 70% $25,776 72% $15,000 36
76 Scripps College CA 798 58% 85/78% 12 63% 68% 91 $36,500 $17,984 100% 78% $21,355 13% $12,941 23
77 Franklin and Marshall College PA 1,926 62% 62/71% 11 78% 83% 73 $36,580 $20,925 98% 80% $24,751 33% $19,656 40
78 Saint Louis University MO 7,178 72% 72% 12 52% 67% 100 $29,983 $16,902 71% 63% $21,714 36% $14,989 16
79 Carnegie Mellon University PA 5,475 38% 75/95% 11 61% 77% 63 $38,460 $24,689 83% 70% $25,952 22% $19,195 76
80 Lawrence University WI 1,389 68% 83% 11 58% 68% 83 $32,875 $17,882 100% 74% $25,093 65% $18,311 34
81 Connecticut College CT 1,890 35% 83/84% 11 75% 81% 62 $37,057 $16,930 100% 86% $37,057 NA $17,250 85
82 Case Western Reserve University OH 3,457 78% 74/85% 8 49% 75% 87 $32,802 $18,323 96% 66% $20,907 66% $21,830 31
84 Dickinson College PA 2,261 51% 65/64% 13 74% 78% 79 $36,600 $19,753 98% 76% $24,515 30% $17,586 39
85 Kalamazoo College MI 1,265 73% 91% 12 60% 69% 92 $30,917 $17,947 NA% 68% $21,467 92% $20,000 33
86 Saint John's University MN 1,897 87% 66% 13 67% 74% 97 $27,272 $19,544 88% 46% $21,687 68% $20,680 28
87 Boston College MA 9,000 34% 78/85% 13 0% 86% 71 $37,745 $24,470 100% 70% $32,160 7% $16,732 73
88 Reed College OR 1,363 55% 95/86% 10 45% 67% 85 $37,900 $18,804 100% 90% $37,900 NA $16,758 47
89 Bard College NY 1,454 36% 85/67% 9 59% 71% 82 $38,282 $20,558 87% 83% $23,338 11% $15,400 49
90 University of Rochester NY 4,695 50% 79/87% 12 65% 76% 76 $37,246 $20,297 100% 78% $27,245 53% $0 60
91 New York University NY 19,490 28% 87/86% 11 65% 74% 60 $40,105 $28,282 70% 67% $33,355 26% $21,495 100
92 Villanova University PA 7,375 47% 57/74% 13 79% 84% 75 $36,560 $26,463 76% 57% $29,161 20% $28,217 72
93 Skidmore College NY 2,506 46% 70/69% 11 71% 75% 78 $38,838 $21,023 98% 77% $29,438 1% $15,560 71
94 Rose-Hulman Institute of Technology IN 1,642 65% 62/91% 13 58% 71% 93 $32,625 $28,677 60% 27% $28,720 65% $27,000 63
95 St. John's College MD 465 71% 95/75% 8 63% 71% 81 $36,635 $21,940 91% 72% $34,477 4% $20,753 75
96 Babson College MA 1,735 48% 50/77% 13 77% 81% 77 $38,443 $21,316 98% 78% $30,308 11% $0 83
97 Rhode Island School of Design RI 1,882 32% 49/55% 11 0% 87% 96 $34,472 $26,447 69% 53% $33,222 4% $21,125 80
98 Rensselaer Polytechnic Institute NY 5,139 70% 68/92% 17 48% 75% 84 $39,200 $22,360 90% 74% $28,411 45% $24,590 94
99 Sarah Lawrence College NY 1,226 40% 79/44% 6 51% 66% 94 $42,121 $22,847 94% 73% $33,610 NA $14,864 89
100 The George Washington University DC 10,328 40% 68/72% 14 62% 73% 98 $40,240 $25,866 94% 56% $29,916 25% $0 96
*SAT or ACT. Shows the percentage of the 2002-2003 freshman class who scored above 600 on the verbal component of the SAT I and the percentage of those students that scored above 600 on the math component, separated by a slash, or the percentage that scor
From Kiplinger: http://www.kiplinger.com/tools/colleges/

Sheet2

6-year Grad. Rate State Student/faculty Ratio Aid From Grants West South East Undergrad. Enrollment Republican State Football team 4-year Grad. Rate Total Costs
California Institute of Technology 0.85 CA 3 0.93 1 0 939 0 0 0.71 32682
Rice University 0.89 TX 5 0.88 1 0 2787 1 1 0.68 28350
Williams College 0.94 MA 8 0.89 0 0 1985 0 1 0.89 36550
Swarthmore College 0.92 PA 8 0.85 0 0 1479 1 0 0.86 38676
Amherst College 0.94 MA 9 0.92 0 0 1618 0 1 0.84 38492
Webb Institute 0.83 NY 7 1 0 0 67 1 1 0.79 8079
Yale University 0.95 CT 7 0.89 0 0 5339 0 1 0.88 38432
Washington and Lee University 0.89 VA 11 0.87 0 1 1750 1 1 0.86 30225
Harvard University 0.97 MA 8 0.9 0 0 6637 0 1 0.86 38831
Stanford University 0.93 CA 7 0.86 1 0 7360 0 1 0.77 38875
Princeton University 0.97 NJ 5 0.94 0 0 4779 0 1 0.91 40169
Massachusetts Institute of Technology 0.91 MA 6 0.85 0 0 4178 0 1 0.82 39213
Pomona College 0.88 CA 9 0.8 1 0 1551 0 1 0.83 38130
Emory University 0.87 GA 7 0.73 0 1 6302 1 0 0.82 37272
Columbia University 0.93 NY 7 0.86 0 0 4109 1 1 0.83 39493
Duke University 0.93 NC 11 0.8 0 1 6206 1 1 0.88 40080
Davidson College 0.91 NC 10 0.82 0 1 1645 1 1 0.89 34706
Wellesley College 0.88 MA 9 0.88 0 0 2300 0 0 0.84 37419
Vassar College 0.87 NY 9 0.78 0 0 2472 1 0 0.81 37870
Haverford College 0.92 PA 8 0.9 0 0 1105 1 0 0.89 38928
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet3

6-year Grad. Rate State West South East Total Costs Republican State Football team Student/faculty Ratio Undergrad. Enrollment
California Institute of Technology 0.85 CA 1 0 32682 0 0 3 939
Rice University 0.89 TX 1 0 28350 1 1 5 2787
Williams College 0.94 MA 0 0 36550 0 1 8 1985
Swarthmore College 0.92 PA 0 0 38676 1 0 8 1479
Amherst College 0.94 MA 0 0 38492 0 1 9 1618
Webb Institute 0.83 NY 0 0 8079 1 1 7 67
Yale University 0.95 CT 0 0 38432 0 1 7 5339
Washington and Lee University 0.89 VA 0 1 30225 1 1 11 1750
Harvard University 0.97 MA 0 0 38831 0 1 8 6637
Stanford University 0.93 CA 1 0 38875 0 1 7 7360
Princeton University 0.97 NJ 0 0 40169 0 1 5 4779
Massachusetts Institute of Technology 0.91 MA 0 0 39213 0 1 6 4178
Pomona College 0.88 CA 1 0 38130 0 1 9 1551
Emory University 0.87 GA 0 1 37272 1 0 7 6302
Columbia University 0.93 NY 0 0 39493 1 1 7 4109
Duke University 0.93 NC 0 1 40080 1 1 11 6206
Davidson College 0.91 NC 0 1 34706 1 1 10 1645
Wellesley College 0.88 MA 0 0 37419 0 0 9 2300
Vassar College 0.87 NY 0 0 37870 1 0 9 2472
Haverford College 0.92 PA 0 0 38928 1 0 8 1105
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet4

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8985094613
R Square 0.807319252
Adjusted R Square 0.6949221491
Standard Error 0.0211200363
Observations 20
ANOVA
df SS MS F Significance F
Regression 7 0.0224273288 0.0032039041 7.1827407529 0.001627108
Residual 12 0.0053526712 0.0004460559
Total 19 0.02778
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.7694264783 0.037399937 20.5729351692 0.0000000001 0.6879390158 0.8509139407 0.6879390158 0.8509139407
West -0.0324817959 0.0133721228 -2.4290680165 0.0317866019 -0.0616171487 -0.0033464431 -0.0616171487 -0.0033464431
South East -0.0223152775 0.0164678937 -1.3550778203 0.20035267 -0.0581957357 0.0135651806 -0.0581957357 0.0135651806
Total Costs 0.000003492 0.0000009221 3.7869738942 0.0025904833 0.0000014829 0.0000055011 0.0000014829 0.0000055011
Republican State 0.0050589309 0.0129398072 0.3909587553 0.7026802342 -0.0231344869 0.0332523487 -0.0231344869 0.0332523487
Football team 0.0442552326 0.0124103327 3.5659988814 0.0038808196 0.0172154404 0.0712950247 0.0172154404 0.0712950247
Student/faculty Ratio -0.0018317178 0.0033926611 -0.5399059334 0.599138383 -0.0092236913 0.0055602556 -0.0092236913 0.0055602556
Undergrad. Enrollment 0.0000020839 0.0000029468 0.7071646151 0.4929690742 -0.0000043366 0.0000085044 -0.0000043366 0.0000085044
RESIDUAL OUTPUT
Observation Predicted 6-year Grad. Rate Residuals
1 0.8475315523 0.0024684477
2 0.8819059552 0.0080940448
3 0.9307967388 0.0092032612
4 0.8979699757 0.0220300243
5 0.9349816903 0.0050183097
6 0.8342700371 -0.0042700371
7 0.9461896697 0.0038103303
8 0.8854686826 0.0045313174
9 0.9484561139 0.0215438861
10 0.9194663182 0.0105336818
11 0.9547517304 0.0152482696
12 0.9483292653 -0.0383292653
13 0.9010961744 -0.0210961744
14 0.8826341425 -0.0126341425
15 0.9523904494 -0.0223904494
16 0.9291679654 0.0008320346
17 0.9027292095 0.0072707905
18 0.8884007468 -0.0084007468
19 0.8953929908 -0.0253929908
20 0.8980705919 0.0219294081

Sheet5

6-year Grad. Rate State West Total Costs Football team
California Institute of Technology 0.85 CA 1 32682 0
Rice University 0.89 TX 1 28350 1
Williams College 0.94 MA 0 36550 1
Swarthmore College 0.92 PA 0 38676 0
Amherst College 0.94 MA 0 38492 1
Webb Institute 0.83 NY 0 8079 1
Yale University 0.95 CT 0 38432 1
Washington and Lee University 0.89 VA 0 30225 1
Harvard University 0.97 MA 0 38831 1
Stanford University 0.93 CA 1 38875 1
Princeton University 0.97 NJ 0 40169 1
Massachusetts Institute of Technology 0.91 MA 0 39213 1
Pomona College 0.88 CA 1 38130 1
Emory University 0.87 GA 0 37272 0
Columbia University 0.93 NY 0 39493 1
Duke University 0.93 NC 0 40080 1
Davidson College 0.91 NC 0 34706 1
Wellesley College 0.88 MA 0 37419 0
Vassar College 0.87 NY 0 37870 0
Haverford College 0.92 PA 0 38928 0
binary varibales
categorical with 3 levels
independent variables
dependent variable

Sheet6

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8590077331
R Square 0.7378942855
Adjusted R Square 0.6887494641
Standard Error 0.0213326287
Observations 20
ANOVA
df SS MS F Significance F
Regression 3 0.0204987033 0.0068329011 15.0146905316 0.000065118
Residual 16 0.0072812967 0.000455081
Total 19 0.02778
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.7537956263 0.0271093071 27.805787313 0 0.6963264626 0.81126479 0.6963264626 0.81126479
West -0.0245104848 0.0119743159 -2.046921504 0.0574568751 -0.0498949006 0.000873931 -0.0498949006 0.000873931
Total Costs 0.0000036426 0.0000006853 5.3156851999 0.0000696391 0.0000021899 0.0000050952 0.0000021899 0.0000050952
Football team 0.0433498076 0.0105243748 4.1189912265 0.0008039005 0.0210391296 0.0656604856 0.0210391296 0.0656604856
significant variables
RESIDUAL OUTPUT
Observation Predicted 6-year Grad. Rate Residuals
1 0.8483317507 0.0016682493
2 0.8759019269 0.0140980731
3 0.93028152 0.00971848
4 0.8946758251 0.0253241749
5 0.937355399 0.002644601
6 0.8265737906 0.0034262094
7 0.9371368445 0.0128631555
8 0.9072422383 -0.0172422383
9 0.9385902316 0.0314097684
10 0.9142400201 0.0157599799
11 0.9434639959 0.0265360041
12 0.939981695 -0.029981695
13 0.9115263023 -0.0315263023
14 0.8895616509 -0.0195616509
15 0.9410016157 -0.0110016157
16 0.9431398068 -0.0131398068
17 0.9235646132 -0.0135646132
18 0.8900971093 -0.0100971093
19 0.8917399103 -0.0217399103
20 0.8955937538 0.0244062462