Gustavo F. Kerntopf

Membro Novato
  • Content Count

    48
  • Joined

  • Last visited

Community Reputation

5 Neutro

About Gustavo F. Kerntopf

  • Rank
    Membro

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. @marcus leandro gerei a matriz 16.12.7.7=72 no COLOGA: 01 02 03 04 05 06 07 08 09 10 11 15 01 02 03 04 05 06 07 08 09 10 13 14 01 02 03 04 05 06 07 08 09 12 14 15 01 02 03 04 05 06 07 08 12 13 14 16 01 02 03 04 05 06 07 09 10 12 14 16 01 02 03 04 05 06 07 09 11 13 14 15 01 02 03 04 05 06 07 11 13 14 15 16 01 02 03 04 05 06 08 10 11 12 13 16 01 02 03 04 05 06 08 10 11 13 14 15 01 02 03 04 05 06 08 10 11 14 15 16 01 02 03 04 05 06 09 11 12 14 15 16 01 02 03 04 05 07 08 09 10 11 12 15 01 02 03 04 05 07 08 09 10 11 12 16 01 02 03 04 05 07 08 10 11 13 15 16 01 02 03 04 05 07 09 10 11 13 15 16 01 02 03 04 05 08 09 11 12 13 14 16 01 02 03 04 05 08 10 11 12 13 15 16 01 02 03 04 06 07 08 09 11 12 13 15 01 02 03 04 06 07 08 10 11 12 14 16 01 02 03 04 06 07 10 11 12 13 14 15 01 02 03 04 06 07 10 11 13 14 15 16 01 02 03 04 06 08 09 10 12 13 14 16 01 02 03 04 06 08 09 11 12 13 14 16 01 02 03 04 07 09 10 11 12 13 15 16 01 02 03 05 06 07 08 09 12 14 15 16 01 02 03 05 06 07 08 11 12 14 15 16 01 02 03 05 06 07 09 10 12 13 14 15 01 02 03 05 06 08 09 10 12 13 14 16 01 02 03 05 07 08 09 11 12 13 14 15 01 02 03 06 07 08 09 10 11 12 13 14 01 02 03 06 07 08 09 11 12 13 15 16 01 02 03 08 09 10 11 12 13 14 15 16 01 02 04 05 06 09 10 11 12 13 14 15 01 02 04 05 07 08 09 10 11 12 13 14 01 02 04 05 07 08 09 10 12 13 14 15 01 02 04 07 08 09 10 11 12 14 15 16 01 02 05 06 07 08 09 10 12 13 15 16 01 02 05 06 07 08 09 12 13 14 15 16 01 02 05 06 07 08 10 11 12 13 15 16 01 02 05 06 07 09 10 11 13 14 15 16 01 02 05 07 08 09 10 12 13 14 15 16 01 03 04 05 06 07 08 09 10 12 13 15 01 03 04 05 06 07 09 10 11 14 15 16 01 03 04 05 06 07 09 11 12 13 15 16 01 03 04 05 07 08 09 12 13 14 15 16 01 03 04 06 07 08 09 10 12 14 15 16 01 03 04 06 07 08 09 11 12 13 15 16 01 03 05 06 07 08 09 11 12 13 14 16 01 03 05 06 07 08 10 11 12 14 15 16 01 04 05 06 07 08 09 10 11 12 13 15 01 04 05 06 07 08 09 10 11 12 13 16 01 04 05 06 07 08 09 10 11 13 14 15 01 04 05 06 07 09 11 12 13 14 15 16 01 04 05 07 08 09 10 11 13 14 15 16 02 03 04 05 06 07 08 09 10 11 13 16 02 03 04 05 06 07 08 09 10 12 15 16 02 03 04 05 06 07 08 09 11 12 14 15 02 03 04 05 06 07 08 11 13 14 15 16 02 03 04 05 06 07 10 11 12 13 14 16 02 03 04 05 06 08 09 10 11 12 14 15 02 03 04 05 06 08 09 11 12 13 15 16 02 03 04 06 07 09 10 11 12 13 15 16 02 03 04 06 07 09 11 12 13 14 15 16 02 03 04 07 08 09 10 11 12 14 15 16 02 03 05 06 07 08 09 11 12 13 14 15 02 03 05 07 08 09 10 11 13 14 15 16 02 03 05 08 09 10 11 12 13 14 15 16 02 03 06 07 08 09 10 11 12 14 15 16 03 04 05 06 07 08 09 10 13 14 15 16 03 04 05 07 08 09 10 11 12 13 14 16 04 05 06 07 08 09 10 11 12 13 14 15 04 05 06 08 09 10 11 12 13 14 15 16
  2. Conforme ideia de @sorel postada em outro tópico: Fiz uma adaptação conceitual e chamei de Menor e Maior Menor {0, 1, 2, 3, 4} Me; Maior {5, 6 ,7 ,8, 9} Ma; O cruzamento e estatística a momento é complicado, pois estou organizando um bolão com os amigos. Espero que ajude a momento.
  3. CC.0095 - 1 3 5 6 7 9 10 15 16 18 19 21 22 29 31 Fórmula aleatório no excel - 1 2 4 5 8 9 11 12 13 16 19 21 23 24 31
  4. @sorel Boa tarde, tenho esses padrões de pares e impares organizados conforme segue no material contido aqui no link. Afortunado 2019 para todos!!!
  5. Arquivo revisado, link abaixo. https://drive.google.com/file/d/1Eu9kCX4O1pwXu8gn0BQnvE4Fjd9MPqeo/view?usp=sharing
  6. Boa madrugada, em um poste @Rodarte comentou sobre ciclo da DDS. Tenho algo mas não sei se é como da lotofácil. Segue link para o documento. https://drive.google.com/file/d/1L80MJf0yxC3LslMdsacLFvKQt4V5hI2X/view?usp=sharing Valeu...
  7. Boa tarde, Atualizei os quadrantes, agora corrigido e totalizando 100%. Na tabela abaixo apresento a frequência e percentual dos quadrantes que saíram até o concurso 89. Apenas para recordar, concatenar nos quadrantes significa, para cada número, a junção de duas colunas. | CONCATENAR QUADRANTES | FREQUÊNCIA PORCENTUAL | | 41020 QTS.x4 - 08 | 1 1% | | 40021 QTS.x4 - 18 | 1 1% | | 33010 QTS.x3 - 03 | 1 1% | | 32110 QTS.x3 - 06 | 1 1% | | 32020 QTS.x3 - 08 | 1 1% | | 31120 QTS.x3 - 14 | 3 3% | | 31111 QTS.x3 - 15 | 2 2% | | 31021 QTS.x3 - 18 | 1 1% | | 31012 QTS.x3 - 19 | 1 1% | | 30211 QTS.x3 - 25 | 3 3% | | 30121 QTS.x3 - 28 | 2 2% | | 30112 QTS.x3 - 29 | 1 1% | | 23110 QTS.x2 - 06 | 1 1% | | 23011 QTS.x2 - 09 | 1 1% | | 22120 QTS.x2 - 14 | 2 2% | | 22111 QTS.x2 - 15 | 5 6% | | 22102 QTS.x2 - 16 | 2 2% | | 22030 QTS.x2 - 17 | 1 1% | | 22003 QTS.x2 - 20 | 1 1% | | 21211 QTS.x2 - 25 | 1 1% | | 21202 QTS.x2 - 26 | 1 1% | | 21121 QTS.x2 - 28 | 1 1% | | 21112 QTS.x2 - 29 | 5 6% | | 20230 QTS.x2 - 42 | 1 1% | | 20212 QTS.x2 - 44 | 1 1% | | 20140 QTS.x2 - 46 | 1 1% | | 20122 QTS.x2 - 48 | 2 2% | | 20032 QTS.x2 - 53 | 1 1% | | 13012 QTS.x1 - 19 | 1 1% | | 12301 QTS.x1 - 23 | 1 1% | | 12211 QTS.x1 - 25 | 1 1% | | 12130 QTS.x1 - 27 | 1 1% | | 12121 QTS.x1 - 28 | 2 2% | | 12031 QTS.x1 - 32 | 1 1% | | 12022 QTS.x1 - 33 | 2 2% | | 11311 QTS.x1 - 40 | 2 2% | | 11221 QTS.x1 - 43 | 4 4% | | 11212 QTS.x1 - 44 | 5 6% | | 11122 QTS.x1 - 48 | 3 3% | | 11113 QTS.x1 - 49 | 2 2% | | 11050 QTS.x1 - 51 | 1 1% | | 11032 QTS.x1 - 53 | 1 1% | | 10402 QTS.x1 - 62 | 1 1% | | 10312 QTS.x1 - 65 | 1 1% | | 10231 QTS.x1 - 68 | 1 1% | | 04111 QTS.x0 - 014 | 1 1% | | 04012 QTS.x0 - 018 | 1 1% | | 03211 QTS.x0 - 024 | 1 1% | | 03031 QTS.x0 - 031 | 1 1% | | 02302 QTS.x0 - 040 | 1 1% | | 02131 QTS.x0 - 046 | 1 1% | | 01222 QTS.x0 - 068 | 4 4% | | 01114 QTS.x0 - 075 | 1 1% | | 01033 QTS.x0 - 080 | 1 1% | | 00241 QTS.x0 - 099 | 1 1% | | 00232 QTS.x0 - 100 | 1 1% | | 00133 QTS.x0 - 107 | 1 1% | = = = = = = = Naturalmente há pontos de concentrações, todavia, a questão é o tempo para apostar nos locais de concentração natural. O objetivo agora é continuar o mapeamento, atualizando nomes de quadrantes para estabelecer as proximidades de concentração (objetivarei com a estatística a momento de Máxima Verossimilhança). Planilha com cálculos e raciocínio. Valeu.
  8. Boa tarde, acredito que já ouviram falar em Vilfredo F. D. Pareto, ou simplesmente, distribuição de Pareto 80x20. Pois bem, fiz um gráfico dentro da ideia de quadros, atualizado até o concurso 76, vejam o resultado a seguir: https://drive.google.com/file/d/15vb_IGfMSAnA-vrC4qBSRPdTdPzUHiRK/view?usp=sharing Essa análise é apenas uma norteados da frequência de eventos em determinada distribuição, assim sendo, pode-se direcionar a quantidade de dezenas nos quadros com maior concentração de eventos.
  9. Olá... https://drive.google.com/file/d/1Z-8Ol5Jl-dbivKpofyXUHIQPo1lMceFc/view?usp=sharing Separei um conjunto de 8.505, considerando um filtro bastante grosseiro ainda, para analisar o quanto tempo aparecerá uma das combinações organizada na ideia dos quadrantis. Optei por analisar três quadrantis β.01 (uma dezena da coluna final 3), γ.04 (uma dezena da coluna final 5 e outra da final 6) e ε.02 (uma dezena da coluna final 0). Agora é esperar para avaliar o desenvolvimento e continuação do estudo.
  10. A B C D E QUADRANTES VEZES PORCENTAGEM 2 2 2 1 0 QTL.x2 - 001 0 0% 2 2 2 0 1 QTL.x2 - 002 0 0% 2 2 1 2 0 QTL.x2 - 003 2 3% 2 2 1 1 1 QTL.x2 - 004 4 6% 2 2 1 0 2 QTL.x2 - 005 2 3% 2 2 0 2 1 QTL.x2 - 006 0 0% 2 2 0 1 2 QTL.x2 - 007 0 0% 2 1 2 2 0 QTL.x2 - 008 0 0% 2 1 2 1 1 QTL.x2 - 009 1 1% 2 1 2 0 2 QTL.x2 - 010 0 0% 2 1 1 2 1 QTL.x2 - 011 1 1% 2 1 1 1 2 QTL.x2 - 012 4 6% 2 1 0 2 2 QTL.x2 - 013 0 0% 2 0 2 2 1 QTL.x2 - 014 0 0% 2 0 2 1 2 QTL.x2 - 015 1 1% 2 0 1 2 2 QTL.x2 - 016 1 1% 1 2 2 2 0 QTL.x2 - 017 0 0% 1 2 2 1 1 QTL.x2 - 018 0 0% 1 2 2 0 2 QTL.x2 - 019 0 0% 1 2 1 2 1 QTL.x2 - 020 2 3% 1 2 1 1 2 QTL.x2 - 021 0 0% 1 2 0 2 2 QTL.x2 - 022 0 0% 1 1 2 2 1 QTL.x2 - 023 4 6% 1 1 2 1 2 QTL.x2 - 024 3 4% 1 1 1 2 2 QTL.x2 - 025 3 4% 1 0 2 2 2 QTL.x2 - 026 0 0% 0 2 2 2 1 QTL.x2 - 027 0 0% 0 2 2 1 2 QTL.x2 - 028 0 0% 0 2 1 2 2 QTL.x2 - 029 0 0% 0 1 2 2 2 QTL.x2 - 030 3 4% 3 3 1 0 0 QTL.x3 - 001 0 0% 3 3 0 1 0 QTL.x3 - 002 1 1% 3 3 0 0 1 QTL.x3 - 003 0 0% 3 2 2 0 0 QTL.x3 - 004 0 0% 3 2 1 1 0 QTL.x3 - 005 0 0% 3 2 1 0 1 QTL.x3 - 006 0 0% 3 2 0 2 0 QTL.x3 - 007 1 1% 3 2 0 1 1 QTL.x3 - 008 0 0% 3 2 0 0 2 QTL.x3 - 009 0 0% 3 1 3 0 0 QTL.x3 - 010 0 0% 3 1 2 1 0 QTL.x3 - 011 0 0% 3 1 2 0 1 QTL.x3 - 012 0 0% 3 1 1 2 0 QTL.x3 - 013 3 4% 3 1 1 1 1 QTL.x3 - 014 1 1% 3 1 1 0 2 QTL.x3 - 015 0 0% 3 1 0 3 0 QTL.x3 - 016 0 0% 3 1 0 2 1 QTL.x3 - 017 1 1% 3 1 0 1 2 QTL.x3 - 018 1 1% 3 1 0 0 3 QTL.x3 - 019 0 0% 3 0 3 1 0 QTL.x3 - 020 0 0% 3 0 3 0 1 QTL.x3 - 021 0 0% 3 0 2 2 0 QTL.x3 - 022 0 0% 3 0 2 1 1 QTL.x3 - 023 3 4% 3 0 2 0 2 QTL.x3 - 024 0 0% 3 0 1 3 0 QTL.x3 - 025 0 0% 3 0 1 2 1 QTL.x3 - 026 1 1% 3 0 1 1 2 QTL.x3 - 027 1 1% 3 0 1 0 3 QTL.x3 - 028 0 0% 3 0 0 3 1 QTL.x3 - 029 0 0% 3 0 0 2 2 QTL.x3 - 030 0 0% 3 0 0 1 3 QTL.x3 - 031 0 0% 2 3 2 0 0 QTL.x3 - 032 0 0% 2 3 1 1 0 QTL.x3 - 033 1 1% 2 3 1 0 1 QTL.x3 - 034 0 0% 2 3 0 2 0 QTL.x3 - 035 0 0% 2 3 0 1 1 QTL.x3 - 036 1 1% 2 3 0 0 2 QTL.x3 - 037 0 0% 2 2 3 0 0 QTL.x3 - 038 0 0% 2 2 0 3 0 QTL.x3 - 039 1 1% 2 2 0 0 3 QTL.x3 - 040 1 1% 2 1 3 1 0 QTL.x3 - 041 0 0% 2 1 3 0 1 QTL.x3 - 042 0 0% 2 1 1 3 0 QTL.x3 - 043 0 0% 2 1 1 0 3 QTL.x3 - 044 0 0% 2 1 0 3 1 QTL.x3 - 045 0 0% 2 1 0 1 3 QTL.x3 - 046 0 0% 2 0 3 2 0 QTL.x3 - 047 0 0% 2 0 3 1 1 QTL.x3 - 048 0 0% 2 0 3 0 2 QTL.x3 - 049 0 0% 2 0 2 3 0 QTL.x3 - 050 1 1% 2 0 2 0 3 QTL.x3 - 051 0 0% 2 0 1 3 1 QTL.x3 - 052 0 0% 2 0 1 1 3 QTL.x3 - 053 0 0% 2 0 0 3 2 QTL.x3 - 054 1 1% 2 0 0 2 3 QTL.x3 - 055 0 0% 1 3 3 0 0 QTL.x3 - 056 0 0% 1 3 2 1 0 QTL.x3 - 057 0 0% 1 3 2 0 1 QTL.x3 - 058 0 0% 1 3 1 2 0 QTL.x3 - 059 0 0% 1 3 1 1 1 QTL.x3 - 060 0 0% 1 3 1 0 2 QTL.x3 - 061 0 0% 1 3 0 3 0 QTL.x3 - 062 0 0% 1 3 0 2 1 QTL.x3 - 063 0 0% 1 3 0 1 2 QTL.x3 - 064 1 1% 1 3 0 0 3 QTL.x3 - 065 0 0% 1 2 3 1 0 QTL.x3 - 066 0 0% 1 2 3 0 1 QTL.x3 - 067 1 1% 1 2 1 3 0 QTL.x3 - 068 1 1% 1 2 1 0 3 QTL.x3 - 069 0 0% 1 2 0 3 1 QTL.x3 - 070 1 1% 1 2 0 1 3 QTL.x3 - 071 0 0% 1 1 3 2 0 QTL.x3 - 072 0 0% 1 1 3 1 1 QTL.x3 - 073 2 3% 1 1 3 0 2 QTL.x3 - 074 0 0% 1 1 2 3 0 QTL.x3 - 075 0 0% 1 1 2 0 3 QTL.x3 - 076 0 0% 1 1 1 3 1 QTL.x3 - 077 0 0% 1 1 1 1 3 QTL.x3 - 078 1 1% 1 1 0 3 2 QTL.x3 - 079 1 1% 1 1 0 2 3 QTL.x3 - 080 0 0% 1 0 3 3 0 QTL.x3 - 081 0 0% 1 0 3 2 1 QTL.x3 - 082 0 0% 1 0 3 1 2 QTL.x3 - 083 0 0% 1 0 3 0 3 QTL.x3 - 084 0 0% 1 0 2 3 1 QTL.x3 - 085 1 1% 1 0 2 1 3 QTL.x3 - 086 0 0% 1 0 1 3 2 QTL.x3 - 087 0 0% 1 0 1 2 3 QTL.x3 - 088 0 0% 1 0 0 3 3 QTL.x3 - 089 0 0% 0 3 3 1 0 QTL.x3 - 090 0 0% 0 3 3 0 1 QTL.x3 - 091 0 0% 0 3 2 2 0 QTL.x3 - 092 0 0% 0 3 2 1 1 QTL.x3 - 093 1 1% 0 3 2 0 2 QTL.x3 - 094 0 0% 0 3 1 3 0 QTL.x3 - 095 0 0% 0 3 1 2 1 QTL.x3 - 096 0 0% 0 3 1 1 2 QTL.x3 - 097 0 0% 0 3 1 0 3 QTL.x3 - 098 0 0% 0 3 0 3 1 QTL.x3 - 099 0 0% 0 3 0 2 2 QTL.x3 - 100 0 0% 0 3 0 1 3 QTL.x3 - 101 0 0% 0 2 3 2 0 QTL.x3 - 102 0 0% 0 2 3 1 1 QTL.x3 - 103 0 0% 0 2 3 0 2 QTL.x3 - 104 1 1% 0 2 2 3 0 QTL.x3 - 105 0 0% 0 2 2 0 3 QTL.x3 - 106 0 0% 0 2 1 3 1 QTL.x3 - 107 1 1% 0 2 1 1 3 QTL.x3 - 108 0 0% 0 2 0 3 2 QTL.x3 - 109 0 0% 0 2 0 2 3 QTL.x3 - 110 0 0% 0 1 3 3 0 QTL.x3 - 111 0 0% 0 1 3 2 1 QTL.x3 - 112 0 0% 0 1 3 1 2 QTL.x3 - 113 0 0% 0 1 3 0 3 QTL.x3 - 114 0 0% 0 1 2 3 1 QTL.x3 - 115 0 0% 0 1 2 1 3 QTL.x3 - 116 0 0% 0 1 1 3 2 QTL.x3 - 117 0 0% 0 1 1 2 3 QTL.x3 - 118 0 0% 0 1 0 3 3 QTL.x3 - 119 1 1% 0 0 3 3 1 QTL.x3 - 120 0 0% 0 0 3 2 2 QTL.x3 - 121 0 0% 0 0 3 1 3 QTL.x3 - 122 0 0% 0 0 2 3 2 QTL.x3 - 123 1 1% 0 0 2 2 3 QTL.x3 - 124 0 0% 0 0 1 3 3 QTL.x3 - 125 1 1% 4 2 1 0 0 QTL.x4 - 001 0 0% 4 2 0 1 0 QTL.x4 - 002 0 0% 4 2 0 0 1 QTL.x4 - 003 0 0% 4 1 2 0 0 QTL.x4 - 004 0 0% 4 1 1 1 0 QTL.x4 - 005 0 0% 4 1 1 0 1 QTL.x4 - 006 0 0% 4 1 0 2 0 QTL.x4 - 007 1 1% 4 1 0 1 1 QTL.x4 - 008 0 0% 4 1 0 0 2 QTL.x4 - 009 0 0% 4 0 2 1 0 QTL.x4 - 010 0 0% 4 0 2 0 1 QTL.x4 - 011 0 0% 4 0 1 2 0 QTL.x4 - 012 0 0% 4 0 1 1 1 QTL.x4 - 013 0 0% 4 0 1 0 2 QTL.x4 - 014 0 0% 4 0 0 2 1 QTL.x4 - 015 1 1% 4 0 0 1 2 QTL.x4 - 016 0 0% 0 4 2 1 0 QTL.x4 - 017 0 0% 0 4 2 0 1 QTL.x4 - 018 0 0% 1 4 2 0 0 QTL.x4 - 019 0 0% 0 4 1 2 0 QTL.x4 - 020 0 0% 0 4 1 1 1 QTL.x4 - 021 0 0% 1 4 1 1 0 QTL.x4 - 022 0 0% 0 4 1 0 2 QTL.x4 - 023 0 0% 1 4 1 0 1 QTL.x4 - 024 0 0% 2 4 1 0 0 QTL.x4 - 025 0 0% 0 4 0 2 1 QTL.x4 - 026 0 0% 1 4 0 2 0 QTL.x4 - 027 0 0% 0 4 0 1 2 QTL.x4 - 028 1 1% 1 4 0 1 1 QTL.x4 - 029 0 0% 2 4 0 1 0 QTL.x4 - 030 0 0% 1 4 0 0 2 QTL.x4 - 031 0 0% 2 4 0 0 1 QTL.x4 - 032 0 0% 0 0 4 2 1 QTL.x4 - 033 0 0% 1 0 4 2 0 QTL.x4 - 034 0 0% 0 1 4 2 0 QTL.x4 - 035 0 0% 0 0 4 1 2 QTL.x4 - 036 0 0% 1 0 4 1 1 QTL.x4 - 037 0 0% 0 1 4 1 1 QTL.x4 - 038 0 0% 2 0 4 1 0 QTL.x4 - 039 0 0% 1 1 4 1 0 QTL.x4 - 040 0 0% 0 2 4 1 0 QTL.x4 - 041 0 0% 1 0 4 0 2 QTL.x4 - 042 0 0% 0 1 4 0 2 QTL.x4 - 043 0 0% 2 0 4 0 1 QTL.x4 - 044 0 0% 1 1 4 0 1 QTL.x4 - 045 0 0% 0 2 4 0 1 QTL.x4 - 046 0 0% 2 1 4 0 0 QTL.x4 - 047 0 0% 1 2 4 0 0 QTL.x4 - 048 0 0% 1 0 0 4 2 QTL.x4 - 049 0 0% 0 1 0 4 2 QTL.x4 - 050 0 0% 0 0 1 4 2 QTL.x4 - 051 0 0% 2 0 0 4 1 QTL.x4 - 052 0 0% 1 1 0 4 1 QTL.x4 - 053 0 0% 1 0 1 4 1 QTL.x4 - 054 0 0% 0 2 0 4 1 QTL.x4 - 055 0 0% 0 1 1 4 1 QTL.x4 - 056 0 0% 0 0 2 4 1 QTL.x4 - 057 1 1% 2 1 0 4 0 QTL.x4 - 058 0 0% 2 0 1 4 0 QTL.x4 - 059 1 1% 1 2 0 4 0 QTL.x4 - 060 0 0% 1 1 1 4 0 QTL.x4 - 061 0 0% 1 0 2 4 0 QTL.x4 - 062 0 0% 0 2 1 4 0 QTL.x4 - 063 0 0% 0 1 2 4 0 QTL.x4 - 064 0 0% 2 1 0 0 4 QTL.x4 - 065 0 0% 2 0 1 0 4 QTL.x4 - 066 0 0% 2 0 0 1 4 QTL.x4 - 067 0 0% 1 2 0 0 4 QTL.x4 - 068 0 0% 1 1 1 0 4 QTL.x4 - 069 0 0% 1 1 0 1 4 QTL.x4 - 070 0 0% 1 0 2 0 4 QTL.x4 - 071 0 0% 1 0 1 1 4 QTL.x4 - 072 0 0% 1 0 0 2 4 QTL.x4 - 073 0 0% 0 2 1 0 4 QTL.x4 - 074 0 0% 0 2 0 1 4 QTL.x4 - 075 0 0% 0 1 2 0 4 QTL.x4 - 076 0 0% 0 1 1 1 4 QTL.x4 - 077 1 1% 0 1 0 2 4 QTL.x4 - 078 0 0% 0 0 2 1 4 QTL.x4 - 079 0 0% 0 0 1 2 4 QTL.x4 - 080 0 0% 5 2 0 0 0 QTL.x5 - 001 0 0% 5 1 1 0 0 QTL.x5 - 002 0 0% 5 1 0 1 0 QTL.x5 - 003 0 0% 5 1 0 0 1 QTL.x5 - 004 0 0% 5 0 2 0 0 QTL.x5 - 005 0 0% 5 0 1 1 0 QTL.x5 - 006 0 0% 5 0 1 0 1 QTL.x5 - 007 0 0% 5 0 0 2 0 QTL.x5 - 008 0 0% 5 0 0 1 1 QTL.x5 - 009 0 0% 5 0 0 0 2 QTL.x5 - 010 0 0% 0 5 2 0 0 QTL.x5 - 011 0 0% 0 5 1 1 0 QTL.x5 - 012 0 0% 0 5 1 0 1 QTL.x5 - 013 0 0% 1 5 1 0 0 QTL.x5 - 014 0 0% 0 5 0 2 0 QTL.x5 - 015 0 0% 0 5 0 1 1 QTL.x5 - 016 0 0% 1 5 0 1 0 QTL.x5 - 017 0 0% 0 5 0 0 2 QTL.x5 - 018 0 0% 1 5 0 0 1 QTL.x5 - 019 0 0% 2 5 0 0 0 QTL.x5 - 020 0 0% 0 0 5 2 0 QTL.x5 - 021 0 0% 0 0 5 1 1 QTL.x5 - 022 0 0% 1 0 5 1 0 QTL.x5 - 023 0 0% 0 1 5 1 0 QTL.x5 - 024 0 0% 0 0 5 0 2 QTL.x5 - 025 0 0% 1 0 5 0 1 QTL.x5 - 026 0 0% 0 1 5 0 1 QTL.x5 - 027 0 0% 2 0 5 0 0 QTL.x5 - 028 0 0% 1 1 5 0 0 QTL.x5 - 029 0 0% 0 2 5 0 0 QTL.x5 - 030 0 0% 0 0 0 5 2 QTL.x5 - 031 0 0% 1 0 0 5 1 QTL.x5 - 032 0 0% 0 1 0 5 1 QTL.x5 - 033 0 0% 0 0 1 5 1 QTL.x5 - 034 0 0% 2 0 0 5 0 QTL.x5 - 035 0 0% 1 1 0 5 0 QTL.x5 - 036 1 1% 1 0 1 5 0 QTL.x5 - 037 0 0% 0 2 0 5 0 QTL.x5 - 038 0 0% 0 1 1 5 0 QTL.x5 - 039 0 0% 0 0 2 5 0 QTL.x5 - 040 0 0% 2 0 0 0 5 QTL.x5 - 041 0 0% 1 1 0 0 5 QTL.x5 - 042 0 0% 1 0 1 0 5 QTL.x5 - 043 0 0% 1 0 0 1 5 QTL.x5 - 044 0 0% 0 2 0 0 5 QTL.x5 - 045 0 0% 0 1 1 0 5 QTL.x5 - 046 0 0% 0 1 0 1 5 QTL.x5 - 047 0 0% 0 0 2 0 5 QTL.x5 - 048 0 0% 0 0 1 1 5 QTL.x5 - 049 0 0% 0 0 0 2 5 QTL.x5 - 050 0 0% 6 1 0 0 0 QTL.x6 - 001 0 0% 6 0 1 0 0 QTL.x6 - 002 0 0% 6 0 0 1 0 QTL.x6 - 003 0 0% 6 0 0 0 1 QTL.x6 - 004 0 0% 0 6 1 0 0 QTL.x6 - 005 0 0% 0 6 0 1 0 QTL.x6 - 006 0 0% 0 6 0 0 1 QTL.x6 - 007 0 0% 1 6 0 0 0 QTL.x6 - 008 0 0% 0 0 6 1 0 QTL.x6 - 009 0 0% 0 0 6 0 1 QTL.x6 - 010 0 0% 1 0 6 0 0 QTL.x6 - 011 0 0% 0 1 6 0 0 QTL.x6 - 012 0 0% 0 0 0 6 1 QTL.x6 - 013 0 0% 1 0 0 6 0 QTL.x6 - 014 0 0% 0 1 0 6 0 QTL.x6 - 015 0 0% 0 0 1 6 0 QTL.x6 - 016 0 0% 1 0 0 0 6 QTL.x6 - 017 0 0% 0 1 0 0 6 QTL.x6 - 018 0 0% 0 0 1 0 6 QTL.x6 - 019 0 0% 0 0 0 1 6 QTL.x6 - 020 0 0%
  11. Estimado, grato pela sugestão, caso tenha algo iniciado que possa contribuir... agradeço. Ainda com relação aos quadrantes (compostas por duas colunas), observa-se que a dispersão dos quadrantes A e B, geralmente, apresentam 3 a 4 dezenas... De repente o filtro que você sugestionou contribua ou ainda outros indicados anteriormente. Observe tabela contendo quadros e quadrantes: CC = P.01 P.02 P.03 P.04 P.05 P.06 P.07 = QUADROS A/B = QDT.A QDT.B QDT.C QDT.D QDT.E QUADRANTE 1 = 3 5 8 9 19 21 30 = QDR.B¬[ 4 ] = 1 1 1 1 3 1 1 1 1 3 2 = 8 11 12 14 20 21 28 = QDR.A¬[ 4 ] = 3 1 0 2 1 3 1 0 2 1 3 = 11 12 21 24 25 28 29 = QDR.A¬[ 5 ] = 3 1 1 1 1 3 1 1 1 1 4 = 6 7 13 15 18 19 29 = QDR.B¬[ 5 ] = 0 1 2 2 2 0 1 2 2 2 5 = 2 8 9 17 19 24 28 = QDR.B¬[ 5 ] = 1 1 0 3 2 1 1 0 3 2 6 = 1 11 18 19 26 30 31 = QDR.B¬[ 4 ] = 3 0 1 1 2 3 0 1 1 2 7 = 2 5 6 14 20 24 25 = QDR.A¬[ 5 ] = 1 2 3 0 1 1 2 3 0 1 8 = 1 4 13 21 22 24 27 = QDR.A¬[ 6 ] = 3 3 0 1 0 3 3 0 1 0 9 = 3 10 13 18 19 23 24 = QDR.A¬[ 4 ] = 0 4 0 1 2 0 4 0 1 2 10 = 6 10 13 18 19 20 30 = QDR.B¬[ 6 ] = 0 1 1 1 4 0 1 1 1 4 11 = 7 13 16 19 20 27 31 = QDR.B¬[ 5 ] = 1 1 1 2 2 1 1 1 2 2 12 = 2 3 7 12 17 21 22 = QDR.A¬[ 5 ] = 4 1 0 2 0 4 1 0 2 0 13 = 1 4 7 9 20 21 26 = QDR.B¬[ 4 ] = 2 1 1 1 2 2 1 1 1 2 14 = 1 8 16 20 21 26 31 = QDR.B¬[ 4 ] = 3 0 2 1 1 3 0 2 1 1 15 = 8 11 13 16 26 28 29 = QDR.B¬[ 5 ] = 1 1 2 2 1 1 1 2 2 1 16 = 1 2 7 12 16 20 25 = QDR.A¬[ 4 ] = 3 0 2 1 1 3 0 2 1 1 17 = 9 11 13 14 19 20 22 = QDR.A¬[ 4 ] = 2 2 0 0 3 2 2 0 0 3 18 = 4 7 8 14 21 27 31 = QDR.A¬[ 4 ] = 2 2 0 3 0 2 2 0 3 0 19 = 3 4 9 12 14 28 29 = QDR.A¬[ 4 ] = 1 3 0 1 2 1 3 0 1 2 20 = 6 12 17 21 26 29 31 = QDR.B¬[ 4 ] = 3 0 2 1 1 3 0 2 1 1 21 = 2 8 10 11 12 18 31 = QDR.A¬[ 4 ] = 4 0 0 2 1 4 0 0 2 1 22 = 2 4 5 12 18 22 27 = QDR.A¬[ 5 ] = 3 1 1 2 0 3 1 1 2 0 23 = 9 10 17 19 25 27 28 = QDR.B¬[ 6 ] = 0 0 1 3 3 0 0 1 3 3 24 = 7 8 12 15 16 18 30 = QDR.B¬[ 5 ] = 1 0 2 3 1 1 0 2 3 1 25 = 1 10 13 17 21 25 29 = QDR.A¬[ 4 ] = 2 1 1 1 2 2 1 1 1 2 26 = 2 8 10 11 16 20 28 = QDR.B¬[ 5 ] = 2 0 1 2 2 2 0 1 2 2 27 = 6 12 15 17 20 23 28 = QDR.B¬[ 4 ] = 1 1 2 2 1 1 1 2 2 1 28 = 2 9 12 15 18 20 24 = QDR.A¬[ 4 ] = 2 1 1 1 2 2 1 1 1 2 29 = 3 5 13 21 22 24 27 = QDR.A¬[ 6 ] = 2 3 1 1 0 2 3 1 1 0 30 = 4 8 9 17 20 27 30 = QDR.B¬[ 6 ] = 0 1 0 3 3 0 1 0 3 3 31 = 4 6 7 9 11 24 28 = QDR.B¬[ 4 ] = 1 2 1 2 1 1 2 1 2 1 32 = 3 4 7 16 18 20 27 = QDR.B¬[ 5 ] = 0 2 1 3 1 0 2 1 3 1 33 = 3 10 12 13 23 28 31 = QDR.A¬[ 5 ] = 2 3 0 1 1 2 3 0 1 1 34 = 6 12 15 18 23 27 29 = QDR.B¬[ 4 ] = 1 1 2 2 1 1 1 2 2 1 35 = 3 7 11 12 17 22 23 = QDR.A¬[ 5 ] = 3 2 0 2 0 3 2 0 2 0 36 = 2 7 11 12 13 16 27 = QDR.A¬[ 4 ] = 3 1 1 2 0 3 1 1 2 0 37 = 2 7 12 16 18 22 23 = QDR.A¬[ 4 ] = 3 1 1 2 0 3 1 1 2 0 38 = 8 15 17 18 26 29 30 = QDR.B¬[ 6 ] = 0 0 2 3 2 0 0 2 3 2 39 = 4 5 6 9 13 25 30 = QDR.A¬[ 4 ] = 0 2 3 0 2 0 2 3 0 2 40 = 2 10 12 14 19 21 27 = QDR.A¬[ 4 ] = 3 1 0 1 2 3 1 0 1 2 41 = 7 12 23 25 27 30 31 = QDR.A¬[ 4 ] = 2 1 1 2 1 2 1 1 2 1 42 = 6 11 14 16 17 19 31 = QDR.B¬[ 4 ] = 2 1 2 1 1 2 1 2 1 1 43 = 4 7 17 18 27 28 31 = QDR.B¬[ 5 ] = 1 1 0 5 0 1 1 0 5 0 44 = 7 9 15 23 26 30 31 = QDR.B¬[ 4 ] = 1 1 2 1 2 1 1 2 1 2 45 = 2 5 7 12 15 29 30 = QDR.A¬[ 4 ] = 2 0 2 1 2 2 0 2 1 2 46 = 1 4 5 8 10 16 30 = QDR.B¬[ 4 ] = 1 1 2 1 2 1 1 2 1 2 47 = 5 7 13 15 16 20 22 = QDR.A¬[ 4 ] = 1 1 3 1 1 1 1 3 1 1 48 = 6 8 10 17 23 29 31 = QDR.B¬[ 5 ] = 1 1 1 2 2 1 1 1 2 2 49 = 4 11 16 17 20 23 31 = QDR.A¬[ 4 ] = 2 2 1 1 1 2 2 1 1 1 50 = 14 16 17 18 22 23 31 = QDR.A¬[ 4 ] = 2 2 1 2 0 2 2 1 2 0 51 = 2 8 10 14 16 24 28 = QDR.B¬[ 4 ] = 1 2 1 2 1 1 2 1 2 1 52 = 7 12 14 20 22 24 26 = QDR.A¬[ 4 ] = 2 2 1 1 1 2 2 1 1 1 53 = 3 7 16 18 19 25 30 = QDR.B¬[ 5 ] = 0 1 2 2 2 0 1 2 2 2 54 = 4 11 18 21 24 25 27 = QDR.A¬[ 5 ] = 2 2 1 2 0 2 2 1 2 0 55 = 1 8 16 18 22 25 28 = QDR.B¬[ 4 ] = 2 0 2 3 0 2 0 2 3 0 56 = 9 10 15 16 17 23 31 = QDR.B¬[ 4 ] = 1 1 2 1 2 1 1 2 1 2 57 = 3 5 10 12 18 26 28 = QDR.B¬[ 4 ] = 1 1 2 2 1 1 1 2 2 1 58 = 11 12 13 24 25 29 30 = QDR.A¬[ 5 ] = 2 2 1 0 2 2 2 1 0 2 59 = 3 4 5 8 10 24 25 = QDR.A¬[ 5 ] = 0 3 2 1 1 0 3 2 1 1 60 = 1 6 7 8 17 18 22 = QDR.B¬[ 5 ] = 2 0 1 4 0 2 0 1 4 0 61 = 5 8 10 13 19 25 28 = QDR.B¬[ 4 ] = 0 1 2 2 2 0 1 2 2 2 62 = 7 11 13 18 23 28 30 = QDR.B¬[ 4 ] = 1 2 0 3 1 1 2 0 3 1 63 = 2 3 6 9 27 28 29 = QDR.B¬[ 5 ] = 1 1 1 2 2 1 1 1 2 2 64 = 5 6 8 17 18 20 27 = QDR.B¬[ 6 ] = 0 0 2 4 1 0 0 2 4 1 65 = 7 20 21 27 28 30 31 = QDR.B¬[ 5 ] = 2 0 0 3 2 2 0 0 3 2 66 = 4 6 10 11 12 20 24 = QDR.A¬[ 4 ] = 2 2 1 0 2 2 2 1 0 2 67 = 1 4 8 14 19 22 26 = QDR.A¬[ 4 ] = 2 2 1 1 1 2 2 1 1 1 68 = 1 4 6 14 20 21 27 = QDR.A¬[ 4 ] = 2 2 1 1 1 2 2 1 1 1 69 = 1 3 5 6 8 26 29 = QDR.B¬[ 4 ] = 1 1 3 1 1 1 1 3 1 1 70 = 2 4 5 9 11 28 29 = QDR.A¬[ 4 ] = 2 1 1 1 2 2 1 1 1 2 71 = 4 6 7 8 24 27 31 = QDR.B¬[ 4 ] 1 2 1 3 0 1 2 1 3 0
  12. CC - P.01 P.02 P.03 P.04 P.05 P.06 P.07 - QDTL.α QDTL.β QDTL.γ QDTL.δ QDTL.ε 1 - 3 5 8 9 19 21 30 - α.01 β.01 γ.01 δ.02 ε.07 2 - 8 11 12 14 20 21 28 - α.07 β.02 γ.00 δ.05 ε.02 3 - 11 12 21 24 25 28 29 - α.07 β.02 γ.01 δ.02 ε.01 4 - 6 7 13 15 18 19 29 - α.00 β.01 γ.04 δ.04 ε.03 5 - 2 8 9 17 19 24 28 - α.02 β.02 γ.00 δ.08 ε.03 6 - 1 11 18 19 26 30 31 - α.06 β.00 γ.02 δ.02 ε.04 7 - 2 5 6 14 20 24 25 - α.02 β.05 γ.07 δ.00 ε.02 8 - 1 4 13 21 22 24 27 - α.07 β.08 γ.00 δ.01 ε.00 9 - 3 10 13 18 19 23 24 - α.00 β.10 γ.00 δ.02 ε.04 10 - 6 10 13 18 19 20 30 - α.00 β.01 γ.02 δ.02 ε.12 11 - 7 13 16 19 20 27 31 - α.01 β.01 γ.02 δ.03 ε.04 12 - 2 3 7 12 17 21 22 - α.13 β.01 γ.00 δ.03 ε.00 13 - 1 4 7 9 20 21 26 - α.03 β.02 γ.02 δ.01 ε.04 14 - 1 8 16 20 21 26 31 - α.06 β.00 γ.05 δ.02 ε.02 15 - 8 11 13 16 26 28 29 - α.01 β.01 γ.05 δ.05 ε.01 16 - 1 2 7 12 16 20 25 - α.08 β.00 γ.04 δ.01 ε.02 17 - 9 11 13 14 19 20 22 - α.04 β.04 γ.00 δ.00 ε.07 18 - 4 7 8 14 21 27 31 - α.03 β.05 γ.00 δ.07 ε.00 19 - 3 4 9 12 14 28 29 - α.02 β.08 γ.00 δ.02 ε.03 20 - 6 12 17 21 26 29 31 - α.07 β.00 γ.05 δ.01 ε.01 21 - 2 8 10 11 12 18 31 - α.12 β.00 γ.00 δ.05 ε.02 22 - 2 4 5 12 18 22 27 - α.09 β.02 γ.01 δ.04 ε.00 23 - 9 10 17 19 25 27 28 - α.00 β.00 γ.01 δ.07 ε.07 24 - 7 8 12 15 16 18 30 - α.02 β.00 γ.04 δ.08 ε.02 25 - 1 10 13 17 21 25 29 - α.03 β.01 γ.01 δ.01 ε.04 26 - 2 8 10 11 16 20 28 - α.04 β.00 γ.02 δ.05 ε.05 27 - 6 12 15 17 20 23 28 - α.02 β.01 γ.04 δ.04 ε.02 28 - 2 9 12 15 18 20 24 - α.05 β.02 γ.01 δ.02 ε.04 29 - 3 5 13 21 22 24 27 - α.04 β.07 γ.01 δ.01 ε.00 30 - 4 8 9 17 20 27 30 - α.00 β.02 γ.00 δ.07 ε.08 31 - 4 6 7 9 11 24 28 - α.01 β.05 γ.02 δ.04 ε.01 32 - 3 4 7 16 18 20 27 - α.00 β.04 γ.02 δ.07 ε.02 33 - 3 10 12 13 23 28 31 - α.04 β.06 γ.00 δ.02 ε.02 34 - 6 12 15 18 23 27 29 - α.02 β.01 γ.04 δ.04 ε.01 35 - 3 7 11 12 17 22 23 - α.08 β.03 γ.00 δ.03 ε.00 36 - 2 7 11 12 13 16 27 - α.08 β.01 γ.02 δ.03 ε.00 37 - 2 7 12 16 18 22 23 - α.09 β.01 γ.02 δ.04 ε.00 38 - 8 15 17 18 26 29 30 - α.00 β.00 γ.04 δ.08 ε.04 39 - 4 5 6 9 13 25 30 - α.00 β.04 γ.07 δ.00 ε.04 40 - 2 10 12 14 19 21 27 - α.08 β.02 γ.00 δ.01 ε.04 41 - 7 12 23 25 27 30 31 - α.04 β.01 γ.01 δ.03 ε.02 42 - 6 11 14 16 17 19 31 - α.03 β.02 γ.05 δ.01 ε.01 43 - 4 7 17 18 27 28 31 - α.01 β.02 γ.00 #N/D ε.00 44 - 7 9 15 23 26 30 31 - α.01 β.01 γ.04 δ.01 ε.04 45 - 2 5 7 12 15 29 30 - α.05 β.00 γ.03 δ.01 ε.04 46 - 1 4 5 8 10 16 30 - α.01 β.02 γ.04 δ.02 ε.05 47 - 5 7 13 15 16 20 22 - α.02 β.01 γ.07 δ.01 ε.02 48 - 6 8 10 17 23 29 31 - α.01 β.01 γ.02 δ.04 ε.04 49 - 4 11 16 17 20 23 31 - α.03 β.04 γ.02 δ.01 ε.02 50 - 14 16 17 18 22 23 31 - α.04 β.04 γ.02 δ.04 ε.00 51 - 2 8 10 14 16 24 28 - α.02 β.05 γ.02 δ.05 ε.02 52 - 7 12 14 20 22 24 26 - α.05 β.05 γ.02 δ.01 ε.02 53 - 3 7 16 18 19 25 30 - α.00 β.01 γ.04 δ.04 ε.04 54 - 4 11 18 21 24 25 27 - α.03 β.05 γ.01 δ.04 ε.00 55 - 1 8 16 18 22 25 28 - α.04 β.00 γ.04 δ.09 ε.00 56 - 9 10 15 16 17 23 31 - α.01 β.01 γ.04 δ.01 ε.04 57 - 3 5 10 12 18 26 28 - α.02 β.01 γ.04 δ.05 ε.02 58 - 11 12 13 24 25 29 30 - α.04 β.04 γ.01 δ.00 ε.04 59 - 3 4 5 8 10 24 25 - α.00 β.08 γ.03 δ.02 ε.02 60 - 1 6 7 8 17 18 22 - α.04 β.00 γ.02 δ.11 ε.00 61 - 5 8 10 13 19 25 28 - α.00 β.01 γ.03 δ.05 ε.04 62 - 7 11 13 18 23 28 30 - α.01 β.03 γ.00 δ.08 ε.02 63 - 2 3 6 9 27 28 29 - α.02 β.01 γ.02 δ.04 ε.03 64 - 5 6 8 17 18 20 27 - α.00 β.00 γ.04 δ.11 ε.02 65 - 7 20 21 27 28 30 31 - α.03 β.00 γ.00 δ.07 ε.05 66 - 4 6 10 11 12 20 24 - α.04 β.05 γ.02 δ.00 ε.05 67 - 1 4 8 14 19 22 26 - α.04 β.05 γ.02 δ.02 ε.01 68 - 1 4 6 14 20 21 27 - α.03 β.05 γ.02 δ.01 ε.02 69 - 1 3 5 6 8 26 29 - α.01 β.01 γ.08 δ.02 ε.01 70 - 2 4 5 9 11 28 29 - α.04 β.02 γ.01 δ.02 ε.03 71 - 4 6 7 8 24 27 31 - α.01 β.05 γ.02 δ.07 ε.00
  13. A B QUADROS VEZES PORCENTAGEM 7 0 QDR.A¬[ 7 ] 0 0% 6 1 QDR.A¬[ 6 ] 2 3% 5 2 QDR.A¬[ 5 ] 9 13% 4 3 QDR.A¬[ 4 ] 23 32% 3 4 QDR.B¬[ 4 ] 19 27% 2 5 QDR.B¬[ 5 ] 13 18% 1 6 QDR.B¬[ 6 ] 5 7% 0 7 QDR.B¬[ 7 ] 0 0%