As mentioned in the title I have an unbalanced repeated measures data set and would like to calculate the correlation of a particular stat with win percentage. The data set is of player performances where players may have repeated observations and the number of times a player can appear is not set. I have done some research and found that using a mixed effect linear model is the best way to go about this, which will control for the impact of the player,
My main goal is to calculate the correlation between the 'Statistic' and Win%, do the results of this test give me some advice on what type of correlation test to use? Does this test tell me how significant the different player groups are? If they aren't significant am I then able to use a pearson correlation on the data set?
This is an example of my data, 3 columns
Any help is greatly appreciated.