115.109 Topic 7 Lab Worksheet: Comparing Means Latest due date: October 9 In this lab we return to the dataset used in Week 4 (the Countdown customer dataset) to investigate differences in mea There are two comparisons to consider: Importance ratings against Performance, and 'Old' store vs 'New' Store. Task 1: Generate means, standard deviations and sample sizes for importance and performance (both stores combined) Importance Mean Short label Question Quality Fresh Price Special Healthy Look Local Organic Season Range Unique Try Pleasant Attractive Organised Signed Smells Lighting Flooring Aisles Queues Location Parking Free park Hours Talk Know Service Slow Entertain Atmosphere Getting quality produce Getting fresh produce Getting a low price for produce Getting produce that is on special Getting healthy produce Getting produce that looks good Finding locally produced food Finding organically-produced food Finding food that is in season Finding a wide range of items Finding unique items Trying food on the spot Pleasant environment (eg temperature) Store is attractively designed Shop is well organised Aisles are well signed Store smells nice Good lighting Quality flooring Wide aisles Short queues at checkouts Convenient location Available parking Cheap / free parking Long hours of operation Talking to staff Friendly and knowledgeable staff Getting good customer service Slow pace of shopping Entertainment Having a lively atmosphere Performance Mean Importance Standard Deviation Community GoodTime Supporting the local community Having a good time Task 2: Generate means, standard deviations and sample sizes for 'Old Store Performance' and 'New Store Performance Old Store New Store Performance Performance Mean Mean Short label Question Quality Fresh Price Special Healthy Look Local Organic Season Range Unique Try Pleasant Attractive Organised Signed Smells Lighting Flooring Aisles Queues Location Parking Free park Hours Talk Know Service Slow Entertain Atmosphere Community GoodTime Getting quality produce Getting fresh produce Getting a low price for produce Getting produce that is on special Getting healthy produce Getting produce that looks good Finding locally produced food Finding organically-produced food Finding food that is in season Finding a wide range of items Finding unique items Trying food on the spot Pleasant environment (eg temperature) Store is attractively designed Shop is well organised Aisles are well signed Store smells nice Good lighting Quality flooring Wide aisles Short queues at checkouts Convenient location Available parking Cheap / free parking Long hours of operation Talking to staff Friendly and knowledgeable staff Getting good customer service Slow pace of shopping Entertainment Having a lively atmosphere Supporting the local community Having a good time Old Store Performance Standard Deviation Task 3: Use the Z formula to calculate whether there is a significant difference between the importance and performanc Bonus: complete for each of the measures above. (Hint: complete in one step: e.g. =(d10-e10) / SQRT(f10*f10/h10+g10*g1 Z x1 x2 2 1 2 2 s s n1 n2 Test: numerator (XX1-XX2) denominator Z Zc Imp-Perf 0 #DIV/0! #DIV/0! Conclusion: Task 4: Create a chart that compares the importance and performance means; and a separate chart that compares the O ataset) to investigate differences in means. e, and 'Old' store vs 'New' Store. d performance (both stores combined) as below. Performance Standard Importance Deviation Sample Size Performance Sample Size Hint: You completed the Importance measures in Lab 4. The dat copy the results here - or produce them again. You can construc CustomerData sheet and copy to here by pasting values only ('P 'transpose' (Paste Special: Transpose) to shift from a row orienta Alternatively you can complete the formulas here ormance' and 'New Store Performance' as below. New Store Performance Old Store New Store Standard Performance Performance Deviation Sample Size Sample Size Hint: Sort the data by Store (column C) and compute the descrip part of the dataset. tween the importance and performance means for Quality, and between the two store performance means for quality =(d10-e10) / SQRT(f10*f10/h10+g10*g10/i10) New-Old 0 #DIV/0! #DIV/0! First: decide on your null and alternate hypotheses: one or two tailed test? If two-tailed: Zc=+/- 1.96; if one-tailed: either +1.645 or -1.645 (depending on which varia Are you rejecting your null hypothesis or not? d a separate chart that compares the Old Store and New Store performance means easures in Lab 4. The data has not changed, so you can m again. You can construct your statistics in the by pasting values only ('Paste Special' Values) and then o shift from a row orientation to a column orientation. mulas here and compute the descriptive statistics separately for each o tailed test? 5 (depending on which variable you think should be bigger) Data Year 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 QUEST ID STORE SUBURB DayIOf Week Time Downing St Coding: 'NEW'= eg 01 'OLD'= Bentley Av A1 A2 A3 A4 A5 A6 A7 A8 B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B11 B12 B13 B14 B15 B16 B17 B18 B19 B D44 D45 D46 D47 D48 D49 D50 D51 NEW NEW NEW OLD OLD OLD OLD OLD NEW NEW NEW NEW NEW OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD NEW NEW NEW NEW NEW NEW NEW NEW NEW OLD OLD OLD OLD Browns Bay Forest Hill Beach Haven Glenfield Grafton Albany Pinhill Glenfield Northcote Glenfield Glenfield Glenfield Glenfield Oteha Albany Albany Albany Sunnynook Albany Sunnynook Sunnynook Glenfield Totara Vale Oteha Valley Glen Innes Albany Browns Bay Northcross Albany Glenfield Glenfield Pinehill glenfield northcote glenfield Forrest Hill 4 9am 4 9am 4 9am 4 9.am 4 9.am 4 9.am 4 9.am 4 9.am 6 10:05:00 6 10:00:00 6 11:40:00 6 12:00:00 6 12:55:00 6 11:35:00 6 11:45:00 6 12:15:00 6 12:56:00 6 12:30:00 6 11:18:00 6 11:58:00 6 12:13:00 6 12:25:00 6 12:45:00 6 10:30 6 10:41 6 10:41 6 11:10 6 11:22 2 0.822916667 2 0.745138889 2 0.675 2 0.689583333 7 0.4375 7 0.447916667 7 0.454861111 7 0.472222222 Q1 (Usual store) 1=Yes 0=No 0 0 1 1 1 0 1 1 1 1 1 1 1 0 1 0 0 1 1 1 0 1 0 0 0 0 1 0 0 1 0 0 1 1 1 1 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 D52 D53 D54 D55 D56 D57 D58 D59 D60 D61 D62 D63 E1 E2 E3 E4 E5 E6 E7 E8 E9 E10 H41 H42 H43 H44 H45 I43 I44 I45 I46 I47 I48 I49 I50 I51 I52 I53 I54 I55 I56 I57 I58 I59 I60 I61 OLD NEW NEW NEW NEW NEW OLD NEW NEW OLD OLD OLD NEW OLD NEW NEW NEW NEW NEW NEW NEW NEW OLD OLD NEW OLD NEW OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD Hillcrest Glenfield Bay View Birkdale Whangaparao Glenfield Glenfield Glefield Glefield Glefield Glefield Browns Bay Glenfield BeachHaven Bayview Glenfield Glenfield Forrest Hill Milford Forrest Hill Westmere Forrest Hill Glenfield Glenfield Glenfield Glenfield Glenfield Sunnynook Glenfield Glenfield Glenfield Unsworth Heights Totara Vale Glenfileld Glenfileld Glenfileld Glenfileld Glenfileld GLENFIELD GLENFIELD GLENFIELD 7 0.479166667 6 0.673611111 6 16.35 6 0.701388889 6 0.753472222 6 0.770833333 6 0.670138889 6 0.684027778 6 0.697916667 6 0.705555556 6 0.715277778 6 0.732638889 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 1 12.30pm-2.3 1 12.30pm-2.3 1 12.30pm-2.3 1 12.30pm-2.3 1 12.30pm-2.3 3 8:43 3 13:17 3 10:08 3 12:50 3 14:52 3 9:30 3 9:50 3 10:10 3 10:40 3 11:30 3 12:30 3 9:00 AM 3 9:10 AM 3 9:20 AM 3 9:30 AM 3 9:40 AM 3 9:00 3 9:15 3 9:25 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 0 1 0 1 1 1 1 0 1 0 1 0 1 0 1 0 1 1 1 1 1 1 1 0 1 0 1 1 1 1 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 I62 I63 J1 J2 J3 J4 J5 J6 J7 J8 J9 J10 J11 J12 J13 J14 J15 J16 J17 J18 J19 J20 J21 L41 L42 L43 L44 L45 L46 L47 L48 L49 L50 L51 L52 L53 L54 L55 L56 L57 L58 L59 L60 M1 M2 M3 OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW OLD OLD OLD GLENFIELD GLENFIELD Hillcrest Glenfield Northcross East Coast Bay Bay View Bay View Glenfield Glenfield Glenfield Beach Haven GLENFIELD GLENFIELD BIRKENHEAD PINEHILL MILFORD GLENFIELD 0 GLENFIELD PINEHILL BROWNS BAY GLENFIELD Birkenhead Albany Height Glenfield Birkenhead Glenfield Glenfield Glenfield Greenhithe Forest Hill Northcote poi Pakuranga Pinehill Pinehill Albany Glenfield Birkdale Glenfield Totata Vale Birkdale Browns Bay Hillcrest 3 3 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 5 5 5 9:35 9:50 9:20 9:30 9:15 9:00 9:10 12:50 13:10 14:15 15:00 15:10 12:59 13:05 13:15 13:45 14:25 13:10 13:18 13:25 14:03 14:10 13:15 13:27 13:40 14:06 14:25 1 1 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 1 1 1 0 0 1 0 0 1 1 1 1 1 1 0 1 0 1 1 0 1 0 1 1 0 0 1 1 1 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 M4 M5 M6 M7 M8 M9 M10 M11 M12 M13 O41 O42 O43 O44 O45 O46 O47 O48 O49 O50 OLD OLD OLD OLD OLD OLD OLD NEW NEW NEW OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD Albany Glenfield Northcote Forrest Hill Forrest Hill Seaview rd Whenuapai West Harbour Greenhithe Fairview heigh Browns Bay Glenfield Bayview Glenfield Glenfield Glenfield Glenfield Bayview Pinehill 5 5 5 5 5 5 5 5 5 5 4 4 4 4 4 4 4 4 4 4 4:30 4:38 4:48 6:15 6:20 4:40 4:50 4:55 5:15 5:23 0 0 1 0 0 0 1 1 0 0 1 1 1 1 0 0 1 1 1 0 Q2 Which Store Text Q2a (Often Q2b Long shop Q3 Often shop THERE) THERE shop HERE 1=Week 2=Month 3=Year 4=Rarely New World 1 More than 5 years 2 More than 1 year 3 More than 2 mnths 4 Only recently 1 1 1 2 1 2 2 Pak'n Save 1 2 Taiping Asian, 1 1 1 2 1 2 Pak'n Save 2 3 Pak'n Save Pak'n Save Pak'n Save Asian Grocery 2 1 2 2 1 1 1 2 Pak'n Save Pak n Save Al 1 1 2 2 Pak n Save Pak n Save 1 1 2 1 Q3b Long visit Q4 Choose here Location 1=Week 2=Month 3=Year 4=Rarely 1 More than 5 years 2 More than 1 year 3 More than 2 mnths 4 Only recently 4 4 1 1 1 4 2 1 2 2 2 2 2 4 1 2 4 3 2 2 4 2 4 4 3 2 1 2 4 1 2 4 1 1 1 1 1=Closest to home 2=Closest to work 3=Other loctnl reason 4=Like the company 5=Like store itself 6=Like shops around 2 2 2 1 2 2 4,5 2 1 1,4 2 2 1 1 4 2 3 4 2 2 2 4 3 2 4 2 2 2 2 2 2 2 2 3 3 4 2 3 4 4 1 3 2 1 1 1 1 1 1 2 1 1 1 2 2 2 1 5 3 1 1 1 4 3 1 3 3 1 2 5 5 Browns Bay 2 2 Albany 2 2 Browns Bay C 1 1 Hibre 2 1 Birkenhead 2 4 New World Mi 2 1 Countdown Ri 2 1 Pak n' save 1 2 Pak n' save 2 2 Pak n' save 1 2 nSave Wairau 1 1 1 1 3 1 5 5 rld Glenfield 1 1 2 4 1 1 1 1 2 4 1 1 1 1 1 2 3 1 2 1 1 4 2 4 2 4 3 4 1 4 1 3 2 1 1 2 2 1 1 2 1 2 2 1 1 1 2 2 2 4 2 4 1 3 2 4 1 1 1 1 1 3 2 1 1 1 2 4 1 4 2 4 2 2 1 4 2 2 3 1 2 2 3 1 2 2 1 2 2 2 4 1 2 1 1 2 5 1 1 2 6 1 1 1 1 1 2 3 1 2 1 1 3 2 3 5 3 1 1 1 2 1 1 1 1 1 1 1 1 1 1 5 5 1 5 5 Northcote Co Pak n' Save Countdown S Pak n' Save Al 1 1 1 4 1 2 2 1 2 3 1 1 1 1 2 2 2 4 1 2 2 4 4 4 2 2 1 2 1 PAKNSAVE ALBANY 2 2 1 2 New World Bi Albany Pak 'n' 1 2 2 1 New World 1 3 ParknSave 2 2 Parksave Alba 3 3 Birkdale Cou 1 1 ParknSave Browns Bay 2 2 3 2 2 4 2 Pak n Save Pak n Save Countdown Br Pak n Save, W PAKNSAVE BIRKENHEAD PAKNSAVE 1 1 2 2 3 4 1 1 2 1 2 2 1 2 4 4 4 2 1 1 4 1 1 4 4 1 1 1 1 1 2 4 1 4 2 2 3 1 3 1 4 4 3 3 4 2 2 1 1 1 2 4 2 2 4 1 1 1 2 2 4 3 1 1 2 2 4 2 2 3 4 1 2 2 2 2 4 4 2 3 1 2 3 1 2 2 3 4 3 1 1 1 5 5 1 1 2 3 1 1 2 1 1 1 1 4 3 3 3 1 5 1 2 3 1 3 2 1 1 1 1 1 2 6 2 1 1 1 1 1 3 1 4 3 1 Albany Pak n Save 2 2 Pak n Save Pak n Save Pak n Save 2 2 2 Pak n Save Pak n Save 2 1 4 4 1 4 3 3 1 2 4 4 Pak n save Pakn Save 1 1 2 2 Pakn save Pak n save; N 1 1 3 3 4 4 2 2 3 4 2 2 4 1 1 1 1 1 2 1 2 1 1 3 4 1 1 4 5 2 1 2 3 3 3 2 1 2 2 1 2 1 2 4 1 1 1 1 2 1 1 1 1 6 Q4 Other Reason Free text for "Other locational reason" Q5 Visit Q5 shops Q4 Other other shops text Shops Free text for 1=Yes (enter text) "Like the shops 0=No around" Playing tennis at Glenfield like the company because if Onecard Closet to school Passing by Passing by Passing by close to friends house close to family pick up kids from swimming Q7 Work Suburb (enter text) 0 Auckland City 0 1 will browse around lots of 0 Glenfield 0 Auckland city 1 2 dollar shop Albany 1 Greenhithe 1 Farmers Auckland city 1 Farmers 1 The Warehouse 1 The Warehouse 1 The Warehouse 1 The Warehouse 0 0 0 0 0 1 The Warehouse 2 Glenfield 2 2 Glenfield 1 The Body ShopMairangi Bay 1 Farmers 1 Hallenstiens 0 Asian Grocery Stores 0 Farmers 0 The WarehousCity CBD 1 The WarehousAlbany 1 The Warehouse Henderson 1 The WarehousAlbany 0 City 0 0 0 0 Q8 Get Here Q9 Age 1=Car 2=Bus 3=On foot 4=Other 1=16-19 2=2029 3=30-39 4=40-49 5=5059 6=60-69 7=70 plus 1 1 1 1 1 1 1 3 1 3 2 3 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 5 2 3 3 2 5 2 3 6 7 6 5 7 2 2 1 2 2 3 4 2 2 2 2 1 2 2 2 3 3 3 4 3 2 2 4 visiting another shop near b visitng family Closets to gym On way to friends Going to family lunch N N N Y N Y 1 KFC 0 0 0 0 0 0 Glenfield 0 1 The WarehousForest Hill 0 Browns Bay 1 The Warehouse 0 Glenfield 1 1 1 1 Glenfield 1 1 bank 0 Glenfield 1 Muffin Break 0 1 Hallensteins, Birkenhead 0 Glenfield 0 Albany 0 Auckland City 0 Westmere 0 0 1 Ware House 0 0 0 Glenfield Subway Health 3000, Body Shop 0 Auckland central 0 Glenfield 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 2 1 1 1 2 1 2 2 3 2 2 4 4 3 4 2 4 4 2 3 3 5 2 7 4 6 7 2 2 1 5 4 7 3 2 4 5 3 4 6 6 5 6 7 5 3 6 7 7 3 2 5 Passing through CONVIENT AT TIME ALBANY WAS IN THE AREA AFTER SWIMMING On way home + looking in sh Working in mall 0 0 0 Hillcrest 1 Farmers Glenfield 0 Northcross 0 East Coast Bay 0 Bay View 0 Bay View 0 Glenfield 1 Health Shop, Glenfield 1 Muffin Break Glenfield 1 Farmers, War Beach Haven 0 GLENFIELD 0 GLENFIELD 0 BIRKENHEAD 1 ALBANY PAKNPINEHILL 1 COTTON ON MILFORD 0 GLENFIELD 0 1 JAPANESE STOGLENFIELD 0 PINEHILL 0 BROWNS BAY 1 GLENFIELD 1 Glassons, Cot Birkenhead 0 Albany Height 0 Glenfield 0 Birkenhead 0 Glenfield 0 Glenfield 1 Hannahs, Far Glenfield 1 Glassons, Cot Greenhithe 1 Cotton on, fooForest Hill 0 Northcote poi 0 Parunrang 0 Pinehill 0 Pinehill 1 Dahua, AlbantAlbany 0 Glenfield 0 Birkdale 0 Glenfield 0 Totata Vale 0 Birkdale 0 Browns Bay 0 Hillcrest 0 0 Takapuna 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 3 1 1 3 1 1 1 1 1 1 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 3 1 3 1 2 3 3 2 7 6 3 2 2 1 2 2 1 2 2 2 2 2 1 4 7 5 6 4 7 1 2 2 2 2 2 2 3 2 2 2 3 3 3 3 2 Food court The whole mal Glenfield Was in area Was passing bFarmers Good car park 0 Albany 0 0 Glenfield city 1 Northcote City 1 Forrest Hill 0 Forrest Hill Glenfield 0 Seaview rd 0 Whenuapai Glenfield 0 West HarbourAlbany 1 Greenhithe 0 Fairview heigh 0 Browns Bay 0 Glenfield 0 Bayview 0 Glenfield 1 Coffee shop,haGlenfield 1 Warehouse Glenfield 0 Glenfield 1 Warehouse K Bayview 1 Clothes shopsPinehill 1 2 1 1 1 3 1 1 1 1 1 1 1 1 1 1 3 3 4 1 3 2 3 3 2 2 4 4 2 4 4 2 2 3 2 4 2 1 7 2 Q10 Gender Imp_Quality Imp_Fresh 1=Male 2=Female 1=Not important 4=Neutral 7=Very important 2 3 1 1 2 1 1 2 2 2 2 2 2 2 2 2 1 1 2 2 1 2 2 1 1 1 2 2 2 2 2 2 2 2 2 2 Imp_Price 1=Not important 4=Neutral 7=Very important 7 6 7 7 7 7 7 6 7 7 7 5 7 5 5 4 7 7 3 3 6 7 6 6 7 5 5 Imp_Special Imp_Healthy Imp_Look 1=Not important 4=Neutral 7=Very important 7 6 7 7 6 7 7 6 7 7 7 5 7 5 5 4 7 5 5 7 6 6 6 7 7 5 7 1=Not important 4=Neutral 7=Very important 5 6 6 5 7 7 7 5 7 7 7 5 6 5 5 4 7 4 2 7 7 3 4 5 5 4 5 1=Not important 4=Neutral 7=Very important 5 7 6 5 7 6 6 5 7 7 7 5 7 4 4 4 7 5 3 7 7 6 4 7 5 5 6 1=Not important 4=Neutral 7=Very important 6 6 7 7 7 7 7 7 7 7 7 5 7 5 6 5 7 4 4 7 7 5 6 6 6 6 7 6 5 7 4 6 6 6 4 7 7 7 5 7 6 7 3 7 5 4 6 7 4 5 7 5 4 7 6 6 7 7 7 7 5 5 6 6 4 5 4 5 5 6 6 6 4 5 4 5 6 6 6 6 5 4 4 5 6 6 6 6 4 4 4 5 6 5 6 6 3 4 4 4 6 6 4 5 2 4 4 4 1 2 1 2 1 2 2 2 2 2 2 2 1 1 2 2 2 2 1 1 1 1 2 2 1 2 1 1 2 2 1 2 2 1 2 2 1 2 1 2 1 2 1 1 2 1 5 4 4 5 7 5 6 5 7 6 5 5 5 5 5 6 6 4 7 7 7 7 6 7 6 7 4 5 3 3 5 5 6 6 6 6 7 7 5 6 6 6 5 6 7 7 5 6 4 5 4 4 7 5 7 5 5 6 6 6 6 6 6 7 6 7 7 7 6 7 6 7 4 5 3 4 6 4 6 6 6 6 7 7 4 5 5 5 5 5 7 6 5 5 5 6 7 6 6 5 6 6 5 5 3 3 4 4 2 7 7 7 7 7 5 6 6 2 7 4 4 2 4 4 6 6 6 6 7 6 4 5 5 4 5 6 6 6 5 4 4 3 3 3 4 4 5 7 4 5 4 4 5 5 2 7 6 7 7 7 4 5 6 2 7 3 5 2 1 2 6 6 6 5 7 6 4 5 5 5 5 7 6 6 4 3 5 4 3 3 5 5 6 6 5 6 6 6 6 6 6 7 5 7 7 7 5 7 6 7 4 3 4 3 5 4 6 6 6 4 7 7 5 6 6 5 4 6 6 5 4 3 2 6 4 4 4 4 7 7 7 4 5 4 5 5 6 7 4 7 7 7 3 5 5 4 7 4 4 4 2 5 6 6 6 5 7 7 6 6 7 5 4 6 6 7 2 2 2 2 2 1 2 2 1 2 2 2 2 1 2 1 2 2 2 2 2 2 1 2 2 2 1 2 2 2 2 1 2 2 2 2 2 11 2 1 2 1 1 1 2 1 5 7 6 7 4 5 7 6 7 6 4 6 6 6 7 6 6 6 5 7 7 7 6 7 6 7 5 6 7 5 7 7 4 6 6 6 7 6 6 6 6 7 7 6 5 4 6 7 3 4 5 5 7 7 2 6 7 7 7 6 6 5 5 6 7 7 5 7 6 7 5 6 5 3 7 4 1 6 7 6 7 7 5 5 5 7 2 6 6 7 5 7 5 6 5 6 7 7 5 6 6 6 7 7 6 5 6 5 4 6 7 3 6 5 6 7 5 7 6 6 1 7 4 5 7 5 6 5 5 7 5 5 7 7 4 3 6 6 7 7 7 7 7 7 7 5 5 7 7 5 6 4 5 5 4 6 7 6 6 6 6 7 7 7 7 7 7 7 5 5 7 6 6 6 5 6 5 4 6 7 6 6 6 6 7 2 7 5 7 6 7 5 5 7 5 6 6 5 5 5 4 6 5 5 6 5 6 7 4 7 7 6 7 6 5 4 7 6 7 5 5 5 5 3 6 5 5 6 5 6 7 7 7 7 7 7 7 5 4 6 5 7 6 4 5 5 3 6 7 6 5 6 5 7 7 7 7 7 6 7 5 4 6 5 6 5 3 6 5 4 6 7 6 5 6 6 2 2 2 2 2 2 2 1 2 2 2 2 2 2 2 2 2 2 1 2 5 5 7 6 4 7 4 7 7 7 6 4 6 6 4 7 7 5 6 6 5 5 7 6 3 7 3 7 7 7 7 4 6 6 4 7 7 5 6 5 5 6 6 5 5 5 5 7 7 7 6 6 5 6 6 7 3 6 6 6 4 6 6 5 3 6 5 7 7 6 3 6 5 5 5 7 2 6 6 7 5 6 7 5 4 4 6 7 7 7 4 4 6 4 4 3 2 6 6 4 6 7 4 4 4 3 3 7 7 6 3 4 4 3 3 4 4 5 5 5 5.837837838 5.891891892 5.445945946 5.277027027 5.601351351 5.310810811 Imp_Local Imp_Organic Imp_Season Imp_Range 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 7 3 7 5 5 6 6 4 7 4 4 4 7 3 4 4 7 6 4 6 1 2 4 6 7 5 6 1=Not important 4=Neutral 7=Very important 2 2 6 6 6 5 6 5 7 7 7 3 7 7 3 5 5 5 5 6 1 2 5 6 7 5 5 1=Not important 4=Neutral 7=Very important 7 3 6 5 6 6 6 6 7 7 7 5 7 4 5 3 5 4 5 6 1 3 6 6 4 5 6 Imp_Pleasan t Imp_Unique Imp_Try 1=Not important 4=Neutral 7=Very important 5 4 7 6 6 6 6 5 7 7 7 5 7 4 6 4 5 5 2 7 6 6 7 7 5 6 6 1=Not important 4=Neutral 7=Very important 4 2 5 4 5 6 6 4 4 7 4 4 4 4 5 6 5 6 2 5 1 6 5 6 4 4 4 1=Not important 4=Neutral 7=Very important 5 2 4 4 6 5 5 5 1 4 1 6 4 4 6 3 3 7 3 5 1 2 6 6 2 5 4 6 6 4 6 6 6 7 4 7 6 7 6 7 7 4 4 3 5 4 6 5 3 7 7 6 5 6 3 6 7 7 4 4 6 2 6 1 5 5 3 2 4 2 1 1 2 5 3 4 4 5 6 1 2 4 5 4 5 5 5 5 6 5 5 4 5 2 4 4 5 4 3 5 5 1 1 3 1 3 3 5 5 3 6 5 4 5 5 5 3 4 2 3 7 3 4 3 3 7 5 2 3 2 2 2 2 5 7 3 7 7 7 3 6 5 7 4 3 4 2 3 3 6 6 6 5 7 6 5 5 6 5 5 6 7 7 4 4 4 5 3 3 2 4 7 4 4 4 2 2 3 3 5 2 3 7 7 2 4 7 5 7 4 4 4 4 5 3 6 6 6 6 7 7 6 5 6 6 6 6 5 4 5 4 4 3 4 5 2 3 7 6 6 4 3 3 4 4 6 7 5 7 7 6 5 7 6 7 4 5 4 4 4 3 6 6 6 5 7 7 6 5 7 6 5 7 6 7 5 5 4 3 3 4 6 4 7 7 4 7 4 4 4 4 5 7 5 7 7 6 5 6 5 6 7 3 5 3 4 4 6 6 6 6 7 7 7 6 6 5 4 5 5 6 5 4 3 3 6 5 4 4 5 1 4 5 5 4 4 3 5 6 3 7 7 4 4 5 5 4 3 5 3 1 4 2 7 6 6 4 7 7 6 6 6 6 1 6 5 6 4 2 5 4 4 3 1 3 1 1 3 2 5 5 5 2 4 6 1 7 7 6 2 4 4 4 3 1 5 1 1 2 5 4 5 3 4 4 5 6 6 6 2 6 5 5 5 5 4 5 5 4 4 3 6 4 3 4 3 3 3 3 5 7 6 6 7 6 5 4 5 5 4 3 5 3 1 4 6 3 6 4 7 6 6 5 7 6 5 5 6 6 7 5 6 6 4 4 5 4 5 7 1 1 3 5 6 6 5 3 6 6 4 5 6 5 5 6 5 6 6 6 2 7 1 1 3 5 5 6 5 3 4 7 5 6 5 5 4 7 5 5 5 4 7 7 5 3 5 5 6 7 6 5 5 7 7 6 5 6 6 6 5 7 5 5 7 7 3 7 5 5 7 5 5 7 6 6 5 7 6 4 6 5 4 6 3 2 4 4 5 3 3 6 5 7 5 4 5 7 5 5 5 3 7 1 3 4 3 2 2 7 1 1 3 6 6 6 2 5 4 5 2 5 6 3 6 7 4 5 5 4 7 7 3 1 5 6 7 6 3 4 6 6 6 7 4 6 6 7 5 6 6 5 4 6 7 4 3 1 2 1 3 4 5 4 5 6 4 4 6 7 5 6 6 5 7 4 1 5 2 1 1 2 1 3 3 6 4 4 4 4 3 6 7 4 5 6 5 5 6 7 7 4 7 6 5 1 5 6 4 5 3 5 4 4 5 7 4 5 6 5 7 6 6 7 6 7 6 5 1 6 6 5 5 5 6 5 3 7 7 6 5 7 6 2 6 4 5 6 1 1 2 1 3 6 7 3 4 5 4 4 4 4 3 6 4 5 6 1 1 2 4 2 1 6 6 2 4 5 3 5 4 4 3 4 5 4 5 5 5 6 6 6 7 6 5 5 5 5 4 6 6 4 4 4 5 4 4 7 5 6 4 4 6 6 4 4 4 4 4 7 6 6 5 4 6 5 3 6 6 6 5 6 6 6 4 4 4 4 5 7 6 6 4 2 5 4 3 5 5 6 7 6 6 6 5 5 5 5 5 7 7 6 4 2 4 3 4 2 7 5 5 6 7 6 5 6 4 4 3 7 7 7 4 2 3 3 3 7 6 6 4 7 5 5 3 3 3 3 2 7 4 5 2 2 3 3 3 1 5 5 5 7 3 6 3 4 3 4 3 2 7 7 2 3 3 4 3 4 4 4 3 5 5 6 4 5 5 4 4 7 6 6 2 5 4 4 3 5 6 4 5 6 4.668918919 4.560810811 5.148648649 5.459459459 4.358108108 3.797297297 5.027027027 Imp_Attracti Imp_Organis ve ed Imp_Signed Imp_Smells Imp_Lighting Imp_Flooring Imp_Aisles 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 6 6 4 5 6 6 6 5 7 1 7 4 7 4 6 5 6 4 3 5 5 5 5 6 7 6 5 1=Not important 4=Neutral 7=Very important 6 6 4 6 6 7 7 6 7 7 7 6 7 4 7 6 4 5 6 6 5 7 7 6 6 6 6 1=Not important 4=Neutral 7=Very important 6 7 7 6 6 6 6 5 7 7 7 6 7 4 4 5 6 6 3 6 7 4 6 6 7 7 6 1=Not important 4=Neutral 7=Very important 5 7 6 4 5 6 4 5 7 7 7 6 7 3 5 4 6 5 6 5 7 7 5 7 7 5 6 1=Not important 4=Neutral 7=Very important 5 5 7 5 6 6 6 4 7 7 7 6 7 7 6 3 6 6 6 6 7 5 5 6 7 6 7 1=Not important 4=Neutral 7=Very important 4 3 7 5 6 5 5 5 7 7 7 6 7 7 4 4 6 5 3 6 7 3 5 6 7 5 7 5 4 7 5 6 6 5 5 7 7 7 6 7 6 5 5 6 6 3 5 7 5 6 6 7 4 5 5 6 7 4 6 6 6 6 5 5 5 4 5 5 5 7 5 6 5 3 4 5 3 7 6 7 6 3 4 5 4 5 6 5 6 6 5 3 4 6 6 6 6 6 5 3 4 5 4 5 4 6 4 5 5 6 6 5 5 5 5 5 5 5 7 5 5 4 4 5 4 5 5 5 5 4 4 4 6 5 7 5 6 7 6 4 4 5 5 3 5 6 3 3 6 6 6 6 4 7 6 5 5 6 6 5 5 5 7 5 3 4 5 5 5 5 5 7 6 5 6 5 5 5 5 6 7 7 6 7 6 6 6 5 5 4 5 6 4 5 6 6 6 6 5 7 6 6 5 6 5 6 4 6 6 6 6 4 6 6 5 7 6 7 7 6 5 4 3 3 2 3 7 7 7 7 7 6 6 5 5 4 3 6 2 4 3 6 6 6 6 7 6 5 6 6 5 5 4 6 6 5 4 3 6 5 6 5 5 7 6 5 6 4 4 4 5 6 6 6 7 7 6 5 5 4 4 3 6 7 5 3 5 6 6 6 6 7 6 5 5 7 7 5 5 5 5 4 5 3 3 4 5 4 5 7 5 5 4 3 6 5 3 4 7 7 6 7 6 5 5 4 4 4 6 7 4 4 6 6 6 6 6 7 6 5 5 6 5 6 3 7 5 4 2 5 4 3 3 4 5 4 2 5 4 3 3 3 2 5 6 5 6 7 6 4 4 4 4 4 6 5 3 4 6 6 6 6 6 7 7 5 5 7 5 5 4 5 5 5 3 3 3 4 7 5 6 7 6 5 5 5 4 4 4 5 7 6 6 7 7 4 4 4 4 4 5 4 4 4 5 6 6 6 6 7 7 6 5 6 5 6 5 4 6 6 5 6 7 3 6 5 4 7 7 5 3 5 6 6 6 4 4 5 7 1 5 5 6 6 7 6 7 5 6 6 7 5 6 5 6 7 6 6 5 5 6 6 7 4 6 6 7 6 5 5 7 6 7 5 7 5 6 7 6 6 5 5 7 6 7 4 4 6 7 3 5 5 4 7 7 3 3 5 6 6 6 5 4 5 7 7 7 4 4 6 7 4 4 4 5 6 7 5 4 5 6 7 7 5 4 6 7 4 6 4 4 6 7 4 4 4 3 6 7 5 1 5 5 7 7 3 4 6 6 5 6 3 4 6 7 3 3 4 5 6 7 6 6 5 5 6 6 4 5 5 6 1 6 5 6 5 4 4 4 3 4 4 5 5 6 4 2 4 4 3 5 5 4 5 5 5 4 4 7 4 6 6 5 6 6 7 7 6 4 3 4 4 3 4 7 4 4 5 5 4 7 7 6 6 6 5 4 6 7 7 6 5 7 4 4 4 7 4 4 5 5 5 4 7 6 5 6 6 6 4 6 7 7 7 5 5 4 5 4 5 5 4 6 5 5 3 2 5 3 6 6 6 6 6 5 7 6 5 6 4 5 4 7 4 4 6 4 5 3 2 5 3 6 5 6 4 5 5 6 6 4 6 4 5 3 6 5 4 6 4 4 3 2 5 4 5 6 5 7 6 5 6 6 5 6 4 4 3 5 6 4 4 5 5 3 4 5 4 6 5 6 5 6 4 5 4 4 4 5 5 5 3 5 4 4 4 3 3 4 4 7 6 6 5 6 4 4 4 7 7 6 3 6 4 5 5 6 7 6 5 5 6 7 3 4 4 4 4 6 7 6 4 6 3 5 3 2 4 6 6 4 6 6 5 5 5 4 4 7 5 7 2 3 7 3 3 7 6 6 7 4 6 5 5 5 5 5 5 7 5 6 3 3 7 4 3 4 5 6 5 5 5 5 5 5 5 4 4 4 2 5 3 4 7 4 4 6 2 5 4 6 6 5 5 5 5 3 4 6 3 7 3 5 7 4 6 5 4 6 5 7 4.966216216 5.560810811 5.459459459 5.277027027 5.263513514 4.837837838 5.168918919 Imp_Locatio Imp_FreePar Imp_Queues n Imp_Parking k Imp_Hours 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 6 5 7 6 6 4 4 6 7 7 7 6 7 6 3 4 6 5 4 6 7 7 6 6 7 3 5 1=Not important 4=Neutral 7=Very important 7 4 7 6 6 6 6 6 4 7 7 6 7 4 5 3 6 5 5 5 7 7 7 7 5 5 6 1=Not important 4=Neutral 7=Very important 7 6 7 6 7 7 7 5 7 7 7 6 7 7 6 4 6 6 4 7 7 6 7 6 6 6 7 Imp_Talk 1=Not important 4=Neutral 7=Very important 7 6 7 6 7 7 7 4 7 7 7 6 7 7 7 3 6 5 3 6 7 7 7 7 7 5 7 Imp_Know 1=Not important 4=Neutral 7=Very important 6 6 7 6 4 4 4 4 4 4 4 5 4 7 5 2 6 5 2 7 7 3 7 6 6 5 7 1=Not important 4=Neutral 7=Very important 5 4 7 5 5 6 6 4 4 4 4 5 4 6 4 4 6 4 6 5 2 1 4 6 5 3 7 5 5 7 4 5 6 6 5 5 7 7 5 7 5 6 4 6 5 4 6 4 6 7 7 6 6 6 7 7 7 7 5 5 6 6 6 7 5 6 5 4 5 7 6 7 6 6 6 4 4 7 6 7 7 6 5 3 4 7 6 7 7 6 5 4 4 7 6 7 5 5 7 3 2 3 2 4 4 5 5 4 2 5 6 5 5 5 5 3 3 5 6 4 5 5 6 6 6 7 7 6 6 6 6 6 6 6 7 7 7 7 7 5 5 5 5 6 6 7 3 4 7 6 6 6 6 7 7 6 6 7 6 5 4 5 5 3 4 5 3 3 4 6 6 7 7 6 7 5 4 5 5 3 7 7 7 7 7 7 7 5 7 6 6 5 1 4 7 6 6 7 6 7 7 6 6 6 7 7 4 4 5 5 4 5 5 6 2 6 6 7 7 6 6 5 5 5 5 3 7 7 7 7 7 7 7 6 7 6 6 3 3 5 7 6 6 7 6 7 7 6 7 7 5 5 5 4 6 5 2 5 4 4 5 6 5 7 7 6 5 6 5 6 6 3 7 7 7 7 7 7 7 6 7 6 6 4 5 5 7 6 6 7 6 7 7 6 7 7 5 5 6 6 5 4 6 4 4 3 4 5 6 7 6 5 7 4 6 4 5 4 7 7 7 7 7 6 7 5 4 7 4 5 3 3 5 5 6 5 6 7 6 6 7 5 5 5 5 4 7 4 5 5 4 3 7 6 7 6 7 6 7 5 5 4 3 3 7 5 7 7 3 4 6 4 3 5 5 7 3 4 4 5 4 2 3 7 5 3 7 5 6 5 5 3 6 5 5 3 4 2 5 6 7 7 7 7 7 4 4 4 3 3 7 6 5 7 5 5 5 4 4 5 5 7 4 4 4 5 7 2 4 7 5 5 7 5 6 5 5 5 6 5 6 7 7 6 7 5 7 7 7 7 7 6 5 7 7 3 5 4 6 7 7 5 7 6 7 5 7 6 7 7 7 5 7 6 5 7 6 5 5 6 7 7 7 3 6 7 7 6 7 6 7 7 7 7 7 6 6 7 5 6 5 6 7 7 7 6 5 7 7 5 7 7 4 7 7 7 7 7 7 7 5 7 6 6 6 7 7 2 7 7 7 6 5 5 5 5 7 5 7 5 7 7 5 5 6 6 7 7 7 5 6 5 7 4 3 4 6 5 7 5 3 3 6 5 6 3 5 5 7 6 6 4 7 6 7 4 6 4 6 5 7 7 7 6 6 6 6 4 5 6 7 7 6 5 6 5 4 3 5 5 4 7 7 7 7 7 7 6 7 6 6 7 4 3 6 4 3 4 7 6 6 6 7 3 6 7 6 7 7 7 6 7 6 5 5 4 6 6 5 5 4 7 6 6 5 6 6 7 7 7 7 7 2 6 7 6 6 6 5 6 6 5 5 6 7 6 5 5 5 6 7 7 7 7 7 2 6 7 6 5 5 5 6 7 5 5 6 5 6 5 5 5 5 7 6 5 7 7 2 6 7 6 7 5 5 5 6 5 5 6 5 6 5 5 5 5 2 5 6 4 3 7 2 4 3 6 6 6 4 6 4 4 6 6 5 5 5 6 5 6 6 6 7 5 7 2 4 5 5 6 6 4 5 5 4 6 6 6 5 6 6 5 7 6 6 5 6 4 7 7 7 6 6 4 5 6 2 5 3 6 4 6 7 5 7 5 6 5 7 7 7 6 6 5 5 6 3 1 6 4 5 6 4 6 4 6 6 5 7 7 7 6 4 5 6 6 7 6 5 6 6 6 4 6 5 7 7 5 7 7 6 6 5 3 7 4 4 7 5 6 4 6 6 6 6 7 7 4 5 7 5 4 4 3 6 3 1 4 6 5 3 6 5 4 4 6 4 3 1 5 1 3 2 3 4 3 5 6 6 6 3 5 6 4 5 6 4 3 6 6 6 3 3 5 4 3 6 3 7 4 3 5.77027027 5.743243243 5.952702703 5.932432432 5.337837838 4.689189189 5.256756757 Imp_Entertai Imp_Atmosp Imp_Commu Imp_GoodTi Store_Qualit n here nity me y Imp_Service Imp_Slow 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 4 7 7 6 6 7 6 4 7 7 3 5 7 7 5 4 6 5 4 6 7 7 6 6 7 5 6 1=Not important 4=Neutral 7=Very important 4 5 7 4 6 6 5 5 1 7 7 4 7 4 4 4 7 6 5 6 2 4 5 6 6 5 6 1=Not important 4=Neutral 7=Very important 2 4 4 4 5 6 5 6 5 7 1 5 7 2 5 5 7 4 5 4 1 2 5 4 2 6 5 1=Not important 4=Neutral 7=Very important 5 4 6 6 6 6 6 5 1 7 7 3 4 4 6 4 6 5 2 4 1 3 6 5 5 6 6 1=Not important 4=Neutral 7=Very important 6 3 5 5 5 6 6 4 5 7 6 5 5 4 5 3 6 6 3 5 1 1 6 6 6 6 5 1=Poor performance 4=Neutral 7=Good performance 4 7 6 6 6 5 6 4 7 7 7 5 7 4 4 5 6 5 4 6 1 4 6 6 7 2 6 6 4 6 6 6 6 6 5 6 6 6 4 6 6 5 5 6 6 4 3 3 5 6 6 5 5 6 7 4 7 3 3 7 6 5 6 5 6 6 5 5 3 5 5 4 3 6 5 5 3 2 5 2 4 3 6 5 5 2 6 2 2 5 5 6 4 5 5 5 6 4 4 6 5 5 4 4 2 5 4 6 4 5 6 6 6 5 4 5 5 5 3 4 4 3 6 6 5 7 7 7 7 4 4 5 4 5 7 7 6 7 6 5 5 4 5 5 6 5 4 4 4 5 7 2 5 7 5 6 7 5 7 5 6 5 4 5 5 4 4 5 2 4 4 4 1 5 1 3 3 5 3 4 3 5 7 7 4 4 4 4 3 3 5 5 3 4 5 5 7 3 4 7 6 3 5 5 6 5 4 6 5 5 3 3 3 5 4 4 4 4 4 3 1 5 3 3 4 3 4 6 5 7 4 4 3 4 3 3 5 5 1 3 5 4 6 1 3 7 6 4 5 5 6 5 4 5 4 6 6 5 5 4 6 3 5 4 6 3 1 5 3 4 3 3 3 6 5 7 4 4 3 4 3 3 5 6 3 3 6 5 4 2 3 7 6 5 7 5 6 5 5 4 4 5 3 2 6 5 5 5 2 6 4 5 7 5 3 4 4 1 7 5 5 7 4 4 3 4 7 3 5 3 1 2 6 2 4 3 3 7 6 6 7 5 6 5 5 7 5 4 4 4 3 4 2 3 2 5 2 2 1 5 3 3 4 3 7 5 5 7 4 3 3 4 2 3 4 6 2 2 5 5 6 6 5 7 6 6 7 5 6 5 6 7 5 4 5 4 4 6 7 5 6 6 5 6 5 2 6 7 3 6 6 7 6 7 4 4 6 3 6 3 4 6 5 5 5 5 5 5 6 5 5 6 6 6 3 7 6 7 5 6 5 6 7 7 7 7 6 6 7 6 5 5 6 7 7 7 4 5 5 7 4 4 4 3 5 4 3 5 6 6 5 5 3 5 5 6 5 5 3 2 6 5 6 6 4 3 5 2 1 2 7 6 6 5 4 5 4 5 2 5 3 4 4 6 5 5 3 4 5 7 1 2 7 6 6 5 4 5 5 6 5 5 6 7 6 7 4 6 4 5 7 6 1 7 7 6 6 7 5 5 5 6 4 5 6 6 6 7 6 7 4 4 5 7 4 1 7 7 5 7 4 4 6 7 4 6 6 4 4 3 3 5 5 6 6 6 7 6 7 2 4 2 2 3 4 4 7 2 1 3 5 6 4 6 5 4 3 4 5 4 5 6 5 5 4 5 4 6 5 6 4 6 5 4 5 4 6 5 4 3 4 5 3 6 5 6 2 2 5 4 6 4 5 4 6 4 5 6 4 6 5 4 3 4 5 3 6 4 6 4 1 4 7 3 6 7 4 4 5 6 6 5 6 5 4 3 4 5 3 7 5 6 3 3 4 3 3 5 7 4 6 4 5 6 5 6 5 6 4 6 5 5 6 6 6 5 6 5 4 6 5 5 4 3 6 4 5 6 6 4 5 4 7 5 4 4 6 5 6 2 4 7 6 4 5 5 7 6 7 7 6 6 7 5 7 6 5 5 5 5 6 5 4 5 4 4 6 7 6 5 3 5 5 3 5 2 7 6 3 6 6 5 4 4 4 4 1 4 7 5 3 4 4 3 4 7 5 5 4 4 5 4 5 4 4 3 4 3 4 2 2 4 2 3 5 5 5 7 5 5 6 5 4 5 4 4 1 3 3 3 4 5 3 3 3 5 6 3 5 5 5 4 4 4 4 4 7 6 6 3 4 5 3 3 2 6 6 5 6 5 6 6 5 4 5 4 1 2 4 4 5 6 4 5 6 7 7 6 5 5.43537415 4.513513514 4.277027027 4.445945946 4.797297297 4.844594595 6 6 6 6 5 6 4 7 6 5 Store_Specia Store_Health Store_Fresh Store_Price l y Store_Look 1=Poor performance 4=Neutral 7=Good performance 1=Poor performance 4=Neutral 7=Good performance 6 4 5 6 6 6 6 5 6 6 6 4 6 5 6 4 5 5 5 7 3 5 6 5 5 5 6 1=Poor performance 4=Neutral 7=Good performance 5 4 3 4 5 6 5 4 6 6 6 4 6 4 4 6 6 5 6 7 1 5 5 5 4 6 4 1=Poor performance 4=Neutral 7=Good performance 5 5 3 5 6 4 5 4 6 6 6 4 6 5 5 5 6 6 6 7 1 4 5 4 6 6 6 Store_Organi Store_Local c 1=Poor performance 4=Neutral 7=Good performance 5 4 2 5 6 6 6 6 6 6 6 4 6 5 4 4 6 6 4 7 1 4 5 6 6 6 6 1=Poor performance 4=Neutral 7=Good performance 6 4 1 4 5 6 6 4 6 6 6 4 6 4 6 5 6 5 5 6 4 4 6 6 7 7 6 1=Poor performance 4=Neutral 7=Good performance 6 4 4 4 5 6 5 4 6 5 4 4 4 5 5 6 6 4 7 6 4 2 5 6 6 7 5 6 3 4 5 6 5 6 5 6 5 4 4 5 4 7 5 6 4 3 6 4 2 5 6 5 5 5 5 4 5 7 6 5 6 5 6 6 5 5 4 4 4 4 4 4 4 3 2 4 5 4 5 4 4 5 5 3 5 5 6 6 6 4 5 3 3 5 6 5 5 5 6 2 3 4 6 4 4 5 4 3 2 4 4 4 5 5 4 4 5 4 7 7 5 3 5 6 6 6 6 6 5 4 4 3 5 6 4 5 6 5 7 6 6 3 4 5 4 6 5 6 5 6 7 5 5 2 3 4 5 4 7 7 5 7 5 5 5 2 7 5 4 5 4 4 6 6 7 7 5 5 7 2 6 4 4 5 5 6 5 5 5 5 3 3 5 6 5 6 6 6 7 6 5 1 6 7 5 6 6 7 6 7 4 3 5 4 5 2 5 6 5 5 5 6 6 5 6 4 5 4 4 4 1 5 7 3 6 5 6 6 2 7 4 4 4 4 2 4 6 5 5 6 6 5 5 7 5 5 5 5 6 1 6 7 3 6 4 5 6 2 7 4 3 3 5 1 4 6 5 6 5 5 5 5 6 5 5 6 4 6 6 5 7 5 6 6 7 6 7 4 3 6 2 5 2 5 6 5 5 5 6 5 5 5 5 5 5 6 6 6 6 7 5 5 5 5 5 4 7 3 6 1 4 3 5 6 5 5 4 5 5 5 5 6 5 4 6 7 5 4 7 2 4 3 6 5 7 4 1 5 3 3 4 4 6 5 4 5 5 5 6 6 6 5 4 7 7 4 4 5 2 4 3 7 5 7 4 2 6 4 3 1 4 6 5 4 5 6 5 6 6 5 5 3 6 5 6 6 5 7 5 4 4 6 5 6 2 4 5 3 5 7 4 5 5 4 4 5 5 3 5 3 4 7 5 4 6 4 4 5 5 3 6 5 4 6 5 6 5 6 5 6 2 6 7 5 4 4 6 5 5 6 6 6 1 7 6 4 4 5 3 4 5 4 4 4 1 1 6 4 4 4 5 6 5 4 4 2 1 1 6 6 4 5 6 4 3 5 6 2 4 5 7 5 4 6 6 3 5 5 5 4 3 4 6 4 4 4 5 3 4 5 5 6 5 7 6 6 7 7 6 7 5 7 6 7 6 5 5 5 6 7 5 7 6 6 5 5 5 4 6 7 5 7 6 7 6 6 7 7 6 7 5 7 6 6 7 5 7 6 6 7 5 7 6 5 5 4 5 3 4 4 4 5 5 5 6 4 4 6 4 4 4 5 5 6 5 6 5 5 6 5 5 7 6 6 6 5 5 6 5 4 5 4 5 6 6 6 6 6 5 6 5 7 6 5 6 6 5 5 4 5 4 4 6 2 5 6 5 5 4 6 3 5 6 3 4 5 6 5 4 5 5 4 6 5 5 6 5 4 4 4 6 6 6 4 5 6 5 4 4 5 7 3 3 3 4 5 5 4 5 4 7 4 3 4 Store_Seaso Store_Uniqu n Store_Range e Store_Try 1=Poor performance 4=Neutral 7=Good performance 1=Poor performance 4=Neutral 7=Good performance 5 3 6 5 6 6 6 5 6 5 5 4 6 4 5 5 6 3 4 6 4 3 5 5 3 5 5 1=Poor performance 4=Neutral 7=Good performance 6 5 6 5 5 6 6 5 6 5 5 4 6 6 6 6 6 5 2 7 2 3 5 5 4 6 6 Store_Pleasa Store_Attrac Store_Organi nt tive sed 1=Poor performance 4=Neutral 7=Good performance 5 4 3 5 5 5 6 4 4 5 4 4 5 3 5 5 6 6 5 5 4 4 5 4 6 5 6 1=Poor performance 4=Neutral 7=Good performance 4 5 2 4 5 5 5 4 4 6 6 4 5 5 6 6 6 4 6 5 3 7 5 4 7 6 4 1=Poor performance 4=Neutral 7=Good performance 6 3 7 5 6 6 7 4 6 6 6 4 6 4 7 5 6 6 7 6 6 3 6 5 5 5 5 1=Poor performance 4=Neutral 7=Good performance 5 3 3 4 6 5 6 5 6 4 6 4 6 6 5 4 6 5 2 5 6 3 5 5 5 6 5 6 2 3 5 6 6 6 5 6 5 6 4 6 4 4 5 6 3 6 7 3 5 6 6 6 6 6 7 5 4 3 5 5 5 6 4 5 5 4 6 5 5 5 5 5 5 4 6 5 5 4 5 4 6 4 5 5 4 4 4 3 6 4 6 6 6 2 6 5 6 4 5 4 6 5 6 6 6 4 6 4 6 5 6 6 6 4 5 4 5 4 5 5 6 6 5 7 7 6 7 5 4 4 6 6 4 7 5 7 5 7 7 7 4 3 4 5 3 3 4 5 4 4 5 4 4 4 4 6 2 7 1 4 1 2 4 1 6 2 3 3 2 1 4 6 4 4 6 2 5 4 6 3 3 2 5 6 5 4 6 4 5 7 5 3 7 6 4 6 6 6 6 6 6 4 6 2 6 5 7 6 7 4 6 5 1 4 1 5 6 5 4 6 5 6 6 5 6 5 6 5 6 7 6 7 6 7 5 6 5 6 7 5 6 4 5 3 5 6 5 5 5 4 5 5 6 6 5 4 4 4 4 6 5 3 7 4 5 5 4 3 4 4 3 3 2 3 6 5 3 5 4 5 5 6 6 5 5 3 4 5 4 3 3 5 4 4 4 4 3 3 4 1 2 2 3 2 2 4 4 1 5 5 5 6 5 5 6 4 7 7 6 3 6 6 4 5 5 4 2 5 2 5 3 4 1 4 3 5 5 5 6 5 5 5 4 7 6 7 3 6 3 6 5 4 5 5 3 2 6 4 5 3 4 6 4 4 5 5 4 6 5 5 5 5 3 5 7 6 6 5 6 6 6 5 5 4 3 7 3 5 3 4 6 6 4 6 5 4 6 6 7 5 6 4 6 3 5 4 5 4 6 5 6 6 3 5 6 4 3 5 6 6 6 6 6 4 3 3 7 2 2 4 4 6 7 6 3 6 3 1 4 5 2 3 1 2 5 5 4 6 7 1 2 6 4 6 7 3 5 5 5 7 7 3 4 6 5 5 6 4 6 5 5 6 7 1 4 6 5 5 5 5 6 6 5 6 7 2 6 6 6 5 5 6 2 5 7 6 1 3 4 5 1 4 3 6 5 5 5 6 2 5 4 6 1 6 5 6 4 4 4 6 4 6 6 6 4 4 7 6 6 4 5 5 6 7 5 7 7 6 7 6 7 6 3 5 4 3 7 4 4 5 5 2 1 1 2 1 4 4 3 3 3 6 6 4 5 6 5 6 5 6 5 5 6 3 3 6 5 5 4 6 5 6 6 5 6 6 5 5 4 6 5 5 5 6 5 6 5 4 5 5 4 5 4 5 4 3 5 4 6 6 7 5 6 6 5 5 6 4 6 1 7 5 6 6 4 6 5 5 5 4 7 5 5 5 3 4 2 4 5 6 3 4 5 5 3 4 3 5 4 4 2 4 5 5 5 5 4 5 3 6 4 5 5 5 5 5 6 5 2 4 4 5 5 5 5 4 5 6 5 6 5 6 Store_Lightin Store_Floori Store_Queue Store_Locati Store_Signed Store_Smells g ng Store_Aisles s on 1=Poor performance 4=Neutral 7=Good performance 1=Poor performance 4=Neutral 7=Good performance 6 2 7 4 6 5 6 5 6 6 6 4 6 5 5 6 6 5 4 6 7 3 6 5 6 5 6 1=Poor performance 4=Neutral 7=Good performance 5 2 7 4 5 6 4 5 6 6 6 4 6 4 6 5 6 5 4 5 5 3 5 4 6 4 4 1=Poor performance 4=Neutral 7=Good performance 5 3 1 5 6 6 6 4 6 6 6 4 6 3 5 4 5 6 5 6 7 3 6 4 7 5 5 1=Poor performance 4=Neutral 7=Good performance 5 3 1 4 6 4 5 5 6 6 6 4 6 4 5 5 6 6 5 6 7 6 5 6 4 6 5 1=Poor performance 4=Neutral 7=Good performance 6 5 2 4 5 5 5 3 6 6 6 4 6 5 6 6 5 7 6 5 7 6 5 6 3 5 5 1=Poor performance 4=Neutral 7=Good performance 6 3 2 4 5 4 4 5 6 6 6 4 6 4 4 5 5 5 7 6 7 6 6 6 4 4 6 4 4 6 5 5 6 6 5 5 6 6 4 6 4 5 5 5 4 6 5 7 2 6 6 5 4 6 6 7 6 6 5 5 6 6 6 6 6 6 3 6 5 5 6 6 6 6 4 5 4 6 6 6 5 6 5 4 5 6 4 6 5 4 5 4 4 6 6 6 6 5 5 4 5 5 2 5 3 6 6 4 4 5 5 5 3 5 5 5 5 4 2 3 5 2 5 4 6 7 6 6 5 5 6 5 5 4 3 4 7 6 4 7 5 5 3 3 4 5 3 4 7 6 4 7 4 5 4 3 4 2 7 4 7 4 4 7 3 4 5 6 7 7 7 5 6 7 7 6 6 4 5 4 4 3 6 4 6 5 3 6 4 4 2 6 5 6 3 5 6 7 4 6 7 7 6 7 4 6 6 6 5 5 4 3 7 2 4 2 4 6 6 4 5 5 4 6 6 5 5 6 7 7 6 6 7 4 6 5 5 4 4 3 2 6 3 6 2 4 6 4 3 5 4 5 6 6 5 5 5 6 7 7 6 7 6 6 5 5 4 4 4 3 7 1 7 4 4 5 6 4 6 5 4 5 7 5 5 4 5 5 2 2 1 1 4 4 4 4 4 4 3 6 1 7 2 4 6 6 3 5 4 4 6 5 5 5 6 6 5 7 7 7 5 7 4 4 4 4 4 4 6 2 5 3 5 6 6 3 5 5 4 5 5 6 5 6 6 6 3 7 5 5 7 5 5 5 5 6 4 6 1 7 3 4 6 7 5 5 5 4 5 5 7 5 5 6 4 7 7 7 7 7 7 7 5 7 6 5 7 3 7 1 5 6 7 6 6 4 4 5 6 5 5 5 4 6 4 4 5 5 6 5 6 6 6 7 1 6 4 5 5 5 5 7 6 4 6 7 3 3 3 5 5 6 4 6 6 4 6 7 4 5 3 5 5 6 5 6 6 4 6 7 4 4 6 4 5 7 4 6 6 3 6 7 4 6 5 5 4 7 6 4 4 4 4 7 1 3 4 4 6 7 4 5 6 7 7 7 5 7 6 1 6 5 5 5 5 5 5 4 5 5 6 3 4 5 7 3 4 4 6 3 5 5 5 5 3 6 5 5 6 6 5 5 7 7 6 6 6 6 5 5 4 4 5 6 5 5 5 6 5 5 4 5 6 7 6 5 6 7 6 6 4 5 6 5 5 5 6 7 4 6 4 5 5 6 6 7 6 7 6 6 4 5 5 7 7 6 7 7 5 7 6 6 6 5 6 4 5 7 7 7 6 6 7 6 5 6 6 5 6 6 6 5 5 5 5 6 5 5 5 5 5 5 6 6 6 6 4 4 4 5 3 4 7 6 6 6 6 5 4 4 4 6 4 4 7 5 5 5 5 5 6 7 6 6 6 5 5 5 5 4 7 5 5 5 6 4 5 4 6 5 4 5 2 5 6 5 5 4 5 5 5 4 1 2 5 4 4 5 6 5 5 4 4 6 Store_Parkin Store_FreePa g rk Store_Hours Store_Talk 1=Poor performance 4=Neutral 7=Good performance 1=Poor performance 4=Neutral 7=Good performance 7 5 7 6 7 7 7 4 6 6 6 4 6 6 6 6 6 5 7 7 7 2 7 7 6 6 7 1=Poor performance 4=Neutral 7=Good performance 7 6 7 6 7 7 7 4 6 6 6 4 6 6 5 4 6 6 3 6 7 2 7 7 6 5 7 Store_Servic Store_Know e Store_Slow 1=Poor performance 4=Neutral 7=Good performance 7 6 7 7 4 4 4 4 6 5 5 4 6 5 4 5 6 5 4 7 7 2 6 5 6 6 6 1=Poor performance 4=Neutral 7=Good performance 5 3 4 5 5 6 6 4 6 5 5 4 5 4 5 4 6 6 2 5 3 2 6 6 5 5 5 1=Poor performance 4=Neutral 7=Good performance 5 3 6 4 5 6 6 4 5 5 6 4 5 3 6 5 6 6 3 6 3 4 6 6 5 5 5 1=Poor performance 4=Neutral 7=Good performance 5 5 6 5 6 7 6 4 6 5 6 4 6 5 6 6 6 6 4 6 3 4 6 5 4 4 6 4 3 5 4 5 5 5 4 3 5 5 4 5 6 5 5 6 5 4 6 4 4 6 5 5 6 5 7 7 6 5 5 5 5 6 6 5 5 5 4 5 4 7 6 5 5 4 5 5 5 5 6 5 5 4 4 4 5 5 4 6 5 5 4 5 5 5 5 4 5 5 5 4 3 6 5 4 5 4 5 5 3 6 5 5 5 5 3 4 4 4 3 3 5 5 6 7 4 7 6 5 7 5 7 3 3 2 5 7 6 7 4 4 7 6 4 7 5 3 6 5 6 6 4 6 5 5 4 4 4 5 3 5 5 5 6 6 6 3 2 3 4 6 7 6 5 5 7 7 7 5 4 4 3 4 2 5 5 6 7 5 7 4 4 1 6 5 1 5 6 5 4 5 4 7 7 7 7 7 7 7 6 7 6 3 6 3 6 1 6 6 7 6 6 5 4 5 6 6 5 6 3 6 7 7 7 7 7 7 7 6 7 6 5 6 4 6 1 6 6 7 6 6 5 6 5 6 6 5 3 5 5 7 3 7 5 7 6 7 5 4 7 3 4 2 6 2 5 5 5 6 5 5 6 5 6 7 5 6 5 4 7 3 6 4 7 4 6 4 3 5 4 6 1 6 3 2 6 2 2 3 6 5 5 5 5 5 2 4 4 7 6 6 4 7 5 5 4 4 5 3 6 3 6 1 1 6 5 3 3 6 5 6 6 5 5 6 6 5 6 6 6 4 7 5 5 4 5 5 3 6 3 7 2 3 6 5 3 3 6 5 5 6 5 4 6 7 3 6 6 7 4 5 4 4 4 3 3 2 7 1 5 1 2 6 5 3 3 7 4 7 6 5 4 5 6 4 4 7 6 6 5 6 7 6 7 7 7 6 6 6 6 6 7 7 7 6 7 7 7 7 3 6 6 5 5 7 5 6 7 7 6 7 6 3 5 5 4 7 6 5 7 7 2 4 5 3 4 4 5 7 6 4 7 7 2 5 6 4 5 5 3 7 6 5 5 7 2 6 3 3 4 5 4 5 6 4 7 6 3 7 7 5 6 6 7 6 6 6 6 4 5 5 6 2 4 5 6 1 4 5 6 3 5 5 6 6 4 5 7 7 4 5 5 5 5 7 6 7 7 7 7 4 6 6 7 7 7 7 7 7 7 4 6 6 7 6 7 6 5 6 7 4 6 6 7 5 2 2 3 6 4 6 4 4 4 5 5 5 5 6 6 6 4 4 6 4 5 5 6 6 6 5 4 4 6 5 6 4 6 6 4 5 4 4 4 6 7 5 5 6 6 5 5 6 6 5 5 6 4 5 6 5 5 5 5 6 5 5 5 7 4 6 4 3 4 6 5 5 5 4 5 5 6 2 4 7 5 6 5 5 6 3 5 1 3 7 6 6 4 6 5 3 4 4 3 2 6 5 4 4 5 3 4 2 4 6 6 6 4 4 5 4 5 1 2 5 6 6 4 5 4 4 5 3 4 6 Store_Entert Store_Atmos Store_Comm Store_GoodT ain phere unity ime 1=Poor performance 4=Neutral 7=Good performance 1=Poor performance 4=Neutral 7=Good performance 5 5 6 4 5 5 5 5 5 6 5 4 6 5 3 6 3 4 3 4 2 3 6 3 3 5 4 1=Poor performance 4=Neutral 7=Good performance 6 4 6 5 6 5 6 4 4 5 4 4 5 4 6 5 6 5 2 4 2 3 5 3 3 5 4 1=Poor performance 4=Neutral 7=Good performance 6 4 4 4 5 5 6 4 6 6 6 4 5 3 4 6 3 4 1 5 2 3 6 3 4 4 4 4 2 4 5 6 5 5 4 5 5 5 4 5 5 5 6 6 5 1 6 2 3 6 4 5 6 5 2 5 5 4 5 5 5 5 5 5 5 4 5 5 5 4 5 5 6 4 4 4 5 3 5 5 5 4 5 4 4 5 5 4 4 5 5 5 5 3 4 5 5 4 4 4 6 4 4 3 6 4 7 7 4 5 4 5 5 5 5 4 3 4 7 5 6 6 5 4 6 6 4 2 2 4 4 6 4 7 4 4 1 4 2 5 7 4 5 4 3 4 3 3 1 6 1 5 1 1 5 3 2 3 6 4 5 6 5 4 4 6 4 2 2 6 4 5 4 3 4 3 3 3 7 2 5 1 1 5 2 2 3 5 5 5 6 5 4 6 4 5 7 2 6 4 5 4 3 4 7 3 5 7 3 4 1 1 2 2 3 3 6 4 5 6 5 5 5 3 6 7 6 6 4 6 3 3 4 2 3 2 7 2 5 2 3 5 5 3 5 7 5 5 7 5 5 4 6 6 2 3 4 2 6 4 6 4 5 7 3 5 6 4 4 3 5 4 6 4 7 7 1 4 4 4 6 6 3 4 6 4 7 4 1 4 4 4 6 3 6 4 6 4 7 7 1 3 5 3 5 3 5 2 5 4 6 4 3 4 5 4 3 4 4 5 5 6 5 6 6 6 5 5 5 4 6 6 3 3 4 3 3 4 6 4 6 6 4 4 4 4 4 6 6 4 4 6 4 3 5 3 4 4 6 4 6 6 5 5 6 5 6 4 6 5 5 5 5 6 5 5 5 4 5 4 4 2 4 5 6 5 4 4 4 4 5 3 6 6 6 6 4 4 4 4 5 4 2 3 5 5 5 5 4 5 5 4 2 6 115.109 Topic 8 Lab Worksheet: Comparing Means, ANOVA Latest due date: October 9 In this lab we continue to use the dataset used in Week 4, 5 and 7 (the Countdown customer dataset) to investigate diffe Use the Data Analysis Tookpak (on a PC, or on a Mac using the latest version of Excel) to run a two-sample t-test on Imp_ On Mac: calculate t-test manually. (ANOVA: too many steps) In each case state what the null and alternate hypotheses are, and what your conclusion is regarding the null hypothesis Task 1: Test difference between Importance Mean and Store Performance mean for Quality (Imp_Quality vs Store_Quali Short label Question Quality Getting quality produce Importance Importance Performance Standard Mean Mean Deviation 5.8378378378 5.3333333333 1.100736019 Task 2: Test difference for Store Performance Mean for Quality (Store_Quality) by Gender categories using two-samples Task 3: Test difference for Store Performance Mean for Quality (Store_Quality) by Gender categories using F-test from A Task 4: Test difference for Importance Mean for Quality (Imp_Quality) by How Often Shop Here categories using ANOVA Means, ANOVA wn customer dataset) to investigate differences in means. xcel) to run a two-sample t-test on Imp_Quality vs Store_Quality; on Store_Quality by Gender , and Single Factor ANOVA for Imp_Quali nclusion is regarding the null hypothesis. or Quality (Imp_Quality vs Store_Quality) using Data Analysis Tookpak (or manually) Performance Standard Importance Performance Deviation Sample Size Sample Size 1.0907131485 148 117 Gender categories using two-samples t-test Hint: Activate the Data Analysis Toolpak (if available): File > Opti Ins > Go... > Analysis ToolPak Or use the manual formula (below) x1 x2 t 1 1 sp n1 n2 sp n1 1 s12 n 2 n1 n2 2 Hint: Sort the data by Gender (column Y) and compute the desc separately for each part of the dataset. Gender categories using F-test from ANOVA ften Shop Here categories using ANOVA (manually: test any two categories using t-test) tor ANOVA for Imp_Quality by Often Shop Here. k (if available): File > Options > Add-Ins > Manage Excel Add- n1 1 s12 n 2 1 s22 n1 n2 2 Y) and compute the descriptive statistics for column BC . Data Year 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 QUEST ID STORE DayIOf Week SUBURB Time Downing St Coding: 'NEW'= eg 01 'OLD'= Bentley Av A3 B19 D45 D53 D56 D57 D59 E1 E3 E6 E8 E9 J11 J17 J18 J20 J21 L55 L57 M13 A4 A5 A8 B7 D48 D49 D50 D51 D52 D58 D62 D63 E2 I44 I46 I49 NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD Beach Haven Browns Bay Glenfield Bay View Glefield Glefield Glenfield Bayview Glenfield GLENFIELD 0 GLENFIELD BROWNS BAY GLENFIELD Glenfield Glenfield Greenhithe Glenfield Grafton Glenfield Albany glenfield northcote glenfield Forrest Hill Hillcrest Glenfield Glenfield Glenfield Glefield Glenfield Glenfield Glenfield 4 9am 6 11:10 2 0.745138889 6 0.673611111 6 0.753472222 6 0.770833333 6 0.684027778 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 1 12pm-3pm 5 5 5 5 5 2 14:10 2 13:27 5 4 9.am 4 9.am 4 9.am 6 11:45:00 7 0.4375 7 0.447916667 7 0.454861111 7 0.472222222 7 0.479166667 6 0.670138889 6 0.715277778 6 0.732638889 1 12pm-3pm 3 13:17 3 12:50 3 9:50 Q1 (Usual store) 1=Yes 0=No 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 0 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 I50 I53 I54 I56 I59 I60 I61 I62 I63 J5 J6 J8 L43 L44 L45 L46 L47 L50 O41 O42 O43 O44 O46 O48 O49 B1 B2 B3 B4 B5 B18 B D46 D54 D60 E4 E7 H43 J12 J16 L52 L53 M11 A7 B8 B11 OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW OLD OLD OLD Glenfield Totara Vale Glenfileld Glenfileld GLENFIELD GLENFIELD GLENFIELD GLENFIELD GLENFIELD Bay View Bay View Glenfield Glenfield Birkenhead Glenfield Glenfield Glenfield Northcote poi Fairview heigh Browns Bay Glenfield Bayview Glenfield Glenfield Bayview Northcote Glenfield Glenfield Glenfield Glenfield Albany Northcross Glenfield Birkdale Glefield BeachHaven Forrest Hill GLENFIELD GLENFIELD Pinehill Pinehill Whenuapai Pinhill Albany Albany 3 10:10 3 12:30 3 9:00 AM 3 9:20 AM 3 9:00 3 9:15 3 9:25 3 9:35 3 9:50 5 5 9:20 5 9:15 2 14:15 2 15:00 2 15:10 2 12:59 2 13:05 2 14:25 4 4:30 4 4:38 4 4:48 4 6:15 4 4:40 4 4:55 4 5:15 6 10:05:00 6 10:00:00 6 11:40:00 6 12:00:00 6 12:55:00 6 10:41 6 11:22 2 0.675 6 16.35 6 0.697916667 1 12pm-3pm 1 12pm-3pm 1 12.30pm-2.3 5 5 2 13:18 2 13:25 5 4 9.am 6 12:15:00 6 11:18:00 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 0 0 0 1 1 1 0 1 1 1 1 1 1 1 0 1 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 B12 B14 H41 I48 I51 I52 I55 I57 I58 J1 J2 J7 J9 J10 L48 M3 M6 M7 M10 O45 O47 B17 E5 H45 L54 L56 L60 B10 I47 J3 M1 M8 O50 A1 A2 B16 D44 D47 D55 E10 J13 J14 J15 J19 L51 L58 OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD NEW NEW NEW NEW NEW NEW OLD OLD OLD OLD OLD OLD NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW NEW Sunnynook Glenfield Forrest Hill Sunnynook Glenfield Unsworth Heights Glenfileld Glenfileld Glenfileld Hillcrest Glenfield Glenfield Glenfield Beach Haven Greenhithe Glenfield Northcote Seaview rd Glenfield Glenfield Glen Innes Browns Bay Forrest Hill Albany Birkdale Browns Bay Sunnynook Glenfield Northcross Hillcrest Forrest Hill Pinehill Browns Bay Forest Hill Oteha Valley Albany Pinehill Glenfield BIRKENHEAD PINEHILL MILFORD PINEHILL Pakuranga Totata Vale 6 11:58:00 6 12:25:00 1 12.30pm-2.3 3 9:30 3 10:40 3 11:30 3 9:10 AM 3 9:30 AM 3 9:40 AM 5 5 5 9:30 5 9:00 5 9:10 2 13:15 5 5 5 5 4 6:20 4 4:50 6 10:41 1 12pm-3pm 1 12.30pm-2.3 2 14:03 2 13:15 2 14:25 6 12:30:00 3 14:52 5 5 5 4 5:23 4 9am 4 9am 6 10:30 2 0.822916667 2 0.689583333 6 0.701388889 1 12pm-3pm 5 5 5 5 2 13:10 2 13:40 1 1 1 1 1 1 0 0 1 0 0 0 0 0 1 1 1 0 1 0 1 0 0 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 L59 M12 A6 B6 B9 B13 B15 D61 H42 H44 I43 I45 J4 L41 L42 L49 M2 M4 M5 M9 OLD NEW NEW NEW OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD Birkdale West Harbour Albany Oteha Albany Sunnynook Totara Vale Whangaparao Milford Westmere Glenfield Glenfield East Coast Bay Birkenhead Albany Height Forest Hill Albany Forrest Hill 89 59 2 14:06 5 4 9.am 6 11:35:00 6 12:56:00 6 12:13:00 6 12:45:00 6 0.705555556 1 12.30pm-2.3 1 12.30pm-2.3 3 8:43 3 10:08 5 2 12:50 2 13:10 2 13:45 5 5 5 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 Q2 Which Store Text Q2a (Often Q2b Long shop Q3 Often shop THERE) THERE shop HERE 1=Week 2=Month 3=Year 4=Rarely 1 More than 5 years 2 More than 1 year 3 More than 2 mnths 4 Only recently PAKNSAVE 1 4 ALBANY 2 2 Pak n Save 1 4 Q3b Long visit Q4 Choose here Location 1=Week 2=Month 3=Year 4=Rarely 1 More than 5 years 2 More than 1 year 3 More than 2 mnths 4 Only recently 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1=Closest to home 2=Closest to work 3=Other loctnl reason 4=Like the company 5=Like store itself 6=Like shops around 2 2 2 2 2 4 3 1 1 1 1 2 2 2 2 2 2 1 2 3 1 2 1 1,4 2 3 3 4 2 2 1 1 1 1 1 2 1 4 1 1 1 2 5 1 1 1 1 1 1 1 5 1 3 1 1 1 1 3 2 1 2 5 5 2 1 1 1 1 1 1 1 1 1 Pak n Save 1 2 1 2 2 1 Pakn Save 1 2 Pakn save 1 3 2 Asian Grocery Pak'n Save Pak n Save 2 1 1 2 2 2 Hibre 2 1 2 2 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 2 1 2 4 1 2 1 2 2 1 1 2 2 2 2 2 3 2 1 2 1 1 2 2 2 1 1 2 2 2 2 2 3 1 2 2 1 1 2 2 2 3 2 1 1 1 1 1 5 5 5 5 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 4 3 1 2 2 2 5 4 1 1 1 2 1 2 nSave Wairau rld Glenfield 1 1 1 1 1 2 2 3 3 5 5 1 1 4 2 2 Pak n Save 2 Pak n save 1 2 1 4 1 2 Pak'n Save Browns Bay C 2 1 1 1 Parksave Alba Birkdale Cou Browns Bay 3 1 2 1 1 1 3 1 2 2 2 1 2 3 3 1 2 1 2 1 2 4 1 2 1 1 2 Northcote Co Pak n' Save Pak n Save Countdown Br Pak n Save, W Pak n' save Countdown S Pak n Save Pak n save; N New World Pak'n Save Pak n Save Al Pak n Save Browns Bay Birkenhead BIRKENHEAD PAKNSAVE PAKNSAVE ParknSave 2 1 1 1 1 1 1 2 2 4 4 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 2 3 1 3 2 3 2 2 2 1 1 4 1 1 4 1 1 4 1 2 2 2 2 2 3 2 3 2 2 2 1 5 4 2 2 4 2 2 4 4 4 3 1 4 3 3 2 1 2 1 1 1 5 5 1 1 2 1 1 2 2 1 1 3 1 1 3 1 1 1 2 6 3 4 3 3 3 3 3 3 3 2 1 4 ParknSave Pak n Save Pak n' save Pak n' Save Al New World Bi Albany Pak 'n' New World 2 2 1 1 1 2 2 2 2 2 1 2 4 1 2 1 Albany Pak n Save Pak n Save 2 2 2 Pak'n Save Taiping Asian, Pak'n Save Pak'n Save Albany New World Mi Countdown Ri Pak n' save 3 4 2 2 1 3 1 2 1 1 2 2 2 2 1 3 4 4 4 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 3 2 4,5 4 4 4 2 4 4 4 2 4 4 3 4 4 1 4 1 2 3 1 1 2 5 6 3 3 1 2 3 3 2 6 Q4 Other Reason Free text for "Other locational reason" Q5 Visit Q5 shops Q4 Other other shops text Shops Free text for 1=Yes (enter text) "Like the shops 0=No around" like the company because if Passing by AFTER SWIMMING Was passing bFarmers Onecard Closet to school N Q7 Work Suburb (enter text) 1 will browse around lots of 0 Farmers 1 The Warehouse Henderson 0 0 0 0 1 1 1 bank 1 Muffin Break 0 0 GLENFIELD 0 1 JAPANESE STOGLENFIELD 0 BROWNS BAY 1 GLENFIELD 0 Glenfield 0 Glenfield 1 Greenhithe 0 Glenfield 0 Auckland city 1 Farmers Auckland city 0 0 0 0 0 1 KFC 0 Glenfield 1 The Warehouse 0 Glenfield 1 1 Ware House 0 Q8 Get Here Q9 Age 1=Car 2=Bus 3=On foot 4=Other 1=16-19 2=2029 3=30-39 4=40-49 5=5059 6=60-69 7=70 plus 1 1 1 1 1 1 1 1 1 1 1 1 1 3 3 1 3 1 1 1 1 1 3 1 1 1 1 1 1 1 1 1 2 1 1 3 3 2 3 2 2 4 3 2 3 7 6 7 2 2 2 2 2 3 2 4 3 2 3 2 3 2 2 4 2 4 4 4 3 2 5 6 N Y Good car park Passing by close to family Health 3000, Body Shop 0 Auckland central 0 0 0 0 0 0 0 Bay View 0 Bay View 1 Health Shop, Glenfield 0 Glenfield 0 Birkenhead 0 Glenfield 0 Glenfield 1 Hannahs, Far Glenfield 0 Northcote poi 0 Fairview heigh 0 Browns Bay 0 Glenfield 0 Bayview 1 Coffee shop,haGlenfield 0 Glenfield 1 Warehouse K Bayview 1 Farmers 1 The Warehouse 1 The Warehouse 1 The Warehouse 1 The Warehouse 0 Asian Grocery Stores 0 The WarehousCity CBD 1 The WarehousAlbany 0 1 The WarehousForest Hill 1 Glenfield 0 Glenfield 0 Auckland City 0 GLENFIELD 0 GLENFIELD 0 Pinehill 0 Pinehill 0 Whenuapai Glenfield 1 Greenhithe 0 1 The Warehouse 1 1 1 2 1 2 1 1 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 3 4 1 3 2 3 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 6 7 5 6 3 2 5 2 3 3 3 7 7 5 6 4 7 2 4 2 2 3 4 1 7 6 7 6 5 7 2 2 3 3 4 5 4 5 2 1 2 2 4 2 1 3 2 2 0 N Y N Subway 0 0 Working in mall Food court Glenfield visitng family The whole mal Playing tennis at Glenfield Passing by close to friends house pick up kids from swimming Closets to gym CONVIENT AT TIME ALBANY WAS IN THE AREA Glenfield Glenfield Glenfield Glenfield 0 Hillcrest 1 Farmers Glenfield 0 Glenfield 1 Muffin Break Glenfield 1 Farmers, War Beach Haven 1 Glassons, Cot Greenhithe 0 Takapuna 0 Glenfield city 1 Northcote City 0 Seaview rd 0 Glenfield 1 Warehouse Glenfield 1 Hallenstiens 1 0 1 Dahua, AlbantAlbany 0 Birkdale 0 Browns Bay 0 0 Glenfield 0 Northcross 0 Hillcrest 1 Forrest Hill 1 Clothes shopsPinehill 0 Auckland City 0 1 Farmers 1 The WarehousAlbany 0 City 0 1 Hallensteins, Birkenhead 0 BIRKENHEAD 1 ALBANY PAKNPINEHILL 1 COTTON ON MILFORD 0 PINEHILL 0 Parunrang 0 Totata Vale 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 2 2 4 5 6 3 7 7 1 3 2 6 3 1 2 3 3 4 2 2 1 2 7 2 2 3 2 3 1 3 2 2 5 2 2 3 4 2 2 1 2 2 2 2 2 Was in area visiting another shop near b On way to friends Going to family lunch Passing through On way home + looking in sh 0 Birkdale 0 West HarbourAlbany 1 2 dollar shop Albany 0 0 2 1 The Body ShopMairangi Bay 0 Browns Bay 0 Albany 0 Westmere 0 0 0 East Coast Bay 1 Glassons, Cot Birkenhead 0 Albany Height 1 Cotton on, fooForest Hill 0 0 Albany 0 0 Forrest Hill Glenfield 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 3 3 2 5 2 2 2 2 2 1 4 3 4 2 1 4 2 3 3 2 2 ALL Q10 Gender Imp_Quality Imp_Fresh 1=Male 2=Female 1=Not important 4=Neutral 7=Very important 1 2 2 2 1 2 2 1 2 2 1 1 2 2 2 2 1 11 1 2 1 2 2 2 2 2 2 2 1 2 2 2 1 2 1 1 Imp_Price 1=Not important 4=Neutral 7=Very important Imp_Special Imp_Healthy Imp_Look 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 7 5 5 4 7 5 5 5 5 4 7 7 6 5 7 7 7 7 6 6 4 4 5 6 6 7 7 7 6 6 7 6 6 5 6 5 7 6 5 3 4 7 7 7 7 5 6 7 6 6 6 4 3 3 4 4 5 7 7 7 7 5 7 6 7 7 5 3 3 3 5 6 6 7 7 7 6 6 5 6 7 7 6 3 4 4 4 5 5 7 7 7 4 5 7 5 7 7 4 3 6 6 5 4 7 7 7 6 5 4 5 4 5 5 6 5 5 5 3 5 6 6 4 7 7 6 6 5 4 5 4 5 5 7 5 6 6 3 6 6 5 4 7 5 7 5 5 5 4 4 5 5 6 5 5 3 4 4 6 5 3 6 5 7 5 4 4 4 4 5 5 4 4 5 4 5 1 6 5 3 7 7 7 7 6 3 4 4 4 4 5 5 6 6 4 5 6 6 4 6 4 6 4 7 2 4 4 4 4 4 7 4 4 4 2 6 2 2 1 1 1 2 1 2 2 2 2 2 2 1 2 2 2 2 2 2 2 2 2 2 1 2 2 2 2 2 1 2 2 1 2 2 1 1 1 2 2 2 1 1 2 2 6 7 5 6 6 7 7 5 7 7 6 6 7 7 7 7 7 7 6 4 6 6 7 5 6 7 7 7 5 7 5 6 7 4 5 5 7 6 6 7 7 5 7 7 7 7 7 7 7 7 4 6 6 7 5 6 7 7 7 5 7 5 6 6 4 5 6 6 6 5 4 5 5 7 7 5 7 6 7 7 6 6 5 6 7 6 6 7 7 7 5 6 4 6 6 4 5 7 6 6 5 7 5 3 4 7 7 6 7 6 7 3 6 5 5 7 6 6 7 7 7 5 7 5 6 7 5 6 6 6 5 6 7 5 6 7 7 7 7 7 7 6 4 4 6 4 3 6 6 7 7 7 5 7 6 6 7 6 7 6 6 7 7 3 5 7 6 7 7 7 6 7 6 3 4 4 3 4 5 5 7 7 7 5 7 4 6 6 7 7 7 7 6 4 7 6 7 6 6 6 5 6 7 7 4 3 6 4 7 6 6 6 6 6 6 6 7 7 4 5 6 5 6 4 7 6 7 5 6 6 7 7 4 2 6 4 5 5 6 6 6 5 7 5 7 6 4 3 6 5 6 6 5 6 6 5 7 6 7 7 5 4 4 2 7 5 4 5 5 5 6 5 7 6 3 4 2 2 2 2 2 1 2 2 1 2 2 1 2 2 2 1 2 2 2 2 2 1 2 1 2 2 1 1 2 2 1 2 2 2 3 1 2 2 2 1 2 1 2 2 2 2 3 7 6 6 6 7 6 6 5 6 7 7 4 6 5 6 7 6 4 4 7 7 6 4 4 5 6 7 5 4 6 4 6 7 6 6 5 6 5 7 7 6 6 7 7 6 7 6 6 6 6 7 5 5 5 6 7 7 4 6 5 6 7 6 3 4 7 7 6 4 5 5 6 5 4 5 6 3 5 7 6 7 5 6 5 7 7 6 6 7 6 6 7 3 5 6 6 7 5 4 5 6 7 7 2 6 5 6 6 5 5 6 3 5 2 7 5 5 5 4 4 3 6 5 6 5 6 5 6 6 6 7 7 6 6 7 5 6 7 6 4 6 5 7 5 5 5 6 7 7 1 6 5 6 6 5 5 5 2 5 2 7 5 5 5 5 2 5 6 3 7 5 7 7 6 6 3 7 7 7 5 2 6 6 7 5 5 6 4 7 6 5 4 5 7 7 5 6 5 5 7 5 6 4 2 6 6 4 4 5 6 4 4 5 5 4 4 6 6 6 6 6 4 7 7 7 6 4 5 6 6 4 3 6 5 7 6 5 4 6 5 6 1 7 5 6 4 4 3 3 4 5 6 7 3 5 6 5 5 6 5 4 5 6 5 7 6 5 6 7 7 5 6 5 5 6 1 2 1 2 1 1 2 2 2 2 1 2 1 2 2 1 2 2 2 2 Means SdDev N 7 7 7 5 7 6 6 6 7 7 5 3 5 7 7 5 6 5 5 7 7 7 7 5 7 6 6 5 7 7 5 4 6 7 7 5 6 5 5 7 5 7 7 5 7 7 4 6 6 2 4 2 4 7 2 5 5 5 6 5 5 7 6 4 7 7 4 7 5 2 3 2 6 7 4 4 5 4 6 6 7 7 7 5 7 7 6 6 7 7 3 3 6 7 7 4 6 5 6 4 7 7 6 6 7 7 5 7 5 4 4 4 7 7 7 4 6 6 7 3 5.837837838 5.891891892 5.445945946 5.277027027 5.601351351 5.310810811 1.100736019 1.050656647 1.289854623 1.460691039 1.232992405 1.403839978 148 148 148 148 148 148 Imp_Local Imp_Organic Imp_Season Imp_Range 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important Imp_Pleasan t Imp_Unique Imp_Try 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 7 6 6 2 3 4 3 2 2 7 7 7 3 6 6 5 6 5 1 4 3 3 4 2 3 2 7 7 3 4 7 6 6 6 6 4 4 5 3 3 4 7 7 7 5 5 7 6 7 6 5 5 3 4 4 4 4 7 7 7 5 6 6 7 5 4 4 4 6 5 4 5 4 6 7 7 3 5 7 5 4 4 1 2 4 3 3 5 5 6 7 7 3 4 5 5 4 6 6 5 5 4 3 3 3 7 6 7 5 6 6 7 4 6 6 7 5 6 6 6 4 6 5 5 4 4 5 3 2 4 4 3 2 3 2 4 3 6 4 3 6 6 6 5 3 5 3 4 4 4 2 4 4 2 4 5 6 5 4 6 5 6 6 5 4 5 4 5 5 2 6 4 3 4 4 6 6 3 7 6 6 5 6 5 5 4 5 5 6 4 7 4 5 4 6 5 4 5 4 5 4 5 4 3 5 5 5 4 4 5 4 3 4 6 4 3 7 4 6 5 6 3 3 5 5 4 1 3 2 5 5 1 4 4 4 6 6 6 4 4 5 5 5 3 5 4 3 4 3 5 1 3 6 6 5 6 6 7 7 7 5 5 4 7 6 7 4 3 1 3 5 4 6 5 6 6 5 7 4 4 4 7 5 6 7 6 6 6 5 4 6 5 6 6 7 1 5 2 1 1 3 4 2 5 4 5 6 7 7 7 7 3 7 5 6 7 6 7 7 6 7 5 5 5 4 7 7 7 4 7 6 5 4 2 4 3 2 5 5 7 7 7 5 7 5 6 7 7 6 5 5 6 5 6 5 5 7 6 7 6 7 6 6 4 2 3 3 7 6 4 7 7 7 5 7 6 6 7 6 6 6 5 6 6 4 3 2 4 4 5 6 1 1 3 2 2 3 3 1 5 5 4 7 4 4 4 4 5 4 5 6 6 5 5 5 3 3 2 7 1 2 4 2 1 2 2 3 3 4 4 4 3 1 4 1 6 4 5 6 6 6 7 5 6 6 6 3 5 4 7 6 7 6 5 5 4 2 5 4 4 5 4 5 7 6 7 6 7 5 3 6 7 7 4 4 6 1 3 7 2 3 5 5 3 5 4 7 6 4 4 1 4 7 3 3 5 5 3 6 4 7 6 5 5 1 4 7 4 5 6 5 5 4 5 7 6 3 5 5 4 7 4 5 5 5 7 5 5 7 6 4 2 4 3 5 3 3 5 6 4 7 3 7 6 6 2 3 5 1 2 1 4 6 5 5 3 2 5 3 3 5 4 6 3 6 5 6 4 6 4 7 7 4 4 6 2 3 6 5 7 5 5 5 6 6 5 1 1 2 5 4 4 4 3 6 7 5 4 5 4 5 6 3 4 6 4 6 7 3 6 2 5 7 7 6 6 5 4 4 6 6 2 4 6 6 7 5 6 6 5 6 2 1 1 2 5 4 4 5 3 5 7 5 4 4 4 4 5 3 5 5 4 6 2 2 6 2 2 5 2 5 6 5 5 3 6 6 3 5 6 5 7 5 6 5 4 7 7 5 3 5 5 5 5 5 4 7 4 6 4 3 4 4 4 3 5 5 5 6 7 3 6 5 2 3 6 6 7 6 7 6 5 7 6 5 6 6 7 6 5 4 6 6 7 3 7 5 6 5 6 3 3 6 5 5 7 5 5 6 5 4 5 5 4 7 5 4 7 5 6 3 6 7 5 5 5 6 7 5 6 4 7 4 7 6 6 1 6 5 4 5 3 2 5 3 3 2 3 5 4 5 3 4 4 3 6 2 4 6 3 7 4 2 6 2 5 3 4 5 7 5 5 6 4 5 2 2 5 3 4 6 6 2 7 1 2 1 1 6 5 3 4 3 3 4 2 4 3 5 4 4 7 2 3 5 3 5 5 2 6 1 1 4 6 6 6 2 2 4 4 6 3 5 6 4 7 5 6 5 6 7 7 3 1 5 4 4 5 4 3 6 6 5 4 4 5 5 5 4 4 6 5 6 6 6 7 3 4 5 6 7 6 3 6 6 4 7 6 6 3 7 1 4 5 6 7 3 2 4 5 4 1 6 6 6 4 7 6 5 7 5 1 5 4 7 7 4 4 6 7 4 1 6 6 6 4 7 7 6 4 5 1 6 6 7 7 5 4 5 5 6 1 6 6 6 5 7 7 6 4 5 6 7 7 6 6 3 3 7 7 6 1 7 7 6 4 4 4 6 4 5 1 5 1 5 4 5 1 6 2 6 1 4 5 5 3 5 7 5 4 3 1 6 1 4 4 1 1 4 6 1 6 5 3 6 4 7 6 6 7 3 5 7 4 4 5 3 3 5 6 6 5 4 5 6 4 4.668918919 4.560810811 5.148648649 5.459459459 4.358108108 3.797297297 5.027027027 1.655288427 1.727041241 1.435056067 1.321606826 1.529795394 1.7101516 1.329651102 148 148 148 148 148 148 148 Imp_Attracti Imp_Organis ve ed Imp_Signed Imp_Smells Imp_Lighting Imp_Flooring Imp_Aisles 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 4 5 5 7 4 4 4 4 4 7 6 7 5 5 7 5 4 6 5 3 5 5 5 5 5 7 6 7 5 5 6 7 7 6 6 6 6 5 6 4 3 7 7 7 5 5 7 7 6 6 6 4 5 6 5 4 4 6 7 7 5 5 7 7 7 7 6 5 4 5 5 3 5 7 6 7 5 6 7 6 7 7 4 2 3 3 5 3 3 6 6 7 5 6 6 6 7 5 6 3 4 7 6 5 4 7 6 7 5 5 6 6 5 6 5 4 4 4 3 5 4 5 5 6 5 6 4 5 5 5 5 5 5 5 4 6 3 6 5 4 6 6 6 6 7 3 4 5 3 5 5 5 6 5 6 5 6 5 4 6 6 6 5 4 3 4 5 4 6 7 6 5 3 6 4 6 5 3 7 4 5 5 5 6 5 3 4 5 5 5 6 4 7 3 6 4 3 6 5 6 4 6 6 5 3 4 4 4 5 4 6 7 4 6 4 3 5 5 6 5 4 6 4 5 5 4 4 5 4 3 5 4 6 5 3 7 5 6 5 5 5 5 5 5 5 5 5 5 4 4 4 6 6 6 5 6 5 5 7 6 5 5 4 7 5 5 6 4 2 3 3 5 4 4 3 4 4 7 1 7 4 7 6 6 6 6 6 4 6 6 5 6 5 6 7 7 7 6 4 3 3 3 6 4 5 6 6 5 7 7 7 6 7 6 6 6 5 6 4 6 6 4 6 5 7 7 7 7 6 5 7 4 4 6 3 5 2 6 6 7 7 7 6 7 7 6 6 5 7 5 5 5 4 4 5 4 7 7 7 7 5 5 4 2 3 7 3 7 6 7 7 7 7 6 7 5 6 6 5 6 3 7 5 4 4 4 5 7 5 7 6 5 6 4 3 3 7 4 4 6 5 7 7 7 6 7 6 6 7 5 7 4 5 5 4 4 4 3 7 5 6 6 4 6 3 3 4 7 4 6 5 4 7 7 7 6 7 5 6 7 6 6 5 4 6 3 4 4 5 7 5 6 6 5 6 3 3 5 7 4 5 6 5 7 7 7 6 7 4 5 6 7 4 6 6 6 5 5 5 6 5 5 6 4 5 4 5 6 5 3 6 4 7 5 7 5 6 5 7 4 7 7 6 6 7 4 7 2 7 5 6 5 4 4 6 6 5 3 5 3 7 5 6 4 6 4 5 4 7 4 4 6 6 3 7 3 7 4 6 4 4 4 7 6 3 6 5 5 4 2 5 4 5 4 5 4 4 5 4 3 5 3 7 4 6 4 5 5 6 4 6 5 5 3 5 5 4 6 4 7 5 6 5 6 7 7 5 3 4 5 4 5 4 4 3 7 5 3 5 5 4 4 6 3 6 4 7 6 6 6 6 5 5 6 6 6 4 1 5 4 6 7 6 6 5 7 5 5 6 6 7 6 5 6 4 5 5 6 4 5 7 6 6 4 4 5 6 5 6 6 6 4 5 6 6 6 7 5 5 6 7 6 6 6 4 7 6 4 6 6 6 7 6 5 5 6 7 6 5 7 4 6 3 4 4 3 4 7 3 4 5 5 5 6 3 6 6 4 4 6 7 6 7 6 6 7 7 6 6 6 7 7 5 7 5 6 6 7 5 7 5 6 7 7 3 3 4 6 5 5 4 3 6 7 6 3 6 5 3 5 5 3 6 5 4 5 7 7 5 6 6 6 6 6 5 7 5 2 6 5 5 6 6 7 5 5 6 6 7 6 5 4 4 6 5 5 5 3 5 7 4 4 6 5 3 6 6 4 6 5 5 5 5 6 6 6 3 6 7 7 5 4 7 2 6 3 4 6 6 7 5 5 5 6 7 6 5 1 4 5 5 5 4 4 2 7 5 4 6 4 4 5 6 4 5 5 6 4 3 6 5 4 4 6 7 7 3 5 6 2 5 5 4 6 6 7 5 5 6 6 7 6 6 6 4 6 5 5 4 6 4 7 5 4 4 5 4 6 5 3 6 5 7 5 4 6 6 5 3 7 6 6 4 1 5 4 7 5 6 4 6 5 5 5 4 5 5 3 6 4 4 4 6 5 6 4 7 7 7 4 4 5 7 6 6 5 5 4 7 6 6 4 6 6 6 4 6 7 6 4 6 7 6 7 6 5 3 2 5 4 6 4 6 6 7 4 5 5 6 3 6 7 5 6 5 4 6 5 5 4 6 5 6 6 6 4 5 5 6 7 6 7 5 5 5 4 6 4 4 6 6 5 5 6 5 5 5 2 5 7 6 7 5 2 4 4 6 3 4 4 5 5 6 5 5 4 5 3 6 6 6 7 6 6 4 4 5 4 3 7 6 4 5 6 5 3 4.966216216 5.560810811 5.459459459 5.277027027 5.263513514 4.837837838 5.168918919 1.186176276 1.064110573 1.311271795 1.271460385 1.21979973 1.335308337 1.203105469 148 148 148 148 148 148 148 Imp_Locatio Imp_FreePar Imp_Queues n Imp_Parking k Imp_Hours 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important Imp_Talk 1=Not important 4=Neutral 7=Very important Imp_Know 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 7 5 6 6 5 6 6 6 6 7 7 7 6 4 6 7 7 6 6 4 3 4 6 5 5 7 7 7 6 6 7 7 7 7 6 4 6 2 6 5 5 7 7 7 6 6 7 7 7 7 6 2 4 5 5 6 6 7 7 7 7 6 6 7 7 7 6 6 3 4 6 4 4 7 7 7 5 6 7 7 7 7 2 5 3 7 7 5 4 7 7 7 3 5 7 6 7 6 6 5 2 5 7 4 4 7 5 7 6 6 7 6 5 6 5 4 3 5 5 6 3 7 6 6 6 3 6 5 4 5 5 6 6 6 6 7 4 6 6 5 7 6 6 6 5 6 6 4 4 3 6 6 7 4 5 4 6 6 5 7 6 7 5 6 6 5 3 4 5 6 6 6 5 3 5 6 7 5 6 6 7 4 7 6 5 4 4 5 6 6 5 5 4 5 6 6 5 5 6 4 4 5 5 7 3 2 4 5 5 7 6 5 3 6 6 4 1 5 5 4 4 5 5 4 2 4 6 6 7 5 7 4 4 5 4 6 4 5 5 6 5 5 3 3 5 6 7 7 4 7 4 7 6 7 6 7 4 5 5 5 6 5 7 7 7 7 7 7 7 6 6 6 4 5 2 3 6 7 7 7 6 7 3 7 7 6 6 4 4 5 5 7 6 7 7 7 6 7 7 7 6 6 6 5 5 3 6 4 4 7 7 6 7 5 7 7 6 7 5 4 6 3 6 6 7 7 7 7 7 7 2 6 6 4 5 6 7 5 6 7 7 7 6 7 6 7 7 6 7 6 6 5 6 5 7 4 7 7 7 7 7 2 6 6 5 3 7 4 5 6 7 7 7 6 7 5 5 6 6 5 5 4 7 2 7 5 5 7 6 5 7 7 2 6 4 4 3 6 1 6 5 4 4 4 5 4 5 2 5 3 5 5 3 6 5 6 4 6 7 5 6 4 3 7 3 3 2 3 4 5 6 6 4 4 4 5 4 3 2 5 5 5 5 5 6 4 7 4 6 7 6 6 7 5 7 5 3 3 5 4 6 7 4 5 7 7 5 7 6 7 7 7 7 5 5 6 7 4 7 6 7 5 5 5 7 4 7 4 4 4 7 5 7 5 7 5 5 5 5 4 7 6 3 5 7 5 7 5 7 6 6 5 6 5 7 7 4 4 7 5 7 6 7 6 7 6 5 5 7 7 3 3 7 4 7 5 7 5 7 6 5 5 5 4 2 2 4 5 6 3 5 4 6 5 6 6 1 6 4 6 5 3 7 3 6 4 6 5 6 6 6 6 4 4 6 7 5 6 6 7 6 6 5 7 7 7 7 7 6 7 6 6 4 6 5 7 6 6 3 4 6 5 7 6 6 5 4 6 5 6 6 5 5 7 7 7 3 7 6 4 5 7 7 6 6 7 6 7 7 6 7 7 5 7 6 6 5 7 5 6 1 5 3 6 6 5 6 5 7 5 6 5 5 7 4 7 7 6 3 7 7 6 5 7 5 4 7 6 7 6 6 7 7 5 5 7 7 7 7 7 6 5 6 4 5 6 6 6 3 6 6 5 6 6 7 6 5 6 6 7 6 6 7 7 5 7 7 5 6 7 6 6 6 7 7 6 6 7 7 5 5 7 7 7 7 7 6 5 6 5 5 4 7 7 3 6 6 5 6 5 7 5 5 7 4 7 6 7 7 7 4 7 7 5 7 7 5 6 7 3 6 5 6 7 7 5 5 7 7 5 5 7 6 5 6 6 4 3 4 6 4 7 5 5 6 5 5 6 5 7 3 6 6 6 7 5 4 7 7 5 5 7 7 6 5 1 4 5 3 7 7 6 5 5 7 5 5 3 2 6 4 4 3 3 6 5 3 5 4 4 5 4 4 4 5 6 3 5 4 6 3 4 4 3 5 6 3 6 6 6 6 6 5 5 4 7 7 6 5 6 7 5 7 7 2 6 4 5 3 3 3 6 3 5 4 5 6 5 4 4 5 6 3 5 5 7 5 5 4 5 6 6 4 7 5 6 7 7 4 6 6 7 6 7 5 5 6 3 7 4 7 7 6 5 7 6 7 7 6 4 6 7 7 7 7 7 6 1 7 3 6 7 5 6 7 6 7 7 7 7 6 7 7 7 7 7 6 3 7 6 7 7 5 6 4 6 5 7 7 7 6 7 7 7 7 7 6 5 7 6 7 7 5 6 4 7 5 7 4 7 6 7 7 6 7 4 4 3 5 5 7 7 5 6 6 7 6 5 6 6 6 2 4 7 6 3 5 3 3 5 2 4 5 6 5 4 6 6 6 5 6 4 7 7 5 4 5 4 6 5 6 4 6 5 6 4 5.77027027 5.743243243 5.952702703 5.932432432 5.337837838 4.689189189 5.256756757 1.190064279 1.278400476 1.138888702 1.193304234 1.402398597 1.456168448 1.262335712 148 148 148 148 148 148 148 Imp_Entertai Imp_Atmosp Imp_Commu Imp_GoodTi Store_Qualit n here nity me y Imp_Service Imp_Slow 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Not important 4=Neutral 7=Very important 1=Poor performance 4=Neutral 7=Good performance 7 6 6 3 3 6 5 4 5 7 6 7 6 6 7 7 7 6 5 5 5 2 4 3 5 3 7 7 6 5 6 5 4 5 5 3 5 4 4 5 3 4 5 7 7 4 5 5 6 6 6 6 4 6 5 5 4 3 5 7 7 5 6 5 5 5 5 3 5 5 2 5 4 7 5 7 7 5 6 5 6 6 4 4 4 2 2 5 3 7 5 7 7 6 7 6 6 4 4 3 3 5 5 4 6 6 6 4 5 6 5 5 3 5 6 7 7 4 5 4 7 5 3 7 4 6 5 4 6 5 5 3 5 4 5 1 3 5 4 7 5 3 4 4 5 6 5 3 6 5 5 5 4 3 1 3 5 3 6 5 3 3 6 6 5 6 5 5 6 4 6 3 3 1 3 6 3 4 5 3 6 5 5 4 5 4 4 6 5 5 5 5 7 3 3 2 4 5 4 4 6 6 4 4 5 4 6 4 4 3 2 1 3 6 2 6 6 6 6 5 6 7 6 2 7 3 5 5 6 6 5 5 5 4 5 5 4 5 6 5 6 6 6 2 5 6 5 6 5 4 3 7 5 6 7 6 6 7 6 7 5 5 3 5 5 5 7 6 7 7 3 5 7 5 3 6 3 5 4 6 5 4 5 4 3 4 2 3 4 4 7 3 5 3 4 4 4 5 5 1 7 7 4 7 5 1 6 4 5 4 5 4 3 2 4 3 2 5 4 6 5 6 5 2 2 4 2 5 5 7 5 7 1 5 7 6 2 6 5 5 5 4 4 3 4 3 4 7 5 4 6 4 5 4 3 4 5 3 3 6 3 1 7 7 3 4 6 3 6 6 5 5 7 5 6 7 4 5 6 4 7 3 6 7 5 3 4 5 3 2 6 5 5 7 6 5 5 6 6 6 6 5 6 7 5 6 6 4 4 7 4 3 3 5 7 4 4 5 6 4 6 7 6 7 7 7 5 7 2 5 5 5 6 6 6 6 4 5 4 6 6 7 7 6 6 7 6 6 6 6 4 6 5 7 4 7 3 3 7 6 5 4 7 4 7 4 6 5 5 4 6 6 4 4 4 4 4 3 5 4 6 5 6 4 1 5 4 5 2 3 4 4 6 4 6 5 5 4 4 5 5 5 2 5 4 3 6 4 6 5 6 4 1 6 4 2 5 2 6 4 5 4 6 5 6 5 7 6 3 3 4 4 5 4 5 4 7 4 6 5 1 6 5 4 6 4 6 6 6 5 7 6 5 4 6 7 5 5 5 7 7 7 5 6 7 7 7 7 2 6 5 4 4 3 2 7 5 5 6 5 4 5 4 5 5 5 3 4 7 6 5 6 4 6 7 6 5 7 6 3 6 4 4 5 4 7 5 6 5 5 7 5 3 5 2 5 5 4 4 3 7 6 4 3 6 4 4 6 5 4 5 4 4 4 5 6 5 3 4 4 5 5 3 5 5 4 4 2 4 4 3 7 5 6 5 6 5 5 1 2 4 6 4 5 3 3 5 2 3 3 6 4 3 4 5 6 6 4 5 2 4 4 2 4 3 4 6 5 4 2 4 4 4 3 4 5 3 7 7 6 5 4 6 5 1 2 4 6 5 4 4 3 5 5 3 3 6 4 3 5 6 5 6 5 5 5 4 5 2 2 5 4 6 5 4 5 5 4 5 1 4 2 3 7 7 6 5 6 7 7 1 7 4 6 4 4 4 3 6 6 1 3 6 4 3 6 6 4 7 4 6 6 3 6 5 6 6 4 6 7 5 4 6 4 6 4 3 5 5 7 7 6 5 6 7 5 4 1 4 6 6 5 4 5 7 7 3 3 6 6 5 5 5 6 6 4 5 4 7 6 5 2 3 4 5 7 4 4 5 6 3 5 6 4 5 5 5 5 5 4 7 5 2 4 5 5 6 6 4 5 4 6 3 5 5 5 6 4 6 5 6 4 6 7 6 4 6 7 7 7 6 7 6 7 5 5 6 4 6 5 6 6 5 6 4 5 4 6 4 7 2 5 1 4 3 5 3 4 4 2 1 6 6 6 4 5 3 6 2 7 1 5 4 3 3 5 1 6 5 4 6 5 4 5 4 5 3 6 4 6 1 6 6 3 3 5 3 5 2 2 6 4 5 6 4 5 6 6 4 6 1 6 4 3 7 5 1 6 4 1 4 5 5 5 4 5 2 5 4 6 1 6 2 3 2 4 2 7 3 3 6 6 5 6 5 6 6 6 6 3 6 5 7 7 4 3 4 7 6 7 5 6 6 6 5.43537415 4.513513514 4.277027027 4.445945946 4.797297297 4.844594595 5.333333333 1.277133065 1.38252695 1.441941935 1.444123837 1.520649071 1.554947504 1.090713149 147 148 148 148 148 148 117 Store_Specia Store_Health Store_Fresh Store_Price l y Store_Look 1=Poor performance 4=Neutral 7=Good performance 1=Poor performance 4=Neutral 7=Good performance 1=Poor performance 4=Neutral 7=Good performance 1=Poor performance 4=Neutral 7=Good performance Store_Organi Store_Local c 1=Poor performance 4=Neutral 7=Good performance 1=Poor performance 4=Neutral 7=Good performance 1=Poor performance 4=Neutral 7=Good performance 5 6 6 7 3 5 6 3 4 4 4 6 4 6 3 6 5 4 6 5 5 2 6 6 3 4 7 5 1 6 6 7 5 4 6 4 5 6 7 4 4 5 4 5 4 3 6 5 6 1 7 5 1 7 3 1 7 3 6 7 5 6 7 5 5 7 2 4 5 2 5 3 4 5 5 6 5 5 6 6 5 6 5 4 4 4 4 6 6 5 2 4 5 4 4 3 2 4 5 4 5 6 6 3 5 6 4 5 5 5 3 5 3 6 5 5 5 5 6 6 4 4 5 3 3 2 7 5 5 4 4 5 4 6 5 6 2 3 2 4 7 5 3 4 5 4 5 5 4 3 2 5 5 5 5 4 5 6 5 7 5 4 4 5 5 6 6 5 5 5 6 4 4 6 3 5 6 6 5 6 6 4 6 5 3 6 6 3 6 5 6 6 6 4 4 4 6 6 4 6 6 6 7 7 6 7 6 5 6 5 7 5 5 6 5 3 5 4 5 5 5 5 6 7 6 5 5 5 6 6 4 6 5 3 6 4 5 5 5 4 6 7 6 5 6 5 5 5 6 6 6 5 5 6 6 6 7 7 6 7 6 5 5 5 5 4 6 7 7 5 5 6 6 5 7 6 6 7 6 5 5 5 6 4 7 7 6 4 5 4 4 4 5 3 4 4 5 5 6 5 6 3 6 5 6 4 5 4 2 4 4 6 4 4 5 6 6 6 4 6 5 6 6 6 4 6 6 6 6 6 4 6 6 6 6 6 4 6 6 6 6 6 4 6 7 6 5 4 4 4 7 6 5 4 4 5 5 5 4 5 7 6 5 6 6 7 6 4 3 5 4 5 6 6 4 7 5 5 6 4 2 6 4 3 6 6 6 5 6 6 6 5 6 6 5 4 5 4 5 5 5 5 6 5 4 4 7 6 4 5 4 5 6 6 5 5 5 6 4 6 4 4 6 6 5 5 3 5 6 7 4 6 5 3 7 5 6 5 5 5 5 4 5 5 7 5 2 4 5 6 6 6 5 7 5 5 4 5 6 5 5 5 5 7 4 5 3 5 6 5 5 4 7 4 4 4 6 5 5 5 5 4 7 4 5 3 5 7 5 5 3 7 4 6 5 5 5 5 5 5 4 6 5 2 6 5 6 6 5 5 6 4 5 5 5 4 5 6 5 4 4 6 1 7 5 6 5 4 6 6 2 3 4 4 5 6 6 5 4 5 4 1 1 4 5 5 4 7 6 2 3 4 4 5 6 5 5 4 4 4 1 1 4 6 5 4 7 5 4 6 6 7 6 5 4 7 7 4 7 4 4 5 2 5 6 5 5 2 4 5 4 6 1 5 5 4 6 2 5 6 4 5 3 6 5 4 4 4 3 5 4 4 1 5 4 5 6 4 5 5 5 5 6 6 6 4 5 4 5 4 4 5 6 6 4 3 5 5 4 4 4 4 6 6 2 4 5 4 6 5 6 5 6 7 5 4 6 4 6 5 5 4 5 6 3 5 6 4 6 4 4 6 4 5 4 3 6 3 6 4 5 5 4 6 4 4 6 6 5 5 3 6 6 7 7 3 4 4 7 6 7 5 6 6 6 6 6 4 6 1 5 7 6 2 4 4 5 7 6 7 5 6 6 5 6 4 5 6 1 5 7 5 2 4 3 4 6 5 7 5 5 6 6 6 6 5 6 1 5 5 7 7 3 2 6 7 6 7 6 4 5 5 6 6 4 6 4 6 7 5 4 3 1 5 6 7 7 5 5 6 4 3 6 5 6 4 5 5 6 7 1 3 4 5 5 5 4 5 6 5 3 5 4 6 4 5 7 7 7 2 4 6 5 6 5 5 4 5 4 5.324786325 4.837606838 4.88034188 5.239316239 5.170940171 4.606837607 4.641025641 1.12823527 1.279528907 1.274162288 1.257046159 1.288480783 1.292933479 1.255755978 117 117 117 117 117 117 117 Store_Seaso Store_Uniqu n Store_Range e Store_Try