I collected a lot of trapping data of a certain rodent species. I constructed a model to see what affects the individual's activity. I constructed this LM (linear model):
Activity ~ Sex+Weight+Exploration+Totaltimestrapped
But this dataset has all the individuals in it. I want to know whether weight, for example, weight is correlated with activity within males, females, adult males, adult females, juvenile males and juvenile females. I therefore subsetted the dataset into one with only males in it, only females, etc. And ran the same model again in all these different datasets (without sex of course).
An interaction between sex and weight is not what I want, because I don’t want to know if heavier males are more active than heavier females. I just want to know if weight is significantly correlated with activity within males or females etc.
This means that I ran a lot of LMs which is not correct. Is there a way to construct a model that reduces the subsetting of the dataset?