{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Exercicio 1","Exercicio 2","Exercicio 3","Exercicio 4","Exercicio 5"],"not_rendered":{"charts":5,"images":1,"macros":0,"external_links":1,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Exercicio 1","index":0,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":8}
[null,"N0=",10]
[null,"λ=",0.5,0.7,0.8999999999999999,1.0999999999999999,1.2999999999999998,1.4999999999999998]
[]
[]
[null,"t","λ=0,5","λ=0,7","λ=0,9","λ=1,1","λ=1,3","λ=1,5"]
[null,0,10,10,10,10,10,10]
[null,1,5,7,9,10.999999999999998,12.999999999999998,14.999999999999998]
[null,2,2.5,4.8999999999999995,8.099999999999998,12.099999999999998,16.899999999999995,22.499999999999993]
[null,3,1.25,3.4299999999999993,7.289999999999997,13.309999999999995,21.96999999999999,33.749999999999986]
[null,4,0.625,2.4009999999999994,6.560999999999996,14.640999999999993,28.560999999999982,50.624999999999964]
[null,5,0.3125,1.6806999999999994,5.904899999999996,16.10509999999999,37.12929999999997,75.93749999999994]
[null,6,0.15625,1.1764899999999994,5.314409999999996,17.715609999999987,48.26808999999996,113.90624999999987]
[null,7,0.078125,0.8235429999999995,4.782968999999996,19.487170999999982,62.748516999999936,170.85937499999977]
[null,8,0.0390625,0.5764800999999996,4.304672099999996,21.43588809999998,81.5730720999999,256.28906249999966]
[null,9,0.01953125,0.4035360699999997,3.874204889999996,23.579476909999975,106.04499372999985,384.43359374999943]
[null,10,0.009765625,0.2824752489999998,3.486784400999996,25.937424600999968,137.8584918489998,576.650390624999]
[]
[null,"t","λ=0,5","λ=0,7","λ=0,9","λ=1,1","λ=1,3","λ=1,5"]
[null,0,2.302585092994046,2.302585092994046,2.302585092994046,2.302585092994046,2.302585092994046,2.302585092994046]
[null,1,1.6094379124341003,1.9459101490553132,2.1972245773362196,2.3978952727983702,2.5649493574615367,2.70805020110221]
[null,2,0.9162907318741551,1.5892352051165808,2.091864061678393,2.4932054526026954,2.8273136219290276,3.1135153092103742]
[null,3,0.22314355131420976,1.2325602611778483,1.9865035460205664,2.5885156324070198,3.0896778863965184,3.5189804173185384]
[null,4,-0.4700036292457356,0.8758853172391159,1.8811430303627399,2.6838258122113445,3.3520421508640093,3.9244455254267026]
[null,5,-1.1631508098056809,0.5192103733003834,1.7757825147049136,2.7791359920156693,3.6144064153315,4.329910633534867]
[null,6,-1.8562979903656263,0.16253542936165088,1.6704219990470872,2.874446171819994,3.876770679798991,4.735375741643031]
[null,7,-2.5494451709255714,-0.19413951457708162,1.5650614833892607,2.969756351624319,4.139134944266482,5.140840849751195]
[null,8,-3.242592351485517,-0.550814458515814,1.4597009677314343,3.0650665314286436,4.401499208733973,5.546305957859359]
[null,9,-3.9357395320454622,-0.9074894024545465,1.354340452073608,3.1603767112329684,4.663863473201464,5.951771065967524]
[null,10,-4.628886712605407,-1.2641643463932788,1.2489799364157814,3.255686891037293,4.926227737668954,6.3572361740756875]

{"sheet":"Exercicio 2","index":1,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,null,"λ (Média Geométrica)","λ (Média Aritmética)"]
[null,"2 anos",1.1434919997417727,1.1439542243438585]
[null,"4 anos",1.137049290382428,1.137577648563821]
[null,"8 anos",1.1242082131528082,1.12475938945906]
[null,"10 anos",1.1091472499972028,1.1101646476168667]
[{"$nulls":5},"MEDIA GEOMÉTRICA"]
[null,null,"Ano","Censo (n)","λ","2 anos","4 anos","8 anos","10 anos"]
[null,1,1966,34,1.1764705882352942,34,34,34,34]
[null,2,1967,40,1.1114378604524227,38.87872799122027,38.659675873002556,38.22307924719548,37.7110064999049]
[null,3,1968,42,1.166733356198461,44.4575144180969,43.957957017812234,42.970699621687814,41.82705915399616]
[null,4,1969,54,1.0956687893691057,50.83681206549832,49.98236383376467,48.30801343962371,46.39236763612517]
[null,5,1970,49,1.158659658782187,58.13148788927335,56.83241132881846,54.3082654699212,51.455966984467466]
[null,6,1971,71,1.1168911158446038,66.47289133446982,64.6212529721553,61.05379808336847,57.072244276768956]
[null,7,1972,66,1.0738866519577224,76.01121944067044,73.47754983561255,68.63718124949601,63.30152279074688]
[null,8,1973,56,1.098327094832683,86.91822132102295,83.54759589962275,77.16248288834133,70.21070992399217]
[null,9,1974,72,1.0950797709571205,99.39029071237454,94.99773463082391,86.74669701033635,77.87401583254724]
[null,10,1976,77,1.0084915895390676,113.6520022816093,108.01710674991655,97.52134924289828,86.37375050690841]
[null,11,1977,37]
[null,12,1978,32]
[null,13,1979,26]
[null,14,1980,22,null,null,"MEDIA ARITMÉTICA"]
[null,15,1981,31,null,"Ano","2 anos","4 anos","8 anos","10 anos"]
[null,16,1982,28,null,1966,34,34,34,34]
[null,17,1983,41,null,1967,38.89444362769119,38.67764005116991,38.24181924160804,37.74559801897347]
[null,18,1984,36,null,1968,44.4934630914014,43.99881882140773,43.01284526199479,41.90382852382159]
[null,19,1985,37,null,1969,50.89848505909619,50.05207285444259,48.37910157577828,46.520149026946]
[null,20,1986,44,null,1970,58.22553699605585,56.93811934350185,54.41484875095023,51.64502485158364]
[null,21,1987,34,null,1971,66.60734901132771,64.77153191642705,61.203612058625865,57.334480815522674]
[null,22,1988,47,null,1972,76.19575827385405,73.68264697136556,68.83933733174919,63.65071369086074]
[null,23,1989,45,null,1973,87.16445955445886,83.81973228164418,77.4276910280245,70.66277213517648]
[null,24,1990,41,null,1974,99.71215171997261,95.35145395220177,87.08752248790557,78.44731152707917]
[null,25,1991,32,null,1976,114.0661371784784,108.46968277408715,97.9525086229988,87.08943195795041]
[null,26,1992,40]
[null,27,1993,120]
[null,28,1994,96]
[null,29,1995,93]
[null,30,1996,67]
[null,31,1997,84]
[null,32,1998,90]
[null,33,1999,37]
[null,34,2000,34]
[null,35,2001,34]
[null,36,2003,43]

{"sheet":"Exercicio 3","index":2,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":7}
[null,null,"Nt = N0ert"]
[{"$nulls":5},"r","t"]
[null,null,"2N0 = N0 ert",null,null,0.01,69.31471805599453]
[{"$nulls":5},0.1,6.931471805599452]
[null,null,"2N0/N0 = (N0 ert)/N0",null,null,0.5,1.3862943611198906]
[{"$nulls":5},1,0.6931471805599453]
[null,null,"2 = ert"]
[]
[null,null,"ln (2) = rt"]
[]
[null,null,"t = ln (2) / r"]

{"sheet":"Exercicio 4","index":3,"n_rows":122,"n_cols":7,"rows_kept":122,"cut":false,"hidden":false,"merged":[[31,1,31,2]],"flags":["formulas_cached_only"]}
{"$rows_empty":19}
[null,"Celta","Palio"]
["Valor emprestado",27000,31000]
["Juros ao mês",1.1,0.7]
["Parcelas",100,50]
["Valor mensal em juros",297.00000000000006,217]
["Valor final",56700,52700]
["Valor final",56700,52700]
[null,1.9999999999999998,2]
["Valor final",56700.00000000001,41850]
["Valor das Pretações",567.0000000000001,837]
["No de carros pagos",2.1,1.35]
["Tempo de duplicação",95.23809523809521,74.07407407407408]
["2da profissão","jogador de futebol"]
{"$rows_empty":89}
[{"$nulls":5},217,0]

{"sheet":"Exercicio 5","index":4,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":11}
[null,"r med =",0.30243918999999997]
[null,"dp =",0.04717609914028852,"r est",0.3566041,0.3547064,0.3597754,0.3093683,0.3017808,0.2195323,0.2771164,0.3025889,0.2996943,0.243225]
[]
[null,null,null,"Tempo","Pop 1","Pop 2","Pop 3","Pop 4","Pop 5","Pop 6","Pop 7","Pop 8","Pop 9","Pop 10","r est"]
[null,null,"r est",0,1,1,1,1,1,1,1,1,1,1,1]
[null,null,0.3566041,1,1.428470226529486,1.4257619891044384,1.4330075249233893,1.3625641104642205,1.3522647777805772,1.2454940767647025,1.3193199309375603,1.3533579845982253,1.3494462188059337,1.2753555468364814,1.428470226529486]
[null,null,0.3547064,2,2.040527188081201,2.032797249575045,2.0535105664870583,1.8565809551251526,1.8286200292259538,1.5512554952559587,1.7406050801690889,1.8315778344757703,1.8210050974496321,1.626531770846581,2.032797249575045]
[null,null,0.3597754,3,2.914832334597928,2.8982850500001476,2.942696094285647,2.5297105776249165,2.472778457466347,1.9320795308899916,2.296414974158249,2.4787804867009102,2.457348443179737,2.0744063160549517,2.942696094285647]
[null,null,0.3093683,4,4.163751205298572,4.132264657879867,4.216905646674,3.4468928429334245,3.343851211286328,2.4063936115618096,3.0297060451104403,3.354677363742952,3.316059564937544,2.645605601573314,3.4468928429334245]
[null,null,0.3017808,5,5.947794627445273,5.8916258781247715,6.0428575235757735,4.69661248039707,4.52177221516142,2.9971489895646544,3.9971515701962144,4.540079395972449,4.474844041240219,3.3740877787081924,4.52177221516142]
[null,null,0.2195323,6,8.496247538817608,8.400056231054357,8.659460303324003,6.39943560654739,6.114633299709647,3.73293131368409,5.273521733538231,6.144352701249202,6.0385613711978765,4.3031615640886764,3.73293131368409]
[null,null,0.2771164,7,12.136636646425373,11.976480880577194,12.409071776438669,8.719641284708304,8.268603240241582,4.649343840163014,6.957462329289382,8.315508788423282,8.14871380939055,5.488060969694043,6.957462329289382]
[null,null,0.3025889,8,17.336824099625318,17.075611202763014,17.782293232951066,11.881070270665665,11.181340923221043,5.79073021376549,9.179118719778744,11.253860214809363,10.996251038213774,6.999228999076098,11.253860214809363]
[null,null,0.2996943,9,24.765137048893635,24.34575739362543,25.48216001321315,16.18871994471246,15.120133498828377,7.212320181387317,12.110194275446162,15.230501579264548,14.838849384558403,8.926505527550457,14.838849384558403]
[null,null,0.243225,10,35.376260930266845,34.71125548778948,36.51612705023633,22.05816879102152,20.446423965805817,8.982902065648428,15.977220675122062,20.612320921733556,20.024229193423096,11.384468338427986,11.384468338427986]