#* The following command was entered into cell J6: <code>=(B6-B$4)/B$5</code>. This takes the first log ratio for sample Biofilm_1, subtracts the average log ratio, and divides by the standard deviation of the log ratios. This function was then pasted for the remaining data, using the drag feature. The placement of the <code>$</code>'s ensures that the cell references for the averages and standard deviations ''will'' change horizontally (to account for different averages/stdev's between samples), but ''will not'' change vertically. | #* The following command was entered into cell J6: <code>=(B6-B$4)/B$5</code>. This takes the first log ratio for sample Biofilm_1, subtracts the average log ratio, and divides by the standard deviation of the log ratios. This function was then pasted for the remaining data, using the drag feature. The placement of the <code>$</code>'s ensures that the cell references for the averages and standard deviations ''will'' change horizontally (to account for different averages/stdev's between samples), but ''will not'' change vertically. |