I have to present the results obtained in the experiment for my master's thesis in the form of charts and tables.
I repeated some of the results 1, 2 or 3 times, for all of them I calculated the standard deviation (a constant percentage value for 1-fold results, and for the remaining ones I determined the deviation based on the obtained repetitions).
I averaged all the results that had repetitions (the sum of repetitions / number of repetitions).
I would like to present the average results in a table so that in each cell the data looks like this:
RESULT (+/- DEVIATION).
In the future, I would also like to use automatic formatting (so that Excel would color cells with a gradient, e.g. from green to red - from the lowest to the highest values). So I would not like to such a cell format in automatic formatting bother ....
Similarly, I would like to make graphs so that, for example, on the bar representing the average result, the deviation should be marked, but those calculated from 3 repetitions of a given result, and not constant percentages for all bars.
Is it possible to do something like that?
I repeated some of the results 1, 2 or 3 times, for all of them I calculated the standard deviation (a constant percentage value for 1-fold results, and for the remaining ones I determined the deviation based on the obtained repetitions).
I averaged all the results that had repetitions (the sum of repetitions / number of repetitions).
I would like to present the average results in a table so that in each cell the data looks like this:
RESULT (+/- DEVIATION).
In the future, I would also like to use automatic formatting (so that Excel would color cells with a gradient, e.g. from green to red - from the lowest to the highest values). So I would not like to such a cell format in automatic formatting bother ....
Similarly, I would like to make graphs so that, for example, on the bar representing the average result, the deviation should be marked, but those calculated from 3 repetitions of a given result, and not constant percentages for all bars.
Is it possible to do something like that?