logo elektroda
logo elektroda
X
logo elektroda

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

kalifsoup 27518 2
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
  • #1 11027640
    kalifsoup
    Level 10  
    Posts: 21
    Rate: 18
    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  
    Posts: 14667
    Help: 848
    Rate: 2646
    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  
    Posts: 21
    Rate: 18
    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