RTINS e L e O LN A e 1 | convertible 49,6 152 | four 168,8 2 convertible 48,8 130 four 168,8 3 | hatchback 48,8 130 | six 171,2 4 | sedan 52,4 152 four 176,6 5 | sedan 54,3 109 | five 176,6 6 sedan 54,3 136 five 177,3 7 sedan 53,1 136 five 192,7 8 wagon 55,7 136 | five 192,7 9 sedan 55,7 136 five 192,7 10 | hatchback 55,9 131 five 178,2 11 | sedan 52 131 four 176,8 12 | sedan 54,3 108 four 176,8 13 | sedan 54,3 108 | six 176,8 14 | sedan 54,3 164 | six 176,8 15 | sedan 54,3 164 | six 189 16 | sedan 55,7 164 | six 189 17 | sedan 55,7 209 | six 193,8 18 | sedan 53,7 209 | six 197 19 | hatchback 56,3 209 | three 141,1 20 | hatchback 53,2 61 four 155,9 21 sedan 52 90 | four 158,8 22 | hatchback 52 90 two 157,3 23 | hatchback 50,8 90 two 157,3 24 | hatchback 50,8 90 two 157,3 25 | hatchback 50,8 98 two 157,3 26 | sedan 50,6 90 two 157,3 23 | hatchback 50,8 90 | two 157,3 24 | hatchback 50,8 90 two 157,3 25 | hatchback 50,8 98 two 157,3 26 | sedan 50,6 90 two 157,3 27 | sedan 50,6 90 two 157,3 28 | sedan 50,6 90 two 157,3 29 wagon 50,6 98 twelve 174,6 30 hatchback 59,8 122 | twelve 173,2 31 hatchback 50,2 156 | twelve 144,6 32 hatchback 50,8 92 twelve 144,6 33 | hatchback 50,8 92 four 150 34 | hatchback 52,6 79 four 150 35 | hatchback 52,6 92 four 150 36 | sedan 52,6 92 four 163,4 37 wagon 54,5 92 four 157,1 38 hatchback 58,3 92 four 167,5 39 hatchback 53,3 110 | four 167,5 40 sedan 53,3 110 | four 175,4 41 sedan 54,1 110 | four 175,4 42 sedan 54,1 110 | three 175,4 43 sedan 54,1 110 | three 169,1 44 sedan 51 110 | three 170,7 45 sedan 53,5 111 | four 155,9 46 sedan 52 90 four 155,9 47 hatchback 52 90 four 172,6 48 sedan 51,4 119 | six 199,6 49 sedan 52,8 258 | six 199,6 50 | sedan 52,8 258 | twelve 191,7 \f2. Buatlah visualisasi yang sesuai dari masing-masing variabel numerik yang ada pada dataset tersebut. Jawab: Histogram Car Height 18 16 14 12 10 8 N [48.8, 50.4] (50.4, 52] (52, 53.6] (53.6, 55.2] (55.2, 56.8] (56.8, 58.4] (58.4, 60] Histogram Engine Size 30 25 20 15 10 5 (89.2, 117.4] (145.6, 173.8] (202, 230.2] [61, 89.2] (117.4, 145.6] (173.8, 202] (230.2, 258.4]Histogram Car Length 16 14 12 10 N O (149.5, 157.9] (166.3, 174.7] (183.1, 191.5] [141.1, 149.5] (157.9, 166.3] (174.7, 183.1] (191.5, 199.9] 3. Buatlah visualisasi yang sesuai dari masing-masing variabel kategorik yang da pada dataset terseby Jawab: Type Of Car Body 6% 4% 34% 56% . convertible . hatchback . sedan wagonType of cylinder 20 15 10 5 0 two three four five six twelve 4. Dari variabel numerik yang ada, hitunglah dari masing-masing variabel : Ket : 1 = car height ; 2 = engine size ; 3 =car length a. Sample mean Jawab: Ex 49.6+ 48.8+ ...+ 52.8 2,647 . 8 X1 = = 52 . 956 n 50 50 Ex 152 + 300 + ... + 258 6,196 1 = = 123 . 92 n 50 50 E x 168.8 + 168.8 + ... + 191.7 8,512.3 X3 = = 170 . 246 n 50 50 H4 vixfx =AVERAGE (C3: (52) A B C D E F G H Perhatikan data set di bawah ini : no type of carbody car height enginesize type of cylinder car length 1 convertible 49.6 152 four 168.8 Mean Car Height 2 convertible 18.8 130 four 168.8 52.956 3 hatchback 18.8 130 six 171.2 Al sedan 2 4 152/ four 176 61 H4 vi X fx =AVERAGE (D3 : D52) B D E F G H Perhatikan data set di bawah ini : no type of carbody car height enginesize type of cylinder car length 1 convertible 49.6 152 four 168.8 Mean Engine Size 2 convertible 48.8 130 four 168.8 123.92 NOUPWN 3 hatchback 48.8 130 six 171.2 sedan 52.4 152 four 176.6 Elcarlan 1 2 nal fiveH4 VIX fx =AVERAGE (F3: F52) A B D E G H 1 Perhatikan data set di bawah ini no type of carbody car height enginesize type of cylinder car length 1 convertible 49.6 152 four 1 A W N 168.8 Mean Car Length 2 convertible 48.8 130 four 168.8 170.246 3 hatchback 48.8 130 six 171.2 4 sedan 52.4 152 four 176.6 b. Standar deviasi Jawab: E(x - $1)2 49.6 - 52.956) + ...+ (52.8 -52.956) $1 = 1 254.083 n - 1 50- 1 = V5.185 = 2.277 49 E(x - $2)2 152 - 123.92) + ...+ (258 - 123.92) $2 = 1/ 91,729 . 68 n - 1 = V1,872 . 034 = 43 .267 50- 1 49 E( x - x3)2 168.8 - 170.246) + ...+ (191.7 - 170.246) $3 = 11,706 . 26 n - 50 - 1 49 -= V238.9034 = 15 . 456 H4 viX fx =STDEV . S(C3 : C52) A B C D E F G H Perhatikan data set di bawah ini : no type of carbody car height enginesize type of cylinder car length 1 A W N - 1 convertible 49.6 152 four 168.8 Standar Deviasi Car Height 2 convertible 48.8 130 four 168.8 2.277 3 hatchback 48.8 130 six 171.2 4 sedan 52.4 152 four 176.6 H4 vi X fx =STDEV . S(D3 : D52) A B C D E F G H Perhatikan data set di bawah ini : no type of carbody car height enginesize type of cylinder car length M A W N- 1 convertible 49.6 152 four 168.8 Standar Deviasi Engine Size 2 convertible 48.8 130 four 168.8 43.267 3 hatchback 48.8 130 six 171.2 6 4 sedan 52.4 152 four 176.6H4 vi XV fx =STDEV. S(F3: F52) B C D E F G H Perhatikan data set di bawah ini : no type of carbody car height enginesize type of cylinder car length UA W N J 1 convertible 49.6 152 four 168.8 Standar Deviasi Car Length 2 convertible 18.8 130 four 168.8 15.456 hatchback 48.8 130 six 171.2 6 4 s 2.4 152 four 176.6 c. Nilai Q1 dan Q3 Jawab: Data urut no car height enginesize car length 1 48.8 61 141.1 N 48.8 79 144.6 W 49.6 90 144.6 4 50.2 90 150 5 50.6 90 150 6 50.6 90 150 V 50.6 90 155.9 8 50.6 90 155.9 9 50.8 90 155.9 10 50.8 90 157.1 11 50.8 90 157.3 12 92 157.3 13 50.8 92 157.3 14 51 92 157.3 15 51.4 92 157.3 16 52 92 157.3 17 52 92 157.3 18 52 98 158.8 19 52 98 163.4 20 52 108 167.5 21 52.4 108 167.5 22 52.6 109 168.8 23 52.6 110 168.8\f\f\fF7 V : XVfx =QUARTILE (C3 : (52; 3) A B C D E F Data urut no car height enginesize car length Engine Size 1 18.8 61 141.1 Q1 OUT AWN 18.8 79 144.6 92 49.6 90 144.6 50.2 90 150 03 50.6 90 150 136 8 50.6 90 150 Car length (data ke 12 + Data ke 13) (157.3 + 157.3) 21 = Xn+1 = X50 +1 = X12.75 = - = 157.3 2 2 (data ke 38 + Data ke 39) (176.8 + 177.3) 23 = Xn+1 = X3(50 + 1) = X38.25 = = 177 . 05 2 2 Pada kuartil 3 Car Length ditemukan perbedaan hasil pada hitungan excel (176.80) dengan perhitungan rumus kuartil (177.05) F4 vi XV fx =QUARTILE(D3 : D52; 1) A B C D E F no car height enginesize car length Car Length 1 49.6 152 168.8 Q1 48.8 V O MI A W N - 130 168.8 157.30 W N 48.8 130 171.2 4 52.4 152 176.6 03 54.3 109 176.6 176.80 Co 54.3 136 177.3F7 vi X fx =QUARTILE (K5 : K54; 3) A B C D E F W N - no car height enginesize car length Car Length 1 49.6 152 168.8 Q1 A 48.8 130 168.8 157.30 48.8 130 171.2 LAWN 52.4 152 176.6 03 54.3 109 176.6 176.80 CO 6 54.3 136 177.3 d. Nilai koefisien variasi Jawab: 2.277 kv = = X 100% = X 100% = 4.30% 52.956 43.267 kv, = - X 100% = X 100% = 34.92% 123.92 15.456 kv3 = - X 100% = X 100% = 9.08% 170.246 e. Buatlah boxplot untuk mengetahui apakah terdapat outlier atau tidak Jawab: Boxplot 300 250 200 car height 150 enginesize X 100 car length 50 HDiketahui variabel car length memiliki 1 outlier di bagian atas, variabel engine size memiliki 2 outlier di bagian atas, dan variabel car length tidak memiliki outlier. 5. Dari variabel kategorik yang ada, buatlah tabel distribusi frekuensi untuk masing-masing variabel dan tentukan modusnya. Jawab: type of carbody Frequency convertible 2 hatchback 17 sedan 28 wagon 3 Total 50 Diketahui modus pada type of car body adalah sedan yang artinya type mobil yang paling umum dimiliki pada dataset adalah sedan. Type Of cylinder Frequency two 7 three 4 four 19 five 6 six 9 twelve 5 Total 50 Diketahui modus pada type of cylinder adalah four yang artinya type cylinder yang paling umum dimiliki pada dataset adalah empat