Last Name Usage By Length

last names, research No Comments

((
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…