How do I make a table and use cumulative figures
http://www.nature.com/ki/journal/v53/n2/images/4490049t2.gif
To make a table and use cumulative figures, you can follow these steps:
1. Determine the data you want to display in the table. Identify the distinct categories or variables for which you want to calculate cumulative figures.
2. List the categories or variables in the leftmost column (usually column A) of your spreadsheet.
3. Enter the individual data points or figures in the corresponding columns next to each category.
4. Insert an additional column to the right of the data columns. This column will contain the cumulative figures.
5. In the first cell of the cumulative column, enter a formula to calculate the cumulative figure for the first category. For example, if your data is in columns B to F and the first category is in cell A2, the formula could be "=SUM($B$2:B2)".
6. Drag the formula from the first cell of the cumulative column to the rest of the cells in that column. This will automatically adjust the formula for each category.
7. You should now have a table with the original data in one set of columns and the corresponding cumulative figures in another column.
Using these steps, you can create a table with cumulative figures in Excel or any other spreadsheet software.