Find correlation between names and score
I'm new to data mining as well as rapidminer and hope you can help me with my task
First some details about my (input data)
I've got an excel table with the following structure:
The id is a unique number, the name columns explain if the name_i occures in the data (1) or not (0) (the label of the column is the name of the person) and the corresponding score of the document. as you can see the excel file looks like a vektor.
My goal is to find a correlation between names (nominal attribute) and a score (numeric). So if the score of the document is potentialy higher if name_0 or name_1 (or name_i) occures in the coument.
When searching in rapidminer for "correlation", the correlation matrix appears but I'm not sure if it is the right tool to work with on this task.
Do you have any clue if there are practices to handle this task correctly?
Thank you very much