If I have a list of peoples hair colour and grades, can I check for the correlation with excel? How?

You can check for correlation using

a. the Analysis Toolpak add-in in Excel to quickly generate correlation coefficients between hair colors and grade; using the following steps.

1. On the Data tab, in the Analysis group, click Data Analysis.

Click Data Analysis

2. Select Correlation and click OK.

Select Correlation

3. select the range of cells that occupies the hair color and grade as the Input Range.

Select the Input Range

4. Check Labels in first row.

5. Select cell A8 as the Output Range.

6. Click OK.

Input and Output Options

Result.

Correlation Coefficients