{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Basic2DBar","Basic2DPie","Basic3DBar","Basic3DPie","Pro2DBar","Pro2DPie","Pro3DCylinder","Pro3DPie","Stamp","Define Variables Master","Data","Define Variables","Description"],"not_rendered":{"charts":8,"images":3,"macros":1,"external_links":1,"defined_names":116},"read":"whole","date_system":"1900"}

{"sheet":"Basic2DBar","index":0,"n_rows":32,"n_cols":4,"rows_kept":32,"hidden":true,"merged":[[24,1,24,3]]}
[]
[null,"Percentages Analysis Results"]
{"$rows_empty":22}
[null,"Size of home town or city"]
[null,"Category"," Frequency "," Percent "]
[null,"Strongly disagree",154,{"v":0.154,"d":"15.4%"}]
[null,"Disagree",177,{"v":0.177,"d":"17.7%"}]
[null,"Neither agree nor disagree",176,{"v":0.176,"d":"17.6%"}]
[null,"Agree",226,{"v":0.226,"d":"22.6%"}]
[null,"Strongly agree",267,{"v":0.267,"d":"26.7%"}]
[null,"Total",1000,{"v":1,"d":"100.0%"}]

{"sheet":"Basic2DPie","index":1,"n_rows":32,"n_cols":4,"rows_kept":32,"hidden":true,"merged":[[24,1,24,3]]}
[]
[null,"Percentages Analysis Results"]
{"$rows_empty":22}
[null,"Size of home town or city"]
[null,"Category"," Frequency "," Percent "]
[null,"Under 10K",154,{"v":0.154,"d":"15.4%"}]
[null,"10K to 100K",177,{"v":0.177,"d":"17.7%"}]
[null,"100K to 500K",176,{"v":0.176,"d":"17.6%"}]
[null,"500K to 1 million",226,{"v":0.226,"d":"22.6%"}]
[null,"1 million and more",267,{"v":0.267,"d":"26.7%"}]
[null,"Total",1000,{"v":1,"d":"100.0%"}]

{"sheet":"Basic3DBar","index":2,"n_rows":32,"n_cols":4,"rows_kept":32,"hidden":true,"merged":[[24,1,24,3]]}
[]
[null,"Percentages Analysis Results"]
{"$rows_empty":22}
[null,"Size of home town or city"]
[null,"Category"," Frequency "," Percent "]
[null,"Under 10K",154,{"v":0.154,"d":"15.4%"}]
[null,"10K to 100K",177,{"v":0.177,"d":"17.7%"}]
[null,"100K to 500K",176,{"v":0.176,"d":"17.6%"}]
[null,"500K to 1 million",226,{"v":0.226,"d":"22.6%"}]
[null,"1 million and more",267,{"v":0.267,"d":"26.7%"}]
[null,"Total",1000,{"v":1,"d":"100.0%"}]

{"sheet":"Basic3DPie","index":3,"n_rows":32,"n_cols":4,"rows_kept":32,"hidden":true,"merged":[[24,1,24,3]]}
[]
[null,"Percentages Analysis Results"]
{"$rows_empty":22}
[null,"Size of home town or city"]
[null,"Category"," Frequency "," Percent "]
[null,"Under 10K",154,{"v":0.154,"d":"15.4%"}]
[null,"10K to 100K",177,{"v":0.177,"d":"17.7%"}]
[null,"100K to 500K",176,{"v":0.176,"d":"17.6%"}]
[null,"500K to 1 million",226,{"v":0.226,"d":"22.6%"}]
[null,"1 million and more",267,{"v":0.267,"d":"26.7%"}]
[null,"Total",1000,{"v":1,"d":"100.0%"}]

{"sheet":"Pro2DBar","index":4,"n_rows":32,"n_cols":4,"rows_kept":32,"hidden":true,"merged":[[24,1,24,3]]}
[]
[null,"Percentages Analysis Results"]
{"$rows_empty":22}
[null,"Size of home town or city"]
[null,"Category"," Frequency "," Percent "]
[null,"Strongly disagree",154,{"v":0.154,"d":"15.4%"}]
[null,"Disagree",177,{"v":0.177,"d":"17.7%"}]
[null,"Neither agree nor disagree",176,{"v":0.176,"d":"17.6%"}]
[null,"Agree",226,{"v":0.226,"d":"22.6%"}]
[null,"Strongly agree",267,{"v":0.267,"d":"26.7%"}]
[null,"Total",1000,{"v":1,"d":"100.0%"}]

{"sheet":"Pro2DPie","index":5,"n_rows":32,"n_cols":4,"rows_kept":32,"hidden":true,"merged":[[24,1,24,3]]}
[]
[null,"Percentages Analysis Results"]
{"$rows_empty":22}
[null,"Size of home town or city"]
[null,"Category"," Frequency "," Percent "]
[null,"Under 10K",154,{"v":0.154,"d":"15.4%"}]
[null,"10K to 100K",177,{"v":0.177,"d":"17.7%"}]
[null,"100K to 500K",176,{"v":0.176,"d":"17.6%"}]
[null,"500K to 1 million",226,{"v":0.226,"d":"22.6%"}]
[null,"1 million and more",267,{"v":0.267,"d":"26.7%"}]
[null,"Total",1000,{"v":1,"d":"100.0%"}]

{"sheet":"Pro3DCylinder","index":6,"n_rows":32,"n_cols":4,"rows_kept":32,"hidden":true,"merged":[[24,1,24,3]]}
[]
[null,"Percentages Analysis Results"]
{"$rows_empty":22}
[null,"Size of home town or city"]
[null,"Category"," Frequency "," Percent "]
[null,"Strongly disagree",154,{"v":0.154,"d":"15.4%"}]
[null,"Disagree",177,{"v":0.177,"d":"17.7%"}]
[null,"Neither agree nor disagree",176,{"v":0.176,"d":"17.6%"}]
[null,"Agree",226,{"v":0.226,"d":"22.6%"}]
[null,"Strongly agree",267,{"v":0.267,"d":"26.7%"}]
[null,"Total",1000,{"v":1,"d":"100.0%"}]

{"sheet":"Pro3DPie","index":7,"n_rows":32,"n_cols":4,"rows_kept":32,"hidden":true,"merged":[[24,1,24,3]]}
[]
[null,"Percentages Analysis Results"]
{"$rows_empty":22}
[null,"Size of home town or city"]
[null,"Category"," Frequency "," Percent "]
[null,"Under 10K",154,{"v":0.154,"d":"15.4%"}]
[null,"10K to 100K",177,{"v":0.177,"d":"17.7%"}]
[null,"100K to 500K",176,{"v":0.176,"d":"17.6%"}]
[null,"500K to 1 million",226,{"v":0.226,"d":"22.6%"}]
[null,"1 million and more",267,{"v":0.267,"d":"26.7%"}]
[null,"Total",1000,{"v":1,"d":"100.0%"}]

{"sheet":"Stamp","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Define Variables Master","index":9,"n_rows":4,"n_cols":1,"rows_kept":4,"hidden":true}
["Variable Label"]
["Description"]
["Value Codes"]
["Value Labels"]

{"sheet":"Data","index":10,"n_rows":163,"n_cols":11,"rows_kept":163}
["FRIENDLY","CIRCLEK","COMMUTE","BARGAIN","CASH","QUICK","KNOWME","HURRY","DWELL","GENDER","WORK"]
[1,1,1,3,2,2,3,2,1,2,2]
[0,1,null,3,2,2,1,1,1,2,3]
[1,0,1,3,2,2,3,2,1,1,1]
[1,0,0,3,3,2,3,1,2,1,2]
[1,1,1,3,3,3,3,2,2,2,1]
[1,1,1,2,2,3,2,1,2,2,1]
[0,0,1,2,2,2,2,1,1,1,1]
[1,0,null,3,2,2,3,3,1,2,3]
[0,1,1,3,3,1,1,1,2,2,2]
[1,0,0,3,2,2,3,1,2,1,1]
[1,1,1,3,1,2,3,1,2,2,2]
[1,0,0,3,2,2,2,3,1,2,1]
[1,1,1,3,3,2,3,1,2,1,1]
[1,1,1,3,2,3,3,2,2,2,1]
[0,1,null,3,2,2,2,1,2,1,3]
[0,1,1,3,2,2,2,2,1,2,1]
[1,1,null,3,3,2,3,1,2,1,3]
[0,1,1,3,1,1,1,1,2,2,2]
[0,0,0,3,2,2,1,3,2,1,2]
[1,1,1,3,1,2,3,2,2,2,1]
[0,1,1,3,3,1,2,1,1,2,1]
[1,0,1,3,1,2,3,1,2,2,2]
[0,1,1,3,2,3,1,2,1,1,1]
[1,1,1,3,3,2,3,1,2,1,1]
[1,1,1,2,1,3,2,3,2,2,1]
[1,0,null,3,3,3,3,2,2,2,3]
[1,0,0,3,1,2,3,1,2,2,1]
[1,1,1,2,2,2,3,2,2,2,2]
[1,0,0,3,1,2,3,1,2,2,2]
[1,0,null,3,3,2,3,2,2,2,3]
[1,1,1,3,1,2,3,3,2,2,2]
[0,0,0,3,1,2,2,2,1,2,1]
[1,0,1,3,2,3,3,2,2,2,1]
[1,1,1,3,2,3,3,1,2,1,2]
[1,1,1,3,2,2,3,3,2,2,1]
[0,1,1,3,2,2,1,2,2,1,2]
[0,1,null,2,2,2,2,1,1,2,3]
[1,0,1,3,1,3,3,1,2,2,1]
[0,1,1,3,2,2,1,1,2,2,1]
[1,1,1,3,1,2,3,1,2,1,1]
[0,1,1,3,3,2,3,2,2,1,2]
[1,1,1,3,1,3,2,2,2,2,1]
[1,1,1,3,1,2,3,2,2,2,1]
[1,1,1,2,2,2,2,1,2,2,1]
[1,1,1,3,2,2,3,3,2,2,1]
[1,1,null,3,2,2,3,2,2,2,3]
[0,1,1,3,2,2,2,1,1,1,1]
[1,1,1,3,2,3,3,3,2,1,2]
[1,0,0,1,3,2,2,2,2,2,1]
[1,0,1,1,1,2,3,1,2,2,1]
[1,0,1,3,2,2,3,2,1,1,1]
[0,0,0,2,1,3,2,1,2,2,2]
[1,1,1,3,2,2,3,2,2,2,1]
[0,1,1,3,1,3,1,2,1,1,1]
[0,1,null,3,1,3,3,1,2,1,3]
[1,1,1,2,1,2,2,2,2,2,2]
[1,0,0,2,2,2,3,2,2,2,1]
[1,1,1,3,2,1,3,2,2,2,1]
[1,1,1,3,1,2,3,1,2,2,1]
[1,1,1,3,3,2,2,3,2,1,2]
[1,0,null,3,2,2,3,1,2,1,3]
[1,1,1,3,2,2,3,1,2,2,1]
[1,1,null,3,2,2,3,2,2,2,3]
[0,1,1,2,2,2,2,2,1,2,1]
[0,1,1,3,2,2,1,2,2,1,1]
[0,0,0,3,1,2,3,1,1,2,2]
[0,1,1,2,2,2,1,1,1,1,1]
[1,1,1,3,2,3,3,1,2,1,1]
[0,1,null,3,2,1,3,1,2,2,3]
[0,1,1,3,2,2,3,1,2,2,2]
[0,1,1,3,2,2,1,1,1,1,1]
[0,1,null,3,3,1,2,2,1,1,3]
[0,1,1,3,2,3,3,2,2,1,1]
[0,1,1,3,2,1,2,2,2,2,1]
[0,1,1,3,2,2,2,2,1,1,2]
[0,0,1,2,2,2,1,2,2,1,1]
[0,1,1,3,2,1,3,1,2,2,1]
[0,0,null,3,2,2,1,2,1,1,3]
[0,1,1,2,2,2,1,2,2,1,2]
[0,1,1,3,3,1,1,2,1,1,2]
[0,1,1,2,2,2,3,2,2,1,2]
[0,1,1,3,1,2,1,2,2,1,1]
[0,1,null,3,2,2,2,2,2,2,3]
[0,1,1,3,2,3,3,1,1,1,1]
[0,1,1,3,3,1,1,3,2,1,1]
[1,0,0,3,2,2,3,1,2,2,1]
[1,0,null,3,2,2,3,2,2,1,3]
[0,1,1,2,3,2,1,2,1,2,1]
[0,1,1,3,3,3,2,1,2,2,1]
[0,1,1,3,2,3,2,2,2,2,2]
[1,1,0,3,2,2,3,2,2,1,2]
[0,0,0,3,2,3,1,1,2,2,2]
[0,1,0,3,2,2,2,1,2,1,1]
[0,1,1,3,2,3,2,2,2,1,1]
[0,1,1,3,2,3,1,1,2,2,1]
[0,0,null,3,2,2,2,1,2,1,3]
[0,1,1,3,2,2,1,1,2,1,1]
[1,1,1,3,2,2,3,1,2,2,1]
[0,1,1,3,2,2,1,2,2,1,2]
[0,1,1,3,3,1,2,2,2,2,2]
[0,1,1,3,2,2,1,2,2,2,1]
[0,0,null,3,2,2,1,2,2,1,3]
[0,1,null,3,3,2,2,1,2,2,3]
[0,1,1,3,2,2,1,1,2,1,1]
[1,1,0,2,3,1,3,2,2,2,1]
[0,1,1,3,2,2,3,1,2,1,1]
[0,1,1,2,1,2,2,2,2,2,1]
[0,1,0,2,2,3,1,3,2,2,1]
[0,1,1,3,2,2,1,2,2,2,1]
[0,1,1,3,2,2,3,1,1,1,2]
[1,1,0,3,3,3,3,2,2,1,1]
[1,0,0,2,3,1,2,1,2,2,1]
[0,1,0,3,2,2,3,1,2,1,2]
[1,1,1,2,1,1,3,2,2,2,1]
[0,1,1,3,2,2,3,1,2,1,1]
[1,1,1,2,2,2,3,2,2,1,1]
[1,1,null,2,2,2,2,1,2,1,3]
[1,0,0,2,3,1,2,2,2,1,1]
[1,1,1,2,2,2,3,1,2,1,1]
[1,1,null,2,3,2,1,2,2,1,3]
[0,1,1,1,2,3,2,3,2,1,2]
[1,0,1,3,3,2,3,1,2,2,2]
[1,1,1,2,2,3,2,3,2,1,2]
[1,1,null,3,2,2,3,1,2,2,3]
[1,0,0,3,2,3,3,2,2,2,1]
[0,1,1,3,2,2,2,1,2,2,1]
[0,0,1,3,2,1,2,2,2,2,2]
[1,0,null,3,2,3,3,2,2,2,3]
[0,1,1,3,2,3,2,2,2,2,2]
[0,1,1,3,2,3,1,2,2,2,1]
[0,1,null,3,2,2,3,2,1,1,3]
[0,1,1,3,2,3,1,2,2,1,1]
[0,0,null,3,2,2,1,2,2,2,3]
[1,1,1,2,1,2,2,2,2,1,1]
[0,1,1,3,2,2,1,1,2,2,2]
[0,1,1,3,2,2,3,1,2,2,2]
[0,1,1,2,3,2,1,2,2,2,1]
[1,1,1,3,2,3,3,2,2,1,1]
[0,1,1,3,3,1,2,1,2,1,1]
[1,1,1,3,2,2,3,2,2,2,2]
[0,1,1,3,2,2,1,2,2,1,2]
[0,1,1,3,2,3,1,1,2,1,1]
[1,1,1,3,2,3,3,2,2,2,1]
[0,0,1,2,2,3,1,2,2,1,2]
[1,1,null,2,3,3,3,2,2,2,3]
[1,0,0,1,2,3,2,2,2,2,2]
[1,1,1,2,2,2,2,2,2,2,2]
[0,1,1,3,2,2,2,2,2,1,1]
[0,1,1,2,1,2,2,2,2,2,1]
[0,1,1,3,2,3,1,1,2,2,1]
[0,1,1,3,2,3,3,1,2,2,1]
[0,1,1,3,3,3,1,1,1,1,1]
[0,1,null,3,3,2,1,2,1,1,3]
[0,1,1,3,2,3,3,1,2,1,1]
[0,1,1,3,3,2,1,2,2,1,2]
[0,1,null,2,2,2,3,1,2,1,3]
[0,1,0,3,3,1,1,1,1,2,1]
[0,1,1,2,3,1,1,2,2,1,2]
[0,1,null,3,3,1,1,3,2,1,3]
[0,1,1,2,2,2,1,2,2,1,2]
[1,0,0,3,3,2,1,1,2,1,1]
[0,1,1,3,3,3,2,2,2,1,1]

{"sheet":"Define Variables","index":11,"n_rows":4,"n_cols":12,"rows_kept":4}
["Variable Label",{"$f":"Data!A1","v":"FRIENDLY"},{"$f":"Data!B1","v":"CIRCLEK"},{"$f":"Data!C1","v":"COMMUTE"},{"$f":"Data!D1","v":"BARGAIN"},{"$f":"Data!E1","v":"CASH"},{"$f":"Data!F1","v":"QUICK"},{"$f":"Data!G1","v":"KNOWME"},{"$f":"Data!H1","v":"HURRY"},{"$f":"Data!I1","v":"DWELL"},{"$f":"Data!J1","v":"GENDER"},{"$f":"Data!K1","v":"WORK"}]
["Description","Do you use Friendly Market regularly","Do you use Circle K regularly?","Do you pass by Friendly Market/Circle K corner to/from work?","I often shop for bargains.","I always pay cash.","I like quick, easy shopping.","I shop where they know my name.","I am always in a hurry.","Where do you live?","What is your gender?","What is your work status?"]
["Value Codes","0,1","0,1","0,1","1,2,3","1,2,3","1,2,3","1,2,3","1,2,3","1,2","1,2","1,2,3"]
["Value Labels","No,Yes","No,Yes","No,Yes","Disagree,Neutral,Agree","Disagree,Neutral,Agree","Disagree,Neutral,Agree","Disagree,Neutral,Agree","Disagree,Neutral,Agree","Own home,Rent","Male,Female","Full-time,Part-time,Retired/Do Not Work"]

{"sheet":"Description","index":12,"n_rows":10,"n_cols":3,"rows_kept":10}
[]
[null,null,"Friendly Market"]
[]
[null,null,"The Friendly Market dataset is associated with a case study at the end of Chapter 14 in  "]
[null,null,"Basic Marketing Research, 3rd edition, by Alvin Burns and Ronald Bush (Pearson, 2012).  "]
[null,null,"The case involves a mom-and-pop type of convenience store that hopes to compete with a chain "]
[null,null,"convenience store (e.g. Circle K) located across the street.  Friendly Market uses friendly service"]
[null,null,"as its marketing strategy.  The chapter involves correlation and cross-tabulation  (associations "]
[null,null,"analyses) and the dataset is comprised of mostly nominal variables, meaning that cross-tabulation "]
[null,null,"analysis should be applied. "]