College RR(%) GR(%) Western International University 7 25 South University 51 25 University of Phoenix 4 28 American InterContinental University 29 32 Franklin University 33 33 DeVry University 47 33 Tiffin University 63 34 Post University 45 36 Peirce College 60 36 Everest University 62 36 Upper Iowa University 67 36 Dickinson State University 65 37 Western Governors University 78 37 Kaplan University 75 38 Salem International University 54 39 Ashford University 45 41 ITT Technical Institute 38 44 Berkeley College 51 45 Grand Canyon University 69 46 Nova Southeastern University 60 47 Westwood College 37 48 Everglades University 63 50 Liberty University 73 51 LeTourneau University 78 52 Rasmussen College 48 53 Keiser University 95 55 Herzing College 68 56 National University 100 57 Florida National College 100 61 Case Study One of the biggest changes in higher education in recent years has been the growth of online universities. The Online Education Database is an independent organization whose mission is to build a comprehensive list of the top accredited online colleges. The following table shows the retention rate (%) and the graduation rate (%) for 29 online colleges (Online Education Database website, January 2009). The data set available at the beginning of the page. a. Use Excel Data Analysis Tool – Regression to get the relationship between the two variables; b. Create a scatter diagram for the two variables and display regression equation and R square on chart, then explain the relationship between the variables; c. Did the estimated regression equation provide a good fit? d. Suppose you were the president of South University. After reviewing the results, would you be able to use the regression result for forecasting?
College | RR(%) | GR(%) |
Western International University | 7 | 25 |
South University | 51 | 25 |
University of Phoenix | 4 | 28 |
American InterContinental University | 29 | 32 |
Franklin University | 33 | 33 |
DeVry University | 47 | 33 |
Tiffin University | 63 | 34 |
Post University | 45 | 36 |
Peirce College | 60 | 36 |
Everest University | 62 | 36 |
Upper Iowa University | 67 | 36 |
Dickinson State University | 65 | 37 |
Western Governors University | 78 | 37 |
Kaplan University | 75 | 38 |
Salem International University | 54 | 39 |
Ashford University | 45 | 41 |
ITT Technical Institute | 38 | 44 |
Berkeley College | 51 | 45 |
Grand Canyon University | 69 | 46 |
Nova Southeastern University | 60 | 47 |
Westwood College | 37 | 48 |
Everglades University | 63 | 50 |
Liberty University | 73 | 51 |
LeTourneau University | 78 | 52 |
Rasmussen College | 48 | 53 |
Keiser University | 95 | 55 |
Herzing College | 68 | 56 |
National University | 100 | 57 |
Florida National College | 100 | 61 |
Case Study
One of the biggest changes in higher education in recent years has been the
growth of online universities. The Online Education Database is an independent
organization whose mission is to build a comprehensive list of the top accredited
online colleges. The following table shows the retention rate (%) and the
graduation rate (%) for 29 online colleges (Online Education Database website,
January 2009). The data set available at the beginning of the page.
a. Use Excel Data Analysis Tool – Regression to get the relationship between
the two variables;
b. Create a
equation and R square on chart, then explain the relationship between the
variables;
c. Did the estimated regression equation provide a good fit?
d. Suppose you were the president of South University. After reviewing the
results, would you be able to use the regression result for forecasting?
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images