Week 7 Homework overviewThis week we'll be learning how to build a regression model with a...

Question

Week 7 Homework overviewThis week we'll be learning how to build a regression model with a classification (yes/no, 1/0) variable as our dependent variable. We will use a technique called "logistic regression".Building models in logistic regression is similar to linear regression. But deciding on a best model and interpreting the parameter estimates is quite different.As usual, you have a homework case. This week, we're back to Holmes University, working on a freshmen retention task force. We will build a model to predict whether students will return for their sophomore year, and consider how to use the model to decide which students will receive a costly intervention.Assigment week7We're back to Holmes University this week. We're on a freshmen retention task force, trying to identify freshmen who are likely to leave Holmes University, i.e. not return for their sophomore year.We've collected the following variables:· GPA: The student's GPA in their freshman yea· Athlete: =1 if the student is an athlete, =0 otherwise· Miles from home: Distance from campus to the student's home· College: College in which the student is enrolled: Education, Business, or Arts and Sciences· Accommodations: Home or Dorm· Work Hours: The number of hours the student said they worked at a job during the last week. They could either answer 0, 0-5, 5-10, 10-15, 15-20, or 20+; this has been coded with the midpoint of that range, or 22.5 for 20+. Not perfect, but it's the best we have.· Attends office hours: How often does the student say they go to office hours: Never, Sometimes, or Regularly· HS GPA: The student's high school GPA· Return: Dependent variable; =1 if the student returned, =0 if the student did not return.Your sample includes 500 students; of those, 395 return, and 105 do not.Week 7 Homework tasks1. Build a logistic regression model to predict which students will leaveeturn to Holmes University for their sophomore year.1. In addition to the variables given, consider polynomial and cross-product terms.1. Particularly, it looks like GPA, College, and Miles from home are important variables; a polynomial or cross-product involving those variables is useful.· Interpret the parameter estimates in your model, including numerical effects or graphical display of effects.1. What generally makes students more or less likely to leave Holmes University?· The retention task force plans to use your model to identify students who are likely to leave. It will place them in a program where they get access to additional services and possibly a small financial incentive to return. The cost of this program is $1,000 per student you identify as likely to leave. Every student who you coectly identify as likely to leave will now be more likely to return: coectly identifying a student as likely to leave gains $4,000 per student.1. What cutoff probability should you use to identify likely leavers?1. How much net benefit will this program give the university, based on the 500 students in your sample?Write your findings in a case report as usual.Report TemplateExecutive SummaryIn your executive summary, describe iefly what you did in your homework this week and what you found. You should include a short summary of the task you were asked to complete, describe how you analyzed the data, and what you found. You should also include any conclusionsecommendations that you generate.The purpose of an executive summary is to explain the main findings and conclusionsecommendations of your report/project. It should be able to be read completely apart from (and in place of, for readers who aren’t going to read) your full report.Your executive summaries in this class should be about XXXXXXXXXXwords, depending on how much you need to summarize. Your executive summary should be the last thing you write; how could you summarize your report if you hadn’t written your report yet?IntroductionIn this class, you can keep your introduction very short. What have you been asked to do? How are you going to go about performing the tasks you need to perform? One or two paragraphs is adequate.                DataDescribe your data. What data do you have? Where does it come from? Show and discuss appropriate summary statistics and/or graphs/plots of your data. Think of this as “supporting evidence” for the analysis you perform in the next section. Try not to spend more than about a page on this.AnalysisThis is the main section of your report. Describe how you analyze your data, including a short explanation of the statistical methods you use. You may include output from Excel or Enterprise Guide here; but any output needs to be discussed in the text. (If you want to include output that you will not discuss, you can place it in the appendix.)Try not to make this too “naative”, i.e. “I did this, then I did this…”. Instead, tell the story of the data: I performed statistical method X on the data in order to determine whether Y was true. The analysis shows evidence foagainst Y because…, etc.Conclusions/RecommendationsFinally, what did you discover? What did we learn from your analysis? How can your analysis inform the decisions that will be made?

Sourav · Accepted Answer

Data
	GPA	Athlete	Miles from home	College	Accommodations	Work hours	Attends office hours	HS GPA	Return
	2.6	1	17	Education	Home	0	Regularly	3.02	0
	3.2	0	21	Business	Home	17.5	Never	3.43	1
	2.7	0	39	Business	Dorm	12.5	Sometimes	3.32	1
	3.1	0	68	Education	Dorm	7.5	Never	3.56	1
	3.3	0	127	Education	Dorm	12.5	Never	3.48	1
	3.5	0	43	Education	Dorm	7.5	Never	3.72	1
	1.9	0	139	Business	Dorm	17.5	Never	2.85	0
	2.1	0	86	Education	Dorm	0	Never	3.13	1
	3.5	0	107	Education	Dorm	12.5	Never	3.13	1
	2.3	1	19	Business	Home	0	Never	3.02	1
	3.8	1	27	Education	Dorm	0	Never	3.58	1
	3.2	0	24	Business	Dorm	7.5	Never	3.29	1
	0.9	0	85	A&S	Dorm	7.5	Never	2.86	1
	3.4	0	12	Business	Dorm	0	Never	3.5	1
	4	1	36	Business	Dorm	12.5	Never	3.61	1
	3.7	0	34	A&S	Dorm	0	Regularly	3.34	1
	3.7	0	27	Education	Dorm	12.5	Sometimes	3.3	1
	2.7	1	55	A&S	Dorm	0	Never	3.13	1
	3.2	1	29	A&S	Dorm	0	Never	3.24	1
	3.2	0	124	A&S	Dorm	7.5	Regularly	3.12	0
	3	1	163	A&S	Dorm	0	Never	3.63	1
	3.1	0	50	A&S	Dorm	0	Never	3.34	1
	2.4	0	26	A&S	Dorm	0	Never	3.28	1
	3.4	1	12	A&S	Home	0	Never	3.77	1
	2.7	0	3	A&S	Home	0	Never	3.18	1
	2.6	1	157	A&S	Dorm	12.5	Never	3.12	1
	3.9	0	103	Education	Dorm	0	Never	3.6	1
	2.5	0	42	Education	Dorm	0	Never	2.94	0
	3.7	0	39	A&S	Dorm	0	Never	3.38	1
	2.8	0	119	A&S	Dorm	2.5	Never	3.01	1
	3.7	0	38	Business	Dorm	0	Sometimes	3.58	1
	4	0	24	Business	Dorm	12.5	Never	3.5	1
	2.2	1	23	A&S	Dorm	12.5	Regularly	3.17	1
	3.7	1	24	A&S	Home	0	Never	3.18	1
	3.9	0	23	Education	Dorm	0	Regularly	3.78	0
	2	0	59	A&S	Dorm	17.5	Never	3.13	1
	2.8	1	49	A&S	Dorm	17.5	Regularly	3.26	1
	3.6	0	79	A&S	Dorm	17.5	Sometimes	3.4	0
	3.6	0	46	Business	Dorm	17.5	Never	3.41	1
	3.9	0	32	Business	Dorm	7.5	Never	3.35	1
	0	0	40	Business	Dorm	0	Never	2.1	0
	3.9	0	55	Education	Dorm	7.5	Never	3.61	1
	3.9	0	23	A&S	Home	0	Sometimes	3.42	1
	3.8	0	128	A&S	Dorm	22.5	Sometimes	3.8	1
	3.3	1	163	A&S	Dorm	0	Never	3.49	1
	3.4	1	160	Business	Dorm	12.5	Never	3.36	1
	2.3	0	34	Education	Dorm	0	Never	3.35	1
	3	0	0	Education	Dorm	7.5	Never	3.32	0
	2.6	0	76	Education	Dorm	0	Never	2.7	1
	4	1	64	A&S	Dorm	0	Never	3.77	1
	2.3	1	81	A&S	Dorm	17.5	Never	3.25	1
	3.1	0	27	Business	Dorm	0	Never	3	1
	4	0	34	A&S	Dorm	0	Never	3.81	1
	3.3	1	10	A&S	Dorm	7.5	Never	3.46	1
	3.3	0	34	Education	Dorm	17.5	Never	3.24	1
	4	0	11	A&S	Home	0	Never	3.52	1
	0	0	42	A&S	Dorm	0	Never	2.38	0
	4	1	5	A&S	Home	22.5	Regularly	3.82	1
	3.7	0	57	A&S	Dorm	17.5	Never	3.7	1
	3.4	0	11	Business	Home	12.5	Never	3.18	1
	3.3	0	36	Education	Dorm	0	Never	3.28	1
	1	1	110	A&S	Dorm	0	Never	2.8	1
	1.6	0	16	A&S	Home	0	Never	2.64	1
	3.9	1	86	A&S	Dorm	0	Never	3.3	1
	2.4	0	52	A&S	Dorm	7.5	Never	3.03	1
	3.3	0	39	Business	Dorm	2.5	Sometimes	3.69	1
	0	1	111	A&S	Dorm	0	Never	2.51	0
	3	0	140	A&S	Dorm	17.5	Never	3.03	1
	2.3	0	17	A&S	Dorm	0	Sometimes	2.99	1
	2.9	0	25	Education	Dorm	0	Never	3.44	1
	2.9	0	63	A&S	Dorm	0	Never	3.5	1
	3.8	0	108	A&S	Dorm	0	Never	3.39	1
	2.4	1	51	A&S	Dorm	0	Never	3.14	1
	2.3	0	42	Business	Dorm	7.5	Never	2.94	1
	3	0	122	Education	Dorm	12.5	Regularly	3.38	1
	4	0	175	Education	Dorm	0	Sometimes	3.68	0
	3.1	0	0	A&S	Dorm	7.5	Never	3.3	0
	0.5	0	36	Education	Dorm	0	Sometimes	2.4	0
	3.3	1	14	Business	Dorm	12.5	Sometimes	3.7	1
	2.9	0	13	Business	Dorm	12.5	Never	2.98	0
	3.3	0	20	Business	Home	0	Never	2.91	0
	3.1	0	52	Education	Dorm	12.5	Never	3.13	1
	3.4	0	45	A&S	Dorm	0	Never	3.52	1
	3.7	0	127	Business	Dorm	2.5	Sometimes	3.33	1
	2.2	0	203	Education	Dorm	17.5	Regularly	2.88	0
	2.3	1	136	Business	Dorm	2.5	Never	3.32	0
	3.7	0	110	A&S	Dorm	12.5	Never	3.52	1
	1.8	1	29	Business	Dorm	2.5	Sometimes	3.09	1
	1.6	1	183	A&S	Dorm	0	Never	2.93	1
	0.3	1	65	Education	Dorm	17.5	Regularly	2.3	0
	3.2	0	9	Education	Home	0	Sometimes	3.24	1
	2.7	0	111	Business	Dorm	12.5	Never	3.17	1
	4	0	21	Business	Home	17.5	Never	3.6	1
	3.3	0	45	Business	Dorm	0	Regularly	3.7	0
	2.7	0	185	A&S	Dorm	0	Never	3.02	1
	3.1	0	22	A&S	Home	12.5	Regularly	3.35	1
	3.1	0	150	Business	Dorm	17.5	Never	3.27	0
	2.6	0	129	A&S	Dorm	0	Never	3.06	1
	2.6	0	136	Business	Dorm	7.5	Never	3.25	1
	1.2	0	107	A&S	Dorm	7.5	Sometimes	2.61	0
	3.2	0	10	A&S	Home	17.5	Sometimes	3.67	1
	2.9	0	50	Business	Dorm	2.5	Sometimes	3.48	1
	1.9	0	105	Education	Dorm	7.5	Sometimes	3.11	0
	2.9	0	122	A&S	Dorm	0	Sometimes	3.17	1
	3.2	0	21	Business	Dorm	7.5	Sometimes	3.54	1
	2.8	0	30	Education	Dorm	17.5	Sometimes	3.31	0
	3.4	0	22	Education	Home	0	Sometimes	3.72	1
	3	1	13	Education	Home	0	Never	3.22	1
	2.7	0	149	A&S	Dorm	12.5	Never	3.24	1
	0.3	1	45	A&S	Dorm	7.5	Sometimes	2.34	1
	3	0	34	A&S	Dorm	12.5	Never	3.39	1
	3.4	0	42	A&S	Dorm	0	Never	3.29	0
	4	0	36	A&S	Dorm	12.5	Regularly	3.66	1
	3	1	39	Education	Dorm	0	Never	3	1
	3	1	40	Business	Dorm	7.5	Never	3.38	1
	1.6	0	120	A&S	Dorm	0	Regularly	2.9	0
	2.4	0	43	Education	Dorm	0	Regularly	2.97	0
	2.9	1	136	A&S	Dorm	12.5	Regularly	3.41	1
	0.6	0	162	A&S	Dorm	0	Regularly	2.66	0
	1.7	0	0	Education	Home	0	Sometimes	3.2	0
	3.1	0	20	A&S	Dorm	0	Never	3.31	1
	2.4	0	133	A&S	Dorm	0	Never	2.98	1
	3	0	131	Education	Dorm	0	Never	3.05	1
	3.2	0	10	A&S	Home	0	Never	3.22	1
	2.9	0	34	Education	Dorm	7.5	Never	3	1
	2	1	44	Business	Dorm	17.5	Never	3.12	1
	3.6	0	46	A&S	Dorm	0	Never	3.62	1
	3.4	1	42	A&S	Dorm	2.5	Sometimes	3.47	1
	3.4	1	114	Business	Dorm	0	Never	3.35	1
	1.6	0	13	A&S	Home	17.5	Regularly	2.9	0
	2.6	0	0	Business	Home	17.5	Never	3.12	1
	3.6	0	0	A&S	Dorm	7.5	Never	3.48	1
	1.9	1	43	Business	Dorm	7.5	Sometimes	2.65	1
	1.9	0	1	A&S	Home	0	Regularly	3.35	1
	2.2	1	39	A&S	Dorm	0	Never	3.05	1
	3.9	0	0	A&S	Home	12.5	Sometimes	3.59	1
	3.4	0	13	A&S	Home	0	Sometimes	3.32	1
	3.2	0	115	A&S	Dorm	0	Never	3.63	1
	1.9	0	47	Education	Dorm	22.5	Never	3.38	0
	2.3	0	146	Education	Dorm	0	Regularly	2.87	0
	0	0	51	A&S	Dorm	17.5	Never	2.22	0
	2.9	0	38	Education	Dorm	7.5	Never	3.25	1
	3.5	0	117	A&S	Dorm	0	Never	3.29	1
	4	0	120	Business	Dorm	0	Never	3.52	1
	2.7	1	22	Business	Home	0	Sometimes	3.09	1
	1.6	0	41	Education	Dorm	7.5	Never	2.71	1
	0	0	29	Business	Dorm	12.5	Never	2.11	0
	2.9	0	53	Business	Dorm	17.5	Sometimes	3.09	1
	2.8	0	51	A&S	Dorm	0	Sometimes	3.37	1
	3.6	0	28	Business	Dorm	0	Never	3.26	1
	3.7	0	175	A&S	Dorm	7.5	Never	3.29	0
	2.9	1	28	Business	Dorm	12.5	Never	3.19	1
	3.7	1	153	A&S	Dorm	0	Regularly	3.68	1
	2.6	1	78	Education	Dorm	0	Sometimes	3.05	0
	4	0	55	A&S	Dorm	12.5	Never	3.39	1
	3.7	1	19	A&S	Home	0	Never	3.54	1
	1.7	0	55	Education	Dorm	0	Never	3.12	1
	2.4	0	123	A&S	Dorm	22.5	Never	2.97	1
	3.7	1	47	Education	Dorm	0	Regularly	3.

Week 7 Homework overview This week we'll be learning how to build a regression model with a classification (yes/no, 1/0) variable as our dependent variable. We will use a technique called "logistic...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment