Example
Data Sorted Frequency
10 10 1
Frequency
20 10 2 3.5
22 18 1
3
10 20 1
18 20 2 2.5
32 22 1
2
20 30 1
30 30 2 1.5
40 30 3 1
45 32 1
45 40 1 0.5
30 45 1 0
30 45 2 5 10 15 20 25
Ques 11.
Data Frequency
0.31 1
0.35 1 6
0.36 1
0.36 2 5
0.37 1
0.38 1 4
0.4 1
3
0.4 2
0.41 1 2
0.41 2
0.42 1 1
0.42 2
0.42 3 0
0.2 0.3 0.4
0.42 4
0.42 5
0.43 1 Positively skewed
0.44 1 Mode-0.42
0.45 1 range = 0.75 - 0.31
0.46 1
0.46 2
0.47 1
0.48 1
0.48 2
0.48 3
0.51 1
0.54 1
0.54 2
0.55 1
0.58 1
0.62 1
0.66 1
0.66 2
0.67 1
0.68 1
0.75 1
Ques 16.
Data Frequency
5.8 1 F
6.1 1 3.5
6.6 1
3
7 1
7 2 2.5
7.1 1
2
7.2 1
7.4 1 1.5
7.8 1
1
7.8 2
8.1 1 0.5
8.3 1
0
8.3 2 5 6 7 8 9
8.3 3
8.5 1
8.9 1 Positively skewed
9.2 1 Mode-8.3
9.7 1 range= 14.1-5.8
9.8 1
11.2 1
12.6 1
14.1 1
Frequency
Negatively skewed
Mode-30
range = 45- 10
20 25 30 35 40 45 50
Frequency
0.4 0.5 0.6 0.7 0.8
Positively skewed
Mode-0.42
range = 0.75 - 0.31
Frequency
8 9 10 11 12 13 14 15
Data Unique Frequency relative frequency
10 10 2 0.153846
10 18 1 0.076923 3.5
18 20 2 0.153846
20 22 1 0.076923 3
20 30 3 0.230769 2.5
22 32 1 0.076923
30 40 1 0.076923 2
30 45 2 0.153846 1.5
30 13 1
32 1
40 0.5
45
45 0
10 18 20
10
20 Rel
30 0.25
40
50 0.2
0.15
Bin Frequency
10 2
0.1
20 3
30 4
0.05
40 2
50 2
More 0 0
10 18 20
Histogram
5
4
Frequency
3
2 Frequency
1
0
10 20 30 40 50 More
Bin
Frequency This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a differe
permanently break the chart.
10 18 20 22 30 32 40 45
Relative frequency
10 18 20 22 30 32 40 45
n your version of Excel.
ng this workbook into a different file format will
art.