# LauraTerada Individual Journal Assignment Week 9

(Difference between revisions)
 Revision as of 12:45, 26 March 2013 (view source)← Previous diff Revision as of 12:32, 2 April 2013 (view source) (pvalue data entry)Next diff → Line 11: Line 11: *We use the dollar sign symbols in front of the number to tell Excel to always reference that row in the equation, even though we will paste it for the entire column. Why is this important? *We use the dollar sign symbols in front of the number to tell Excel to always reference that row in the equation, even though we will paste it for the entire column. Why is this important? **If you paste it through the entire column without the dollar sign, the box that you want for each equation won't normalize and it will be different for each equation. You need the dollar sign to keep the same box in each equation throughout the column. **If you paste it through the entire column without the dollar sign, the box that you want for each equation won't normalize and it will be different for each equation. You need the dollar sign to keep the same box in each equation throughout the column. + *Scan through your spreadsheet to find an example of the error message. Then go to the Edit menu and Select Replace. A window will open, type the text you are replacing in the "Find what:" field. In the "Replace with:" field, enter a single space character. Click on the button "Replace All" and record the number of replacements made in your wiki page. + **No error messages. + *t15 + **1474 genes have p value < 0.05 + **345 genes have p < 0.01 + **30 genes have p < 0.001 + **4 genes have p < 0.0001 + *t30 + **492 genes have p value < 0.05 + **266 genes have p < 0.01 + **34 genes have p < 0.001 + **6 genes have p < 0.0001 + *t60 + **284 genes have p value < 0.05 + **274 genes have p < 0.01 + **35 genes have p < 0.001 + **0 genes have p < 0.0001 + *t90 + **732 genes have p value < 0.05 + **190 genes have p < 0.01 + **12 genes have p < 0.001 + **1 gene have p < 0.0001 + *t120 + **397 genes have p value < 0.05 + **89 genes have p < 0.01 + **9 genes have p < 0.001 + **1 gene have p < 0.0001

## Revision as of 12:32, 2 April 2013

• Replicates for each time point
• 15C: 4
• 30C: 4
• 60C: 4
• 90C: 4
• 120C: 4
• We use the dollar sign symbols in front of the number to tell Excel to always reference that row in the equation, even though we will paste it for the entire column. Why is this important?
• If you paste it through the entire column without the dollar sign, the box that you want for each equation won't normalize and it will be different for each equation. You need the dollar sign to keep the same box in each equation throughout the column.
• Scan through your spreadsheet to find an example of the error message. Then go to the Edit menu and Select Replace. A window will open, type the text you are replacing in the "Find what:" field. In the "Replace with:" field, enter a single space character. Click on the button "Replace All" and record the number of replacements made in your wiki page.
• No error messages.
• t15
• 1474 genes have p value < 0.05
• 345 genes have p < 0.01
• 30 genes have p < 0.001
• 4 genes have p < 0.0001
• t30
• 492 genes have p value < 0.05
• 266 genes have p < 0.01
• 34 genes have p < 0.001
• 6 genes have p < 0.0001
• t60
• 284 genes have p value < 0.05
• 274 genes have p < 0.01
• 35 genes have p < 0.001
• 0 genes have p < 0.0001
• t90
• 732 genes have p value < 0.05
• 190 genes have p < 0.01
• 12 genes have p < 0.001
• 1 gene have p < 0.0001
• t120
• 397 genes have p value < 0.05
• 89 genes have p < 0.01
• 9 genes have p < 0.001
• 1 gene have p < 0.0001