excel MF

7/24/2019 excel MF

1/38

REALIZADO POR MARITZA MIREYA FLORES RAMIREZ

primer ejercicio

-4

-3.5

-3

-2.5

-2-1.5

-1

-0.5

0

0.5

1

1.5

2

2.5

33.5

4

7/24/2019 excel MF

2/38

segundo ejer

1

5

25

125

625

312515625

78125

390625

1953125

7/24/2019 excel MF

3/38

tercer eje

4/25/2006

4/26/2006

4/27/2006

4/28/2006

4/29/2006

4/30/20065/1/2006

5/2/2006

5/3/2006

5/4/2006

5/5/2006

5/6/2006

5/7/2006

5/8/2006

5/9/2006

5/10/20065/11/2006

5/12/2006

5/13/2006

5/14/2006

5/15/2006

5/16/2006

5/17/2006

5/18/2006

5/19/2006

5/20/2006

5/21/2006

5/22/2006

5/23/2006

5/24/2006

5/25/2006

7/24/2019 excel MF

4/38

4/25/2006

4/26/2006

4/27/2006

4/28/2006

5/1/2006

5/2/20065/3/2006

5/4/2006

5/5/2006

5/8/2006

5/9/2006

5/10/2006

5/11/2006

5/12/2006

5/15/2006

5/16/20065/17/2006

5/18/2006

5/19/2006

5/22/2006

5/23/2006

5/24/2006

5/25/2006

7/24/2019 excel MF

5/38

1

2

3

4

5

6

78

9

10

11

12

13

14

15

16

1718

19

20

7/24/2019 excel MF

6/38

Capita

interes !""" !!"" !#"" !$"" !%"" !&"" !'"" !(""

!) 10 11 12 13 14 15 16 17

#) 20 22 24 26 28 30 32 34

$) 30 33 36 39 42 45 48 51

%) 40 44 48 52 56 60 64 68&) 50 55 60 65 70 75 80 85

') 60 66 72 78 84 90 96 102

() 70 77 84 91 98 105 112 119

*) 80 88 96 104 112 120 128 136

+) 90 99 108 117 126 135 144 153

!") 100 110 120 130 140 150 160 170

7/24/2019 excel MF

7/38

!*"" !+"" #"""

18 19 20

36 38 40

54 57 60

72 76 8090 95 100

108 114 120

126 133 140

144 152 160

162 171 180

180 190 200

7/24/2019 excel MF

8/38

IdEmpeadoApeidos ,om-re .ni/car ,om-re 0 apeido

! Davilo Nancy Nancy Davilo

# Fuller Andrew Andrew Fuller

$ everlin! "ane# "ane# everlin!

% $eacoc% &ar!are# &ar!are# $eacoc%

& 'uc(anan )#even )#even 'uc(anan

' *uya+a &ic(ael &ic(ael *uya+a( %in! ,o'er# ,o'er# %in!

* calla(an aura aura calla(an

+ dod*wor#( Anne Anne dod*wor#(

7/24/2019 excel MF

9/38

ec(a ac#ual

1ec2a actua 2/22/2016

IdEmpeadoApeidos ,om-re cargo

1 Davilo Nancy re$re*en#an#e de ven#a*

2 Fuller Andrew vice$re*iden#e co+ercial

3 everlin! "ane# re$re*en#an#e de ven#a*

4 $eacoc% &ar!are# re$re*en#an#e de ven#a*5 'uc(anan )#even !eren#e de ven#a*

6 *uya+a &ic(ael re$re*en#an#e de ven#a*

7%in! ,o'er# re$re*en#an#e de ven#a*

8 calla(an aura coordinador ven#a* in#erno

9 dod*wor#( Anne re$re*en#an#e de ven#a*

7/24/2019 excel MF

10/38

1ec2a de nacimiento edad

6/15/1989 #(

2/18/1995 #!

4/12/1998 !*

8/19/1974 %#12/25/1972 %$

9/23/1984 $!

6/15/1985 $!

1/1/1984 $#

7/14/1994 ##

7/24/2019 excel MF

11/38

$re*#a+o 30000

$lao 6 ao*

in#ere* 15

$a!o #i+e*#ral 4

$eriodo de $a!o 1

cuo#a 1917.57

$a!o del ca$i#al 792.57

$a!o de in#ere* 1125.00

7/24/2019 excel MF

12/38

,o3 Apeido nom-res nota! nota# nota$

! Davilo Nancy 8 3 8

# Fuller Andrew 1 8 0

$ everlin! "ane# 3 3 2

% $eacoc% &ar!are# 1 4 6

& 'uc(anan )#even 6 0 2

' *uya+a &ic(ael 1 2 3( %in! ,o'er# 9 8 10

* calla(an aura 5 3 2

+ dod*wor#( Anne 5 0 6

7/24/2019 excel MF

13/38

nota tota

!+

+

*

!!

*

'#(

!"

!!

7/24/2019 excel MF

14/38

,o3 producto cantidad 4aor unitario 4entas

! ca+i*a 74 68 5032

# $an#alon 53 80 4240

$ cor'a#a 61 96 5856

% ca+i*a 40 86 3440& ca+i*a 48 79 3792

' $an#alon 51 46 2346

( $an#alon 48 99 4752

* cor'a#a 60 72 4320

+ cor'a#a 52 81 4212

!" ca+i*a 30 67 2010

*u+a#oria del $roduc#o ca+i*a* !%#(%

*u+a#oria del $roduc#o $an#alon !!$$*

*u+a#oria del $roduc#o cor'a#a !%$**

7/24/2019 excel MF

15/38

w w2

-4 -13.6339032 -13.6339032-3.5 -12.1624653 -12.1624653

-3 -10.6379293 -10.6379293

-2.5 -9.05003151 -9.05003151

-2 -7.37925861 -7.37925861

-1.5 -5.58139243 -5.58139243

-1 -3.55775043 -3.55775043

-0.5 -1.22708916 -1.22708916

0 1.25992105 1.25992105

0.5 3.77291084 3.77291084

1 6.44224957 6.442249571.5 9.41860757 9.41860757

2 12.6207414 12.6207414

2.5 15.9499685 15.9499685

3 19.3620707 19.3620707

3.5 22.8375347 22.8375347

4 26.3660968 26.3660968

7/24/2019 excel MF

16/38

,o3 producto cantidad 4aor unitario 4entas rai5 cuadrada

! ca+i*a 74 68 5.032 #3#%$#!!+*#*

# $an#alon 53 80 4.24 #3"&+!#'"#*#

$ cor'a#a 61 96 5.856 #3%!++!($&%

% ca+i*a 40 86 3.44 !3*&%(#$'++!

& ca+i*a 48 79 3.792 !3+%($"&*$!!

' $an#alon 51 46 2.346 !3&$!''&(&++( $an#alon 48 99 4.752 #3!(++"*#&&

* cor'a#a 60 72 4.32 #3"(*%'"+'+!

+ cor'a#a 52 81 4.212 #3"$!&('

!" ca+i*a 30 67 2.01 !3%!((%%'*(+

7/24/2019 excel MF

17/38

,o3 producto cantidad 4aor unitario 4entas rai5 cuadrada

! ca+i*a 74 48 3552 59.598657703

# $an#alon 53 80 4240 65.1152823844

$ cor'a#a 61 96 5856 76.5245058788

% ca+i*a 40 86 3440 58.6515131945

& ca+i*a 48 79 3792 61.5792172734

' $an#alon 51 46 2346 48.4355241532( $an#alon 48 99 4752 68.9347517585

* cor'a#a 60 72 4320 65.7267069006

+ cor'a#a 52 81 4212 64.8999229584

!" ca+i*a 30 67 2010 44.8330235429

7/24/2019 excel MF

18/38

redondear

&+3'

'&3!#

('3

&*3'&

'!3&*

%*3%%'*3+$

'&3($

'%3+

%%3*$

7/24/2019 excel MF

19/38

CO,CEOTO E,ERO FE6RERO MARZO

i#e+1 408 215 308

i#e+2 798 392 414

i#e+3 575 439 587

i#e+4 360 290 750

i#e+5 484 462 633

i#e+6 749 635 522i#e+7 289 658 781

i#e+8 446 244 676

i#e+9 262 594 474

i#e+10 464 326 439

7/24/2019 excel MF

20/38

apeido nom-re genero escuea 4aor matricua edad

5urita aleandra e+enino inor+a#ica 1468 24

andre7s rance* +a*culino co+ercio 1141 19-ac2 *(irley e+enino (o#eleria 721 20

da4indson $aul +a*culino #uri*+o 1197 27

ede2art ca#(erine e+enino inor+a#ica 1190 19

1aconer c(arle* +a*culino co+ercio 1150 25

1ord (un#er +a*culino (o#eleria 1198 19

gue4ara (ec#or +a*culino #uri*+o 1108 23

aguirre #a#iana e+enino #uri*+o 1352 28

gandet de''ie e+enino (o#eleria 1083 19

ga0 +ic(ael +a*culino co+ercio 1411 26

endara cri*#ina e+enino inor+a#ica 1232 222a4orson +onica e+enino co+ercio 1454 20

gon5aga !a'riel +a*culino inor+a#ica 947 26

jac8s %ri* +a*culino co+ercio 880 26

7/24/2019 excel MF

21/38

tiempo estudios nota! nota# nota tota

3 7.6 9.8 17.4

5 8.6 8.5 17.12 9.6 6.3 15.9

3 9.9 5.2 15.1

3 5.6 4.2 9.8

5 6.3 6.3 12.6

4 4.5 2.3 6.8

3 8.9 5.4 14.3

2 7.5 6.5 14

2 7.4 8.2 15.6

4 7.6 6.2 13.8

1 7.2 5.4 12.65 7 8.4 15.4

4 7.3 5.6 12.9

3 6.5 4.5 11

7/24/2019 excel MF

22/38

aumnos 9 cumpes as 1unsiones

"

""

"

"

!

"

"

"

"

!

""

"

!

7/24/2019 excel MF

23/38

apeido nom-re genero escuea 4aor matri edad


andre7s rance* +a*culino co+ercio 1141 19-ac2 *(irley e+enino (o#eleria 721 20









endara cri*#ina e+enino inor+a#ica 1232 222a4orson +onica e+enino co+ercio 1454 20



7/24/2019 excel MF

24/38

tiempo estudios nota! nota# nota tota cump

3 7.6 9.8 17.4 !

5 8.6 8.5 17.1 !2 9.6 6.3 15.9 !

3 9.9 5.2 15.1 !

3 5.6 4.2 9.8 "

5 6.3 6.3 12.6 !

4 4.5 2.3 6.8 !

3 8.9 5.4 14.3 !

2 7.5 6.5 14 !

2 7.4 8.2 15.6 "

4 7.6 6.2 13.8 !

1 7.2 5.4 12.6 !5 7 8.4 15.4 !

4 7.3 5.6 12.9 !

3 6.5 4.5 11 !

7/24/2019 excel MF

25/38



andre7s rance* +a*culino co+ercio 1141 19

-ac2 *(irley e+enino (o#eleria 721 20



1aconer c(arle* +a*culino co+ercio 1150 251ord (un#er +a*culino (o#eleria 1198 19





endara cri*#ina e+enino inor+a#ica 1232 22

2a4orson +onica e+enino co+ercio 1454 20



7/24/2019 excel MF

26/38

tiempo estudios nota! nota# nota tota cump

3 7.6 9.8 17.4 !

5 8.6 8.5 17.1 "

2 9.6 6.3 15.9 !

3 9.9 5.2 15.1 !

3 5.6 4.2 9.8 !

5 6.3 6.3 12.6 "4 4.5 2.3 6.8 !

3 8.9 5.4 14.3 !

2 7.5 6.5 14 !

2 7.4 8.2 15.6 !

4 7.6 6.2 13.8 "

1 7.2 5.4 12.6 !

5 7 8.4 15.4 "

4 7.3 5.6 12.9 !

3 6.5 4.5 11 "

7/24/2019 excel MF

27/38

















7/24/2019 excel MF

28/38

tiempo estudios nota! nota# nota tota cumpen a 1unsion

3 7.6 9.8 17.4 apro-ado

5 8.6 8.5 17.1 apro-ado

2 9.6 6.3 15.9 apro-ado

3 9.9 5.2 15.1 apro-ado

3 5.6 4.2 9.8 repro-ado

5 6.3 6.3 12.6 repro-ado

4 4.5 2.3 6.8 repro-ado

3 8.9 5.4 14.3 repro-ado

2 7.5 6.5 14 repro-ado

2 7.4 8.2 15.6 apro-ado

4 7.6 6.2 13.8 repro-ado

1 7.2 5.4 12.6 repro-ado

5 7 8.4 15.4 apro-ado

4 7.3 5.6 12.9 repro-ado

3 6.5 4.5 11 repro-ado

7/24/2019 excel MF

29/38

*i la no#a e* +ayo o i!ual a 15en#once* a$ro'ado

*i la no#a e* +ayor a 10 y +enor 15 en#once* *u*$en*o

*i la no#a e* #o#al e* +enor 10 en#once* re$ro'ado

apeido nom-re genero escuea 4aor matricua edad5urita aleandra e+enino inor+a#ica 1468 24









gandet de''ie e+enino (o#eleria 1083 19ga0 +ic(ael +a*culino co+ercio 1411 26





7/24/2019 excel MF

30/38

tiempo estudios nota! nota# nota tota cump3 7.6 9.8 17.4 apro-ado

5 8.6 8.5 17.1 apro-ado

2 9.6 6.3 15.9 apro-ado

3 9.9 5.2 15.1 apro-ado

3 5.6 4.2 9.8 repro-ado

5 6.3 6.3 12.6 suspenso

4 4.5 2.3 6.8 repro-ado

3 8.9 5.4 14.3 suspenso

2 7.5 6.5 14 suspenso

2 7.4 8.2 15.6 apro-ado4 7.6 6.2 13.8 suspenso

1 7.2 5.4 12.6 suspenso

5 7 8.4 15.4 apro-ado

4 7.3 5.6 12.9 suspenso

3 6.5 4.5 11 suspenso

7/24/2019 excel MF

31/38

Apeido ,om-re :enero Escuea ;aor matricua

uri#a Aleandra Fe+enino nor+a#ica 1468

Andrew* France* Fe+enino :o+ercio 1141

;ac( )(irley Fe+enino uri*+o 1197

?del(ar# :a#(erine Fe+enino nor+a#ica 1190

Falconer :(arle* &a*culino :o+ercio 1150Ford uri*+o 1352

@ande# Di''ie Fe+enino

7/24/2019 excel MF

32/38








7/24/2019 excel MF

33/38








7/24/2019 excel MF

34/38








7/24/2019 excel MF

35/38








7/24/2019 excel MF

36/38








7/24/2019 excel MF

37/38








7/24/2019 excel MF

38/38








Documents

excel MF