I have to columns of data. One has the number of claims for a member. The other has the number of months the member is enrolled.
i am trying to calculate the variance to see if there is a correlation between the two. Does anyone have any idea how I would dot this in Excel.
Using ColumnA as number of claims
ColumnB as number of months enrolled