File Latihan Excel
File Latihan Excel
File Latihan Excel
Xi
40 - 49 5 44.5 222.5
50 - 59 5 54.5 272.5
60 - 69 4 64.5 258
70 - 79 5 74.5 372.5
80 - 89 3 84.5 253.5
90 - 99 5 94.5 472.5
100 - 109 7 104.5 731.5
34
No Nilai
1 90 Mean 75.85 Column1
2 67 Median 78
3 56 Modus 78 Mean 75.85
4 78 Standard Error 2.887609647 SQRT
5 90 QUARTIL 1 67 Median 78
6 55 QUARTIL 2 78 Mode 78
7 56 QUARTIL 3 89 Standard Deviation 12.913782927
8 78 DESIL 1 56 Sample Variance 166.76578947
9 67 DESIL 2 58.2 Kurtosis -1.1673276964
10 89 DESIL 3 67 Skewness -0.4605715149
11 67 PERSENTIL 1 55.19 Range 35
12 89 55.19 Minimum 55
13 56 PERSENTIL 99 90 Maximum 90
14 78 PERSENTIL 22 62.82 Sum 1517
15 90 Count 20
16 78
17 89
18 77 2.887609647 SQRT
19 89
20 78
80
71.26042
70.5
63