Q2 data
| Property # | Profit | Size | Advertexp | Mgrperf | Neighbors | Attract |
| 1 | 166.855 | 0 | 12.72 | 3 | 8 | 1 |
| 2 | 299.980 | 0 | 42.50 | 3 | 5 | 2 |
| 3 | 840.615 | 1 | 32.35 | 4 | 28 | 3 |
| 4 | 201.433 | 0 | 10.09 | 5 | 4 | 2 |
| 5 | 872.874 | 1 | 20.27 | 4 | 31 | 3 |
| 6 | 186.493 | 1 | 23.70 | 2 | 9 | 3 |
| 7 | 300.901 | 1 | 19.11 | 3 | 9 | 4 |
| 8 | 755.746 | 1 | 32.87 | 4 | 19 | 3 |
| 9 | 808.764 | 1 | 40.37 | 4 | 17 | 3 |
| 10 | 332.976 | 0 | 25.37 | 4 | 13 | 2 |
| 11 | 590.922 | 1 | 46.40 | 3 | 6 | 2 |
| 12 | 329.644 | 0 | 39.47 | 2 | 12 | 1 |
| 13 | 829.321 | 1 | 38.99 | 5 | 7 | 3 |
| 14 | 713.162 | 1 | 42.72 | 4 | 13 | 4 |
| 15 | 341.979 | 0 | 29.17 | 3 | 24 | 2 |
| 16 | 322.471 | 0 | 43.33 | 3 | 6 | 2 |
| 17 | 608.782 | 1 | 40.95 | 3 | 3 | 2 |
| 18 | 134.128 | 0 | 26.01 | 3 | 9 | 1 |
| 19 | 194.545 | 0 | 22.53 | 5 | 11 | 1 |
| 20 | 494.896 | 1 | 21.52 | 4 | 12 | 3 |
| 21 | 206.774 | 1 | 27.91 | 3 | 4 | 3 |
| 22 | 565.189 | 1 | 31.51 | 4 | 8 | 3 |
| 23 | 279.658 | 0 | 33.81 | 3 | 7 | 3 |
| 24 | 89.235 | 0 | 43.45 | 1 | 6 | 2 |
| 25 | 372.522 | 1 | 17.41 | 4 | 2 | 2 |
| 26 | 89.877 | 0 | 29.45 | 4 | 7 | 3 |
| 27 | 91.116 | 0 | 23.86 | 2 | 11 | 1 |
| 28 | 201.996 | 0 | 32.04 | 5 | 6 | 2 |
| 29 | 673.770 | 1 | 44.16 | 5 | 11 | 2 |
| 30 | 326.183 | 0 | 45.10 | 4 | 7 | 4 |
| 31 | 382.848 | 0 | 28.69 | 4 | 14 | 1 |
| 32 | 730.514 | 1 | 43.87 | 4 | 13 | 2 |
| 33 | 457.112 | 1 | 24.84 | 3 | 12 | 1 |
| 34 | 823.807 | 1 | 49.36 | 3 | 20 | 3 |
| 35 | 425.945 | 1 | 32.73 | 3 | 9 | 4 |
| 36 | 530.593 | 1 | 14.23 | 3 | 20 | 3 |
| 37 | 449.527 | 1 | 27.69 | 3 | 9 | 3 |
| 38 | 297.237 | 0 | 35.02 | 3 | 6 | 3 |
| 39 | 198.809 | 0 | 45.02 | 2 | 10 | 2 |
| 40 | 420.942 | 1 | 13.65 | 4 | 9 | 1 |
| 41 | 581.784 | 1 | 48.10 | 3 | 9 | 5 |
| 42 | 229.914 | 0 | 15.01 | 4 | 17 | 2 |
| 43 | 683.982 | 1 | 49.55 | 4 | 10 | 3 |
| 44 | 801.843 | 1 | 41.93 | 5 | 11 | 3 |
| 45 | 203.803 | 1 | 11.46 | 2 | 10 | 3 |
| 46 | 101.432 | 0 | 18.82 | 3 | 13 | 3 |
| 47 | 254.989 | 1 | 40.94 | 3 | -0 | 2 |
| 48 | 432.992 | 0 | 46.02 | 3 | 17 | 3 |
| 49 | 496.599 | 1 | 24.53 | 4 | 12 | 3 |
| 50 | 204.977 | 1 | 23.36 | 4 | 5 | 3 |
| 51 | -5.541 | 1 | 16.78 | 1 | 4 | 2 |
| 52 | 645.317 | 1 | 27.97 | 5 | 11 | 3 |
| 53 | 707.284 | 1 | 36.58 | 2 | 20 | 4 |
| 54 | 372.360 | 0 | 14.59 | 3 | 26 | 2 |
| 55 | 190.481 | 1 | 17.92 | 3 | 8 | 2 |
| 56 | 421.723 | 0 | 49.20 | 4 | 9 | 3 |
| 57 | 172.960 | 0 | 11.54 | 4 | 9 | 3 |
| 58 | 413.843 | 0 | 36.03 | 4 | 13 | 1 |
| 59 | 761.802 | 0 | 47.79 | 4 | 26 | 2 |
| 60 | 1322.114 | 1 | 37.38 | 5 | 29 | 4 |
Profit = annual profit in thousands
Size = small (0) or large (1) design
Advertexp = annual spending on local advertising, in thousands
Mgrperf = Performance rating of local manager, on scale where 5 = best and 1 = worst
Attract = Rating of physical attractiveness of property (location, architecture, etc.) on a scale where 4 is best
Neighbors = Quantity and quality of nearby attractions: restaurants, shopping, arts venues, etc. Scale from 0 to 30, where 30 is best
afdybz
Regression_Assignment_data.xlsx
