I got a dataset in Excel with 2 dummy variables: trained(1 or 0), part-time(1 or 0). The question asks if whether there is a relationship between those who have been trained and whether they are part-time rather than permanent employees? It also says that it requires a formal test in terms of whether employment type and "trained" are independent variables.
So, I filter the column "trained" to have individuals with "1" only Then, I run a regression analysis to see if the coefficients are significant
Do I also need to filter for the part-time column before running the regression?
I am not sure if that is the correct way to answer this question? Or it is trying to ask me to do the test based on the probability function? P(A)*P(B)=P(A&B). If so, how can I handle this in Excel?
I'd really appreciate any help