Posted 09 May 2012 - 10:55 AM
It doesn't necessarily need to be an excel but even a .csv file would do. I have attached what I would like to export.
Frequency.jpg 109.02K 35 downloads
Posted 09 May 2012 - 11:57 AM
Screen Shot 2012-05-09 at 12.56.23 PM.png 93.65K 32 downloads
As a tip (if you didn't already know), when using the count command on a custom range of verses, be sure to use the [RANGE ] command, and not the drop down menu of your custom ranges. Using the latter will constrain the hits to only that range, and not the entire GNT, which is usually what most people want with this type of search.
Project Manager, Module Development
iOS Working Group
Posted 10 January 2013 - 05:48 PM
I have a question similar to brenshaw833's. First of all, what are the search commands to export the list of words like you did? Second, is there a way to have Accordance sort the list by the number of times each word occurs? For example, first list all the words that appear once, then twice, and so on.
Posted 10 January 2013 - 07:36 PM
If you open the Analysis Word Counts after your search, you have the option of sorting by count up or count down (Brenshaw's initial post in this thread shows alphabetical, but you can use the pull down menu to select other options).
Posted 11 January 2013 - 06:35 AM
To get this list open the relevant text (e.g. GNT-T)
For list of all words across the whole text just type [COUNT 1-99999] then open the analysis window. As Michael says the analysis window can then be sorted.
If you are just interested in the words in a book then use the range commands with the count [COUNT 1-99999] <and> [RANGE Jn]
If you are interested in lower frequency words only (i.e. only those that occurs 1-30 times in the NT) then just change the count accordingly. This is where the type of range you use becomes important as mentioned by Rick. If you use the range command [COUNT 1-99999] <and> [RANGE Jn] it uses the frequency of the word across the NT. If you use the range drop down it uses the frequency in that particular selected range. These therefore give different results.
Posted 11 January 2013 - 01:26 PM
There is actually no need to use the COUNT command to find all the words, just use the *. The COUNT command limits the hits to those in the specified range.
Also tagged with one or more of these keywords: export frequency, vocabulary, excel export
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users