Table 5 Descriptive overview of...

Table 5

Descriptive overview of activities on data cleaning in minutes

Dataset	Cleaning		Missing values		Wild codes		Skip pattern		Data protection		Labels		Sort variables
Dataset	In total	Per variable	In total	Per variable	In total	Per variable	In total	Per variable	In total	Per variable	In total	Per variable	In total	Per variable
Study 1 – wave 1	705	2.45	60	0.21	270	0.94	120	0.42	15	0.05	210	0.73	30	0.10
Study 1 – wave 2	465	1.94	60	0.25	165	0.69	90	0.38	15	0.06	120	0.50	15	0.06
Study 1 – wave 3	420	1.40	60	0.20	135	0.45	60	0.20	30	0.10	120	0.40	15	0.05
Study 1 – wave 4	1,515	2.18	60	0.09	165	0.24	120	0.17	855	1.23	300	0.43	15	0.02
Study 2 – wave 1	1,170	1.83	120	0.19	90	0.14	375	0.59	30	0.05	540	0.85	15	0.02
Study 2 – wave 2	1,080	1.88	60	0.10	90	0.16	480	0.84	30	0.05	405	0.71	15	0.03
Study 2 – wave 3	1,065	1.45	150	0.20	90	0.12	375	0.51	30	0.04	405	0.55	15	0.02
Study 2 – wave 4	1,425	1.64	210	0.24	180	0.21	540	0.62	30	0.03	450	0.52	15	0.02
Study 3 – wave 1	1,680	3.93	540	1.26	60	0.14	300	0.70	15	0.04	750	1.75	15	0.04
Study 3 – wave 2	2,535	4.04	540	0.86	30	0.05	1,260	2.01	30	0.05	660	1.05	15	0.02
Average (n = 8)	980.63	1.84	97.50	0.19	148.13	0.37	270.00	0.46	129.38	0.20	318.75	0.58	16.88	0.04
Std. dev.	412.66	0.36	57.26	0.06	61.81	0.30	192.93	0.22	293.28	0.42	156.86	0.16	5.30	0.03
Proportion	100.00		10.54		19.24		26.02		9.90		32.15		2.15
Average (n = 10)	1206.00	2.27	186.00	0.36	127.50	0.31	372.00	0.64	108.00	0.17	396.00	0.75	16.50	0.04
Std. dev.	631.51	0.96	193.29	0.38	70.09	0.29	355.51	0.52	262.56	0.37	214.73	0.41	4.74	0.03
Proportion	100.00		13.77		15.87		27.57		8.13		32.79		1.87

Dataset	Cleaning		Missing values		Wild codes		Skip pattern		Data protection		Labels		Sort variables
Dataset	In total	Per variable	In total	Per variable	In total	Per variable	In total	Per variable	In total	Per variable	In total	Per variable	In total	Per variable
Study 1 – wave 1	705	2.45	60	0.21	270	0.94	120	0.42	15	0.05	210	0.73	30	0.10
Study 1 – wave 2	465	1.94	60	0.25	165	0.69	90	0.38	15	0.06	120	0.50	15	0.06
Study 1 – wave 3	420	1.40	60	0.20	135	0.45	60	0.20	30	0.10	120	0.40	15	0.05
Study 1 – wave 4	1,515	2.18	60	0.09	165	0.24	120	0.17	855	1.23	300	0.43	15	0.02
Study 2 – wave 1	1,170	1.83	120	0.19	90	0.14	375	0.59	30	0.05	540	0.85	15	0.02
Study 2 – wave 2	1,080	1.88	60	0.10	90	0.16	480	0.84	30	0.05	405	0.71	15	0.03
Study 2 – wave 3	1,065	1.45	150	0.20	90	0.12	375	0.51	30	0.04	405	0.55	15	0.02
Study 2 – wave 4	1,425	1.64	210	0.24	180	0.21	540	0.62	30	0.03	450	0.52	15	0.02
Study 3 – wave 1	1,680	3.93	540	1.26	60	0.14	300	0.70	15	0.04	750	1.75	15	0.04
Study 3 – wave 2	2,535	4.04	540	0.86	30	0.05	1,260	2.01	30	0.05	660	1.05	15	0.02
Average (n = 8)	980.63	1.84	97.50	0.19	148.13	0.37	270.00	0.46	129.38	0.20	318.75	0.58	16.88	0.04
Std. dev.	412.66	0.36	57.26	0.06	61.81	0.30	192.93	0.22	293.28	0.42	156.86	0.16	5.30	0.03
Proportion	100.00		10.54		19.24		26.02		9.90		32.15		2.15
Average (n = 10)	1206.00	2.27	186.00	0.36	127.50	0.31	372.00	0.64	108.00	0.17	396.00	0.75	16.50	0.04
Std. dev.	631.51	0.96	193.29	0.38	70.09	0.29	355.51	0.52	262.56	0.37	214.73	0.41	4.74	0.03
Proportion	100.00		13.77		15.87		27.57		8.13		32.79		1.87