{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PT","PT2"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":2,"pivot_tables":2},"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":"PT","index":0,"n_rows":259,"n_cols":17,"rows_kept":259,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table2",null,null,null,null,"PivotTable1",null,null,null,"With macro",null,"Table3"]
[null,"NName","State","Age","Median",null,"State","NName","_Age",null,null,null,"State","Av_Age","Md_Age"]
[null,"Adams","CA",46,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,"CA",null,56.2,null,null,null,"CA",56.200000762939453,62]
[null,"Bailey","CA",40,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Miller",63,null,null,null,"MO",40.25,41]
[null,"Bell","CA",46,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Mitchell",37,null,null,null,"NV",36.75,36]
[null,"Boyd","CA",37,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Morales",54,null,null,null,"TX",43.166667938232422,46.5]
[null,"Brooks","CA",19,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Morris",65,null,null,null,"PT_All",{"$f":"44.63158","v":44.63158},{"$f":"47","v":47}]
[null,"Brown","CA",65,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Murphy",62]
[null,"Carter","CA",53,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,"MO",null,40.25]
[null,"Cooper","CA",62,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Marshall",35,null,null,null,null,null,null,null,"For \"M\" Names"]
[null,"Crawford","CA",19,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Miller",58]
[null,"Diaz","CA",23,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Murray",47,null,null,null,"Table4"]
[null,"Edwards","CA",63,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Myers",21,null,"With Formulas",null,"State","Av_Age","Md_Age"]
[null,"Flores","CA",42,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,"NV",null,36.75,null,null,null,"CA",{"$f":"AVERAGEIFS(Table2[Age],Table2[NName],\"=M*\",Table2[State],Table4[[#This Row],[State]])","v":56.2},{"$f":"MEDIAN(IFERROR(1/(1/((LEFT(Table2[NName])=\"M\")*(Table2[State]=Table4[[#This Row],[State]])*(Table2[Age]))),\"\"))","v":62}]
[null,"Ford","CA",51,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Martin",24,null,null,null,"MO",{"$f":"AVERAGEIFS(Table2[Age],Table2[NName],\"=M*\",Table2[State],Table4[[#This Row],[State]])","v":40.25},{"$f":"MEDIAN(IFERROR(1/(1/((LEFT(Table2[NName])=\"M\")*(Table2[State]=Table4[[#This Row],[State]])*(Table2[Age]))),\"\"))","v":41}]
[null,"Gibson","CA",36,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Martinez",21,null,null,null,"NV",{"$f":"AVERAGEIFS(Table2[Age],Table2[NName],\"=M*\",Table2[State],Table4[[#This Row],[State]])","v":36.75},{"$f":"MEDIAN(IFERROR(1/(1/((LEFT(Table2[NName])=\"M\")*(Table2[State]=Table4[[#This Row],[State]])*(Table2[Age]))),\"\"))","v":36}]
[null,"Gonzales","CA",49,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Mcdonald",54,null,null,null,"TX",{"$f":"AVERAGEIFS(Table2[Age],Table2[NName],\"=M*\",Table2[State],Table4[[#This Row],[State]])","v":43.166666666666664},{"$f":"MEDIAN(IFERROR(1/(1/((LEFT(Table2[NName])=\"M\")*(Table2[State]=Table4[[#This Row],[State]])*(Table2[Age]))),\"\"))","v":46.5}]
[null,"Griffin","CA",32,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Murray",48]
[null,"Hayes","CA",29,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,"TX",null,43.166666666666664]
[null,"Hernandez","CA",50,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Marshall",64]
[null,"Hicks","CA",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Mitchell",46]
[null,"Howard","CA",35,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Moore",29]
[null,"Hughes","CA",53,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Morales",51]
[null,"Hunter","CA",57,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Morris",47]
[null,"Jackson","CA",54,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429},null,null,"Murray",22]
[null,"James","CA",41,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Jenkins","CA",44,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Jones","CA",64,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"King","CA",61,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Miller","CA",63,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Mitchell","CA",37,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Morales","CA",54,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Morris","CA",65,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Murphy","CA",62,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Nelson","CA",18,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Patterson","CA",38,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Perez","CA",55,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Perry","CA",63,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Phillips","CA",56,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Price","CA",26,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Robinson","CA",26,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Rogers","CA",45,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Sanchez","CA",21,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Scott","CA",55,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Simpson","CA",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Smith","CA",61,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Taylor","CA",55,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Thomas","CA",38,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Thompson","CA",38,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Torres","CA",35,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Tucker","CA",40,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Walker","CA",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Wallace","CA",27,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Ward","CA",25,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"West","CA",34,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Wilson","CA",19,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Wright","CA",53,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Young","CA",51,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.7678571428571429}]
[null,"Allen","MN",34,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Barnes","MN",45,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Brooks","MN",40,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Campbell","MN",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Clark","MN",56,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Cole","MN",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Collins","MN",37,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Cox","MN",42,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Crawford","MN",51,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Cruz","MN",38,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Diaz","MN",20,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Foster","MN",52,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Gibson","MN",33,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Gomez","MN",49,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Green","MN",59,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Henderson","MN",60,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Hicks","MN",48,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Howard","MN",49,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Jordan","MN",55,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Kelly","MN",63,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"King","MN",33,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Lopez","MN",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Martin","MN",57,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Mitchell","MN",20,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Morris","MN",28,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Murphy","MN",24,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Murray","MN",64,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Nelson","MN",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Ortiz","MN",42,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Patterson","MN",18,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Perez","MN",54,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Peterson","MN",63,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Phillips","MN",23,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Ramirez","MN",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Robinson","MN",18,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Sanders","MN",53,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Scott","MN",65,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Simmons","MN",47,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Stevens","MN",28,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Thompson","MN",63,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Turner","MN",19,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Walker","MN",46,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Ward","MN",18,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Washington","MN",29,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Wells","MN",59,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"West","MN",62,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Williams","MN",18,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Wilson","MN",55,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Wright","MN",57,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.8571428571428571}]
[null,"Allen","MO",25,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Bennett","MO",34,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Boyd","MO",59,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Brooks","MO",51,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Bryant","MO",20,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Butler","MO",22,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Cole","MO",65,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Coleman","MO",64,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Crawford","MO",24,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Cruz","MO",29,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Ellis","MO",58,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Fisher","MO",46,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Foster","MO",64,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Gibson","MO",24,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Gonzales","MO",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Graham","MO",55,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Gray","MO",41,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Harrison","MO",29,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Hayes","MO",36,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Henderson","MO",41,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Hernandez","MO",36,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Hill","MO",51,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Hughes","MO",33,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Jenkins","MO",33,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Johnson","MO",35,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Jordan","MO",29,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Kelly","MO",21,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"King","MO",44,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Long","MO",54,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Lopez","MO",37,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Marshall","MO",35,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Miller","MO",58,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Murray","MO",47,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Myers","MO",21,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Ortiz","MO",35,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Parker","MO",45,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Perry","MO",21,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Peterson","MO",45,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Phillips","MO",22,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Reynolds","MO",47,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Richardson","MO",57,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Roberts","MO",28,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Rodriguez","MO",30,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Ross","MO",43,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Sanchez","MO",42,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Simmons","MO",43,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Simpson","MO",63,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Stewart","MO",28,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Taylor","MO",22,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Thompson","MO",25,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Wallace","MO",37,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Ward","MO",46,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Washington","MO",21,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Wilson","MO",55,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Woods","MO",38,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.67272727272727273}]
[null,"Alexander","NV",22,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Allen","NV",59,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Brooks","NV",37,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Brown","NV",43,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Butler","NV",22,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Cooper","NV",42,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Evans","NV",43,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Flores","NV",64,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Foster","NV",60,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Gibson","NV",21,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Gonzalez","NV",53,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Gray","NV",37,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Griffin","NV",44,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Harrison","NV",65,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Hayes","NV",63,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Hill","NV",31,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Howard","NV",38,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Jackson","NV",61,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Jenkins","NV",29,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Lewis","NV",29,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Long","NV",57,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Martin","NV",24,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Martinez","NV",21,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Mcdonald","NV",54,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Murray","NV",48,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Nelson","NV",60,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Owens","NV",21,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Perez","NV",61,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Perry","NV",27,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Roberts","NV",50,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Rogers","NV",24,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Ross","NV",54,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Sanders","NV",43,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Scott","NV",61,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Smith","NV",56,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Sullivan","NV",21,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Thomas","NV",33,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Torres","NV",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Tucker","NV",43,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Wallace","NV",24,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Watson","NV",64,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Webb","NV",23,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Woods","NV",65,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":1}]
[null,"Adams","TX",42,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Anderson","TX",59,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Bell","TX",20,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Brooks","TX",44,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Bryant","TX",46,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Campbell","TX",63,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Carter","TX",57,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Clark","TX",33,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Crawford","TX",43,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Cruz","TX",59,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Ellis","TX",55,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Evans","TX",37,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Garcia","TX",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Gonzales","TX",44,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Gonzalez","TX",54,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Hall","TX",28,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Harris","TX",58,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Henderson","TX",19,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Henry","TX",18,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Hicks","TX",35,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Hill","TX",46,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Jackson","TX",32,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Johnson","TX",28,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Kelly","TX",59,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Long","TX",27,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Marshall","TX",64,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Mitchell","TX",46,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Moore","TX",29,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Morales","TX",51,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Morris","TX",47,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Murray","TX",22,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Ortiz","TX",30,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Owens","TX",49,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Perez","TX",35,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Peterson","TX",31,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Ramirez","TX",24,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Richardson","TX",30,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Robinson","TX",61,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Rodriguez","TX",21,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Russell","TX",48,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Simpson","TX",55,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Smith","TX",20,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Stevens","TX",22,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Stewart","TX",57,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Sullivan","TX",41,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Thomas","TX",25,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Tucker","TX",55,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Turner","TX",34,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Walker","TX",20,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Wallace","TX",39,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Webb","TX",65,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Wilson","TX",18,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]
[null,"Woods","TX",52,{"$f":"MEDIAN(IF(Table2[State]=Table2[[#This Row],[State]],Table2[Age]))/COUNTIF(Table2[State],Table2[[#This Row],[State]])","v":0.77358490566037741}]

{"sheet":"PT2","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"All Names included"]
[null,null,"PivotTable"]
[null,null,null,"Values"]
[null,null,"State","Avg","_Median"]
[null,null,"CA",43.714285714285715,43.000000000000028]
[null,null,"MN",42.632653061224488,41.999999999999979]
[null,null,"MO",39.145454545454548,36.999999999999972]
[null,null,"NV",42.697674418604649,43]
[null,null,"TX",40.301886792452834,41.000000000000036]