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?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Topic Video
Question
100%
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?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Means
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman