Teste T de Student - Macro em Excel ou Ferramentas de Analise (Cientifica ou Financeira)

  Teste T de Student - Macro em Excel ou Ferramentas de Analise (Cientifica ou Financeira)

- Salarios MS Vs SP

Videoaula:

      https://youtu.be/MNokvQqeP_c

Arquivo Elaborad o Durante a Aula para Fazer Download:

Teste_T_Excel_Salarios

Teste T de Student - O mais utilizado no dia a dia dos egressos da ESALQ no Mercado de Trabalho na Area de BI

No programa de todas as disciplinas de Estatística Básica da ESALQ:

·       

Exemplo 1:

Teste se a média aritmética dos dois estados é igual. Se existirem

 outliers elimine-os.  Analise os dados com o outlier e eliminando-o,

 compare os resultados. Discuta os resultados da analise sem o

 outlier. 

Teste T - Macro em Excel - Inferência Indutiva

Inferência Indutiva utilizando Estatística

Cidade	Estado	Salario na Industria Tático/Operacional
1	MS	1678
2	SP	1850
3	MS	1650
4	MS	1890
5	SP	1950
6	SP	2050
7	SP	2320
8	SP	1800
9	MS	1789
10	MS	1890
11	MS	1780
12	MS	2550
13	SP	2150
14	SP	1680

Arquivo do Ecxel feito em dinamica conjunta:

(Arquivo para Downoad)

===> Exemplo_1_Conjunto

Livro Básico - Infer. Estat. Indutiva - Download

Livro Introdutorio sobre Machine Learning

https://alex.smola.org/drafts/thebook.pdf

Relatório Técnico para uma Empresa (ano 2020), linguagem corporativa.

Caso 1 – Com Informação Previa Confiável (por exemplo um relatório técnico de 2019 comparando os salários dos dois estados – MS e SP)

A média salarial de SP (1971,4 Reais) foi estatisticamente superior à média de MS (1792,4 Reais) com uma margem de confiança de 95,5%.

 

Caso 2 – Sem Informação Previa Confiável (pesquisa pioneira)

A média salarial de SP não diferiu estatisticamente da média de MS, margem de confiança para falar que são diferentes 90,9% (inferior a 95%).

 

Resultados e Discussão (âmbito acadêmico Ex. USP, trabalho cientifico)

Caso 1 – Com Informação Previa Confiável (por exemplo uma referência bibliográfica importante) comparando os salários dos dois estados – MS e SP)

A média salarial de SP (1971,4 Reais) foi estatisticamente superior à média de MS (1792,4 Reais) com uma margem de erro (p valor) de 0,045.

 

Caso 2 – Sem Informação Previa Confiável (pesquisa pioneira)

A média salarial de SP não diferiu estatisticamente da média de MS (p < 0,090).

Estatística Tradicional Paramétrica

·       Inteligência Artificial (Era da IA) e Normas ISO (balizam o comercio internacional e nacional):

               Agora Estatística Robusta (fora do Excel, no SAS, R e Python)

·                                 Teste T Robusto ou Kruskal Wallis

Arquivo ARFF de Falsificação de Dinheiro

 Arquivo ARFF de Falsificação de Dinheiro

Fonte: Arquivos de amostra do Progrma R

Videoaula:

https://youtu.be/DiECxyHHpo0

Arquivo para Download, padrão Weka (.arff):

Arquivo Dinheiro Falso

Arquivo em padrão Texto, completo, Dinheiro Falso:

(Somente copiar e colar no Programa Notes do Computador)

@RELATION banco

@ATTRIBUTE Length REAL
@ATTRIBUTE Left REAL
@ATTRIBUTE Right REAL
@ATTRIBUTE Bottom REAL
@ATTRIBUTE Top REAL
@ATTRIBUTE Diagonal REAL
@ATTRIBUTE Class {0,1}

@DATA      

214.8,131.0,131.1,9.0,9.7,141.0,0
214.6,129.7,129.7,8.1,9.5,141.7,0
214.8,129.7,129.7,8.7,9.6,142.2,0
214.8,129.7,129.6,7.5,10.4,142.0,0
215.0,129.6,129.7,10.4,7.7,141.8,0
215.7,130.8,130.5,9.0,10.1,141.4,0
215.5,129.5,129.7,7.9,9.6,141.6,0
214.5,129.6,129.2,7.2,10.7,141.7,0
214.9,129.4,129.7,8.2,11.0,141.9,0
215.2,130.4,130.3,9.2,10.0,140.7,0
215.3,130.4,130.3,7.9,11.7,141.8,0
215.1,129.5,129.6,7.7,10.5,142.2,0
215.2,130.8,129.6,7.9,10.8,141.4,0
214.7,129.7,129.7,7.7,10.9,141.7,0
215.1,129.9,129.7,7.7,10.8,141.8,0
214.5,129.8,129.8,9.3,8.5,141.6,0
214.6,129.9,130.1,8.2,9.8,141.7,0
215.0,129.9,129.7,9.0,9.0,141.9,0
215.2,129.6,129.6,7.4,11.5,141.5,0
214.7,130.2,129.9,8.6,10.0,141.9,0
215.0,129.9,129.3,8.4,10.0,141.4,0
215.6,130.5,130.0,8.1,10.3,141.6,0
215.3,130.6,130.0,8.4,10.8,141.5,0
215.7,130.2,130.0,8.7,10.0,141.6,0
215.1,129.7,129.9,7.4,10.8,141.1,0
215.3,130.4,130.4,8.0,11.0,142.3,0
215.5,130.2,130.1,8.9,9.8,142.4,0
215.1,130.3,130.3,9.8,9.5,141.9,0
215.1,130.0,130.0,7.4,10.5,141.8,0
214.8,129.7,129.3,8.3,9.0,142.0,0
215.2,130.1,129.8,7.9,10.7,141.8,0
214.8,129.7,129.7,8.6,9.1,142.3,0
215.0,130.0,129.6,7.7,10.5,140.7,0
215.6,130.4,130.1,8.4,10.3,141.0,0
215.9,130.4,130.0,8.9,10.6,141.4,0
214.6,130.2,130.2,9.4,9.7,141.8,0
215.5,130.3,130.0,8.4,9.7,141.8,0
215.3,129.9,129.4,7.9,10.0,142.0,0
215.3,130.3,130.1,8.5,9.3,142.1,0
213.9,130.3,129.0,8.1,9.7,141.3,0
214.4,129.8,129.2,8.9,9.4,142.3,0
214.8,130.1,129.6,8.8,9.9,140.9,0
214.9,129.6,129.4,9.3,9.0,141.7,0
214.9,130.4,129.7,9.0,9.8,140.9,0
214.8,129.4,129.1,8.2,10.2,141.0,0
214.3,129.5,129.4,8.3,10.2,141.8,0
214.8,129.9,129.7,8.3,10.2,141.5,0
214.8,129.9,129.7,7.3,10.9,142.0,0
214.6,129.7,129.8,7.9,10.3,141.1,0
214.5,129.0,129.6,7.8,9.8,142.0,0
214.6,129.8,129.4,7.2,10.0,141.3,0
215.3,130.6,130.0,9.5,9.7,141.1,0
214.5,130.1,130.0,7.8,10.9,140.9,0
215.4,130.2,130.2,7.6,10.9,141.6,0
214.5,129.4,129.5,7.9,10.0,141.4,0
215.2,129.7,129.4,9.2,9.4,142.0,0
215.7,130.0,129.4,9.2,10.4,141.2,0
215.0,129.6,129.4,8.8,9.0,141.1,0
215.1,130.1,129.9,7.9,11.0,141.3,0
215.1,130.0,129.8,8.2,10.3,141.4,0
215.1,129.6,129.3,8.3,9.9,141.6,0
215.3,129.7,129.4,7.5,10.5,141.5,0
215.4,129.8,129.4,8.0,10.6,141.5,0
214.5,130.0,129.5,8.0,10.8,141.4,0
215.0,130.0,129.8,8.6,10.6,141.5,0
215.2,130.6,130.0,8.8,10.6,140.8,0
214.6,129.5,129.2,7.7,10.3,141.3,0
214.8,129.7,129.3,9.1,9.5,141.5,0
215.1,129.6,129.8,8.6,9.8,141.8,0
214.9,130.2,130.2,8.0,11.2,139.6,0
213.8,129.8,129.5,8.4,11.1,140.9,0
215.2,129.9,129.5,8.2,10.3,141.4,0
215.0,129.6,130.2,8.7,10.0,141.2,0
214.4,129.9,129.6,7.5,10.5,141.8,0
215.2,129.9,129.7,7.2,10.6,142.1,0
214.1,129.6,129.3,7.6,10.7,141.7,0
214.9,129.9,130.1,8.8,10.0,141.2,0
214.6,129.8,129.4,7.4,10.6,141.0,0
215.2,130.5,129.8,7.9,10.9,140.9,0
214.6,129.9,129.4,7.9,10.0,141.8,0
215.1,129.7,129.7,8.6,10.3,140.6,0
214.9,129.8,129.6,7.5,10.3,141.0,0
215.2,129.7,129.1,9.0,9.7,141.9,0
215.2,130.1,129.9,7.9,10.8,141.3,0
215.4,130.7,130.2,9.0,11.1,141.2,0
215.1,129.9,129.6,8.9,10.2,141.5,0
215.2,129.9,129.7,8.7,9.5,141.6,0
215.0,129.6,129.2,8.4,10.2,142.1,0
214.9,130.3,129.9,7.4,11.2,141.5,0
215.0,129.9,129.7,8.0,10.5,142.0,0
214.7,129.7,129.3,8.6,9.6,141.6,0
215.4,130.0,129.9,8.5,9.7,141.4,0
214.9,129.4,129.5,8.2,9.9,141.5,0
214.5,129.5,129.3,7.4,10.7,141.5,0
214.7,129.6,129.5,8.3,10.0,142.0,0
215.6,129.9,129.9,9.0,9.5,141.7,0
215.0,130.4,130.3,9.1,10.2,141.1,0
214.4,129.7,129.5,8.0,10.3,141.2,0
215.1,130.0,129.8,9.1,10.2,141.5,0
214.7,130.0,129.4,7.8,10.0,141.2,0
214.4,130.1,130.3,9.7,11.7,139.8,1
214.9,130.5,130.2,11.0,11.5,139.5,1
214.9,130.3,130.1,8.7,11.7,140.2,1
215.0,130.4,130.6,9.9,10.9,140.3,1
214.7,130.2,130.3,11.8,10.9,139.7,1
215.0,130.2,130.2,10.6,10.7,139.9,1
215.3,130.3,130.1,9.3,12.1,140.2,1
214.8,130.1,130.4,9.8,11.5,139.9,1
215.0,130.2,129.9,10.0,11.9,139.4,1
215.2,130.6,130.8,10.4,11.2,140.3,1
215.2,130.4,130.3,8.0,11.5,139.2,1
215.1,130.5,130.3,10.6,11.5,140.1,1
215.4,130.7,131.1,9.7,11.8,140.6,1
214.9,130.4,129.9,11.4,11.0,139.9,1
215.1,130.3,130.0,10.6,10.8,139.7,1
215.5,130.4,130.0,8.2,11.2,139.2,1
214.7,130.6,130.1,11.8,10.5,139.8,1
214.7,130.4,130.1,12.1,10.4,139.9,1
214.8,130.5,130.2,11.0,11.0,140.0,1
214.4,130.2,129.9,10.1,12.0,139.2,1
214.8,130.3,130.4,10.1,12.1,139.6,1
215.1,130.6,130.3,12.3,10.2,139.6,1
215.3,130.8,131.1,11.6,10.6,140.2,1
215.1,130.7,130.4,10.5,11.2,139.7,1
214.7,130.5,130.5,9.9,10.3,140.1,1
214.9,130.0,130.3,10.2,11.4,139.6,1
215.0,130.4,130.4,9.4,11.6,140.2,1
215.5,130.7,130.3,10.2,11.8,140.0,1
215.1,130.2,130.2,10.1,11.3,140.3,1
214.5,130.2,130.6,9.8,12.1,139.9,1
214.3,130.2,130.0,10.7,10.5,139.8,1
214.5,130.2,129.8,12.3,11.2,139.2,1
214.9,130.5,130.2,10.6,11.5,139.9,1
214.6,130.2,130.4,10.5,11.8,139.7,1
214.2,130.0,130.2,11.0,11.2,139.5,1
214.8,130.1,130.1,11.9,11.1,139.5,1
214.6,129.8,130.2,10.7,11.1,139.4,1
214.9,130.7,130.3,9.3,11.2,138.3,1
214.6,130.4,130.4,11.3,10.8,139.8,1
214.5,130.5,130.2,11.8,10.2,139.6,1
214.8,130.2,130.3,10.0,11.9,139.3,1
214.7,130.0,129.4,10.2,11.0,139.2,1
214.6,130.2,130.4,11.2,10.7,139.9,1
215.0,130.5,130.4,10.6,11.1,139.9,1
214.5,129.8,129.8,11.4,10.0,139.3,1
214.9,130.6,130.4,11.9,10.5,139.8,1
215.0,130.5,130.4,11.4,10.7,139.9,1
215.3,130.6,130.3,9.3,11.3,138.1,1
214.7,130.2,130.1,10.7,11.0,139.4,1
214.9,129.9,130.0,9.9,12.3,139.4,1
214.9,130.3,129.9,11.9,10.6,139.8,1
214.6,129.9,129.7,11.9,10.1,139.0,1
214.6,129.7,129.3,10.4,11.0,139.3,1
214.5,130.1,130.1,12.1,10.3,139.4,1
214.5,130.3,130.0,11.0,11.5,139.5,1
215.1,130.0,130.3,11.6,10.5,139.7,1
214.2,129.7,129.6,10.3,11.4,139.5,1
214.4,130.1,130.0,11.3,10.7,139.2,1
214.8,130.4,130.6,12.5,10.0,139.3,1
214.6,130.6,130.1,8.1,12.1,137.9,1
215.6,130.1,129.7,7.4,12.2,138.4,1
214.9,130.5,130.1,9.9,10.2,138.1,1
214.6,130.1,130.0,11.5,10.6,139.5,1
214.7,130.1,130.2,11.6,10.9,139.1,1
214.3,130.3,130.0,11.4,10.5,139.8,1
215.1,130.3,130.6,10.3,12.0,139.7,1
216.3,130.7,130.4,10.0,10.1,138.8,1
215.6,130.4,130.1,9.6,11.2,138.6,1
214.8,129.9,129.8,9.6,12.0,139.6,1
214.9,130.0,129.9,11.4,10.9,139.7,1
213.9,130.7,130.5,8.7,11.5,137.8,1
214.2,130.6,130.4,12.0,10.2,139.6,1
214.8,130.5,130.3,11.8,10.5,139.4,1
214.8,129.6,130.0,10.4,11.6,139.2,1
214.8,130.1,130.0,11.4,10.5,139.6,1
214.9,130.4,130.2,11.9,10.7,139.0,1
214.3,130.1,130.1,11.6,10.5,139.7,1
214.5,130.4,130.0,9.9,12.0,139.6,1
214.8,130.5,130.3,10.2,12.1,139.1,1
214.5,130.2,130.4,8.2,11.8,137.8,1
215.0,130.4,130.1,11.4,10.7,139.1,1
214.8,130.6,130.6,8.0,11.4,138.7,1
215.0,130.5,130.1,11.0,11.4,139.3,1
214.6,130.5,130.4,10.1,11.4,139.3,1
214.7,130.2,130.1,10.7,11.1,139.5,1
214.7,130.4,130.0,11.5,10.7,139.4,1
214.5,130.4,130.0,8.0,12.2,138.5,1
214.8,130.0,129.7,11.4,10.6,139.2,1
214.8,129.9,130.2,9.6,11.9,139.4,1
214.6,130.3,130.2,12.7,9.1,139.2,1
215.1,130.2,129.8,10.2,12.0,139.4,1
215.4,130.5,130.6,8.8,11.0,138.6,1
214.7,130.3,130.2,10.8,11.1,139.2,1
215.0,130.5,130.3,9.6,11.0,138.5,1
214.9,130.3,130.5,11.6,10.6,139.8,1
215.0,130.4,130.3,9.9,12.1,139.6,1
215.1,130.3,129.9,10.3,11.5,139.7,1
214.8,130.3,130.4,10.6,11.1,140.0,1
214.7,130.7,130.8,11.2,11.2,139.4,1
214.3,129.9,129.9,10.2,11.5,139.6,1

Primeira Aula 19/8/2021

  Primeira Aula 19/8/2021

 Link Permanente: zwz-pbzr-qkx

 

Primeiro Vídeo

- Assunto: Introdução à IA – Exemplo do Dinheiro Falso

- Data: 19/8/2021

- Link Youtube: https://youtu.be/yCOXF1N5YZw

Segundo Video

- Assunto: Rodando o Weka (ML S para Classificação). Exemplo da falsificação de Dinheiro

- Data: 19/8/2021

- Link Youtube: https://youtu.be/9kmB2roNLNA

 

 

Link de Hoje Completo:

 https://meet.google.com/sti-yqky-icn

Cor de Caneta para Dinheiro Falso - Serve?

 Cor de Caneta para Dinheiro Falso - Serve?

Status	Cor Caneta
0	83,65353
0	90,25343
0	43,13085
0	53,01225
0	15,33307
0	57,59582
0	36,0029
0	86,40212
0	61,48928
0	12,45479
0	4,62973
0	91,85131
0	30,54573
0	49,49624
0	40,16129
0	51,27183
0	36,86467
0	46,25725
0	62,8076
0	65,58608
0	4,70759
0	31,26727
0	21,11035
0	1,13906
0	70,89552
0	61,63458
0	29,19919
0	30,76647
0	76,60232
0	9,31595
0	93,06659
0	16,74785
0	91,07692
0	30,86002
0	96,89812
0	71,72279
0	58,34042
0	84,71992
0	82,90316
0	23,94091
0	79,02688
0	86,48963
0	65,42981
0	62,23108
0	66,25354
0	44,5922
0	19,19184
0	87,24295
0	30,10982
0	5,91166
0	64,27039
0	2,55993
0	34,70459
0	183,32562
0	16,41623
0	76,60185
0	15,16712
0	57,74074
0	1,89488
0	45,0128
0	3,58244
0	61,68626
0	38,19348
0	61,61745
0	54,99944
0	39,34293
0	9,99716
0	4,36134
0	45,13104
0	161,42563
0	32,14225
0	80,09399
0	92,09951
0	81,71371
0	11,95441
0	94,45796
0	6,28648
0	88,99565
0	40,16958
0	22,33717
0	90,1883
0	79,69556
0	43,70476
0	67,03159
0	58,19778
0	47,42314
0	86,94677
0	92,93823
0	50,32061
0	54,4594
0	85,621
0	49,63298
0	87,32418
0	45,99332
0	78,72574
0	75,01017
0	19,3562
0	16,23
0	43,88422
0	93,09701
1	34,69576
1	61,71355
1	20,39865
1	106,44009
1	30,37141
1	56,89958
1	72,72
1	89,53084
1	82,73819
1	84,05903
1	28,16527
1	29,67405
1	39,1569
1	52,2792
1	21,73199
1	59,89746
1	31,16851
1	53,81875
1	79,13291
1	84,01863
1	72,00784
1	18,60162
1	92,39925
1	98,07972
1	55,58555
1	23,04342
1	97,52286
1	48,45659
1	21,72005
1	80,9902
1	11,87254
1	63,80653
1	20,75768
1	53,69426
1	82,30976
1	89,0245
1	72,09232
1	31,44685
1	28,90182
1	67,95739
1	17,90656
1	34,29343
1	72,43088
1	93,70734
1	96,90829
1	24,4345
1	83,72753
1	39,53333
1	59,03921
1	52,51332
1	19,96579
1	24,58857
1	75,19153
1	106,05215
1	92,3004
1	43,80708
1	55,79931
1	19,47883
1	61,51025
1	83,7093
1	60,50356
1	68,42157
1	29,55
1	53,38098
1	22,15106
1	99,65967
1	75,51685
1	63,58178
1	86,66296
1	109,6289
1	91,10468
1	48,92542
1	31,09325
1	20,26407
1	69,48994
1	83,89364
1	15,51428
1	61,59145
1	44,72399
1	97,93596
1	30,32127
1	102,66528
1	83,52417
1	71,13818
1	50,61342
1	83,71403
1	104,45799
1	88,46663
1	93,10527
1	79,74555
1	89,37621
1	29,14828
1	28,15244
1	39,78067
1	20,63377
1	10,62059
1	88,94284
1	46,35969
1	90,1424
1	12,64731