Kelompok 5 Soal 1.23

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 11

Data

141 Dibawah Rata-Rata 163.58823529 Max


112 Dibawah Rata-Rata 163.58823529 Min
153 Dibawah Rata-Rata 163.58823529
134 Dibawah Rata-Rata 163.58823529 MEAN
95 Dibawah Rata-Rata 163.58823529 163.588235294118
96 Dibawah Rata-Rata 163.58823529 Langkah 1
78 Dibawah Rata-Rata 163.58823529 Kuartil 1
148 Dibawah Rata-Rata 163.58823529 Kuartil 2
172 Diatas Rata-Rata 163.58823529 Kuartil 3
200 Diatas Rata-Rata 163.58823529 Langkah 2
271 Diatas Rata-Rata 163.58823529 Q2 * 1.5
103 Dibawah Rata-Rata 163.58823529 Langkah 3
172 Diatas Rata-Rata 163.58823529 (Nilai Langkah 2 - Q1)
359 Diatas Rata-Rata 163.58823529 Langkah 4
145 Dibawah Rata-Rata 163.58823529 Q3 + (Langkah 2)
147 Dibawah Rata-Rata 163.58823529 Langkah 5
255 Diatas Rata-Rata 163.58823529 Rentang Nilai
Langkah 6
Steam Leaf Urutan data(naik)
7 Steam 1 78
9 2 95
10 3 3 96
11 2 4 103
13 4 5 112
14 1578 6 134
15 #NAME? 7 141
17 22 8 145
20 0 9 147
25 5 10 148
27 1 11 153
35 9 12 172
13 172
14 200
15 255
16 271
17 359
Nilai
359
78

Langkah 1
112
147
186
Langkah 2
220.5
Langkah 3
108.5
Langkah 4
406.5
Langkah 5
108.5 - 406.5
Langkah 6
Penentuan
Pencilan
Pencilan
Pencilan
Pencilan
Bukan
Bukan
Bukan
Bukan
Bukan
Bukan
Bukan
Bukan
Bukan
Bukan
Bukan
Bukan
Bukan
Q= Apakah ada Pencilan ? Seberapa baik kelompok secara keseluruhan mencapai tujuan pengendalian kadar glukosa?
A : Ada, Kelompok ini dapat dikatan cukup baik dalam mengendalikan kadar plasma glukosa dalam tubuh 18 orang penderita d

Data
400
350
300
250 Data
200
150
100
50
0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
78 This chart isn't available in your version of Excel.
95
96 Editing this shape or saving this workbook into a different file format
103 permanently break the chart.
112
134
141
145
147
148
153
158
172
172
200
255
271
359

Langkah 1 Steam Leaf


Kuartil 1 117.5 78
Kuartil 2 147.5 9 56
Kuartil 3 172 10 3
Langkah 2 11 2
(Q3-Q1)*1.5 / Interkuartil Dalam 81.75 13 4
Langkah 3 14 1578
Q3 + Interkuatil 253.75 15 38
Q1 - Interkuartil 35.75 17 22
Langkah 4 20 0
Rentang Pagar Dalam 35,75 - 253,75 25 5
Langkah 5 / Pagar Luar 27 1
(Q3-Q1)*3 / Interkuartil Luar 163.5 35 9
Langkah 6
Q3 + Interkuatil Luar 335.5
Q1 - Interkuartil Dalam -46
Langkah 7
Rentang Pagar Luar -46-335.5
Langkah 8
78 Bukan Pencilan
95 Bukan Pencilan
96 Bukan Pencilan
103 Bukan Pencilan
112 Bukan Pencilan
134 Bukan Pencilan
141 Bukan Pencilan
145 Bukan Pencilan
147 Bukan Pencilan
148 Bukan Pencilan
153 Bukan Pencilan
158 Bukan Pencilan
172 Bukan Pencilan
172 Bukan Pencilan
200 Bukan Pencilan
255 Pencilan
271 Pencilan
359 Pencilan
of Excel.

ok into a different file format will


Education Employability Research
World Rank Institution Location National Rank Faculty Rank Score
Rank Rank Rank
Harvard USA 1 1 1 1 1 100
1
University
Massachusett USA 2 4 12 3 9 96.7
2 s Institute of
Technology
Stanford USA 3 11 4 2 2 95.2
3
University
University of United 1 3 25 5 11 94.1
4
Cambridge Kingdom
University of United 2 7 27 9 4 93.3
5
Oxford Kingdom
Princeton USA 4 5 16 6 82 92.6
6
University
University of USA 5 8 15 22 28 92.1
7
Chicago
Columbia USA 6 12 14 10 13 91.6
8
University
University of USA 7 14 8 45 12 91.2
9
Pennsylvania
Yale USA 8 6 35 13 21 90.8
10
University
California USA 9 2 96 7 83 90.4
11 Institute of
Technology
University of USA 10 9 59 4 16 90.1
12 California,
Berkeley
University of Japan 1 37 6 113 30 89.8
13
Tokyo
Cornell USA 11 16 29 18 23 89.5
14
University
Northwestern USA 12 99 17 31 31 89.3
15
University
University of USA 13 32 40 62 7 89.1
16 Michigan, Ann
Arbor
Johns Hopkins USA 14 22 192 20 8 88.8
17 University

University of USA 15 31 63 16 15 88.6


18 California, Los
Angeles
University United 3 35 664 14 5 88.4
19 College Kingdom
London
Duke USA 16 58 49 19 24 88.2
20
University
PSL University France 1 17 31 111 91 88.0
21
University of USA 17 19 143 11 74 87.9
Illinois at
22 Urbana–
Champaign
University of Canada 1 233 163 23 3 87.7
23
Toronto
New York USA 18 40 45 47 46 87.5
24
University
University of USA 19 74 227 25 10 87.4
25
Washington
McGill Canada 2 25 109 36 45 87.2
26
University
Kyoto Japan 2 38 32 64 79 87.1
27
University
University of USA 20 36 102 30 41 87.0
28 Wisconsin–
Madison
Imperial United 4 68 123 55 18 86.8
29 College Kingdom
London
30 ETH Zurich Switzerland 1 64 88 24 42 86.7

Seoul National South Korea 1 299 22 154 57 86.6


31 University
Paris-Saclay France 2 152 137 46 14 86.4
32
University
University of USA 21 128 1520 12 22 86.3
33 California, San
Diego
University of USA 22 92 64 17 63 86.2
34 Texas at
Austin
University of Denmark 1 96 379 41 26 86.1
35
Copenhagen
University of USA 23 - 1554 15 27 86.0
California, San
36 Francisco

University of USA 24 76 92 71 39 85.9


North Carolina
37 at Chapel Hill

Karolinska Sweden 1 39 - 35 62 85.8


38
Institute
Paris City France 3 254 958 60 17 85.7
39
University
King's College United 5 51 505 28 53 85.6
40 London Kingdom

Sorbonne France 4 103 324 92 19 85.5


41
University
Dartmouth USA 25 45 18 107 286 85.4
42
College
Washington USA 26 106 144 37 48 85.3
43 University in
St. Louis
Tsinghua China 1 346 56 - 20 85.2
44
University
Institut France 5 102 9 188 370 85.1
45 Polytechnique
de Paris
Ludwig Germany 1 56 254 57 52 85.0
Maximilian
46 University of
Munich
University of USA 27 78 318 84 34 84.9
47 Minnesota -
Twin Cities
University of United 6 55 473 63 49 84.9
48
Edinburgh Kingdom
Peking China 2 369 58 - 25 84.8
49
University
University of United 7 89 417 33 56 84.7
50
Manchester Kingdom
University of Canada 3 109 554 87 35 84.6
51 British
Columbia
University of USA 28 87 526 54 54 84.5
52 California,
Davis
University of USA 29 252 133 29 75 84.5
53 Southern
California
Pennsylvania USA 30 297 171 56 55 84.4
54 State
University
University of China 3 - 1304 - 6 84.3
Chinese
55 Academy of
Sciences
Vanderbilt USA 31 392 89 65 71 84.2
56
University
University of Australia 1 142 411 130 33 84.2
57
Melbourne
Free Germany 2 80 1123 44 76 84.1
58 University of
Berlin
Humboldt Germany 3 85 1532 50 69 84.0
59 University of
Berlin
Ohio State USA 32 129 294 133 40 84.0
60
University
Rockefeller USA 33 13 - 8 460 83.9
61
University
Rutgers USA 34 230 150 27 95 83.8
62
University
University of Switzerland 2 90 578 58 72 83.8
63
Zurich
Brown USA 35 75 55 121 138 83.7
64
University
Purdue USA 36 94 91 75 114 83.6
65
University
University of USA 37 153 169 52 97 83.6
66 Colorado
Boulder
Georgia USA 38 313 165 26 115 83.5
67 Institute of
Technology
Heidelberg Germany 4 135 1012 83 60 83.5
68
University
Texas A&M USA 39 - 129 72 85 83.4
University,
69 College
Station
Hebrew Israel 1 29 346 39 195 83.3
70 University of
Jerusalem
University of USA 40 358 37 176 137 83.3
71
Virginia
Utrecht Netherlands 1 180 481 161 43 83.2
72
University
University of USA 41 41 - 42 167 83.2
Texas
73 Southwestern
Medical
Center
Shanghai Jiao China 4 - 140 - 29 83.1
74 Tong
University
University of USA 42 234 208 267 38 83.0
75
Pittsburgh
University of Canada 4 327 488 67 88 83.0
76
Alberta
Uppsala Sweden 2 97 412 70 105 82.9
77
University
Technical Germany 5 81 368 144 77 82.9
78 University of
Munich
University of USA 43 122 387 152 68 82.8
79 Maryland,
College Park
University of Netherlands 2 239 689 201 44 82.8
80
Amsterdam
National Singapore 1 365 181 - 37 82.7
81 University of
Singapore
University of USA 44 393 1229 34 110 82.7
82 California,
Irvine
University of Norway 1 121 798 79 94 82.6
83
Oslo
University of United 8 50 486 170 103 82.6
84
Birmingham Kingdom
Zhejiang China 5 - 351 - 32 82.5
85
University
University of USA 45 326 426 139 65 82.5
86
Florida
Weizmann Israel 2 24 - 51 289 82.4
87 Institute of
Science
Leiden Netherlands 3 124 1068 77 100 82.4
88
University
Fudan China 6 353 93 - 59 82.3
89
University
Boston USA 46 428 111 200 80 82.3
90
University
University of USA 47 65 70 132 185 82.2
91
Rochester
University of Australia 2 198 627 - 36 82.2
92
Sydney
University of United 9 186 430 78 99 82.1
93
Bristol Kingdom
Erasmus Netherlands 4 535 68 270 89 82.1
94 University
Rotterdam
University of USA 48 498 237 73 107 82.1
95
Arizona
École Switzerland 3 - 83 112 124 82.0
Polytechnique
96 Fédérale de
Lausanne
University of Germany 6 44 369 104 162 82.0
97
Göttingen
University of USA 49 211 535 21 156 81.9
California,
98 Santa Barbara

Carnegie USA 50 70 113 40 223 81.9


99 Mellon
University
Osaka Japan 3 145 74 124 147 81.8
100
University
Reason why we choose Harvard University :
Choosing Harvard University for your studies
is an excellent decision due to its rich
academic heritage, world-class faculty,
extensive research resources, and diverse
community of scholars. Harvard offers
unparalleled opportunities for intellectual
growth and networking, preparing you for a
successful and impactful career. The
university's commitment to excellence in
various fields, combined with its global
recognition, makes it an ideal choice for
those seeking a top-tier education and a
pathway to future success. These reasons
make Harvard University the number one
university in the world, with a university
score of 100.

You might also like