Question

Answer the following application exercise on organization and data visualization.

You can use Excel.
If you use the calculator and perform the exercise manually, obtain a picture of the process performed using the cutout and pasting its result into a Word file.
A sample of 30 employees who investigate cases of possible money laundering, answered a survey on the average time in the days analyzed, presented results and recommendations. Below, your answers are detailed.

5 22 20 16 13 6 12 26 13 24 15 5 14 14 24 11 24 24 24 19 17 10 16 18 11 13 10 13 12 24

Summarize these data:

Use of the base of the frequency distribution table.
Calculating the measures of variation: range, variance, standard deviation and coefficient of variation, taking into account the average of the test 3.
Click on a comment to indicate when.

Answer 1

Sr. no	X	(X - X̄)²
1	5	117.361
2	22	38.028
3	20	17.361
4	16	0.028
5	13	8.028
6	6	96.694
7	12	14.694
8	26	103.4
9	13	8.028
10	24	66.694
11	15	0.694
12	5	117.361
13	14	3.361
14	14	3.36
15	24	66.694
16	11	23.361
17	24	66.694
18	24	66.694
19	24	66.69444
20	19	10.028
21	17	1.361
22	10	34.028
23	16	0.028
24	18	4.694
25	11	23.361
26	13	8.027778
27	10	34.02778
28	13	8.027778
29	12	14.69444
30	24	66.69444

	X	(X - X̄)²
total sum	475	1090.167
n	30	30

mean =    ΣX/n =    475.000   /   30.000   =   15.833
                      
sample variance =    Σ(X - X̄)²/(n-1)=   1090.1667   /   29.0000   =   37.5920
                      
sample std dev =   √ [ Σ(X - X̄)²/(n-1)] =   √   37.5920   =       6.1312

range=max-min =    26   -   5   =   21

coefficient of variation,CV=mean / std dev =   0.3872