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. 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

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

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.
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