Last Name Usage By Length

July 27, 2008 last names, research 1 Comment

((
Second Life Last Name Usage Figures Grouped By Last Name Length. For the number of last names contributing to each group, see Length Distribution of SL Last Names.

mysql>
SELECT LENGTH(last_name) AS len, SUM(usage_count), AVG(usage_count)
  FROM last_names
 GROUP BY len;
+-----+------------------+------------------+
| len | SUM(usage_count) | AVG(usage_count) |
+-----+------------------+------------------+
|   2 |           123563 |        4412.9643 |
|   3 |           422033 |        2542.3675 |
|   4 |          1910360 |        2966.3975 |
|   5 |          2680595 |        2177.5751 |
|   6 |          2847973 |        1633.0120 |
|   7 |          2291388 |        1342.3480 |
|   8 |          1848338 |        1574.3935 |
|   9 |           982622 |        1308.4181 |
|  10 |           545722 |        1491.0437 |
|  11 |           184255 |        1109.9699 |
|  12 |            67832 |         892.5263 |
|  13 |            13924 |         409.5294 |
|  14 |              895 |          25.5714 |
|  15 |             1159 |          46.3600 |
|  16 |               26 |           1.0400 |
|  17 |             1172 |          68.9412 |
|  18 |                2 |           0.0385 |
+-----+------------------+------------------+
17 rows in set (0.19 sec)

Bar chart follows. Read the rest…