Aligning & analyzing TRFLP data - EEMB Research
Aligning & analyzing TRFLP data
Based on Rees et al., 2004
Rees, G. N., Baldwin, D. S., Watson, G. O., Perryman, S., and D. L. Nielson, 2004. Ordination and significance testing of microbial community composition derived from terminal restriction fragment length polymorphisms: application of multivariate statistics. Antonie van Leeuwenhoek, 86:339-347.
1) Standardize each peak height as a % of the total peak height for that sample. Reassign all peaks that are less than 1% to 0, and recalculate the % of the remaining peaks for that sample.
a) Import data tables that you exported from Genescan into Excel. Create a workbook for each project and a worksheet page for each sample.
b) For each sample, calculate the total of all the peak heights (usually column D).
c) Next calculate each individual peak height in that sample a percentage of the total peak heights for that sample (new column,"%peak height"). (peak1_height/total_peak_heights)*100, (peak2_height/total_peak_heights)*100, etc.
d) Use a simple If-Then statement to carry over the peak heights and areas that are >1%. Use one column for peak heights ("new peak height"), and another for peak areas ("new peak area") (even though we will only use peak height data). Type your actual cell numbers into the formulas below in their respective columns. =IF(%peakheight ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- n quick and dirty excel workbooks without dde or ods n
- after 30 years microsoft excel remains ubiquitous in
- excel basics microsoft office 2007
- dragging in the original spreadsheet using the mouse
- and when i try to add another row to my spreadsheet
- aligning analyzing trflp data eemb research
- kingsoftspreadsheets2016 wps office
Related searches
- data analysis research paper example
- analyzing data in quantitative research
- data analysis research methodology
- analyzing qualitative data pdf
- analyzing quantitative data methods
- data analytics research paper
- analyzing and interpreting data worksheet
- analyzing scientific data worksheets
- analyzing data in research
- analyzing data for research study
- analyzing data pdf
- data analytics research topics