The Head of the Analytics Unit would like to have a report with some insights about that data…

SUPERIOR-PAPERS.COM essay writing company is the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click the button below to place your order.

Order a Similar Paper Order a Different Paper

You have just started working as a data miner/analyst in the Analytics Unit of a company. The Head of the Analytics Unit has brought you a data set [a welcome present ;-))]. The data set includes two files: description of the attributes and a table with the actual values of these attributes. The Head of the Analytics Unit has mentioned to you that this is some sort of demographic data that a potential client has provided for analysis. The Head of the Analytics Unit would like to have a report with some insights about that data, that he/she could deliver to the client. Your tasks include: ? understanding the specifics of the data set ? extracting information about each of the attributes, possible associations between them and other specifics of the data set. The tasks in the assignment are specified below. 31250 / 32130 Assignment 2 2 Data sets For this dataset you only have the attribute headings, no descriptions of what they mean. Each student is assigned an individual table with the actual values of these attributes. Please, download the file that is linked to your name from UTS Online. Tasks 1A. Initial data exploration 1. Identify the type of first 30 attributes {row ID, ……., foreign_worker_info_education} (nominal, ordinal, interval or ratio). If it’s not clear you may need to justify why you choose the type. 2. Identify the values of the summarising properties for the first 30 attributes including frequency, location and spread (e.g. value ranges of the attributes, frequency of values, distributions, medians, means, variances, percentiles, etc. – the statistics that have been covered in the lectures and materials given). Note that not all of these summary statistics will make sense for all the attribute types, so use your judgement! Where necessary, use proper visualisations for the corresponding statistics. 3. Using KNIME or other tools, explore your data set and identify any outliers, clusters of similar instances, “interesting” attributes and specific values of those attributes. Note that you may need to ‘temporarily’ recode attributes to numeric or from numeric to nominal. In the report include the corresponding snapshots from the tools and explanation of what has been identified there. Present your findings in the assignment report. 1B. Data preprocessing Perform each of the following data preparation tasks (each task applies to the original data) using your choice of tool: a. Use the following binning techniques to smooth the values of the employer_num_employees attribute: ? equi-width binning ? equi-depth binning. In the assignment report for each of these techniques you need to illustrate your steps. In your Excel workbook file place the results in separate columns in the corresponding spreadsheet. Use your judgement in choosing the appropriate number of bins – and justify this in the report. b. Use the following techniques to normalise the attribute employer_num_employees: ? min-max normalization to transform the values onto the range [0.0-1.0]. ? z-score normalization to transform the values.


"Is this question part of your assignment? We can help"


Got stuck with a writing task? We can help! Use our paper writing service to score better grades and meet your deadlines.

Get 15% discount for your first order

Order a Similar Paper Order a Different Paper