Escribe en cada celda la FORMULA necesaria para obtener el promedio en cad

Nombre del alumno: Ruflecindo Perez Martinez

ESPAÑOL MATEMATICAS
SEP-OCT 8 9
NOV-DIC 9 8
ENE-FEB 7 8
MAR-ABR 8 9
MAY-JUN 9 10
PROMEDIO 8.20 8.80

PROMEDIO GENERAL:

Escribe en cada celda la FUNCION necesaria para obtener el promedio en cada

Nombre del alumno: Ruflecindo Perez Martinez

ESPAÑOL MATEMATICAS
SEP-OCT 8 9
NOV-DIC 9 8
ENE-FEB 7 8
MAR-ABR 8 9
MAY-JUN 9 10
PROMEDIO 8.20 8.80

PROMEDIO GENERAL:
ara obtener el promedio en cada uno de los bimestres y al final el promedio general

erez Martinez

NATURALES HISTORIA GEOGRAFIA CIVISMO

8 9 8 7
8 7 7 6
8 7 8 8
9 7 7 6
9 8 8 7
8.40 7.60 7.60 6.80

7.90

ara obtener el promedio en cada uno de los bimestres y al final el promedio general

erez Martinez

NATURALES HISTORIA GEOGRAFIA CIVISMO

8 9 8 7
8 7 7 6
8 7 8 8
9 7 7 6
9 8 8 7
8.40 7.60 7.60 6.80

7.90
general

eneral
 Realiza las formulas necesarias para obtener los datos de cada columna y fila, según lo qu
alumno o nota.

RESULTADOS DE NOTAS DE I CICLO

Nota
Curso A Curso B Curso C Curso D Curso E Máxima
Créditos curso 5 3 2 3 5 18
Alumno 01 14 16 14 9 20 20
Alumno 02 18 18 12 8 22 22
Alumno 03 15 15 8 5 15 15
Alumno 04 8 15 10 10 15 15
Alumno 05 2 10 9 10 15 15
Alumno 06 0 7 10 8 9 10
Alumno 07 0 3 1 5 6 6
Alumno 08 0 8 3 3 7 8
Alumno 09 0 10 10 5 20 20
Alumno 10 3 14 20 8 28 28
Alumno 11 5 18 15 11 18 18
Alumno 12 9 15 10 13 19 19
Máximo 18 18 20 13 28
Mínimo 0 3 1 3 6

Desviac. Estandar 1 (de 6.5482 4.7378 5.0422 2.9375 6.4503

Muestra)
Desviac. Estandar 2 (de 6.5482 4.7378 5.0422 2.9375 6.4503
muestra)
Desviac. Estandar 3 6.2694 4.5361 4.8276 2.8124 6.1757
(población)
Desviac. Estandar 4 6.2694 4.5361 4.8276 2.8124 6.1757
(población)

Varianza 1 (Muestra) 42.8788 22.4470 25.4242 8.6288 41.6061

Varianza 2 (Muestra) 42.8788 22.4470 25.4242 8.6288 41.6061

Varianza M 42.8788 22.4470 25.4242 8.6288 41.6061

Varianza 3 (Población) 39.3056 20.5764 23.3056 7.9097 38.1389

Varianza 4 (Población) 39.3056 20.5764 23.3056 7.9097 38.1389

Varianza P 39.3056 20.5764 23.3056 7.9097 38.1389

TOTAL 74 149 122 95 194

Promedio 6.17 12.42 10.17 7.92 16.17
N° notas 12.00 12.00 12.00 12.00 12.00

N° Aprobados 3 7 4 1 9
% Aprobados 25.0% 58.3% 33.3% 8.3% 75.0%

N° Desaprobados 9 5 8 10 3
% Desaprobados 75.0% 41.7% 66.7% 83.3% 25.0%

Error estándar (Desv. 1.06 0.38 0.50 0.37 0.40

Estandar / Prom.)
na y fila, según lo que se solicita, de cada
Usando una
Usando combinación de Nota final,
fórmula Usando fórmula y usando VALOR
función función CRÉDITOS

Nota Promedio
Mínima notas 1 Promedio 2 Promedio 3 Nota Final 1 Nota Final 2

9 X 14.60 14.60 14.60 15.17 15.17

8 15.60 15.60 15.60 16.78 16.78
5 11.60 11.60 11.60 12.56 12.56
8 11.60 11.60 11.60 11.67 11.67
2 9.20 9.20 9.20 9.06 9.06
0 6.80 6.80 6.80 6.11 6.11
0 3.00 3.00 3.00 3.11 3.11
0 4.20 4.20 4.20 4.11 4.11
0 9.00 9.00 9.00 9.17 9.17
3 14.60 14.60 14.60 14.50 14.50
5 13.40 13.40 13.40 12.89 12.89
9 13.20 13.20 13.20 13.56 13.56
Realiza las formulas necesarias para completar las siguientes facturas

Mercancia cantidad precio total Mercancia

Lapiz 33 $3.00 $99.00 Escoba
Borrador 45 $2.50 $112.50 Trapeador
Cuaderno 65 $14.00 $910.00 Escuridor
Tijeras 67 $15.00 $1,005.00 Fabuloso
Pegamento 45 $22.00 $990.00 Pinol
Sacapuntas 76 $4.00 $304.00 Clorox
total $3,420.50 $3,420.50
IGV 16% $547.28
$3,967.78
Descuento 15% $595.17
$3,372.61

Mercancia cantidad precio total

Gansito 12 $8.00 $96.00 =SUMAPRODUCTO(R
Chocorol 9 $10.00 $90.00
Submarino 8 $9.00 $72.00
Pingüino 10 $9.00 $90.00
Rollo 6 $8.00 $48.00
Mamut 5 $8.00 $40.00
total $436.00
IGV 16% $69.76
$505.76
Descuento 15% $75.86
$429.90
 cantidad precio total Mercancia cantidad precio
12 $35.00 $420.00 Doritos 9 $8.00
18 $28.00 $504.00 Chetos 12 $6.00
10 $20.00 $200.00 Rancheritos 10 $7.00
23 $26.00 $598.00 Churrumaíz 8 $5.00
19 $33.00 $627.00 Ruffles 20 $9.00
25 $18.00 $450.00 Sabritones 18 $7.50
total $2,799.00 total
IGV 16% $447.84 IGV 16%
$3,246.84
Descuento 10% $324.68 Descuento 20%
$2,922.16

Mercancia cantidad precio

MAPRODUCTO(RANGO1, RANGO2) Pinol 20 $15.00
Fabuloso 25 $14.00
Flash 18 $12.00
Bret 15 $19.00
Cloralex 21 $10.00
Poet 17 $18.00
total
IGV 16%

Descuento 20%
total
$72.00
$72.00
$70.00
$40.00
$180.00
$135.00
$569.00
$91.04
$660.04
$132.01
$528.03

total
$300.00
$350.00
$216.00
$285.00
$210.00
$306.00
$1,667.00
$266.72
$1,933.72
$386.74
$1,546.98
Realiza las formulas necesarias para Calcular el costo total y completar la siguiente tabl

Costo x Cantidad (Kg.)

Alimentos
kilo 2 4 6 8
Fresa $35.0 $70.0 $140.0 $210.0 $280.0
Uva $39.0 $78.0 $156.0 $234.0 $312.0
Kiwi $45.0 $90.0 $180.0 $270.0 $360.0
Mango $25.0 $50.0 $100.0 $150.0 $200.0
Durazno $28.0 $56.0 $112.0 $168.0 $224.0
Sandia $8.0 $16.0 $32.0 $48.0 $64.0
Melon $12.0 $24.0 $48.0 $72.0 $96.0
Pera $29.0 $58.0 $116.0 $174.0 $232.0
Total $221.0 $442.0 $884.0 $1,326.0 $1,768.0

Realiza las formulas necesarias para Calcular la utilidad respectiva, asumiendo que:
a) El costo dismunuye 1%, 2%, 5%, 10%
b) El Precio aumenta 1, 2%, 3%, 5%
c) Las cantidades aumentan 1%, 3%, 5%, 10%
d) El costo dismunuye 1%, 2%, 5%, 10% y El Precio aumenta 1, 2%, 3%, 5%
e) El Precio aumenta 1, 2%, 3%, 5% y Las cantidades aumentan 1%, 3%, 5%, 10%
f) Las cantidades disminuyen 1%, 3%, 5%, 10% y El Precio aumenta 1, 2%, 3%, 5%
g) Considerar en un mismo escenario a), b) y c)

Alimentos Costo x Cant.

kilo Precio (Kg)
Unit Utilidad 1
Fresa 35.00 39.00 50.00 $200.00
Uva 39.00 45.10 79.00 $481.90
Kiwi 45.00 49.60 59.00 $271.40
Mango 25.00 28.90 87.00 $339.30
Durazno 28.00 31.70 59.00 $218.30
Sandia 8.00 9.60 55.00 $88.00
Melon 12.00 13.40 55.00 $77.00
Pera 29.00 31.90 68.00 $197.20
Total 221.00 249.20 512.00 1,873.10
completar la siguiente tabla

Cantidad (Kg.)
10 12 15 20 Total
$350.0 $420.0 $525.0 $700.0 $2,695.0
$390.0 $468.0 $585.0 $780.0 $3,003.0
$450.0 $540.0 $675.0 $900.0 $3,465.0
$250.0 $300.0 $375.0 $500.0 $1,925.0
$280.0 $336.0 $420.0 $560.0 $2,156.0
$80.0 $96.0 $120.0 $160.0 $616.0
$120.0 $144.0 $180.0 $240.0 $924.0
$290.0 $348.0 $435.0 $580.0 $2,233.0
$2,210.0 $2,652.0 $3,315.0 $4,420.0 $34,034.0

ctiva, asumiendo que:

, 2%, 3%, 5%
n 1%, 3%, 5%, 10%
menta 1, 2%, 3%, 5%

a) Disminución del Costo a) UTILIDAD por disminución del Costo

1% 2% 5% 10% 1% 2% 5%
34.65 34.30 33.25 31.50 217.50 235.00 287.50
38.61 38.22 37.05 35.10 512.71 543.52 635.95
44.55 44.10 42.75 40.50 297.95 324.50 404.15
24.75 24.50 23.75 22.50 361.05 382.80 448.05
27.72 27.44 26.60 25.20 234.82 251.34 300.90
7.92 7.84 7.60 7.20 92.40 96.80 110.00
11.88 11.76 11.40 10.80 83.60 90.20 110.00
28.71 28.42 27.55 26.10 216.92 236.64 295.80
 b) UTILIDAD por Aumento de
minución del Costo b) Aumento de precio
precio
10% 1% 2% 3% 5% 1% 2% 3% 5%
375.00 39.39 39.78 40.17 40.95 219.50 239.00 258.50 297.50
790.00 45.55 46.00 46.45 47.36 517.53 553.16 588.79 660.05
536.90 50.10 50.59 51.09 52.08 300.66 329.93 359.19 417.72
556.80 29.19 29.48 29.77 30.35 364.44 389.59 414.73 465.02
383.50 32.02 32.33 32.65 33.29 237.00 255.71 274.41 311.82
132.00 9.70 9.79 9.89 10.08 93.28 98.56 103.84 114.40
143.00 13.53 13.67 13.80 14.07 84.37 91.74 99.11 113.85
394.40 32.22 32.54 32.86 33.50 218.89 240.58 262.28 305.66
 Realiza las formulas necesarias para completar la siguiente tabla

Importe Cantidad de articulos por mes

por articulo

Articulo ENE FEB

1 Doritos $8.0 9 8
2 Chetos $6.0 12 14
3 Rancheritos $7.0 10 9
4 Churrumaíz $5.0 8 9
5 Ruffles $9.0 20 22
6 Sabritones $7.5 18 20
7 Gansito $8.0 12 18
8 Chocorol $10.0 10 15
9 Submarino $9.0 8 12
10 Pingüino $9.0 10 15
11 Rollo $8.0 8 10
12 Mamut $8.0 14 18
MAXIMO
MINIMO

SUB TOTAL
IGV
TOTAL
letar la siguiente tabla
TRIMESTRE I

rticulos por mes Totales por mes

Total I Trim.

MAR ENE FEB MAR

10 $72.0 $64.0 $80.0 $216.0
16 $72.0 $84.0 $96.0 $252.0
14 $70.0 $63.0 $98.0 $231.0
10 $40.0 $45.0 $50.0 $135.0
25 $180.0 $198.0 $225.0 $603.0
22 $135.0 $150.0 $165.0 $450.0
19 $96.0 $144.0 $152.0 $392.0
18 $100.0 $150.0 $180.0 $430.0
14 $72.0 $108.0 $126.0 $306.0
17 $90.0 $135.0 $153.0 $378.0
14 $64.0 $80.0 $112.0 $256.0
18 $112.0 $144.0 $144.0 $400.0
MAXIMO $180.0 $198.0 $225.0 $603.0
MINIMO $40.0 $45.0 $50.0 $135.0
PROMEDIO $91.9 $113.8 $131.8 $337.4
SUB TOTAL $1,103.0 $1,365.0 $1,581.0 $4,049.0
18% 198.54 245.7 284.58 728.82
TOTAL $1,301.5 $1,610.7 $1,865.6 $4,777.8
TRIMESTRE II
50%

Estimar las cantidades de articulos por

mes del II Trimestre, sabiendo que
estas se han aumentado en 50%, Totales por mes
respecto a los meses del trimestre
anterior

ABR MAY JUN ABR MAY JUN

14.00 12.00 15.00 $112.0 $96.0 $120.0
18.00 21.00 24.00 $108.0 $126.0 $144.0
15.00 14.00 21.00 $105.0 $98.0 $147.0
12.00 14.00 15.00 $60.0 $70.0 $75.0
30.00 33.00 38.00 $270.0 $297.0 $342.0
27.00 30.00 33.00 $202.5 $225.0 $247.5
18.00 27.00 29.00 $144.0 $216.0 $232.0
15.00 23.00 27.00 $150.0 $230.0 $270.0
12.00 18.00 21.00 $108.0 $162.0 $189.0
15.00 23.00 26.00 $135.0 $207.0 $234.0
12.00 15.00 21.00 $96.0 $120.0 $168.0
21.00 27.00 27.00 $168.0 $216.0 $216.0
MAXIMO $270.0 $297.0 $342.0
MINIMO $60.0 $70.0 $75.0
PROMEDIO $138.2 $171.9 $198.7
SUB TOTAL $1,658.5 $2,063.0 $2,384.5
IGV 18% 298.53 371.34 429.21
TOTAL $1,957.0 $2,434.3 $2,813.7
 TRIMESTRE III
35%

Estimar las cantidades de articulos por

mes del III Trimestre, sabiendo que
Total II estas se han aumentado en 50%, Totales por mes
Trim. respecto a los meses del trimestre
anterior

JUL AGO SEP JUL AGO

$328.0 19.00 16.00 20.00 $152.0 $128.0
$378.0 24.00 28.00 32.00 $144.0 $168.0
$350.0 20.00 19.00 28.00 $140.0 $133.0
$205.0 16.00 19.00 20.00 $80.0 $95.0
$909.0 41.00 45.00 51.00 $369.0 $405.0
$675.0 36.00 41.00 45.00 $270.0 $307.5
$592.0 24.00 36.00 39.00 $192.0 $288.0
$650.0 20.00 31.00 36.00 $200.0 $310.0
$459.0 16.00 24.00 28.00 $144.0 $216.0
$576.0 20.00 31.00 35.00 $180.0 $279.0
$384.0 16.00 20.00 28.00 $128.0 $160.0
$600.0 28.00 36.00 36.00 $224.0 $288.0
$909.0 MAXIMO $369.0 $405.0
$205.0 MINIMO $80.0 $95.0
$508.8 PROMEDIO $185.3 $231.5
$6,106.0 SUB TOTAL $2,223.0 $2,777.5
1099.08 IGV 18% 400.14 499.95
$7,205.1 TOTAL $2,623.1 $3,277.5
 TRIMESTRE IV
35%

Estimar las cantidades de articulos por

mes del IV Trimestre, sabiendo que
es por mes Total III estas se han aumentado en 50%,
Trim. respecto a los meses del trimestre
anterior

SEP OCT NOV DIC

$160.0 $440.0 26.00 22.00 27.00
$192.0 $504.0 32.00 38.00 43.00
$196.0 $469.0 27.00 26.00 38.00
$100.0 $275.0 22.00 26.00 27.00
$459.0 $1,233.0 55.00 61.00 69.00
$337.5 $915.0 49.00 55.00 61.00
$312.0 $792.0 32.00 49.00 53.00
$360.0 $870.0 27.00 42.00 49.00
$252.0 $612.0 22.00 32.00 38.00
$315.0 $774.0 27.00 42.00 47.00
$224.0 $512.0 22.00 27.00 38.00
$288.0 $800.0 38.00 49.00 49.00
$459.0 $1,233.0 MAXIMO
$100.0 $275.0 MINIMO
$266.3 $683.0 PROMEDIO
$3,195.5 $8,196.0 SUB TOTAL
575.19 1475.28 IGV 18%
$3,770.7 $9,671.3 TOTAL
 Totales por mes Total IV
Trim.

OCT NOV DIC

$208.0 $176.0 $216.0 $600.0
$192.0 $228.0 $258.0 $678.0
$189.0 $182.0 $266.0 $637.0
$110.0 $130.0 $135.0 $375.0
$495.0 $549.0 $621.0 $1,665.0
$367.5 $412.5 $457.5 $1,237.5
$256.0 $392.0 $424.0 $1,072.0
$270.0 $420.0 $490.0 $1,180.0
$198.0 $288.0 $342.0 $828.0
$243.0 $378.0 $423.0 $1,044.0
$176.0 $216.0 $304.0 $696.0
$304.0 $392.0 $392.0 $1,088.0
$495.0 $549.0 $621.0 $1,665.0
$110.0 $130.0 $135.0 $375.0
$250.7 $313.6 $360.7 $925.0
$3,008.5 $3,763.5 $4,328.5 $11,100.5
541.53 677.43 779.13 1998.09
$3,550.0 $4,440.9 $5,107.6 $13,098.6