[–] 21 points 2 days ago (5 children)

One of the Lazy Guns from Against A Dark Background by Iain M. Banks. Point at target. Pull trigger. Target is destroyed in some ridiculous way, like having a piano fall on it.

But don't point it at the sun. It doesn't like that.

  • source
  •  

    I'm working on a personal project that involves calculating the mean, median and mode of word length in a series of poems. I've imported the first into LibreOffice Calc as a CSV, and have about 600 cells of word lengths.

    Calc has Average, Median and Mode functions, but they only accept 255 inputs each. I could split the cells into batches of three and then work with those results, but it feels like that would only let me calculate the overall mean, not the other two figures.

    So firstly, am I even using the right tool for this? Maybe there's a better way than using a spreadsheet. And secondly, if a spreadsheet is the best tool, is there a way I can do the calculations I need?

    view more: next ›