09 Feb Using the file?Longitudinal Survey, subset the data to select only those individuals who lived in an urban area. Reduce the dimensionality of the data by converting numerical variables such as
see attached files
Option 1:
Using the file Longitudinal Survey, subset the data to select only those individuals who lived in an urban area. Reduce the dimensionality of the data by converting numerical variables such as age, height, weight, number of years of education, number of siblings, family size, number of weeks employed, self-esteem scale, and income into a smaller set of principal components that retain at least 90% of the information in the original data. After showing your work, summarize your findings in a paragraph containing no more than five sentences. It should be clear how PCA improved one's ability to interpret the data. Note: you will need to standardize the data prior to PCA as the scales of the variables are different.
Show your workings and Summarize the findings.
Option 2:
Using the file House Price, choose one of the college towns in the data set. Reduce the dimensionality of the data by converting numerical variables such as number of bedrooms, number of bathrooms, home square footage, lot square footage, and age of the house into a smaller set of the principal components that retain at least 90% of the information in the original data. Then use the principal components as predictor variables for building two de novo models for predicting sale prices of houses. Summarize each of the two models in two or three sentences each.
Show your workings and develop models of home prices.
Query4
Record | Sale_amount | Sale_date | Beds | Baths | Sqft_home | Sqft_lot | Type | Build_year | Town | University |
1 | 295000 | 5/31/16 | 5 | 3 | 2020 | 38332.8 | Single Family | 1976 | Ames, IA | Iowa State University |
2 | 240000 | 6/20/16 | 4 | 2 | 1498 | 54014.4 | Single Family | 2002 | Ames, IA | Iowa State University |
3 | 385000 | 5/31/16 | 5 | 4 | 4000 | 85813.2 | Single Family | 2001 | Ames, IA | Iowa State University |
4 | 268000 | 4/12/16 | 3 | 2.5 | 2283 | 118918.8 | Single Family | 1972 | Ames, IA | Iowa State University |
5 | 186000 | 4/5/16 | 3 | 1.25 | 1527 | 15681.6 | Single Family | 1975 | Ames, IA | Iowa State University |
6 | 302500 | 3/2/16 | 4 | 3 | 3117 | 33105.6 | Single Family | 1976 | Ames, IA | Iowa State University |
7 | 223000 | 6/2/16 | 3 | 2 | 1218 | 25264.8 | Single Family | 1975 | Ames, IA | Iowa State University |
8 | 225000 | 5/7/16 | 3 | 3 | 3000 | 30056.4 | Single Family | 1969 | Ames, IA | Iowa State University |
9 | 215000 | 4/14/16 | 5 | 2 | 2963 | 14374.8 | Single Family | 1965 | Ames, IA | Iowa State University |
10 | 285100 | 2/12/16 | 3 | 4 | 1680 | 48351.6 | Single Family | 1987 | Ames, IA | Iowa State University |
11 | 269000 | 6/1/16 | 3 | 2 | 1682 | 43560 | Single Family | 1932 | Ames, IA | Iowa State University |
12 | 650000 | 6/2/16 | 4 | 3.5 | 2535 | 82764 | Single Family | 1998 | Ames, IA | Iowa State University |
13 | 203500 | 4/18/16 | 4 | 2 | 1277 | 10628 | Single Family | 1970 | Ames, IA | Iowa State University |
14 | 265000 | 6/28/16 | 4 | 2.5 | 1340 | 10290 | Single Family | 1998 | Ames, IA | Iowa State University |
15 | 180000 | 2/24/16 | 3 | 3.5 | 1709 | 13068 | Single Family | 1991 | Ames, IA | Iowa State University |
16 | 192000 | 2/29/16 | 3 | 3 | 1470 | 8139 | Single Family | 1995 | Ames, IA | Iowa State University |
17 | 246500 | 3/23/16 | 4 | 3.5 | 1776 | 8712 | Single Family | 1996 | Ames, IA | Iowa State University |
18 | 258000 | 6/14/16 | 4 | 2.5 | 1752 | 9174 | Single Family | 1996 | Ames, IA | Iowa State University |
19 | 240500 | 3/17/16 | 3 | 2.25 | 1502 | 6821 | Single Family | 1985 | Ames, IA | Iowa State University |
20 | 218000 | 7/1/16 | 2 | 3.25 | 1864 | 28749.6 | Single Family | 1978 | Ames, IA | Iowa State University |
21 | 249000 | 5/20/16 | 3 | 2.25 | 1381 | 13939.2 | Single Family | 1983 | Ames, IA | Iowa State University |
22 | 246000 | 6/24/16 | 3 | 2.75 | 1969 | 11761.2 | Single Family | 1977 | Ames, IA | Iowa State University |
23 | 264000 | 4/29/16 | 3 | 2 | 1660 | 13068 | Single Family | 1979 | Ames, IA | Iowa State University |
24 | 180000 | 7/15/16 | 3 | 3 | 1277 | 10140 | Single Family | 1975 | Ames, IA | Iowa State University |
25 | 196000 | 4/4/16 | 4 | 3 | 1768 | 10000 | Single Family | 1973 | Ames, IA | Iowa State University |
26 | 262000 | 6/15/16 | 3 | 1.75 | 1650 | 14374.8 | Single Family | 1900 | Ames, IA | Iowa State University |
27 | 138000 | 5/10/16 | 3 | 1 | 845 | 8712 | Single Family | 1970 | Ames, IA | Iowa State University |
28 | 143500 | 5/10/16 | 2 | 1 | 858 | 7340 | Single Family | 1971 | Ames, IA | Iowa State University |
29 | 122000 | 5/10/16 | 2 | 2 | 987 | 1680 | Single Family | 1972 | Ames, IA | Iowa State University |
30 | 145000 | 2/10/16 | 2 | 2 | 836 | 2280 | Single Family | 1977 | Ames, IA | Iowa State University |
31 | 250000 | 4/27/16 | 3 | 1.75 | 1462 | 10361 | Single Family | 2005 | Ames, IA | Iowa State University |
32 | 361000 | 5/3/16 | 5 | 5 | 1800 | 14374.8 | Single Family | 2007 | Ames, IA | Iowa State University |
33 | 305000 | 3/28/16 | 4 | 2.5 | 2363 | 13068 | Single Family | 2004 | Ames, IA | Iowa State University |
34 | 232500 | 3/28/16 | 3 | 4 | 1560 | 11761.2 | Single Family | 2005 | Ames, IA | Iowa State University |
35 | 233500 | 5/12/16 | 4 | 4 | 2531 | 10797 | Single Family | 1999 | Ames, IA | Iowa State University |
36 | 256000 | 5/2/16 | 3 | 2.5 | 2035 | 9420 | Single Family | 1999 | Ames, IA | Iowa State University |
37 | 189000 | 1/26/16 | 3 | 3 | 1320 | 7750 | Single Family | 2003 | Ames, IA | Iowa State University |
38 | 350000 | 2/1/16 | 4 | 3.5 | 2166 | 13068 | Single Family | 2000 | Ames, IA | Iowa State University |
39 | 410000 | 2/23/16 | 5 | 3.5 | 2759 | 10890 | Single Family | 1994 | Ames, IA | Iowa State University |
40 | 332000 | 7/8/16 | 5 | 3.5 | 2197 | 10010 | Single Family | 1993 | Ames, IA | Iowa State University |
41 | 265000 | 6/17/16 | 3 | 4 | 1728 | 8791 | Single Family | 2003 | Ames, IA | Iowa State University |
42 | 275100 | 5/23/16 | 4 | 3 | 1455 | 20037.6 | Single Family | 2003 | Ames, IA | Iowa State University |
43 | 192500 | 5/31/16 | 2 | 2.25 | 1472 | 8012 | Single Family | 1992 | Ames, IA | Iowa State University |
44 | 185000 | 2/25/16 | 4 | 2.25 | 995 | 9343 | Single Family | 1984 | Ames, IA | Iowa State University |
45 | 140000 | 2/24/16 | 3 | 2 | 926 | 7800 | Single Family | 1984 | Ames, IA | Iowa State University |
46 | 210000 | 2/25/16 | 3 | 2.5 | 1603 | 8712 | Single Family | 1992 | Ames, IA | Iowa State University |
47 | 135500 | 2/10/16 | 5 | 2 | 912 | 8020 | Single Family | 1964 | Ames, IA | Iowa State University |
48 | 318000 | 5/5/16 | 4 | 3 | 2094 | 11325.6 | Single Family | 1990 | Ames, IA | Iowa State University |
49 | 343000 | 3/17/16 | 5 | 3.5 | 2755 | 10500 | Single Family | 1994 | Ames, IA | Iowa State University |
50 | 345000 | 2/26/16 | 3 | 3 | 1557 | 4356 | Single Family | 1999 | Ames, IA | Iowa State University |
51 | 315000 | 6/6/16 | 3 | 2 | 1480 | 12632.4 | Single Family | 1997 | Ames, IA | Iowa State University |
52 | 278000 | 6/7/16 | 3 | 4 | 1970 | 13068 | Single Family | 1979 | Ames, IA | Iowa State University |
53 | 265000 | 5/3/16 | 3 | 3 | 1351 | 13503.6 | Single Family | 1996 | Ames, IA | Iowa State University |
54 | 168000 | 4/11/16 | 3 | 2 | 1298 | 8712 | Single Family | 1969 | Ames, IA | Iowa State University |
55 | 237500 | 3/17/16 | 4 | 2.5 | 2380 | 9979 | Single Family | 1967 | Ames, IA | Iowa State University |
56 | 260000 | 5/10/16 | 3 | 3.25 | 1754 | 7501 | Single Family | 2001 | Ames, IA | Iowa State University |
57 | 237000 | 2/26/16 | 3 | 1.75 | 1594 | 9548 | Single Family | 1993 | Ames, IA | Iowa State University |
58 | 205000 | 6/21/16 | 2 | 2.5 | 1334 | 9650 | Single Family | 1977 | Ames, IA | Iowa State University |
59 | 252000 | 4/1/16 | 4 | 2 | 2385 | 10819 | Single Family | 1965 | Ames, IA | Iowa State University |
60 | 187900 | 7/8/16 | 3 | 3 | 1232 | 9600 | Single Family | 1966 | Ames, IA | Iowa State University |
61 | 178000 | 2/9/16 | 3 | 3 | 1310 | 17859.6 | Single Family | 1970 | Ames, IA | Iowa State University |
62 | 169500 | 4/5/16 | 3 | 2 | 1050 | 10659 | Single Family | 1961 | Ames, IA | Iowa State University |
63 | 180000 | 5/17/16 | 2 | 2 | 1048 | 7395 | Single Family | 1956 | Ames, IA | Iowa State University |