Test task - Product Analyst [Apalon].xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2	Task 1
3
4	The data below represents usage statistics of some application.
5	Please, analyze the data and answer the following questions:
6
7	1. Describe how the app* metrics were developing during the last year. What trends do you observe? Provide your explanation of the trends and mention all details that may matter.
8	2. Can you say from the data below what caused average session growth at the end of December 2015 and its drop in the beginning of June 2016?
9	3. What other useful metrics can be calculated from the data presented in the table?
10	4. Present the findings of your analysis in a form that will be understandable to TOP management. Use any tools you consider to be the best ones for carrying out the analyisis and visualization your findings.
11
12	*app - short form of "application"
13
14
15
16
17								Number of active users by frequency of use per day
18	Date	Median Session Length	Total Time Spent in App by all users	Avg Session Length	New Users	Active Users	Sessions	1 session	2 sessions	3 - 4 sessions	5 - 6 sessions	7 - 9 sessions	10 - 14 sessions	15 - 19 sessions	20+ sessions	# of events A	Unique users performing event A
19	06/19/16	22 sec	21 yr 5 mo 1 dy 7 hr 3 min 44 sec	4 min 30 sec	68986	935285	2774516	330974	217470	226516	87329	45076	18957	5014	3949	353441	182678
20	06/18/16	23 sec	18 yr 8 mo 26 dy 12 hr 45 min 9 sec	5 min 2 sec	59566	708737	2188128	234261	171753	175983	67189	35187	15893	4618	3853	303344	152762
21	06/17/16	23 sec	22 yr 19 dy 1 hr 6 min 45 sec	4 min 48 sec	64206	852716	2714947	256561	208925	224111	87680	45836	19846	5466	4291	412847	209385
22	06/16/16	23 sec	24 yr 6 mo 15 dy 21 hr 12 min 50 sec	4 min 39 sec	68887	937587	3100061	251756	232083	260105	105015	55020	22837	6036	4735	494249	249479
23	06/15/16	23 sec	25 yr 7 mo 4 dy 20 hr 44 min 35 sec	4 min 47 sec	64074	943355	3129072	251174	234413	262303	105291	55799	23407	6193	4775	511688	256263
24	06/14/16	23 sec	25 yr 1 mo 3 dy 13 hr 32 min 36 sec	4 min 38 sec	73035	960366	3133504	259186	240914	266358	105831	55180	23017	5754	4126	508137	260442
25	06/13/16	23 sec	26 yr 2 mo 23 dy 1 hr 16 min 17 sec	4 min 39 sec	76229	991243	3229711	274456	244778	272503	109033	56892	23463	5943	4175	519880	264246
26	06/12/16	22 sec	23 yr 7 mo 18 dy 12 hr 38 min 33 sec	4 min 51 sec	89293	950773	2774342	344662	221134	227146	86903	44141	18513	4867	3407	371020	185585
27	06/11/16	23 sec	21 yr 6 mo 22 dy 1 hr 20 min 22 sec	5 min 35 sec	79101	720978	2187991	241359	176520	177761	67103	35048	15541	4332	3314	328895	159767
28	06/10/16	23 sec	28 yr 1 mo 12 dy 4 hr 50 min 12 sec	5 min 49 sec	72021	863026	2713261	262381	212904	225568	87809	45649	19549	5302	3864	500624	229401
29	06/09/16	24 sec	38 yr 5 mo 16 dy 18 hr 52 min 22 sec	6 min 41 sec	78662	949433	3129823	256448	235483	263184	105406	55381	23158	5963	4410	716157	302685
30	06/08/16	25 sec	44 yr 27 dy 16 hr 23 min 37 sec	7 min 25 sec	88883	964458	3188694	258861	238782	267210	108385	56786	23911	6061	4462	789167	324672
31	06/07/16	25 sec	44 yr 9 mo 7 hr 16 min 0 sec	7 min 30 sec	92804	971821	3202811	262286	240685	268878	108335	57384	23717	6046	4490	797799	327098
32	06/06/16	25 sec	46 yr 2 mo 15 dy 1 hr 17 min 19 sec	7 min 38 sec	106015	993224	3247491	274850	244152	272165	109466	58267	23900	5900	4524	799147	327346
33	06/05/16	24 sec	39 yr 7 mo 18 dy 22 hr 14 min 10 sec	7 min 58 sec	72818	902288	2676695	319132	209777	219179	84452	43436	17830	4684	3798	560906	228629
34	06/04/16	24 sec	31 yr 5 mo 22 dy 54 min 12 sec	8 min 43 sec	50208	642714	1936625	217256	157285	157836	59423	30748	13377	3743	3046	452321	180302
35	06/03/16	25 sec	38 yr 7 mo 19 hr 44 min 10 sec	8 min 21 sec	49136	789930	2476191	240857	196200	205743	79662	41537	17498	4738	3695	657891	262297
36	06/02/16	25 sec	36 yr 5 mo 21 dy 3 hr 39 min 29 sec	9 min 8 sec	44254	836645	2495314	255442	217826	223112	80318	38561	14989	3641	2756	566118	245654
37	06/01/16	24 sec	31 yr 2 mo 27 dy 23 hr 17 min 30 sec	7 min 44 sec	37511	832866	2514424	254852	214556	219606	80904	40143	15873	4070	2862	610286	261153
38	05/31/16	24 sec	42 yr 3 mo 14 dy 23 hr 12 min 18 sec	7 min 58 sec	39731	872322	2856902	232975	218961	243511	96754	50097	20793	5312	3919	772524	313802
39	05/30/16	24 sec	43 yr 4 mo 27 dy 8 hr 11 min 19 sec	8 min 35 sec	39319	872033	2707729	266862	215241	229422	88372	45137	18475	4749	3775	685331	272633
40	05/29/16	24 sec	36 yr 2 mo 22 dy 6 hr 24 min 20 sec	8 min 9 sec	39664	806172	2392926	282465	189387	197492	75117	38255	15808	4245	3403	537150	217347
41	05/28/16	24 sec	29 yr 1 mo 19 dy 5 hr 30 min 21 sec	8 min 27 sec	32856	614154	1852475	208906	150162	150232	56539	29047	12654	3722	2892	432319	175011
42	05/27/16	25 sec	36 yr 7 mo 7 dy 14 hr 58 min 45 sec	8 min 12 sec	33569	764772	2390536	233527	189441	199976	76767	40026	16938	4612	3485	633439	256318
43	05/26/16	25 sec	43 yr 7 mo 17 dy 11 hr 52 min 54 sec	8 min 21 sec	38585	858669	2801739	233354	213353	238158	94476	49556	20500	5310	3962	759474	308685
44	05/25/16	24 sec	41 yr 12 mo 3 dy 10 hr 55 min 21 sec	7 min 58 sec	38835	869260	2818120	236131	218695	240135	95425	49820	20325	5073	3656	743707	310939
45	05/24/16	24 sec	43 yr 7 mo 3 dy 20 hr 3 min 8 sec	8 min 3 sec	37487	884717	2896923	235156	222064	246715	99273	51224	21205	5337	3743	745622	334746
46	05/23/16	24 sec	44 yr 1 mo 22 dy 23 hr 59 min 41 sec	7 min 59 sec	37876	908138	2959216	248645	225567	249390	100521	52793	21824	5470	3928	736081	337555
47	05/22/16	24 sec	38 yr 3 mo 26 dy 20 hr 2 min 25 sec	8 min 10 sec	42549	859536	2524967	306102	200868	207526	79463	40788	16884	4488	3417	505589	236231
48	05/21/16	24 sec	30 yr 6 mo 6 dy 4 hr 10 min 8 sec	8 min 47 sec	31438	616374	1862098	208735	150423	150790	56750	30055	13072	3673	2876	396608	186221
49	05/20/16	25 sec	38 yr 1 mo 1 dy 20 hr 35 min 50 sec	8 min 13 sec	31924	781876	2477156	234847	193080	204319	80340	42418	18513	4788	3571	618002	282602
50	05/19/16	24 sec	44 yr 11 mo 26 dy 18 hr 59 min 37 sec	8 min 18 sec	34353	871795	2902503	228006	215483	244600	99249	52881	21805	5532	4239	750441	339836
51	05/18/16	24 sec	43 yr 2 mo 13 dy 8 hr 47 min 4 sec	7 min 52 sec	34590	879658	2928849	225576	218362	248895	101955	53739	21974	5379	3778	751472	344387
52	05/17/16	24 sec	43 yr 11 mo 22 dy 35 min 6 sec	8 min 1 sec	35997	887893	2927133	232123	222622	249359	100114	52928	21656	5334	3757	755345	346046
53	05/16/16	24 sec	44 yr 7 mo 13 dy 7 hr 47 min 38 sec	7 min 58 sec	36559	912641	2993329	244245	226534	253441	102596	53918	22427	5535	3945	749933	343591
54	05/15/16	24 sec	37 yr 5 mo 12 dy 14 hr 45 min 59 sec	8 min 16 sec	40162	843724	2438333	312216	195403	197956	75558	38900	16111	4327	3253	474686	222230
55	05/14/16	24 sec	29 yr 8 mo 3 dy 22 hr 28 min 14 sec	8 min 34 sec	30046	618941	1858905	209700	151163	151871	56986	29834	12978	3656	2753	404697	186981
56	05/13/16	25 sec	37 yr 10 mo 3 dy 20 hr 7 min 28 sec	8 min 10 sec	31290	784968	2479670	236705	192939	206318	80415	42279	18065	4692	3555	619366	283961
57	05/12/16	24 sec	44 yr 11 mo 23 dy 12 hr 27 min 23 sec	8 min 15 sec	33978	876689	2922064	229513	217768	245272	99353	52722	22266	5614	4181	757033	340974
58	05/11/16	24 sec	44 yr 7 mo 27 dy 2 hr 34 min 27 sec	8 min 9 sec	35484	883518	2924421	229814	222086	247602	100143	52945	21828	5307	3793	757328	345550
59	05/10/16	24 sec	43 yr 1 mo 3 dy 1 hr 52 min 24 sec	7 min 49 sec	36120	890846	2947391	232397	223508	250025	100453	53201	22071	5332	3859	757454	345746
60	05/09/16	24 sec	45 yr 7 mo 14 dy 43 min 47 sec	8 min 10 sec	36281	908756	2982925	244272	225228	251998	101830	53729	22243	5501	3955	754457	343772
61	05/08/16	24 sec	38 yr 7 mo 1 dy 2 hr 5 min 58 sec	8 min 23 sec	39922	848181	2473104	309362	195895	202144	76863	39599	16650	4291	3377	491726	228282
62	05/07/16	24 sec	30 yr 4 mo 3 dy 22 hr 42 min 55 sec	8 min 38 sec	32044	623154	1882925	209887	151752	153622	57953	30143	13228	3664	2905	402189	189600
63	05/06/16	25 sec	38 yr 2 mo 9 dy 13 hr 55 min 9 sec	8 min 12 sec	32251	782687	2488779	233217	192614	205658	81433	43025	18271	4852	3617	623617	285292
64	05/05/16	24 sec	44 yr 8 mo 12 dy 6 hr 21 min 29 sec	8 min 20 sec	34697	859242	2873380	224724	211376	241196	97923	52407	21870	5555	4191	736363	332998
65	05/04/16	24 sec	42 yr 8 mo 12 dy 23 hr 32 min 31 sec	8 min 4 sec	35409	862363	2830483	232624	213246	238652	96003	51648	21147	5317	3726	724001	329712
66	05/03/16	24 sec	44 yr 27 dy 12 hr 6 min 55 sec	8 min 0 sec	38542	890923	2946228	231572	223349	250642	100976	53119	21982	5499	3784	754177	346168
67	05/02/16	24 sec	42 yr 7 mo 2 dy 19 hr 13 min 42 sec	7 min 44 sec	39897	896789	2947910	245282	220953	246759	99641	52607	21944	5592	4011	730825	333463
68	05/01/16	24 sec	39 yr 1 mo 1 dy 4 hr 52 min 46 sec	8 min 53 sec	42901	832284	2369124	319326	190517	190622	71905	36895	15610	4040	3369	456387	211854
69	04/30/16	24 sec	31 yr 4 mo 12 dy 30 min 9 sec	9 min 1 sec	32472	619600	1866155	211118	150640	151716	56747	29560	13047	3849	2923	398706	186623
70	04/29/16	25 sec	38 yr 1 mo 18 dy 11 hr 8 sec	8 min 13 sec	33143	784785	2484679	237630	192944	204503	80348	42424	18262	4983	3691	625761	284658
71	04/28/16	24 sec	45 yr 4 mo 14 dy 15 hr 15 min 51 sec	8 min 22 sec	34502	874281	2909480	230972	216759	243199	98584	52872	22058	5679	4158	756166	341067
72	04/27/16	24 sec	43 yr 11 mo 15 dy 16 hr 10 min 51 sec	7 min 59 sec	34798	885267	2939677	231382	221423	247366	100630	53271	21893	5453	3849	764941	349117
73	04/26/16	24 sec	45 yr 8 mo 11 dy 12 hr 29 min 40 sec	8 min 14 sec	35230	892266	2963921	232478	223050	250185	101308	53691	22251	5397	3906	772137	351408
74	04/25/16	24 sec	44 yr 5 mo 21 dy 3 hr 59 min 11 sec	7 min 50 sec	35639	920817	3035790	246014	227699	256182	103757	55060	22482	5683	3940	770943	352407
75	04/24/16	24 sec	41 yr 9 mo 24 dy 23 hr 46 min 3 sec	8 min 50 sec	41085	875002	2544340	317557	203034	208934	80095	40741	16926	4331	3384	509661	238638
76	04/23/16	24 sec	33 yr 1 mo 15 dy 22 hr 39 min 45 sec	9 min 28 sec	30310	621389	1872522	210521	151602	151999	57276	30095	13267	3666	2963	403617	189318
77	04/22/16	25 sec	40 yr 2 mo 24 dy 9 hr 15 min 55 sec	8 min 37 sec	32338	786512	2496528	236355	193372	205938	81414	42803	18123	4870	3637	626938	285961
78	04/21/16	24 sec	48 yr 8 mo 23 dy 12 hr 1 min 41 sec	9 min 0 sec	34068	874755	2897881	232680	215821	243229	98751	52584	21944	5576	4170	753305	339328
79	04/20/16	24 sec	47 yr 4 mo 14 dy 11 hr 18 min 4 sec	8 min 32 sec	34779	893039	2961223	231805	223017	251412	101855	53392	22227	5528	3803	765894	348066
80	04/19/16	24 sec	47 yr 3 mo 1 dy 8 hr 36 min 30 sec	8 min 21 sec	37600	907876	3020421	235055	225055	256016	104320	55044	22897	5625	3864	768490	350792
81	04/18/16	24 sec	46 yr 9 mo 3 dy 23 hr 34 min 34 sec	8 min 1 sec	40756	937130	3117756	247922	228273	262082	107835	56976	24013	5921	4108	779158	356143
82	04/17/16	24 sec	43 yr 2 mo 2 dy 8 hr 14 min 36 sec	8 min 44 sec	46222	896339	2656157	318171	205705	217799	85068	43577	17853	4705	3461	527354	246869
83	04/16/16	24 sec	33 yr 2 mo 3 dy 7 hr 10 min 58 sec	9 min 9 sec	35248	637018	1943576	213386	153237	157612	60462	31645	13860	3846	2970	410065	193666
84	04/15/16	25 sec	40 yr 11 mo 26 dy 20 hr 58 min 4 sec	8 min 25 sec	36470	807261	2598855	238819	195192	213197	85990	45548	19589	5049	3877	648697	296770
85	04/14/16	24 sec	48 yr 11 mo 17 dy 18 hr 17 min 45 sec	8 min 39 sec	39366	894494	3031715	228942	216569	253516	105004	56686	23446	6033	4298	786967	356684
86	04/13/16	24 sec	47 yr 8 mo 7 dy 17 hr 16 min 43 sec	8 min 19 sec	40307	903109	3057758	226097	219784	259837	107416	56838	23500	5767	3870	790417	361807
87	04/12/16	24 sec	47 yr 10 mo 7 dy 9 hr 13 min 14 sec	8 min 12 sec	42409	914063	3112436	228299	220673	262861	109703	58631	24010	5826	4060	798761	365102
88	04/11/16	24 sec	48 yr 11 mo 18 dy 5 hr 11 min 56 sec	8 min 9 sec	45975	946916	3204700	242023	226604	269738	113417	60326	24707	5971	4130	795902	364820
89	04/10/16	23 sec	45 yr 28 dy 6 hr 15 min 19 sec	8 min 48 sec	53570	918195	2747968	320001	208985	226689	89822	45519	18828	4761	3590	531989	249167
90	04/09/16	24 sec	35 yr 1 mo 11 dy 1 hr 14 min 32 sec	9 min 32 sec	41648	641368	1972147	213177	152943	159951	61814	32417	14006	4021	3039	409661	194076
91	04/08/16	25 sec	43 yr 7 mo 4 dy 14 hr 57 min 30 sec	8 min 56 sec	43262	810224	2606035	239487	197192	213887	85471	45722	19435	5220	3810	653404	301563
92	04/07/16	25 sec	52 yr 7 mo 23 dy 12 hr 43 min 11 sec	9 min 27 sec	43612	889985	2978287	233113	220835	248230	101294	53652	22776	5732	4353	811821	371091
93	04/06/16	25 sec	51 yr 8 mo 23 dy 10 hr 33 min 32 sec	9 min 22 sec	45942	892799	2942115	235961	224828	248650	99477	52692	21831	5501	3859	826479	381334
94	04/05/16	25 sec	52 yr 18 dy 12 hr 27 min 39 sec	9 min 22 sec	46319	897553	2963977	237144	226738	249944	99204	53025	21995	5508	3995	825835	383728
95	04/04/16	25 sec	51 yr 10 mo 11 dy 2 hr 47 min 36 sec	9 min 11 sec	50908	923917	3014644	253837	230861	253179	101008	53181	22174	5632	4045	806212	372911
96	04/03/16	24 sec	47 yr 3 mo 9 dy 3 hr 23 min 17 sec	9 min 55 sec	56457	883239	2559155	323934	205031	209556	79465	40749	16767	4369	3368	544491	257807
97	04/02/16	25 sec	36 yr 4 mo 20 dy 2 hr 51 min 39 sec	10 min 29 sec	43232	618633	1857624	209825	152125	151198	56518	29545	12864	3681	2877	419479	202203
98	04/01/16	25 sec	43 yr 6 mo 8 dy 17 hr 43 min 41 sec	9 min 37 sec	43548	768059	2415514	233024	191217	200496	77432	40389	17261	4724	3516	643319	300127
99	03/31/16	25 sec	50 yr 2 mo 11 hr 27 min 4 sec	9 min 38 sec	43804	844994	2785976	226879	210542	234033	93934	49631	20621	5275	4079	777428	355049
100	03/30/16	25 sec	48 yr 1 mo 17 dy 16 hr 26 min 50 sec	9 min 18 sec	41858	844277	2758093	225363	213832	234393	92808	48829	20406	5111	3535	775234	357388