ID Price SqFt Bedrooms Bathrooms Offers Brick Neighborhood 1 114300 1790 2 2 2 N
ID: 3337709 • Letter: I
Question
ID Price SqFt Bedrooms Bathrooms Offers Brick Neighborhood 1 114300 1790 2 2 2 No East 2 114200 2030 4 2 3 No East 3 114800 1740 3 2 1 No East 4 94700 1980 3 2 3 No East 5 119800 2130 3 3 3 No East 6 114600 1780 3 2 2 No North 7 151600 1830 3 3 3 Yes West 8 150700 2160 4 2 2 No West 9 119200 2110 4 2 3 No East 10 104000 1730 3 3 3 No East 11 132500 2030 3 2 3 Yes East 12 123000 1870 2 2 2 Yes East 13 102600 1910 3 2 4 No North 14 126300 2150 3 3 5 Yes North 15 176800 2590 4 3 4 No West 16 145800 1780 4 2 1 No West 17 147100 2190 3 3 4 Yes East 18 83600 1990 3 3 4 No North 19 111400 1700 2 2 1 Yes East 20 167200 1920 3 3 2 Yes West 21 116200 1790 3 2 3 No East 22 113800 2000 3 2 4 No North 23 91700 1690 3 2 3 No North 24 106100 1820 3 2 3 Yes North 25 156400 2210 4 3 2 Yes East 26 149300 2290 4 3 3 No North 27 137000 2000 4 2 3 No West 28 99300 1700 3 2 2 No East 29 69100 1600 2 2 3 No North 30 188000 2040 4 3 1 Yes West 31 182000 2250 4 3 3 Yes West 32 112300 1930 2 2 2 Yes North 33 135000 2250 3 3 3 Yes East 34 139600 2280 5 3 4 Yes East 35 117800 2000 2 2 3 No North 36 117100 2080 3 3 3 No North 37 117500 1880 2 2 2 No North 38 147000 2420 4 3 4 No West 39 131300 1720 3 2 1 No West 40 108200 1740 3 2 2 No North 41 106600 1560 2 2 1 No East 42 133600 1840 4 3 2 No West 43 105600 1990 2 2 3 No East 44 154000 1920 3 2 1 Yes East 45 166500 1940 3 3 2 Yes West 46 103200 1810 3 2 3 No East 47 129800 1990 2 3 2 No North 48 90300 2050 3 2 6 No North 49 115900 1980 2 2 2 No East 50 107500 1700 3 2 3 Yes North 51 151100 2100 3 2 3 Yes East 52 91100 1860 2 2 3 No North 53 117400 2150 2 3 4 No North 54 130800 2100 3 2 3 No North 55 81300 1650 3 2 3 No North 56 125700 1720 2 2 2 Yes East 57 140900 2190 3 2 3 Yes East 58 152300 2240 4 3 3 No West 59 138100 1840 3 3 1 No West 60 155400 2090 4 2 1 No West 61 180900 2200 3 3 1 No West 62 100900 1610 2 2 2 No North 63 161300 2220 4 3 2 No West 64 120500 1910 2 3 2 No East 65 130300 1860 3 2 2 No West 66 111100 1450 2 2 1 Yes North 67 126200 2210 3 3 4 No North 68 151900 2040 4 3 3 No East 69 93600 2140 3 2 4 No North 70 165600 2080 4 3 3 No West 71 166700 1950 3 3 3 Yes West 72 157600 2160 4 2 1 No West 73 107300 1650 3 2 3 No North 74 125700 2040 3 3 2 No East 75 144200 2140 3 3 3 No West 76 106900 1900 2 2 2 No North 77 129800 1930 3 2 2 No West 78 176500 2280 4 3 3 Yes West 79 121300 2130 3 2 3 No North 80 143600 1780 4 2 1 No West 81 143400 2190 3 3 4 Yes East 82 184300 2140 4 3 2 Yes West 83 164800 2050 2 2 1 Yes West 84 147700 2410 3 3 2 No East 85 90500 1520 2 2 3 No North 86 188300 2250 4 3 2 Yes West 87 102700 1900 4 2 4 No North 88 172500 1880 3 3 1 Yes West 89 127700 1930 3 3 2 No North 90 97800 2010 2 2 4 No North 91 143100 1920 4 2 2 No West 92 116500 2150 3 2 2 No East 93 142600 2110 3 2 2 No West 94 157100 2080 3 3 2 No East 95 160600 2150 4 3 3 Yes West 96 152500 1970 2 2 1 Yes West 97 133300 2440 3 3 3 No East 98 126800 2000 2 2 1 Yes East 99 145500 2060 3 2 1 No West 100 171000 2080 3 3 2 Yes West 101 103200 2010 3 2 5 No North 102 123100 2260 3 3 5 No East 103 136800 2410 3 3 4 No East 104 211200 2440 4 3 3 Yes West 105 82300 1910 3 2 4 No East 106 146900 2530 4 3 4 No West 107 108500 2130 3 2 4 No North 108 134000 1890 3 2 1 Yes East 109 117000 1990 3 3 3 Yes East 110 108700 2110 3 2 3 No East 111 111600 1710 2 2 1 No North 112 114900 1740 2 2 2 No North 113 123600 1940 2 2 2 Yes East 114 115700 2000 3 2 3 Yes North 115 124500 2010 4 3 2 No East 116 102500 1900 3 3 3 No North 117 199500 2290 5 4 1 Yes West 118 117800 1920 3 2 2 No North 119 150200 1950 3 2 3 Yes North 120 109700 1920 2 2 4 No North 121 110400 1930 2 3 3 No North 122 105600 1930 3 3 3 No East 123 144800 2060 2 2 1 Yes East 124 119700 1900 3 3 3 Yes East 125 147900 2160 4 3 3 Yes East 126 113500 2070 2 2 2 No North 127 149900 2020 3 3 1 No West 128 124600 2250 3 3 4 No North Perform a correlation analysis of all quantitative variables except ID. Which two variables have the largest magnitude correlation? Which two variables have the smallest magnitude correlation? What does the largest magnitude imply if we perform a regression analysis next? Are there any negative correlations? Are these correlations intuitive? If not, why not? ID Price SqFt Bedrooms Bathrooms Offers Brick Neighborhood 1 114300 1790 2 2 2 No East 2 114200 2030 4 2 3 No East 3 114800 1740 3 2 1 No East 4 94700 1980 3 2 3 No East 5 119800 2130 3 3 3 No East 6 114600 1780 3 2 2 No North 7 151600 1830 3 3 3 Yes West 8 150700 2160 4 2 2 No West 9 119200 2110 4 2 3 No East 10 104000 1730 3 3 3 No East 11 132500 2030 3 2 3 Yes East 12 123000 1870 2 2 2 Yes East 13 102600 1910 3 2 4 No North 14 126300 2150 3 3 5 Yes North 15 176800 2590 4 3 4 No West 16 145800 1780 4 2 1 No West 17 147100 2190 3 3 4 Yes East 18 83600 1990 3 3 4 No North 19 111400 1700 2 2 1 Yes East 20 167200 1920 3 3 2 Yes West 21 116200 1790 3 2 3 No East 22 113800 2000 3 2 4 No North 23 91700 1690 3 2 3 No North 24 106100 1820 3 2 3 Yes North 25 156400 2210 4 3 2 Yes East 26 149300 2290 4 3 3 No North 27 137000 2000 4 2 3 No West 28 99300 1700 3 2 2 No East 29 69100 1600 2 2 3 No North 30 188000 2040 4 3 1 Yes West 31 182000 2250 4 3 3 Yes West 32 112300 1930 2 2 2 Yes North 33 135000 2250 3 3 3 Yes East 34 139600 2280 5 3 4 Yes East 35 117800 2000 2 2 3 No North 36 117100 2080 3 3 3 No North 37 117500 1880 2 2 2 No North 38 147000 2420 4 3 4 No West 39 131300 1720 3 2 1 No West 40 108200 1740 3 2 2 No North 41 106600 1560 2 2 1 No East 42 133600 1840 4 3 2 No West 43 105600 1990 2 2 3 No East 44 154000 1920 3 2 1 Yes East 45 166500 1940 3 3 2 Yes West 46 103200 1810 3 2 3 No East 47 129800 1990 2 3 2 No North 48 90300 2050 3 2 6 No North 49 115900 1980 2 2 2 No East 50 107500 1700 3 2 3 Yes North 51 151100 2100 3 2 3 Yes East 52 91100 1860 2 2 3 No North 53 117400 2150 2 3 4 No North 54 130800 2100 3 2 3 No North 55 81300 1650 3 2 3 No North 56 125700 1720 2 2 2 Yes East 57 140900 2190 3 2 3 Yes East 58 152300 2240 4 3 3 No West 59 138100 1840 3 3 1 No West 60 155400 2090 4 2 1 No West 61 180900 2200 3 3 1 No West 62 100900 1610 2 2 2 No North 63 161300 2220 4 3 2 No West 64 120500 1910 2 3 2 No East 65 130300 1860 3 2 2 No West 66 111100 1450 2 2 1 Yes North 67 126200 2210 3 3 4 No North 68 151900 2040 4 3 3 No East 69 93600 2140 3 2 4 No North 70 165600 2080 4 3 3 No West 71 166700 1950 3 3 3 Yes West 72 157600 2160 4 2 1 No West 73 107300 1650 3 2 3 No North 74 125700 2040 3 3 2 No East 75 144200 2140 3 3 3 No West 76 106900 1900 2 2 2 No North 77 129800 1930 3 2 2 No West 78 176500 2280 4 3 3 Yes West 79 121300 2130 3 2 3 No North 80 143600 1780 4 2 1 No West 81 143400 2190 3 3 4 Yes East 82 184300 2140 4 3 2 Yes West 83 164800 2050 2 2 1 Yes West 84 147700 2410 3 3 2 No East 85 90500 1520 2 2 3 No North 86 188300 2250 4 3 2 Yes West 87 102700 1900 4 2 4 No North 88 172500 1880 3 3 1 Yes West 89 127700 1930 3 3 2 No North 90 97800 2010 2 2 4 No North 91 143100 1920 4 2 2 No West 92 116500 2150 3 2 2 No East 93 142600 2110 3 2 2 No West 94 157100 2080 3 3 2 No East 95 160600 2150 4 3 3 Yes West 96 152500 1970 2 2 1 Yes West 97 133300 2440 3 3 3 No East 98 126800 2000 2 2 1 Yes East 99 145500 2060 3 2 1 No West 100 171000 2080 3 3 2 Yes West 101 103200 2010 3 2 5 No North 102 123100 2260 3 3 5 No East 103 136800 2410 3 3 4 No East 104 211200 2440 4 3 3 Yes West 105 82300 1910 3 2 4 No East 106 146900 2530 4 3 4 No West 107 108500 2130 3 2 4 No North 108 134000 1890 3 2 1 Yes East 109 117000 1990 3 3 3 Yes East 110 108700 2110 3 2 3 No East 111 111600 1710 2 2 1 No North 112 114900 1740 2 2 2 No North 113 123600 1940 2 2 2 Yes East 114 115700 2000 3 2 3 Yes North 115 124500 2010 4 3 2 No East 116 102500 1900 3 3 3 No North 117 199500 2290 5 4 1 Yes West 118 117800 1920 3 2 2 No North 119 150200 1950 3 2 3 Yes North 120 109700 1920 2 2 4 No North 121 110400 1930 2 3 3 No North 122 105600 1930 3 3 3 No East 123 144800 2060 2 2 1 Yes East 124 119700 1900 3 3 3 Yes East 125 147900 2160 4 3 3 Yes East 126 113500 2070 2 2 2 No North 127 149900 2020 3 3 1 No West 128 124600 2250 3 3 4 No North Perform a correlation analysis of all quantitative variables except ID. Which two variables have the largest magnitude correlation? Which two variables have the smallest magnitude correlation? What does the largest magnitude imply if we perform a regression analysis next? Are there any negative correlations? Are these correlations intuitive? If not, why not?Explanation / Answer
Answer to the questions as below:
The highest correlation is between Price and Sqft variables. The correlation comes out to be .553. This is also the highest in magnitude.
The smallest correlation is between Price and Offers. The correlation is -.313, which is also the one smallest in magnitude. As asked in the last question, this is the only negative correlation.
The largest magnitude if we perform the regression analysis next means that this variable has a higher chance of coming out as significant variable.
Commentry regarding intuitiveness between correlation of variables
These correation are intuitive. If no. of rooms increases then Price increases. If the area ( in Sqft) increases then then the Price increases. The only one counterintuitive is the correlation between offers and Price. If there are more no. of offers, it should mean more price ( a positive correlation), however that doesn't seem to be the case. Hence, the correlation between Price and Offers is not intuituve