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?

 

To explain what I mean, I think you can level up a cooking style. For example, pasta. At level 1, you're boiling dried pasta and adding sauce out of a jar. At level 1, you add your own spices. Level 3, switch to fresh pasta. Level 4, make your own sauce. And finally at level 5, make the pasta from scratch.

So with BBQ, I guess level 1 would be cooking the meat so it's neither burnt nor underdone. Maybe level 2 is mixing different meats/cuts that have different heat/time requirements and cooking well. Further levels = ?

view more: next ›