My updated data set can (hopefully) be found here. It contains all the data I used, most of it summarized on sheet 1, titled "All IL Public." All the data is from 2012. Illinois Transfer information is from the university and can be found on their website under 2012. Driving distances were found using Google Maps. Overall college data was found using College Measures. As a note, Google uses slightly different formulas, so variance and standard deviation do not show up. If you want the original copy, please comment.
I have decided to broaden my focus away from Engineering Pathways specifically and towards Illinois Community College Students overall. I want to see what makes them successful individually and specifically at getting students transferred into UIUC. My plan is to upload this data into Stata, which will hopefully make analysis easier. I will let you know how this turns out in latter posts.
There should be an option for you to upload the Excel file without converting it. At least there used to be that option.
ReplyDeleteBefore doing an analysis, you might spend some time on defining the variables so you understand what they mean. For example, you have a variable called Graduate Plus Transfer. But there is no time horizon given. Graduation rates at 4-year institutions are given by the number of years out. The NCAA typically reports 6-year graduate rates, if memory serves. What is it here? If a student hasn't graduated or transferred, has the student dropped out? Or might the student still be matriculating?
There are similar issues with the cost variables. I recommend that you spend some time working on a document that is called Variable Definition, that explains these things as best as you can.