User:Yamagawa/Drop Rates Scratch

Working: Gift of the traveller.

107 rows of data.

Determined reported totals and actual totals do not match. Identified final row of data as the source. Moved to the 'for review' table.

106 rows of data.

2633 drops total.

2633^0.5 = ~ 51. Target bucket size = 50.

However... there are 12 samples that are larger  (Grr -- lost precision)

Sort by size, decending....

Oversize samples account for 1698 drops.

That leaves 935 drops with sizes <= 50.

Reworking the preferred sample size...

935^0.5 = 30.57

Oversize samples = 1888 drops.

745 remain

745^0.5 = 27.... using 30 as the target bucket size. (HINT! 1 sample of 50 is much less helpful than 2 samples of 25)

Bucketing the data....