Troque Week 8

User Page        Bio Databases Main Page       

Normalize the log ratios for the set of slides in the experiment

To scale and center the data (between chip normalization) I performed the following operations:

• Insert a new Worksheet into my Excel file, and named it "scaled_centered".
• Go back to the "compiled_raw_data" worksheet, Select All and Copy. I went to my new "scaled_centered" worksheet, click on the upper, left-hand cell (cell A1) and Paste.
• Insert two rows in between the top row of headers and the first data row.
• In cell A2, type "Average" and in cell A3, type "StDev".
• I then computed the Average log ratio for each chip (each column of data). In cell B2, type the following equation:

=AVERAGE(B4:B5224)

Note: We tried to do a keyboard shortcut using CTRL + Shift + Down buttons, but row 363 has a missing data so we had to manually type in "B5224" for the end of the data.

Assignment Links

Weekly Assignments

• Week 1
• Week 2
• Week 3
• Week 4
• Week 5
• Week 6
• Week 7
• Week 8
• Week 9
• Week 10
• Week 11
• Week 12
• No Week 13 Assignment
• Week 14
• Week 15

Individual Journal Entries

• Week 1 - This is technically the user page.
• Week 2
• Week 3
• Week 4
• Week 5
• Week 6
• Week 7
• Week 8
• Week 9
• Week 10
• Week 11
• Week 12
• No Week 13 Assignment
• Week 14
• Week 15

Shared Journal Entries

• Week 1
• Week 2
• Week 3
• Week 4
• Week 5
• Week 6
• Week 7
• Week 8
• Week 9
• Week 10
• Week 11
• Week 12
• No Week 13 Assignment
• Week 14
• Week 15