Stephen Louie Week 8

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.

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

Merrell_Compiled_Raw_Data_Vibrio_SL_10102013.gex

Merrell_Compiled_Raw_Data_Vibrio_SL_10102013.gmf