Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Ex1 Exemplo1: Série de vendas Gráfico t y(t) Trimestres (j) 1 920.00 Anos(i) 1 2 3 4 y(i) i*y(i) 2 1114.00 1 920.00 1114.00 1310.00 1147.00 1122.75 1122.75 3 1310.00 2 1003.00 1320.00 1570.00 1340.00 1308.25 2616.5 4 1147.00 3 1140.00 1430.00 1710.00 1530.00 1452.50 4357.5 5 1003.00 4 1310.00 1590.00 1830.00 1670.00 1600.00 6400 6 1320.00 y(j) 1093.25 1363.50 1605.00 1421.75 1370.88 14496.75 7 1570.00 c(j) -218.525 12.325 214.425 -8.225 8 1340.00 9 1140.00 10 1430.00 11 1710.00 n=anos 4 12 1530.00 m=trimestres 4 13 1310.00 14 1590.00 15 1830.00 a = 39.4 16 1670.00 b= 1035.975 Ex1 t(Tempo) Y(t) Ex2 Exemplo 2 Gráfico Trimestres (j) t y(t) Anos(i) 1 2 3 4 y(i) i*y(i) 1 323.00 1 323.00 294.00 250.00 305.00 293.00 293 2 294.00 2 354.00 304.00 296.00 326.00 320.00 640 3 250.00 3 396.00 325.00 310.00 362.00 348.25 1044.75 4 305.00 4 435.00 342.00 376.00 399.00 388.00 1552 5 354.00 5 499.00 364.00 410.00 456.00 432.25 2161.25 6 304.00 y(j) 401.40 325.80 328.40 369.60 356.30 5691 7 296.00 c(j) 58.09375 -26.16875 -32.23125 0.30625 8 326.00 9 396.00 10 325.00 n=anos 5 11 310.00 m=trimestres 4 12 362.00 13 435.00 14 342.00 a = 8.6625 15 376.00 b= 265.34375 16 399.00 17 499.00 18 364.00 19 410.00 20 456.00 ATENÇÃO: Resolvido considerando Modelo Linear Aditivo Podem resolver considerando o modelo Exponencial Multiplicativo Ex2 t (Tempo) Y(t) Ex3 Exemplo 3 Gráfico Trimestres (j) t y(t) Trimestres (j) Anos(i) 1 2 3 4 y(i) i*y(i) 1 234.00 Anos(i) 1 2 3 4 y(i) i*y(i) 1 234.00 156.00 92.00 352.00 208.50 208.5 2 156.00 1 2.37 2.19 1.96 2.55 2.27 2.2681677366 2 316.00 215.00 120.00 397.00 262.00 524 3 92.00 2 2.50 2.33 2.08 2.60 2.38 4.7550486477 3 452.00 300.00 240.00 510.00 375.50 1126.5 4 352.00 3 2.66 2.48 2.38 2.71 2.56 7.6650308305 4 610.00 370.00 290.00 680.00 487.50 1950 5 316.00 4 2.79 2.57 2.46 2.83 2.66 10.6484384697 5 815.00 515.00 397.00 875.00 650.50 3252.5 6 215.00 5 2.91 2.71 2.60 2.94 2.79 13.954704247 y(j) 485.40 311.20 227.80 562.80 396.80 7061.5 7 120.00 y(j) 2.64 2.46 2.30 2.73 2.53 39.2913899315 c(j) 130.20625 -127.20625 -238.34375 68.91875 8 397.00 c(j) 0.1632351349 -0.0575852636 -0.2505034409 0.1448535696 9 452.00 (1+sj) 1.4562473057 0.8758197539 0.5616898281 1.3958976291 10 300.00 n=anos 5 11 240.00 m=trimestres 4 12 510.00 a= 0.033253288 ATENÇÃO: 13 610.00 b= 2.1815910371 Resolvido considerando Modelo Linear Aditivo 14 370.00 ATENÇÃO: a = 27.7375 15 290.00 (1+r) = 1.079576166 Resolvido considerando Modelo EXPONENCIAL MULTIPLICATIVO b= 105.55625 16 680.00 yo = 151.9116346737 17 815.00 18 515.00 19 397.00 20 875.00 Ex3 t(Tempo) Y(t) Ex1(Alunos) Exemplo1: Série de vendas Gráfico t y(t) Trimestres (j) 1 920.00 Anos(i) 1 2 3 4 y(i) i*y(i) 2 1114.00 1 920.00 1114.00 1310.00 1147.00 3 1310.00 2 1003.00 1320.00 1570.00 1340.00 4 1147.00 3 1140.00 1430.00 1710.00 1530.00 5 1003.00 4 1310.00 1590.00 1830.00 1670.00 6 1320.00 y(j) 7 1570.00 c(j) 8 1340.00 9 1140.00 10 1430.00 11 1710.00 n=anos 4 12 1530.00 m=trimestres 4 13 1310.00 14 1590.00 15 1830.00 a = 16 1670.00 b= Ex1(Alunos) 920 1114 1310 1147 1003 1320 1570 1340 1140 1430 1710 1530 1310 1590 1830 1670 t(Tempo) Y(t) Ex2(alunos) Exemplo 2 Gráfico Trimestres (j) t y(t) Anos(i) 1 2 3 4 y(i) i*y(i) 1 323.00 1 323.00 294.00 250.00 305.00 2 294.00 2 354.00 304.00 296.00 326.00 3 250.00 3 396.00 325.00 310.00 362.00 4 305.00 4 435.00 342.00 376.00 399.00 5 354.00 5 499.00 364.00 410.00 456.00 6 304.00 y(j) 7 296.00 c(j) 8 326.00 9 396.00 10 325.00 n=anos 5 11 310.00 m=trimestres 4 12 362.00 13 435.00 14 342.00 a = 15 376.00 b= 16 399.00 17 499.00 18 364.00 19 410.00 20 456.00 Ex2(alunos) 323 294 250 305 354 304 296 326 396 325 310 362 435 342 376 399 499 364 410 456 t (Tempo) Y(t) Ex3(alunos) Exemplo 3 Gráfico Trimestres (j) t y(t) Trimestres (j) Anos(i) 1 2 3 4 y(i) i*y(i) 1 234.00 Anos(i) 1 2 3 4 y(i) i*y(i) 1 234.00 156.00 92.00 352.00 2 156.00 1 2.37 2.19 1.96 2.55 2.28 2.2811702279 2 316.00 215.00 120.00 397.00 3 92.00 2 2.50 2.33 2.08 2.60 2.42 4.8321255425 3 452.00 300.00 240.00 510.00 4 352.00 3 2.66 2.48 2.38 2.71 2.57 7.6983895343 4 610.00 370.00 290.00 680.00 5 316.00 4 2.79 2.57 2.46 2.83 2.68 10.7070631182 5 815.00 515.00 397.00 875.00 6 215.00 5 2.91 2.71 2.60 2.94 2.81 14.0574120945 y(j) 7 120.00 y(j) 2.66 2.48 2.38 2.71 2.57 39.5761605173 c(j) 8 397.00 c(j) 0.1296665718 -0.0754559295 -0.1994712636 0.1007823496 9 452.00 10 300.00 n=anos 5 11 240.00 n=anos 5 m=trimestres 4 12 510.00 m=trimestres 4 13 610.00 14 370.00 a = 15 290.00 a = 0.0271053211 b= 16 680.00 b= 2.2815239727 17 815.00 18 515.00 19 397.00 20 875.00 Ex3(alunos) 234 156 92 352 316 215 120 397 452 300 240 510 610 370 290 680 815 515 397 875 t(Tempo) Y(t) Ex2(EXP) Exemplo 2 Gráfico Exemplo 2 Gráfico Trimestres (j) t y(t) Trimestres (j) t y(t) Anos(i) 1 2 3 4 y(i) i*y(i) 1 323.00 Anos(i) 1 2 3 4 y(i) i*y(i) 1 323.00 1 323.00 294.00 250.00 305.00 293.00 293 2 294.00 1 2.51 2.47 2.40 2.48 2.46 2.4649474252 2 294.00 2 354.00 304.00 296.00 326.00 320.00 640 3 250.00 2 2.55 2.48 2.47 2.51 2.50 5.0081930784 3 250.00 3 396.00 325.00 310.00 362.00 348.25 1044.75 4 305.00 3 2.60 2.51 2.49 2.56 2.54 7.6197366085 4 305.00 4 435.00 342.00 376.00 399.00 388.00 1552 5 354.00 4 2.64 2.53 2.58 2.60 2.59 10.3486761036 5 354.00 5 499.00 364.00 410.00 456.00 432.25 2161.25 6 304.00 5 2.70 2.56 2.61 2.66 2.63 13.1636882858 6 304.00 y(j) 401.40 325.80 328.40 369.60 356.30 5691 7 296.00 y(j) 2.60 2.51 2.51 2.56 2.55 38.6052415015 7 296.00 c(j) 58.09375 -26.16875 -32.23125 0.30625 8 326.00 c(j) 0.0684250702 -0.0288930552 -0.0412927089 0.0174601796 8 326.00 9 396.00 9 396.00 10 325.00 10 325.00 n=anos 5 11 310.00 11 310.00 m=trimestres 4 12 362.00 n=anos 5 12 362.00 13 435.00 m=trimestres 4 13 435.00 14 342.00 14 342.00 a = 8.6625 15 376.00 15 376.00 b= 265.34375 16 399.00 a = 0.0104663238 16 399.00 17 499.00 b= 2.4358761705 17 499.00 18 364.00 18 364.00 19 410.00 19 410.00 20 456.00 20 456.00 Ex2(EXP) 323 294 250 305 354 304 296 326 396 325 310 362 435 342 376 399 499 364 410 456 t (Tempo) Y(t) 323 294 250 305 354 304 296 326 396 325 310 362 435 342 376 399 499 364 410 456 t (Tempo) Y(t)
Compartilhar