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?

  • howrar@lemmy.ca
    2·
    5 months ago

    I’ve never used Calc, but I find it hard to believe that it can only accept a range of 255 cells. That’s an insanely small number of cells.

    This is definitely something that should be doable with spreadsheets.

  • rImITywR@lemmy.worldEnglish
    2·
    5 months ago

    I agree that Python is probably worth looking into.

    But looking at the LibreOffice docs, the AVERAGE function can take up to 255 arguments, each “are numbers, references to cells or to cell ranges of numbers”. A cell range is a single argument.

    To test, I just opened Calc and filled 1000 cells in the first column with random data, and =AVERAGE(A1:A1000) worked fine.