Question

1.)The graduation rate of college students is a subject of considerable interest and is a frequent topic in the news. College/university administrators use the graduation rate as a barometer of student success at their respective institution. State legislators are interested in the graduation rate since most states subsidize the cost of educating each in-state student at public universities and colleges.

Graduation rates are also used to evaluate university athletic programs. Athletic directors do not relish the negative publicity that results when the graduation rate of athletes is significantly lower than that of the general student body.

This Excel file graduation rates shows recent 6-year graduation rates for athletes and the general student body at 26 universities. The institutions included are all ACC schools, NCSU peer-designated institutions, and two of the larger schools in the UNC system - ECU and UNC-Charlotte.

Question. Use the data in the Excel file to find the quartiles and the median of the general student body graduation rates and the athlete graduation rates

_______ % Q₁, first quartile for general student body graduation rate
_______ % Q₁, first quartile for athlete graduation rate

_______ % median, general student body graduation rate
________ % median, athlete graduation rate

________ % Q₃, third quartile for general student body graduation rate
________ % Q₃, third quartile for athlete graduation rate

		6-year Graduation Rate
	Status	All students	athletes
Duke	Private	95%	87%
UNC-CH	Public	86%	74%
NCSU	Public	71%	51%
Wake	Private	88%	80%
ECU	Public	54%	58%
UNC-C	Public	51%	59%
BC	Private	91%	90%
Clemson	Public	79%	66%
FSU	Public	70%	53%
Ga Tech	Public	77%	56%
U-MD	Public	82%	66%
Miami	Private	77%	70%
UVA	Public	93%	73%
Va Tech	Public	78%	72%
UC-Davis (D-II)	Public	81%	81%
Florida	Public	82%	61%
UGA	Public	79%	59%
Illinois	Public	82%	70%
Iowa St	Public	67%	79%
Michigan St	Public	75%	66%
Minnesota	Public	66%	71%
Ohio State	Public	73%	67%
Penn State	Public	85%	76%
Purd	Public	72%	66%
Texas A&M	Public	78%	61%
Wisconsin	Public	81%	59%

Answer 1

	All students	Athletes
Q1=	72.25	59.5
Q2=Median=	78.5	66.5
Q3=	82	73.75

Use "=QUARTILE(G4:G29,1)" for Q1; "=QUARTILE(G4:G29,2)" for median, "=QUARTILE(G4:G29,3)" for Q3.

72.25 % Q₁, first quartile for general student body graduation rate
59.5 % Q₁, first quartile for athlete graduation rate

78.5 % median, general student body graduation rate
66.5 % median, athlete graduation rate

82 % Q₃, third quartile for general student body graduation rate
73.75 % Q₃, third quartile for athlete graduation rate