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 have a dataset with age groups as individual variables with counts and I want to create one age group variable with all the options in that variable and combine some age groups as well: HAVE: age_grp_1 = 345 age_grp_2 = 123 age_grp_3 = 46 age_grp_4 = 35 age_grp_5 = 232 age_grp_6 = 372

WANT: age_grp variable with the following values 1= 345 2 = 123 3 = 46 + 35 (combine groups 3&4 above) 4 = 232 5 = 372

Anyone know how to do this? Thanks in advance!