logo elektroda
logo elektroda
X
logo elektroda

[EXCEL] Standard deviations in the table and in the chart - how to present it?

kalifsoup 27047 2
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
  • #1 11027640
    kalifsoup
    Level 10  
    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?
  • ADVERTISEMENT
  • #2 11028651
    yogi009
    Level 43  
    If you want to present several elements in one cell of the table (e.g. two numbers), I suggest checking the concatenation operator:

    = N5 & N6

    Of course, you can include separating spaces, parentheses, etc. along the way.

    Regards.
  • #3 11028662
    kalifsoup
    Level 10  
    As for the table, it will actually be probably the only option to combine the contents of the cell with the value and cells with the deviation.

    By the way, I think, can the standard deviation value be treated as the plus or minus (+/-), or maybe I should calculate the Error Limit for this?

    How to mark the deviation calculated from the mean of 3 repetitions with a line on the bar chart? And it's not just a few bars, but hundreds of bars - I'd like to automate the retrieval of the variance value. I can not find it...
ADVERTISEMENT