Reference no: EM131038163
Scenario
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 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.
Data sets
The description of the attributes is the same for all students and comes in a tiny documentation file (download it from UTS Online). 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
1 A. Initial data exploration
1. Identify the type of each attribute (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 each attribute 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):
a. Use the following binning techniques to smooth the values of the Age
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 Age:
- min--max normalization to transform the values onto the range [0.0--1.0].
- z--score normalization to transform the values.
In the assignment report provide explanation about each of the applied techniques. In your Excel workbook file place the results in separate columns in the corresponding spreadsheet.
c. Discretise the Age attribute into the following categories: Teenager = 1--20; Young = 21--30; Mid_Age = 31--45; Mature = 46--65; Old = 66+. Provide the frequency of each category in your data set.
In the assignment report provide explanation about each of the applied techniques. In your Excel workbook file place the results in a separate column in the corresponding spreadsheet.
d. Binarise the Education variable [with values "0" or "1"].
In the assignment report provide explanation about the applied binarisation technique. In your Excel workbook file place the results in separate columns in the corresponding spreadsheet.
Attachment:- Data.csv
|
Explain research results described in the literature
: Explain research results described in the literature and the methods used to obtain those results, List open questions that need to be addressed by research,
|
|
Write an appropriate null hypothesis for this analysis
: Based on the scenario, what is the appropriate analysis for examining differences among the Asking for Help subscale scores based on the number of online courses completed? Write an appropriate null hypothesis for this analysis
|
|
A major detergent manufacturer proposes
: A major detergent manufacturer proposes spending £2.5 million (US$4.5 million) on a twelve-month national advertising campaign to promote an environmentally friendly washing liquid. Advise the marketing director how the effectiveness of the campa..
|
|
Evaluate how useful consumer panels
: Evaluate how useful consumer panels are in determining the most appropriate marketing mix components at the various stages of the PLC.
|
|
Provide explanation about the applied binarisation technique
: 32130 Fundamentals of Data Analytics - Identify the values of the summarising properties for each attribute including frequency, location and spread (e.g. value ranges of the attributes, frequency of values, distributions, medians, means, varian..
|
|
Define sensitivity and specificity
: Based on the outcome of the test, he decides who could participate in his iron supplementation trail. For this purpose, it is very important that diagnostic test has high............... ........
|
|
Discuss the circumstances whereby personal interviewing
: Discuss the circumstances whereby personal interviewing would be likely to be favoured rather than postal survey techniques in marketing research.
|
|
Conduct a hambrick model to determine the companys strategy
: Conduct a Hambrick Model to determine the company's strategy. Speculate on what would be considered Driving Forces and Key Success Factors in the industry.
|
|
Develop a work breakdown structure
: Develop a work breakdown structure (WBS) for a project to build new student housing for 150 students on campus at LTU in Southfield, Mi. The WBS should have at a minimum 5 levels and should cover all areas associated with designing, engineering, cons..
|