Analisis Deskriptif

1 Hitung rata-rata tinggi, berat, IPK dan modus tahun lahir

2 Hitung variance dan standard deviation untuk tinggi, berat, dan IPK
3 Buat histogram tinggi, berat, IPK, tahun lahir
4 Pelajari cara membuat kurva normal di tab Normal Distribution
5 Pelajari kurva normal yang dihasilkan
6 Hitung probabilitas
7 Hitung expected value dari tinggi, berat, IPK, dan tahun kelahiran

Analisis Linear Regresi Sederhana

1 Beri nama range: TINGGI, BERAT, IPK
2 Hitung covariance
3 Buat matrix covariance
4 Hitung correlation
5 Buat matrix correlation
6 Buat scatterplot dan persamaan regresi
7 Hitung slope (beta)
8 Hitung intercept (alpha)
9 Hitung koefisien determinasi (R2)

Analisis Multiple Regression

DATA MAHASISWA MM Variance
Student ID Tinggi (cm) Berat (kg) IPK Tahun kelahiran (t - tbar) ^2 (b - bbar) ^2 (i - ibar) ^2
1 175.0 75.9 2.89 2005 36.07 0.03 0.04
2 168.6 75.0 3.23 1979 0.12 1.08 0.02
3 176.5 78.7 3.48 1978 56.48 7.03 0.16
4 185.2 81.7 3.58 1993 264.67 32.17 0.25
5 167.7 75.1 2.64 2004 1.70 0.91 0.20
6 167.7 76.3 2.78 2004 1.70 0.03 0.09
7 185.8 87.4 3.45 2005 283.27 127.72 0.13
8 177.7 80.3 3.33 1987 75.91 17.85 0.06
9 165.3 74.9 3.18 2001 13.37 1.38 0.01
10 175.4 78.8 3.90 1993 41.78 7.37 0.67
11 165.4 70.6 3.18 1992 12.93 30.25 0.01
12 165.3 74.4 3.37 2001 13.10 2.98 0.08
13 172.4 77.7 3.40 1981 11.96 2.66 0.10
14 150.9 72.8 3.07 1982 327.41 10.63 0.00
15 152.8 68.4 2.77 1992 262.79 59.66 0.09
16 164.4 74.6 3.24 1994 21.02 2.26 0.03
17 159.9 71.9 2.73 2004 82.63 17.68 0.13
18 173.1 75.6 3.04 1999 17.48 0.25 0.00
19 160.9 74.7 2.84 1986 64.67 1.90 0.06
20 155.9 71.6 2.94 1989 171.21 19.61 0.02
21 184.7 84.7 3.96 1994 246.33 73.96 0.78
22 167.7 73.7 2.49 1991 1.49 5.82 0.36
23 170.7 79.6 3.31 1982 2.94 12.48 0.05
24 155.8 67.3 2.41 1988 174.48 77.31 0.45
25 164.6 75.2 2.88 2005 19.41 0.73 0.04
26 171.1 81.4 3.44 1981 4.61 28.12 0.13
27 158.5 69.3 2.95 1988 109.65 45.40 0.02
28 173.8 77.1 2.80 1981 23.00 0.96 0.08
29 164.0 74.0 2.80 1978 24.68 4.33 0.08
30 167.1 74.2 3.25 1976 3.53 3.60 0.03
31 164.0 70.7 2.77 1997 24.79 29.01 0.09
32 188.5 85.0 3.38 1983 382.64 79.12 0.09
33 169.9 74.3 3.08 2000 0.82 3.11 0.00
34 159.4 72.7 2.76 1988 90.99 11.49 0.10
35 178.2 78.4 3.82 1985 85.82 5.22 0.54
36 157.8 74.1 3.14 1974 124.77 3.89 0.00
37 172.1 75.9 2.49 2004 9.78 0.04 0.35
38 150.4 67.0 2.90 1981 344.41 81.72 0.03
39 156.7 72.2 2.73 1994 149.90 15.42 0.12
40 172.0 74.9 3.35 1990 9.04 1.33 0.07
41 177.4 80.3 2.94 2005 70.95 17.65 0.02
42 171.7 79.9 3.08 1992 7.57 14.50 0.00
43 168.8 72.8 3.20 1985 0.01 10.97 0.01
44 167.0 75.5 3.31 1983 3.89 0.32 0.05
45 155.2 70.4 2.54 2000 188.97 32.61 0.29
46 162.8 74.8 2.90 1974 37.95 1.57 0.03
47 165.4 72.0 2.87 2004 12.73 17.01 0.04
48 180.6 78.6 3.00 1992 134.78 6.45 0.01
49 173.4 79.1 3.66 1998 20.02 9.08 0.33
50 152.4 69.2 2.99 1980 275.29 47.85 0.01
51 173.2 78.5 2.75 1987 18.31 5.67 0.11
52 166.1 75.5 3.31 1981 7.91 0.38 0.05
53 163.2 72.1 3.63 1978 32.84 15.87 0.30
54 176.1 79.7 3.47 1979 51.20 13.25 0.15
55 180.3 81.7 2.76 1986 128.79 31.90 0.11
56 179.3 79.3 3.04 1976 107.15 10.14 0.00
57 161.6 76.5 3.38 1982 54.08 0.14 0.09
58 166.9 76.1 2.84 1978 4.22 0.00 0.06
59 173.3 75.6 3.24 1996 18.93 0.22 0.03
60 179.8 82.2 3.44 1971 116.51 37.52 0.13
61 165.2 72.4 2.74 1974 14.09 13.56 0.12
62 168.1 77.2 3.05 1998 0.67 1.35 0.00
63 158.9 73.8 1.99 1988 100.50 5.01 1.20
64 158.0 69.5 2.62 1977 119.33 43.58 0.21
65 178.1 82.1 3.12 1970 83.97 36.07 0.00
66 183.6 83.4 2.88 1991 213.19 54.04 0.04
67 169.3 77.8 3.57 1986 0.10 3.04 0.24
68 180.0 84.8 2.80 1976 122.63 76.25 0.08
69 173.6 77.6 2.99 1994 21.67 2.43 0.01
70 163.5 72.1 3.04 1973 29.30 15.90 0.00
71 173.6 76.3 3.55 2005 21.65 0.07 0.22
72 185.4 81.8 2.83 1975 269.58 32.63 0.06
73 169.6 76.2 3.43 2000 0.46 0.01 0.12
74 185.6 84.2 3.28 1988 278.39 66.36 0.04
75 143.8 65.3 2.47 1996 632.97 116.92 0.37
76 178.2 81.9 3.33 1979 85.70 33.36 0.06
77 170.9 76.9 3.15 1995 3.64 0.71 0.01
78 167.0 78.1 2.88 1988 3.81 3.94 0.04
79 170.9 76.4 3.11 1972 3.83 0.09 0.00
80 150.1 73.0 2.75 1982 354.84 9.49 0.11
81 167.8 76.8 3.10 1997 1.34 0.47 0.00
82 173.6 76.4 3.32 1989 21.25 0.10 0.05
83 184.8 81.0 3.73 1997 250.19 24.32 0.42
84 164.8 75.1 2.65 1977 17.17 0.89 0.18
85 161.9 72.4 3.62 1970 49.65 13.41 0.29
86 165.0 75.7 2.44 1972 15.83 0.17 0.41
87 179.2 81.6 3.15 1982 103.89 30.12 0.01
88 173.3 77.8 3.30 1997 18.71 3.09 0.05
89 164.7 72.4 3.09 1994 18.14 13.36 0.00
90 175.1 75.8 2.94 2002 38.08 0.09 0.02
91 171.0 76.0 3.03 1975 4.04 0.00 0.00
92 179.7 82.6 3.06 2001 115.02 42.18 0.00
93 163.0 73.8 2.82 1990 35.79 5.33 0.07
94 166.7 72.5 3.28 1985 5.01 12.55 0.04
 95 166.1 75.1 3.14 1990 8.31 0.99 0.00
96 155.4 70.7 2.70 1980 184.87 29.08 0.15
97 173.0 76.1 3.38 2005 16.00 0.00 0.09
98 172.6 78.0 3.21 2004 13.32 3.63 0.02
99 170.1 76.6 3.33 1988 1.19 0.32 0.06
100 167.7 73.2 3.23 1989 1.71 8.52 0.02
Total 16,896.2 7,607.7 308.2 Variance 82.48 18.21 0.12
Average 168.96 76.08 3.08 1988 Modus Std Dev 9.08 4.27 0.35
168.96 76.08 3.08 1970 Min
2005 Max
Variance 82.48 18.21 0.12
Std Dev 9.08 4.27 0.35

Jumlah
1970 2
1971 1
1972 2
1973 1
1974 3
1975 2
1976 3
1977 2
1978 4
1979 3
1980 2
1981 5
1982 5
1983 2
1984 0
1985 3
1986 3
1987 2
1988 7
1989 3
1990 3
1991 2
1992 4
1993 2
1994 5
1995 1
1996 2
1997 4
1998 2
1999 1
2000 3
2001 3
2002 1
2003 0
2004 6
2005 6
100
Student ID Tinggi Berat IPK Student ID Tinggi (sortedNORM Student ID Berat (sorted
1 175.0 75.9 2.89 75 143.8 0.00094675 75 65.3
2 168.6 75.0 3.23 80 150.1 0.00511105 38 67.0
3 176.5 78.7 3.48 38 150.4 0.00544475 24 67.3
4 185.2 81.7 3.58 14 150.9 0.00603593 15 68.4
5 167.7 75.1 2.64 50 152.4 0.00827843 50 69.2
6 167.7 76.3 2.78 15 152.8 0.00893042 27 69.3
7 185.8 87.4 3.45 45 155.2 0.01397046 64 69.5
8 177.7 80.3 3.33 96 155.4 0.01432235 45 70.4
9 165.3 74.9 3.18 24 155.8 0.01525365 11 70.6
10 175.4 78.8 3.90 20 155.9 0.01555925 96 70.7
11 165.4 70.6 3.18 39 156.7 0.01770442 31 70.7
12 165.3 74.4 3.37 36 157.8 0.02061821 20 71.6
13 172.4 77.7 3.40 64 158.0 0.02130993 17 71.9
14 150.9 72.8 3.07 27 158.5 0.02259697 47 72.0
15 152.8 68.4 2.77 63 158.9 0.02388633 70 72.1
16 164.4 74.6 3.24 34 159.4 0.02530431 53 72.1
17 159.9 71.9 2.73 17 159.9 0.02661987 39 72.2
18 173.1 75.6 3.04 19 160.9 0.02968101 61 72.4
19 160.9 74.7 2.84 57 161.6 0.03164961 85 72.4
20 155.9 71.6 2.94 85 161.9 0.03250999 89 72.4
21 184.7 84.7 3.96 46 162.8 0.0349012 94 72.5
22 167.7 73.7 2.49 93 163.0 0.03536127 34 72.7
23 170.7 79.6 3.31 53 163.2 0.03599794 43 72.8
24 155.8 67.3 2.41 70 163.5 0.03677969 14 72.8
25 164.6 75.2 2.88 31 164.0 0.03779943 80 73.0
26 171.1 81.4 3.44 29 164.0 0.03782378 100 73.2
27 158.5 69.3 2.95 16 164.4 0.0386732 22 73.7
28 173.8 77.1 2.80 25 164.6 0.03905242 93 73.8
29 164.0 74.0 2.80 89 164.7 0.03935352 63 73.8
30 167.1 74.2 3.25 84 164.8 0.03958455 29 74.0
31 164.0 70.7 2.77 86 165.0 0.03990777 36 74.1
32 188.5 85.0 3.38 61 165.2 0.04033247 30 74.2
33 169.9 74.3 3.08 9 165.3 0.04050859 33 74.3
34 159.4 72.7 2.76 12 165.3 0.04057555 12 74.4
35 178.2 78.4 3.82 11 165.4 0.0406166 16 74.6
36 157.8 74.1 3.14 47 165.4 0.04066564 19 74.7
37 172.1 75.9 2.49 95 166.1 0.04177017 46 74.8
38 150.4 67.0 2.90 52 166.1 0.04187162 9 74.9
39 156.7 72.2 2.73 94 166.7 0.04261426 40 74.9
40 172.0 74.9 3.35 58 166.9 0.04281931 2 75.0
41 177.4 80.3 2.94 44 167.0 0.04290414 95 75.1
42 171.7 79.9 3.08 78 167.0 0.04292555 5 75.1
43 168.8 72.8 3.20 30 167.1 0.0429985 84 75.1
44 167.0 75.5 3.31 100 167.7 0.04347538 25 75.2
45 155.2 70.4 2.54 5 167.7 0.04347836 52 75.5
46 162.8 74.8 2.90 6 167.7 0.04347847 44 75.5
47 165.4 72.0 2.87 22 167.7 0.04353409 18 75.6
48 180.6 78.6 3.00 81 167.8 0.04357241 59 75.6
49 173.4 79.1 3.66 62 168.1 0.04375034 86 75.7
50 152.4 69.2 2.99 2 168.6 0.04389669 90 75.8
51 173.2 78.5 2.75 43 168.8 0.04392452 37 75.9
52 166.1 75.5 3.31 67 169.3 0.04390124 1 75.9
53 163.2 72.1 3.63 73 169.6 0.04380518 91 76.0
54 176.1 79.7 3.47 33 169.9 0.04371138 58 76.1
55 180.3 81.7 2.76 99 170.1 0.0436132 97 76.1
56 179.3 79.3 3.04 23 170.7 0.04315303 73 76.2
57 161.6 76.5 3.38 77 170.9 0.04296844 6 76.3
58 166.9 76.1 2.84 79 170.9 0.04292101 71 76.3
59 173.3 75.6 3.24 91 171.0 0.04286619 79 76.4
60 179.8 82.2 3.44 26 171.1 0.04271688 82 76.4
61 165.2 72.4 2.74 42 171.7 0.04195675 57 76.5
62 168.1 77.2 3.05 40 172.0 0.04158496 99 76.6
63 158.9 73.8 1.99 37 172.1 0.04139977 81 76.8
64 158.0 69.5 2.62 13 172.4 0.04085633 77 76.9
65 178.1 82.1 3.12 98 172.6 0.04052162 28 77.1
66 183.6 83.4 2.88 97 173.0 0.0398681 62 77.2
67 169.3 77.8 3.57 18 173.1 0.0395113 69 77.6
68 180.0 84.8 2.80 51 173.2 0.03931246 13 77.7
69 173.6 77.6 2.99 88 173.3 0.03921686 67 77.8
70 163.5 72.1 3.04 59 173.3 0.03916507 88 77.8
71 173.6 76.3 3.55 49 173.4 0.03890703 98 78.0
72 185.4 81.8 2.83 82 173.6 0.03861896 78 78.1
73 169.6 76.2 3.43 71 173.6 0.0385262 35 78.4
74 185.6 84.2 3.28 69 173.6 0.03852097 51 78.5
75 143.8 65.3 2.47 28 173.8 0.03821189 48 78.6
76 178.2 81.9 3.33 1 175.0 0.03530082 3 78.7
77 170.9 76.9 3.15 90 175.1 0.03487209 10 78.8
78 167.0 78.1 2.88 10 175.4 0.03409836 49 79.1
79 170.9 76.4 3.11 54 176.1 0.032207 56 79.3
80 150.1 73.0 2.75 3 176.5 0.03119181 23 79.6
81 167.8 76.8 3.10 41 177.4 0.02857243 54 79.7
82 173.6 76.4 3.32 8 177.7 0.02772541 42 79.9
83 184.8 81.0 3.73 65 178.1 0.02640314 41 80.3
84 164.8 75.1 2.65 76 178.2 0.0261281 8 80.3
85 161.9 72.4 3.62 35 178.2 0.02610926 83 81.0
86 165.0 75.7 2.44 87 179.2 0.02340067 26 81.4
87 179.2 81.6 3.15 56 179.3 0.02294247 87 81.6
88 173.3 77.8 3.30 92 179.7 0.0218729 55 81.7
89 164.7 72.4 3.09 60 179.8 0.0216769 4 81.7
90 175.1 75.8 2.94 68 180.0 0.02088736 72 81.8
91 171.0 76.0 3.03 55 180.3 0.0201219 76 81.9
92 179.7 82.6 3.06 48 180.6 0.01940346 65 82.1
93 163.0 73.8 2.82 66 183.6 0.01206326 60 82.2
94 166.7 72.5 3.28 21 184.7 0.00986726 92 82.6
95 166.1 75.1 3.14 83 184.8 0.00963911 66 83.4
 96 155.4 70.7 2.70 4 185.2 0.00882892 74 84.2
97 173.0 76.1 3.38 72 185.4 0.00857024 21 84.7
98 172.6 78.0 3.21 74 185.6 0.00812462 68 84.8
99 170.1 76.6 3.33 7 185.8 0.00788764 32 85.0
100 167.7 73.2 3.23 32 188.5 0.00431832 7 87.4
Mean 168.96 Mean 168.96 Mean 76.08
Std Dev 9.08 Std Dev 9.08 Std Dev 4.27
NORM Student ID IPK NORM Normal Distribution
0.00377359 63 1.99 0.00877365 Probability
0.00991709 24 2.41 0.18252026 Tinggi badan < 160cm 16.19%
0.0111949 86 2.44 0.2168045
0.01817093 75 2.47 0.2490383 Berat badan 75 - 78 kg
0.02513476 22 2.49 0.26889408 Prob berat <= 78kg 67.38%
0.02688091 37 2.49 0.27827519 Prob berat<= 75kg 40.04%
0.02825619 45 2.54 0.3515265 Antara 75-78kg 27.35%
0.03818295 64 2.62 0.47923401
0.04074066 5 2.64 0.5127669 IPK antara 2.75-3.25
0.04207464 84 2.65 0.5379914 Prob IPK <= 3.25 68.38%
0.0421516 96 2.70 0.62733936 Prob IPK <= 2.75 17.24%
0.05455882 17 2.73 0.6801688 IPK antara 2.75 - 3.25 51.14%
0.05753824 39 2.73 0.68636802
0.05860559 61 2.74 0.69926214
0.06041129 51 2.75 0.71975363 Expected Value
0.06046833 80 2.75 0.72794527
0.06121348 55 2.76 0.73826346 Tinggi 168.96 mean
0.06441693 34 2.76 0.75046829 Berat 76.08 mean
0.06468379 31 2.77 0.77368561 IPK 3.08 mean
0.06478312 15 2.77 0.7746862 Tahun Kelahi 1988 modus
0.06622703 6 2.78 0.77818895
0.06818976 29 2.80 0.81410317
0.06916444 68 2.80 0.81416201
0.06981786 28 2.80 0.82203923
0.07203485 93 2.82 0.86330857
0.07398461 72 2.83 0.88162449
0.07968095 58 2.84 0.89062148
0.08075915 19 2.84 0.89066961
0.08146523 47 2.87 0.94856663
0.08300346 66 2.88 0.9601159
0.08402206 25 2.88 0.96275156
0.08468812 78 2.88 0.96312878
0.0858379 1 2.89 0.97275967
0.08613878 38 2.90 0.98583546
0.08784859 46 2.90 0.99559811
0.08873399 41 2.94 1.04343101
0.08953746 20 2.94 1.04837016
0.09000487 90 2.94 1.05055427
0.09012967 27 2.95 1.05915154
0.09074176 50 2.99 1.09804495
0.09097212 69 2.99 1.09912237
0.09117612 48 3.00 1.10700834
0.09121884 91 3.03 1.12189837
0.09163067 70 3.04 1.12543026
0.09250801 18 3.04 1.12671115
0.09267085 56 3.04 1.12890766
0.09283999 62 3.05 1.13070009
0.09291744 92 3.06 1.1335888
0.09305619 14 3.07 1.1345766
0.09325422 42 3.08 1.13544647
0.09337411 33 3.08 1.13542892
0.09340414 89 3.09 1.13483825
0.09347789 81 3.10 1.13454929
0.09347963 79 3.11 1.13128648
0.09348037 65 3.12 1.13015296
0.09345124 36 3.14 1.12076213
0.09340023 95 3.14 1.11825594
0.09329393 77 3.15 1.11244713
0.09324029 87 3.15 1.11191742
0.09322584 11 3.18 1.0939465
0.09311524 9 3.18 1.09024539
0.09267334 43 3.20 1.06920534
0.09228252 98 3.21 1.06443279
0.09168561 2 3.23 1.03947404
0.09104459 100 3.23 1.03743757
0.09008243 59 3.24 1.02043479
0.08744469 16 3.24 1.02041673
0.08688946 30 3.25 1.01868502
0.08600219 74 3.28 0.96761861
0.08588952 94 3.28 0.96113375
0.0846172 88 3.30 0.93893475
0.08390346 44 3.31 0.9245133
0.08099422 23 3.31 0.91859832
0.07999623 52 3.31 0.9126624
0.07831978 82 3.32 0.90893851
0.07706836 99 3.33 0.88926819
0.07635109 76 3.33 0.88479968
0.07286091 8 3.33 0.88068802
0.07076084 40 3.35 0.84864751
0.06636987 12 3.37 0.81916208
0.06497876 32 3.38 0.80178471
0.06277955 57 3.38 0.79530183
0.05758797 97 3.38 0.79264653
0.0572613 13 3.40 0.75577321
0.04794799 73 3.43 0.70238957
0.04319775 60 3.44 0.67363804
0.04088517 26 3.44 0.66635635
0.03893494 7 3.45 0.65725918
0.03865238 54 3.47 0.61795392
0.03816665 3 3.48 0.59122446
0.03741128 71 3.55 0.46704913
0.03472707 67 3.57 0.42989176
0.03336717 4 3.58 0.420451
0.02936642 85 3.62 0.3497439
0.02120249 53 3.63 0.33721441
 0.01512083 49 3.66 0.29409593
0.01227082 83 3.73 0.20868698
0.01152379 35 3.82 0.12708032
0.01065027 10 3.90 0.07550439
0.0028047 21 3.96 0.04847196
0.09348077 Mean 3.08
3.08476E-63 Std Dev 0.35
 Normal Distribution Tinggi (cm)
0.05

0.045

0.04

0.035

0.03

0.025

0.02

0.015

0.01

0.005

0
140.0 150.0 160.0 170.0 180.0 190.0 200.0
 Normal Distribution IPK

1.2

0.8

0.6

0.4

0.2

0
1.50 2.00 2.50 3.00 3.50 4.00 4.50
 Normal Distribution Berat (kg)

0.1

0.09

0.08

0.07

0.06

0.05

0.04

0.03

0.02

0.01

0
60.0 65.0 70.0 75.0 80.0 85.0 90.0
Dataset Variance and Covariance (manual calculation) Covariance Matrix
Student ID Tinggi (cm) Berat (kg) IPK T - Tbar B - Bbar (T-Tbar)^2 (B - Bbar)^2(T-Tbar)(B-Bbar)
1 175.0 75.9 2.89 6.01 (0.17) 36.07 0.03 (1.04) Tinggi
2 168.6 75.0 3.23 (0.34) (1.04) 0.12 1.08 0.36 Berat
3 176.5 78.7 3.48 7.52 2.65 56.48 7.03 19.93 IPK
4 185.2 81.7 3.58 16.27 5.67 264.67 32.17 92.27
5 167.7 75.1 2.64 (1.30) (0.95) 1.70 0.91 1.24 Correlation Matrix
6 167.7 76.3 2.78 (1.30) 0.18 1.70 0.03 (0.23)
7 185.8 87.4 3.45 16.83 11.30 283.27 127.72 190.21 Tinggi
8 177.7 80.3 3.33 8.71 4.23 75.91 17.85 36.81 Berat
9 165.3 74.9 3.18 (3.66) (1.17) 13.37 1.38 4.30 IPK
10 175.4 78.8 3.90 6.46 2.72 41.78 7.37 17.55
11 165.4 70.6 3.18 (3.60) (5.50) 12.93 30.25 19.78 Regression Coefficients
12 165.3 74.4 3.37 (3.62) (1.73) 13.10 2.98 6.25 y = alpha + beta . X
13 172.4 77.7 3.40 3.46 1.63 11.96 2.66 5.64
14 150.9 72.8 3.07 (18.09) (3.26) 327.41 10.63 59.00 Tinggi vs Berat
15 152.8 68.4 2.77 (16.21) (7.72) 262.79 59.66 125.21 Beta
16 164.4 74.6 3.24 (4.58) (1.50) 21.02 2.26 6.90 Alpha
17 159.9 71.9 2.73 (9.09) (4.20) 82.63 17.68 38.22 R2
18 173.1 75.6 3.04 4.18 (0.50) 17.48 0.25 (2.09)
19 160.9 74.7 2.84 (8.04) (1.38) 64.67 1.90 11.08 Tinggi vs IPK
20 155.9 71.6 2.94 (13.08) (4.43) 171.21 19.61 57.95 Beta
21 184.7 84.7 3.96 15.69 8.60 246.33 73.96 134.98 Alpha
22 167.7 73.7 2.49 (1.22) (2.41) 1.49 5.82 2.94 R2
23 170.7 79.6 3.31 1.71 3.53 2.94 12.48 6.05
24 155.8 67.3 2.41 (13.21) (8.79) 174.48 77.31 116.14 Berat vs IPK
25 164.6 75.2 2.88 (4.41) (0.85) 19.41 0.73 3.76 Beta
26 171.1 81.4 3.44 2.15 5.30 4.61 28.12 11.39 Alpha
27 158.5 69.3 2.95 (10.47) (6.74) 109.65 45.40 70.56 R2
28 173.8 77.1 2.80 4.80 0.98 23.00 0.96 4.70
29 164.0 74.0 2.80 (4.97) (2.08) 24.68 4.33 10.34
30 167.1 74.2 3.25 (1.88) (1.90) 3.53 3.60 3.56
31 164.0 70.7 2.77 (4.98) (5.39) 24.79 29.01 26.82
32 188.5 85.0 3.38 19.56 8.90 382.64 79.12 174.00
33 169.9 74.3 3.08 0.90 (1.76) 0.82 3.11 (1.59)
34 159.4 72.7 2.76 (9.54) (3.39) 90.99 11.49 32.33
35 178.2 78.4 3.82 9.26 2.29 85.82 5.22 21.17
36 157.8 74.1 3.14 (11.17) (1.97) 124.77 3.89 22.02
37 172.1 75.9 2.49 3.13 (0.20) 9.78 0.04 (0.64)
38 150.4 67.0 2.90 (18.56) (9.04) 344.41 81.72 167.77
39 156.7 72.2 2.73 (12.24) (3.93) 149.90 15.42 48.08
40 172.0 74.9 3.35 3.01 (1.15) 9.04 1.33 (3.47)
41 177.4 80.3 2.94 8.42 4.20 70.95 17.65 35.38
42 171.7 79.9 3.08 2.75 3.81 7.57 14.50 10.48
43 168.8 72.8 3.20 (0.12) (3.31) 0.01 10.97 0.39
44 167.0 75.5 3.31 (1.97) (0.56) 3.89 0.32 1.11
45 155.2 70.4 2.54 (13.75) (5.71) 188.97 32.61 78.51
46 162.8 74.8 2.90 (6.16) (1.25) 37.95 1.57 7.72
47 165.4 72.0 2.87 (3.57) (4.12) 12.73 17.01 14.71
48 180.6 78.6 3.00 11.61 2.54 134.78 6.45 29.48
49 173.4 79.1 3.66 4.47 3.01 20.02 9.08 13.48
50 152.4 69.2 2.99 (16.59) (6.92) 275.29 47.85 114.77
51 173.2 78.5 2.75 4.28 2.38 18.31 5.67 10.19
52 166.1 75.5 3.31 (2.81) (0.62) 7.91 0.38 1.74
53 163.2 72.1 3.63 (5.73) (3.98) 32.84 15.87 22.83
54 176.1 79.7 3.47 7.16 3.64 51.20 13.25 26.04
55 180.3 81.7 2.76 11.35 5.65 128.79 31.90 64.10
56 179.3 79.3 3.04 10.35 3.18 107.15 10.14 32.97
57 161.6 76.5 3.38 (7.35) 0.38 54.08 0.14 (2.78)
58 166.9 76.1 2.84 (2.05) (0.02) 4.22 0.00 0.04
59 173.3 75.6 3.24 4.35 (0.47) 18.93 0.22 (2.04)
60 179.8 82.2 3.44 10.79 6.13 116.51 37.52 66.12
61 165.2 72.4 2.74 (3.75) (3.68) 14.09 13.56 13.82
62 168.1 77.2 3.05 (0.82) 1.16 0.67 1.35 (0.95)
63 158.9 73.8 1.99 (10.02) (2.24) 100.50 5.01 22.44
64 158.0 69.5 2.62 (10.92) (6.60) 119.33 43.58 72.11
65 178.1 82.1 3.12 9.16 6.01 83.97 36.07 55.04
66 183.6 83.4 2.88 14.60 7.35 213.19 54.04 107.34
67 169.3 77.8 3.57 0.32 1.74 0.10 3.04 0.55
68 180.0 84.8 2.80 11.07 8.73 122.63 76.25 96.70
69 173.6 77.6 2.99 4.65 1.56 21.67 2.43 7.26
70 163.5 72.1 3.04 (5.41) (3.99) 29.30 15.90 21.58
71 173.6 76.3 3.55 4.65 0.27 21.65 0.07 1.26
72 185.4 81.8 2.83 16.42 5.71 269.58 32.63 93.79
73 169.6 76.2 3.43 0.68 0.11 0.46 0.01 0.07
74 185.6 84.2 3.28 16.68 8.15 278.39 66.36 135.91
75 143.8 65.3 2.47 (25.16) (10.81) 632.97 116.92 272.04
76 178.2 81.9 3.33 9.26 5.78 85.70 33.36 53.47
77 170.9 76.9 3.15 1.91 0.84 3.64 0.71 1.60
78 167.0 78.1 2.88 (1.95) 1.98 3.81 3.94 (3.87)
79 170.9 76.4 3.11 1.96 0.31 3.83 0.09 0.60
80 150.1 73.0 2.75 (18.84) (3.08) 354.84 9.49 58.04
81 167.8 76.8 3.10 (1.16) 0.69 1.34 0.47 (0.79)
82 173.6 76.4 3.32 4.61 0.32 21.25 0.10 1.45
83 184.8 81.0 3.73 15.82 4.93 250.19 24.32 78.00
84 164.8 75.1 2.65 (4.14) (0.94) 17.17 0.89 3.91
85 161.9 72.4 3.62 (7.05) (3.66) 49.65 13.41 25.81
86 165.0 75.7 2.44 (3.98) (0.41) 15.83 0.17 1.62
87 179.2 81.6 3.15 10.19 5.49 103.89 30.12 55.94
88 173.3 77.8 3.30 4.33 1.76 18.71 3.09 7.60
89 164.7 72.4 3.09 (4.26) (3.65) 18.14 13.36 15.57
90 175.1 75.8 2.94 6.17 (0.30) 38.08 0.09 (1.83)
91 171.0 76.0 3.03 2.01 (0.03) 4.04 0.00 (0.07)
92 179.7 82.6 3.06 10.72 6.49 115.02 42.18 69.65
93 163.0 73.8 2.82 (5.98) (2.31) 35.79 5.33 13.81
94 166.7 72.5 3.28 (2.24) (3.54) 5.01 12.55 7.93
 95 166.1 75.1 3.14 (2.88) (1.00) 8.31 0.99 2.87
96 155.4 70.7 2.70 (13.60) (5.39) 184.87 29.08 73.32
97 173.0 76.1 3.38 4.00 (0.01) 16.00 0.00 (0.05)
98 172.6 78.0 3.21 3.65 1.90 13.32 3.63 6.95
99 170.1 76.6 3.33 1.09 0.56 1.19 0.32 0.61
100 167.7 73.2 3.23 (1.31) (2.92) 1.71 8.52 3.82
Analisis Deskriptif SUM OF SQUARES / (n-1) 82.48 18.21 34.75
Mean 168.96 76.08 3.08
Variance 82.48 18.21 0.12
Std Dev 9.08 4.27 0.35
Std Dev 9.08 4.27 0.35

Covariance Tinggi, Berat 34.75

Correlation Tinggi, Berat 0.897
Coefficient of Determination (R2) 0.804

Covariance Tinggi, IPK 1.51

Correlation Tinggi, IPK 0.475
Coefficient of Determination (R2) 0.949

Covariance Berat, IPK 0.66

Correlation Berat, IPK 0.440
Coefficient of Determination (R2) 0.193
Covariance Matrix Prediction Using Regression Deviation
Tinggi Berat IPK Student ID x (tinggi) y hat (pred) y actual y actual - ybar y hat - y bar error (y actual - y hat)
82.477 34.752 1.515 1
34.752 18.213 0.659 2
1.515 0.659 0.123 3
4
Correlation Matrix 5
Tinggi Berat IPK 6
1.000 0.897 0.475 7
0.897 1.000 0.440 8
0.475 0.440 1.000 9
10
Regression Coefficients 11
y = alpha + beta . X 12
13
Tinggi vs Berat 14
15
16
17
18
Tinggi vs IPK 19
20
21
22
23
Berat vs IPK 24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
 95
96
97
98
99
100
SUM OF SQUARES

SUM OF SQUARES / (n-1)

TOTAL VARIANCE BERAT

Percent Explained Variance (R2
Percent Unexplained Variance
Squared values
(y actual - ybar) ^2 (y hat - y bar)^2 error ^2
 Total SS (TSS) Explained SS (ESS) Residual SS (RSS)

Total Variance Explained Variance Unexplained Variance

TOTAL VARIANCE BERAT

ercent Explained Variance (R2) Square of Correlation
Percent Unexplained Variance