Question

Provide Mean, Median, Mode, Upper and Lower Limit

• Any null or missing values
• Detect any outliers or data points of interest
  • Provide a paragraph for each column with facts from the previous 3 bullets and provide the business context behind the importance of the column, showing the analysis and how this helps you in the preparation stages.

  • Month	Year	N Obs	Variable	Mean	Std Dev	Minimum	Maximum	Median	N	N Miss
    1	2016	3584	Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member	4.0231585 4.7360491 5.5172991 0.7460938 0.5957031	2.0277917 2.4579240 2.9140122 0.4353053 0.4908239	1.0000000 1.0000000 1.0000000 0 0	7.0000000 9.0000000 10.0000000 1.0000000 1.0000000	4.0000000 5.0000000 6.0000000 1.0000000 1.0000000	3584 3584 3584 3584 3584	0 0 0 0 0
    	2017	3584	Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member	4.0474330 4.7126116 5.5167411 0.7460938 0.5904018	1.9896422 2.4584740 2.8495141 0.4353053 0.4918282	1.0000000 1.0000000 1.0000000 0 0	7.0000000 9.0000000 10.0000000 1.0000000 1.0000000	4.0000000 5.0000000 5.0000000 1.0000000 1.0000000	3584 3584 3584 3584 3584	0 0 0 0 0
    2	2016	3604	Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member	3.9919534 4.7130966 5.4642064 0.7522198 0.5810211	1.9889206 2.4250830 2.8749679 0.4317834 0.4934604	1.0000000 1.0000000 1.0000000 0 0	7.0000000 9.0000000 10.0000000 1.0000000 1.0000000	4.0000000 5.0000000 5.0000000 1.0000000 1.0000000	3604 3604 3604 3604 3604	0 0 0 0 0
    	2017	3522	Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member	3.9400909 4.7118115 5.5008518 0.7413401 0.5800681	1.9807623 2.4473141 2.8953389 0.4379605 0.4936175	1.0000000 1.0000000 1.0000000 0 0	7.0000000 9.0000000 10.0000000 1.0000000 1.0000000	4.0000000 5.0000000 5.0000000 1.0000000 1.0000000	3522 3522 3522 3522 3522	0 0 0 0 0
    3	2016	3625	Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member	3.9798621 4.6780690 5.4419310 0.7514483 0.5961379	1.9948561 2.4453918 2.8590908 0.4322329 0.4907382	1.0000000 1.0000000 1.0000000 0 0	7.0000000 9.0000000 10.0000000 1.0000000 1.0000000	4.0000000 5.0000000 5.0000000 1.0000000 1.0000000	3625 3625 3625 3625 3625	0 0 0 0 0
    	2017	3498	Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member	4.0437393 4.6329331 5.4765580 0.7481418 0.6177816	1.9829346 2.4520967 2.8817401 0.4341423 0.4859990	1.0000000 1.0000000 1.0000000 0 0	7.0000000 9.0000000 10.0000000 1.0000000 1.0000000	4.0000000 5.0000000 5.0000000 1.0000000 1.0000000	3498 3498 3498 3498 3498	0 0 0 0 0
    4	2016	3488	Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member	3.9650229 4.6662844 5.4440940 0.7428326 0.6002294	2.0276079 2.4055163 2.9074777 0.4371351 0.4899213	1.0000000 1.0000000 1.0000000 0 0	7.0000000 9.0000000 10.0000000 1.0000000 1.0000000	4.0000000 5.0000000 5.0000000 1.0000000 1.0000000	3488 3488 3488 3488 3487	0 0 0 0 1
    	2017	3584	Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member	3.9455915 4.6582031 5.4972098 0.7580915 0.6035156	1.9872880 2.4224678 2.8647030 0.4282989 0.4892354	1.0000000 1.0000000 1.0000000 0 0	7.0000000 9.0000000 10.0000000 1.0000000 1.0000000	4.0000000 5.0000000 5.0000000 1.0000000 1.0000000	3584 3584 3584 3584 3584	0 0 0 0 0
    5	2016	3533	Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member	4.0118879 4.6787433 5.4189074 0.7472403 0.5767271	1.9951456 2.4580497 2.8687807 0.4346558 0.4941478	1.0000000 1.0000000 1.0000000 0 0	7.0000000 9.0000000 10.0000000 1.0000000 1.0000000	4.0000000 5.0000000 5.0000000 1.0000000 1.0000000	3533 3533 3533 3533 3532	0 0 0 0 1
    	2017	3532	Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member	3.9949037 4.6868630 5.4963194 0.7364100 0.5821065	2.0033891 2.4034851 2.9178768 0.4406419 0.4932823	1.0000000 1.0000000 1.0000000 0 0	7.0000000 9.0000000 10.0000000 1.0000000 1.0000000	4.0000000 5.0000000 6.0000000 1.0000000 1.0000000	3532 3532 3532 3532 3532	0 0 0 0 0

Answer 1

Mode	Lower limit	Upper limit
3.953683	0.048686768	7.997630232
5.527902	-0.08148194	9.55358014
6.965402	-0.19416481	11.22876301
1.507812	-0.10710459	1.599292188
1.808594	-0.36631174	1.557717944
3.905134	0.147734288	7.947131712
5.574777	-0.10599744	9.53122064
3.966518	-0.06830654	11.10178874
1.507812	-0.10710459	1.599292188
1.819196	-0.37358147	1.554385072
4.016093	0.093669024	7.890237776
5.573807	-0.04006608	9.46625928
4.071587	-0.17073068	11.09914348
1.49556	-0.09407566	1.598515264
1.837958	-0.38616128	1.548203484
4.119818	0.057796792	7.822385008
5.576377	-0.08492414	9.508547136
3.998296	-0.17401244	11.17571604
1.51732	-0.11706248	1.59974268
1.839864	-0.3874222	1.5475584
4.040276	0.069944144	7.889780056
5.643862	-0.11489893	9.471036928
4.116138	-0.16188697	11.04574897
1.497103	-0.09572818	1.598624784
1.807724	-0.36570897	1.557984772
3.912521	0.157187484	7.930291116
5.734134	-0.17317643	9.439042632
4.046884	-0.1716526	11.1247686
1.503716	-0.10277711	1.599060708
1.764437	-0.33477644	1.57033964
4.069954	-0.00908858	7.939134384
5.667431	-0.04852755	9.381096348
4.111812	-0.25456229	11.14275029
1.514335	-0.1139522	1.599617396
1.799541	-0.36001635	1.560475148
4.108817	0.05050702	7.84067598
5.683594	-0.08983379	9.406239988
4.00558	-0.11760808	11.11202768
1.483817	-0.08137434	1.597557344
1.792969	-0.35538578	1.562416984
3.976224	0.101402524	7.922373276
5.642513	-0.13903411	9.496520712
4.162185	-0.20390277	11.04171757
1.505519	-0.10468507	1.599165668
1.846546	-0.39180259	1.545256788
4.010193	0.068261064	7.921546336
5.626274	-0.0239678	9.397693796
7.007361	-0.22271913	11.21535793
1.52718	-0.12724812	1.600068124
1.835787	-0.38472681	1.548939808

Outliers:

From this plot we see that the points below one are all outliers, they affect on the data.

This is the information about the variable Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member having comparison of two years 2016 and 2017 of six months.