K6 X fx 4 B OWNER K L TOTALROOMS BEDROOMS 3 1 4 2 1 1 1 4 2 3 1 1 1 2 4 2 4 2 1 4 2 2 2 1 1 4 5 6 3 3 1 5 1 4 3 2 2 1 4 1 1 3 4 1 2 1 3 1 5 A 1 PARID 2 0001 G002 3 0001 G002 4 0001 G002 5 0001 G002 6 0001 G002 7 0001G002 8 0001G002 9 0001 G002 10 0001 G002 11 00016002 12 0001 G002 13 0001 G002 14 0001 G002 15 0001 G002 16 0001 G002 17 0001 G002 18 0001 G002 19 0001 G002 20 00016002 21 0001 G002 22 0001 G002 23 0001 G002 24 0001 G002 25 0001 G002 26 0001 G002 27 0001 G002 28 0001 G002 29 0001 G002 30 00016002 31 0001 G002 32 0001 G002 33 0001 G002 34 0001H003 35 0001 G002 36 0001 G002 37 0001 G002 D E F G H 1 SALEPRICE COUNTYTOTAL LOCALTOTAL FAIRMARKETTOTAL YEARBLT EXTERIORFINISH GRADE CONDITION 320000 227000 227000 227000 2007 Concrete VERY GOOD+ GOOD 333325 315000 315000 315000 2007 Concrete VERY GOOD + AVERAGE 400000 394600 394600 394600 2007 Concrete VERY GOOD + AVERAGE 330000 206900 206900 206900 2007 Concrete VERY GOOD + AVERAGE 387000 295700 313700 313700 2007 Concrete VERY GOOD + AVERAGE 554500 466600 484600 484600 2007 Concrete VERY GOOD + AVERAGE 615000 529400 547400 547400 2007 Brick VERY GOOD + EXCELLENT 593900 519100 519100 519100 2015 Concrete VERY GOOD + AVERAGE 892900 874900 892900 892900 2007 Concrete VERY GOOD + AVERAGE 1050000 532000 550000 550000 2007 Concrete VERY GOOD + AVERAGE 660000 578000 596000 596000 2007 Concrete VERY GOOD + AVERAGE 770243 671700 671700 671700 2007 Concrete VERY GOOD + GOOD 425000 295700 313700 313700 2007 Concrete VERY GOOD + AVERAGE 245000 209600 227600 227600 2007 Concrete VERY GOOD + AVERAGE 422000 397200 415200 415200 2007 Concrete VERY GOOD + AVERAGE 325000 237500 255500 255500 2007 Concrete VERY GOOD + AVERAGE 435000 417000 435000 435000 2007 Concrete VERY GOOD + AVERAGE 439000 295800 313800 313800 2007 Concrete VERY GOOD + AVERAGE 311750 209500 227500 227500 2007 Concrete VERY GOOD + AVERAGE 415000 397200 415200 415200 2007 Concrete VERY GOOD + AVERAGE 560000 415500 415500 415500 2007 Concrete VERY GOOD + AVERAGE 400000 237200 255200 255200 2007 Concrete VERY GOOD + AVERAGE 330000 357000 375000 2007 Concrete VERY GOOD + AVERAGE 472500 397300 415300 415300 2007 Concrete VERY GOOD + AVERAGE 500000 397600 415600 415600 2007 Concrete VERY GOOD + AVERAGE 535000 468400 468400 468400 2007 Concrete VERY GOOD + AVERAGE 426250 295700 313700 313700 2007 Concrete VERY GOOD + AVERAGE 269200 209600 227600 227600 2007 Concrete VERY GOOD + AVERAGE 462500 415300 415300 415300 2007 Concrete VERY GOOD+ GOOD 540000 454000 472000 472000 2007 Concrete VERY GOOD + AVERAGE 394000 303200 303200 303200 2007 Concrete VERY GOOD + AVERAGE 355900 479500 497500 497500 2007 Concrete VERY GOOD + AVERAGE 270000 250500 250500 250500 1906 Concrete VERY GOOD + GOOD 273200 344800 344800 344800 2007 Concrete VERY GOOD + AVERAGE 2394693 2376693 2394693 2394693 2007 Concrete VERY GOOD + AVERAGE 654500 411000 411000 411000 2007 Concrete VERY GOOD + AVERAGE 1 3 2 2 1 M N 0 FULLBATHS FINISHEDLIVINGAREA 1 890 1 1434 2 1483 1 877 2 1388 2 1450 2 1343 2 1304 2 2249 2 2185 2 2102 2 1529 2 1275 1 889 2 1666 1 1107 2 1763 2 1275 1 889 2 1666 2 1668 1 1107 2 1763 2 1666 2 1668 2 1763 2 1 889 2 1666 2 1465 1 1315 2 1989 2 1172 2 1367 2 3663 2 1514 1 4 1 3 1 4 2 2 2 5 1 3 1 375000 3 4 1 1 1 2 2 3 2. 2 5 1 5 1 4 1275 1 3 1 4 1 2 2 1 1 4 1 3 1 5 3 2 1 4 4 2 1 1 6 3 2 1 4 1 3 1 2 2 1 4 2 2 1 4 2 1 4 2 3 1 2 1 2 1 3 2 2 5 4 4 2 2 1 2 1 1 3 2 2 1 3 1 1 1 4 1 1 1 4 2 2 2 2 1 4 1 4 1 1 1 5 3 2 1 4 2 2 1 1 1 1 2 2 38 00016002 39 0001 G002 40 0001 G002 41 0001 G002 42 0001 G002 43 0001 G002 44 0001 G002 45 0001 G002 46 0001 G002 47 0001 G002 48 0001 G002 49 0001 G002 50 0001 G002 51 0001 G002 52 0001 G002 53 0001 G002 54 0001 G002 55 0001 G002 56 0001 G002 57 0001 G002 58 0001 G002 59 0001 G002 60 0001 G002 61 0001H003 62 0001H003 63 0001H003 64 0001H003 65 0001H003 66 0001H003 67 0001H003 68 0001H003 69 0001H003 70 0001H003 71 0001H003 72 0001H003 73 0001H003 74 0001H003 1 930000 381800 592850 294750 424000 1212100 311500 750000 253099 418000 320000 500000 505200 350000 505000 300000 325000 450000 425000 265000 310000 502000 380000 295000 314500 285000 359942 289212 386098 310000 375000 300000 415000 325000 323505 318000 395000 900000 470300 500100 359500 282000 608000 290500 650000 337500 334200 257500 470300 487000 325400 379700 295600 204800 415200 326000 227800 415200 387500 380000 230000 298900 250500 359900 276400 333400 240400 290400 234600 361900 242800 300800 266800 395000 900000 470300 518100 377500 300000 626000 290500 650000 337500 334200 275500 470300 505000 343400 397700 313600 222800 415200 344000 227800 415200 405500 380000 248000 298900 250500 359900 294400 351400 258400 290400 252600 379900 260800 318800 284800 395000 900000 470300 518100 377500 300000 626000 290500 650000 337500 334200 275500 470300 505000 343400 397700 313600 222800 415200 344000 227800 415200 405500 380000 248000 298900 250500 359900 294400 351400 258400 290400 252600 379900 260800 318800 284800 395000 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2015 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete Block VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD AVERAGE 1906 Concrete VERY GOOD+ GOOD 2015 Concrete VERY GOOD + GOOD 1906 Concrete VERY GOOD + GOOD 1905 Concrete VERY GOOD + GOOD 1905 Concrete VERY GOOD + GOOD 1906 Concrete VERY GOOD + GOOD 1906 Concrete EXCELLENT - GOOD 1906 Concrete VERY GOOD + GOOD 1906 Concrete VERY GOOD + GOOD 1906 Concrete VERY GOOD + GOOD 1906 Concrete EXCELLENT - GOOD 1906 Concrete VERY GOOD + GOOD 1905 Concrete VERY GOOD + AVERAGE 1906 Concrete VERY GOOD + AVERAGE 1 1 3 4 3 3 4 5 1926 1855 1529 1310 1357 3140 1399 1884 1257 1367 1107 1858 1567 1578 1761 1275 888 1666 1447 888 1666 1668 1763 1172 1442 1172 1485 1444 1485 1170 1444 1170 1485 1170 1485 1444 1485 1 1 1 1 2 2 3 1 2 1 5 2 2 4 2 2 2 2 5 2 2 2 1 4 2 1 4 2 2 1 3 1 1 4 1 1 2 2 4 2 2 2 2 3 2 1 4 2 2 4 2 1 1 1 2 2 4 2 2. 2. 1 4 3 4 1 1 1 2 2 5 1 1 2 2 1240 1485 4 1 3 1 2 2 1 2 2 1444 2. 4 2 1 4 2 1 4 2 2 2 1 4 2 1 4 2 2 1 5 2 2 1 3 2 1 1 2 75 0001H003 76 0001H003 77 0001H003 78 0001H003 79 0001H003 80 0001H003 81 0001H003 82 0001H003 83 0001H003 84 0002J0019 85 00020019 86 0002J0019 87 0001H003 88 0001H003 89 0001H003 90 0001H003 91 0001H003 92 0001H003 93 0001H003 94 0001H003 95 0001H003 96 0002J0019 97 0002J0019 o 379205 415000 340000 405000 315000 420000 299000 311631 340000 280000 425000 257000 306000 380000 330000 540000 527000 501000 307196 516110 475000 272500 447000 297200 346000 271000 361700 242100 402000 228700 285300 283800 223700 242900 242000 243300 309300 298900 474100 429300 389100 278700 412100 471800 224000 1 315200 364000 289000 361700 260100 420000 246700 303300 301800 241700 242900 242000 261300 309300 298900 492100 447300 407100 278700 412100 489800 242000 292500 315200 364000 289000 361700 260100 420000 246700 303300 301800 241700 242900 242000 261300 309300 298900 492100 447300 407100 278700 412100 489800 242000 292500 2015 Concrete 1905 Concrete 1905 Concrete 1905 Concrete 1905 Concrete 1906 Concrete 1906 Concrete 1905 Concrete 2015 Frame 1900 Brick 1900 Brick 1900 Brick 1905 Concrete 1905 Concrete 2015 Concrete 1905 Concrete 1906 Concrete 1905 Concrete 1905 Concrete 1905 Concrete 1905 Concrete 1900 Brick 1900 Brick VERY GOOD + AVERAGE VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + AVERAGE VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD GOOD + AVERAGE GOOD + AVERAGE GOOD + AVERAGE VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD GOOD + AVERAGE GOOD + AVERAGE 1 1 2 2 2 1 2 1 1485 1172 1485 1172 1485 1442 1998 1998 1998 1172 1485 1442 2126 1485 2123 1242 2123 2084 1998 1998 1 2 1 2 2 4 4 5 7 4 7 6 7 2 1 2 1 2 2 2 2 1 2 1 2 1 2 2 2 2 1 7 2 1 4 2 1 1 292500 4 2 1 Data for property assessment on condominium in Pittsburgh Variable names PARID owner sale price county total local total Description A 16 character unique identifier for the parcel. Numeric code categorizes owner as individuals "REGULAR') VS corporations (2- 'CORPORATION Amount paid for the sale (also called the consideration). The assessed property value (land and building together) for county tax purposes. This amount reflects the remaining assessment after any preferential assessments (such as Clean and Green! or county reductions (such as homesteads or other abatements) have been deducted from the base year market values. The assessed property value (land and building together) for local tax purposes (for schools and municipalities). This amount reflects the remaining assessment after preferential assessments (such as Clean and Green) have been deducted from the base year market values. This value is often higher than the county assessed value since county-only incentives (such as homesteads) have not been deducted. The base year appraised fair market value of land and building together. This value has had no reductions, not even Clean and Green preferential assessment reduction. Allegheny County currently uses a base year of 2012. The original date of construction. The exterior wall type, FRAME, BRICK, CONCRETE. Grade refers to quality of construction: A, X, XX - Have superior materials and workmanship and are typically custom designed or historic homes. faitparket total yearblt exterior finish grade B- Construction has above average construction and may exceed code. C- Is the standard, construction meets code, and is typical of current materials and methods. D-Construction is adequate, but below average with minimal features. E- Construction lacks some basics and may be a "camp" or seasonal structure. Pluses and minuses may be used. condition Code for the overall physical condition or state of repair of a structure, relative to its age. Indicated by number and description: 1- Excellent - Outstanding maintenance. 2- Good - Above ordinary maintenance. 3- Average - Ordinary maintenance, shows normal wear and tear. 4- Fair- Sound but with noticeable deferred maintenance. 5- Poor - Structural deterioration caused by significant and chronic deferred maintenance. 6- Unsound - Not suitable for habitation. 7- Very good - High degree of upkeep. 8- Very poor - Barely livable. Total number of rooms in the main dwelling. total rooms bedrooms This includes rec rooms and FBLA (Finished Basement Living Area). This count is for descriptive purposes only and does not affect assessed value. The total number of separate rooms designed to be used as bedrooms. If a room was designed to be a bedroom but is being utilized for some other purpose, such as a den, it is to be included in this count. This is for descriptive purposes only and does not affect value. A full bath has a toilet, sink and bathing facility (shower or tub). Finished living area, as measured from the outside of the structure. fullbaths finished living area 14201 SQQS2013 Group assignment project 3 Phase I: Data selection process (12 marks) 1. With a data set given, discuss with your group and choose at least ONE QUANTITATIVE and ONE QUALITATIVE variable from the data set. 2. Provide TWO hypotheses statements related to the chosen data no. 2. 3. Give a suitable title for this data project and objective (tally with the hypotheses statements) 4. Data collection. Select 30 data from this file at random using one of the following options a. any random data selection system such as SPSS or Excel, etc. b. manual random selection ii. Write the whole process of the data selection in (0) i. 5. Identify which member to do the following tasks: Describing data using numerical and graphical data description. Testing the hypothesis as described in no. 3. i. ii. 6. Submit Phase 1 by 7th January 2021 which include: i. List of group members and the name of your group. The selected variables iii. Provide two hypotheses related to the chosen data no. 2. iv. A suitable title and objective for your project related to the data. The description of the data selection process vi. Data set V. Full marks = 12 Phase 2: Data analysis (19 marks) 1. Analyze data which already chosen in Phase 1. The analysis consists of descriptive and inferential statistics process. 2. Discuss your finding from the descriptive to the inferential statistics. Relate all the results. 3. You may use any statistical software such as Excel/SPSS/etc. include output where related. 4. Report all your findings in a portfolio within 10 pages. 5. You may attach data, figures, tables or photo on your portfolio. 6. Submit your portfolio by 15rd January 2021. Full marks = 19 K6 X fx 4 B OWNER K L TOTALROOMS BEDROOMS 3 1 4 2 1 1 1 4 2 3 1 1 1 2 4 2 4 2 1 4 2 2 2 1 1 4 5 6 3 3 1 5 1 4 3 2 2 1 4 1 1 3 4 1 2 1 3 1 5 A 1 PARID 2 0001 G002 3 0001 G002 4 0001 G002 5 0001 G002 6 0001 G002 7 0001G002 8 0001G002 9 0001 G002 10 0001 G002 11 00016002 12 0001 G002 13 0001 G002 14 0001 G002 15 0001 G002 16 0001 G002 17 0001 G002 18 0001 G002 19 0001 G002 20 00016002 21 0001 G002 22 0001 G002 23 0001 G002 24 0001 G002 25 0001 G002 26 0001 G002 27 0001 G002 28 0001 G002 29 0001 G002 30 00016002 31 0001 G002 32 0001 G002 33 0001 G002 34 0001H003 35 0001 G002 36 0001 G002 37 0001 G002 D E F G H 1 SALEPRICE COUNTYTOTAL LOCALTOTAL FAIRMARKETTOTAL YEARBLT EXTERIORFINISH GRADE CONDITION 320000 227000 227000 227000 2007 Concrete VERY GOOD+ GOOD 333325 315000 315000 315000 2007 Concrete VERY GOOD + AVERAGE 400000 394600 394600 394600 2007 Concrete VERY GOOD + AVERAGE 330000 206900 206900 206900 2007 Concrete VERY GOOD + AVERAGE 387000 295700 313700 313700 2007 Concrete VERY GOOD + AVERAGE 554500 466600 484600 484600 2007 Concrete VERY GOOD + AVERAGE 615000 529400 547400 547400 2007 Brick VERY GOOD + EXCELLENT 593900 519100 519100 519100 2015 Concrete VERY GOOD + AVERAGE 892900 874900 892900 892900 2007 Concrete VERY GOOD + AVERAGE 1050000 532000 550000 550000 2007 Concrete VERY GOOD + AVERAGE 660000 578000 596000 596000 2007 Concrete VERY GOOD + AVERAGE 770243 671700 671700 671700 2007 Concrete VERY GOOD + GOOD 425000 295700 313700 313700 2007 Concrete VERY GOOD + AVERAGE 245000 209600 227600 227600 2007 Concrete VERY GOOD + AVERAGE 422000 397200 415200 415200 2007 Concrete VERY GOOD + AVERAGE 325000 237500 255500 255500 2007 Concrete VERY GOOD + AVERAGE 435000 417000 435000 435000 2007 Concrete VERY GOOD + AVERAGE 439000 295800 313800 313800 2007 Concrete VERY GOOD + AVERAGE 311750 209500 227500 227500 2007 Concrete VERY GOOD + AVERAGE 415000 397200 415200 415200 2007 Concrete VERY GOOD + AVERAGE 560000 415500 415500 415500 2007 Concrete VERY GOOD + AVERAGE 400000 237200 255200 255200 2007 Concrete VERY GOOD + AVERAGE 330000 357000 375000 2007 Concrete VERY GOOD + AVERAGE 472500 397300 415300 415300 2007 Concrete VERY GOOD + AVERAGE 500000 397600 415600 415600 2007 Concrete VERY GOOD + AVERAGE 535000 468400 468400 468400 2007 Concrete VERY GOOD + AVERAGE 426250 295700 313700 313700 2007 Concrete VERY GOOD + AVERAGE 269200 209600 227600 227600 2007 Concrete VERY GOOD + AVERAGE 462500 415300 415300 415300 2007 Concrete VERY GOOD+ GOOD 540000 454000 472000 472000 2007 Concrete VERY GOOD + AVERAGE 394000 303200 303200 303200 2007 Concrete VERY GOOD + AVERAGE 355900 479500 497500 497500 2007 Concrete VERY GOOD + AVERAGE 270000 250500 250500 250500 1906 Concrete VERY GOOD + GOOD 273200 344800 344800 344800 2007 Concrete VERY GOOD + AVERAGE 2394693 2376693 2394693 2394693 2007 Concrete VERY GOOD + AVERAGE 654500 411000 411000 411000 2007 Concrete VERY GOOD + AVERAGE 1 3 2 2 1 M N 0 FULLBATHS FINISHEDLIVINGAREA 1 890 1 1434 2 1483 1 877 2 1388 2 1450 2 1343 2 1304 2 2249 2 2185 2 2102 2 1529 2 1275 1 889 2 1666 1 1107 2 1763 2 1275 1 889 2 1666 2 1668 1 1107 2 1763 2 1666 2 1668 2 1763 2 1 889 2 1666 2 1465 1 1315 2 1989 2 1172 2 1367 2 3663 2 1514 1 4 1 3 1 4 2 2 2 5 1 3 1 375000 3 4 1 1 1 2 2 3 2. 2 5 1 5 1 4 1275 1 3 1 4 1 2 2 1 1 4 1 3 1 5 3 2 1 4 4 2 1 1 6 3 2 1 4 1 3 1 2 2 1 4 2 2 1 4 2 1 4 2 3 1 2 1 2 1 3 2 2 5 4 4 2 2 1 2 1 1 3 2 2 1 3 1 1 1 4 1 1 1 4 2 2 2 2 1 4 1 4 1 1 1 5 3 2 1 4 2 2 1 1 1 1 2 2 38 00016002 39 0001 G002 40 0001 G002 41 0001 G002 42 0001 G002 43 0001 G002 44 0001 G002 45 0001 G002 46 0001 G002 47 0001 G002 48 0001 G002 49 0001 G002 50 0001 G002 51 0001 G002 52 0001 G002 53 0001 G002 54 0001 G002 55 0001 G002 56 0001 G002 57 0001 G002 58 0001 G002 59 0001 G002 60 0001 G002 61 0001H003 62 0001H003 63 0001H003 64 0001H003 65 0001H003 66 0001H003 67 0001H003 68 0001H003 69 0001H003 70 0001H003 71 0001H003 72 0001H003 73 0001H003 74 0001H003 1 930000 381800 592850 294750 424000 1212100 311500 750000 253099 418000 320000 500000 505200 350000 505000 300000 325000 450000 425000 265000 310000 502000 380000 295000 314500 285000 359942 289212 386098 310000 375000 300000 415000 325000 323505 318000 395000 900000 470300 500100 359500 282000 608000 290500 650000 337500 334200 257500 470300 487000 325400 379700 295600 204800 415200 326000 227800 415200 387500 380000 230000 298900 250500 359900 276400 333400 240400 290400 234600 361900 242800 300800 266800 395000 900000 470300 518100 377500 300000 626000 290500 650000 337500 334200 275500 470300 505000 343400 397700 313600 222800 415200 344000 227800 415200 405500 380000 248000 298900 250500 359900 294400 351400 258400 290400 252600 379900 260800 318800 284800 395000 900000 470300 518100 377500 300000 626000 290500 650000 337500 334200 275500 470300 505000 343400 397700 313600 222800 415200 344000 227800 415200 405500 380000 248000 298900 250500 359900 294400 351400 258400 290400 252600 379900 260800 318800 284800 395000 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2015 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete Block VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD + AVERAGE 2007 Concrete VERY GOOD AVERAGE 1906 Concrete VERY GOOD+ GOOD 2015 Concrete VERY GOOD + GOOD 1906 Concrete VERY GOOD + GOOD 1905 Concrete VERY GOOD + GOOD 1905 Concrete VERY GOOD + GOOD 1906 Concrete VERY GOOD + GOOD 1906 Concrete EXCELLENT - GOOD 1906 Concrete VERY GOOD + GOOD 1906 Concrete VERY GOOD + GOOD 1906 Concrete VERY GOOD + GOOD 1906 Concrete EXCELLENT - GOOD 1906 Concrete VERY GOOD + GOOD 1905 Concrete VERY GOOD + AVERAGE 1906 Concrete VERY GOOD + AVERAGE 1 1 3 4 3 3 4 5 1926 1855 1529 1310 1357 3140 1399 1884 1257 1367 1107 1858 1567 1578 1761 1275 888 1666 1447 888 1666 1668 1763 1172 1442 1172 1485 1444 1485 1170 1444 1170 1485 1170 1485 1444 1485 1 1 1 1 2 2 3 1 2 1 5 2 2 4 2 2 2 2 5 2 2 2 1 4 2 1 4 2 2 1 3 1 1 4 1 1 2 2 4 2 2 2 2 3 2 1 4 2 2 4 2 1 1 1 2 2 4 2 2. 2. 1 4 3 4 1 1 1 2 2 5 1 1 2 2 1240 1485 4 1 3 1 2 2 1 2 2 1444 2. 4 2 1 4 2 1 4 2 2 2 1 4 2 1 4 2 2 1 5 2 2 1 3 2 1 1 2 75 0001H003 76 0001H003 77 0001H003 78 0001H003 79 0001H003 80 0001H003 81 0001H003 82 0001H003 83 0001H003 84 0002J0019 85 00020019 86 0002J0019 87 0001H003 88 0001H003 89 0001H003 90 0001H003 91 0001H003 92 0001H003 93 0001H003 94 0001H003 95 0001H003 96 0002J0019 97 0002J0019 o 379205 415000 340000 405000 315000 420000 299000 311631 340000 280000 425000 257000 306000 380000 330000 540000 527000 501000 307196 516110 475000 272500 447000 297200 346000 271000 361700 242100 402000 228700 285300 283800 223700 242900 242000 243300 309300 298900 474100 429300 389100 278700 412100 471800 224000 1 315200 364000 289000 361700 260100 420000 246700 303300 301800 241700 242900 242000 261300 309300 298900 492100 447300 407100 278700 412100 489800 242000 292500 315200 364000 289000 361700 260100 420000 246700 303300 301800 241700 242900 242000 261300 309300 298900 492100 447300 407100 278700 412100 489800 242000 292500 2015 Concrete 1905 Concrete 1905 Concrete 1905 Concrete 1905 Concrete 1906 Concrete 1906 Concrete 1905 Concrete 2015 Frame 1900 Brick 1900 Brick 1900 Brick 1905 Concrete 1905 Concrete 2015 Concrete 1905 Concrete 1906 Concrete 1905 Concrete 1905 Concrete 1905 Concrete 1905 Concrete 1900 Brick 1900 Brick VERY GOOD + AVERAGE VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + AVERAGE VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD GOOD + AVERAGE GOOD + AVERAGE GOOD + AVERAGE VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD VERY GOOD + GOOD GOOD + AVERAGE GOOD + AVERAGE 1 1 2 2 2 1 2 1 1485 1172 1485 1172 1485 1442 1998 1998 1998 1172 1485 1442 2126 1485 2123 1242 2123 2084 1998 1998 1 2 1 2 2 4 4 5 7 4 7 6 7 2 1 2 1 2 2 2 2 1 2 1 2 1 2 2 2 2 1 7 2 1 4 2 1 1 292500 4 2 1 Data for property assessment on condominium in Pittsburgh Variable names PARID owner sale price county total local total Description A 16 character unique identifier for the parcel. Numeric code categorizes owner as individuals "REGULAR') VS corporations (2- 'CORPORATION Amount paid for the sale (also called the consideration). The assessed property value (land and building together) for county tax purposes. This amount reflects the remaining assessment after any preferential assessments (such as Clean and Green! or county reductions (such as homesteads or other abatements) have been deducted from the base year market values. The assessed property value (land and building together) for local tax purposes (for schools and municipalities). This amount reflects the remaining assessment after preferential assessments (such as Clean and Green) have been deducted from the base year market values. This value is often higher than the county assessed value since county-only incentives (such as homesteads) have not been deducted. The base year appraised fair market value of land and building together. This value has had no reductions, not even Clean and Green preferential assessment reduction. Allegheny County currently uses a base year of 2012. The original date of construction. The exterior wall type, FRAME, BRICK, CONCRETE. Grade refers to quality of construction: A, X, XX - Have superior materials and workmanship and are typically custom designed or historic homes. faitparket total yearblt exterior finish grade B- Construction has above average construction and may exceed code. C- Is the standard, construction meets code, and is typical of current materials and methods. D-Construction is adequate, but below average with minimal features. E- Construction lacks some basics and may be a "camp" or seasonal structure. Pluses and minuses may be used. condition Code for the overall physical condition or state of repair of a structure, relative to its age. Indicated by number and description: 1- Excellent - Outstanding maintenance. 2- Good - Above ordinary maintenance. 3- Average - Ordinary maintenance, shows normal wear and tear. 4- Fair- Sound but with noticeable deferred maintenance. 5- Poor - Structural deterioration caused by significant and chronic deferred maintenance. 6- Unsound - Not suitable for habitation. 7- Very good - High degree of upkeep. 8- Very poor - Barely livable. Total number of rooms in the main dwelling. total rooms bedrooms This includes rec rooms and FBLA (Finished Basement Living Area). This count is for descriptive purposes only and does not affect assessed value. The total number of separate rooms designed to be used as bedrooms. If a room was designed to be a bedroom but is being utilized for some other purpose, such as a den, it is to be included in this count. This is for descriptive purposes only and does not affect value. A full bath has a toilet, sink and bathing facility (shower or tub). Finished living area, as measured from the outside of the structure. fullbaths finished living area 14201 SQQS2013 Group assignment project 3 Phase I: Data selection process (12 marks) 1. With a data set given, discuss with your group and choose at least ONE QUANTITATIVE and ONE QUALITATIVE variable from the data set. 2. Provide TWO hypotheses statements related to the chosen data no. 2. 3. Give a suitable title for this data project and objective (tally with the hypotheses statements) 4. Data collection. Select 30 data from this file at random using one of the following options a. any random data selection system such as SPSS or Excel, etc. b. manual random selection ii. Write the whole process of the data selection in (0) i. 5. Identify which member to do the following tasks: Describing data using numerical and graphical data description. Testing the hypothesis as described in no. 3. i. ii. 6. Submit Phase 1 by 7th January 2021 which include: i. List of group members and the name of your group. The selected variables iii. Provide two hypotheses related to the chosen data no. 2. iv. A suitable title and objective for your project related to the data. The description of the data selection process vi. Data set V. Full marks = 12 Phase 2: Data analysis (19 marks) 1. Analyze data which already chosen in Phase 1. The analysis consists of descriptive and inferential statistics process. 2. Discuss your finding from the descriptive to the inferential statistics. Relate all the results. 3. You may use any statistical software such as Excel/SPSS/etc. include output where related. 4. Report all your findings in a portfolio within 10 pages. 5. You may attach data, figures, tables or photo on your portfolio. 6. Submit your portfolio by 15rd January 2021. Full marks = 19