Assignment title: Management
Make a hard copy1 (see note below) of your Excel worksheet (SampleRandomNumbers) containing the following four columns:
(i) Sixty valid three-digit property numbers selected according to the last three digits of your student identification number as per the above instructions.
(ii) The sixty valid three-digit property numbers recorded in (i) ordered from smallest to largest and with all repetitions of any particular property numbers clearly identified (highlighted).
(iii) The column of valid three-digit property numbers recorded in (ii) with the highlighted repeat property numbers deleted. You should present this column without any blank entries (these will be produced if you have to delete any repeat property numbers). If this column contains less than 50 property numbers you will have to return to the Table of Random Numbers and select additional valid three-digit property numbers between 001 and 400 and repeat the above process. Clearly identify (by highlighting) the largest property numbers in this column beyond the first 50 property numbers.
Task 1(a) (cont.)
(iv) The column of valid three-digit property numbers in (iii) trimmed down to 50 in total by deleting the largest property numbers in column (iii) beyond the first 50 property numbers.
(b) Make a hard copy1 (see note below) of your sample property data (9 columns x 51 rows (including the headings)) from the Excel file (SamplePropertyData) obtained as per the above instructions.