We have to do to this..... plus regression, correlation, pivot table,graphs and chart and also add radio button, stock market software

1 answer below »
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
real-estate-data-6-e4hnvvcg.xlsx hints-for-real-estate-data-015dubfe.docx
Answered Same DayMay 19, 2022

Answer To: We have to do to this..... plus regression, correlation, pivot table,graphs and chart and also add...

Mohd answered on May 20 2022
91 Votes
Sheet2
                Credit Union    June Extract    MFSR    Report status    Variance
                Aldergrove    No    No    Pending    NA
                Community Savings    No    No    Pending    NA
                First    No    No    Pending    NA
                GNF    No    No    Pending    NA
                Interior    No    No    Pending    NA
                Salmon Arm    Yes    Yes    Completed    Resolved
                Sharons    Incomplete    Yes    Pending    NA
                Summerland    Yes    Yes    Completed    Resolved
                Sunshine Coast    No    No    Pending    NA
Real Estate
    Vancouver        Jan-18    Feb-18    Mar-18    Apr-18    May-18    Jun-18    Jul-18    Aug-18    Sep-18    Oct-18    Nov-18    Dec-18    Jan-19    Feb-19    Mar-19    Apr-19    May-19    Jun-19    Jul-19    Aug-19    Sep-19    Oct-19    Nov-19    Dec-19    Jan-20
    Vancouver    Single    5178    5836    6190    7020    7860    8236    8178    7966    8467    8199    7705    6504    6693    7125    7698    8561    8808    8988    8587    8127    8116    7466    6598    5359    5206
    Active listing    Apartment    1,769    1,986    2190    2802    3432    3711    3959    3859    4617    4785    4602    3771    4115    4465    5076    5796    5877    5980    5653    5269    5323    4770    4172    3244    3411
    Sales    Single    806    1022    1168    1261    1402    1185    991    904    783    981    798    537    544    725    854    944    1332    1136    1314    1115    1167    1474    1276    963    757
    Sales    Apartment    1,012    1,185    1349    1308    1431    1240    1079    1025    812    985    810    535    559    759    873    885    1246    941    1243    1116    1166    1,384    1222    1053    814
    Sales to Active List Ratio    Single    15.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 Ratio    Apartment    57.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 Price    Single    $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 Price    Apartment    $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 market    Single    42    35.5    31    30    30.5    30    37    43    43    43    47.5    50    58    47    42.5    42.5    40.5    41    44.5    49.5    51.5    49    49.5    58    63.5
    Average days on market    Apartment    28    20    18    19    17    21    24    29    32    29    34    41    47    40    37    33    34    36    37    42    43    41    44    48    43
    https://www.rebgv.org/market-watch/monthly-market-report/december-2018.html
    Vancouver Island        Jan-18    Feb-18    Mar-18    Apr-18    May-18    Jun-18    Jul-18    Aug-18    Sep-18    Oct-18    Nov-18    Dec-18    Jan-19    Feb-19    Mar-19    Apr-19    May-19    Jun-19    Jul-19    Aug-19    Sep-19    Oct-19    Nov-19    Dec-19    Jan-20
    HPI    Single    217.1    222.7    225.8    230.2    233.9    235.1    235.3    235.8    237.2    236.2    237.5    236    235.2    236.7    238.1    241.4    240.4    241.3    241    241.8    245.4    244.8    242.6    243    241.8
    HPI    Apartment    246.7    251.4    254.6    261.2    269.9    268    270.3    272.6    274.2    269    270.1    273.7    273.5    278.4    274.4    279.6    280.3    283.7    282.1    282.3    278.6    279.8    276.9    283.9    288.3
    Benchmark price    Single    $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 price    Apartment    $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
    Sales    Sales    290    316    399    476    518    438    437    467    347    384    304    170    209    227    308    412    459    408    453    413    345    342    312    237    174
    http://www.vireb.com/index.php?page=20
    Central        Jan-18    Feb-18    Mar-18    Apr-18    May-18    Jun-18    Jul-18    Aug-18    Sep-18    Oct-18    Nov-18    Dec-18    Jan-19    Feb-19    Mar-19    Apr-19    May-19    Jun-19    Jul-19    Aug-19    Sep-19    Oct-19    Nov-19    Dec-19    Jan-20
    Units Listed    Units Listed    529    648    962    1006    1149    1072    977    859    838    715    547    312    664    660    898    1075    1137    1072    976    859    838    640    486    308    NO DATA
    Inventory    Inventory    1295    1424    1771    1995    2300    2494    2570    2603    2583    2376    2160    1829    1961    2080    2325    2615    2845    2494    2809    2754    2578    2,315    2016    1697    NO DATA
    Units Sold    Units Sold    318    344    412    478    504    484    433    417    364    377    282    194    192    264    343    424    509    451    441    516    562    383    371    271    NO DATA
    List/Sales Ratio    List/Sales Ratio    97.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 Price    Average 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,127    NO DATA
    Median Sales Price    Median 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,500    NO DATA
    Days to Sell    Days to Sell    73    58    50    50    46    45    50    62    65    61    64    77    80    73    67    68    59    81    65    65    66    76    75    84    NO DATA
    https://www.omreb.com/market-stats/
    Shuswap - Residential        Jan-18    Feb-18    Mar-18    Apr-18    May-18    Jun-18    Jul-18    Aug-18    Sep-18    Oct-18    Nov-18    Dec-18    Jan-19    Feb-19    Mar-19    Apr-19    May-19    Jun-19    Jul-19    Aug-19    Sep-19    Oct-19    Nov-19    Dec-19    Jan-20
    Units Listed    Units Listed    71    104    141    219    268    214    169    163    103
    Inventory    Inventory    359    397    442    538    663    701    707    690    624
    Units Sold    Units Sold    41    40    62    99    190    144    122    118    87
    List/Sales Ratio    List/Sales Ratio    97.23%    96.38%    96.38%    97.42%    96.72%    96.92%    95.74%    96.71%    95.96%
    Average Sales Price    Average Sales Price    $411,932    $483,504    $452,260    $430,918    $421,724    $393,809    $456,177    $411,577    $412,563
    Median Sales Price    Median Sales Price    $387,500    $432,200    $421,475    $420,500    $408,500    $371,000    $450,000    $395,500    $380,000
    Days to Sell    Days to Sell    122    108    109    95    88    74    71    89    117
    http://www.omreb.com/page.php?pageID=124§ionID=2
    Fraser Valley        Jan-18    Feb-18    Mar-18    Apr-18    May-18    Jun-18    Jul-18    Aug-18    Sep-18    Oct-18    Nov-18    Dec-18    Jan-19    Feb-19    Mar-19    Apr-19    May-19    Jun-19    Jul-19    Aug-19    Sep-19    Oct-19    Nov-19    Dec-19    Jan-20
        Fraser Valley
    Active listing    Single - Detached    1739    1838    1990    2415    2867    3076    3117    2988    3076    3037    2768    1954    2207    2295    2507    2924    3231    3306    3200    3061    2992    2,723    2393    1593    1744
    Active listing    Apartment    420    504    649    809    1010    1128    1242    1291    1431    1506    1445    1121    1272    1339    1454    1602    1666    1610    1537    1454    1487    1,417    1272    889    1024
    Sales    Single - Detached    446    522    620    601    658    529    469    433    376    438    383    271    250    354    462    489    562    504    557    511    521    609    514    463    363
    Sales    Apartment    338    379    460    496    516    392    337    318    274    292    286    213    257    288    346    374    396    329    344    331    361    415    373    313    248
    Sales to Active List Ratio    Single - Detached    25.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 Ratio    Apartment    80.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 Price    Single - 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 Price    Apartment    $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 listings    Single - Detached    825    911    1152    1441    1670    1319    1157    969    1186    1060    740    309    995    768    1097    1361    1410    1178    1067    939    1088    896    634    315    792
    New listings    Apartment    453    519    684    785    873    696    695    637    702    684    524    260    675    589    697    764    764    597    624    506    681    598    439    241    523
    http://www.fvreb.bc.ca/stats/
    South Okanagan        Jan-18    Feb-18    Mar-18    Apr-18    May-18    Jun-18    Jul-18    Aug-18    Sep-18    Oct-18    Nov-18    Dec-18    Jan-19    Feb-19    Mar-19    Apr-19    May-19    Jun-19    Jul-19    Aug-19    Sep-19    Oct-19    Nov-19    Dec-19    Jan-20
    Number of Days to Sell    Single     98    89    86    70    65    63    62    58    91    92    71    96    118    86    78    88    71    75    69    70    87    104    90    137    NO DATA
    Number of Days to Sell    Condo    72    61    84    70    62    56    83    59    74    76    71    84    56    77    76    98    74    77    85    95    68    87    101    90    NO DATA
    Average Sales Price    Single*    $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    NO DATA
    Average Sales Price    Condo**    $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,714    NO DATA
    Sales    Single*    69    75    79    102    105    118    86    88    67    81    59    53    41    62    71    113    131    103    126    104    101    103    79    56    -0.58
    Sales    Condo**    44    49    62    78    64    66    60    57    35    40    34    22    17    26    46    52    57    63    61    43    55    39    35    26    NO DATA
    # of Current Listing    Single*    501    535    595    710    795    821    892    719    912    878    784    654    697    712    767    894    947    1027    1007    1010    975    871    791    664    NO DATA
    # of Current Listing    Condo**    192    186    209    232    265    269    275    281    328    338    321    297    306    321    329    356    425    395    369    394    382    357    336    288    NO DATA
    # of New listings    Single*    82    133    162    250    262    210    261    203    183    188    127    87    160    150    214    344    291    271    227    225    201    169    136    73    NO DATA
    # of New listings    Condo**    56    56    100    108    108    96    92    85    113    75    47    28    45    59    100    123    149    85    84    95    123    64    55    34    NO DATA
    http://www.soreb.org/stats/2019/APR19
    Real Estate Indicators BC Sales        Jan-18    Feb-18    Mar-18    Apr-18    May-18    Jun-18    Jul-18    Aug-18    Sep-18    Oct-18    Nov-18    Dec-18    Jan-19    Feb-19    Mar-19    Apr-19    May-19    Jun-19    Jul-19    Aug-19    Sep-19    Oct-19    Nov-19    Dec-19    Jan-20
    Vancouver        1,818    2,207    2,517    2,569    2,833    2,425    2,070    1,929    1,595    1,966    1,608    1,072    1,103    1,484    1,727    1,829    2,578    2,077    2,557    2,231    2,333    2,858    2,498    2,016    1,571
    Vancouver Island        290    316    399    476    518    438    437    467    347    384    304    170    209    227    308    412    459    408    453    413    345    342    312    237    174
    Central Okanagan        318    344    412    478    504    484    433    417    364    377    282    194    192    264    343    424    509    451    441    516    562    383    371    271    0
    Shuswap - Residential        41    40    62    99    190    144    122    118    87    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    NO DATA
    Fraser Valley        784    901    1080    1097    1174    921    806    751    650    730    669    484    507    642    808    863    958    833    901    842    882    1024    887    776    611
    South Okanagan        113    124    141    180    169    184    146    145    102    121    93    75    58    88    117    165    188    166    187    147    156    142    114    82
    Real Estate Indicators BC Prices        Jan-18    Feb-18    Mar-18    Apr-18    May-18    Jun-18    Jul-18    Aug-18    Sep-18    Oct-18    Nov-18    Dec-18    Jan-19    Feb-19    Mar-19    Apr-19    May-19    Jun-19    Jul-19    Aug-19    Sep-19    Oct-19    Nov-19    Dec-19    Jan-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    $0    NO 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
            1    2    3    4    5    6    7    8    9    10    11    12    13    14    15    16    17    18    19    20    21    22    23    24    25
            Jan-18    Feb-18    Mar-18    Apr-18    May-18    Jun-18    Jul-18    Aug-18    Sep-18    Oct-18    Nov-18    Dec-18    Jan-19    Feb-19    Mar-19    Apr-19    May-19    Jun-19    Jul-19    Aug-19    Sep-19    Oct-19    Nov-19    Dec-19    Jan-20
    Canada    Interest rate    1.25    1.25    1.25    1.25    1.25    1.25    1.5    1.5    1.5    1.75    1.75    1.75    1.75    1.75    1.75    1.75    1.75    1.75    1.75    1.75    1.75    1.75    1.75    1.75    1.75
        CPI    131.7    132.5    132.9    133.3    133.4    133.6    134.3    134.2    133.7    134.1    133.5    133.4    133.6    134.5    135.4    136    136.6    136.3    137    136.8    136.2    136.6    136.4    136.4    137.2605072464
        Exchange rate (CAD-USD)    1.2293    1.2809    1.2894    1.2836    1.2948    1.3168    1.3017    1.3055    1.2945    1.3142    1.3301    1.3642    1.3144    1.3169    1.3363    1.3423    1.3527    1.3087    1.3148    1.3295    1.3244    1.316    1.3289    1.2988    1.3233
        Unemployment    5.9    5.8    5.8    5.8    5.8    6    5.8    6    5.9    5.8    5.6    5.6    5.8    5.8    5.8    5.7    5.4    5.5    5.7    5.7    5.5    5.6    5.9    5.6
        Housing Starts    13,122    14,697    14,280    15,962    15,985    20,953    16,774    15,666    16,735    17,179    18,346    16,954    12,457    10,265    12,853    18,166    16,409    21,548    18,073    17,713    19,139    17,060    17,108    15,772
    BC    CPI    126.1    127    127.4    127.7    128.4    128.6    129.7    129.6    128.9    128.9    129.4    128.9    129.1    129.8    130.7    131.2    131.8    131.9    132.4    132.2    132    132.2    131.8    131.7    133.2004940711
        Unemployment    4.8    4.7    4.7    5    4.8    5.2    5    5.3    4.2    4.1    4.4    4.4    4.7    4.5    4.7    4.6    4.3    4.5    4.4    5    4.8    4.8    5.00    4.80
        Housing Starts    3,259    2,437    3,746    3,292    3,487    2,963    3,538    3,812    2,237    2,523    3,205    3,941    3,159    2,848    2,594    4,312    4,566    5,110    4,177    2,952    3,382    2,731    3,952    3,431
        Housing Market indicators    Jan-18    Feb-18    Mar-18    Apr-18    May-18    Jun-18    Jul-18    Aug-18    Sep-18    Oct-18    Nov-18    Dec-18    Jan-19    Feb-19    Mar-19    Apr-19    May-19    Jun-19    Jul-19    Aug-19    Sep-19    Oct-19    Nov-19    Dec-19    Jan-20
    Canada    Housing Starts - Single Detached (Units)    3,534    3,164    3,703    4,421    5,525    5,860    5,342    4,743    5,025    4,160    4,663    4,040    2,353    2,026    2,543    3,564    4,401    5,232    4,608    4,910    4,716    4,359    4,323    3,874
        Housing Starts - Apartment and other (Units)    7,401    9,614    8,238    9,050    7,489    12,017    8,896    8,189    8,469    10,052    10,324    10,081    7,831    6,393    8,331    11,316    9,192    13,203    10,598    9,523    11,173    9,820    9,440    8,844
    BC    Building permits Single (Units)    747    544    666    831    875    908    877    794    805    658    826    725    468    418    516    752    723    778    682    662    653    623    586    490
        Building permits Apartment (Units)    1,988    1,539    2,692    2,138    2,205    1,632    2,275    2,635    871    1,471    1,857    2,610    2,248    2,075    1,736    3,031    3,427    3,842    2,913    1,846    2,221    1,651    2,935    2,399
    Canada    Mortgage lending rate (%)    4.14    4.26    4.27    4.27    4.35    4.32    4.42    4.43    4.43    4.48    4.38    4.59    4.59    4.52    4.44    4.33    4.30    4.23    4.14    4.08    4.07    4.09    4.09    4.08    4.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
Radio Button
                                                    3
    Row Labels    Sum of Vancouver    Sum of Vancouver Island    Sum of Central Okanagan    Sum of Fraser Valley
    2018    14422900    6011600    6819443    11385912
    2019    13219250    6176900    6690553    11168550
    2020    1106850    515400    0    968000
    Grand Total    28749000    12703900    13509996    23522462
    Year    Sum of Vancouver    Sum of Vancouver Island    Sum of Central Okanagan    Sum of Fraser Valley
    2018    14422900    6011600    6819443    11385912
    2019    13219250    6176900    6690553    11168550
    2020    1106850    515400    0    968000
    2018    6819443
    2019    6690553
    2020    0
Group Box 1
Sum of sales by area
2018    2019    2020    6819443    6690553    0    
Vancover
Vancouver Island
Central Oknagon
Data Table format
    Vancouver                                                Vancouver Island                            Central                                        Fraser Valley                                                South Okanagan                                                Real Estate Indicators BC Sales
    Date    Active Listing Single    Active listing Apartment    Sales single    Sales Apartment    Sales to Active List Ratio Single    Sales to Active List Ratio Apartment    Average Sales Price Single    Average Sales Price Apartment    Average days on market single    Average days on market Apartment        Date    HPI    HPI2    Benchmark price    Benchmark price3    Sales        Date    Units Listed    Inventory    Units Sold    List/Sales Ratio    Average Sales Price    Median Sales Price    Days to Sell            Date    Active listing-single detached    Active listing_apartment    Sales_Single -...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?