It’s Friday, pals and this is the 21st Community Open Thread! 21 is my lucky number (and was my varsity field hockey number too) and today has been somewhat of a lucky day for me as well, so here I am paying some of that forward to y’all:
Also paying forward some of those good hyperlinks:
it’s weekend and I’m trying to put together post for my thread in the gallery with some charts. I’m plotting averages and standard deviations. and I’m in awe at how dumb the error bar system in google sheets is.
you can use the same constant/percentage error on each data point. who ever wanted that?
or there’s this even stupider feature to get the standard deviation across various bar values and to draw that on each bar. whoever added that feature has a seriously warped understanding of what charts are meant to show.
y’all see how dumb this is
the solution is to create a separate data series for every single bar and to type in a “constant” error for each thusly single-data-point series.