Which language provides the most random alphabetically sorted sequence?

Data

|  N | Eng | Dut | Ger | Tur | Chi | Lex |
|----+-----+-----+-----+-----+-----+-----|
|  1 |   8 |   8 |   8 |   6 |   8 |   1 |
|  2 |  11 |   3 |   3 |   5 |   2 |  10 |
|  3 |   5 |   1 |   1 |   1 |   9 |  11 |
|  4 |   4 |  11 |  11 |   9 |   6 |  12 |
|  5 |   9 |   9 |   5 |   4 |   3 |   2 |
|  6 |   1 |  10 |   9 |   2 |   4 |   3 |
|  7 |   7 |  12 |   6 |  10 |   7 |   4 |
|  8 |   6 |   2 |   7 |  11 |  10 |   5 |
|  9 |  10 |   4 |   4 |  12 |  12 |   6 |
| 10 |   3 |   5 |  10 |   8 |  11 |   7 |
| 11 |  12 |   6 |   2 |   3 |   5 |   8 |
| 12 |   2 |   7 |  12 |   7 |   1 |   9 |

Sourced from comments in thread (English from image, Dutch from !Vinny_93@lemmy.world, German from !TJA@sh.itjust.works , Turkish from some rando, Chinese from !idealotus@lemmy.world, Lexicographical from !monogram@feddit.nl)

Plot with Correlation Scores

We will compute the pearson correlation (r-statistic) score by comparing the base number (column 1) with the corresponding language column. We will also compute the Serial correlation, by creating staggered columns that measure how close a number is in a sequence to the one before it.

cat alphabetic.tab \
    | awk '{print $0"\t"prE"\t"prD"\t"prG"\t"prT"\t"prC"\t"prL;prE=$2;prD=$3;prG=$4;prT=$5;prC=$6;prL=$7}' \
    | tee alphabetic.tab.stagger

gnuplot -p -e '
  set xlabel "Base Sequence";
  set ylabel "Alphabetic";
  set xtics 1,1,12;
  set ytics 1,1,12;
  set title "Alphabetic Number Plot with Correlation Score";
  set rmargin 25; set key at graph 1.5,0.9;
  set size ratio 0.45;

  stats "alphabetic.tab.stagger" using 1:2 name "E";
  stats "" using 1:3 name "D";
  stats "" using 1:4 name "G";
  stats "" using 1:5 name "T";
  stats "" using 1:6 name "C";
  stats "" using 1:7 name "L";
  
  stats "" using 2:8 name "ES";
  stats "" using 3:9 name "DS";
  stats "" using 4:10 name "GS";
  stats "" using 5:11 name "TS";
  stats "" using 6:12 name "CS";
  stats "" using 7:13 name "LS";

  set label 1 sprintf("%10s  %6s  %6s", "", "Base", "Stagger") at graph 1.07,0.95;

  plot "" using 1:2 with lines lw 3 title sprintf("%10s  %+.3f  %+.3f", "English", E_correlation, ES_correlation),
       "" using 1:3 with lines lw 3 title sprintf("%10s  %+.3f  %+.3f", "Dutch", D_correlation, DS_correlation),
       "" using 1:4 with lines lw 3 title sprintf("%10s  %+.3f  %+.3f", "German", G_correlation, GS_correlation),
       "" using 1:5 with lines lw 3 title sprintf("%10s  %+.3f  %+.3f", "Turkish", T_correlation, TS_correlation),
       "" using 1:6 with lines lw 3 title sprintf("%10s  %+.3f  %+.3f", "Chinese", C_correlation, CS_correlation),
       "" using 1:7 with lines lw 1 title sprintf("%10s  %+.3f  %+.3f", "Lexicon", L_correlation, LS_correlation)
'

It looks like Dutch has the lowest (near 0) correlation to both the base sequence and it’s own staggered sequence, with Turkish mirroring it’s staggered randomness somewhat.

The least random alphabetic sequences are English and German.

Updated: Added chinese and staggered analysis.

I recently found out that javascript’s .sort() function, when called without arguments on an array of numbers, converts them all to strings and sorts them alphabetically 🤡

Lexicographical clock

1 10 11 12 3 4 5 6 7 8 9

Thanks, i hate it :)

Interestingly it would be right twice a day

Portuguese

cinco, dez, dois, doze, nove, oito, onze, quatro, seis, sete, três, um

5 10 2 12 9 8 11 4 6 7 3 1

cinco, dez, dois, doze, meia, nove, oito, onze, quatro, sete, três, um

5 10 2 12 6 9 8 11 4 7 3 1

(six can be “seis” or “meia”)

It’s 9 o’clock somewhere!

This is extremely sick. I’m going to cancel my Disney account.

What time is it?
It’s Beer O’clock!

If a mechanical clock or watch was like that it would be one hell of a fascinating movement

I hate this so much

5 4 10 2 12 9 6 7 8 11 3 1

Ah yes its nearly 8:03 o’clock

Or nearly 56 minutes to 11:08

Cinq Deux Dix Douze Huit Neuf Onze Quatre Sept Six Trois Un

5 2 10 12 8 9 11 4 7 6 3 1

8 3 1 11 5 9 6 7 4 10 2 12