BIOL368/F14:Chloe Jones Week 13: Difference between revisions
From OpenWetWare
Jump to navigationJump to search
(note to start from sheet SAR only) |
(→Calculating fold change: instructions for taking log2) |
||
| Line 4: | Line 4: | ||
*<u>Step. 1</u> Rename the columns with the item isolated, biological replicate, and dye used. For each array data file there will be 2 columns: signal and background. | *<u>Step. 1</u> Rename the columns with the item isolated, biological replicate, and dye used. For each array data file there will be 2 columns: signal and background. | ||
*<u>Step. 2</u> Minus the background from the signal for each data file. Then take the answers from each replicate and divide it by its corresponding dye (i.e. Cy5 Ranalexin(B1)/Cy3 MRSA252 (B1)). NOw, the fold change is calculated. | *<u>Step. 2</u> Minus the background from the signal for each data file. Then take the answers from each replicate and divide it by its corresponding dye (i.e. Cy5 Ranalexin(B1)/Cy3 MRSA252 (B1)). NOw, the fold change is calculated. | ||
* Step 3. Take the log2 of each fold change. | |||
=LOG(number, base) | |||
for example, =LOG(A1,2) takes the log2 of the number in cell A1. | |||
Revision as of 16:01, 19 November 2014
Calculating fold change
- Here is the Overton_MicroarrayData_20141119.xlsx used for this analysis of MRSA with Ranalexin.
- Start from the sheet called "SAR_only"
- Step. 1 Rename the columns with the item isolated, biological replicate, and dye used. For each array data file there will be 2 columns: signal and background.
- Step. 2 Minus the background from the signal for each data file. Then take the answers from each replicate and divide it by its corresponding dye (i.e. Cy5 Ranalexin(B1)/Cy3 MRSA252 (B1)). NOw, the fold change is calculated.
- Step 3. Take the log2 of each fold change.
=LOG(number, base) for example, =LOG(A1,2) takes the log2 of the number in cell A1.
