Question:

(a) Search the Internet for the latest figures you can find on the age and sex of the Australian population.

(b) Then using Excel, prepare a table of population numbers (not percentages) by sex (in the columns) and age (in the rows). Break age into about 5 groups, eg, 0-14, 15-24, 24-54, 55-64, 65 and over. Insert total of each row and each column. Paste the table into Word as a picture.

Give the table a title, and below the table quote the source of the figures.

(c) Calculate from the table and explain:

• The marginal probability that any person selected at random from the population is a male.
• The marginal probability that any person selected at random from the population is aged between 25 and 54 (or similar age group if you do not have the same age groupings).
• The joint probability that any person selected at random from the population is a female and aged between 25 and 54 (or similar).
• The conditional probability that any person selected at random from the population is 65 or over given that the person is a male.