Prévia do material em texto
Sugestões de Gráficos Sugestões de Gráficos Gráfico de Barras Gráfico de Linhas Gráfico de Área Sombreada Gráfico de Bolhas Gráfico de Barras Bala Gráfico de Colunas Gráfico de Pizza Gráfico de Pizza com Destaque Gráfico de Dispersão Gráfico de Barras Empilhadas Gráfico de Colunas Empilhadas (Total) Gráfico de Colunas Empilhadas (Volume) Gráfico de Colunas Empilhadas (Total) Gráfico de Dois Eixos (Coluna e Linha) Gráfico em Cascata Gráfico de Coluna Variavel Gráfico de Linha Formatação Condicional Gráfico de Histograma (Coluna) Gráfico Medidor Gráfico de Gantt Gráfico de Pareto Barras Series 1 Series 2 Series 3 Mai 7.90 0.35 9.99 Jun 3.22 8.01 0.91 Jul 1.43 8.54 8.08 Ago 9.80 7.79 8.71 Set 2.36 8.17 5.70 Out 4.39 9.71 7.19 Nov 3.24 0.26 7.65 Dez 8.44 7.78 9.44 Gráfico Barras Series 1 Mai Jun Jul Ago Set Out Nov Dez 7.8970106887491394 3.2174907359052751 1.4348066186844655 9.8014713219132776 2.358689184656706 4.3889940172686099 3.2416577844782619 8.4377681791896109 Series 2 Mai Jun Jul Ago Set Out Nov Dez 0.34992391259077937 8.0149419520764624 8.5405564918246046 7.7913136356925623 8. 1719435254149193 9.7069218792098688 0.26167349141405616 7.7794038909810492 Series 3 Mai Jun Jul Ago Set Out Nov Dez 9.9938913053011689 0.91391651377436212 8.080299167530038 8.710057108624504 5.6971622117331755 7.1915499773238274 7.6474951991872597 9.443622621320797 Linha Series 1 Series 2 Series 3 Series 4 Jan 3.01 4.64 9.71 1.56 Fev 3.53 5.22 10.17 2.48 Mar 3.95 5.31 10.62 3.44 Abr 4.51 5.87 11.37 3.51 Mai 5.37 6.53 12.01 3.84 Jun 6.27 6.85 12.39 4.32 Jul 7.00 7.61 13.27 4.52 Ago 7.09 8.32 13.55 5.49 Set 7.67 8.53 13.84 5.76 Out 7.86 9.52 14.12 5.90 Nov 8.28 10.04 14.95 6.12 Dez 9.02 10.55 15.52 6.98 Gráfico Linhas Series 1 Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 3.0067707331622096 3.5284134015480264 3.951151279013783 4.5074241521566378 5.3665544417134274 6.2692379576840755 6.9970309937049846 7.0877751033728362 7.6704668051167104 7.8637258653519035 8.2793511546114562 9.018748048222136 Series 2 Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 4.6434095761598488 5.2165156492296489 5.3070687220351678 5.8749414017705606 6.5274877529629531 6.8491225439681855 7.6137622826519387 8.323205681245156 8.5311019140577429 9.5187580712287936 10.037646212677735 10.553830615502505 Series 3 Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 9.7089230211571191 10.172148842214373 10.619925888983978 11.366937037177115 12.00864626235014 12.390992375352688 13.274698060671685 13.548618450234695 13.842718788180694 14.120827687054145 14.947084549366396 15.524421095308256 Series 4 Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 1.5586692172925343 2.4773310469625329 3.4376805436552917 3.5107699497352476 3.8381914700509179 4.3179027731486839 4.5243840245070395 5.4877808095146285 5.7585646463718714 5.9019871978797713 6.1213905170991749 6.9798945581264844 Linha Área Sombreada Series 1 Series 2 Jan 2.61 2.61 Fev 3.13 3.13 Mar 9.14 9.14 Abr 2.12 2.12 Mai 3.57 3.57 Jun 2.89 2.89 Jul 2.49 2.49 Ago 1.22 1.22 Set 2.14 2.14 Out 0.21 0.21 Nov 0.60 0.60 Dez 3.50 3.50 Gráfico Linha e Área Sombreada Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 2.6111323454369018 3.1334666369983233 9.13633488185007 2.1222066862673739 3.5717724892743519 2.8921542538807277 2.4924069166823237 1.2186022879530278 2.144802025705177 0.21389466082661457 0.5994552952661536 3.4971741683872981 2.6111323454369018 3.1334666369983233 9.13633488185007 2.1222066862673739 3.5717724892743519 2.8921542538807277 2.4924069166823237 1.2186022879530278 2.144802025705177 0.21389466082661457 0.5994552952661536 3.4971741683872981 Bolhas Series 1 Series 2 Value Jan 0.0759451004 7.7149435835 4.1728973363 Feb 7.6899944192 8.6618329727 0.0732676574 Mar 3.2092227351 8.6794141169 5.3548193367 Apr 1.4653026094 9.43984017 6.3298261404 May 3.8095591573 8.9472819013 2.6201751293 Jun 1.7860700738 4.3720175088 0.5681263906 Jul 6.5652042822 3.5335053439 6.6942508308 Aug 3.8223479694 4.2822218409 0.1338348102 Sep 1.3939810173 5.8524924083 5.8331202616 Oct 5.8568156299 5.2651773404 2.3802059387 Nov 3.4917998572 3.7200433712 0.0781412625 Dec 1.2895130029 2.8456697967 4.0483202565 Gráfico Bolhas Series 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 7.5945100420833356E-2 7.6899944191917253 3.2092227351132374 1.4653026093588029 3.8095591572780996 1.7860700737946011 6.5652042822160972 3.822347969429913 1.3939810173476808 5.8568156299326812 3.4917998572229791 1.28951300286958 7.7149435834873259 8.6618329726770718 8.6794141168658978 9.4398401700103207 8.9472819013215243 4.3720175088229603 3.5335053439022435 4.282221840940994 5.852492408312111 5.2651773404039837 3.7200433712420899 2.8456697967428779 Value Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 4.1728973362885124 7.3267657383815354E-2 5.3548193367135788 6.3298261403806251 2.6201751292666042 0.56812639057333136 6.6942508307658244 0.13383481023542032 5.833120261639877 2.3802059386902119 7.8141262496611574E-2 4.0483202565250709 0 0 0 0 0 0 0 0 0 0 0 0 Barra Bala Real FE Serie 1 90% 4 Serie 2 255% 8 Serie 3 25% 7 Serie 4 360% 8 Serie 5 33% 5 Gráfico Barras Bala FE Serie 1 Serie 2 Serie 3 Serie 4 Serie 5 4 8 7 8 5 Real Serie 1 Serie 2 Serie 3 Serie 4 Serie 5 0.9 2.5499999999999998 0.25 3.6 0.33 Colunas Series 1 Series 2 Series 3 Series 4 Jan 7.41 9.38 5.52 6.25 Fev 5.74 8.27 7.29 3.39 Mar 6.52 5.42 7.51 6.20 Abr 2.02 0.70 0.24 1.88 Mai 7.90 0.35 9.99 6.84 Jun 3.22 8.01 0.91 1.61 Jul 1.43 8.54 8.08 7.62 Gráfico de Colunas Series 1 Jan Fev Mar Abr Mai Jun Jul 7.4063547950436277 5.744560826023255 6.5234346695976946 2.0198793781168245 7.8970106887491394 3.2174907359052751 1.4348066186844655 Series 2 Jan Fev Mar Abr Mai Jun Jul 9.3758515606652253 8.2658492783220083 5.4182749742435643 0.704585867141 54059 0.34992391259077937 8.0149419520764624 8.5405564918246046 Series 3 Jan Fev Mar Abr Mai Jun Jul 5.5172576993812772 7.2905738170888679 7.5069009317542008 0.23783900169277672 9.9938913053011689 0.91391651377436212 8.080299167530038 Series 4 Jan Fev Mar Abr Mai Jun Jul 6.2499851704271769 3.3900261884833527 6.1989462121196937 1.8823927645 968563 6.8446126016406561 1.6105941681661329 7.6194794989886638 Pizza Value Category A 5 Catedgory B 4 Category C 3 Catedgory D 2 Category E 1 Gráfico de Pizza Value Category A Catedgory B Category C Catedgory D Category E 5 4 3 2 1 Pizza com Destaque Value Category A 5 Category B 4 Category C 3 Category D 2 Category E 1 Gráfico de Pizza com Destaque Value Category A Category B Category C Category D Category E 5 4 3 2 1 Dispersão Series 1 Series 2 Jan 1 5.353762575 Fev 2 7.4628698217 Mar 3 0.2674471865 Abr 4 3.3199455845 Mai 5 1.8902809026 Jun 6 6.1403139763 Jul 7 4.6757327658 Ago 8 3.1341024948 Set 9 3.1526477687 Out 10 8.2875919024 Nov 11 5.1536724173 Dez 12 0.7932350599 Series 1 5.3537625750242857 7.4628698216920863 0.26744718654035049 3.3199455844565051 1.8902809026323109 6.1403139763015897 4.6757327657713121 3.1341024947737672 3.1526477687386922 8.2875919024207185 5.1536724173387993 0.79323505990132936 1 2 3 4 5 6 7 8 9 10 11 12 Barras Empilhadas Series 1 Series 2 Series 3 Series 4 Jan 7.41 9.38 5.52 6.25 Fev 5.74 8.27 7.29 3.39 Mar 6.52 5.42 7.51 6.20 Abr 2.02 0.70 0.24 1.88 Mai 7.90 0.35 9.99 6.84 Jun 3.22 8.01 0.91 1.61 Jul 1.43 8.54 8.08 7.62 Ago 9.80 7.79 8.71 8.21 Series 1 Jan Fev Mar Abr Mai Jun Jul Ago 7.4063547950436277 5.744560826023255 6.5234346695976946 2.0198793781168245 7.8970106887491394 3.2174907359052751 1.4348066186844655 9.8014713219132776 Series 2 Jan Fev Mar Abr Mai Jun Jul Ago 9.3758515606652253 8.2658492783220083 5.4182749742435643 0.70458586714154059 0.34992391259077937 8.014941952076 4624 8.5405564918246046 7.7913136356925623 Series 3 Jan Fev Mar Abr Mai Jun Jul Ago5.5172576993812772 7.2905738170888679 7.5069009317542008 0. 23783900169277672 9.9938913053011689 0.91391651377436212 8.080299167530038 8.710057108624504 Series 4 Jan Fev Mar Abr Mai Jun Jul Ago 6.2499851704271769 3.3900261884833527 6.1989462121196937 1.8823927645968563 6.8446126016406561 1.6105941681661329 7.6194794989886638 8.2083750937336752 Colunas Empilhadas Series 1 Series 2 Series 3 Series 4 Jan 7.41 9.38 5.52 6.25 Fev 5.74 8.27 7.29 3.39 Mar 6.52 5.42 7.51 6.20 Abr 2.02 0.70 0.24 1.88 Mai 7.90 0.35 9.99 6.84 Jun 3.22 8.01 0.91 1.61 Jul 1.43 8.54 8.08 7.62 Ago 9.80 7.79 8.71 8.21 Set 2.36 8.17 5.70 4.48 Out 4.39 9.71 7.19 4.96 Nov 3.24 0.26 7.65 1.37 Dez 8.44 7.78 9.44 3.65 Series 1 Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 7.4063547950436277 5.744560826023255 6.5234346695976946 2.0198793781168245 7.8970106887491394 3.2174907359052751 1.4348066186844655 9.8014713219132776 2.358689184656706 4.3889940172686099 3.2416577844782619 8.4377681791896109 Series 2 Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 9.3758515606652253 8.2658492783220083 5.4182749742435643 0.70458586714154059 0.34992391259077937 8.0149419520764624 8.5405564918246046 7.7913136356925623 8.1719435254149193 9.7069218792098688 0.26167349141405616 7.77 94038909810492 Series 3 Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 5.5172576993812772 7.2905738170888679 7.5069009317542008 0.23783900169277672 9.9938913053011689 0.91391651377436212 8.080299167530038 8.710057108624504 5.6971622117331755 7.1915499773238274 7.6474951991872597 9.443622621320797 Series 4 Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 6.2499851704271769 3.3900261884833527 6.1989462121196937 1.8823927645968563 6.8446126016406561 1.6105941681661329 7.6194794989886638 8.2083750937336752 4.4822521193414833 4.9602422825121462 1.3663298796340406 3.6462787019970522 Colunas Empilhadas Volume Item A Item B Item C Negative Item D Total Jan 0.08 0.51 1.31 -1.90 -0.00 Fev 1.00 1.32 1.18 -1.61 1.89 Mar 1.71 1.95 1.02 -1.56 3.12 Abr 2.08 2.02 1.53 -1.66 3.97 Mai 2.25 2.10 1.18 -1.57 3.96 Jun 2.99 2.62 1.30 -1.10 5.81 Jul 3.02 3.24 1.57 -1.75 6.08 Ago 3.50 4.09 1.46 -1.05 8.00 Set 3.72 4.90 1.49 -1.46 8.65 Out 4.54 5.11 1.07 -1.58 9.14 Nov 5.16 5.85 1.73 -1.98 10.75 Dez 5.57 6.74 1.93 -1.73 12.50 Gráfico de Colunas Empilhadas Volume Item A Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 7.7851075530615432E-2 1.0005790077714414 1.7122012645446878 2.0787924944309228 2.2528341227988333 2.9925053434435211 3.0204346295748343 3.4954117946233447 3.7208447763672097 4.5437695323702156 5.1588148762363577 5.5705367813619677 Item B Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 0.51022564698385864 1.3220160775707186 1.9477541853600833 2.0174278393071203 2.098981935303498 2.6198704075367294 3.2373346461447992 4.0949199005538608 4.8953243714820065 5.1110543634138814 5.8493551979326392 6.7383250393932137 Item C Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 1.3070153040216645 1.1771350394139455 1.015949494871013 1.5306470210219199 1.1786619063858066 1.2981816559187518 1.5672915822159075 1.4610832528151327 1.4897696516777517 1.066637972964438 1.7290865102184281 1.9268783730788539 Negative Item D Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez -1.8991104700110808 -1.611243939552593 -1.5559081953737151 -1.660381689096269 -1.5736231069500368 -1.1037889434368151 -1.7491857924243126 -1.050219503426953 -1.4581695444783294 -1.5817940428401911 -1.9829685433225777 -1.7307675569499912 Barras Empilhadas com Total Item A Item B Item C Negative Item D Total Jan 0.27 0.98 1.68 -1.72 1.20 Fev 0.45 1.08 1.68 -1.11 2.10 Mar 0.88 1.25 1.97 -1.95 2.14 Abr 1.39 1.85 1.78 -1.24 3.78 Mai 1.43 2.54 1.02 -1.61 3.38 Jun 2.16 3.29 1.97 -1.40 6.02 Jul 2.74 3.73 1.44 -1.46 6.45 Ago 3.65 3.83 1.31 -1.28 7.51 Set 3.83 4.26 1.67 -1.72 8.03 Out 4.17 5.14 1.23 -1.82 8.72 Nov 5.10 6.08 1.02 -1.04 11.15 Dez 5.50 6.40 1.33 -1.46 11.78 Gráfico de Barras Empilhadas com Total Item A Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 0.27049738952134206 0.4459093918975503 0.87529636310393233 1.38542701078 88649 1.433235788845475 2.1605638256088735 2.7401919543928459 3.6531347692716505 3.830867065989656 4.1712198328276742 5.0985204120424656 5.4999479450524529 Item B Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 0.97575268480576138 1.0758139879213084 1.2486566508619694 1.850419988282946 2.538227437173374 3.2908218510296692 3.7313667519138729 3.8306979858405494 4.2563313555997064 5.137517848204892 6.0795395589632353 6.4003411373753512 Item C Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 1.6770550573500442 1.6812642199589094 1.9667907888726281 1.7750726605545877 1.0207156893270402 1.9701161308877788 1.4424282949311475 1.3081688316095665 1.6693089099568832 1.2263121876036445 1.0188721872211124 1.3321663356297688 Negative Item D Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez -1.7229341374841454 -1.1056555312686347 -1.9486160056959623 -1.2351266843078061 -1.6128636514766677 -1.3970050605503666 -1.4621237118842147 -1.2774577339568074 -1.7242194093650198 -1.8151139977842004 -1.0431169748797959 -1.4559084155765403 Total Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 1.2003709941930021 2.0973320685091332 2.1421277971425674 3.7757929753185921 3.3793152638692212 6.0244967469759549 6.4518632893536516 7.5145438527649597 8.0322879221812258 8.7199358708520105 11.153815183347019 11.776547002481031 Dois Eixos Colunas e Linha Series 1 (left axis) Series 2 (right axis) Jan 0.17 5.60 Fev 0.95 8.52 Mar 1.56 8.74 Abr 2.09 1.08 Mai 2.69 5.54 Jun 2.73 3.03 Jul 3.49 6.00 Ago 3.65 5.78 Set 4.01 4.32 Out 4.57 7.56 Nov 5.45 5.90 Dez 6.16 2.43 Gráfico de Dois Eixos Colunas e Linha Series 1 (left axis) Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 0.16524610295508513 0.95367012757052638 1.5631570183722234 2.0893599068549289 2.6904240313447216 2.726302417160837 3.4887703644632353 3.6548990455084089 4.0102636999877044 4.572606515628646 5.4476800106658754 6.155354712618343 Series 2 (right axis) Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez 5.6031318500236305 8.5196234200167851 8.7406150291158049 1.0751861122066075 5.5350237095065236 3.0292676330564561 5.9972009307664091 5.7806582241401046 4.3232467406241781 7.5579277968939085 5.9023720470420393 2.4277038271309248 Cascata Value Change Start 100 Step 1 80 20 Step 2 70 10 Step 3 62 8 Step 4 52 10 Final result 52 Em itálico são valores calculados Em cinza é a entrada de dados Gráfico em Cascata Value Start Step 1 Step 2 Step 3 Step 4 Final result 100 80 70 62 52 52 Change Start Step 1 Step 2 Step 3 Step 4 Final result 20 10 8 10 Coluna Variável % Percentual Custo Serie1 20% 152.00 Serie2 15% 112.20 Serie3 12% 90.00 Serie4 30% 225.00 Serie5 7% 52.50 Serie6 16% 120.00 Total 100% Serie1 (20%) Serie2 (15%) Serie3 (12%) Serie4 (30%) Serie5 (7%) Serie6 (16%) 0 152 0 0 0 0 0 1 20 152 0 0 0 0 0 1 20 0 0 0 0 0 0 1 20 0 113 0 0 0 0 2 35 0 113 0 0 0 0 2 35 0 0 0 0 0 0 2 35 0 0 90 0 0 0 3 47 0 0 90 0 0 0 3 47 0 0 0 0 0 0 3 47 0 0 0 225 0 0 4 77 0 0 0 225 0 0 4 77 0 0 0 0 0 0 4 77 0 0 0 0 53 0 5 84 0 0 0 0 53 0 5 84 0 0 0 0 0 0 5 84 0 0 0 0 0 120 6 100 0 0 0 0 0 120 Gráfico Coluna Variável Serie1 (20%) 0 20 20 20 35 35 35 47 47 47 77 77 77 84.000000000000014 84.000000000000014 84.000000000000014 100 152 152 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Serie2 (15%) 0 20 20 20 35 35 35 47 47 47 77 77 77 84.000000000000014 84.000000000000014 84.000000000000014 100 0 0 0 112.5 112.5 0 0 0 0 0 0 0 0 0 0 0 0 Serie3 (12%) 0 20 20 20 35 35 35 47 47 47 77 77 77 84.000000000000014 84.000000000000014 84.000000000000014 100 0 0 0 0 0 0 90 90 0 0 0 0 0 0 0 0 0 Serie4 (30%) 0 20 20 20 35 35 35 47 47 47 77 77 77 84.000000000000014 84.000000000000014 84.000000000000014 100 0 0 0 0 0 0 0 0 0 225 225 0 0 0 0 0 0 Serie5 (7%) 0 20 20 20 35 35 35 47 47 47 77 77 77 84.000000000000014 84.000000000000014 84.000000000000014 100 0 0 0 0 0 0 0 0 0 0 0 0 52.5 52.5 0 0 0 Serie6 (16%) 0 20 20 20 35 35 35 47 47 47 77 77 77 84.00000000000001484.000000000000014 84.000000000000014 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 120 120 Linha Formatação Condicional Linha Condicional Aperte F9 para mudar a Data DATA MEAN ABOVE MEAN DETERMINES WHERE CROSSES MEAN BELOW MEAN DETERMINES WHERE CROSSES MEAN ANDY POPE'S DYNAMIC SORTING 1 0.86679 0.44451 0.86679 1.62 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 20 ERROR:#N/A 0.4396256092 2 0.18574 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.18574 ERROR:#N/A 0.44451 19.9830177478 0.4445101141 0.4445101141 3 0.23005 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.23005 ERROR:#N/A 0.44451 19 0.7272497023 ERROR:#N/A 4 0.08690 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.08690 ERROR:#N/A 0.44451 18 0.6655440587 ERROR:#N/A 5 0.31872 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.31872 5.20 0.44451 17 0.5324888162 ERROR:#N/A 6 0.94041 0.44451 0.94041 6.60 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 16.466336279 0.4445101141 0.4445101141 7 0.11830 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.11830 7.76 0.44451 16 ERROR:#N/A 0.3676308754 8 0.54977 0.44451 0.54977 8.30 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 15 ERROR:#N/A 0.3073509407 9 0.19992 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.19992 9.42 0.44451 14 ERROR:#N/A 0.0451729274 10 0.78237 0.44451 0.78237 10.68 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 13 ERROR:#N/A 0.4416629894 11 0.28224 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.28224 11.31 0.44451 12.9921049028 0.4445101141 0.4445101141 12 0.80228 0.44451 0.80228 12.99 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 12 0.8022823233 ERROR:#N/A 13 0.44166 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.44166 ERROR:#N/A 0.44451 11.3120313637 0.4445101141 0.4445101141 14 0.04517 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.04517 ERROR:#N/A 0.44451 11 ERROR:#N/A 0.2822408703 15 0.30735 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.30735 ERROR:#N/A 0.44451 10.6755427549 0.4445101141 0.4445101141 16 0.36763 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 0.36763 16.47 0.44451 10 0.7823660678 ERROR:#N/A 17 0.53249 0.44451 0.53249 ERROR:#N/A 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 9.4199396678 0.4445101141 0.4445101141 18 0.66554 0.44451 0.66554 ERROR:#N/A 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 9 ERROR:#N/A 0.1999163897 19 0.72725 0.44451 0.72725 19.98 0.44451 ERROR:#N/A ERROR:#N/A 0.44451 8.3008602455 0.4445101141 0.4445101141 20 0.43963 0.44451 ERROR:#N/A 0.4396256092 8 0.5497659337 ERROR:#N/A 7.7560504131 0.4445101141 0.4445101141 7 ERROR:#N/A 0.1183004781 6.6032041262 0.4445101141 0.4445101141 6 0.9404099242 ERROR:#N/A 5.2023410287 0.4445101141 0.4445101141 5 ERROR:#N/A 0.3187159072 4 ERROR:#N/A 0.0869040223 3 ERROR:#N/A 0.2300520765 2 ERROR:#N/A 0.1857366322 1.6200369694 0.4445101141 0.4445101141 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A 1 0.8667857369 ERROR:#N/A Gráfico com Linha Formatação Condicional 20 19.983017747824793 19 18 17 16.466336278990109 16 15 14 13 12.992104902778483 12 11.312031363711611 11 10.675542754900498 10 9.419939667823737 9 8.3008602454586331 8 7.7560504130751795 7 6.6032041262366015 6 5.2023410286502294 5 4 3 2 1.6200369693802372 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 #N/A 0.44451011406647573 0.72724970225427255 0.66554405865070487 0.53248881620761557 0.44451011406647573 #N/A #N/A #N/A #N/A 0.44451011406647573 0.80228232334572036 0.44451011406647573 #N/A 0.44451011406647573 0.78236606778297801 0.44451011406647573 #N/A 0.44451011406647573 0.54976593374755134 0.44451011406647573 #N/A 0.44451011406647573 0.94040992415161706 0.44451011406647573 #N/A #N/A #N/A #N/A 0.44451011406647573 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 0.8667857369455092 20 19.983017747824793 19 18 17 16.466336278990109 16 15 14 13 12.992104902778483 12 11.312031363711611 11 10.675542754900498 10 9.419939667823737 9 8.3008602454586331 8 7.7560504130751795 7 6.6032041262366015 6 5.2023410286502294 5 4 3 2 1.6200369693802372 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0.4396256091863302 0.44451011406647573 #N/A #N/A #N/A 0.44451011406647573 0.36763087537803973 0.30735094066707447 4.5172927388162698E-2 0.44166298936473636 0.44451011406647573 #N/A 0.44451011406647573 0.28224087027972566 0.44451011406647573 #N/A 0.44451011406647573 0.19991638974873105 0.44451011406647573 #N/A 0.444 51011406647573 0.118300478085545 0.44451011406647573 #N/A 0.44451011406647573 0.31871590716338316 8.6904022284767679E-2 0.23005207645431547 0.18573663224273229 0.44451011406647573 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 0.44451011406647573 Histograma Coluna Número de Estudantes 22 29 20 Bin Frequency 40 25 0-20 1 30 30 21-25 8 48 35 26-30 2 24 40 31-35 2 21 36-40 3 19 40+ 2 24 22 25 52 35 40 31 37 21 23 Passo - 1 Passo - 2 Passo - 3 Gráfico Histograma Coluna Frequency 0-20 21-25 26-30 31-35 36-40 40+ 1 8 2 2 3 2 Bin Frequency Medidor Barra Percentual 6 40 50 1 44 159 100 40% complete Bands Dial Dial Lables Lables Velocidade 25 180 180 25 Percent Success 180 Share 75 45 9 0 44 25 90 18 10 1 45 18 20 135 18 30 18 40 18 50 18 60 18 70 18 80 18 90 9 100 Percentage 25 Description Percent Success Gráfico de Medidor Barra 6 50 44 100 Percentual 40 1 159 25 Percent Success 0 10 20 30 40 50 60 70 80 90 100 180 45 90 45 Series 2 25 Percent Success 0 10 20 30 40 50 60 70 80 90 100 180 9 18 18 18 18 18 18 18 18 18 9 Series 3 25 Percent Success 0 10 20 30 40 50 60 70 80 90 100 180 44 1 135 Gantt Start Date Duration Série 1 1-Jun 10 Série 2 12-Jun 7 Série 3 20-Jun 10 Série 4 1-Jul 5 Série 5 7-Jul 3 Série 6 7-Jul 3 Série 7 11-Jul 2 Série 8 13-Jul 2 Gráfico de Gantt Start Date Série 1 Série 2 Série 3 Série 4 Série 5 Série 6 Série 7 Série 8 41061 41072 41080 41091 41097 41097 41101 41103 Duration Série 1 Série 2 Série 3 Série 4 Série 5 Série 6 Série 7 Série 8 10 7 10 5 3 3 2 2 Pareto Complaint Count Cumulative Count Cumulative % Série 1 789 789 45.8 Série 2 621 1410 81.9 Série 3 109 1519 88.2 Série 4 65 1584 92.0 Série 5 45 1629 94.6 Série 6 30 1659 96.3 Série 7 27 1686 97.9 Série 8 15 1701 98.8 Série 9 12 1713 99.5 Série 10 9 1722 100.0 Gráfico Pareto Count Série 1 Série 2 Série 3 Série 4 Série 5 Série 6 Série 7 Série 8 Série 9 Série 10 789 621 109 65 45 30 27 15 12 9 Cumulative% Série 1 Série 2 Série 3 Série 4 Série 5 Série 6 Série 7 Série 8 Série 9 Série 10 45.818815331010455 81.881533101045306 88.211382113821131 91.986062717770039 94.599303135888505 96.341463414634148 97.909407665505228 98.780487804878049 99.477351916376307 100