Observat Community in the With Home Owners Estimated ion # Area Association? Value Per square ft 1 A Yes 123 2 A Yes 120 3 C No 130 4 C No 158 5 B No 92 6 E Yes 155 7 A Yes 150 8 9 B No 115 102 R 8 # *88*q h863338 3 8 t 8 o & =NctcR 886 8$R EEEEEEE D A Yes 148 Yes 142 C No 159 C No 168 B No 75 E No 79 A No 128 B No 92 C Yes 165 D No 122 B No 93 E No 149 A Yes 147 B Yes 120 E Yes 162 A No 128 E Yes 134 E B C E B E A No 116 No 112 Yes 139 No 121 No 119 No 130 No 119 C Yes 159 C Yes 135 A No 158 B No 98 C Yes 164 D E Yes 127 No 126 D No 125 A Yes 135 D Yes 119 C Yes 137 F No 125 B Yes 109 E No 132 B No 105 F Yes 109 A Yes 132 C No 160 C No 165 A Yes 125 B No 100 C No 141 C No 158 E No 99 B No 95 A No 135 A Yes 136 C Yes 139 E No 125 B Yes 115 C No 139 C No 132 A No 113 B No 103 C Yes 129 C Yes 139 E No 125 C Yes 129 E No 119 B Yes 115 A Yes 120 D Yes 120 C Yes 135 A No 120 A Yes 115 C No 130 C No 140 B No 105 E No 106 A Yes 128 B No 109 D No 125 C No 150 A Yes 117 B Yes 123 C No 139 C Yes 135 A No 125 C Yes 120 C No 129 D Yes 128 E No 105 A Yes 124 B Yes 115 C No 136 A Yes 125 D Yes 140 D No 142 A No 131 C No 129 C No 139 B No 110 E No 101 A Yes 123 B No 104 108 D Yes 126 A Yes 131 C Yes 135 C No 140 112 B No 99 E Yes 105 A Yes 117 B Yes 109 116 C Yes 150 D No 127 B A Yes No 107 119 B Yes 111 E Yes 116 A Yes 135 E Yes 129 E Yes 134 B Yes 117 C Yes 109 A No 120 A No 128 C No 135 C Yes 145 B Yes 117 E Yes 97 A Yes 120 B No 95 D Yes 130 136 D No 125 A No 132 138 C Yes 139 C No 142 B No 100 E No 110 A No 125 B No 100 C No 135 D Yes 129 B Yes 115 C No 138 C Yes 139 A No 124 A No 124 C No 135 C Yes 139 B E No Yes 120 119 A Yes 125 B Yes 110 D Yes 125 D No 126 A No 120 D Yes 132 D Yes 133 A Yes 120 C No 136 C No 169 B No 100 E No 109 A No 120 B Yes 110 B Yes 110 E No 120 A Yes 129 B Yes 111 E Yes 125 A No 120 E Yes 129 176 E No 117 B No 109 C Yes 137 E No 168 B No 115 E No 165 Bins Data 1. Housing Features are from 181 ransomly sampled houses. The data show 181 observations' community name, HOA affiliation, estimated value per sq ft of the observed Regarding problem 1.3: Before you run "Histogram" procedure, do followings first. 1. Define (which means decide class width, and class limits of each class) classes. Guideline: number of classes are 10 and first class begins from 70. 2. Based on class limits, figure out upper boundary of each class. 3. Fill up "Bins" column with each class's upper boundary. Starting from cell E2, type 1st class's upper boundary; in the cell E3, type 2nd class's upper boundary,... go on through the cell E11 with upper boundary of the 10th class. 4. Data --> Data Analysis--> Histogram Year-Month 1996-08 Median of Top Tier Median of Bottom Tier 251900 45700 1996-09 251600 45800 1996-10 251700 45900 1996-11 252100 45900 1996-12 252600 46000 1997-01 253100 46200 1997-02 253700 46400 1997-03 254400 46500 1997-04 254900 46600 1997-05 255100 46800 1997-06 255000 47000 1997-07 254600 47300 1997-08 253900 47500 1997-09 252900 47800 1997-10 251500 48200 1997-11 249800 48500 1997-12 247300 48900 1998-01 244600 49200 1998-02 242000 49500 1998-03 239900 49700 1998-04 238400 50000 1998-05 237700 50200 1998-06 237800 50300 1998-07 238700 50600 1998-08 239900 50800 1998-09 241400 51100 1998-10 242900 51300 1998-11 244500 51500 1998-12 246000 51800 1999-01 247400 52200 1999-02 248700 52600 1999-03 250000 53000 1999-04 251300 53400 1999-05 252500 53900 1999-06 253700 54300 1999-07 254900 54800 1999-08 256100 55100 1999-09 257300 55400 1999-10 258400 55700 1999-11 259500 55900 1999-12 260300 56100 2000-01 261000 56300 2000-02 261400 56400 2000-03 261700 56400 2000-04 261900 56400 2000-05 261900 56400 2000-06 261900 56400 2000-07 262000 56500 2000-08 262200 56600 2000-09 262600 56700 2000-10 263100 56900 2000-11 263700 57000 2000-12 264200 57200 2001-01 264400 57400 2001-02 264400 57500 2001-03 264100 57600 2001-04 263600 57700 2001-05 263000 57800 2001-06 262200 57900 2001-07 261300 57900 2001-08 260400 58000 2001-09 259600 58100 2001-10 258900 58100 2001-11 258400 58100 2001-12 258100 58000 2002-01 257900 58000 2002-02 257900 57900 2002-03 258000 57900 2002-04 258200 58000 2002-05 258400 58200 2002-06 258900 58600 2002-07 259400 59000 2002-08 260000 59600 2002-09 260500 60200 2002-10 261000 60800 2002-11 261400 61400 2002-12 261800 61900 2003-01 262100 62300 2003-02 262400 62600 2003-03 262600 62900 2003-04 262700 63000 2003-05 262800 63000 2003-06 262900 63000 2003-07 263000 63000 2003-08 263000 62900 2003-09 262800 62900 2003-10 262800 63100 2003-11 263000 63300 2003-12 263800 63600 2004-01 265400 64200 2004-02 267800 65000 2004-03 270600 65900 2004-04 273500 66700 2004-05 275900 67500 2004-06 277900 68100 2004-07 279500 68600 2004-08 280900 68900 2004-09 282300 69200 2004-10 283800 69600 2004-11 285400 70100 2004-12 287100 70500 2005-01 288600 70900 2005-02 290100 71200 2005-03 291600 71400 2005-04 293200 71700 2005-05 294800 71900 2005-06 296500 72200 2005-07 298100 72300 2005-08 299400 72300 2005-09 300300 72200 2005-10 300800 72000 2005-11 301100 71700 2005-12 301500 71500 2006-01 302200 71400 2006-02 303100 71400 2006-03 304300 71400 2006-04 305600 71600 2006-05 306700 71700 2006-06 307500 71700 2006-07 308200 71700 2006-08 309000 71600 2006-09 310100 71600 2006-10 311300 71700 2006-11 312600 71900 2006-12 313600 72000 2007-01 314700 72100 2007-02 315500 72100 2007-03 316300 72300 2007-04 317200 72600 2007-05 318300 72800 2007-06 319300 72900 2007-07 320600 73100 2007-08 322100 73000 2007-09 323600 72700 2007-10 324800 72600 2007-11 325500 72500 2007-12 325200 72400 2008-01 324000 72100 2008-02 321700 71500 2008-03 318900 70800 2008-04 316200 70100 2008-05 314000 69400 2008-06 312100 68900 2008-07 310900 68600 2008-08 309800 68200 2008-09 308900 67500 2008-10 308100 67000 2008-11 307300 66800 2008-12 306800 66700 2009-01 306700 66700 2009-02 306500 66600 2009-03 306100 66500 2009-04 305400 66300 2009-05 304400 65900 2009-06 303100 65700 2009-07 302000 65800 2009-08 300900 65900 2009-09 300000 65700 2009-10 299300 65500 2009-11 298700 65500 2009-12 298600 65500 2010-01 297800 65500 2010-02 297900 65800 2010-03 297300 65300 2010-04 295600 64300 2010-05 294400 64000 2010-06 294300 63500 2010-07 293300 62500 2010-08 292600 62200 2010-09 292600 62400 2010-10 292300 61600 2010-11 291600 61100 2010-12 291100 61000 2011-01 290900 60500 2011-02 290600 59900 2011-03 290700 59700 2011-04 291200 59700 2011-05 291600 59500 2011-06 291500 58900 2011-07 291200 57700 2011-08 290800 57500 2011-09 290700 58600 2011-10 291100 59400 2011-11 292100 59300 2011-12 293200 59000 2012-01 294200 58700 2012-02 294900 58300 2012-03 295800 58000 2012-04 296900 2012-05 298100 57900 58300 2012-06 299500 58800 2012-07 301500 58900 2012-08 303000 58800 2012-09 303200 58900 2012-10 303400 59600 2012-11 304200 60400 2012-12 304800 60200 2013-01 305200 59500 2013-02 305800 59300 2013-03 307100 59500 2013-04 309200 59000 2013-05 311100 58600 2013-06 312600 59700 2013-07 314400 61600 2013-08 316200 62000 2013-09 317500 61200 2013-10 318500 60600 2013-11 320000 59800 2013-12 321300 59600 2014-01 322400 60300 2014-02 323500 60500 2014-03 325000 60200 2014-04 326500 61400 2014-05 328400 62300 2014-06 331100 61500 2014-07 334200 60800 2014-08 337400 61300 2014-09 341000 61500 2014-10 344700 61500 2014-11 348500 61500 2014-12 352100 61300 2015-01 355300 61100 2015-02 358300 61400 2015-03 362000 62300 2015-04 365900 63000 2015-05 369500 62600 2015-06 371900 62700 2015-07 373500 64100 2015-08 375400 2015-09 378400 65200 65300 2015-10 381300 65300 2015-11 383900 65800 2015-12 386700 66800 2016-01 389300 67600 2016-02 390700 67900 2016-03 391700 68400 2016-04 394100 69200 2016-05 397700 70000 2016-06 403200 70900 2016-07 410400 71900 2016-08 417000 73000 2016-09 421700 74400 2016-10 427000 76600 2016-11 431900 79000 2016-12 435900 80700 2017-01 439900 81900 2017-02 444300 83600 2017-03 448400 85200 2017-04 451900 86700 2017-05 454200 88700 2017-06 454500 90500 2017-07 454600 91400 2017-08 455700 91600 2017-09 458300 92000 2017-10 459300 92500 2017-11 457700 93700 2017-12 456500 95200 2018-01 459700 97500 2018-02 465300 100500 2018-03 470000 103100 2018-04 472700 104700 2018-05 475500 106600 2018-06 477300 108300 2018-07 477300 109000 Year (Year # is just for reference. Do not use year as a variable when you see correlation. Cisco Systems Walt Disney (CSCO) (DIS) General Electric Exxon Mobil TECO Energy Progressive (GE) (XOM) Corp. (PGR) Newmont Minning Corp. (NEM) 1991 195.26 12.81 33.33 17.63 23.7 5.37 -1.22 1992 137.36 50.22 11.76 0.41 -0.3 61.81 1.86 1993 64.39 -0.87 22.66 3.27 8.71 39.06 40.12 1994 8.7 7.92 -2.74 -2.77 -10.5 -13.58 -37.53 1995 112.46 27.99 41.18 31.16 26.54 39.64 26.04 1996 70.52 18.47 37.33 21.74 -5.85 37.85 -1.38 1997 31.43 41.94 48.42 24.87 16.58 77.92 -34.36 1998 149.72 -9.09 39.01 19.51 0.22 41.29 -37.87 1999 130.84 -2.5 51.72 10.17 -34.15 -56.83 34.25 2000 -28.59 -1.07 -7.07 7.91 74.41 41.71 -30.36 2001 -52.65 -28.4 -16.39 -9.59 -18.95 44.08 12 2002 -27.66 -21.28 -39.25 -11.09 -41.04 -0.27 51.91 2003 84.96 43.04 27.23 17.34 -6.85 68.43 67.45 2004 -20.26 19.16 17.82 25.02 6.52 1.5 -8.64 2005 -11.39 -13.78 -3.97 9.58 11.92 37.65 20.24 2006 59.64 42.97 6.16 36.43 0.29 -17.04 -15.45 2007 -0.95 -5.81 -0.38 22.26 -0.12 -20.84 8.15 2008 -39.79 -29.71 56.3 -14.79 -28.24 -22.7 -16.65 2009 46.87 42.13 -6.6 -14.58 31.34 21.47 16.24 2010 -15.5 16.31 20.89 7.23 9.74 10.45 29.85 2011 -10.63 -0.03 -2.08 15.92 7.53 -1.81 -2.31 2012 8.68 32.77 17.2 2.11 -12.43 8.15 -22.61 2013 14.15 53.44 33.54 16.93 2.86 29.24 -50.41 2014 24.01 23.29 -9.85 -8.65 18.85 -1.03 -17.93 2015 -2.37 11.56 23.27 -15.68 30.06 17.82 -4.81 2016 11.29 -0.82 1.44 15.79 3.38 11.64 89.38