The Manga Guide to Statistics

206 Aendix

Step 3

Select cells B1 and B2, and then click OK.

Step 4

Now you’re done.

7. Calculating the Correlation Coefficient

This data comes from the P-Girls Magazine survey found on page 116.

Step 1

Select cell B14.

Let's Calculate Using Excel 207

Step 2

Select InsertFunction, then select Statistical, and then select CORREL.

Step 3

Select the area shown in the figure below, and then click OK.

Step 4

Now you have the correlation coefficient.

Note Unfortunately, there are no Excel functions for calculating the correlation ratio or the

Cramer’s coefficient.