Bklein7 Week 8

From LMU BioDB 2015
Revision as of 23:37, 15 October 2015 by Bklein7 (Talk | contribs) (added link to current spreadsheet)

Jump to: navigation, search

Overview of Microarray Data Analysis

Current Spreadsheet: File:Merrell Compiled Raw Data Vibrio BK 20151015.xls

Statistical Analysis of Vibrio cholerae Microarray Data (Part 1)

  • Downloaded the [Merrell_Compiled_Raw_Data_Vibrio.xls] file.
    • Renamed the file to Merrell_Compiled_Raw_Data_Vibrio_BK_20151015.xls

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

  • Copied data from the compiled_raw_data tab to a new tab, entitled scaled_centered
    • Inserted two rows below the ID row, labelled Average and StDev.
      • Average: Calculated the averages of the data in each column using the function =AVERAGE()
        • Sample- for row B the function is =AVERAGE(B4:B5224)
      • StDev: Calculated the standard deviations of the data in each column using the function =STDEV()
        • Sample- for row B the function is =STDEV(B4:B5224)
    • Created a new series of columns for data sets A1-C4, adding the labels "_scaled_centered" (e.g. A1_scaled_centered)
      • Wrote a function to normalize each value in the data set
        • For the first value in column B (data set A1), the function was =(B4-B$2)/B$3
        • Extended this to all data values in the new scaled_centered columns
  • Created a new tab entitled statistics
    • Copied over:
      • The first column of gene ID values from the compiled_raw_data tab
      • The _scaled_centered columns from the scaled_centered tab
    • Deleted the blank Average and StDev rows
    • Created a new series of columns
  • COPY FROM OPENWETWARE FOR ELECTRONIC LAB NOTEBOOK

MAPPFinder Analysis of Vibrio cholerae Microarray Data (Part 2)

Conclusion

Links

Assignments Pages

Individual Journal Entries

Shared Journal Entries

Retrieved from "https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?title=Bklein7_Week_8&oldid=2668"