This Excel file (https://www.webassign.net/userimages/recent%20NCAA%20tourn%20gr

Question

This Excel file (https://www.webassign.net/userimages/recent%20NCAA%20tourn%20grad%20rates.xls?db=v4net&id=330708) DI Basketball Graduation Rates shows the graduation rates for the men's and women's basketball teams that participated in recent NCAA division I men's and women's basketball tournaments. There are data for 67 men's teams and 63 women's teams since Princeton had teams in both tournaments but does not report graduation rates.

Use the data to calculate a 90% confidence interval for ?M - ?F, the difference in the mean graduation rates for all division I men's and women's basketball teams. Do not waste time entering this data into a graphing calculator! Use Excel or Statcrunch! Use 2 decimal places in your answers.

_______ lower bound of confidence interval
_______ upper bound of confidence interval

Select the choice below that correctly interprets the confidence interval.

A) Since the interval is entirely negative, it appears that the DI women's basketball mean graduation rate is higher than the DI men's basketball mean graduation rate.

B) Since the interval is entirely negative, it appears that the DI men's basketball mean graduation rate is higher than the DI women's basketball mean graduation rate.    

C) Since the interval contains zero we can conclude that both graduation rates are too low.

D) Since the interval is entirely positive it appears that both men's and women's mean basketball graduation rates are higher than the graduation rate for the general student body.

E) Since the interval is entirely negative, it appears that their is no significant difference between the DI women's basketball mean graduation rate and the DI men's basketball mean graduation rate.

Explanation / Answer

SOl:

Get the descriptive statistics in excel :

90% confidence inteval for diff in means

=(66.253-86.746)+-1.657sqrt(454.98/67+263.257/63)

=-20.923+-5.488

=-20.923-5.488,-20.923+5.488

=-25.9803,-15.0043

lower limit=-25.9803,

upper limit=-15.0043

OPTION E

E) Since the interval is entirely negative, it appears that their is no significant difference between the DI women's basketball mean graduation rate and the DI men's basketball mean graduation rate.

Men GraduationRate Women Graduation Rate Mean 66.25373134 Mean 86.74603 Standard Error 2.605906321 Standard Error 2.044183 Median 67 Median 92 Mode 100 Mode 100 Standard Deviation 21.33026253 Standard Deviation 16.2252 Sample Variance 454.9800995 Sample Variance 263.257 Kurtosis -0.890189591 Kurtosis 7.034618 Skewness -0.104019593 Skewness -2.14685 Range 80 Range 90 Minimum 20 Minimum 10 Maximum 100 Maximum 100 Sum 4439 Sum 5465 Count 67 Count 63

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.