Question

Research Question: Constructing data table and calculating probabilities

Guide to marks: 14 - 5 for 1, 5 for 2, 4 for 3

The following question involves learning/employing research skills in searching out data on the Internet, presenting it in a well constructed and informative table, and calculating some probabilities showing calculation methods.

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

2.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 standard groups, eg, 0-14, 15-24, 25-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.

3.Calculate from the table, showing your calculation methods:

The probability that any person selected at random from the population is a male.

The probability that any person selected at random from the population is aged between 55 and 64.

The joint probability that any person selected at random from the population is a female and aged between 15 and 24.

The probability that any person selected at random from the population is 55 or over.

Answer 1

Male female Tola (2210) oZoo 3720626 ll19 3oo 0-14 63 0 4o3. ?40 to6064 $6s glo9 9437066202 Nr fri-A total = 07 11770 fedin た ofal 07l1770

to tal Papoleton () o 731 erson over giventuat he is malo total mo total male Populston 1126 (9 (2-