Difference between revisions of "Stephen Louie Week 8"
From LMU BioDB 2013
(edited part 1 of journal entry) |
(edited part 1) |
||
| Line 13: | Line 13: | ||
**Typed "Average" in cell A2 and "StdDev" in cell A3 | **Typed "Average" in cell A2 and "StdDev" in cell A3 | ||
*Typed "=AVERAGE(B4:B5224)" in cell B2. | *Typed "=AVERAGE(B4:B5224)" in cell B2. | ||
| + | *Typed "=STDEV(B4:B5224)" in cell B3. | ||
| + | *Copied both equations in cells B2 and B3 and pasted them into the empty cells in the rest of the columns. | ||
| + | * | ||
===Part 2=== | ===Part 2=== | ||
Revision as of 06:09, 18 October 2013
Contents |
Overview of Microarray Data Analysis
Lab Journal
Part 1
- Accessed BIOL398-01:Bioinformatics Laboratory
- Downloaded the Merrell_Compiled_Raw_Data_Vibrio.xls file to Desktop.
- File renamed Merrell_Compiled_Raw_Data_Vibrio_SL_10102013.xls to reflect ownership and date
- Inserted a new Worksheet into Excel file, and named it "scaled_centered"
- Copied data from "compiled_raw_data" worksheet into "scaled_centered" worksheet
- Inserted two rows in between the top row of headers and the first data row.
- Typed "Average" in cell A2 and "StdDev" in cell A3
- Typed "=AVERAGE(B4:B5224)" in cell B2.
- Typed "=STDEV(B4:B5224)" in cell B3.
- Copied both equations in cells B2 and B3 and pasted them into the empty cells in the rest of the columns.
Part 2
Files
Part 1
Merrell_Compiled_Raw_Data_Vibrio_SL_10102013.txt
Merrell_Compiled_Raw_Data_Vibrio_SL_10102013.xls
Part 2
Increased_SL-Criterion0-GO.txt
Increased_SL-Criterion0-GO.xls
Merrell_Compiled_Raw_Data_Vibrio_SL_10102013.EX.txt
