QUESTION 2 Research Question: Constructing data table and calculating probabilit
ID: 3063008 • Letter: Q
Question
QUESTION 2 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.
Explanation / Answer
The data are downloaded from http://www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/3101.0Jun%202017?OpenDocument
under the heading "Data Cubes"
The data pertain to Australian demographic statistics, June 2017
The data table is as below:
1. The probability that any person selected at random from the population is a male = 12204419/24598933 = 0.4961.
2. The probability that any person selected at random from the population is aged between 55 and 64
= 2839985/24598933 = 0.1155.
3. The joint probability that any person selected at random from the population is a female and aged between 15 and 24 = 1566973/24598933 = 0.0637.
4. The probability that any person selected at random from the population is 55 or over = (2839985+3794800)/24598933 = 0.2697.
Age Group Male Female Total 0-14 2,378,293 2,253,739 4,632,032 15-24 1,636,306 1,566,973 3,203,279 25-54 5,023,223 5,105,614 10,128,837 55-64 1,389,331 1,450,654 2,839,985 65 and over 1,777,266 2,017,534 3,794,800 Total 12,204,419 12,394,514 24,598,933