# Difference between revisions of "Salomon Garcia: Lab notebook Week 7"

#### Procedures for Excel calculations

• Original data is uploaded with no significant changes yet as of 6:08pm 10/19/10 Link to the assignment: Dataset for assignment
• For the first portion of this assignment several calculations were done using excel standard deviation and averages were found link to this uploaded Vibrio data continued
• After doing some of the statistical analysis further work needs to be done and finish the excel, here is the link: continued version
• This data that has just been uploaded includes the information with the p-values and it includes the TSTAT and the data will be fixed in order for it to be ready to be used for GenMAPP. So far this is the data at this particular moment, at 11:52am 10/23/10/ File is ready but further analyzing still required
• For the next portion of the analyzing of the data some of the cells were cut and they were rearranged in a way that helps in the use of GenMAPP. Then a new column was inserted in order to add a new name (this will be seen in the link that is at the botttom of this). Here I have added a copy of the excel worksheet Data that has been manipulated for usage of GenMAPP and here is the copy of the text file required GenMAPP Data for GenMAPP usage is ready

• How many genes have p value < 0.05?----944 genes have p-values less than 0.05
• What about p < 0.01?----233 genes have p-values less than 0.01
• What about p < 0.001?----23 genes have p-values less than 0.001
• What about p < 0.0001?----2 genes have p-values less than 0.0001

• Keeping the "Pvalue" filter at p < 0.05, filter the "Avg_LogFC_all" column to show all genes with an average log fold change greater than zero. How many are there?----353 genes are shown to fall in this criteria
• Keeping the "Pvalue" filter at p < 0.05, filter the "Avg_LogFC_all" column to show all genes with an average log fold change less than zero. How many are there?----591 genes are shown to fall in this criteria
• What about an average log fold change of > 0.25 or < -0.25? (This is a more realistic value for the fold change cut-off because it represents about a 20% fold change which is about the level of detection of this technology.)----918 genes were shown to fall under this criteria.

• What criteria did Merrell et al. (2002) use to determine a significant gene expression change? How does it compare to our method?