Difference between revisions of "ANLY482 AY2016-17 T2 Group19 Data"

From Analytics Practicum
Jump to navigation Jump to search
Line 39: Line 39:
 
<!--End Header-->
 
<!--End Header-->
 
<p>
 
<p>
<div style="background: #4d4d4d; padding: 20px; line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Rockwell;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #FFF>Data</font></div>
+
<div style="background: #4d4d4d; padding: 20px; line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Trajan Pro;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #FFF>Data</font></div>
 
<p>
 
<p>
=<div style="background: #4d4d4d; padding: 20px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Rockwell;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff>Background</font></div>=
+
=<div style="background: #4d4d4d; padding: 20px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Trajan Pro;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff>Background</font></div>=
  
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; ">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; ">
Line 50: Line 50:
 
</div><br>
 
</div><br>
  
=<div style="background: #4d4d4d; padding: 20px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Rockwell;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff>Data Description</font></div>=
+
=<div style="background: #4d4d4d; padding: 20px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Trajan Pro;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff>Data Description</font></div>=
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; ">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; ">
 
Data relates to sensitive transactional data and hence will not be released on the wiki
 
Data relates to sensitive transactional data and hence will not be released on the wiki
 
</div>
 
</div>
  
=<div style="background: #4d4d4d; padding: 20px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Rockwell;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff>Purpose of the model</font></div>=
+
=<div style="background: #4d4d4d; padding: 20px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Trajan Pro;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff>Purpose of the model</font></div>=
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px;">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px;">
 
Given the context of this data set...<br><br> Through these model...
 
Given the context of this data set...<br><br> Through these model...
 
</div>
 
</div>
  
=<div style="background: #4d4d4d; padding: 20px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Rockwell;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff> Data Exploration </font></div>=
+
=<div style="background: #4d4d4d; padding: 20px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Trajan Pro;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff> Data Exploration </font></div>=
  
<div style="background: #4d4d4d; padding: 10px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Rockwell;  border-radius: 5px; border-bottom:2px solid #ba3749"><font color= #ffffff> Categorical Data </font></div>
+
<div style="background: #4d4d4d; padding: 10px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Trajan Pro;  border-radius: 5px; border-bottom:2px solid #ba3749"><font color= #ffffff> Categorical Data </font></div>
  
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; ">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; ">
Line 70: Line 70:
 
</div><br>
 
</div><br>
  
<div style="background: #4d4d4d; padding: 10px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Rockwell;  border-radius: 5px; border-bottom:2px solid #ba3749"><font color= #ffffff> Continuous Data </font></div>
+
<div style="background: #4d4d4d; padding: 10px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Trajan Pro;  border-radius: 5px; border-bottom:2px solid #ba3749"><font color= #ffffff> Continuous Data </font></div>
  
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px;">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px;">
Line 78: Line 78:
 
</div><br>
 
</div><br>
  
<div style="background: #4d4d4d; padding: 10px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Rockwell;  border-radius: 5px; border-bottom:2px solid #ba3749"><font color= #ffffff> Multicollinearity </font></div>
+
<div style="background: #4d4d4d; padding: 10px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Trajan Pro;  border-radius: 5px; border-bottom:2px solid #ba3749"><font color= #ffffff> Multicollinearity </font></div>
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px;">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px;">
 
-Discuss any overlapping collinearity <br>
 
-Discuss any overlapping collinearity <br>
Line 84: Line 84:
 
</div><br><br>
 
</div><br><br>
  
=<div style="background: #4d4d4d; padding: 20px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Rockwell;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff> Data Cleaning and Preparation </font></div>=
+
=<div style="background: #4d4d4d; padding: 20px;  line-height: 0.1em;  text-indent: 10px; font-size:20px; font-family: Trajan Pro;  border-radius: 7px; border-bottom:3px solid #ba3749"><font color= #ffffff> Data Cleaning and Preparation </font></div>=
  
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px;">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px;">

Revision as of 19:52, 19 February 2017



Protegelogo-01.svg

Protege overview.svg   OVERVIEW

Protege data.svg   DATA

Protege Methods.svg   METHODOLOGY

Protege Analysis.svg   ANALYSIS

Protegemaster-03.svg   FINDINGS

Protege poster.svg   POSTER

Data

Background

In the pharmaceutical industry, it has historically been a challenge to manage hundreds of hospitals and clinics with sizeable differences in the types of drugs, disposable items and the sheer volume in respective purchase orders

While not exclusive to this industry alone, managerial decision making processes have historically relied heavily on transactional raw data and managerial experience

The data set that was used contains sales data from a medium-sized pharmaceutical company with customer base ranging from over the counter pharmacies to clinics around Singapore.


Data Description

Data relates to sensitive transactional data and hence will not be released on the wiki

Purpose of the model

Given the context of this data set...

Through these model...

Data Exploration

Categorical Data

-Insert title of variable-
-Insert Description of variable and comment on the preparatory work to be done-

  1. insert image if any


Continuous Data

-Insert title of variable-
-Insert Description of variable and comment on the preparatory work to be done-

  1. insert image if any


Multicollinearity

-Discuss any overlapping collinearity

  1. insert image if any



Data Cleaning and Preparation

-insert variable that has been cleaned-
-discuss the treatment and why the treatment-