Each row of the spreadsheet (Figure 1) corresponds to a single sample. The first column is the names of the .idat files and the remaining columns are the array probes. The table values are β-values, which correspond to the percentage methylation at each site. A β-value is calculated as the ratio of methylated probe intensity over the overall intensity at each site (the overall intensity is the sum of methylated and unmethylated probe intensities). 

An alternative metric for measurement of methlyation levels are M-values. β-values can be easily converted to M-values using the following equation:

M-value = log2( β / (1 - β))

An M-value close to 0 for a CpG site indicates a similar intensity between the methylated and unmethylated probes, which means the CpG site is about half-methylated. Positive M-values mean that more molecules are methylated than unmethylated, while negative M-values mean that more molecules are unmethylated than methylated.  As discussed by Du and colleagues, the β-value has a more intuitive biological interpretation, but the M-value is more statistically valid for the differential analysis of methylation levels.

Because we are performing differential methylation analysis, we need to convert our data to from β-values to M-values.

• Select Convert Beta Value to M Value from the Import section of the Illumina BeadArray Methylation workflow

The original data (β-values) will be overwritten.

• Select () from the icon bar to save the current spreadsheet 

Before we can perform any analysis, the study samples need to be organized into their experimental groups.

• Select Add Sample Attributes from the Import section of the Illumina BeadArray Methylation workflow
• Select Add a Categorical Attribute from the Add Sample Attributes dialog (Figure 2)
  
  

• Select OK

The Create categorical attribute dialog allows us to create groups for a categorical attribute. By default, two groups are created, but additional groups can be added. 

• Set Attribute name: to Experimental Group
  
• Select New Group twice to add two additional groups
• Rename the groups Primed+shCTRL, Naive+shCTRL, Naive+shPOU5F1, and Naive+shNANOG
• Drag and drop the samples from the Unassigned list to their groups as listed in the table below

There should now be four groups with two samples in each group (Figure 4).

• Select OK
• Select No from the Add another categorical attribute dialog
• Select Yes to save the spreadsheet

A new column s been added to spreadsheet 1 (Differential Methylation Analysis) with the state and shRNA treatment of each sample (Figure 6).