I am using SPSS 25. I want to predict the probability of a binary outcome (DV): pass or fail a test at the end of “this” school year. My independent variables are
- Test status (pass/fail) at the end of “last” school year as a baseline measure
- Course grades or Grade Point Average (A=4, B=3...F=0) for “this” school year. This is a repeated measure where we have three observations prior to the outcome event
- Attendance data (number of days missed), which can be represented as a simple scaled variable (0-180) or as a percentage of days missed out of total days
- Demographic characteristics (e.g., age, ethnicity, gender)
I have already used logistic regression to establish the probability of passing given the baseline event (pass/fail “last” school year) and the first and/or second observation of course grades. The challenges I am still facing are how to include multiple IVs (such as attendance Or the third observation of course grades) when the IVs are highly correlated with each other. Right now I’m using SPSS and logistic regression, with pass/fail “this” year as the dependent variable, and then pass/fail “last” year in step 1. Then I add other IVs in subsequent steps as they occur (i.e., the first course grade in Step 2, the second course grade in Step 3).
On top of all this, my data are FLAT right now (e.g., all data for one student in one row). I might be able to build a stacked file for the analysis, but I cannot seem to think through how I deal with the baseline event And multiple IVs with different weights that happen at different times.
My ultimate goal is to be able to impose a formula onto my flat file that can be updated as new data get added or updated over time. Even if I have to do all the analyses using a repeated observations model and a stacked dataset, my users are viewing charts and reports based on the flat file - so that is where I need to have some sort of formula that can “feed” off data in the flat file as it gets updated.
Example: imagine the P of passing Your math test “this” year if you failed “last” year is .17. But if you begin “this” year and get an A in your math claSS, the probability changes from .17 to .42. On the other hand, if you failed the math test “last” year and you earn a C in your math class at the start of “this” year, the probability remains at .17. So I ultimately need an equation where new binary events (e.g., A in math = 1, else 0) can change the probability that is calculated in the flat file.
Man, I hope this makes sense to someone.