Teaching Week 11
Seminar 8 Regression and Forecasting
Learning Objectives of the Seminar Achieved through
1. Practice Data Analysis Tool –
Regression;
2. Enhance understanding on linear
relationship and use of scatter graph;
3. Develop analytical thinking: how to
explain R square in OLS regression;
Completion of the seminar tasks
Completion of the seminar tasks
During the process of interpretation of
results
4. Develop competencies in workplace Peer discussion; ask questions to tutor and
completion of the task. Regression and
forecasting are powerful techniques to
help solve business problems.
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).
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?
1
AssignmentTutorOnline