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?
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.
I may have been looking at an older version of the LibreOffice wiki.