Difference between revisions of "Troque Week 8"
From LMU BioDB 2015
(Starting the Individual Journal) |
m (→Normalize the log ratios for the set of slides in the experiment: Updated this page, will need to edit) |
||
| Line 2: | Line 2: | ||
== Normalize the log ratios for the set of slides in the experiment == | == Normalize the log ratios for the set of slides in the experiment == | ||
| − | To scale and center the data (between chip normalization) | + | To scale and center the data (between chip normalization) I performed the following operations: |
| − | * Insert a new Worksheet into | + | * 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. | + | * 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. | * 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 " | + | * 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) | =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. | 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. | ||
| + | |||
| + | |||
| + | |||
{{Template:Troque_Journal}} | {{Template:Troque_Journal}} | ||
Revision as of 22:14, 15 October 2015
Contents
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
