All parts of this Problem must be done in Excel.Be sure to use Excel thanks

Over the past few years the percentage of students who leave Lakeland College at the end of the first

year has increased. Last year Lakeland started a voluntary one-week orientation program to help first

year students adjust to campus life. If Lakeland is able to show that the orientation program has a

positive effect on retention, they will consider making the program a requirement for all first-year

students. Lakeland's administration also suspects that students with lower GPAs have a higher

probability of leaving Lakeland at the end of the first year. In order to investigate the relation of these

variables to retention, Lakeland selected a random sample of 100 students from last year's entering

class. The data are contained in the data set named Lakeland. The dependent variable was coded as

y=1 if the student returned to Lakeland for the sophomore year and y=0 if not. The two independent

variables are:

21 = GPA at the end of the first semester 0 if the student did not attend the orientation program 1 if the student attended the orientation program