Nstojan1 Week 10

Rows: 4727 filter greater than 0.05 Media:Screenshots.pptx Media:Natalija_Stojanovic_File_New.xlsx

Rows: 4727 filter greater than 0.05 Media:Screenshots.pptx Media:Natalija_Stojanovic_File_New.xlsx

• Purpose: The purpose of this assignment is to analyze a DNA microarray dataset that involves clustering and analysis of gene regulation networks using the GRNsight software.

• Procedure:

1. • Preparing the microarray data file for loading into STEM:
     • Insert a new worksheet into Excel workbook, and make it dCIN5_stem
     • Select all the data from "dCIN5_ANOVA" worksheet and Paste Special > paste the values into "dCIN5_stem" worksheet.
     • The leftmost column should have a column header "Master Index". Rename it to "Spot". Rename Column B ("ID") to "Gene Symbol" and delete the column named "Standard_Name".
     • Filter the data on the B-H corrected value to be > 0.05
     • Once it has been filtered, select all of the rows (not header row) and delete the row by right clicking and choosing "Delete Row" from the context menu. Undo the filter, this will cluster only the genes with "significant" change in expression and not the noise.