3. You have been hired as a consultant by a real estate company to analyze the distribution of investment in new housing in Canada. To undertake this analysis, you have been provided with data on "Investment in new housing construction data for all dwelling types. This data is from 1994-2017 and contains 288 observations (Data Source: Statistics Canada, Table 34-10-0012-01). a) Construct a stem-and-leaf diagram for new housing construction expenditure for all types of dwellings (aggregate new housing construction expenditure). (2 marks) b) Construct a histogram for new housing construction expenditure for all types of dwellings (aggregate new housing construction expenditure). (2 marks) c) Based on your visual inspections of the diagrams in a) and b), what is the shape of the distribution for investment in new housing in Canada? (1 mark) Investment in new housing construction data for all dwelling types (CSV) Dwellings type Month Year Season New housing construction expenditure ($million) Bank of Canada interest rate(%) 1,741 3.88 1,628 4.1 1,658 5.64 2,083 6.07 2,439 6.31 2,907 6.92 3,107 6.04 2,751 5.6 2,559 5.54 2,441 5.62 2,187 6.04 1,981 7.43 1,639 8.38 All types of dwellings Jan-1994 1994 Winter All types of dwellings Feb-1994 1994 Winter All types of dwellings Mar-1994 1994 Winter All types of dwellings Apr-1994 1994 Spring All types of dwellings May-1994 1994 Spring All types of dwellings Jun-1994 1994 Summer All types of dwellings Jul-1994 1994 Summer All types of dwellings Aug-1994 1994 Summer All types of dwellings Sep-1994 1994 Fall All types of dwellings Oct-1994 1994 Fall All types of dwellings Nov-1994 1994 Winter All types of dwellings Dec-1994 1994 Winter All types of dwellings Jan-1995 1995 Winter All types of dwellings Feb-1995 1995 Winter All types of dwellings Mar-1995 1995 Winter All types of dwellings Apr-1995 1995 Spring All types of dwellings May-1995 1995 Spring All types of dwellings Jun-1995 1995 Summer All types of dwellings Jul-1995 1995 Summer All types of dwellings Aug-1995 1995 Summer All types of dwellings Sep-1995 1995 Fall All types of dwellings Oct-1995 1995 Fall All types of dwellings Nov-1995 1995 Winter All types of dwellings Dec-1995 1995 Winter All types of dwellings Jan-1996 1996 Winter All types of dwellings Feb-1996 1996 Winter 1,530 8.38 1,463 8.47 1,703 8.17 1,793 7.64 1,998 6.97 2,025 6.87 1,885 6.59 1,814 6.71 1,786 7.65 1,677 6.07 1,550 5.79 1,327 5.37 1,251 5.5 1,298 5.25 1,594 5 1,866 5 2,269 5 2,490 4.75 2,308 4.25 2,189 4.25 2,045 3.5 1,971 3.25 1,863 3.25 1,683 3.25 1,672 3.25 1,729 3.25 2,102 3.25 All types of dwellings Mar-1996 1996 Winter All types of dwellings Apr-1996 1996 Spring All types of dwellings May-1996 1996 Spring All types of dwellings Jun-1996 1996 Summer All types of dwellings Jul-1996 1996 Summer All types of dwellings Aug-1996 1996 Summer All types of dwellings Sep-1996 1996 Fall All types of dwellings Oct-1996 1996 Fall All types of dwellings Nov-1996 1996 Winter All types of dwellings Dec-1996 1996 Winter All types of dwellings Jan-1997 1997 Winter All types of dwellings Feb-1997 1997 Winter All types of dwellings Mar-1997 1997 Winter All types of dwellings Apr-1997 1997 Spring All types of dwellings May-1997 1997 Spring All types of dwellings Jun-1997 1997 Summer All types of dwellings Jul-1997 1997 Summer All types of dwellings Aug-1997 1997 Summer All types of dwellings Sep-1997 1997 Fall All types of dwellings Oct-1997 1997 Fall All types of dwellings Nov-1997 1997 Winter All types of dwellings Dec-1997 1997 Winter All types of dwellings Jan-1998 1998 Winter All types of dwellings Feb-1998 1998 Winter All types of dwellings Mar-1998 1998 Winter All types of dwellings Apr-1998 1998 Spring All types of dwellings May-1998 1998 Spring All types of dwellings Jun-1998 1998 Summer 2,341 3.25 2,690 3.25 2,932 3.5 2,718 3.5 2,626 3.5 2,466 3.75 2,339 4 2,183 4.5 1,927 4.5 1,868 5 1,860 5 2,241 5 2,431 5 2,637 5 All types of dwellings Jul-1998 1998 Summer 2,772 5 2,489 5 2,387 5.75 All types of dwellings Aug-1998 1998 Summer All types of dwellings Sep-1998 1998 Fall All types of dwellings Oct-1998 1998 Fall All types of dwellings Nov-1998 1998 Winter All types of dwellings Dec-1998 1998 Winter 2,298 5.5 2,197 5.25 2,098 5.25 All types of dwellings Jan-1999 1999 Winter 1,890 5.25 All types of dwellings Feb-1999 1999 Winter 1,802 5.25 1,785 5 2,172 5 2,411 4.75 2,766 4.75 3,006 4.75 2,724 4.75 2,640 4.75 2,519 4.75 2,396 5 2,323 5 All types of dwellings Mar-1999 1999 Winter All types of dwellings Apr-1999 1999 Spring All types of dwellings May-1999 1999 Spring All types of dwellings Jun-1999 1999 Summer All types of dwellings Jul-1999 1999 Summer All types of dwellings Aug-1999 1999 Summer All types of dwellings Sep-1999 1999 Fall All types of dwellings Oct-1999 1999 Fall All types of dwellings Nov-1999 1999 Winter All types of dwellings Dec-1999 1999 Winter All types of dwellings Jan-2000 2000 Winter All types of dwellings Feb-2000 2000 Winter All types of dwellings Mar-2000 2000 Winter All types of dwellings Apr-2000 2000 Spring All types of dwellings May-2000 2000 Spring All types of dwellings Jun-2000 2000 Summer All types of dwellings Jul-2000 2000 Summer All types of dwellings Aug-2000 2000 Summer All types of dwellings Sep-2000 2000 Fall All types of dwellings Oct-2000 2000 Fall 2.030 5 1,877 5.25 1,918 5.5 2,363 5.5 2,414 6 2,532 6 2,700 6 2,745 6 2,793 6 2,729 6 2,592 6 2.370 6 2,201 5.75 All types of dwellings Nov-2000 2000 Winter All types of dwellings Dec-2000 2000 Winter All types of dwellings Jan-2001 2001 Winter All types of dwellings Feb-2001 2001 Winter All types of dwellings Mar-2001 2001 Winter All types of dwellings Apr-2001 2001 Spring 2.134 5.75 2.142 5.25 2,531 5 2.557 4.75 2,698 4.75 2,775 4.5 2.894 4.25 2,922 3.75 2,911 3 2,792 2.5 2,615 2.5 2,458 2.25 2,434 2.25 2,535 2.25 All types of dwellings May-2001 2001 Spring All types of dwellings Jun-2001 2001 Summer All types of dwellings Jul-2001 2001 Summer All types of dwellings Aug-2001 2001 Summer All types of dwellings Sep-2001 2001 Fall All types of dwellings Oct-2001 2001 Fall All types of dwellings Nov-2001 2001 Winter All types of dwellings Dec-2001 2001 Winter All types of dwellings Jan-2002 2002 Winter All types of dwellings Feb-2002 2002 Winter All types of dwellings Mar-2002 2002 Winter All types of dwellings Apr-2002 2002 Spring All types of dwellings May-2002 2002 Spring All types of dwellings Jun-2002 2002 Summer All types of dwellings Jul-2002 2002 Summer All types of dwellings Aug-2002 2002 Summer All types of dwellings Sep-2002 2002 Fall All types of dwellings Oct-2002 2002 Fall All types of dwellings Nov-2002 2002 Winter All types of dwellings Dec-2002 2002 Winter All types of dwellings Jan-2003 2003 Winter All types of dwellings Feb-2003 2003 Winter All types of dwellings Mar-2003 2003 Winter 3,064 2.5 3,223 2.5 3,444 2.75 3,539 3 3,673 3 3,696 3 3.653 3 3,453 3 3,158 3 2,844 3 2.754 3 2,725 3.25 2.725 3.25 3.143 3.5 3.108 3.5 3,242 3.5 3,430 3.25 3,618 3.25 3,696 3 3,633 3 3,431 3 3 3,117 2,909 2.75 2,930 2.75 3.079 2.5 2.25 3,680 3,669 2.25 2.25 3,776 3,868 4,009 2.25 2.25 4,065 2.5 3,969 3,720 2.75 2.75 3,354 2.75 3.107 2.75 All types of dwellings Mar-2003 2003 Winter All types of dwellings Apr-2003 2003 Spring All types of dwellings May-2003 2003 Spring All types of dwellings Jun-2003 2003 Summer All types of dwellings Jul-2003 2003 Summer All types of dwellings Aug-2003 2003 Summer All types of dwellings Sep-2003 2003 Fall All types of dwellings Oct-2003 2003 Fall All types of dwellings Nov-2003 2003 Winter All types of dwellings Dec-2003 2003 Winter All types of dwellings Jan-2004 2004 Winter All types of dwellings Feb-2004 2004 Winter All types of dwellings Mar-2004 2004 Winter All types of dwellings Apr-2004 2004 Spring All types of dwellings May-2004 2004 Spring All types of dwellings Jun-2004 2004 Summer All types of dwellings Jul-2004 2004 Summer All types of dwellings Aug-2004 2004 Summer All types of dwellings Sep-2004 2004 Fall All types of dwellings Oct-2004 2004 Fall All types of dwellings Nov-2004 2004 Winter All types of dwellings Dec-2004 2004 Winter All types of dwellings Jan-2005 2005 Winter All types of dwellings Feb-2005 2005 Winter All types of dwellings Mar-2005 2005 Winter All types of dwellings Apr-2005 2005 Spring All types of dwellings May-2005 2005 Spring All types of dwellings Jun-2005 2005 Summer All types of dwellings Jul-2005 2005 Summer All types of dwellings Aug-2005 2005 Summer All types of dwellings Sep-2005 2005 Fall All types of dwellings Oct-2005 2005 Fall All types of dwellings Nov-2005 2005 Winter All types of dwellings Dec-2005 2005 Winter All types of dwellings Jan-2006 2006 Winter All types of dwellings Feb-2006 2006 Winter All types of dwellings Mar-2006 2006 Winter All types of dwellings Apr-2006 2006 Spring All types of dwellings May-2006 2006 Spring All types of dwellings Jun-2006 2006 Summer All types of dwellings Jul-2006 2006 Summer All types of dwellings Aug-2006 2006 Summer All types of dwellings Sep-2006 2006 Fall All types of dwellings Oct-2006 2006 Fall All types of dwellings Nov-2006 2006 Winter All types of dwellings Dec-2006 2006 Winter All types of dwellings Jan-2007 2007 Winter 3,099 2.75 3,129 2.75 3,707 2.75 3,706 2.75 3,851 2.75 2.75 3,888 3.958 2.75 4,026 3 3,919 3.25 3.643 3.25 3.282 3.5 3.142 3.75 3.194 3.75 3.289 4 3,804 4.25 3,708 4.5 3,747 4.5 3,774 4.5 4.5 3,865 3,898 4.5 3,810 4.5 3,539 3,176 3,053 4.5 4.5 4.5 3,038 4.5 3,108 4.5 3,649 4.5 3,598 4.5 3,727 4.5 3,789 4.75 3,970 4.75 4,102 4.75 4,002 4.75 3,736 4.75 3,304 3,056 4.5 4.25 3,017 4.25 2,991 3.75 3,398 3.25 3.25 3,391 3,499 3.25 3,528 3.25 3,713 3.25 3,847 3.25 3,843 2.5 3.382 2.5 2,905 1.75 2,680 1.25 All types of dwellings Feb-2007 2007 Winter All types of dwellings Mar 2007 2007 Winter All types of dwellings Apr-2007 2007 Spring All types of dwellings May 2007 2007 Spring All types of dwellings Jun-2007 2007 Summer All types of dwellings Jul-2007 2007 Summer All types of dwellings Aug-2007 2007 Summer All types of dwellings Sep-2007 2007 Fall All types of dwellings Oct-2007 2007 Fall All types of dwellings Nov-2007 2007 Winter All types of dwellings Dec-2007 2007 Winter All types of dwellings Jan-2008 2008 Winter All types of dwellings Feb-2008 2008 Winter All types of dwellings Mar-2008 2008 Winter All types of dwellings Apr-2008 2008 Spring All types of dwellings May-2008 2008 Spring All types of dwellings Jun-2008 2008 Summer All types of dwellings Jul-2008 2008 Summer All types of dwellings Aug-2008 2008 Summer All types of dwellings Sep-2008 2008 Fall All types of dwellings Oct-2008 2008 Fall All types of dwellings Nov-2008 2008 Winter All types of dwellings Dec-2008 2008 Winter All types of dwellings Jan-2009 2009 Winter All types of dwellings Feb-2009 2009 Winter All types of dwellings Mar-2009 2009 Winter All types of dwellings Apr-2009 2009 Spring All types of dwellings May-2009 2009 Spring All types of dwellings Jun-2009 2009 Summer All types of dwellings Jul-2009 2009 Summer All types of dwellings Aug-2009 2009 Summer All types of dwellings Sep-2009 2009 Fall All types of dwellings Oct-2009 2009 Fall All types of dwellings Nov-2009 2009 Winter All types of dwellings Dec-2009 2009 Winter All types of dwellings Jan-2010 2010 Winter All types of dwellings Feb-2010 2010 Winter All types of dwellings Mar-2010 2010 Winter All types of dwellings Apr-2010 2010 Spring All types of dwellings May-2010 2010 Spring All types of dwellings Jun-2010 2010 Summer All types of dwellings Jul-2010 2010 Summer All types of dwellings Aug-2010 2010 Summer All types of dwellings Sep-2010 2010 Fall All types of dwellings Oct-2010 2010 Fall All types of dwellings Nov-2010 2010 Winter All types of dwellings Dec-2010 2010 Winter All types of dwellings Jan-2011 2011 Winter 2,559 1.25 2,487 0.75 2,675 0.5 2,608 0.5 2,698 0.5 2.774 0.5 0.5 2.858 3,048 0.5 3,115 0.5 3,004 0.5 2,811 0.5 2,754 0.5 0.5 2,812 2,869 0.5 3.333 0.5 3,337 0.5 3,397 0.75 3,498 1 1 3,584 1 3,616 1.25 3,494 1.25 1.25 3,229 2.879 1.25 2.711 1.25 1.25 2.716 2,726 1.25 3,090 1.25 3,119 1.25 3,245 1.25 3,432 1.25 3,608 1.25 3,760 1.25 3.727 1.25 3,465 1.25 3,166 1.25 3,026 1.25 3,081 1.25 3,141 1.25 3,656 1.25 3,645 1.25 3,738 1.25 3,896 1.25 4,125 1.25 4,252 1.25 4,192 1.25 3,835 1.25 3,440 1.25 3,206 1.25 All types of dwellings Feb-2011 2011 Winter All types of dwellings Mar-2011 2011 Winter All types of dwellings Apr-2011 2011 Spring All types of dwellings May-2011 2011 Spring All types of dwellings Jun-2011 2011 Summer All types of dwellings Jul 2011 2011 Summer All types of dwellings Aug-2011 2011 Summer All types of dwellings Sep-2011 2011 Fall All types of dwellings Oct-2011 2011 Fall All types of dwellings Nov-2011 2011 Winter All types of dwellings Dec-2011 2011 Winter All types of dwellings Jan-2012 2012 Winter All types of dwellings Feb-2012 2012 Winter All types of dwellings Mar-2012 2012 Winter All types of dwellings Apr-2012 2012 Spring All types of dwellings May-2012 2012 Spring All types of dwellings Jun-2012 2012 Summer All types of dwellings Jul-2012 2012 Summer All types of dwellings Aug-2012 2012 Summer All types of dwellings Sep-2012 2012 Fall All types of dwellings Oct-2012 2012 Fall All types of dwellings Nov-2012 2012 Winter All types of dwellings Dec-2012 2012 Winter All types of dwellings Jan-2013 2013 Winter All types of dwellings Feb-2013 2013 Winter All types of dwellings Mar-2013 2013 Winter All types of dwellings Apr-2013 2013 Spring All types of dwellings May-2013 2013 Spring All types of dwellings Jun-2013 2013 Summer All types of dwellings Jul-2013 2013 Summer All types of dwellings Aug-2013 2013 Summer All types of dwellings Sep-2013 2013 Fall All types of dwellings Oct-2013 2013 Fall All types of dwellings Nov-2013 2013 Winter All types of dwellings Dec-2013 2013 Winter All types of dwellings Jan-2014 2014 Winter All types of dwellings Feb-2014 2014 Winter All types of dwellings Mar-2014 2014 Winter All types of dwellings Apr-2014 2014 Spring All types of dwellings May-2014 2014 Spring All types of dwellings Jun-2014 2014 Summer All types of dwellings Jul-2014 2014 Summer All types of dwellings Aug-2014 2014 Summer All types of dwellings Sep-2014 2014 Fall All types of dwellings Oct-2014 2014 Fall All types of dwellings Nov-2014 2014 Winter All types of dwellings Dec-2014 2014 Winter All tynes of dwellinaslan 2015 2015 Winter 3,214 1.25 3,202 1.25 3,588 1.25 3,546 1.25 3,465 1.25 3,688 1.25 3,824 1.25 3.937 1.25 3,883 1.25 3,616 1.25 3,240 1.25 3,069 1.25 3,111 1.25 3,080 1.25 3,482 1.25 3,476 1.25 3,565 1.25 3,769 1.25 3,991 1.25 1.25 4,126 4,087 1.25 3.784 1.25 3,380 1.25 2008 3,208 1 3,198 1 3,204 1 3,573 1 3,578 1 3,653 1 1 3,808 0.75 4,061 0.75 4,264 0.75 4,230 0.75 3,867 0.75 3,462 0.75 3,284 0.75 3,353 0.75 3,400 0.75 3,780 0.75 3,689 0.75 0.75 All types of dwellings Jan-2015 2015 Winter All types of dwellings Feb-2015 2015 Winter All types of dwellings Mar-2015 2015 Winter All types of dwellings Apr-2015 2015 Spring All types of dwellings May-2015 2015 Spring All types of dwellings Jun-2015 2015 Summer All types of dwellings Jul-2015 2015 Summer All types of dwellings Aug-2015 2015 Summer All types of dwellings Sep-2015 2015 Fall All types of dwellings Oct-2015 2015 Fall All types of dwellings Nov-2015 2015 Winter All types of dwellings Dec-2015 2015 Winter All types of dwellings Jan-2016 2016 Winter - All types of dwellings Feb-2016 2016 Winter All types of dwellings Mar-2016 2016 Winter All types of dwellings Apr-2016 2016 Spring All types of dwellings May-2016 2016 Spring All types of dwellings Jun-2016 2016 Summer All types of dwellings Jul-2016 2016 Summer All types of dwellings Aug-2016 2016 Summer All types of dwellings Sep-2016 2016 Fall All types of dwellings Oct-2016 2016 Fall All types of dwellings Nov-2016 2016 Winter All types of dwellings Dec-2016 2016 Winter All types of dwellings Jan-2017 2017 Winter All types of dwellings Feb-2017 2017 Winter All types of dwellings Mar-2017 2017 Winter All types of dwellings Apr-2017 2017 Spring All types of dwellings May-2017 2017 Spring All types of dwellings Jun-2017 2017 Summer All types of dwellings Jul-2017 2017 Summer All types of dwellings Aug-2017 2017 Summer All types of dwellings Sep-2017 2017 Fall All types of dwellings Oct-2017 2017 Fall All types of dwellings Nov-2017 2017 Winter All types of dwellings Dec-2017 2017 Winter 3,831 3,935 0.75 0.75 0.75 4,098 4,357 4,338 3,978 0.75 0.75 3,640 0.75 3,445 0.75 3,463 0.75 3,537 0.75 3,968 0.75 3,788 0.75 3,950 0.75 4,111 1 1 1 1 4.324 4,552 1.25 4,530 1.25 1.25 4,222 3,857 1.25
