CORPORACIÓN UNIVERSITARIA MINUTO DE DIOS - UNIMINUTO

ARCHIVO DE EJERCICIOS - PARCIAL II

IMPORTANTE : NO MODIFIQUE LOS DATOS SUMINISTRADOS. SU MANIPULACIÓN PUEDE ALTERAR EL R

EJERCICIO 1
RESPUESTA
1, Cuantos vehiculos tienen por combustible diesel. Consulte columna fuel-type
2. Cuantos vehiculos tienen como altura mas de 52,0. Consulte columna "height"
3. Cuantos Registros se encuentran en "compression-ratio"
4 cuantos vehiculos no tienen dato en Compresion "compression -ratio"

normalized-losses make fuel-type aspiration num-of-doors body-style

122 alfa-romero gas std two convertible
122 alfa-romero gas std two convertible
122 alfa-romero gas std two hatchback
164 audi gas std four sedan
164 audi gas std four sedan
122 audi gas std two sedan
158 audi gas std four sedan
122 audi gas std four wagon
158 audi gas turbo four sedan
122 audi gas turbo two hatchback
192 bmw gas std two sedan
192 bmw gas std four sedan
188 bmw gas std two sedan
188 bmw gas std four sedan
122 bmw gas std four sedan
122 bmw gas std four sedan
122 bmw gas std two sedan
122 bmw gas std four sedan
121 chevrolet gas std two hatchback
98 chevrolet gas std two hatchback
81 chevrolet gas std four sedan
118 dodge gas std two hatchback
118 dodge gas std two hatchback
118 dodge gas turbo two hatchback
148 dodge gas std four hatchback
148 dodge gas std four sedan
148 dodge gas std four sedan
148 dodge gas turbo _missing sedan
110 dodge gas std four wagon
145 dodge gas turbo two hatchback
137 honda gas std two hatchback
137 honda gas std two hatchback
101 honda gas std two hatchback
101 honda gas std two hatchback
101 honda gas std two hatchback
110 honda gas std four sedan
78 honda gas std four wagon
106 honda gas std two hatchback
106 honda gas std two hatchback
85 honda gas std four sedan
85 honda gas std four sedan
85 honda gas std four sedan
107 honda gas std two sedan
122 isuzu gas std four sedan
122 isuzu gas std two sedan
122 isuzu gas std four sedan
122 isuzu gas std two hatchback
145 jaguar gas std four sedan
122 jaguar gas std four sedan
122 jaguar gas std two sedan
104 mazda gas std two hatchback
104 mazda gas std two hatchback
104 mazda gas std two hatchback
113 mazda gas std four sedan
113 mazda gas std four sedan
150 mazda gas std two hatchback
150 mazda gas std two hatchback
150 mazda gas std two hatchback
150 mazda gas std two hatchback
129 mazda gas std two hatchback
115 mazda gas std four sedan
129 mazda gas std two hatchback
115 mazda gas std four sedan
122 mazda diesel std _missing sedan
115 mazda gas std four hatchback
118 mazda gas std four sedan
122 mazda diesel std four sedan
93 mercedes-benz diesel turbo four sedan
93 mercedes-benz diesel turbo four wagon
93 mercedes-benz diesel turbo two hardtop
93 mercedes-benz diesel turbo four sedan
122 mercedes-benz gas std four sedan
142 mercedes-benz gas std two convertible
122 mercedes-benz gas std four sedan
122 mercedes-benz gas std two hardtop
122 mercury gas turbo two hatchback
161 mitsubishi gas std two hatchback
161 mitsubishi gas std two hatchback
161 mitsubishi gas std two hatchback
161 mitsubishi gas turbo two hatchback
153 mitsubishi gas turbo two hatchback
153 mitsubishi gas std two hatchback
122 mitsubishi gas turbo two hatchback
122 mitsubishi gas turbo two hatchback
122 mitsubishi gas turbo two hatchback
125 mitsubishi gas std four sedan
125 mitsubishi gas std four sedan
125 mitsubishi gas turbo four sedan
137 mitsubishi gas std four sedan
128 nissan gas std two sedan
128 nissan diesel std two sedan
128 nissan gas std two sedan
122 nissan gas std four sedan
103 nissan gas std four wagon
128 nissan gas std two sedan
128 nissan gas std two hatchback
122 nissan gas std four sedan
103 nissan gas std four wagon
168 nissan gas std two hardtop
106 nissan gas std four hatchback
106 nissan gas std four sedan
128 nissan gas std four sedan
108 nissan gas std four wagon
108 nissan gas std four sedan
194 nissan gas std two hatchback
194 nissan gas turbo two hatchback
231 nissan gas std two hatchback
161 peugot gas std four sedan
161 peugot diesel turbo four sedan
122 peugot gas std four wagon
122 peugot diesel turbo four wagon
161 peugot gas std four sedan
161 peugot diesel turbo four sedan
122 peugot gas std four wagon
122 peugot diesel turbo four wagon
161 peugot gas std four sedan
161 peugot diesel turbo four sedan
161 peugot gas turbo four sedan
119 plymouth gas std two hatchback
119 plymouth gas turbo two hatchback
154 plymouth gas std four hatchback
154 plymouth gas std four sedan
154 plymouth gas std four sedan
74 plymouth gas std four wagon
122 plymouth gas turbo two hatchback
186 porsche gas std two hatchback
122 porsche gas std two hardtop
122 porsche gas std two hardtop
122 porsche gas std two convertible
122 porsche gas std two hatchback
122 renault gas std four wagon
122 renault gas std two hatchback
150 saab gas std two hatchback
104 saab gas std four sedan
150 saab gas std two hatchback
104 saab gas std four sedan
150 saab gas turbo two hatchback
104 saab gas turbo four sedan
 83 subaru gas std two hatchback
83 subaru gas std two hatchback
83 subaru gas std two hatchback
102 subaru gas std four sedan
102 subaru gas std four sedan
102 subaru gas std four sedan
102 subaru gas std four sedan
102 subaru gas turbo four sedan
89 subaru gas std four wagon
89 subaru gas std four wagon
85 subaru gas std four wagon
85 subaru gas turbo four wagon
87 toyota gas std two hatchback
87 toyota gas std two hatchback
74 toyota gas std four hatchback
77 toyota gas std four wagon
81 toyota gas std four wagon
91 toyota gas std four wagon
91 toyota gas std four sedan
91 toyota gas std four hatchback
91 toyota diesel std four sedan
91 toyota diesel std four hatchback
91 toyota gas std four sedan
91 toyota gas std four hatchback
91 toyota gas std four sedan
168 toyota gas std two sedan
168 toyota gas std two hatchback
168 toyota gas std two sedan
168 toyota gas std two hatchback
134 toyota gas std two hardtop
134 toyota gas std two hardtop
134 toyota gas std two hatchback
134 toyota gas std two hardtop
134 toyota gas std two hatchback
134 toyota gas std two convertible
65 toyota gas std four sedan
65 toyota diesel turbo four sedan
65 toyota gas std four hatchback
65 toyota gas std four sedan
65 toyota gas std four hatchback
197 toyota gas std two hatchback
197 toyota gas std two hatchback
90 toyota gas std four sedan
122 toyota gas std four wagon
122 volkswagen diesel std two sedan
122 volkswagen gas std two sedan
94 volkswagen diesel std four sedan
94 volkswagen gas std four sedan
94 volkswagen gas std four sedan
94 volkswagen diesel turbo four sedan
 94 volkswagen gas std four sedan
122 volkswagen gas std two convertible
256 volkswagen gas std two hatchback
122 volkswagen gas std four sedan
122 volkswagen diesel turbo four sedan
122 volkswagen gas std four wagon
103 volvo gas std four sedan
74 volvo gas std four wagon
103 volvo gas std four sedan
74 volvo gas std four wagon
103 volvo gas turbo four sedan
74 volvo gas turbo four wagon
95 volvo gas std four sedan
95 volvo gas turbo four sedan
95 volvo gas std four sedan
95 volvo diesel turbo four sedan
95 volvo gas turbo four sedan
DIOS - UNIMINUTO
CIAL II
PULACIÓN PUEDE ALTERAR EL RESULTADO

drive-wheels engine-location wheel-base length width height curb-weight

rwd front 88.6 168.8 64.1 48.8 2548
rwd front 88.6 168.8 64.1 48.8 2548
rwd front 94.5 171.2 65.5 52.4 2823
fwd front 99.8 176.6 66.2 54.3 2337
4wd front 99.4 176.6 66.4 54.3 2824
fwd front 99.8 177.3 66.3 53.1 2507
fwd front 105.8 192.7 71.4 55.7 2844
fwd front 105.8 192.7 71.4 55.7 2954
fwd front 105.8 192.7 71.4 55.9 3086
4wd front 99.5 178.2 67.9 52.0 3053
rwd front 101.2 176.8 64.8 54.3 2395
rwd front 101.2 176.8 64.8 54.3 2395
rwd front 101.2 176.8 64.8 54.3 2710
rwd front 101.2 176.8 64.8 54.3 2765
rwd front 103.5 189 66.9 55.7 3055
rwd front 103.5 189 66.9 55.7 3230
rwd front 103.5 193.8 67.9 53.7 3380
rwd front 110 197 70.9 56.3 3505
fwd front 88.4 141.1 60.3 53.2 1488
fwd front 94.5 155.9 63.6 52.0 1874
fwd front 94.5 158.8 63.6 52.0 1909
fwd front 93.7 157.3 63.8 50.8 1876
fwd front 93.7 157.3 63.8 50.8 1876
fwd front 93.7 157.3 63.8 50.8 2128
fwd front 93.7 157.3 63.8 50.6 1967
fwd front 93.7 157.3 63.8 50.6 1989
fwd front 93.7 157.3 63.8 50.6 1989
fwd front 93.7 157.3 63.8 50.6 2191
fwd front 103.3 174.6 64.6 59.8 2535
fwd front 95.9 173.2 66.3 50.2 2811
fwd front 86.6 144.6 63.9 50.8 1713
fwd front 86.6 144.6 63.9 50.8 1819
fwd front 93.7 150 64 52.6 1837
fwd front 93.7 150 64 52.6 1940
fwd front 93.7 150 64 52.6 1956
fwd front 96.5 163.4 64 54.5 2010
fwd front 96.5 157.1 63.9 58.3 2024
fwd front 96.5 167.5 65.2 53.3 2236
fwd front 96.5 167.5 65.2 53.3 2289
fwd front 96.5 175.4 65.2 54.1 2304
fwd front 96.5 175.4 62.5 54.1 2372
fwd front 96.5 175.4 65.2 54.1 2465
fwd front 96.5 169.1 66 51.0 2293
rwd front 94.3 170.7 61.8 53.5 2337
fwd front 94.5 155.9 63.6 52.0 1874
fwd front 94.5 155.9 63.6 52.0 1909
rwd front 96 172.6 65.2 51.4 2734
rwd front 113 199.6 69.6 52.8 4066
rwd front 113 199.6 69.6 52.8 4066
rwd front 102 191.7 70.6 47.8 3950
fwd front 93.1 159.1 64.2 54.1 1890
fwd front 93.1 159.1 64.2 54.1 1900
fwd front 93.1 159.1 64.2 54.1 1905
fwd front 93.1 166.8 64.2 54.1 1945
fwd front 93.1 166.8 64.2 54.1 1950
rwd front 95.3 169 65.7 49.6 2380
rwd front 95.3 169 65.7 49.6 2380
rwd front 95.3 169 65.7 49.6 2385
rwd front 95.3 169 65.7 49.6 2500
fwd front 98.8 177.8 66.5 53.7 2385
fwd front 98.8 177.8 66.5 55.5 2410
fwd front 98.8 177.8 66.5 53.7 2385
fwd front 98.8 177.8 66.5 55.5 2410
fwd front 98.8 177.8 66.5 55.5 2443
fwd front 98.8 177.8 66.5 55.5 2425
rwd front 104.9 175 66.1 54.4 2670
rwd front 104.9 175 66.1 54.4 2700
rwd front 110 190.9 70.3 56.5 3515
rwd front 110 190.9 70.3 58.7 3750
rwd front 106.7 187.5 70.3 54.9 3495
rwd front 115.6 202.6 71.7 56.3 3770
rwd front 115.6 202.6 71.7 56.5 3740
rwd front 96.6 180.3 70.5 50.8 3685
rwd front 120.9 208.1 71.7 56.7 3900
rwd front 112 199.2 72 55.4 3715
rwd front 102.7 178.4 68 54.8 2910
fwd front 93.7 157.3 64.4 50.8 1918
fwd front 93.7 157.3 64.4 50.8 1944
fwd front 93.7 157.3 64.4 50.8 2004
fwd front 93 157.3 63.8 50.8 2145
fwd front 96.3 173 65.4 49.4 2370
fwd front 96.3 173 65.4 49.4 2328
fwd front 95.9 173.2 66.3 50.2 2833
fwd front 95.9 173.2 66.3 50.2 2921
fwd front 95.9 173.2 66.3 50.2 2926
fwd front 96.3 172.4 65.4 51.6 2365
fwd front 96.3 172.4 65.4 51.6 2405
fwd front 96.3 172.4 65.4 51.6 2403
fwd front 96.3 172.4 65.4 51.6 2403
fwd front 94.5 165.3 63.8 54.5 1889
fwd front 94.5 165.3 63.8 54.5 2017
fwd front 94.5 165.3 63.8 54.5 1918
fwd front 94.5 165.3 63.8 54.5 1938
fwd front 94.5 170.2 63.8 53.5 2024
fwd front 94.5 165.3 63.8 54.5 1951
fwd front 94.5 165.6 63.8 53.3 2028
fwd front 94.5 165.3 63.8 54.5 1971
fwd front 94.5 170.2 63.8 53.5 2037
fwd front 95.1 162.4 63.8 53.3 2008
fwd front 97.2 173.4 65.2 54.7 2324
fwd front 97.2 173.4 65.2 54.7 2302
fwd front 100.4 181.7 66.5 55.1 3095
fwd front 100.4 184.6 66.5 56.1 3296
fwd front 100.4 184.6 66.5 55.1 3060
rwd front 91.3 170.7 67.9 49.7 3071
rwd front 91.3 170.7 67.9 49.7 3139
rwd front 99.2 178.5 67.9 49.7 3139
rwd front 107.9 186.7 68.4 56.7 3020
rwd front 107.9 186.7 68.4 56.7 3197
rwd front 114.2 198.9 68.4 58.7 3230
rwd front 114.2 198.9 68.4 58.7 3430
rwd front 107.9 186.7 68.4 56.7 3075
rwd front 107.9 186.7 68.4 56.7 3252
rwd front 114.2 198.9 68.4 56.7 3285
rwd front 114.2 198.9 68.4 58.7 3485
rwd front 107.9 186.7 68.4 56.7 3075
rwd front 107.9 186.7 68.4 56.7 3252
rwd front 108 186.7 68.3 56.0 3130
fwd front 93.7 157.3 63.8 50.8 1918
fwd front 93.7 157.3 63.8 50.8 2128
fwd front 93.7 157.3 63.8 50.6 1967
fwd front 93.7 167.3 63.8 50.8 1989
fwd front 93.7 167.3 63.8 50.8 2191
fwd front 103.3 174.6 64.6 59.8 2535
rwd front 95.9 173.2 66.3 50.2 2818
rwd front 94.5 168.9 68.3 50.2 2778
rwd rear 89.5 168.9 65 51.6 2756
rwd rear 89.5 168.9 65 51.6 2756
rwd rear 89.5 168.9 65 51.6 2800
rwd front 98.4 175.7 72.3 50.5 3366
fwd front 96.1 181.5 66.5 55.2 2579
fwd front 96.1 176.8 66.6 50.5 2460
fwd front 99.1 186.6 66.5 56.1 2658
fwd front 99.1 186.6 66.5 56.1 2695
fwd front 99.1 186.6 66.5 56.1 2707
fwd front 99.1 186.6 66.5 56.1 2758
fwd front 99.1 186.6 66.5 56.1 2808
fwd front 99.1 186.6 66.5 56.1 2847
fwd front 93.7 156.9 63.4 53.7 2050
fwd front 93.7 157.9 63.6 53.7 2120
4wd front 93.3 157.3 63.8 55.7 2240
fwd front 97.2 172 65.4 52.5 2145
fwd front 97.2 172 65.4 52.5 2190
fwd front 97.2 172 65.4 52.5 2340
4wd front 97 172 65.4 54.3 2385
4wd front 97 172 65.4 54.3 2510
fwd front 97 173.5 65.4 53.0 2290
fwd front 97 173.5 65.4 53.0 2455
4wd front 96.9 173.6 65.4 54.9 2420
4wd front 96.9 173.6 65.4 54.9 2650
fwd front 95.7 158.7 63.6 54.5 1985
fwd front 95.7 158.7 63.6 54.5 2040
fwd front 95.7 158.7 63.6 54.5 2015
fwd front 95.7 169.7 63.6 59.1 2280
4wd front 95.7 169.7 63.6 59.1 2290
4wd front 95.7 169.7 63.6 59.1 3110
fwd front 95.7 166.3 64.4 53.0 2081
fwd front 95.7 166.3 64.4 52.8 2109
fwd front 95.7 166.3 64.4 53.0 2275
fwd front 95.7 166.3 64.4 52.8 2275
fwd front 95.7 166.3 64.4 53.0 2094
fwd front 95.7 166.3 64.4 52.8 2122
fwd front 95.7 166.3 64.4 52.8 2140
rwd front 94.5 168.7 64 52.6 2169
rwd front 94.5 168.7 64 52.6 2204
rwd front 94.5 168.7 64 52.6 2265
rwd front 94.5 168.7 64 52.6 2300
rwd front 98.4 176.2 65.6 52.0 2540
rwd front 98.4 176.2 65.6 52.0 2536
rwd front 98.4 176.2 65.6 52.0 2551
rwd front 98.4 176.2 65.6 52.0 2679
rwd front 98.4 176.2 65.6 52.0 2714
rwd front 98.4 176.2 65.6 53.0 2975
fwd front 102.4 175.6 66.5 54.9 2326
fwd front 102.4 175.6 66.5 54.9 2480
fwd front 102.4 175.6 66.5 53.9 2414
fwd front 102.4 175.6 66.5 54.9 2414
fwd front 102.4 175.6 66.5 53.9 2458
rwd front 102.9 183.5 67.7 52.0 2976
rwd front 102.9 183.5 67.7 52.0 3016
rwd front 104.5 187.8 66.5 54.1 3131
rwd front 104.5 187.8 66.5 54.1 3151
fwd front 97.3 171.7 65.5 55.7 2261
fwd front 97.3 171.7 65.5 55.7 2209
fwd front 97.3 171.7 65.5 55.7 2264
fwd front 97.3 171.7 65.5 55.7 2212
fwd front 97.3 171.7 65.5 55.7 2275
fwd front 97.3 171.7 65.5 55.7 2319
fwd front 97.3 171.7 65.5 55.7 2300
fwd front 94.5 159.3 64.2 55.6 2254
fwd front 94.5 165.7 64 51.4 2221
fwd front 100.4 180.2 66.9 55.1 2661
fwd front 100.4 180.2 66.9 55.1 2579
fwd front 100.4 183.1 66.9 55.1 2563
rwd front 104.3 188.8 67.2 56.2 2912
rwd front 104.3 188.8 67.2 57.5 3034
rwd front 104.3 188.8 67.2 56.2 2935
rwd front 104.3 188.8 67.2 57.5 3042
rwd front 104.3 188.8 67.2 56.2 3045
rwd front 104.3 188.8 67.2 57.5 3157
rwd front 109.1 188.8 68.9 55.5 2952
rwd front 109.1 188.8 68.8 55.5 3049
rwd front 109.1 188.8 68.9 55.5 3012
rwd front 109.1 188.8 68.9 55.5 3217
rwd front 109.1 188.8 68.9 55.5 3062
engine-type num-of-cylinders engine-size fuel-system bore stroke
dohc four 130 mpfi 3.47 2.68
dohc four 130 mpfi 3.47 2.68
ohcv six 152 mpfi 2.68 3.47
ohc four 109 mpfi 3.19 3.4
ohc five 136 mpfi 3.19 3.4
ohc five 136 mpfi 3.19 3.4
ohc five 136 mpfi 3.19 3.4
ohc five 136 mpfi 3.19 3.4
ohc five 131 mpfi 3.13 3.4
ohc five 131 mpfi 3.13 3.4
ohc four 108 mpfi 3.5 2.8
ohc four 108 mpfi 3.5 2.8
ohc six 164 mpfi 3.31 3.19
ohc six 164 mpfi 3.31 3.19
ohc six 164 mpfi 3.31 3.19
ohc six 209 mpfi 3.62 3.39
ohc six 209 mpfi 3.62 3.39
ohc six 209 mpfi 3.62 3.39
l three 61 2bbl 2.91 3.03
ohc four 90 2bbl 3.03 3.11
ohc four 90 2bbl 3.03 3.11
ohc four 90 2bbl 2.97 3.23
ohc four 90 2bbl 2.97 3.23
ohc four 98 mpfi 3.03 3.39
ohc four 90 2bbl 2.97 3.23
ohc four 90 2bbl 2.97 3.23
ohc four 90 2bbl 2.97 3.23
ohc four 98 mpfi 3.03 3.39
ohc four 122 2bbl 3.34 3.46
ohc four 156 mfi 3.6 3.9
ohc four 92 1bbl 2.91 3.41
ohc four 92 1bbl 2.91 3.41
ohc four 79 1bbl 2.91 3.07
ohc four 92 1bbl 2.91 3.41
ohc four 92 1bbl 2.91 3.41
ohc four 92 1bbl 2.91 3.41
ohc four 92 1bbl 2.92 3.41
ohc four 110 1bbl 3.15 3.58
 ohc four 110 1bbl 3.15 3.58
ohc four 110 1bbl 3.15 3.58
ohc four 110 1bbl 3.15 3.58
ohc four 110 mpfi 3.15 3.58
ohc four 110 2bbl 3.15 3.58
ohc four 111 2bbl 3.31 3.23
ohc four 90 2bbl 3.03 3.11
ohc four 90 2bbl 3.03 3.11
ohc four 119 spfi 3.43 3.23
dohc six 258 mpfi 3.63 4.17
dohc six 258 mpfi 3.63 4.17
ohcv twelve 326 mpfi 3.54 2.76
ohc four 91 2bbl 3.03 3.15
ohc four 91 2bbl 3.03 3.15
ohc four 91 2bbl 3.03 3.15
ohc four 91 2bbl 3.03 3.15
ohc four 91 2bbl 3.08 3.15
rotor two 70 4bbl 3.32975 3.25543
rotor two 70 4bbl 3.32975 3.25543
rotor two 70 4bbl 3.32975 3.25543
rotor two 80 mpfi 3.32975 3.25543
ohc four 122 2bbl 3.39 3.39
ohc four 122 2bbl 3.39 3.39
ohc four 122 2bbl 3.39 3.39
ohc four 122 2bbl 3.39 3.39
ohc four 122 idi 3.39 3.39
ohc four 122 2bbl 3.39 3.39
ohc four 140 mpfi 3.76 3.16
ohc four 134 idi 3.43 3.64
ohc five 183 idi 3.58 3.64
ohc five 183 idi 3.58 3.64
ohc five 183 idi 3.58 3.64
ohc five 183 idi 3.58 3.64
ohcv eight 234 mpfi 3.46 3.1
ohcv eight 234 mpfi 3.46 3.1
ohcv eight 308 mpfi 3.8 3.35
ohcv eight 304 mpfi 3.8 3.35
ohc four 140 mpfi 3.78 3.12
ohc four 92 2bbl 2.97 3.23
ohc four 92 2bbl 2.97 3.23
ohc four 92 2bbl 2.97 3.23
ohc four 98 spdi 3.03 3.39
ohc four 110 spdi 3.17 3.46
ohc four 122 2bbl 3.35 3.46
ohc four 156 spdi 3.58 3.86
ohc four 156 spdi 3.59 3.86
ohc four 156 spdi 3.59 3.86
ohc four 122 2bbl 3.35 3.46
ohc four 122 2bbl 3.35 3.46
ohc four 110 spdi 3.17 3.46
 ohc four 110 spdi 3.17 3.46
ohc four 97 2bbl 3.15 3.29
ohc four 103 idi 2.99 3.47
ohc four 97 2bbl 3.15 3.29
ohc four 97 2bbl 3.15 3.29
ohc four 97 2bbl 3.15 3.29
ohc four 97 2bbl 3.15 3.29
ohc four 97 2bbl 3.15 3.29
ohc four 97 2bbl 3.15 3.29
ohc four 97 2bbl 3.15 3.29
ohc four 97 2bbl 3.15 3.29
ohc four 120 2bbl 3.33 3.47
ohc four 120 2bbl 3.33 3.47
ohcv six 181 mpfi 3.43 3.27
ohcv six 181 mpfi 3.43 3.27
ohcv six 181 mpfi 3.43 3.27
ohcv six 181 mpfi 3.43 3.27
ohcv six 181 mpfi 3.43 3.27
ohcv six 181 mpfi 3.43 3.27
l four 120 mpfi 3.46 3.19
l four 152 idi 3.7 3.52
l four 120 mpfi 3.46 3.19
l four 152 idi 3.7 3.52
l four 120 mpfi 3.46 2.19
l four 152 idi 3.7 3.52
l four 120 mpfi 3.46 2.19
l four 152 idi 3.7 3.52
l four 120 mpfi 3.46 3.19
l four 152 idi 3.7 3.52
l four 134 mpfi 3.61 3.21
ohc four 90 2bbl 2.97 3.23
ohc four 98 spdi 3.03 3.39
ohc four 90 2bbl 2.97 3.23
ohc four 90 2bbl 2.97 3.23
ohc four 98 2bbl 2.97 3.23
ohc four 122 2bbl 3.35 3.46
ohc four 156 spdi 3.59 3.86
ohc four 151 mpfi 3.94 3.11
ohcf six 194 mpfi 3.74 2.9
ohcf six 194 mpfi 3.74 2.9
ohcf six 194 mpfi 3.74 2.9
dohcv eight 203 mpfi 3.94 3.11
ohc four 132 mpfi 3.46 3.9
ohc four 132 mpfi 3.46 3.9
ohc four 121 mpfi 3.54 3.07
ohc four 121 mpfi 3.54 3.07
ohc four 121 mpfi 2.54 2.07
ohc four 121 mpfi 3.54 3.07
dohc four 121 mpfi 3.54 3.07
dohc four 121 mpfi 3.54 3.07
ohcf four 97 2bbl 3.62 2.36
ohcf four 108 2bbl 3.62 2.64
ohcf four 108 2bbl 3.62 2.64
ohcf four 108 2bbl 3.62 2.64
ohcf four 108 2bbl 3.62 2.64
ohcf four 108 mpfi 3.62 2.64
ohcf four 108 2bbl 3.62 2.64
ohcf four 108 mpfi 3.62 2.64
ohcf four 108 2bbl 3.62 2.64
ohcf four 108 mpfi 3.62 2.64
ohcf four 108 2bbl 3.62 2.64
ohcf four 108 mpfi 3.62 2.64
ohc four 92 2bbl 3.05 3.03
ohc four 92 2bbl 3.05 3.03
ohc four 92 2bbl 3.05 3.03
ohc four 92 2bbl 3.05 3.03
ohc four 92 2bbl 3.05 3.03
ohc four 92 2bbl 3.05 3.03
ohc four 98 2bbl 3.19 3.03
ohc four 98 2bbl 3.19 3.03
ohc four 110 idi 3.27 3.35
ohc four 110 idi 3.27 3.35
ohc four 98 2bbl 3.19 3.03
ohc four 98 2bbl 3.19 3.03
ohc four 98 2bbl 3.19 3.03
ohc four 98 2bbl 3.19 3.03
ohc four 98 2bbl 3.19 3.03
dohc four 98 mpfi 3.24 3.08
dohc four 98 mpfi 3.24 3.08
ohc four 146 mpfi 3.62 3.5
ohc four 146 mpfi 3.62 3.5
ohc four 146 mpfi 3.62 3.5
ohc four 146 mpfi 3.62 3.5
ohc four 146 mpfi 3.62 3.5
ohc four 146 mpfi 3.62 3.5
ohc four 122 mpfi 3.31 3.54
ohc four 110 idi 3.27 3.35
ohc four 122 mpfi 3.31 3.54
ohc four 122 mpfi 3.31 3.54
ohc four 122 mpfi 3.31 3.54
dohc six 171 mpfi 3.27 3.35
dohc six 171 mpfi 3.27 3.35
dohc six 171 mpfi 3.27 3.35
dohc six 161 mpfi 3.27 3.35
ohc four 97 idi 3.01 3.4
ohc four 109 mpfi 3.19 3.4
ohc four 97 idi 3.01 3.4
ohc four 109 mpfi 3.19 3.4
ohc four 109 mpfi 3.19 3.4
ohc four 97 idi 3.01 3.4
ohc four 109 mpfi 3.19 3.4
ohc four 109 mpfi 3.19 3.4
ohc four 109 mpfi 3.19 3.4
ohc five 136 mpfi 3.19 3.4
ohc four 97 idi 3.01 3.4
ohc four 109 mpfi 3.19 3.4
ohc four 141 mpfi 3.78 3.15
ohc four 141 mpfi 3.78 3.15
ohc four 141 mpfi 3.78 3.15
ohc four 141 mpfi 3.78 3.15
ohc four 130 mpfi 3.62 3.15
ohc four 130 mpfi 3.62 3.15
ohc four 141 mpfi 3.78 3.15
ohc four 141 mpfi 3.78 3.15
ohcv six 173 mpfi 3.58 2.87
ohc six 145 idi 3.01 3.4
ohc four 141 mpfi 3.78 3.15
compression-ratio horsepower peak-rpm city-mpg highway-mpg price symboling
9 111 5000 21 27 13495 3
9 111 5000 21 27 16500 3
9 154 5000 19 26 16500 1
10 102 5500 24 30 13950 2
8 115 5500 18 22 17450 2
8.5 110 5500 19 25 15250 2
8.5 110 5500 19 25 17710 1
8.5 110 5500 19 25 18920 1
8.3 140 5500 17 20 23875 1
7 160 5500 16 22 13207.1 0
8.8 101 5800 23 29 16430 2
8.8 101 5800 23 29 16925 0
9 121 4250 21 28 20970 0
9 121 4250 21 28 21105 0
9 121 4250 20 25 24565 1
8 182 5400 16 22 30760 0
8 182 5400 16 22 41315 0
8 182 5400 15 20 36880 0
9.5 48 5100 47 53 5151 2
9.6 70 5400 38 43 6295 1
9.6 70 5400 38 43 6575 0
9.41 68 5500 37 41 5572 1
9.4 68 5500 31 38 6377 1
7.6 102 5500 24 30 7957 1
68 5500 31 38 6229 1
9.4 68 5500 31 38 6692 1
9.4 68 5500 31 38 7609 1
7.6 102 5500 24 30 8558 1
8.5 88 5000 24 30 8921 -1
7 145 5000 19 24 12964 3
9.6 58 4800 49 54 6479 2
9.2 76 6000 31 38 6855 2
10.1 60 5500 38 42 5399 1
9.2 76 6000 30 34 6529 1
9.2 76 6000 30 34 7129 1
9.2 76 6000 30 34 7295 0
9.2 76 6000 30 34 7295 0
9 86 5800 27 33 7895 0
 9 86 5800 27 33 9095 0
86 5800 27 33 8845 0
9 86 5800 27 33 10295 0
9 101 5800 24 28 12945 0
9.1 100 5500 25 31 10345 1
8.5 78 4800 24 29 6785 0
9.6 70 5400 38 43 13207.1 1
9.6 70 5400 38 43 13207.1 0
9.2 90 5000 24 29 11048 2
8.1 176 4750 15 19 32250 0
8.1 176 4750 15 19 35550 0
11.5 262 5000 13 17 36000 0
9 68 5000 30 31 5195 1
9 68 5000 31 38 6095 1
9 68 5000 31 38 6795 1
9 68 5000 31 38 6695 1
9 68 5000 31 38 7395 1
9.4 101 6000 17 23 10945 3
9.4 101 6000 17 23 11845 3
9.4 101 6000 17 23 13645 3
9.4 135 6000 16 23 15645 3
8.6 84 4800 26 32 8845 1
8.6 84 4800 26 32 8495 0
8.6 84 4800 26 32 10595 1
8.6 84 4800 26 32 10245 0
22.7 64 4650 36 42 10795 0
8.6 84 4800 26 32 11245 0
120 5000 19 27 18280 0
22 72 4200 31 39 18344 0
21.5 123 4350 22 25 25552 -1
21.5 123 4350 22 25 28248 -1
21.5 123 4350 22 25 28176 0
21.5 123 4350 22 25 31600 -1
8.3 155 4750 16 18 34184 -1
8.3 155 4750 16 18 35056 3
8 184 4500 14 16 40960 0
8 184 4500 14 16 45400 1
8 175 5000 19 24 16503 1
9.4 68 5500 37 41 5389 2
9.4 68 5500 31 38 6189 2
9.4 68 5500 31 38 6669 2
7.6 102 5500 24 30 7689 1
7.5 116 5500 23 30 9959 3
8.5 88 5000 25 32 8499 3
7 145 5000 19 24 12629 3
7 145 5000 19 24 14869 3
7 145 5000 19 24 14489 3
8.5 88 5000 25 32 6989 1
8.5 88 5000 25 32 8189 1
7.5 116 5500 23 30 9279 1
 7.5 116 5500 23 30 9279 -1
9.4 69 5200 31 37 5499 1
21.9 55 4800 45 50 7099 1
9.4 69 5200 31 37 6649 1
9.4 69 5200 31 37 6849 1
9.4 69 5200 31 37 7349 1
9.4 69 5200 31 37 7299 1
9.4 69 5200 31 37 7799 1
9.4 69 5200 31 37 7499 1
9.4 69 5200 31 37 7999 1
9.4 69 5200 31 37 8249 2
8.5 97 5200 27 34 8949 0
8.5 97 5200 27 34 9549 0
9 152 5200 17 22 13499 0
9 152 5200 17 22 14399 0
9 152 5200 19 25 13499 0
160 5200 19 25 17199 3
7.8 200 5200 17 23 19699 3
9 160 5200 19 25 18399 1
8.4 97 5000 19 24 11900 0
21 95 4150 28 33 13200 0
8.4 97 5000 19 24 12440 0
21 95 4150 25 25 13860 0
8.4 95 5000 19 24 15580 0
21 95 4150 28 33 16900 0
8.4 95 5000 19 24 16695 0
21 95 4150 25 25 17075 0
8.4 97 5000 19 24 16630 0
21 95 4150 28 33 17950 0
7 142 5600 18 24 18150 0
9.4 68 5500 37 41 5572 1
7.6 102 5500 24 30 7957 1
9.4 68 5500 31 38 6229 1
9.4 68 5500 31 38 6692 1
9.4 68 5500 31 38 7609 1
8.5 88 5000 24 30 8921 -1
7 145 5000 19 24 12764 3
9.5 143 5500 19 27 22018 3
9.5 207 5900 17 25 32528 3
9.5 207 5900 17 25 34028 3
9.5 207 5900 17 25 37028 3
10 288 5750 17 28 13207.1 1
8.7 104.256 5125.37 23 31 9295 0
8.7 104.256 5125.37 23 31 9895 2
9.31 110 5250 21 28 11850 3
9.3 110 5250 21 28 12170 2
9.3 110 5250 21 28 15040 3
9.3 110 5250 21 28 15510 2
9 160 5500 19 26 18150 3
9 160 5500 19 26 18620 2
 9 69 4900 31 36 5118 2
8.7 73 4400 26 31 7053 2
8.7 73 4400 26 31 7603 2
9.5 82 4800 32 37 7126 0
9.5 82 4400 28 33 7775 0
9 94 5200 26 32 9960 0
9 82 4800 24 25 9233 0
7.7 111 4800 24 29 11259 0
9 82 4800 28 32 7463 0
9 94 5200 25 31 10198 0
9 82 4800 23 29 8013 0
7.7 111 4800 23 23 11694 0
9 62 4800 35 39 5348 1
9 62 4800 31 38 6338 1
9 62 4800 31 38 6488 1
9 62 4800 31 37 6918 0
9 62 4800 27 32 7898 0
9 62 4800 27 32 8778 0
9 70 4800 30 37 6938 0
9 70 4800 30 37 7198 0
22.5 56 4500 34 36 7898 0
22.5 56 4500 38 47 7788 0
9 70 4800 38 47 7738 0
9 70 4800 28 34 8358 0
9 70 4800 28 34 9258 0
9 70 4800 29 34 8058 1
9 70 4800 29 34 8238 1
9.4 112 6600 26 29 9298 1
9.4 112 6600 26 29 9538 1
9.3 116 4800 24 30 8449 2
9.3 116 4800 24 30 9639 2
9.3 116 4800 24 30 9989 2
9.3 116 4800 24 30 11199 2
9.3 116 4800 24 30 11549 2
9.3 116 4800 24 30 17669 2
8.7 92 4200 29 34 8948 -1
22.5 73 4500 30 33 10698 -1
8.7 92 4200 27 32 9988 -1
8.7 92 4200 27 32 10898 -1
8.7 92 4200 27 32 11248 -1
9.3 161 5200 20 24 16558 3
9.3 161 5200 19 24 15998 3
9.2 156 5200 20 24 15690 -1
9.2 156 5200 19 24 15750 -1
23 52 4800 37 46 7775 2
9 85 5250 27 34 7975 2
23 52 4800 37 46 7995 2
9 85 5250 27 34 8195 2
9 85 5250 27 34 8495 2
23 68 4500 37 42 9495 2
10 100 5500 26 32 9995 2
8.5 90 5500 24 29 11595 3
8.5 90 5500 24 29 9980 3
8.5 110 5500 19 24 13295 0
23 68 4500 33 38 13845 0
9 88 5500 25 31 12290 0
9.5 114 5400 23 28 12940 -2
9.5 114 5400 23 28 13415 -1
9.5 114 5400 24 28 15985 -2
9.5 114 5400 24 28 16515 -1
7.5 162 5100 17 22 18420 -2
7.5 162 5100 17 22 18950 -1
9.5 114 5400 23 28 16845 -1
8.7 160 5300 19 25 19045 -1
8.8 134 5500 18 23 21485 -1
23 106 4800 26 27 22470 -1
9.5 114 5400 19 25 22625 -1
dSymboling
more
more
more
more
more
more
more
more
more
normal
more
normal
normal
normal
more
normal
normal
normal
more
more
normal
more
more
more
more
more
more
more
less
more
more
more
more
more
more
normal
normal
normal
normal
normal
normal
normal
more
normal
more
normal
more
normal
normal
normal
more
more
more
more
more
more
more
more
more
more
normal
more
normal
normal
normal
normal
normal
less
less
normal
less
less
more
normal
more
more
more
more
more
more
more
more
more
more
more
more
more
more
 less
more
more
more
more
more
more
more
more
more
more
normal
normal
normal
normal
normal
more
more
more
normal
normal
normal
normal
normal
normal
normal
normal
normal
normal
normal
more
more
more
more
more
less
more
more
more
more
more
more
normal
more
more
more
more
more
more
more
 more
more
more
normal
normal
normal
normal
normal
normal
normal
normal
normal
more
more
more
normal
normal
normal
normal
normal
normal
normal
normal
normal
normal
more
more
more
more
more
more
more
more
more
more
less
less
less
less
less
more
more
less
less
more
more
more
more
more
more
 more
more
more
normal
normal
normal
less
less
less
less
less
less
less
less
less
less
less
 IMPORTANTE : NO MODIFIQUE LOS DATOS SUMINISTRADOS. SU

EJERCICIO 2

Sistema de ventas por teléfono

PLANTEAMIENTO DEL PROBLEMA:
La empresa "OfiTel, S.A" se dedica a la venta y distribución de artículos de oficina. Las ventas se efectúan únicamente por teléfono. Se acerca el
decisiones respecto a las ventas del siguiente mes.
El informe consiste en completar, mediante Excel, los datos que a continuación se piden.

Sistema de ventas por teléfono

INSTRUCCIONES:
* De acuerdo a la tabla de artículos que se muestra abajo, responda, mediante las funciones apropiadas, las preguntas que se encuentran junto a
ORTANTE : NO MODIFIQUE LOS DATOS SUMINISTRADOS. SU MANIPULACIÓN PUEDE ALTERAR EL RESULTADO

rtículos de oficina. Las ventas se efectúan únicamente por teléfono. Se acerca el fin de mes y es preciso generar un informe de ventas que indique algunos datos estádisticos

a continuación se piden.

a, mediante las funciones apropiadas, las preguntas que se encuentran junto a la tabla.

Clave del
Fecha artículo Descripción Precio
3/1/1999 224 Estanterías 5,639.00 F
3/2/1999 224 Estanterías 5,639.00 F
3/3/1999 227 Portapapeles 332.00 F
3/4/1999 218 PC 15,269.00 F
3/5/1999 229 Agenda 1,025.00 F
3/6/1999 215 Calculadora 2,165.00 F
3/7/1999 223 PortaCD´s 325.00 F
3/8/1999 224 Estanterías 5,639.00 F
3/9/1999 221 Caja de CD´s 248.00 F
3/10/1999 215 Calculadora 2,165.00 F
3/11/1999 216 Engrapadora 152.00 F
3/12/1999 225 Esquinero 524.00 F
3/13/1999 221 Caja de CD´s 248.00 F
3/14/1999 222 Caja de disqu 75.00 F
3/15/1999 219 Sillón 1,245.00 F
3/16/1999 216 Engrapadora 152.00 F
3/17/1999 215 Calculadora 2,165.00 F
3/18/1999 217 Escritorio 3,589.00 F
3/19/1999 221 Caja de CD´s 248.00 F
3/20/1999 215 Calculadora 2,165.00 F
3/21/1999 221 Caja de CD´s 248.00 F
3/22/1999 225 Esquinero 524.00 F
3/23/1999 216 Engrapadora 152.00 F
3/24/1999 217 Escritorio 3,589.00 F
3/25/1999 217 Escritorio 3,589.00 F
3/26/1999 221 Caja de CD´s 248.00 F
3/27/1999 228 Calendario 89.00 F
3/28/1999 223 PortaCD´s 325.00 F
3/29/1999 229 Agenda 1,025.00 F
3/30/1999 220 Portaclips 56.00 F
3/31/1999 230 Grapas 45.00 F
EL RESULTADO

as que indique algunos datos estádisticos que se utilizarán para tomar

Unidades
vendidas Monto diario Conteste las preguntas:
9 50,751.00 F
10 56,390.00 F 1) Cuántas cajas de CD´s se vendieron en el mes de marzo?
10 3,320.00 F
5 76,345.00 F
8 8,200.00 F 2) Cúal es la cantidad de estanterías vendidas?
6 12,990.00 F
2 650.00 F
4 22,556.00 F 3) De las ventas totales, qué porcentaje
7 1,736.00 F corresponde a las calculadoras?
7 15,155.00 F
2 304.00 F
9 4,716.00 F
5 1,240.00 F
8 600.00 F
6 7,470.00 F
6 912.00 F
4 8,660.00 F
6 21,534.00 F
2 496.00 F
10 21,650.00 F
5 1,240.00 F
9 4,716.00 F
1 152.00 F
3 10,767.00 F
6 21,534.00 F
5 1,240.00 F
8 712.00 F
8 2,600.00 F
9 9,225.00 F
4 224.00 F
1 45.00 F
mes de marzo?
 IMPORTANTE : EN ESTA HOJA SE ENCUENTRAN TRES EJERCICIOS
EJERCICIO 3

ALUMNO Trimestre 1 Trimestre 2 Trimestre 3 DEFINITIVA SITUACION

A. Martínez 10.0 2.5 2.3
J. González 6.5 4.8 4.0
k.Montaner 3.4 10.0 5.8
G. Pérez 10.0 9.0 9.5
L. kats 4.7 5.5 10.0
H.Huerta 4.2 6.5 9.0
S.Fernandez 10.0 10.0 10.0
C.Nuñez 5.3 7.0 4.9
J.Vivanco 2.5 2.3 2.3
P.Urrutia 4.9 5.0 6.4

Nota máxima
Nota mínima
Nota más repetida

Promedio No. alumnos

Numero %
Reprobados
Aprobados

EJERCICIO 4

Venta Moneda Monto Monto a Pagar TC

BOL - 0001 USD 200 USD
BOL - 0002 EUR 145 EUR
BOL - 0003 USD 196
BOL - 0004 EUR 121
BOL - 0005 USD 106
BOL - 0006 EUR 143
BOL - 0007 USD 152
BOL - 0008 USD 106
BOL - 0009 USD 134
BOL - 0010 EUR 193
BOL - 0011 USD 130
BOL - 0012 EUR 143
BOL - 0013 USD 118
Calcular el monto a Pagar según corresponda la Modenda USD - EUR utilizando la funcion SI

EJERCICIO 5
ANTIGUEDA
CODIGO NOMBRE SALARIO COMISIÓN
D
ALVARO
230 5 2,300,000
CASTRO
ALBERTO
231 2 1,000,000
ANDRADE
ANA MARIA
232 ARIZA 3 700,000

233 LUZ MARIA 1 880,000

PELAEZ
MIGUEL
234 10 1,850,000
GALLEGO
JORGE LUIS
235 GOMEZ 4 3,500,000

LUZ DARY
236 10 970,000
GUTIERREZ
CARMEN
237 6 800,000
MARTINEZ

Se entrega un reporte de nomina donde le han autorizado pagar una prima

extraordinaria de $300.000 a los empleados que tengan un salario menor o igual a
$ 1.000.000 Y su tiempo de servicio sea 5 años o mas.
ERCICIOS

Si el promedio es menor que 5, la situación del alumno será "Reprobado"

Si el promedio es mayor o igual que 5,0, la situación es "Aprobado"

DEFINITIVA: promedio de los tres trimestres

CUANTOS ALUMNOS APROBADOS :

CUANTOS ALUMNOS REPROBADOS

CUANTOS ALUMNOS HAY EN CLASE

Monto
3.3
4.2
FUNCION SI