Hi, i am working in a case named: GoodBelly: Using Statistics to Justify the Marketing Expense. is not clear what i should do.I bought the membership because I saw that there was a document explaining...

Hi, i am working in a case named: GoodBelly: Using Statistics to Justify the Marketing Expense. is not clear what i should do.I bought the membership because I saw that there was a document explaining the answer. As i am attaching, it only shows the answers in text and I want to know the solution in excel so I can learn the steps to solve it. Would you please advice me. Thank you and have a great day.


Explanation Explanation of GoodBelly Sales Spreadsheet The data came from 126 Whole Foods stores over the 10 weeks between May 4 and July 13. There was a total of 1,386 observations. Variable Definitions 1Weekly Sales (Volume): The number of units sold per store per week. 2Average Retail Price: The average retail price for GoodBelly products per store per week. 3Sales Rep: Defined as 1 if the store had a regional sales rep (face-to-face contact) and 0 if the store had only the national sales rep (no face-to-face contact). 4Endcap: Defined as 1 if a store participated in an endcap promotion. 5Demo: Defined as 1 if the store had a demo on the corresponding week. 6Demo1-3: Defined as 1 if the store had a demo 1-3 weeks ago. 7Demo4-5: Defined as 1 if the store had a demo at least 4-5 weeks ago. 8Natural Retailers: The number of other natural retailers within 5 miles of each store. 9Fitness Centers: The number of fitness centers within 5 miles of each store. Real Data DateRegionStoreUnits SoldAverage Retail PriceSales RepEndcapDemoDemo1-3Demo4-5NaturalFitness 5/4/10FLBiscayne (aka Aventura)150.70208791274.390000010 5/11/10FLBiscayne (aka Aventura)197.40379746163.9976923080000010 5/18/10FLBiscayne (aka Aventura)235.10617151573.8092307690000010 5/25/10FLBiscayne (aka Aventura)226.69242729243.8350000010 6/1/10FLBiscayne (aka Aventura)257.68815075813.90250000010 6/8/10FLBiscayne (aka Aventura)132.957189784.4976923080000010 6/15/10FLBiscayne (aka Aventura)221.88996854774.1166666670000010 6/22/10FLBiscayne (aka Aventura)245.88135635494.1166666670000010 6/29/10FLBiscayne (aka Aventura)156.10253495214.1166666670000040 7/6/10FLBiscayne (aka Aventura)200.10396603553.7473333330000010 7/13/10FLBiscayne (aka Aventura)128.39600335344.01250000010 5/4/10FLBoca Raton142.77821016194.390000004 5/11/10FLBoca Raton237.54455427214.2354545450000004 5/18/10FLBoca Raton141.53329677413.8092307690000004 5/25/10FLBoca Raton158.07394923633.8092307690000004 6/1/10FLBoca Raton255.11774339934.0556250000004 6/8/10FLBoca Raton129.79362652894.3833333330000004 6/15/10FLBoca Raton137.76428505274.358750000004 6/22/10FLBoca Raton306.79381870654.358750000004 6/29/10FLBoca Raton103.31902266754.358750000004 7/6/10FLBoca Raton240.22517723014.01250000004 7/13/10FLBoca Raton190.02480103064.01250000004 5/4/10FLCoral Gables149.76787147124.5185714290000021 5/11/10FLCoral Gables223.6127594273.720000021 5/18/10FLCoral Gables216.36969551663.7936363640000021 5/25/10FLCoral Gables205.53494026213.9040000021 6/1/10FLCoral Gables131.62652953314.0433333330000021 6/8/10FLCoral Gables199.93391075024.4066666670100021 6/15/10FLCoral Gables217.95188990664.358750100021 6/22/10FLCoral Gables139.61353155344.390100021 6/29/10FLCoral Gables106.41656568614.5207692310100021 7/6/10FLCoral Gables203.74320370763.9015384620100021 7/13/10FLCoral Gables159.43369536644.1935714290000021 5/4/10FLCoral Springs305.18329023184.490000111 5/11/10FLCoral Springs235.4571090174.4011111110000111 5/18/10FLCoral Springs239.69490187973.8092307690000011 5/25/10FLCoral Springs220.94679052994.0640000011 6/1/10FLCoral Springs233.32600297583.9578571430000011 6/8/10FLCoral Springs143.79479905433.690000011 6/15/10FLCoral Springs192.92288859284.6438461540000011 6/22/10FLCoral Springs134.71292337334.3650000011 6/29/10FLCoral Springs118.93892330314.6438461540000011 7/6/10FLCoral Springs206.22037266823.9015384620000011 7/13/10FLCoral Springs149.38332773594.1016666670000011 5/4/10FLFort Lauderdale152.3502851724.3733333330000032 5/11/10FLFort Lauderdale118.76812387154.0366666670000032 5/18/10FLFort Lauderdale147.81766512793.8435714290000032 5/25/10FLFort Lauderdale199.09332638814.0553846150000032 6/1/10FLFort Lauderdale160.96977035983.8435714290000032 6/8/10FLFort Lauderdale204.55912904324.1042857140000032 6/15/10FLFort Lauderdale189.28982781314.1166666670000032 6/22/10FLFort Lauderdale177.42078362714.1042857140000032 6/29/10FLFort Lauderdale173.99129602774.1166666670000032 7/6/10FLFort Lauderdale141.86786679213.7085714290000032 7/13/10FLFort Lauderdale232.06234637483.7085714290000032 5/4/10FLPalm Beach Gardens179.03076002824.5592307690000014 5/11/10FLPalm Beach Gardens238.2752855644.208750000014 5/18/10FLPalm Beach Gardens163.09534122554.0556250000014 5/25/10FLPalm Beach Gardens239.57606242374.0556250000014 6/1/10FLPalm Beach Gardens204.93451075924.0556250000014 6/8/10FLPalm Beach Gardens156.40946381164.3833333330000014 6/15/10FLPalm Beach Gardens242.6888071714.470000014 6/22/10FLPalm Beach Gardens239.12351100954.470000014 6/29/10FLPalm Beach Gardens199.01339937794.0983333330000014 7/6/10FLPalm Beach Gardens107.13302889144.1935714290000014 7/13/10FLPalm Beach Gardens241.64242867984.3714285710000014 5/4/10FLPlantation201.31407102864.390000025 5/11/10FLPlantation132.29828345054.390000025 5/18/10FLPlantation165.56829520874.0127272730000025 5/25/10FLPlantation191.69830370073.8092307690000025 6/1/10FLPlantation182.73938911764.1466666670000025 6/8/10FLPlantation209.0979724474.358750000025 6/15/10FLPlantation239.34123096424.358750000025 6/22/10FLPlantation137.87190068514.1166666670000025 6/29/10FLPlantation238.4028120164.3361538460000025 7/6/10FLPlantation237.22506320124.0930769230000025 7/13/10FLPlantation111.44654122924.0930769230000025 5/4/10FLSarasota128.69191142114.390000013 5/11/10FLSarasota281.94862788184.390000013 5/18/10FLSarasota197.53479107574.1450000013 5/25/10FLSarasota265.47862152684.2166666670100013 6/1/10FLSarasota230.48953775143.9578571430100013 6/8/10FLSarasota119.22865867614.1166666670100013 6/15/10FLSarasota172.05145587074.2185714290100013 6/22/10FLSarasota189.20587625554.5971428570100013 6/29/10FLSarasota222.53856116444.1042857140100013 7/6/10FLSarasota115.90130641413.9078571430000013 7/13/10FLSarasota177.09896642683.9940000013 5/4/10MAAnnapolis155.87295042613.9042857140000011 5/11/10MAAnnapolis193.51021803013.540000011 5/18/10MAAnnapolis309.49467078273.4809090910000011 5/25/10MAAnnapolis254.92885294653.5983333330000011 6/1/10MAAnnapolis195.30839872113.4809090910000011 6/8/10MAAnnapolis267.93874264334.0566666670010011 6/15/10MAAnnapolis247.13009632274.0566666670001011 6/22/10MAAnnapolis299.34168500633.7145454550001011 6/29/10MAAnnapolis265.72152913234.040001011 7/6/10MAAnnapolis259.04277945963.7116666670000111 7/13/10MAAnnapolis280.6576747153.7116666670000111 5/4/10MABethesda138.2312258583.940000033 5/11/10MABethesda263.23886655753.5233333330000033 5/18/10MABethesda119.9619815243.5471428570000033 5/25/10MABethesda212.36199176663.440000033 6/1/10MABethesda167.08937074643.5471428570000033 6/8/10MABethesda293.52183413813.5233333330110033 6/15/10MABethesda207.8206997113.62750101033 6/22/10MABethesda273.70825654063.62750101033 6/29/10MABethesda252.2503762453.5233333330101033 7/6/10MABethesda299.6356855133.196250100133 7/13/10MABethesda305.56784938343.196250100133 5/4/10MACedar Center170.70252409513.9042857140000022 5/11/10MACedar Center115.68799780223.9042857140000022 5/18/10MACedar Center162.40568885033.6185714290000022 5/25/10MACedar Center257.48777303143.77750000022 6/1/10MACedar Center248.69065608193.77750000022 6/8/10MACedar Center151.29341196613.75250000022 6/15/10MACedar Center155.60504802353.9444444440000022 6/22/10MACedar Center110.56019874443.8566666670000022 6/29/10MACedar Center233.25920301363.9677777780000022 7/6/10MACedar Center228.32504147053.4733333330000022 7/13/10MACedar Center221.79105343313.4733333330000022 5/4/10MAColumbus326.96440424364.1185714290000104 5/11/10MAColumbus172.1360212344.12750000104 5/18/10MAColumbus209.29898754633.6185714290000004 5/25/10MAColumbus158.70198965863.756250000004 6/1/10MAColumbus203.48322561973.77750000004 6/8/10MAColumbus183.09666170843.6344444440000004 6/15/10MAColumbus162.39531158883.75250000004 6/22/10MAColumbus372.16674821313.7354545450010004 6/29/10MAColumbus389.75935425643.7354545450001004 7/6/10MAColumbus302.68255911693.4950001004 7/13/10MAColumbus301.8969483473.4950001004 5/4/10MAFair Lakes137.12077837143.9042857140000031 5/11/10MAFair Lakes184.92340118483.540000031 5/18/10MAFair Lakes169.83557348783.340000031 5/25/10MAFair Lakes219.35191068163.340000031 6/1/10MAFair Lakes148.64037025483.340000031 6/8/10MAFair Lakes292.90619429113.540000031 6/15/10MAFair Lakes222.27630722953.540000031 6/22/10MAFair Lakes148.1474343263.6344444440000031 6/29/10MAFair Lakes270.1418702823.75250000031 7/6/10MAFair Lakes194.17912340553.2511111110000031 7/13/10MAFair Lakes170.53767932683.1260000031 5/4/10MAGeorgetown171.56586569393.6185714290000020 5/11/10MAGeorgetown227.65606238923.6185714290000020 5/18/10MAGeorgetown186.2484724673.340000020 5/25/10MAGeorgetown235.94996755383.3566666670000020 6/1/10MAGeorgetown193.89605758073.340000020 6/8/10MAGeorgetown293.98212083793.540010020 6/15/10MAGeorgetown288.09687412343.540001020 6/22/10MAGeorgetown220.34523058553.5233333330001020 6/29/10MAGeorgetown309.77610469023.6344444440001020 7/6/10MAGeorgetown252.82365819023.1260000120 7/13/10MAGeorgetown274.33208209993.196250000120 5/4/10MAJenkintown221.17930909323.9042857140000014 5/11/10MAJenkintown213.02564125963.9042857140000014 5/18/10MAJenkintown239.8165698373.6185714290000014 5/25/10MAJenkintown230.5775988013.6185714290000014 6/1/10MAJenkintown192.07886176183.6185714290000014 6/8/10MAJenkintown241.41485464343.9042857140000014 6/15/10MAJenkintown129.92389501923.9042857140000014 6/22/10MAJenkintown186.5729841463.540000014 6/29/10MAJenkintown349.81802167753.540010014 7/6/10MAJenkintown285.29345392373.1260001014 7/13/10MAJenkintown272.7344724623.2511111110001014 5/4/10MAKentlands133.16738407453.9042857140000030 5/11/10MAKentlands228.09061092693.540000030 5/18/10MAKentlands169.67140976613.340000030 5/25/10MAKentlands182.00033620033.50250000030 6/1/10MAKentlands249.75552396183.340000030 6/8/10MAKentlands200.27799422553.540000030 6/15/10MAKentlands203.47503719573.540010030 6/22/10MAKentlands344.80229826183.540001030 6/29/10MAKentlands266.01853365353.6344444440001030 7/6/10MAKentlands299.90550581873.1260001030 7/13/10MAKentlands332.74298398663.0633333330000130 5/4/10MALouisville245.79503869793.9677777780000042 5/11/10MALouisville215.64611869384.0566666670000042 5/18/10MALouisville138.30679100463.5983333330000042 5/25/10MALouisville201.37415502883.5983333330000042 6/1/10MALouisville256.98591142023.5983333330000042 6/8/10MALouisville188.10437388214.0566666670000042 6/15/10MALouisville124.38985083624.0566666670000042 6/22/10MALouisville156.17406821343.7354545450000042 6/29/10MALouisville288.23260903924.0566666670000042 7/6/10MALouisville148.26599974063.7116666670000042 7/13/10MALouisville142.45749506643.7116666670000042 5/4/10MAMarlton257.28028934433.7614285710000030 5/11/10MAMarlton164.2759468213.5233333330000030 5/18/10MAMarlton80.52511822993.3566666670000030 5/25/10MAMarlton271.65775763583.340000030 6/1/10MAMarlton208.29025637313.440000030 6/8/10MAMarlton332.28145488763.5111111110010030 6/15/10MAMarlton314.43788867173.5233333330001030 6/22/10MAMarlton305.09423830563.5233333330001030 6/29/10MAMarlton224.2860161333.5233333330001030 7/6/10MAMarlton215.47607854893.0633333330000130 7/13/10MAMarlton322.69748275183.0633333330000130 5/4/10MAMount Washington237.71606292693.9042857140000000 5/11/10MAMount Washington149.31694764543.9042857140000000 5/18/10MAMount Washington103.89607680243.6185714290000000 5/25/10MAMount Washington141.20900644913.6185714290000000 6/1/10MAMount Washington216.53256257873.6185714290000000 6/8/10MAMount Washington352.43026335583.9042857140010000 6/15/10MAMount Washington186.66780828773.9042857140001000 6/22/10MAMount Washington290.77960308463.9042857140001000 6/29/10MAMount Washington273.34371354113.9042857140001000 7/6/10MAMount Washington299.30554824713.6085714290000100 7/13/10MAMount Washington249.27424817533.6085714290000100 5/4/10MAOld Town113.51073122783.9042857140000014 5/11/10MAOld Town267.5313899743.540000014 5/18/10MAOld Town175.82855388863.340000014 5/25/10MAOld Town235.56756669023.4122222220000014 6/1/10MAOld Town151.33727037313.340000014 6/8/10MAOld Town211.42324552063.6344444440000014 6/15/10MAOld Town272.30203800983.540000014 6/22/10MAOld Town163.02528919563.540000014 6/29/10MAOld Town170.96248093173.540000014 7/6/10MAOld Town176.15168917133.1260000014 7/13/10MAOld Town145.65043161863.1260000014 5/4/10MAP Street136.57308462174.12750000014 5/11/10MAP Street274.90949048063.540000014 5/18/10MAP Street201.68844724813.5983333330000014 5/25/10MAP Street173.8882741593.5983333330000014 6/1/10MAP Street253.9583351373.5983333330000014 6/8/10MAP Street236.74914768854.0566666670000014 6/15/10MAP Street269.81424529994.0566666670000014 6/22/10MAP Street348.9255605654.0566666670010014 6/29/10MAP Street243.08811096154.0566666670001014 7/6/10MAP Street273.53225253923.7116666670001014 7/13/10MAP Street286.31471586883.7116666670001014 5/4/10MAPhiladelphia156.63099861083.9042857140000042 5/11/10MAPhiladelphia170.64443579453.6344444440000042 5/18/10MAPhiladelphia186.3977397793.340000042 5/25/10MAPhiladelphia250.87647476693.4122222220000042 6/1/10MAPhiladelphia199.68927943413.4042857140000042 6/8/10MAPhiladelphia148.63493356993.9042857140000042 6/15/10MAPhiladelphia320.93990137443.9042857140000042 6/22/10MAPhiladelphia187.72749178353.9042857140000042 6/29/10MAPhiladelphia235.12672575023.9042857140000042 7/6/10MAPhiladelphia215.6434901373.6085714290000042 7/13/10MAPhiladelphia215.02602948313.6085714290000042 5/4/10MAPrinceton163.57883685324.1371428570000003 5/11/10MAPrinceton240.14283873373.740000003 5/18/10MAPrinceton173.96435568033.6566666670000003 5/25/10MAPrinceton208.72591854663.340000003 6/1/10MAPrinceton241.91298963213.4809090910000003 6/8/10MAPrinceton199.3725547283.7354545450000003 6/15/10MAPrinceton128.15942831423.7354545450000003 6/22/10MAPrinceton294.96157728923.7354545450010003 6/29/10MAPrinceton174.59030084073.8290001003 7/6/10MAPrinceton336.47344563453.3590909090001003 7/13/10MAPrinceton307.93997790923.3590909090001003 5/4/10MARockville171.96581401523.9042857140000014 5/11/10MARockville254.49795626023.9042857140000014 5/18/10MARockville169.60365591753.340000014 5/25/10MARockville128.23626008813.340000014 6/1/10MARockville220.5186312173.340000014 6/8/10MARockville262.89154945943.540000014 6/15/10MARockville309.22053610953.540000014 6/22/10MARockville243.57384414623.540010014 6/29/10MARockville234.53430483473.540001014 7/6/10MARockville323.54789319543.1260001014 7/13/10MARockville298.39008078083.1260001014 5/4/10MAShort Pump202.68989714053.9042857140000001 5/11/10MAShort Pump277.15210037893.9042857140000001 5/18/10MAShort Pump184.94136353843.77750000001 5/25/10MAShort Pump269.42854473613.6185714290000001 6/1/10MAShort Pump226.95314536583.50250000001 6/8/10MAShort Pump51.7332929953.9677777780000001 6/15/10MAShort Pump215.3091665143.75250000001 6/22/10MAShort Pump261.72053085793.840000001 6/29/10MAShort Pump196.77380542413.840000001 7/6/10MAShort Pump141.00011784053.3671428570000001 7/13/10MAShort Pump201.60322196633.6611111110000001 5/4/10MATysons185.37632585973.75250000005 5/11/10MATysons220.86064395053.540000005 5/18/10MATysons180.1324640293.340000005 5/25/10MATysons221.74469588343.340000005 6/1/10MATysons196.86668249093.4122222220000005 6/8/10MATysons233.50110614043.6344444440000005 6/15/10MATysons312.23762343553.75250010005 6/22/10MATysons257.85305302923.6344444440001005 6/29/10MATysons276.04987380444.0566666670001005 7/6/10MATysons330.71675967313.1260001005 7/13/10MATysons320.61071730513.5318181820000105 5/4/10MAVienna204.41295499283.5650000014 5/11/10MAVienna177.70281425183.540000014 5/18/10MAVienna98.09849847753.340000014 5/25/10MAVienna177.76132147393.4122222220000014 6/1/10MAVienna213.89909382713.340000014 6/8/10MAVienna193.923991963.6344444440000014 6/15/10MAVienna201.35267809533.4757142860000014 6/22/10MAVienna195.1513436983.540000014 6/29/10MAVienna177.59046764433.540000014 7/6/10MAVienna173.67382968033.1260000014 7/13/10MAVienna158.11965911233.40750000014 5/4/10MWAnn Arbor171.02147572744.191000023 5/11/10MWAnn Arbor213.92718229934.691000023 5/18/10MWAnn Arbor303.14183200224.15251000023 5/25/10MWAnn Arbor234.53057870334.3011111111000023 6/1/10MWAnn Arbor269.08567967813.6718181821000023 6/8/10MWAnn Arbor300.54842234734.0627272731000023 6/15/10MWAnn Arbor288.18018444764.391010023 6/22/10MWAnn Arbor396.24958198364.391011023 6/29/10MWAnn Arbor256.55013742943.7354545451001023 7/6/10MWAnn Arbor295.89900395933.9107692311001023 7/13/10MWAnn Arbor456.46658982844.1116666671001123 5/4/10MWDeerfield309.36771364144.6122222221000033 5/11/10MWDeerfield350.6653639784.591000033 5/18/10MWDeerfield346.59224842683.7651000033 5/25/10MWDeerfield265.65104041133.7130769231000033 6/1/10MWDeerfield288.29235551994.1354545451000033 6/8/10MWDeerfield344.05808966364.0757142861010033 6/15/10MWDeerfield308.46141357434.0757142861001033 6/22/10MWDeerfield350.90474275053.591001033 6/29/10MWDeerfield333.06564616684.0566666671001033 7/6/10MWDeerfield352.88012995693.3735714291000133 7/13/10MWDeerfield348.12137023244.1141000133 5/4/10MWGalleria314.5617653764.1677777781000014 5/11/10MWGalleria197.92662824564.1677777781000014 5/18/10MWGalleria204.79183871783.5438461541000014 5/25/10MWGalleria181.47405578133.641000014 6/1/10MWGalleria287.24276312413.5438461541000014 6/8/10MWGalleria112.29142219533.7746153851000014 6/15/10MWGalleria232.40187786123.8185714291000014 6/22/10MWGalleria227.4403156353.8185714291000014 6/29/10MWGalleria279.66236109473.8185714291000014 7/6/10MWGalleria253.47303799023.3735714291000014 7/13/10MWGalleria231.8325685753.3735714291000014 5/4/10MWGold Coast207.1220684834.6122222221000015 5/11/10MWGold Coast191.00311729794.6122222221000015 5/18/10MWGold Coast209.2027526141000015 5/25/10MWGold Coast334.17134472153.8344444441000015 6/1/10MWGold Coast269.53593854133.731000015 6/8/10MWGold Coast345.82663493454.0966666671000015 6/15/10MWGold Coast232.05936022484.0757142861000015 6/22/10MWGold Coast196.24413258754.0966666671000015 6/29/10MWGold Coast269.96410556014.0757142861000015 7/6/10MWGold Coast256.61489032813.53751000015 7/13/10MWGold Coast244.19387147273.4963636361000015 5/4/10MWLake Calhoun (aka Minneapolis)173.61154686244.551000012 5/11/10MWLake Calhoun (aka Minneapolis)279.7689365954.0233333331000012 5/18/10MWLake Calhoun (aka Minneapolis)237.15464873063.731000012 5/25/10MWLake Calhoun (aka Minneapolis)253.02384445593.731000012 6/1/10MWLake Calhoun (aka Minneapolis)208.05758340613.8983333331000012 6/8/10MWLake Calhoun (aka Minneapolis)275.39538339134.0966666671000012 6/15/10MWLake Calhoun (aka Minneapolis)272.44503641554.6185714291000012 6/22/10MWLake Calhoun (aka Minneapolis)257.05647617174.0966666671000012 6/29/10MWLake Calhoun (aka Minneapolis)347.23463269464.341010012 7/6/10MWLake Calhoun (aka Minneapolis)288.62490884353.6813333331001012 7/13/10MWLake Calhoun (aka Minneapolis)330.85900805443.6307142861001012 5/4/10MWLakeview66.3866532144.6122222221000023 5/11/10MWLakeview267.69017284574.6122222221000023 5/18/10MWLakeview191.368189952841000023 5/25/10MWLakeview285.85885156853.9566666671000023 6/1/10MWLakeview275.69384398763.6718181821000023 6/8/10MWLakeview226.22608339644.0757142861000023 6/15/10MWLakeview413.47796122723.7746153851010023 6/22/10MWLakeview326.33147594034.0757142861001023 6/29/10MWLakeview460.86903184594.4757142861011023 7/6/10MWLakeview352.87791379993.6813333331001023 7/13/10MWLakeview412.95908735453.4783333331001123 5/4/10MWMilwaukee248.86945673154.1677777781000033 5/11/10MWMilwaukee332.24424225444.1677777781000033 5/18/10MWMilwaukee309.7899002423.7651000033 5/25/10MWMilwaukee201.857032758641000033 6/1/10MWMilwaukee245.53821815823.8344444441000033 6/8/10MWMilwaukee210.86976212834.1677777781000033 6/15/10MWMilwaukee359.96152749424.2081818181010033 6/22/10MWMilwaukee263.16596012924.5354545451001033 6/29/10MWMilwaukee370.37297953194.3566666671001033 7/6/10MWMilwaukee242.76983137443.8845454551001033 7/13/10MWMilwaukee375.24808120553.8845454551000133 5/4/10MWNew Lincoln Park (aka Lincoln Park)157.72699360894.551000025 5/11/10MWNew Lincoln Park (aka Lincoln Park)301.3081807814.8627272731000025 5/18/10MWNew Lincoln Park (aka Lincoln Park)238.59306467414.1354545451000025 5/25/10MWNew Lincoln Park (aka Lincoln Park)315.8942060324.1354545451000025 6/1/10MWNew Lincoln Park (aka Lincoln Park)220.09814715774.1354545451000025 6/8/10MWNew Lincoln Park (aka Lincoln Park)368.0769799294.341010025 6/15/10MWNew Lincoln Park (aka Lincoln Park)325.72575593214.0966666671001025 6/22/10MWNew Lincoln Park (aka Lincoln Park)379.68786971174.121011025 6/29/10MWNew Lincoln Park (aka Lincoln Park)348.65699907324.0893751001025 7/6/10MWNew Lincoln Park (aka Lincoln Park)416.25373131763.9506251001125 7/13/10MWNew Lincoln Park (aka Lincoln Park)471.98484406083.9506251001125 5/4/10MWNorthbrook359.43146397963.51000023 5/11/10MWNorthbrook261.99623314913.51000023 5/18/10MWNorthbrook246.9966879573.5076923081000023 5/25/10MWNorthbrook232.13335787253.4926666671000023 6/1/10MWNorthbrook284.22949968763.651000023 6/8/10MWNorthbrook329.2498806742.9441010023 6/15/10MWNorthbrook373.44485004522.8993333331001023 6/22/10MWNorthbrook335.26492189383.391251001023 6/29/10MWNorthbrook408.43517623093.0846666671001023 7/6/10MWNorthbrook341.31525997993.6856251000123 7/13/10MWNorthbrook324.47576750653.3626666671000123 5/4/10MWPalatine226.83540533114.191000015 5/11/10MWPalatine319.37159675594.1677777781000015 5/18/10MWPalatine279.9385105093.7651000015 5/25/10MWPalatine197.50706894593.7651000015 6/1/10MWPalatine280.70684797333.691000015 6/8/10MWPalatine220.51392764743.8053846151000015 6/15/10MWPalatine270.49091814254.0757142861000015 6/22/10MWPalatine350.24398072663.8185714291010015 6/29/10MWPalatine320.67921593584.2185714291001015 7/6/10MWPalatine270.87754938773.7378571431001015 7/13/10MWPalatine373.01199798543.4415384621001015 5/4/10MWRegency (aka Omaha)180.49489707833.831000035 5/11/10MWRegency (aka Omaha)224.63083159253.7746153851000035 5/18/10MWRegency (aka Omaha)213.23584284283.6042857141000035 5/25/10MWRegency (aka Omaha)184.02851650263.5438461541000035 6/1/10MWRegency (aka Omaha)264.33464968993.641000035 6/8/10MWRegency (aka Omaha)239.64847595833.8445454551000035 6/15/10MWRegency (aka Omaha)334.02079454283.791000035 6/22/10MWRegency (aka Omaha)203.48298985193.7746153851000035 6/29/10MWRegency (aka Omaha)243.95858257393.7233333331000035 7/6/10MWRegency (aka Omaha)277.35157597783.2953846151000035 7/13/10MWRegency (aka Omaha)337.15641035393.2953846151000035 5/4/10MWSauganash287.91095812654.191000004 5/11/10MWSauganash283.36179701124.1677777781000004 5/18/10MWSauganash240.78452753243.5438461541000004 5/25/10MWSauganash190.78856733853.731000004 6/1/10MWSauganash182.67998819673.8257142861000004 6/8/10MWSauganash295.76774814363.9284615381000004 6/15/10MWSauganash227.7867073.741000004 6/22/10MWSauganash180.26323081563.741000004 6/29/10MWSauganash171.31509019743.6435714291000004 7/6/10MWSauganash305.19558360593.5181000004 7/13/10MWSauganash260.91328186613.7816666671000004 5/4/10MWSouth Loop194.99294107514.1677777781000002 5/11/10MWSouth Loop272.00479313584.551000002 5/18/10MWSouth Loop287.80901743763.6284615381000002 5/25/10MWSouth Loop249.91364274173.7614285711000002 6/1/10MWSouth Loop331.06755196753.6828571431000002 6/8/10MWSouth Loop294.77798061324.0966666671000002 6/15/10MWSouth Loop428.25950466574.0966666671000002 6/22/10MWSouth Loop303.94495440634.3366666671010002 6/29/10MWSouth Loop422.6725809783.3918751011002 7/6/10MWSouth Loop305.53107036963.5781251001002 7/13/10MWSouth Loop363.06297289842.9478571431001002 5/4/10MWWest Bloomfield232.26304670134.1677777781000014 5/11/10MWWest Bloomfield221.15200914724.1677777781000014 5/18/10MWWest Bloomfield283.473952294441000014 5/25/10MWWest Bloomfield238.08482038433.8344444441000014 6/1/10MWWest Bloomfield252.732579428541000014 6/8/10MWWest Bloomfield299.90317706574.551000014 6/15/10MWWest Bloomfield289.22265409494.551000014 6/22/10MWWest Bloomfield400.74006383614.551010014 6/29/10MWWest Bloomfield311.81459028123.7233333331001014 7/6/10MWWest Bloomfield338.57506919863.5723076921001014 7/13/10MWWest Bloomfield214.46193937093.5723076921001014 5/4/10MWWheaton268.60745840934.6122222221000024 5/11/10MWWheaton341.00816773144.6122222221000024 5/18/10MWWheaton175.19033847974.0677777781000024 5/25/10MWWheaton219.9378745374.0677777781000024 6/1/10MWWheaton306.68417344093.7053846151000024 6/8/10MWWheaton215.11433451214.1042857141000024 6/15/10MWWheaton196.44880610044.391010024 6/22/10MWWheaton366.05895897294.0823076921001024 6/29/10MWWheaton260.07669471364.0566666671001024 7/6/10MWWheaton345.84885107793.6338461541001024 7/13/10MWWheaton346.95121395433.6592857141000124 5/4/10MWWillowbrook236.51710949684.551000033 5/11/10MWWillowbrook200.76071477954.0966666671000033 5/18/10MWWillowbrook255.70223472963.9366666671000033 5/25/10MWWillowbrook269.47292733793.841000033 6/1/10MWWillowbrook199.04757397143.731000033 6/8/10MWWillowbrook239.13177591664.341000033 6/15/10MWWillowbrook257.53511231134.0966666671000033 6/22/10MWWillowbrook467.47352684834.0966666671010033 6/29/10MWWillowbrook487.99911748134.341011033 7/6/10MWWillowbrook296.34238692433.6813333331001033 7/13/10MWWillowbrook329.35000751743.9506251001033 5/4/10NABedford185.93067785174.2042857140000025 5/11/10NABedford139.78138217044.2042857140000025 5/18/10NABedford148.03629422633.7566666670000025 5/25/10NABedford188.05332765233.8614285710000025 6/1/10NABedford186.24054578763.8614285710000025 6/8/10NABedford167.50956760944.2042857140000025 6/15/10NABedford106.25215438594.1566666670000025 6/22/10NABedford167.94479187984.1150000025 6/29/10NABedford87.51636752664.2042857140000025 7/6/10NABedford171.45285503753.780000025 7/13/10NABedford116.25538178573.2733333330000025 5/4/10NABellingham156.18498714324.2042857140000020 5/11/10NABellingham208.03543903934.1185714290000020 5/18/10NABellingham165.13920127873.8614285710000020 5/25/10NABellingham165.86791419553.8614285710000020 6/1/10NABellingham134.33644365253.7566666670000020 6/8/10NABellingham187.07895060694.2042857140000020 6/15/10NABellingham230.61403857524.2042857140000020 6/22/10NABellingham150.45427153164.2042857140000020 6/29/10NABellingham303.29102884013.8233333330000020 7/6/10NABellingham256.18144733593.0960000020 7/13/10NABellingham241.45294253463.0960000020 5/4/10NACranston (aka Garden City Center)170.86965325124.2042857140000011 5/11/10NACranston (aka Garden City Center)181.32186067634.1442857140000011 5/18/10NACranston (aka