$openoffice calculate fraction of second$

We want to COUNT the occurences of each chrom/class pair (when counting, it doesn't matter which column is used as the DATA column).

$openoffice calculate fraction of second$

The families (column 13) will be listed in the ROWS.The chromosomes (column 6) will be listed as COLUMNS.We can use cross-tabulation to count how many families are in each chromosome: We want to calculate the MEAN score of each chrom/strand pair - the actual score value is found in column 5.We can use cross-tabulation to find the mean score for each chrom/strand pair: We want to COUNT the occurences of each chrom/strand pair (when counting, it doesn't matter which column is used as the DATA column).

$openoffice calculate fraction of second$

The chromsomes (column 1) will be listed in the ROWS.

The strand information (column 4) will be listed as COLUMNS.

We can use cross-tabulation to see a contingency table of chromosome vs.

$openoffice calculate fraction of second$ $openoffice calculate fraction of second$

Given the following (made up) list of intervals (columns are: chrom,start,end,strand,score): more than two variables), see the hierarchical and the advanced versions of the cross-tabulation tool (available under the same category). This tool calculates a cross-tabulation for two variables in a input dataset.Ĭross-Tabulation is commonly known as Data Pilot in OpenOffice Calc, and as Pivot Tables in Microsoft Excel.įor general information about cross-tabulations, see and įor advanced cross-tabulation options (e.g.

$openoffice calculate fraction of second$

Openoffice calculate fraction of second