Academic success of a school's football players

Solve those problems I mark red color， Using excel files solve question. Two excel files. Look the files name to see which question use which excel file. he Federal Graduation Rate (FGR) for a college/university is the percentage of the school's admitted freshmen that graduate from that school within 6 years. A school's FGR is calculated for all students, for all athletes, and for athletes in individual sports. The FGR is especially useful in the athletic context because it enables comparison of the academic success of athletes with the academic success of other students on campus. Evaluation of the academic success of a school's football players frequently focuses on the difference, or gap between the FGR of the student body and the FGR of the football players, calculated as gap = student body FGR−football player FGR. A large positive value for a school's gap means that the FGR of the football players is much less than the FGR of the student body. This Excel file Federal Graduation Rates shows the FGRs for 12 ACC schools and 14 SEC schools. Shown are the FGRs for football players at each school for the years 2009, 2010, 2011, and 2012, in addition to each school's football mean FGR and overall student body mean FGR over these 4 years. The mean of the 2009, 2010, 2011, and 2012 end-of-season Sagarin Ratings of each team is included in the above file as a measure of each school's football success. The Sagarin Ratings, developed by Jeff Sagarin, apply a proprietary statistical technique to evaluate each team by taking into account several factors such as strength of schedule, strength of opponent schedules, win/loss records, wins on the road and other variables. The Sagarin ratings were obtained from USA Today, which has been publishing them since 1985. Question 1. Make a scatterplot of the results for the 26 schools using the "Sagarin mean" as the x-variable and the "gap: all-student FGR minus football FGR" as the y-variable. Which school corresponds to the outlier in the lower right corner? University of Alabama Correct: Your answer is correct. Question 2. With the data for the school in question 1 removed, find the slope b1 and intercept b0 of the least squares prediction line y hat = b0 + b1x, where x is the Sagarin mean and y is the gap: all-student FGR minus football FGR. 0.2987 Correct: Your answer is correct. slope b1 (use 4 decimal places in your answer). -4.2797 Correct: Your answer is correct. intercept b0 (use 4 decimal places in your answer) Question 3a. Use the least squares prediction line y hat = b0 + b1x from Question 2 to predict the gap for the university in Question 1. 25.45 Correct: Your answer is correct. predicted gap (use 2 decimal places in your answer) Question 3b. What is the residual y−y hat for the university in Question 1? -19.95 Correct: Your answer is correct. residual Question 4. Construct a 99% prediction interval for the gap at the school in Question 1. _________lower bound of prediction interval (use 3 decimal places). _________upper bound of prediction interval (use 3 decimal places). Three percent of a man's body is essential fat; for a woman the percentage is closer to 12.5%. As the name implies, essential fat is necessary for a normal healthy body. Fat is stored in small amounts throughout the body. Too much fat, however, can be dangerous to your health. For men between 18 and 39 years old, a healthy percent of body fat ranges from 8% to 19%; for women of the same age, it's 21% to 32%. Measuring body fat can be tedious and expensive. The "standard reference" measurement is by dual-eneregy X-ray absorptiometry (DEXA), which involves two low-dose X-ray generators and takes from 10 to 20 minutes. Because of the time and expense involved with the DEXA method, health professionals would like to be able to make a useable prediction of body fat from easily measurable variables such as weight or waist size.This Excel file shows the waist size (inches), weight (pounds) and percent body fat for 20 individuals. Question 1. What is the slope of the least squares regression line of %body fat on waist size? 2.2215 Correct: Your answer is correct. (use 4 decimal places). Question 2. Find sb1, the estimate of the standard deviation σb1 of the least squares slope b1 (use 4 decimal places). 0.27279 Correct: Your answer is correct. sb1, estimate of σb1 Question 3. Determine the 99% confidence interval for the slope of the least squares regression line of %body fat on waist size. 1.4363 Correct: Your answer is correct. lower bound 3.0067 Correct: Your answer is correct. upper bound Question 4. Determine a 99% confidence interval for the mean %body fat found in people with 40-inch waists (use 2 decimal places). lower bound upper bound Question 5. Determine a 99% prediction interval for the %body fat of an individual with a 40-inch waist (use 2 decimal places). lower bound upper bound                                                                                                                                                                                                                                                          

Sample Solution