Stratified Samples, Populations & Capture

Interactive macro-enabled MS-Excel spreadsheet. Contents: Find the № of coats from 3 design styles to give a stratified sample. Find the № of pupils from 5 year groups to give a stratified sample. Find the № of trisuits using two criteria to give a stratified sample. Find the № of each pizza to order given a sample of pupils’ choices. Find the pupil whose survey is closest to a given % of four villages. Describe how to take a random sample of a tenth of a population. Estimate the total № in the greater population given a small sample. Estimate the № of people in each category of spectator at a match. Estimate the girls’ & boys’ mean time given 2 frequency polygons. Estimate the annual total fines given vehicles’ speeds on a bridge. Estimate the № & value of coins in a jar after capture & recapture. Estimate the № & value of fish in a pond after capture & recapture. Estimate the № of deer in a herd after capture & double recapture.