User talk:Cem

Statistical Analysis

Hey Cem, can I ask how you compiled your statistical analysis, I really like the stuff you've done and I think it would be awesome to be able to apply it to more of the books, or add extra information (like maybe to the depth of dialogue/mentions and stuff?) --Joe ST (talk) 11:25, 13 January 2014 (UTC)

It's nothing complicated, though it's a bit of boring work. I have all the books in ebook format. I just went and copied every POV in tWoK, one by one, to MS Word and got the word count from there. Then I dumped the word counts to Excel and let it make the calculations with few easy functions. Then I converted that to a wikitable using one of the online converters, and made some adjustments to make it prettier. All told, the whole process took an evening. I uploaded the Excel file here, if you want to take a look at it. I've thought about compiling the same sort of information for other books, but so far I haven't been able to muster enough motivation. I'll eventually get to it, but if anyone else wants to take a shot at it meanwhile, go ahead, I'd be happy to help. For improvements, I'm open to suggestions, can you clarify what you mean by "depth of dialogue/mentions?" --Cem (talk) 12:05, 13 January 2014 (UTC)