GLG410/598 Pebble data
These data come from Waltham, D., 1994, Mathematics: a simple tool for geologists, New York: Chapman and Hall, 189 p.
Listed below is a table of the weights of pebbles on a beach. Note, the way this table lists the numbers is such that there is a comma, followed in many cases by a three digit number. Thus if you cut and paste these into Excel, Excel will think the first row, "1,881" is one thousand, eight hundred, and eighty one. Therefore, you need to find a way to enter these as separate columns. A bandaid is to copy it from below, then when you go to paste it into Excel, choose Edit>Paste Special. Then choose the Text option. If there were absolutely no way to get Excel to behave, one duct tape approach would be to paste the contents into Microsoft Word as a temporary holding tank, replace commas w/ a space, then paste back into Excel. This is unnecessary here. You just need paste special as text.
Pebble #,Mass (g)
1,881
2,355
3,909
4,632
5,706
6,359
7,881
8,284
9,607
10,1263
11,290
12,795
13,1120
14,1154
15,439
16,229
17,182
18,383
19,719
20,509
21,322
22,578
23,1336
24,686
25,488
26,375
27,134
28,204
29,161
30,160
31,419
32,147
33,68
34,91
35,167
36,459
37,151
38,135
39,80
40,197
41,233
42,75
43,115
44,314
45,414
46,83
47,239
48,146
49,145
50,62