BaronArt6383 Question  This week’s assignment is based on a questionnaire that…Question This week’s assignment is based on a questionnaire that was developed to select a summer magazine cover for a grocery store.  This week’s assignment is to prepare a tabplan – that is, a plan (or instructions) for developing cross-tabs (also called data tables) that will help us analyze the survey data collected. The tabplan should include all survey questions  and specify what banner breaks should be created for the particular topic. For statistical testing between banner breaks, breaks should be mutually exclusive and be complimentary (add up to 100% of the sample).In this case, we need to make a banner that will help this grocery store select a magazine cover. Some things to keep in mind about this grocery store and survey as you create your tabplan:- There are 2 different stores that might use this magazine cover (Sobeys,  FreshCo).- The grocery store is interested in understanding differences across regions: Western Canada, Ontario, Quebec, Atlantic Canada.  (Territories are excluded from analysis.)- There are 6 different magazine covers being evaluated (see JPEG images). – There are 4 different customer segments for these stores: A) 1-2 person households with income over $80k; B) 1-2 person households with income under $80k; C) 3+ person household with income over $100k; D) 3+ person household with income under $100k.For your tabplan, make  sure all the questions in the survey are listed in your tabplan.  Create one banner, based on your understanding of this store’s needs  Image transcription textI U ~ abs X2 X A ~ ~ A – Font Paragraph Summer Magazine PretestQ1.1 Thank you for agreeing to participate in this survey. We trulyappreciate your time and cooperation. At the completi… Show more… Show more Image transcription textlider 1 BlockEn.. 1 BlockSe… 1 BlockSta… 1 Dropdo… 1 Normal 1QDisplaynam… Styles Q1.5 Which of the following age groups doyou belong to? Less than 18 years old (1) 18-24 years o… Show more… Show more Image transcription textFont Paragraph End of Block: Contest Entry Start of Block:Shopping Habits and Stores Q4.3 Overall, at which onesupermarket or grocery store do you spend the most … Show more… Show more Image transcription textC AaBbCcl AaBbCCI AaBbCcI AaBbCcC AaBbCcD AaBbCCDAaBbCCD 1 BlockEn… 1 BlockSe… 1 BlockSta… 1 Dropdo… 1Normal 1 QDisplaynam… Styles Q6.1 SUMMER let’s t… Show more… Show more Image transcription textBI U~ abe X2 X A~ ary A E 1 Ba Font Paragraph Q6.4 On themagazine cover below, please click on the elements that you like,if any, and tell us why in the box below. SUMMER let’s … Show more… Show more Image transcription text06.6 On’ihe magazine cover below, please dick on the elementsthat you dislike, if any, and tel us in me box below. ” 06.7What do you dislike about this cover? … Show more Image transcription textI U ~ abe Xz X A A Font Paragraph Q6.8 On a scale from 1(strongly disagree) to 5 (strongly agree), please rate how muchyou agree with each statement: (1) Strongly (2) Some… Show more… Show more Image transcription text1 BlockEn… I BlockSe… 1 BlockSta… 1 Dropdo… 1 Normal 1QDisplaynam… Styles Q6.9 Based on this cover, how likely are youto shop at ${e://Field/Banner} during the summer time… Show more… Show more Image transcription textParagraph Styles Q14.2 Including yourself and any children, howmany people live in your household? 1 (1) … 10+(10) Q14.3 Howmany children under the age of 18 do you have living i… Show more… Show more BusinessBusiness – Other