{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["solution","text","hot_dogs"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"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":"solution","index":0,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Product_Name","Type","Taste","__oz","__lb_Protein","Calories","Sodium","Protein_Fat"]
["Happy Hill Supers","Beef","Bland",0.11,14.23,186,495,1]
["Georgies Skinless Beef","Beef","Bland",0.17,21.7,181,477,2]
["Special Market's Premium Beef","Beef","Bland",0.11,14.49,176,425,1]
["Spike's Beef","Beef","Medium",0.15,20.49,149,322,1]
["Hungry Hugh's Jumbo Beef","Beef","Medium",0.1,14.47,184,482,1]
["Great Dinner Beef","Beef","Medium",0.11,15.45,190,587,1]
["RJB Kosher Beef","Beef","Medium",0.21,25.25,158,370,2]
["Wonder Kosher Skinless Beef","Beef","Medium",0.2,24.02,139,322,2]
["Happy Fats Jumbo Beef","Beef","Medium",0.14000000000000001,18.86,175,479,1]
["Midwest Beef","Beef","Medium",0.14000000000000001,18.86,148,375,1]
["General Kosher Beef","Beef","Medium",0.23,30.65,152,330,1]
["Wall's Kosher Beef Lower Fat","Beef","Medium",0.25,25.62,111,300,3]
["Hickory Natural Smoke","Beef","Medium",7.0000000000000007E-2,8.1199999999999992,141,386,2]
["Smith Beef","Beef","Medium",0.09,12.74,153,401,1]
["Premium Beef","Beef","Medium",0.1,14.21,190,645,1]
["Family StoreSkinless Beef","Beef","Medium",0.1,13.39,157,440,1,null,null,null,"Count of Type"]
["Sam's Kosher Beef","Beef","Medium",0.19,22.31,131,317,2,null,null,null,"Type","Total"]
["Hammer Beef","Beef","Medium",0.11,19.95,149,319,1,null,null,null,"Beef",0.37037037037037035]
["Athens Beef","Beef","Medium",0.19,22.9,135,298,2,null,null,null,"Meat",0.31481481481481483]
["Regents Kosher Beef","Beef","Scrumptious",0.17,19.78,132,253,2,null,null,null,"Poultry",0.31481481481481483]
["Really Big","Meat","Bland",0.12,14.86,173,458,2,null,null,null,"Grand Total",1]
["Biggest Jumbo","Meat","Bland",0.12,17.32,191,506,1]
["Home Made","Meat","Bland",0.12,15.2,182,473,1]
["Martha's Jumbo Dinner","Meat","Bland",0.1,14.01,190,545,1]
["Hammer Premium","Meat","Bland",0.11,13.92,172,496,2]
["Willie's Wieners","Meat","Bland",0.13,18.239999999999998,147,360,1,null,null,null,"Sum of __oz","Taste"]
["Premium Hot Dogs","Meat","Medium",0.1,14.12,146,387,1,null,null,null,"Type","Bland","Medium","Scrumptious","Grand Total"]
["Airport Wieners","Meat","Medium",0.09,11.83,139,386,2,null,null,null,"Beef",0.39,2.3800000000000003,0.17,2.9400000000000004]
["Judy's Favorite Jumbos","Meat","Medium",0.11,15.41,175,507,1,null,null,null,"Meat",0.7,0.94999999999999984,0.21000000000000002,1.8599999999999999]
["Stick Lean Supreme Jumbo","Meat","Medium",0.15,17.399999999999999,136,393,3,null,null,null,"Poultry",0.08,1.07,0.06,1.2100000000000002]
["Stick Jumbo","Meat","Medium",0.13,17.32,179,405,1,null,null,null,"Grand Total",1.17,4.4000000000000004,0.44,6.0100000000000007]
["Fat Jack Jumbo","Meat","Medium",0.1,15.61,153,372,1]
["Thin Jack Veal","Meat","Medium",0.18,20.399999999999999,107,144,3]
["Top Grade Hot Dogs","Meat","Medium",0.09,12.65,195,511,1]
["Blended w/Chicken&Beef","Meat","Scrumptious",7.0000000000000007E-2,11.17,135,405,1]
["Heaven Made","Meat","Scrumptious",0.08,11.75,140,428,1]
["Baked and Smoked","Meat","Scrumptious",0.06,9.49,138,339,1]
["Smart Person Chicken","Poultry","Bland",0.08,10.210000000000001,129,430,2]
["Woods Park  Chicken","Poultry","Medium",0.05,6.37,132,375,2]
["Tony Turkey","Poultry","Medium",7.0000000000000007E-2,8.42,102,396,3]
["Rose Garden Turkey","Poultry","Medium",0.08,9.3699999999999992,106,383,3]
["Low Fat Turkey","Poultry","Medium",0.08,9,94,387,4]
["Special Market's Turkey","Poultry","Medium",7.0000000000000007E-2,8.07,102,542,5]
["Calorie-less Turkey","Poultry","Medium",0.09,9.39,90,359,5]
["Heaven Made  Lower Fat","Poultry","Medium",0.06,6.59,99,357,4]
["McDowell's Jumbo Chicken","Poultry","Medium",7.0000000000000007E-2,8.43,107,528,2]
["Estate Turkey","Poultry","Medium",0.08,8.6300000000000008,113,513,5]
["Forth Generation Chicken","Poultry","Medium",7.0000000000000007E-2,7.39,135,426,4]
[" Best Grill  Chicken","Poultry","Medium",7.0000000000000007E-2,7.42,142,513,3]
["Estate Chicken","Poultry","Medium",7.0000000000000007E-2,6.27,83,358,3]
["College Bred Chicken","Poultry","Medium",0.08,9.07,143,581,3]
["Willie's Great Chicken","Poultry","Medium",0.06,7.91,152,588,2]
["Heaven Made Chicken","Poultry","Medium",7.0000000000000007E-2,8.7899999999999991,146,522,2]
["Mike Murphy's Best Chicken","Poultry","Scrumptious",0.06,7.18,144,545,3]

{"sheet":"text","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["An investigation of the taste and nutritional content of three types of hot dogs was carried out. The types of franks included in the study were categorized as beef, meat, and poultry. Construct a bar chart of hot dog type and use it to compare the type frequencies."]

{"sheet":"hot_dogs","index":2,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Product_Name","Type","Taste","__oz","__lb_Protein","Calories","Sodium","Protein_Fat"]
["Happy Hill Supers","Beef","Bland",0.11,14.23,186,495,1]
["Georgies Skinless Beef","Beef","Bland",0.17,21.7,181,477,2]
["Special Market's Premium Beef","Beef","Bland",0.11,14.49,176,425,1]
["Spike's Beef","Beef","Medium",0.15,20.49,149,322,1]
["Hungry Hugh's Jumbo Beef","Beef","Medium",0.1,14.47,184,482,1]
["Great Dinner Beef","Beef","Medium",0.11,15.45,190,587,1]
["RJB Kosher Beef","Beef","Medium",0.21,25.25,158,370,2]
["Wonder Kosher Skinless Beef","Beef","Medium",0.2,24.02,139,322,2]
["Happy Fats Jumbo Beef","Beef","Medium",0.14000000000000001,18.86,175,479,1]
["Midwest Beef","Beef","Medium",0.14000000000000001,18.86,148,375,1]
["General Kosher Beef","Beef","Medium",0.23,30.65,152,330,1]
["Wall's Kosher Beef Lower Fat","Beef","Medium",0.25,25.62,111,300,3]
["Hickory Natural Smoke","Beef","Medium",7.0000000000000007E-2,8.1199999999999992,141,386,2]
["Smith Beef","Beef","Medium",0.09,12.74,153,401,1]
["Premium Beef","Beef","Medium",0.1,14.21,190,645,1]
["Family StoreSkinless Beef","Beef","Medium",0.1,13.39,157,440,1]
["Sam's Kosher Beef","Beef","Medium",0.19,22.31,131,317,2]
["Hammer Beef","Beef","Medium",0.11,19.95,149,319,1]
["Athens Beef","Beef","Medium",0.19,22.9,135,298,2]
["Regents Kosher Beef","Beef","Scrumptious",0.17,19.78,132,253,2]
["Really Big","Meat","Bland",0.12,14.86,173,458,2]
["Biggest Jumbo","Meat","Bland",0.12,17.32,191,506,1]
["Home Made","Meat","Bland",0.12,15.2,182,473,1]
["Martha's Jumbo Dinner","Meat","Bland",0.1,14.01,190,545,1]
["Hammer Premium","Meat","Bland",0.11,13.92,172,496,2]
["Willie's Wieners","Meat","Bland",0.13,18.239999999999998,147,360,1]
["Premium Hot Dogs","Meat","Medium",0.1,14.12,146,387,1]
["Airport Wieners","Meat","Medium",0.09,11.83,139,386,2]
["Judy's Favorite Jumbos","Meat","Medium",0.11,15.41,175,507,1]
["Stick Lean Supreme Jumbo","Meat","Medium",0.15,17.399999999999999,136,393,3]
["Stick Jumbo","Meat","Medium",0.13,17.32,179,405,1]
["Fat Jack Jumbo","Meat","Medium",0.1,15.61,153,372,1]
["Thin Jack Veal","Meat","Medium",0.18,20.399999999999999,107,144,3]
["Top Grade Hot Dogs","Meat","Medium",0.09,12.65,195,511,1]
["Blended w/Chicken&Beef","Meat","Scrumptious",7.0000000000000007E-2,11.17,135,405,1]
["Heaven Made","Meat","Scrumptious",0.08,11.75,140,428,1]
["Baked and Smoked","Meat","Scrumptious",0.06,9.49,138,339,1]
["Smart Person Chicken","Poultry","Bland",0.08,10.210000000000001,129,430,2]
["Woods Park  Chicken","Poultry","Medium",0.05,6.37,132,375,2]
["Tony Turkey","Poultry","Medium",7.0000000000000007E-2,8.42,102,396,3]
["Rose Garden Turkey","Poultry","Medium",0.08,9.3699999999999992,106,383,3]
["Low Fat Turkey","Poultry","Medium",0.08,9,94,387,4]
["Special Market's Turkey","Poultry","Medium",7.0000000000000007E-2,8.07,102,542,5]
["Calorie-less Turkey","Poultry","Medium",0.09,9.39,90,359,5]
["Heaven Made  Lower Fat","Poultry","Medium",0.06,6.59,99,357,4]
["McDowell's Jumbo Chicken","Poultry","Medium",7.0000000000000007E-2,8.43,107,528,2]
["Estate Turkey","Poultry","Medium",0.08,8.6300000000000008,113,513,5]
["Forth Generation Chicken","Poultry","Medium",7.0000000000000007E-2,7.39,135,426,4]
[" Best Grill  Chicken","Poultry","Medium",7.0000000000000007E-2,7.42,142,513,3]
["Estate Chicken","Poultry","Medium",7.0000000000000007E-2,6.27,83,358,3]
["College Bred Chicken","Poultry","Medium",0.08,9.07,143,581,3]
["Willie's Great Chicken","Poultry","Medium",0.06,7.91,152,588,2]
["Heaven Made Chicken","Poultry","Medium",7.0000000000000007E-2,8.7899999999999991,146,522,2]
["Mike Murphy's Best Chicken","Poultry","Scrumptious",0.06,7.18,144,545,3]