I have inputted data into my excel spreadsheet. The data is descriptive. I was wondering if there was a way of quantifying this data, such as finding common words etc.
Any suggestions are appreciated :)
Just a thought.
You can try analysing data in Excel itself if you split the text as "one word in one cell". Then you can use functions like COUNTIF.
To identify if a word appears in an MS Excel cell of text, you could write a formula. For example, if you're looking for "the" in cell A2, write =FIND("the",A2), and it returns the number of characters into the text the word begins. Write =IF(ISERROR(FIND("the",A2),0,1) to return 1 is the cell contains the text and 0 if it does not. If you would like to check for the occurrence of at least one of a set of terms (e.g., his, her, or their), then write =IF(AND(ISERROR(FIND("his",A2),ISERROR(FIND("her",A2),ISERROR(FIND("their",A2)),0,1). Przemysław's suggestion would definitely work to count the number of occurrences of particular words, maybe if you used MS Word and replaced spaces with paragraph marks and then pasted to Excel. I'm very curious too, Tarik, so I hope someone adds more elaborate, authoritative, answers than us. Best wishes with your project. ~ Kevin
- Badges
- Science topic