{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","tabelas","gráficos","dashboard"],"not_rendered":{"charts":5,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":8},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Data","index":0,"n_rows":105,"n_cols":7,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Customer","Method of Payment","Items","Sales","Gender","Marital Status","Age"]
[1,"Discover",1,39.5,"Male","Married",32]
[2,"Proprietary Card",1,102.4,"Female","Married",36]
[3,"Proprietary Card",1,22.5,"Female","Married",32]
[4,"Proprietary Card",5,100.4,"Female","Married",28]
[5,"Mastercard",2,54,"Female","Married",34]
[6,"Mastercard",1,44.5,"Female","Married",44]
[7,"Proprietary Card",2,78,"Female","Married",30]
[8,"Visa",1,22.5,"Female","Married",40]
[9,"Proprietary Card",2,56.52,"Female","Married",46]
[10,"Proprietary Card",1,44.5,"Female","Married",36]
[11,"Proprietary Card",1,29.5,"Female","Married",48]
[12,"Proprietary Card",1,31.6,"Female","Married",40]
[13,"Visa",9,160.4,"Female","Married",40]
[14,"Visa",2,64.5,"Female","Married",46]
[15,"Visa",1,49.5,"Male","Single",24]
[16,"Proprietary Card",2,71.400000000000006,"Male","Single",36]
[17,"Proprietary Card",3,94,"Female","Single",22]
[18,"Discover",3,54.5,"Female","Married",40]
[19,"Mastercard",2,38.5,"Female","Married",32]
[20,"Proprietary Card",6,44.8,"Female","Married",56]
[21,"Proprietary Card",1,31.6,"Female","Single",28]
[22,"Proprietary Card",4,70.819999999999993,"Female","Married",38]
[23,"American Express",7,266,"Female","Married",50]
[24,"Proprietary Card",2,74,"Female","Married",42]
[25,"Visa",2,39.5,"Male","Married",48]
[26,"Proprietary Card",1,30.02,"Female","Married",60]
[27,"Proprietary Card",1,44.5,"Female","Married",54]
[28,"Proprietary Card",5,192.8,"Female","Single",42]
[29,"Proprietary Card",3,71.2,"Female","Married",32]
[30,"Proprietary Card",1,18,"Female","Married",70]
[31,"Mastercard",2,63.2,"Female","Married",28]
[32,"Proprietary Card",1,75,"Female","Married",52]
[33,"Proprietary Card",3,63.2,"Female","Married",44]
[34,"Proprietary Card",1,40,"Female","Married",34]
[35,"Mastercard",5,105.5,"Female","Married",56]
[36,"Mastercard",1,29.5,"Male","Single",36]
[37,"Visa",2,102.5,"Female","Single",42]
[38,"Proprietary Card",6,117.5,"Female","Married",50]
[39,"Proprietary Card",5,13.23,"Female","Married",44]
[40,"Proprietary Card",2,52.5,"Female","Married",58]
[41,"Proprietary Card",13,198.8,"Female","Married",42]
[42,"Visa",4,19.5,"Female","Married",46]
[43,"Proprietary Card",2,123.5,"Female","Married",48]
[44,"Proprietary Card",1,62.4,"Female","Married",54]
[45,"Proprietary Card",2,23.8,"Female","Married",38]
[46,"Proprietary Card",2,39.6,"Female","Married",60]
[47,"Mastercard",1,25,"Female","Married",46]
[48,"Proprietary Card",3,63.64,"Female","Married",30]
[49,"Proprietary Card",1,14.82,"Female","Married",32]
[50,"Mastercard",9,145.19999999999999,"Female","Married",46]
[51,"Proprietary Card",6,176.62,"Female","Married",38]
[52,"Proprietary Card",5,118.8,"Male","Married",68]
[53,"Discover",1,58,"Female","Single",78]
[54,"Visa",2,74,"Female","Single",20]
[55,"Mastercard",2,49.5,"Female","Married",32]
[56,"Proprietary Card",3,141.6,"Female","Married",38]
[57,"Proprietary Card",6,123.1,"Female","Married",54]
[58,"Proprietary Card",2,80.400000000000006,"Female","Married",48]
[59,"Mastercard",4,65.2,"Female","Married",46]
[60,"Proprietary Card",4,113,"Female","Single",50]
[61,"Proprietary Card",1,108.8,"Female","Married",46]
[62,"Proprietary Card",3,59.91,"Female","Single",30]
[63,"Proprietary Card",5,53.6,"Female","Married",54]
[64,"Proprietary Card",1,31.6,"Female","Single",42]
[65,"Proprietary Card",2,49.5,"Female","Married",48]
[66,"Proprietary Card",1,39.6,"Female","Married",62]
[67,"Proprietary Card",2,59.5,"Female","Married",34]
[68,"Proprietary Card",5,146.80000000000001,"Female","Married",28]
[69,"Proprietary Card",2,47.2,"Male","Married",46]
[70,"Proprietary Card",8,95.05,"Female","Married",54]
[71,"Proprietary Card",5,155.32,"Female","Married",30]
[72,"Mastercard",4,58,"Female","Married",32]
[73,"Proprietary Card",1,69,"Female","Single",22]
[74,"Proprietary Card",2,46.5,"Female","Married",32]
[75,"Proprietary Card",2,45.22,"Female","Married",74]
[76,"Proprietary Card",4,84.74,"Female","Married",62]
[77,"Proprietary Card",2,39,"Female","Married",42]
[78,"Proprietary Card",4,111.14,"Female","Married",28]
[79,"Proprietary Card",3,86.8,"Female","Married",38]
[80,"Discover",2,89,"Female","Married",54]
[81,"Mastercard",2,78,"Female","Married",68]
[82,"Proprietary Card",6,53.2,"Female","Single",30]
[83,"Visa",4,58.5,"Female","Married",36]
[84,"Proprietary Card",3,46,"Female","Married",44]
[85,"Visa",2,37.5,"Female","Married",44]
[86,"Proprietary Card",1,20.8,"Female","Married",62]
[87,"Mastercard",6,144,"Female","Single",48]
[88,"Proprietary Card",4,107,"Female","Married",36]
[89,"Proprietary Card",1,31.6,"Female","Single",20]
[90,"Proprietary Card",6,57.6,"Female","Married",42]
[91,"Proprietary Card",4,95.2,"Female","Married",54]
[92,"Proprietary Card",1,22.42,"Female","Married",54]
[93,"Proprietary Card",5,159.75,"Female","Married",72]
[94,"Proprietary Card",17,229.5,"Female","Married",30]
[95,"American Express",3,66,"Female","Married",46]
[96,"Mastercard",1,39.5,"Female","Married",44]
[97,"Proprietary Card",9,253,"Female","Married",30]
[98,"Proprietary Card",10,287.58999999999997,"Female","Married",52]
[99,"Proprietary Card",2,47.6,"Female","Married",30]
[100,"Proprietary Card",1,28.44,"Female","Married",44]

{"sheet":"tabelas","index":1,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[12,8,12,9]]}
[]
[]
[]
[]
[null,"Método de pagamento","Frequência absoluta","Frequência relativa","Frequência percentual","Frequência acumulada","Frequência acumulada percentual"]
[null,"American Express",2,0.02,0.02,2,0.02]
[null,"Discover",4,0.04,0.04,6,0.06]
[null,"Mastercard",14,0.14000000000000001,0.14000000000000001,20,0.2]
[null,"Proprietary Card",70,0.7,0.7,90,0.9]
[null,"Visa",10,0.1,0.1,100,1]
[null,"Total Geral",100,1,1]
[]
[null,"Intervalo de classes","Frequência absoluta","Frequência relativa","Frequência percentual","Frequência acumulada","Frequência acumulada percentual",null,"Critério de Sturges"]
[null,{"$f":"fdt(Tabela1[Sales],3,1)","v":"[13,098;47,769)"},36,{"$f":"C14/$C$22","v":0.36},{"$f":"D14","v":0.36},{"$f":"C14","v":36},{"$f":"E14","v":0.36},null,"Nº de classes",{"$f":"ROUNDUP(1+LOG(100,2),0)","v":8}]
[null,"[47,769;82,44)",32,{"$f":"C15/$C$22","v":0.32},{"$f":"D15","v":0.32},{"$f":"F14+C15","v":68},{"$f":"G14+E15","v":0.67999999999999994},null,"Limite inferior",{"$f":"MIN(Tabela1[Sales]-Tabela1[Sales]/100)","v":13.0977}]
[null,"[82,44;117,111)",14,0.14000000000000001,0.14000000000000001,{"$f":"F15+C16","v":82},{"$f":"G15+E16","v":0.82},null,"Limite superior",{"$f":"MAX(Tabela1[Sales]+Tabela1[Sales]/100)","v":290.46589999999998}]
[null,"[117,111;151,782)",8,0.08,0.08,90,0.89999999999999991,null,"Comprimento da classe (h)",{"$f":"(J16-J15)/J14","v":34.671025}]
[null,"[151,782;186,453)",4,0.04,0.04,94,0.94]
[null,"[186,453;221,124)",2,0.02,0.02,96,0.96]
[null,"[221,124;255,795)",2,0.02,0.02,98,0.98]
[null,"[255,795;290,466)",2,0.02,0.02,100,1]
[null,"Total Geral",{"$f":"SUM(C14:C21)","v":100},{"$f":"SUM(D14:D21)","v":1}]
[]
[null,"Método de pagamento","Média de Sales","Var. de Sales","DesvPad de Sales","Mín. de Sales","Máx. de Sales"]
[null,"American Express",166,20000,141.42135623730951,66,266]
[null,"Discover",60.25,431.75,20.778594755180148,39.5,89]
[null,"Mastercard",67.114285714285714,1497.4028571428576,38.696289966130571,25,145.19999999999999]
[null,"Proprietary Card",80.272142857142853,3316.5224257763966,57.589256166201665,13.23,287.58999999999997]
[null,"Visa",62.839999999999996,1789.7226666666668,42.305113954067856,19.5,160.4]
[null,"Total Geral",77.600500000000025,3098.5853704545434,55.664938430348982,13.23,287.58999999999997]
[]
[null,"Método de pagamento","Contagem de Gender"]
[null,"Female",93]
[null,"Male",7]
[null,"Total Geral",100]
[]
[null,"Método de pagamento","Contagem de Marital Status"]
[null,"Married",84]
[null,"Single",16]
[null,"Total Geral",100]

{"sheet":"gráficos","index":2,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,2,20]]}
["Para gráficos dinâmicos e, caso tenha tabelas dinâmicas com mais de uma coluna e, caso queira utilizar apenas algumas colunas, é mais fácil fazer outra tabela dinâmica apenas com as colunas desejadas"]
[]
[]
[]
["Método de pagamento","Frequência percentual"]
["American Express",0.02]
["Discover",0.04]
["Mastercard",0.14000000000000001]
["Proprietary Card",0.7]
["Visa",0.1]
["Total Geral",1]
[]
["Intervalo de classes","Frequência absoluta","Frequência relativa","Frequência percentual","Frequência acumulada","Frequência acumulada percentual"]
[{"$f":"fdt(Tabela1[Sales],3,1)","v":"[13,098;47,769)"},36,{"$f":"B14/$C$19","v":0.36},{"$f":"C14","v":0.36},{"$f":"B14","v":36},{"$f":"D14","v":0.36}]
["[47,769;82,44)",32,{"$f":"B15/$C$19","v":0.32},{"$f":"C15","v":0.32},{"$f":"E14+B15","v":68},{"$f":"F14+D15","v":0.67999999999999994}]
["[82,44;117,111)",14,0.14000000000000001,0.14000000000000001,{"$f":"E15+B16","v":82},{"$f":"F15+D16","v":0.82}]
["[117,111;151,782)",8,0.08,0.08,90,0.89999999999999991]
["[151,782;186,453)",4,0.04,0.04,94,0.94]
["[186,453;221,124)",2,0.02,0.02,96,0.96]
["[221,124;255,795)",2,0.02,0.02,98,0.98]
["[255,795;290,466)",2,0.02,0.02,100,1]
["Total Geral",{"$f":"SUM(B14:B21)","v":100},{"$f":"SUM(C14:C21)","v":1}]
[]
["Método de pagamento","Média de Sales","Mín. de Sales","Máx. de Sales"]
["American Express",166,66,266]
["Discover",60.25,39.5,89]
["Mastercard",67.114285714285714,25,145.19999999999999]
["Proprietary Card",80.272142857142853,13.23,287.58999999999997]
["Visa",62.839999999999996,19.5,160.4]
["Total Geral",77.600500000000025,13.23,287.58999999999997]
[]
["Sexo","Contagem de Gender"]
["Female",93]
["Male",7]
["Total Geral",100]
[]
["Estado civil","Contagem de Marital Status"]
["Married",84]
["Single",16]
["Total Geral",100]

{"sheet":"dashboard","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}