Difference between revisions of "Maximum Project Findings"

From Analytics Practicum
Jump to navigation Jump to search
Line 43: Line 43:
 
We also conducted the following cleaning procedures:
 
We also conducted the following cleaning procedures:
  
* Irrelevant and Duplicate Fields
+
* Irrelevant and Duplicate Fields: Removed from our dataset.
* Missing Data
+
* Missing Data: Removed from our data set, null values were replaced with 0s to facilitate our analysis.
* Duplications
+
* Rectifying Discrepancies: Ensured data from pre- and post- survey were in comparable formats.
* Rectifying Discrepancies
+
* Data Transformation: Transformed categorical data into numerical data for the Likert data analysis.
* Data Transformation
+
* Standardisation: Standardised name conventions for the variables in the merged data.
* Standardisation
 
  
 
<br/><div align="left">
 
<br/><div align="left">

Revision as of 13:12, 25 February 2018

Team20 Logo.jpg


HOME

 

ABOUT US

 

PROJECT OVERVIEW

 

PROJECT FINDINGS

 

PROJECT MANAGEMENT

 

DOCUMENTATION

 

BACK TO MAIN PAGE

 


Data Cleaning


The pre-survey dataset had 1,455 records, and the post-survey dataset had 414 records. On merging, we only had 292 records where the pre- and post- surveys were both done by the respondents.

We also conducted the following cleaning procedures:

  • Irrelevant and Duplicate Fields: Removed from our dataset.
  • Missing Data: Removed from our data set, null values were replaced with 0s to facilitate our analysis.
  • Rectifying Discrepancies: Ensured data from pre- and post- survey were in comparable formats.
  • Data Transformation: Transformed categorical data into numerical data for the Likert data analysis.
  • Standardisation: Standardised name conventions for the variables in the merged data.

Data Exploration