STT500 Statistics for Decision Making

STT500 Assignment Help

Statistics for Decision Making Assignment help

Description Individual assignment must provide a 1500-word written report. This report will develop students quantitative, writing skills and, also test the ability to apply theoretical concepts covered from weeks 1-8. Please use Excel for statistical analysis in this assignment. Relevant Excel statistical output must be properly analysed and interpreted. Assignment Data

The real estate markets present a fascinating opportunity for data analysts to analyse and predict property prices. Considering the data provided a large set of property sales records.

Attribute information:
• PN: Property identification number
• Price: Price of the property ($000)
• Bedrooms: Number of bedrooms
• Bathrooms: Number of bathrooms
• Lot size: Land size (in square meters)

The population property data from which you will select your sample data consists of 500 IDs each with an identifying property number (PN) ranging from 1 (or 001) to 500.

Your first task is to select 50 three-digit random (property) numbers ranging from 001 to 500 from the provided table of random numbers.

To select your 50 random property identification numbers, you will need to first go to a starting position row and column in the random number table. Defined by the last three digits of your Polytechnic Institute Australia student identification number. The last two digits of your PIA ID number identifies the row, and the third last digit identifies the column of your (relatively) “unique” starting position.

You need to record these first three acceptable ID numbers into the first column of an Excel spread-sheet and then continue this process until fifty valid three-digit personal identification numbers are selected.

To select your sample data based on 50 randomly selected properties from the random number table, you will need to use these identification numbers to select properties from the Excel sheet of the population property data. For the demonstration last three digits of 205, reading across row 05 from left to right starting at column 2 as instructed, you would encounter the following three-digit numbers.

04773
12032
51414
82384
38370
00249
80709
72605
67497

You need to record these first three acceptable ID numbers, 047, 120, 383 and 002 into the first column of an Excel spread-sheet and then continue this process until fifty valid three-digit personal identification numbers selected.