Help needed for set tally

Reply #9

adobea78 — Wed, 10 Nov 2021 22:49:11 GMT

Thank you Mitachoo, will get you feedback soon.

Reply #8

mitachoo — Wed, 10 Nov 2021 08:18:32 GMT

Data, for up to 1,000 data points, goes in Columns B, C, and D, and the resulting frequencies are tabulated automatically and listed in Columns Y and Z (Pairs), AC and AD (Triads), and AG and AH (Quads). The calculations are performed in the columns hidden between the red markers.

Reply #7

mitachoo — Wed, 10 Nov 2021 08:12:59 GMT

Done! See link below.

https://docs.google.com/spreadsheets/d/12ei1cXrmHeJXouVtGA1U-AFkfMKyLInD/edit?usp=sharing ouid=110429349872253868641 rtpof=true sd=true

Reply #6

adobea78 — Wed, 10 Nov 2021 02:00:14 GMT

Thanks for the info, will check.

Reply #5

adobea78 — Wed, 10 Nov 2021 01:54:19 GMT

Hi Mitachoo, that will be fantastic. Take your time , no rush.

Thanks.

Reply #4

mitachoo — Tue, 09 Nov 2021 20:12:08 GMT

I could put an Excel template together, where you would type in or paste the data and it would spit out lists of pairs, triads, etc, sorted by frequency. How soon do you need it

Reply #3

Todd — Tue, 09 Nov 2021 12:25:55 GMT

Have you tried Inspector 3 and Inspector 4

Reply #2

Todd — Tue, 09 Nov 2021 12:24:40 GMT

Reply #1

stah — Tue, 09 Nov 2021 04:50:59 GMT

Gail Howard has one that does that.

At least her old program did it.

Help needed for set tally

adobea78 — Tue, 09 Nov 2021 01:46:33 GMT

I need a program to count Pair, triads and quads by frequency.

Eg 01,21,23,01,20,20,40,40

enter numbers below enter numbers below enter numbers

01,21,23,01,20,20,40,40 023,024,023,111,111,123 0000,0000,0011,0012

count pairs count triads/sets

Pair Frequency

01 2

20 2

21 1

23 1

40 2

Thanks,

Adobea 78