22576 - Data Analytics - Assessment 2

Examines Profile Score

check for distribution, to decide whether we use median or mean to replace missing data (TotalVisits)

Conversion rate without duplicate row filter is shown to be 0.383 (38.3%)

Conversion rate after duplicate row filter is shown to be 0.398 (39.8%)

This shows the average mean of people being converted coming from different lead sources (Conversion rate percentage) Conversion varies by acquisition score

Shows the percentage of people converted that did the survey (2851/7167=39.8%)

STATS FOR CLEANED DATASET

Test of 2 clusters

To group leads into 2 clusters based on TotalVisits, Page Views Per Visit, Activity Score and Profile Score

To check cluster quality

Shows cluster_1 converted at a higher rate than cluster_0

Shows clear separation between cluster_0 and cluster_1 based on Total Visits and Page Views Per Visit

To compare converted vs non-converted leads across key variables (Time Spent on Website, TotalVisits, Activity Score and Profile Score)

Testing the first Hypothesis of whether time spent on website = higher conversion rate + the others

check for distribution, to decide whether we use median or mean to replace missing data

to verify that an observation either missed all 4 four variables (activity and profile index/score) or not

This compares lead sources to whether it matters when it comes to people being converted

This compares country, however there is a unkown makes a signficant amount towards the resutl

Grouping the average of total time spent on website, total visits, activity score, profile score, page views per visit

This compares whether giving a free copy of masting the interview = customers are more likely to convert