We have to do to this..... plus regression, correlation, pivot table,graphs and chart and also add radio button, stock market software
Sheet2 Credit UnionJune ExtractMFSRReport statusVariance AldergroveNoNoPendingNA Community SavingsNoNoPendingNA FirstNoNoPendingNA GNFNoNoPendingNA InteriorNoNoPendingNA Salmon ArmYesYesCompletedResolved SharonsIncompleteYesPendingNA SummerlandYesYesCompletedResolved Sunshine CoastNoNoPendingNA Real Estate VancouverJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20 VancouverSingle5178583661907020786082368178796684678199770565046693712576988561880889888587812781167466659853595206 Active listingApartment1,7691,98621902802343237113959385946174785460237714115446550765796587759805653526953234770417232443411 SalesSingle806102211681261140211859919047839817985375447258549441332113613141115116714741276963757 SalesApartment1,0121,18513491308143112401079102581298581053555975987388512469411243111611661,38412221053814 Sales to Active List RatioSingle15.57%17.51%18.87%17.96%17.84%14.39%12.12%11.35%9.25%11.96%10.36%8.26%8.13%10.18%11.09%11.03%15.12%12.64%15.30%13.72%14.38%19.74%19.34%17.97%14.54% Sales to Active List RatioApartment57.21%59.67%61.60%46.68%41.70%33.41%27.25%26.56%17.59%20.59%17.60%14.19%13.58%17.00%17.20%15.27%21.20%15.74%21.99%21.18%21.90%29.01%29.29%32.46%23.86% Average Sales PriceSingle$1,202,600$1,210,600$1,221,750$1,230,000$1,233,750$1,229,000$1,222,200$1,203,500$1,189,250$1,176,600$1,159,300$1,144,350$1,127,000$1,116,200$1,110,350$1,110,200$1,100,650$1,099,100$1,093,500$1,089,300$1,086,850$1,091,050$1,094,100$1,100,950$1,106,850 Average Sales PriceApartment$665,400$682,800$693,500$701,000$701,700$704,200$700,500$695,500$687,300$683,500$667,800$664,100$658,600$660,300$656,900$656,900$664,200$654,700$653,200$654,000$651,500$652,500$651,500$656,700$663,200 Average days on marketSingle4235.5313030.5303743434347.550584742.542.540.54144.549.551.54949.55863.5 Average days on marketApartment28201819172124293229344147403733343637424341444843 https://www.rebgv.org/market-watch/monthly-market-report/december-2018.html Vancouver IslandJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20 HPISingle217.1222.7225.8230.2233.9235.1235.3235.8237.2236.2237.5236235.2236.7238.1241.4240.4241.3241241.8245.4244.8242.6243241.8 HPIApartment246.7251.4254.6261.2269.9268270.3272.6274.2269270.1273.7273.5278.4274.4279.6280.3283.7282.1282.3278.6279.8276.9283.9288.3 Benchmark priceSingle$471,200.00$483,400$490,100$499,600$507,700$510,300$510,700$505,800$508,800$508,200$509,500$506,300$504,500$507,800$510,800$517,800$512,500$514,400$513,700$515,400$523,100$521,800$517,100$518,000$515,400 Benchmark priceApartment$288,400.00$293,900$297,600$305,300$314,000$313,300$315,900$317,700$319,600$313,500$314,800$319,000$318,800$324,500$319,800$325,900$300,700$304,300$302,600$302,800$298,900$300,200$297,000$304,600$309,300 SalesSales290316399476518438437467347384304170209227308412459408453413345342312237174 http://www.vireb.com/index.php?page=20 CentralJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20 Units ListedUnits Listed529648962100611491072977859838715547312664660898107511371072976859838640486308NO DATA InventoryInventory1295142417711995230024942570260325832376216018291961208023252615284524942809275425782,31520161697NO DATA Units SoldUnits Sold318344412478504484433417364377282194192264343424509451441516562383371271NO DATA List/Sales RatioList/Sales Ratio97.25%97.93%98.11%97.49%97.73%97.86%96.84%96.84%96.98%96.73%96.50%96.34%96.71%96.74%97.16%96.65%96.81%97.02%97.68%97.69%97.60%96.47%96.13%96.86%NO DATA Average Sales PriceAverage Sales Price$546,463$534,067$571,678$586,947$582,738$604,168$641,006$568,210$581,818$541,549$528,044$532,755$512,407$512,665$539,565$573,955$573,926$571,864$559,366$560,980$566,090$548,137$615,471$556,127NO DATA Median Sales PriceMedian Sales Price$487,500$493,250$545,000$540,000$525,000$546,500$534,000$525,000$537,750$500,000$520,000$516,950$496,000$463,195$500,000$537,750$537,000$526,000$519,900$519,000$521,750$502,000$538,500$502,500NO DATA Days to SellDays to Sell735850504645506265616477807367685981656566767584NO DATA https://www.omreb.com/market-stats/ Shuswap - ResidentialJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20 Units ListedUnits Listed71104141219268214169163103 InventoryInventory359397442538663701707690624 Units SoldUnits Sold4140629919014412211887 List/Sales RatioList/Sales Ratio97.23%96.38%96.38%97.42%96.72%96.92%95.74%96.71%95.96% Average Sales PriceAverage Sales Price$411,932$483,504$452,260$430,918$421,724$393,809$456,177$411,577$412,563 Median Sales PriceMedian Sales Price$387,500$432,200$421,475$420,500$408,500$371,000$450,000$395,500$380,000 Days to SellDays to Sell1221081099588747189117 http://www.omreb.com/page.php?pageID=124§ionID=2 Fraser ValleyJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20 Fraser Valley Active listingSingle - Detached1739183819902415286730763117298830763037276819542207229525072924323133063200306129922,723239315931744 Active listingApartment420504649809101011281242129114311506144511211272133914541602166616101537145414871,41712728891024 SalesSingle - Detached446522620601658529469433376438383271250354462489562504557511521609514463363 SalesApartment338379460496516392337318274292286213257288346374396329344331361415373313248 Sales to Active List RatioSingle - Detached25.65%28.40%31.16%24.89%22.95%17.20%15.05%14.49%12.22%14.42%13.84%13.87%11.33%15.42%18.43%16.72%17.39%15.25%17.41%16.69%17.41%22.37%21.48%29.06%20.81% Sales to Active List RatioApartment80.48%75.20%70.88%61.31%51.09%34.75%27.13%24.63%19.15%19.39%19.79%19.00%20.20%21.51%23.80%23.35%23.77%20.43%22.38%22.76%24.28%29.29%29.32%35.21%24.22% Median Sales PriceSingle - Detached$942,500$957,737$960,000$981,000$961,675$980,000$975,000$935,000$933,000$920,000$920,000$920,000$900,000$935,000$930,000$932,000$925,500$937,250$909,900$920,000$936,900$925,000$947,000$970,000$968,000 Median Sales PriceApartment$370,150$385,000$390,000$399,844$400,000$395,000$385,000$390,000$385,000$380,000$379,500$360,000$372,000$380,000$385,000$365,000$369,500$380,000$375,000$362,000$370,000$366,000$368,000$380,000$371,750 New listingsSingle - Detached8259111152144116701319115796911861060740309995768109713611410117810679391088896634315792 New listingsApartment453519684785873696695637702684524260675589697764764597624506681598439241523 http://www.fvreb.bc.ca/stats/ South OkanaganJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20 Number of Days to SellSingle 988986706563625891927196118867888717569708710490137NO DATA Number of Days to SellCondo7261847062568359747671845677769874778595688710190NO DATA Average Sales PriceSingle*$491,679$521,969$463,452$590,813$574,839$546,457$549,056$491,903$453,448$596,772$520,206$505,092$475,995$513,451$495,562$510,506$555,219$558,478$598,552$494,349$573,315$598,714$512,022$548,070NO DATA Average Sales PriceCondo**$295,711$265,458$305,249$276,776$261,273$286,337$274,171$305,695$271,957$283,292$342,486$244,125$257,247$261,924$264,280$286,868$302,449$273,317$369,487$266,577$325,878$366,935$250,805$291,714NO DATA SalesSingle*6975791021051188688678159534162711131311031261041011037956-0.58 SalesCondo**444962786466605735403422172646525763614355393526NO DATA # of Current ListingSingle*501535595710795821892719912878784654697712767894947102710071010975871791664NO DATA # of Current ListingCondo**192186209232265269275281328338321297306321329356425395369394382357336288NO DATA # of New listingsSingle*821331622502622102612031831881278716015021434429127122722520116913673NO DATA # of New listingsCondo**56561001081089692851137547284559100123149858495123645534NO DATA http://www.soreb.org/stats/2019/APR19 Real Estate Indicators BC SalesJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20 Vancouver1,8182,2072,5172,5692,8332,4252,0701,9291,5951,9661,6081,0721,1031,4841,7271,8292,5782,0772,5572,2312,3332,8582,4982,0161,571 Vancouver Island290316399476518438437467347384304170209227308412459408453413345342312237174 Central Okanagan3183444124785044844334173643772821941922643434245094514415165623833712710 Shuswap - Residential4140629919014412211887000000000000000NO DATA Fraser Valley7849011080109711749218067516507306694845076428088639588339018428821024887776611 South Okanagan1131241411801691841461451021219375588811716518816618714715614211482 Real Estate Indicators BC PricesJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20 Vancouver$1,202,600$1,210,600$1,221,750$1,230,000$1,233,750$1,229,000$1,222,200$1,203,500$1,189,250$1,176,600$1,159,300$1,144,350$1,127,000$1,116,200$1,110,350$1,110,200$1,100,650$1,099,100$1,093,500$1,089,300$1,086,850$1,091,050$1,094,100$1,100,950$1,106,850 Vancouver Island$471,200$483,400$490,100$499,600$507,700$510,300$510,700$505,800$508,800$508,200$509,500$506,300$504,500$507,800$510,800$517,800$512,500$514,400$513,700$515,400$523,100$521,800$517,100$518,000$515,400 Central Okanagan$546,463$534,067$571,678$586,947$582,738$604,168$641,006$568,210$581,818$541,549$528,044$532,755$512,407$512,665$539,565$573,955$573,926$571,864$559,366$560,980$566,090$548,137$615,471$556,127$0 Shuswap - Residential$411,932$483,504$452,260$430,918$421,724$393,809$456,177$411,577$412,563$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0NO DATA Fraser Valley$942,500$957,737$960,000$981,000$961,675$980,000$975,000$935,000$933,000$920,000$920,000$920,000$900,000$935,000$930,000$932,000$925,500$937,250$909,900$920,000$936,900$925,000$947,000$970,000$968,000 South Okanagan$491,679$521,969$463,452$590,813$574,839$546,457$549,056$491,903$453,448$596,772$520,206$505,092$475,995$513,451$495,562$510,506$555,219$558,478$598,552$494,349$573,315$598,714$512,022$548,070$0 http://www.fvreb.bc.ca/stats/http://www.vireb.com/index.php?page=20https://www.omreb.com/market-stats/https://www.rebgv.org/market-watch/monthly-market-report/december-2018.htmlhttp://www.soreb.org/stats/2019/APR19 Sheet3 Macro Economic 12345678910111213141516171819202122232425 Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20 CanadaInterest rate1.251.251.251.251.251.251.51.51.51.751.751.751.751.751.751.751.751.751.751.751.751.751.751.751.75 CPI131.7132.5132.9133.3133.4133.6134.3134.2133.7134.1133.5133.4133.6134.5135.4136136.6136.3137136.8136.2136.6136.4136.4137.2605072464 Exchange rate (CAD-USD)1.22931.28091.28941.28361.29481.31681.30171.30551.29451.31421.33011.36421.31441.31691.33631.34231.35271.30871.31481.32951.32441.3161.32891.29881.3233 Unemployment5.95.85.85.85.865.865.95.85.65.65.85.85.85.75.45.55.75.75.55.65.95.6 Housing Starts13,12214,69714,28015,96215,98520,95316,77415,66616,73517,17918,34616,95412,45710,26512,85318,16616,40921,54818,07317,71319,13917,06017,10815,772 BCCPI126.1127127.4127.7128.4128.6129.7129.6128.9128.9129.4128.9129.1129.8130.7131.2131.8131.9132.4132.2132132.2131.8131.7133.2004940711 Unemployment4.84.74.754.85.255.34.24.14.44.44.74.54.74.64.34.54.454.84.85.004.80 Housing Starts3,2592,4373,7463,2923,4872,9633,5383,8122,2372,5233,2053,9413,1592,8482,5944,3124,5665,1104,1772,9523,3822,7313,9523,431 Housing Market indicatorsJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20 CanadaHousing Starts - Single Detached (Units)3,5343,1643,7034,4215,5255,8605,3424,7435,0254,1604,6634,0402,3532,0262,5433,5644,4015,2324,6084,9104,7164,3594,3233,874 Housing Starts - Apartment and other (Units)7,4019,6148,2389,0507,48912,0178,8968,1898,46910,05210,32410,0817,8316,3938,33111,3169,19213,20310,5989,52311,1739,8209,4408,844 BCBuilding permits Single (Units)747544666831875908877794805658826725468418516752723778682662653623586490 Building permits Apartment (Units)1,9881,5392,6922,1382,2051,6322,2752,6358711,4711,8572,6102,2482,0751,7363,0313,4273,8422,9131,8462,2211,6512,9352,399 CanadaMortgage lending rate (%)4.144.264.274.274.354.324.424.434.434.484.384.594.594.524.444.334.304.234.144.084.074.094.094.084.1851449275 Sources http://www.bankofcanada.ca/core-functions/monetary-policy/key-interest-rate/ http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=3260020&&pattern=&stByVal=1&p1=1&p2=37&tabMode=dataTable&csid= http://www.bankofcanada.ca/rates/exchange/daily-exchange-rates-lookup/?series%5B%5D=FXUSDCAD&lookupPage=lookup_daily_exchange_rates_2017.php&startRange=2007-07-12&rangeType=range&rangeValue=3.m&dFrom=&dTo=&submit_button=Submit http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2820087&&pattern=&stByVal=1&p1=1&p2=37&tabMode=dataTable&csid= http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0270001&pattern=0270001..0270002%2C0270006..0270041%2C0270043..0270044%2C0270046..0270057&csid= https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810000413&pickMembers%5B0%5D=1.26 http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/lfss01c-eng.htm http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0270001&pattern=0270001..0270002%2C0270006..0270041%2C0270043..0270044%2C0270046..0270057&tabMode=dataTable&srchLan=-1&p1=-1&p2=-1#customizeTab Sources http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0270001&pattern=0270001..0270002%2C0270006..0270041%2C0270043..0270044%2C0270046..0270057&tabMode=dataTable&srchLan=-1&p1=-1&p2=-1#customizeTab http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0270001&pattern=0270001..0270002%2C0270006..0270041%2C0270043..0270044%2C0270046..0270057&tabMode=dataTable&srchLan=-1&p1=-1&p2=-1#customizeTab https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=3410014301 http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0260001&pattern=0260001..0260008%2C0260010&csid= http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&p2=33&id=0270015 http://www.bankofcanada.ca/core-functions/monetary-policy/key-interest-rate/http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0270001&pattern=0270001..0270002%2C0270006..0270041%2C0270043..0270044%2C0270046..0270057&tabMode=dataTable&srchLan=-1&p1=-1&p2=-1http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0270001&pattern=0270001..0270002%2C0270006..0270041%2C0270043..0270044%2C0270046..0270057&tabMode=dataTable&srchLan=-1&p1=-1&p2=-1https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810000413&pickMembers%5B0%5D=1.26https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=3410014301http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=3260020&&pattern=&stByVal=1&p1=1&p2=37&tabMode=dataTable&csid=http://www.bankofcanada.ca/rates/exchange/daily-exchange-rates-lookup/?series%5B%5D=FXUSDCAD&lookupPage=lookup_daily_exchange_rates_2017.php&startRange=2007-07-12&rangeType=range&rangeValue=3.m&dFrom=&dTo=&submit_button=Submithttp://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2820087&&pattern=&stByVal=1&p1=1&p2=37&tabMode=dataTable&csid=http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0270001&pattern=0270001..0270002%2C0270006..0270041%2C0270043..0270044%2C0270046..0270057&csid=http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&p2=33&id=0270015http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0260001&pattern=0260001..0260008%2C0260010&csid=http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/lfss01c-eng.htmhttp://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0270001&pattern=0270001..0270002%2C0270006..0270041%2C0270043..0270044%2C0270046..0270057&tabMode=dataTable&srchLan=-1&p1=-1&p2=-1 Sheet5 BC Dependent Independent Housing Starts (units)Unemployment (%)SUMMARY OUTPUT 131225.9 146975.8Regression Statistics 142805.8Multiple R0.3060972898 159625.8R Square0.0936955508 159855.8Adjusted R Square0.0524998941 209536Standard Error2514.3593248885 167745.8Observations24 156666 167355.9ANOVA 171795.8dfSSMSFSignificance F 183465.6Regression114378786.077611914378786.07761192.27440361850.1457531136 169545.6Residual22139084061.9223886322002.814654 124575.8Total23153462848 102655.8 128535.8CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0% 181665.7Intercept45521.501492537319327.32376507892.35529254050.02783878585439.085261478785603.91772359585439.085261478785603.9177235958 164095.4X Variable 1-5074.74626865673364.9650987489-1.50811260140.1457531136-12053.25676138911903.7642240756-12053.25676138911903.7642240756 215485.5 180735.7 177135.7 191395.5 170605.6 171085.9 157725.6 Data Fraser ValleyVancouverSimple Index numbersWhat are we looking for?Real estate AgentGovernmentBankBuyer or SellerReal estate AgentGovernmentBankBuyer or Seller Median Apartment Author: Author: Table 027-0001Avg ApartmentPatternPotential Tax RevenueReal Estate InflationOpportunity to Sell100PricingTaxesinterest RatesTrend Jan-18$370,150$665,400100100Base PeriodSales or Commission patternsAffordabilityMortgage DemandRight time to buy and Sell$37,015,000Timing of the marketGDP ForecastMarketingInvestments Feb-18$385,000$682,800104.01102.61Regulation$38,500,000Marketing/NicheReal estate inflation Mar-18$390,000$693,500105.36104.22$39,000,000CorrelationValuationPolicy and regulation Apr-18$399,844$701,000108.02105.35$39,984,400rUnderstanding purchasing power May-18$400,000$701,700108.06105.46January 2018 to 2020$40,000,000-1 -1 to 0 0 0 to 11Infrastrcuture needs Jun-18$395,000$704,200106.71105.83Fraser ValleyVancouver% DifferenceRent Differential$39,500,000Perfect NegativeImperfect negativeNo or little correlationImperfect PositivePerfect Positive Jul-18$385,000$700,500104.01105.28Average$378,550$671,26044%$38,500,000 Aug-18$390,000$695,500105.36104.52Std Dev.1121718844$39,000,000 Sep-18$385,000$687,300104.01103.29Co. Eff of Variation2.96%2.81%$38,500,000 Oct-18$380,000$683,500102.66102.72$38,000,000 Nov-18$379,500$667,800102.53100.36$37,950,000 Dec-18$360,000$664,10097.2699.80QOQAverageFraser ValleyVancouver%Change of Average prices$36,000,000 Jan-19$372,000$658,600100.5098.982018Q1$381,717$680,567$37,200,000 Feb-19$380,000$660,300102.6699.232018Q2$398,281$702,3004.34%3.19%$38,000,000 Mar-19$385,000$656,900104.0198.722018Q3$386,667$694,433-2.92%-1.12%$38,500,000 Apr-19$365,000$656,90098.6198.722018Q4$373,167$671,800-3.49%-3.26%$36,500,000 May-19$369,500$664,20099.8299.822019Q1$379,000$658,6001.56%-1.96%$36,950,000 Jun-19$380,000$654,700102.6698.392019Q2$371,500$658,600-1.98%0.00%$38,000,000 Jul-19$375,000$653,200101.3198.172019Q3$369,000$652,900-0.67%-0.87%$37,500,000 Aug-19$362,000$654,00097.8098.292019Q4$371,333$653,5670.63%0.10%$36,200,000 Sep-19$370,000$651,50099.9697.91$37,000,000 Oct-19$366,000$652,50098.8898.06$36,600,000 Nov-19$368,000$651,50099.4297.91YOYCorrelation$36,800,000 Dec-19$380,000$656,700102.6698.69New - Old / Old *100X and Y0.81$38,000,000 Jan-20$371,750$663,200100.4399.67Y and X0.81$37,175,000 xyNew X Independent of orgin and scale0.81 6 5 4 3 2 1 Fraser Valley 43131431594319043220432514328143312433434337343404434344346543496435244355543585436164364643677437084373843769437994383043861370150385000390000399844400000395000385000390000385000380000379500360000372000380000385000365000369500380000375000362000370000366000368000380000371750 Vancouver 43131431594319043220432514328143312433434337343404434344346543496435244355543585436164364643677437084373843769437994383043861665400682800693500701000701700704200700500695500687300683500667800664100658600660300656900656900664200654700653200654000651500652500651500656700663200 Fraser Valley v/s Vancouver 43131431594319043220432514328143312433434337343404434344346543496435244355543585436164364643677437084373843769437994383043861370150385000390000399844400000395000385000390000385000380000379500360000372000380000385000365000369500380000375000362000370000366000368000380000371750665400682800693500701000701700704200700500695500687300683500667800664100658600660300656900656900664200654700653200654000651500652500651500656700663200 654321 Index Fraser ValleyFraser ValleyVancouverVancouver Median Apartment Author: Author: Table 027-0001IndexAvg ApartmentIndex Base periodJan-18$370,150100$665,400100.00 Feb-18$385,000104.01$682,800102.61 Mar-18$390,000105.36$693,500104.22 Apr-18$399,844108.02$701,000105.35 May-18$400,000108.06$701,700105.46 Jun-18$395,000106.71$704,200105.83 Jul-18$385,000104.01$700,500105.28 Aug-18$390,000105.36$695,500104.52 Sep-18$385,000104.01$687,300103.29 Oct-18$380,000102.66$683,500102.72 Nov-18$379,500102.53$667,800100.36 Dec-18$360,00097.26$664,10099.80 Jan-19$372,000100.50$658,60098.98 Feb-19$380,000102.66$660,30099.23 Mar-19$385,000104.01$656,90098.72 Apr-19$365,00098.61$656,90098.72 May-19$369,50099.82$664,20099.82 Jun-19$380,000102.66$654,70098.39 Jul-19$375,000101.31$653,20098.17 Aug-19$362,00097.80$654,00098.29 Sep-19$370,00099.96$651,50097.91 Oct-19$366,00098.88$652,50098.06 Nov-19$368,00099.42$651,50097.91