lilliefors calculations with excel
DESCRIPTION
Lilliefors test as a test of normality not only be done with the statistical computing tools that are commonly used for research, but also the calculation can be done with Excel. Here is a working file tutorial. In this file you can see and learn his equations.TRANSCRIPT
![Page 1: Lilliefors Calculations with Excel](https://reader035.vdocuments.us/reader035/viewer/2022080922/577cc3cd1a28aba7119738c1/html5/thumbnails/1.jpg)
Statistik Variabel
N Sampel 100
Mean 33.440
Simpangan Baku 16.549
Variabel Zi F(zi) S(zi)
10 -1.416 0.078 0.010
12 -1.296 0.098 0.020
13 -1.235 0.108 0.030
14 -1.175 0.120 0.040
14 -1.175 0.120 0.050
14 -1.175 0.120 0.060
15 -1.114 0.133 0.070
15 -1.114 0.133 0.080
15 -1.114 0.133 0.090
15 -1.114 0.133 0.100
15 -1.114 0.133 0.110
15 -1.114 0.133 0.120
15 -1.114 0.133 0.130
16 -1.054 0.146 0.140
17 -0.993 0.160 0.150
17 -0.993 0.160 0.160
17 -0.993 0.160 0.170
18 -0.933 0.175 0.180
19 -0.873 0.191 0.190
20 -0.812 0.208 0.200
20 -0.812 0.208 0.210
20 -0.812 0.208 0.220
20 -0.812 0.208 0.230
20 -0.812 0.208 0.240
20 -0.812 0.208 0.250
20 -0.812 0.208 0.260
20 -0.812 0.208 0.270
20 -0.812 0.208 0.280
20 -0.812 0.208 0.290
20 -0.812 0.208 0.300
20 -0.812 0.208 0.310
20 -0.812 0.208 0.320
21 -0.752 0.226 0.330
21 -0.752 0.226 0.340
21 -0.752 0.226 0.350
21 -0.752 0.226 0.360
21 -0.752 0.226 0.370
21 -0.752 0.226 0.380
Uji Liliefors dg Excel
http://www.statistikian.com
By: Anwar Hidayat
![Page 2: Lilliefors Calculations with Excel](https://reader035.vdocuments.us/reader035/viewer/2022080922/577cc3cd1a28aba7119738c1/html5/thumbnails/2.jpg)
21 -0.752 0.226 0.390
21 -0.752 0.226 0.400
21 -0.752 0.226 0.410
21 -0.752 0.226 0.420
22 -0.691 0.245 0.430
23 -0.631 0.264 0.440
24 -0.570 0.284 0.450
25 -0.510 0.305 0.460
26 -0.450 0.327 0.470
27 -0.389 0.349 0.480
28 -0.329 0.371 0.490
29 -0.268 0.394 0.500
30 -0.208 0.418 0.510
31 -0.147 0.441 0.520
32 -0.087 0.465 0.530
33 -0.027 0.489 0.540
33 -0.027 0.489 0.550
33 -0.027 0.489 0.560
34 0.034 0.513 0.570
34 0.034 0.513 0.580
34 0.034 0.513 0.590
34 0.034 0.513 0.600
34 0.034 0.513 0.610
35 0.094 0.538 0.620
36 0.155 0.561 0.630
37 0.215 0.585 0.640
38 0.276 0.609 0.650
39 0.336 0.632 0.660
40 0.396 0.654 0.670
41 0.457 0.676 0.680
42 0.517 0.698 0.690
43 0.578 0.718 0.700
44 0.638 0.738 0.710
45 0.699 0.758 0.720
46 0.759 0.776 0.730
47 0.819 0.794 0.740
48 0.880 0.811 0.750
50 1.001 0.842 0.760
51 1.061 0.856 0.770
52 1.122 0.869 0.780
53 1.182 0.881 0.790
54 1.242 0.893 0.800
55 1.303 0.904 0.810
55 1.303 0.904 0.820
55 1.303 0.904 0.830
55 1.303 0.904 0.840
55 1.303 0.904 0.850
58 1.484 0.931 0.860
59 1.545 0.939 0.870
59 1.545 0.939 0.880
![Page 3: Lilliefors Calculations with Excel](https://reader035.vdocuments.us/reader035/viewer/2022080922/577cc3cd1a28aba7119738c1/html5/thumbnails/3.jpg)
59 1.545 0.939 0.890
59 1.545 0.939 0.900
59 1.545 0.939 0.910
59 1.545 0.939 0.920
59 1.545 0.939 0.930
60 1.605 0.946 0.940
61 1.665 0.952 0.950
62 1.726 0.958 0.960
63 1.786 0.963 0.970
63 1.786 0.963 0.980
63 1.786 0.963 0.990
63 1.786 0.963 1.000
Liliefors Hitung 0.194
Derajat Kepercayaan 0.050
Liliefors 0.886
Liliefors Tabel 0.089
Kesimpulan Tidak Normal
Uji Normalitas Liliefors
http://statistikian.blogspot.com/
![Page 4: Lilliefors Calculations with Excel](https://reader035.vdocuments.us/reader035/viewer/2022080922/577cc3cd1a28aba7119738c1/html5/thumbnails/4.jpg)
F(zi) - S(zi)
0.068
0.078
0.078
0.080
0.070
0.060
0.063
0.053
0.043
0.033
0.023
0.013
0.003
0.006
0.010
0.000
0.010
0.005
0.001
0.008
0.002
0.012
0.022
0.032
0.042
0.052
0.062
0.072
0.082
0.092
0.102
0.112
0.104
0.114
0.124
0.134
0.144
0.154
Uji Liliefors dg Excel
http://www.statistikian.com
By: Anwar Hidayat
![Page 5: Lilliefors Calculations with Excel](https://reader035.vdocuments.us/reader035/viewer/2022080922/577cc3cd1a28aba7119738c1/html5/thumbnails/5.jpg)
0.164
0.174
0.184
0.194
0.185
0.176
0.166
0.155
0.143
0.131
0.119
0.106
0.092
0.079
0.065
0.051
0.061
0.071
0.057
0.067
0.077
0.087
0.097
0.082
0.069
0.055
0.041
0.028
0.016
0.004
0.008
0.018
0.028
0.038
0.046
0.054
0.061
0.082
0.086
0.089
0.091
0.093
0.094
0.084
0.074
0.064
0.054
0.071
0.069
0.059
![Page 6: Lilliefors Calculations with Excel](https://reader035.vdocuments.us/reader035/viewer/2022080922/577cc3cd1a28aba7119738c1/html5/thumbnails/6.jpg)
0.049
0.039
0.029
0.019
0.009
0.006
0.002
0.002
0.007
0.017
0.027
0.037
http://statistikian.blogspot.com/