The data file contains data for a random sample of 1,000 houses located in the greater Wilmington, DE area The data fields included are as follows Home Price Living area (square feet) Number of bedrooms Number of bathrooms Age (years) In developing both your model and the report, address the items below 1 There are numerous variables that are believed to be predictors of housing prices, including the ones in the data set for this project Using the web, find the key variables that determine home price including any not include in this data set 2 Using Data Data Analysis Descriptive Statistics in Excel, calculate the mean, median, range and standard deviation of each variable and summarize the results in table 3 Using Excel, create histograms for price of the home, living area (square feet) and age of the home Be sure to give each chart a title and label the axes clearly 4 Using Excel, create scatterplots of each variable with each other variable Be sure to give each chart a title and label the axes clearly 5 Using Data Data Analysis Correlation in Excel, calculate the correlation coefficient each variable with each other variable 6 Using Data Data Analysis Regression in Excel, run 4 separate simple regression models to predict the dependent variable (price of the home) with each of the independent variables Use an alpha level of 0 05 to determine significance 7 Using Data Data Analysis Regression in Excel, run a multiple regression model to predict the dependent variable with all 4 independent variables Use an alpha level of 0 05 to determine significance Living Area (Square Feet) Number of Bedrooms Number of Bathrooms Age (Years) 1,344 3 0 2 0 13 822 2 0 1 0 173 1,540 2 0 1 0 115 1,320 3 0 1 0 90 1,214 3 0 1 0 103 882 3 0 1 5 71 960 2 0 1 0 11 1,328 4 0 1 0 103 1,235 3 0 1 0 84 800 2 0 1 0 55 1,363 3 0 2 0 39 743 3 0 1 0 105 960 2 0 1 5 12 1,144 3 0 1 0 15 1,310 4 0 1 5 120 792 2 0 1 0 55 1,688 5 0 2 0 119 990 2 0 1 5 75 924 1 0 1 0 104 1,668 4 0 1 5 115 1,664 3 0 1 5 76 2,039 3 0 1 0 55 1,228 2 0 1 0 53 1,064 3 0 1 0 95 1,628 2 0 1 0 124 1,536 4 0 1 5 30 672 2 0 1 0 46 1,298 3 0 1 0 106 813 2 0 1 0 68 1,196 4 0 1 5 56 924 3 0 1 0 39 1,653 3 0 2 0 79 1,040 2 0 1 0 19 1,216 2 0 1 0 101 986 3 0 1 0 133 1,170 2 0 1 0 110 840 1 0 1 0 57 976 2 0 2 0 21 2,087 3 0 2 5 0 957 3 0 1 0 45 1,594 4 0 1 5 81 864 3 0 1 5 114 1,928 4 0 2 0 134 1,708 2 0 1 0 39 2,708 4 0 2 0 21 728 2 0 1 0 22 988 2 0 1 0 20 912 2 0 1 5 19 995 3 0 1 0 47 896 2 0 1 0 48 908 2 0 1 0 19 1,620 4 0 1 5 99 1,704 2 0 1 0 177 1,080 3 0 2 0 15 908 2 0 1 0 19 1,536 3 0 2 0 105 908 2 0 1 0 19 2,634 4 0 2 5 83 1,572 4 0 1 5 41 1,225 3 0 1 0 48 1,600 3 0 1 5 16 1,380 2 0 1 5 0 1,336 2 0 1 5 20 912 2 0 1 5 19 1,008 3 0 1 0 41 1,518 3 0 1 0 130 1,480 3 0 1 5 14 1,272 4 0 1 5 115 1,480 2 0 2 5 14 924 3 0 1 0 15 924 3 0 1 0 15 2,043 4 0 1 5 94 2,068 4 0 1 0 104 912 2 0 1 5 20 1,527 2 0 2 0 17 1,140 2 0 1 5 18 1,392 2 0 1 0 17 976 2 0 2 0 23 1,270 3 0 1 0 110 1,572 4 0 1 5 50 929 2 0 1 5 22 1,480 3 0 1 5 14 1,000 3 0 1 0 91 960 3 0 1 0 51 1,480 3 0 1 5 19 1,132 2 0 1 0 25 1,480 2 0 2 5 14 960 2 0 1 0 48 1,216 3 0 1 0 129 912 2 0 1 5 16 1,200 3 0 2 0 10 1,256 3 0 1 5 19 957 3 0 1 0 49 1,120 3 0 1 0 14 929 2 0 1 5 21 1,392 3 0 1 5 21 908 2 0 1 0 17 1,300 3 0 1 0 10 1,281 2 0 2 5 19 1,368 3 0 1 0 34 912 2 0 1 5 20 988 2 0 2 0 19 784 1 0 1 0 44 1,022 3 0 1 0 55 924 2 0 1 0 19 1,324 3 0 1 5 5 1,184 2 0 1 5 19 1,385 2 0 1 5 17 1,480 3 0 1 5 17 960 3 0 1 0 48 1,480 2 0 2 5 16 912 3 0 1 0 37 1,375 2 0 1 5 22 1,150 3 0 1 0 45 924 2 0 1 0 19 912 3 0 1 0 34 1,240 2 0 1 5 17 1,380 4 0 1 0 105 1,480 3 0 1 5 15 912 2 0 1 5 20 912 2 0 1 5 20 912 2 0 1 5 18 1,480 3 0 1 5 19 1,244 4 0 1 5 53 1,219 2 0 1 5 19 1,548 3 0 1 5 85 1,276 2 0 2 0 26 1,061 3 0 1 0 48 1,480 2 0 2 5 16 912 2 0 1 5 18 1,184 2 0 1 5 18 1,184 2 0 1 5 18 1,355 3 0 1 0 60 1,406 2 0 1 5 19 1,158 3 0 1 5 14 1,480 3 0 1 5 16 937 2 0 1 0 19 924 2 0 1 0 20 1,281 2 0 2 5 18 690 3 0 1 0 114 912 3 0 1 0 31 1,064 3 0 1 0 45 1,628 2 0 1 5 30 1,360 2 0 1 0 79 1,184 3 0 2 0 19 1,314 2 0 1 5 19 912 2 0 1 5 18 1,480 2 0 1 5 17 1,034 3 0 1 5 15 988 2 0 1 0 20 1,375 2 0 1 5 21 1,754 4 0 1 0 110 1,281 2 0 1 0 8 1,040 3 0 1 0 12 1,032 2 0 1 0 23 1,232 3 0 1 0 43 960 3 0 1 0 19 1,820 4 0 1 5 35 1,852 4 0 2 0 37 1,492 3 0 2 5 16 1,214 2 0 1 5 17 1,184 2 0 1 5 20 1,172 3 0 2 5 73 1,302 2 0 1 5 16 882 3 0 1 5 71 1,680 3 0 2 0 15 1,202 2 0 1 5 18 1,227 3 0 1 0 115 1,184 3 0 2 0 18 1,480 3 0 1 5 15 1,168 3 0 2 0 21 1,248 3 0 1 0 46 1,492 3 0 1 5 16 1,344 3 0 1 5 16 1,176 2 0 1 5 31 1,034 2 0 1 5 14 1,560 3 0 1 5 16 1,314 2 0 1 5 21 1,476 3 0 2 0 6 1,375 2 0 1 5 21 1,700 3 0 1 0 25 1,486 3 0 1 5 16 1,170 2 0 2 0 10 1,302 2 0 1 5 17 1,480 3 0 1 5 19 1,056 3 0 1 0 47 898 2 0 1 0 57 1,290 3 0 2 0 16 1,463 3 0 1 5 125 1,480 2 0 1 5 15 2,116 4 0 2 0 74 1,673 2 0 2 0 18 1,673 2 0 2 0 18 912 2 0 1 5 19 1,852 4 0 1 0 147 1,184 3 0 2 0 21 1,144 3 0 1 5 44 1,096 3 0 1 0 67 908 2 0 1 0 21 1,100 3 0 1 0 93 864 3 0 1 0 128 972 3 0 1 0 40 1,480 3 0 1 5 21 1,184 3 0 2 0 20 1,148 3 0 1 0 7 1,144 2 0 1 0 16 1,308 2 0 1 0 17 936 3 0 1 0 34 1,472 3 0 1 0 28 1,592 3 0 2 0 16 1,276 3 0 2 0 29 840 2 0 1 0 2 1,008 3 0 1 0 38 1,802 4 0 2 0 56 1,184 2 0 1 5 18 1,228 3 0 1 5 21 1,272 3 0 1 0 43 1,375 2 0 1 5 20 1,308 3 0 1 0 26 1,056 2 0 2 0 7 1,388 3 0 1 0 60 1,544 3 0 2 0 72 1,288 3 0 1 0 32 1,292 3 0 1 5 25 1,840 3 0 1 0 8 1,480 3 0 1 5 19 1,480 3 0 1 5 22 1,464 2 0 1 0 87 1,514 3 0 1 5 19 1,198 2 0 1 0 13 880 3 0 1 0 56 812 2 0 1 0 115 1,239 3 0 1 0 33 1,456 3 0 1 5 155 1,176 3 0 2 0 5 1,342 2 0 1 0 41 775 2 0 1 0 47 1,218 3 0 1 5 0 1,385 2 0 1 5 17 1,480 3 0 1 5 20 1,652 3 0 1 5 105 1,800 3 0 1 5 83 911 2 0 1 0 114 1,266 3 0 1 0 134 1,568 3 0 1 5 18 1,888 3 0 1 0 18 1,056 3 0 1 0 27 912 2 0 1 5 20 1,142 3 0 1 5 18 1,248 3 0 1 5 0 1,272 3 0 1 5 1 1,380 3 0 1 5 2 1,032 3 0 1 0 4 1,560 3 0 1 0 31 1,564 3 0 1 0 54 878 2 0 1 0 28 1,711 3 0 1 0 112 1,758 3 0 2 0 25 1,270 3 0 1 5 18 1,834 4 0 2 0 65 1,375 2 0 1 5 20 1,138 3 0 1 0 98 1,350 3 0 1 5 26 1,314 2 0 1 5 20 1,380 3 0 1 0 3 1,760 4 0 1 5 133 1,177 3 0 1 5 36 1,656 3 0 1 0 94 1,142 2 0 2 0 40 1,240 3 0 2 0 18 1,920 3 0 1 0 34 960 3 0 1 0 40 1,098 2 0 1 0 113 1,164 3 0 2 0 7 1,053 3 0 1 0 41 1,560 3 0 1 5 5 960 2 0 2 0 11 1,514 3 0 2 0 17 1,428 3 0 2 0 85 1,736 3 0 2 0 37 1,332 3 0 1 0 45 1,700 2 0 2 0 15 912 2 0 1 0 14 1,480 3 0 1 5 18 1,184 3 0 2 0 17 1,422 3 0 1 5 20 1,242 3 0 2 0 30 1,479 3 0 1 5 17 1,272 3 0 1 0 31 1,107 3 0 1 0 43 1,486 3 0 1 5 16 1,184 3 0 2 0 18 1,322 3 0 1 0 63 1,404 3 0 1 5 28 1,456 4 0 1 0 54 1,542 3 0 2 5 10 988 3 0 1 0 10 1,536 2 0 1 0 55 1,040 3 0 1 0 39 1,492 3 0 2 5 17 1,295 3 0 1 5 125 1,694 3 0 2 0 15 1,227 2 0 2 0 19 2,128 4 0 2 0 7 1,298 3 0 1 0 44 1,592 3 0 1 5 18 936 3 0 1 0 35 1,164 3 0 2 0 5 1,572 3 0 1 5 16 1,506 3 0 1 5 24 912 2 0 1 0 68 1,364 2 0 1 5 20 1,480 3 0 1 5 17 1,560 2 0 1 0 25 1,411 3 0 1 0 48 1,476 3 0 1 5 24 1,512 4 0 1 5 61 2,028 3 0 2 0 27 967 4 0 2 0 55 1,404 3 0 2 0 7 1,056 2 0 1 0 5 1,120 3 0 2 0 7 1,248 3 0 2 0 14 2,238 3 0 1 5 114 1,498 2 0 1 5 0 1,498 2 0 1 5 0 1,348 2 0 2 5 18 1,412 3 0 1 5 103 1,308 3 0 1 0 29 2,268 3 0 1 0 25 1,637 3 0 1 5 54 2,256 4 0 1 5 124 1,170 4 0 1 5 26 1,440 3 0 1 0 32 1,404 3 0 2 0 72 1,400 3 0 1 5 17 1,856 3 0 1 5 36 1,612 3 0 1 0 34 1,209 2 0 1 0 73 1,632 3 0 1 5 14 1,416 3 0 1 5 5 1,302 3 0 2 0 35 1,092 5 0 1 0 72 1,620 3 0 2 5 1 1,272 3 0 1 5 1 1,164 3 0 2 0 8 1,468 4 0 1 0 51 1,092 3 0 1 5 35 1,678 3 0 2 5 1 1,099 2 0 1 0 9 1,836 3 0 2 0 27 1,173 3 0 1 0 16 1,326 2 0 1 5 19 1,253 2 0 1 5 16 1,605 3 0 2 5 0 1,760 4 0 1 0 37 864 3 0 1 5 37 1,268 3 0 1 0 25 1,592 3 0 1 5 18 1,592 3 0 1 5 18 1,471 3 0 2 5 4 1,370 3 0 1 0 27 1,216 3 0 1 0 51 720 3 0 1 0 113 1,019 2 0 1 5 16 1,210 2 0 1 0 17 1,416 3 0 1 5 11 2,040 5 0 2 5 127 1,480 3 0 2 5 16 1,488 3 0 2 5 1 1,688 3 0 1 0 29 1,343 2 0 2 5 15 1,508 3 0 1 5 19 1,554 3 0 1 5 103 1,215 3 0 1 5 41 1,242 2 0 2 0 3 1,260 2 0 1 5 27 1,512 3 0 2 0 16 2,088 3 0 1 0 29 1,635 4 0 1 5 52 1,593 3 0 1 0 63 1,792 2 0 2 5 24 1,248 3 0 2 0 11 1,052 2 0 1 5 15 1,586 3 0 1 5 49 1,595 3 0 2 0 6 1,200 3 0 1 5 1 1,600 3 0 1 0 57 2,110 3 0 2 0 52 1,394 4 0 1 0 33 1,274 3 0 1 5 14 1,456 3 0 1 0 23 1,564 3 0 2 0 13 1,512 3 0 1 5 13 1,368 3 0 1 0 33 1,468 2 0 1 5 161 1,512 3 0 1 5 13 1,326 4 0 2 0 7 1,334 3 0 1 5 7 1,480 3 0 2 5 16 1,716 4 0 2 0 4 1,364 2 0 1 5 19 1,666 3 0 2 5 1 1,768 4 0 1 5 48 1,780 2 0 2 5 25 2,133 4 0 1 5 34 1,501 3 0 2 0 44 1,279 3 0 1 0 31 1,676 3 0 1 5 14 1,500 3 0 1 5 31 1,496 3 0 1 0 37 2,488 3 0 2 0 24 1,327 2 0 2 0 35 1,610 3 0 2 0 17 1,420 3 0 1 5 13 1,952 4 0 2 5 31 1,460 2 0 2 0 17 1,475 3 0 2 0 20 1,946 4 0 1 5 18 1,508 3 0 1 5 21 1,623 4 0 1 5 36 1,479 2 0 1 5 20 1,486 3 0 2 5 0 1,152 3 0 1 0 36 1,880 3 0 2 0 7 1,352 2 0 1 5 11 1,892 3 0 2 0 26 1,290 3 0 1 5 16 1,092 3 0 1 5 33 1,530 3 0 2 0 20 1,164 3 0 1 0 54 1,551 4 0 1 0 97 1,508 3 0 1 5 19 1,728 4 0 1 5 12 1,800 2 0 1 0 49 1,673 3 0 1 0 27 1,576 3 0 1 5 18 1,719 3 0 1 5 25 1,400 3 0 1 5 35 1,248 3 0 2 0 37 1,608 3 0 1 0 63 1,760 4 0 3 0 135 2,308 2 0 3 0 5 1,296 4 0 2 0 51 1,666 3 0 2 5 0 1,980 4 0 1 0 205 1,900 3 0 1 5 12 1,322 3 0 1 0 130 1,244 2 0 1 5 13 1,590 3 0 2 5 0 1,693 3 0 1 5 26 2,254 4 0 1 5 31 1,554 2 0 2 0 20 1,596 3 0 1 5 49 1,873 4 0 2 5 32 1,874 3 0 2 5 31 1,740 3 0 1 5 36 952 3 0 1 0 102 1,982 3 0 1 0 133 1,242 2 0 2 0 2 2,016 3 0 1 5 16 1,920 3 0 2 0 31 1,744 4 0 1 5 35 1,568 3 0 1 5 18 1,360 4 0 1 0 53 1,918 3 0 2 0 29 1,376 3 0 1 5 14 1,612 3 0 1 5 37 1,572 3 0 1 5 7 1,274 3 0 2 0 20 1,292 3 0 2 0 4 1,512 3 0 1 5 13 1,642 3 0 2 0 11 1,536 3 0 2 0 6 1,372 3 0 1 5 26 1,832 4 0 2 0 47 1,376 3 0 2 0 25 1,666 3 0 2 5 1 984 3 0 1 0 41 2,026 4 0 2 5 1 892 2 0 1 0 113 1,989 4 0 1 5 104 1,056 2 0 1 0 5 1,580 5 0 1 5 26 1,561 3 0 1 5 18 1,656 3 0 1 5 18 1,832 3 0 1 5 30 1,821 3 0 2 5 0 1,582 3 0 1 5 11 1,590 3 0 2 5 3 1,680 4 0 1 0 27 1,668 2 0 2 0 16 864 3 0 1 5 39 1,782 3 0 1 5 36 1,475 3 0 1 5 21 1,391 3 0 2 0 12 1,856 3 0 1 5 37 1,470 3 0 1 5 12 1,734 4 0 1 5 34 1,397 2 0 1 5 14 2,208 3 0 2 5 17 1,864 3 0 1 5 154 792 3 0 1 0 36 1,592 3 0 1 5 9 1,664 3 0 1 5 14 1,470 3 0 2 5 11 1,664 3 0 2 0 25 1,632 4 0 2 5 30 1,611 4 0 2 0 83 1,666 4 0 1 5 38 1,668 3 0 2 0 18 1,785 3 0 2 5 1 1,664 3 0 2 0 33 1,652 3 0 2 0 20 1,212 3 0 1 5 6 1,423 3 0 1 5 9 1,512 3 0 1 5 7 1,374 3 0 1 5 44 1,510 3 0 2 5 0 1,792 3 0 2 0 17 1,890 3 0 2 5 27 1,890 4 0 2 0 30 1,512 3 0 2 5 18 1,508 3 0 2 0 16 1,600 4 0 2 0 35 1,875 4 0 2 5 31 1,578 3 0 2 5 11 1,508 3 0 2 0 20 1,043 3 0 1 0 104 1,720 4 0 2 0 31 1,560 3 0 2 0 4 1,872 4 0 1 5 32 1,820 4 0 1 5 45 2,400 3 0 2 0 26 1,984 2 0 2 5 11 1,466 3 0 1 0 62 1,644 4 0 2 5 20 1,886 3 0 1 5 31 1,785 3 0 2 5 1 1,704 3 0 2 5 17 1,944 3 0 2 5 0 2,470 4 0 2 5 26 1,440 2 0 2 0 66 2,310 4 0 2 5 38 1,747 3 0 2 5 1 1,540 3 0 1 5 16 1,540 3 0 1 5 16 1,332 3 0 1 5 9 2,601 4 0 2 5 19 1,792 3 0 2 5 6 1,734 4 0 2 5 29 1,756 3 0 1 5 24 1,911 4 0 1 5 35 1,672 3 0 2 5 0 1,720 3 0 2 0 27 1,836 4 0 1 5 106 2,310 4 0 2 5 33 1,656 3 0 1 5 19 1,666 3 0 2 5 2 1,092 3 0 1 0 41 1,664 3 0 2 0 34 1,910 4 0 2 5 19 1,804 3 0 2 5 0 1,836 3 0 2 5 15 1,512 3 0 1 5 14 1,696 3 0 2 5 5 1,512 3 0 2 0 12 1,561 4 0 1 5 17 1,561 3 0 1 5 16 1,350 2 0 1 5 1 1,794 3 0 2 0 37 1,665 4 0 2 0 27 2,078 4 0 1 5 33 1,732 3 0 1 5 17 2,262 4 0 2 0 21 1,612 3 0 2 0 15 1,294 3 0 1 5 17 1,336 3 0 2 0 11 1,500 2 0 2 0 18 1,344 2 0 1 5 15 1,887 4 0 2 5 27 1,758 4 0 2 0 26 1,560 2 0 1 0 43 1,910 4 0 2 5 20 2,044 3 0 2 5 16 1,601 3 0 1 5 8 1,456 3 0 2 0 1 1,158 3 0 1 5 7 1,656 3 0 1 5 17 1,806 3 0 2 5 0 1,348 2 0 2 0 11 1,804 3 0 2 5 2 2,011 4 0 2 5 12 1,872 3 0 1 5 18 1,552 3 0 1 5 9 1,886 3 0 2 5 16 1,720 3 0 1 5 19 2,334 4 0 2 0 39 2,516 3 0 2 0 40 1,908 3 0 2 5 25 1,811 3 0 2 5 19 1,124 3 0 1 0 26 2,039 4 0 2 5 18 2,310 4 0 2 5 33 1,785 3 0 2 5 1 1,772 3 0 2 0 0 1,664 3 0 3 0 10 1,212 2 0 1 0 87 1,110 3 0 1 0 115 1,498 3 0 1 5 10 1,664 3 0 2 0 37 1,740 3 0 1 5 26 1,852 4 0 2 5 16 1,872 3 0 2 0 16 2,088 3 0 2 0 2 1,876 3 0 2 5 1 2,311 4 0 2 5 20 1,016 2 0 2 0 41 1,888 3 0 2 0 6 1,620 3 0 2 0 0 2,576 5 0 2 5 34 1,796 3 0 2 5 14 2,310 4 0 2 5 33 1,430 3 0 2 5 5 1,774 3 0 2 5 1 1,952 4 0 2 0 33 1,820 3 0 2 5 18 1,585 3 0 1 5 16 1,728 3 0 2 5 0 1,822 3 0 1 5 12 1,784 3 0 1 5 104 1,536 3 0 2 5 7 1,550 2 0 2 5 16 1,547 3 0 2 0 11 2,008 4 0 2 5 0 1,812 3 0 2 0 16 1,512 3 0 1 5 15 1,910 4 0 2 5 21 2,056 4 0 1 5 35 1,656 3 0 2 5 18 1,896 3 0 1 5 17 2,124 3 0 2 5 0 1,910 4 0 2 5 18 1,548 3 0 2 0 0 1,970 4 0 2 5 18 2,372 3 0 2 0 2 2,226 4 0 2 5 31 1,126 3 0 2 0 46 2,214 3 0 2 5 22 2,310 5 0 2 5 36 2,475 4 0 2 5 35 1,837 3 0 1 5 18 2,195 3 0 2 0 1 2,162 4 0 2 5 19 1,772 3 0 2 5 14 2,249 4 0 2 5 1 1,064 2 0 1 0 77 2,402 4 0 2 5 28 1,528 3 0 2 5 8 2,564 4 0 2 5 34 2,200 4 0 2 5 1 1,512 3 0 2 0 12 1,512 3 0 2 0 12 2,014 3 0 1 5 32 2,291 4 0 2 5 0 2,002 4 0 2 5 14 2,030 3 0 2 5 3 1,632 4 0 2 0 20 2,600 4 0 2 5 18 1,736 3 0 1 5 17 2,066 4 0 2 5 32 2,294 5 0 2 5 36 2,310 4 0 2 5 31 1,570 3 0 2 0 14 1,815 3 0 2 5 11 2,050 4 0 1 5 33 2,310 4 0 3 0 31 2,648 4 0 2 5 0 1,944 4 0 2 5 25 1,842 3 0 1 5 8 1,924 3 0 2 0 16 2,204 4 0 1 5 31 1,822 3 0 2 5 4 2,396 4 0 2 5 28 2,035 4 0 2 5 35 2,262 4 0 2 5 24 1,758 3 0 2 5 1 1,836 3 0 2 5 9 2,570 5 0 2 5 28 1,250 4 0 1 5 43 2,702 5 0 1 5 31 1,920 3 0 2 5 0 2,152 3 0 2 5 8 2,296 4 0 2 5 19 1,472 4 0 1 5 3 2,212 4 0 2 5 18 1,500 4 0 1 5 208 1,662 3 0 2 0 0 2,271 3 0 2 5 1 2,756 4 0 2 5 33 2,011 4 0 2 5 14 2,328 3 0 2 5 1 1,868 3 0 2 5 13 1,831 3 0 2 0 19 2,027 3 0 2 5 15 2,040 4 0 2 5 1 1,992 4 0 2 5 30 1,742 3 0 2 5 5 2,110 3 0 2 5 9 2,097 3 0 2 5 10 2,320 4 0 2 5 16 2,367 4 0 2 5 4 1,334 2 0 1 5 122 2,203 3 0 2 5 1 2,588 4 0 2 5 31 1,964 4 0 2 5 6 1,726 3 0 2 0 26 2,316 3 0 2 5 7 2,150 4 0 2 0 104 1,879 3 0 2 5 5 1,836 3 0 2 0 0 2,086 4 0 2 5 14 2,088 4 0 2 5 22 1,666 3 0 1 0 140 2,304 4 0 2 5 0 2,096 3 0 3 0 18 2,079 3 0 2 5 11 1,948 3 0 2 5 13 1,730 3 0 2 5 1 2,167 3 0 2 5 8 2,350 3 0 2 5 15 1,932 4 0 2 5 4 2,066 4 0 2 5 35 2,278 4 0 2 5 0 2,359 4 0 2 5 1 1,428 3 0 2 0 20 2,064 4 0 2 5 3 2,144 3 0 2 5 19 2,086 4 0 2 5 17 1,894 3 0 2 0 0 2,500 4 0 3 5 1 1,702 3 0 1 5 16 2,314 4 0 2 5 1 1,971 4 0 2 5 7 2,024 3 0 2 0 25 1,616 2 0 2 0 36 1,971 4 0 2 5 11 1,938 3 0 2 5 26 2,223 4 0 2 5 9 2,275 4 0 2 5 0 840 2 0 1 0 50 1,808 2 0 1 5 6 2,011 4 0 2 5 12 1,690 3 0 2 5 5 1,806 4 0 2 0 40 2,504 4 0 2 5 14 1,680 3 0 2 5 4 1,940 3 0 2 0 9 1,116 3 0 2 0 38 2,119 4 0 2 5 16 2,498 4 0 2 5 38 2,322 4 0 2 5 22 2,564 4 0 2 5 30 2,120 4 0 2 5 9 2,202 4 0 2 5 6 2,250 4 0 2 5 2 2,284 3 0 1 5 29 2,068 4 0 2 5 17 2,464 4 0 2 5 42 2,762 4 0 3 0 1 1,743 3 0 2 5 0 1,927 3 0 2 0 3 2,460 4 0 2 5 1 2,501 4 0 2 5 0 2,425 4 0 2 5 0 1,224 2 0 1 0 63 1,474 3 0 2 0 29 2,024 4 0 2 5 10 2,284 4 0 2 5 18 2,676 4 0 2 5 34 2,310 3 0 2 5 18 2,116 3 0 2 5 0 1,456 3 0 2 0 10 2,284 4 0 2 5 17 2,331 4 0 2 5 1 2,147 4 0 2 5 9 2,656 4 0 2 5 1 2,119 4 0 2 5 14 2,628 3 0 2 5 20 1,876 3 0 2 5 1 2,602 4 0 2 5 1 2,109 2 0 2 5 1 1,752 3 0 2 5 10 2,714 4 0 3 0 1 1,804 3 0 2 5 4 2,550 3 0 2 5 0 2,084 3 0 2 5 5 2,076 3 0 2 5 13 2,539 4 0 2 5 1 1,596 3 0 1 0 29 2,008 4 0 2 5 19 1,994 3 0 2 0 49 1,764 3 0 2 5 8 2,120 3 0 2 5 10 2,328 4 0 2 5 10 2,170 3 0 2 5 3 1,400 3 0 2 0 25 2,266 4 0 2 5 0 2,270 3 0 2 5 0 2,494 3 0 2 5 13 2,022 3 0 2 5 0 2,498 5 0 2 5 36 1,904 2 0 2 0 2 1,643 3 0 2 5 3 1,680 3 0 2 0 27 2,500 4 0 2 5 0 2,286 4 0 2 5 11 2,056 4 0 2 5 2 1,216 3 0 1 5 75 2,388 4 0 2 5 20 2,472 3 0 2 5 0 2,593 4 0 2 5 0 2,498 4 0 2 5 14 1,386 2 0 1 5 92 2,655 4 0 2 5 1 2,655 4 0 2 5 1 2,748 4 0 2 5 0 2,038 3 0 2 5 13 2,219 4 0 2 5 15 2,327 4 0 2 5 10 2,712 4 0 2 5 1 2,058 3 0 2 5 1 2,421 4 0 2 5 13 2,000 3 0 2 5 22 2,472 4 0 2 0 183 2,495 4 0 2 5 26 2,712 5 0 3 0 1 2,668 4 0 2 5 0 2,619 4 0 2 5 4 2,526 4 0 2 5 1 2,738 2 0 2 5 12 1,200 2 0 1 0 65 2,185 3 0 2 5 14 2,216 3 0 2 5 8 2,524 4 0 2 5 6 1,921 3 0 2 0 0 2,510 4 0 2 5 1 2,764 4 0 2 5 1 1,973 3 0 2 5 3 1,986 3 0 2 5 1 2,512 4 0 2 5 0 2,527 4 0 2 5 1 2,577 4 0 2 5 0 1,824 3 0 2 5 11 2,500 4 0 2 5 0 2,310 4 0 2 5 3 2,230 3 0 2 5 1 2,103 4 0 2 5 6 2,623 4 0 2 5 0 2,548 3 0 2 5 3 1,800 3 0 2 5 16 1,980 3 0 2 0 6 2,541 4 0 2 5 5 2,500 4 0 2 5 0 2,116 3 0 2 5 20 2,248 4 0 2 5 7 2,338 4 0 2 5 16 2,434 4 0 2 5 20 2,434 4 0 2 5 20 1,470 3 0 2 5 3 2,294 4 0 3 5 0 2,299 4 0 2 5 6 2,107 2 0 1 0 1 2,405 4 0 2 5 16 2,066 3 0 2 5 2 1,392 3 0 2 5 4 2,412 4 0 2 5 10 2,608 4 0 2 5 4 2,472 4 0 3 5 0 2,300 3 0 2 5 16 2,500 4 0 2 5 11 2,604 4 0 2 5 0 2,936 4 0 2 5 6 2,762 4 0 2 5 17 2,996 4 0 2 5 1 2,250 4 0 2 5 10 2,872 5 0 3 0 0 2,641 4 0 3 0 1 2,641 4 0 3 0 1 2,619 4 0 2 5 0 3,001 4 0 2 5 1 2,572 4 0 2 5 9 1,445 3 0 1 5 17 2,348 4 0 2 5 7 1,921 3 0 2 0 0 2,376 4 0 2 5 10 2,604 4 0 3 0 0 1,708 2 0 2 0 14 1,954 2 0 1 5 66 2,242 3 0 2 5 0 2,346 4 0 2 5 0 2,572 4 0 2 5 6 2,396 3 0 2 5 5 2,810 4 0 2 5 14 1,652 3 0 1 5 4 2,835 4 0 3 0 1 2,445 4 0 2 5 18 1,016 2 0 2 0 41 1,536 3 0 1 5 66 1,908 3 0 2 0 0 2,604 4 0 2 5 1 2,490 4 0 2 5 4 2,394 4 0 2 5 0 1,932 3 0 2 0 0 2,741 4 0 2 5 2 2,612 4 0 2 5 23 3,021 4 0 2 5 21 1,498 2 0 1 0 51 2,464 4 0 2 5 2 2,541 4 0 2 5 5 2,579 4 0 2 5 0 2,242 3 0 2 5 0 2,752 5 0 3 0 9 2,093 3 0 2 5 1 1,675 2 0 2 5 18 2,577 4 0 2 5 1 2,092 4 0 2 5 0 2,143 3 0 2 5 6 2,176 3 0 2 0 36 3,015 4 0 2 5 1 2,280 4 0 2 5 24 1,859 3 0 1 5 85 1,850 4 0 2 5 16 2,772 4 0 2 5 0 2,380 3 0 2 5 9 2,505 4 0 2 5 1 2,809 4 0 2 5 2 2,932 4 0 2 5 31 1,738 3 0 2 0 5 2,641 4 0 2 5 3 1,870 3 0 2 5 4 3,030 4 0 2 5 1 2,993 4 0 2 5 15 3,001 5 0 2 5 0 2,657 4 0 2 5 15 2,329 5 0 2 0 72 3,319 3 0 2 5 20 2,306 3 0 2 5 1 2,815 4 0 2 5 1 3,020 4 0 2 5 1 2,950 4 0 2 5 1 2,988 5 0 2 5 9 2,960 4 0 2 5 1 1,908 3 0 2 0 16 2,000 3 0 2 5 4 3,017 4 0 3 5 0 2,793 3 0 2 5 21 2,931 4 0 3 5 12 2,346 4 0 2 5 1 2,808 4 0 2 5 1 2,058 4 0 2 5 26 2,900 4 0 2 5 1 3,210 3 0 2 5 15 3,020 4 0 2 5 2 2,748 4 0 2 5 3 2,906 4 0 2 5 2 2,310 2 0 3 0 23 847 2 0 1 0 78 3,329 3 0 1 5 14 2,960 4 0 2 5 8 2,880 4 0 2 5 9 2,958 4 0 2 5 0 2,270 3 0 2 5 9 2,843 4 0 2 5 5 3,028 5 0 2 5 0 2,919 4 0 2 5 5 2,892 4 0 3 5 1 2,592 3 0 3 0 1 1,326 3 0 1 0 52 2,733 4 0 2 5 3 2,934 3 0 2 5 9 2,786 4 0 2 5 0 2,576 3 0 2 5 31 3,026 4 0 4 0 1 1,908 4 0 3 5 17 2,926 4 0 3 0 11 2,186 3 0 2 5 12 2,618 3 0 1 5 1 2,322 3 0 2 5 0 2,058 2 0 1 5 49 3,457 3 0 2 5 20 3,003 4 0 3 5 88 3,250 3 0 2 5 23 1,764 4 0 2 5 85 1,764 4 0 2 5 86 780 2 0 1 5 55 2,986 4 0 2 5 12 2,563 4 0 2 0 55 2,586 4 0 3 0 3 2,472 3 0 2 5 6

The Answer is in the image, click to view ...

Question: The data file contains data for a random sample of 1,000 houses located in the greater Wilmington, DE area. The data fields included are as

The data file contains data for a random sample of 1,000 houses located in the greater Wilmington, DE area. The data fields included are as follows: Home Price Living area (square feet) Number of bedrooms Number of bathrooms Age (years) In developing both your model and the report, address the items below. 1. There are numerous variables that are believed to be predictors of housing prices, including the ones in the data set for this project. Using the web, find the key variables that determine home price including any not include in this data set. 2. Using Data>Data Analysis>Descriptive Statistics in Excel, calculate the mean, median, range and standard deviation of each variable and summarize the results in table. 3. Using Excel, create histograms for price of the home, living area (square feet) and age of the home. Be sure to give each chart a title and label the axes clearly. 4. Using Excel, create scatterplots of each variable with each other variable. Be sure to give each chart a title and label the axes clearly. 5. Using Data>Data Analysis>Correlation in Excel, calculate the correlation coefficient each variable with each other variable. 6. Using Data>Data Analysis>Regression in Excel, run 4 separate simple regression models to predict the dependent variable (price of the home) with each of the independent variables. Use an alpha level of 0.05 to determine significance. 7. Using Data>Data Analysis>Regression in Excel, run a multiple regression model to predict the dependent variable with all 4 independent variables. Use an alpha level of 0.05 to determine significance.

Living Area (Square Feet)	Number of Bedrooms	Number of Bathrooms	Age (Years)
1,344	3.0	2.0	13
822	2.0	1.0	173
1,540	2.0	1.0	115
1,320	3.0	1.0	90
1,214	3.0	1.0	103
882	3.0	1.5	71
960	2.0	1.0	11
1,328	4.0	1.0	103
1,235	3.0	1.0	84
800	2.0	1.0	55
1,363	3.0	2.0	39
743	3.0	1.0	105
960	2.0	1.5	12
1,144	3.0	1.0	15
1,310	4.0	1.5	120
792	2.0	1.0	55
1,688	5.0	2.0	119
990	2.0	1.5	75
924	1.0	1.0	104
1,668	4.0	1.5	115
1,664	3.0	1.5	76
2,039	3.0	1.0	55
1,228	2.0	1.0	53
1,064	3.0	1.0	95
1,628	2.0	1.0	124
1,536	4.0	1.5	30
672	2.0	1.0	46
1,298	3.0	1.0	106
813	2.0	1.0	68
1,196	4.0	1.5	56
924	3.0	1.0	39
1,653	3.0	2.0	79
1,040	2.0	1.0	19
1,216	2.0	1.0	101
986	3.0	1.0	133
1,170	2.0	1.0	110
840	1.0	1.0	57
976	2.0	2.0	21
2,087	3.0	2.5	0
957	3.0	1.0	45
1,594	4.0	1.5	81
864	3.0	1.5	114
1,928	4.0	2.0	134
1,708	2.0	1.0	39
2,708	4.0	2.0	21
728	2.0	1.0	22
988	2.0	1.0	20
912	2.0	1.5	19
995	3.0	1.0	47
896	2.0	1.0	48
908	2.0	1.0	19
1,620	4.0	1.5	99
1,704	2.0	1.0	177
1,080	3.0	2.0	15
908	2.0	1.0	19
1,536	3.0	2.0	105
908	2.0	1.0	19
2,634	4.0	2.5	83
1,572	4.0	1.5	41
1,225	3.0	1.0	48
1,600	3.0	1.5	16
1,380	2.0	1.5	0
1,336	2.0	1.5	20
912	2.0	1.5	19
1,008	3.0	1.0	41
1,518	3.0	1.0	130
1,480	3.0	1.5	14
1,272	4.0	1.5	115
1,480	2.0	2.5	14
924	3.0	1.0	15
924	3.0	1.0	15
2,043	4.0	1.5	94
2,068	4.0	1.0	104
912	2.0	1.5	20
1,527	2.0	2.0	17
1,140	2.0	1.5	18
1,392	2.0	1.0	17
976	2.0	2.0	23
1,270	3.0	1.0	110
1,572	4.0	1.5	50
929	2.0	1.5	22
1,480	3.0	1.5	14
1,000	3.0	1.0	91
960	3.0	1.0	51
1,480	3.0	1.5	19
1,132	2.0	1.0	25
1,480	2.0	2.5	14
960	2.0	1.0	48
1,216	3.0	1.0	129
912	2.0	1.5	16
1,200	3.0	2.0	10
1,256	3.0	1.5	19
957	3.0	1.0	49
1,120	3.0	1.0	14
929	2.0	1.5	21
1,392	3.0	1.5	21
908	2.0	1.0	17
1,300	3.0	1.0	10
1,281	2.0	2.5	19
1,368	3.0	1.0	34
912	2.0	1.5	20
988	2.0	2.0	19
784	1.0	1.0	44
1,022	3.0	1.0	55
924	2.0	1.0	19
1,324	3.0	1.5	5
1,184	2.0	1.5	19
1,385	2.0	1.5	17
1,480	3.0	1.5	17
960	3.0	1.0	48
1,480	2.0	2.5	16
912	3.0	1.0	37
1,375	2.0	1.5	22
1,150	3.0	1.0	45
924	2.0	1.0	19
912	3.0	1.0	34
1,240	2.0	1.5	17
1,380	4.0	1.0	105
1,480	3.0	1.5	15
912	2.0	1.5	20
912	2.0	1.5	20
912	2.0	1.5	18
1,480	3.0	1.5	19
1,244	4.0	1.5	53
1,219	2.0	1.5	19
1,548	3.0	1.5	85
1,276	2.0	2.0	26
1,061	3.0	1.0	48
1,480	2.0	2.5	16
912	2.0	1.5	18
1,184	2.0	1.5	18
1,184	2.0	1.5	18
1,355	3.0	1.0	60
1,406	2.0	1.5	19
1,158	3.0	1.5	14
1,480	3.0	1.5	16
937	2.0	1.0	19
924	2.0	1.0	20
1,281	2.0	2.5	18
690	3.0	1.0	114
912	3.0	1.0	31
1,064	3.0	1.0	45
1,628	2.0	1.5	30
1,360	2.0	1.0	79
1,184	3.0	2.0	19
1,314	2.0	1.5	19
912	2.0	1.5	18
1,480	2.0	1.5	17
1,034	3.0	1.5	15
988	2.0	1.0	20
1,375	2.0	1.5	21
1,754	4.0	1.0	110
1,281	2.0	1.0	8
1,040	3.0	1.0	12
1,032	2.0	1.0	23
1,232	3.0	1.0	43
960	3.0	1.0	19
1,820	4.0	1.5	35
1,852	4.0	2.0	37
1,492	3.0	2.5	16
1,214	2.0	1.5	17
1,184	2.0	1.5	20
1,172	3.0	2.5	73
1,302	2.0	1.5	16
882	3.0	1.5	71
1,680	3.0	2.0	15
1,202	2.0	1.5	18
1,227	3.0	1.0	115
1,184	3.0	2.0	18
1,480	3.0	1.5	15
1,168	3.0	2.0	21
1,248	3.0	1.0	46
1,492	3.0	1.5	16
1,344	3.0	1.5	16
1,176	2.0	1.5	31
1,034	2.0	1.5	14
1,560	3.0	1.5	16
1,314	2.0	1.5	21
1,476	3.0	2.0	6
1,375	2.0	1.5	21
1,700	3.0	1.0	25
1,486	3.0	1.5	16
1,170	2.0	2.0	10
1,302	2.0	1.5	17
1,480	3.0	1.5	19
1,056	3.0	1.0	47
898	2.0	1.0	57
1,290	3.0	2.0	16
1,463	3.0	1.5	125
1,480	2.0	1.5	15
2,116	4.0	2.0	74
1,673	2.0	2.0	18
1,673	2.0	2.0	18
912	2.0	1.5	19
1,852	4.0	1.0	147
1,184	3.0	2.0	21
1,144	3.0	1.5	44
1,096	3.0	1.0	67
908	2.0	1.0	21
1,100	3.0	1.0	93
864	3.0	1.0	128
972	3.0	1.0	40
1,480	3.0	1.5	21
1,184	3.0	2.0	20
1,148	3.0	1.0	7
1,144	2.0	1.0	16
1,308	2.0	1.0	17
936	3.0	1.0	34
1,472	3.0	1.0	28
1,592	3.0	2.0	16
1,276	3.0	2.0	29
840	2.0	1.0	2
1,008	3.0	1.0	38
1,802	4.0	2.0	56
1,184	2.0	1.5	18
1,228	3.0	1.5	21
1,272	3.0	1.0	43
1,375	2.0	1.5	20
1,308	3.0	1.0	26
1,056	2.0	2.0	7
1,388	3.0	1.0	60
1,544	3.0	2.0	72
1,288	3.0	1.0	32
1,292	3.0	1.5	25
1,840	3.0	1.0	8
1,480	3.0	1.5	19
1,480	3.0	1.5	22
1,464	2.0	1.0	87
1,514	3.0	1.5	19
1,198	2.0	1.0	13
880	3.0	1.0	56
812	2.0	1.0	115
1,239	3.0	1.0	33
1,456	3.0	1.5	155
1,176	3.0	2.0	5
1,342	2.0	1.0	41
775	2.0	1.0	47
1,218	3.0	1.5	0
1,385	2.0	1.5	17
1,480	3.0	1.5	20
1,652	3.0	1.5	105
1,800	3.0	1.5	83
911	2.0	1.0	114
1,266	3.0	1.0	134
1,568	3.0	1.5	18
1,888	3.0	1.0	18
1,056	3.0	1.0	27
912	2.0	1.5	20
1,142	3.0	1.5	18
1,248	3.0	1.5	0
1,272	3.0	1.5	1
1,380	3.0	1.5	2
1,032	3.0	1.0	4
1,560	3.0	1.0	31
1,564	3.0	1.0	54
878	2.0	1.0	28
1,711	3.0	1.0	112
1,758	3.0	2.0	25
1,270	3.0	1.5	18
1,834	4.0	2.0	65
1,375	2.0	1.5	20
1,138	3.0	1.0	98
1,350	3.0	1.5	26
1,314	2.0	1.5	20
1,380	3.0	1.0	3
1,760	4.0	1.5	133
1,177	3.0	1.5	36
1,656	3.0	1.0	94
1,142	2.0	2.0	40
1,240	3.0	2.0	18
1,920	3.0	1.0	34
960	3.0	1.0	40
1,098	2.0	1.0	113
1,164	3.0	2.0	7
1,053	3.0	1.0	41
1,560	3.0	1.5	5
960	2.0	2.0	11
1,514	3.0	2.0	17
1,428	3.0	2.0	85
1,736	3.0	2.0	37
1,332	3.0	1.0	45
1,700	2.0	2.0	15
912	2.0	1.0	14
1,480	3.0	1.5	18
1,184	3.0	2.0	17
1,422	3.0	1.5	20
1,242	3.0	2.0	30
1,479	3.0	1.5	17
1,272	3.0	1.0	31
1,107	3.0	1.0	43
1,486	3.0	1.5	16
1,184	3.0	2.0	18
1,322	3.0	1.0	63
1,404	3.0	1.5	28
1,456	4.0	1.0	54
1,542	3.0	2.5	10
988	3.0	1.0	10
1,536	2.0	1.0	55
1,040	3.0	1.0	39
1,492	3.0	2.5	17
1,295	3.0	1.5	125
1,694	3.0	2.0	15
1,227	2.0	2.0	19
2,128	4.0	2.0	7
1,298	3.0	1.0	44
1,592	3.0	1.5	18
936	3.0	1.0	35
1,164	3.0	2.0	5
1,572	3.0	1.5	16
1,506	3.0	1.5	24
912	2.0	1.0	68
1,364	2.0	1.5	20
1,480	3.0	1.5	17
1,560	2.0	1.0	25
1,411	3.0	1.0	48
1,476	3.0	1.5	24
1,512	4.0	1.5	61
2,028	3.0	2.0	27
967	4.0	2.0	55
1,404	3.0	2.0	7
1,056	2.0	1.0	5
1,120	3.0	2.0	7
1,248	3.0	2.0	14
2,238	3.0	1.5	114
1,498	2.0	1.5	0
1,498	2.0	1.5	0
1,348	2.0	2.5	18
1,412	3.0	1.5	103
1,308	3.0	1.0	29
2,268	3.0	1.0	25
1,637	3.0	1.5	54
2,256	4.0	1.5	124
1,170	4.0	1.5	26
1,440	3.0	1.0	32
1,404	3.0	2.0	72
1,400	3.0	1.5	17
1,856	3.0	1.5	36
1,612	3.0	1.0	34
1,209	2.0	1.0	73
1,632	3.0	1.5	14
1,416	3.0	1.5	5
1,302	3.0	2.0	35
1,092	5.0	1.0	72
1,620	3.0	2.5	1
1,272	3.0	1.5	1
1,164	3.0	2.0	8
1,468	4.0	1.0	51
1,092	3.0	1.5	35
1,678	3.0	2.5	1
1,099	2.0	1.0	9
1,836	3.0	2.0	27
1,173	3.0	1.0	16
1,326	2.0	1.5	19
1,253	2.0	1.5	16
1,605	3.0	2.5	0
1,760	4.0	1.0	37
864	3.0	1.5	37
1,268	3.0	1.0	25
1,592	3.0	1.5	18
1,592	3.0	1.5	18
1,471	3.0	2.5	4
1,370	3.0	1.0	27
1,216	3.0	1.0	51
720	3.0	1.0	113
1,019	2.0	1.5	16
1,210	2.0	1.0	17
1,416	3.0	1.5	11
2,040	5.0	2.5	127
1,480	3.0	2.5	16
1,488	3.0	2.5	1
1,688	3.0	1.0	29
1,343	2.0	2.5	15
1,508	3.0	1.5	19
1,554	3.0	1.5	103
1,215	3.0	1.5	41
1,242	2.0	2.0	3
1,260	2.0	1.5	27
1,512	3.0	2.0	16
2,088	3.0	1.0	29
1,635	4.0	1.5	52
1,593	3.0	1.0	63
1,792	2.0	2.5	24
1,248	3.0	2.0	11
1,052	2.0	1.5	15
1,586	3.0	1.5	49
1,595	3.0	2.0	6
1,200	3.0	1.5	1
1,600	3.0	1.0	57
2,110	3.0	2.0	52
1,394	4.0	1.0	33
1,274	3.0	1.5	14
1,456	3.0	1.0	23
1,564	3.0	2.0	13
1,512	3.0	1.5	13
1,368	3.0	1.0	33
1,468	2.0	1.5	161
1,512	3.0	1.5	13
1,326	4.0	2.0	7
1,334	3.0	1.5	7
1,480	3.0	2.5	16
1,716	4.0	2.0	4
1,364	2.0	1.5	19
1,666	3.0	2.5	1
1,768	4.0	1.5	48
1,780	2.0	2.5	25
2,133	4.0	1.5	34
1,501	3.0	2.0	44
1,279	3.0	1.0	31
1,676	3.0	1.5	14
1,500	3.0	1.5	31
1,496	3.0	1.0	37
2,488	3.0	2.0	24
1,327	2.0	2.0	35
1,610	3.0	2.0	17
1,420	3.0	1.5	13
1,952	4.0	2.5	31
1,460	2.0	2.0	17
1,475	3.0	2.0	20
1,946	4.0	1.5	18
1,508	3.0	1.5	21
1,623	4.0	1.5	36
1,479	2.0	1.5	20
1,486	3.0	2.5	0
1,152	3.0	1.0	36
1,880	3.0	2.0	7
1,352	2.0	1.5	11
1,892	3.0	2.0	26
1,290	3.0	1.5	16
1,092	3.0	1.5	33
1,530	3.0	2.0	20
1,164	3.0	1.0	54
1,551	4.0	1.0	97
1,508	3.0	1.5	19
1,728	4.0	1.5	12
1,800	2.0	1.0	49
1,673	3.0	1.0	27
1,576	3.0	1.5	18
1,719	3.0	1.5	25
1,400	3.0	1.5	35
1,248	3.0	2.0	37
1,608	3.0	1.0	63
1,760	4.0	3.0	135
2,308	2.0	3.0	5
1,296	4.0	2.0	51
1,666	3.0	2.5	0
1,980	4.0	1.0	205
1,900	3.0	1.5	12
1,322	3.0	1.0	130
1,244	2.0	1.5	13
1,590	3.0	2.5	0
1,693	3.0	1.5	26
2,254	4.0	1.5	31
1,554	2.0	2.0	20
1,596	3.0	1.5	49
1,873	4.0	2.5	32
1,874	3.0	2.5	31
1,740	3.0	1.5	36
952	3.0	1.0	102
1,982	3.0	1.0	133
1,242	2.0	2.0	2
2,016	3.0	1.5	16
1,920	3.0	2.0	31
1,744	4.0	1.5	35
1,568	3.0	1.5	18
1,360	4.0	1.0	53
1,918	3.0	2.0	29
1,376	3.0	1.5	14
1,612	3.0	1.5	37
1,572	3.0	1.5	7
1,274	3.0	2.0	20
1,292	3.0	2.0	4
1,512	3.0	1.5	13
1,642	3.0	2.0	11
1,536	3.0	2.0	6
1,372	3.0	1.5	26
1,832	4.0	2.0	47
1,376	3.0	2.0	25
1,666	3.0	2.5	1
984	3.0	1.0	41
2,026	4.0	2.5	1
892	2.0	1.0	113
1,989	4.0	1.5	104
1,056	2.0	1.0	5
1,580	5.0	1.5	26
1,561	3.0	1.5	18
1,656	3.0	1.5	18
1,832	3.0	1.5	30
1,821	3.0	2.5	0
1,582	3.0	1.5	11
1,590	3.0	2.5	3
1,680	4.0	1.0	27
1,668	2.0	2.0	16
864	3.0	1.5	39
1,782	3.0	1.5	36
1,475	3.0	1.5	21
1,391	3.0	2.0	12
1,856	3.0	1.5	37
1,470	3.0	1.5	12
1,734	4.0	1.5	34
1,397	2.0	1.5	14
2,208	3.0	2.5	17
1,864	3.0	1.5	154
792	3.0	1.0	36
1,592	3.0	1.5	9
1,664	3.0	1.5	14
1,470	3.0	2.5	11
1,664	3.0	2.0	25
1,632	4.0	2.5	30
1,611	4.0	2.0	83
1,666	4.0	1.5	38
1,668	3.0	2.0	18
1,785	3.0	2.5	1
1,664	3.0	2.0	33
1,652	3.0	2.0	20
1,212	3.0	1.5	6
1,423	3.0	1.5	9
1,512	3.0	1.5	7
1,374	3.0	1.5	44
1,510	3.0	2.5	0
1,792	3.0	2.0	17
1,890	3.0	2.5	27
1,890	4.0	2.0	30
1,512	3.0	2.5	18
1,508	3.0	2.0	16
1,600	4.0	2.0	35
1,875	4.0	2.5	31
1,578	3.0	2.5	11
1,508	3.0	2.0	20
1,043	3.0	1.0	104
1,720	4.0	2.0	31
1,560	3.0	2.0	4
1,872	4.0	1.5	32
1,820	4.0	1.5	45
2,400	3.0	2.0	26
1,984	2.0	2.5	11
1,466	3.0	1.0	62
1,644	4.0	2.5	20
1,886	3.0	1.5	31
1,785	3.0	2.5	1
1,704	3.0	2.5	17
1,944	3.0	2.5	0
2,470	4.0	2.5	26
1,440	2.0	2.0	66
2,310	4.0	2.5	38
1,747	3.0	2.5	1
1,540	3.0	1.5	16
1,540	3.0	1.5	16
1,332	3.0	1.5	9
2,601	4.0	2.5	19
1,792	3.0	2.5	6
1,734	4.0	2.5	29
1,756	3.0	1.5	24
1,911	4.0	1.5	35
1,672	3.0	2.5	0
1,720	3.0	2.0	27
1,836	4.0	1.5	106
2,310	4.0	2.5	33
1,656	3.0	1.5	19
1,666	3.0	2.5	2
1,092	3.0	1.0	41
1,664	3.0	2.0	34
1,910	4.0	2.5	19
1,804	3.0	2.5	0
1,836	3.0	2.5	15
1,512	3.0	1.5	14
1,696	3.0	2.5	5
1,512	3.0	2.0	12
1,561	4.0	1.5	17
1,561	3.0	1.5	16
1,350	2.0	1.5	1
1,794	3.0	2.0	37
1,665	4.0	2.0	27
2,078	4.0	1.5	33
1,732	3.0	1.5	17
2,262	4.0	2.0	21
1,612	3.0	2.0	15
1,294	3.0	1.5	17
1,336	3.0	2.0	11
1,500	2.0	2.0	18
1,344	2.0	1.5	15
1,887	4.0	2.5	27
1,758	4.0	2.0	26
1,560	2.0	1.0	43
1,910	4.0	2.5	20
2,044	3.0	2.5	16
1,601	3.0	1.5	8
1,456	3.0	2.0	1
1,158	3.0	1.5	7
1,656	3.0	1.5	17
1,806	3.0	2.5	0
1,348	2.0	2.0	11
1,804	3.0	2.5	2
2,011	4.0	2.5	12
1,872	3.0	1.5	18
1,552	3.0	1.5	9
1,886	3.0	2.5	16
1,720	3.0	1.5	19
2,334	4.0	2.0	39
2,516	3.0	2.0	40
1,908	3.0	2.5	25
1,811	3.0	2.5	19
1,124	3.0	1.0	26
2,039	4.0	2.5	18
2,310	4.0	2.5	33
1,785	3.0	2.5	1
1,772	3.0	2.0	0
1,664	3.0	3.0	10
1,212	2.0	1.0	87
1,110	3.0	1.0	115
1,498	3.0	1.5	10
1,664	3.0	2.0	37
1,740	3.0	1.5	26
1,852	4.0	2.5	16
1,872	3.0	2.0	16
2,088	3.0	2.0	2
1,876	3.0	2.5	1
2,311	4.0	2.5	20
1,016	2.0	2.0	41
1,888	3.0	2.0	6
1,620	3.0	2.0	0
2,576	5.0	2.5	34
1,796	3.0	2.5	14
2,310	4.0	2.5	33
1,430	3.0	2.5	5
1,774	3.0	2.5	1
1,952	4.0	2.0	33
1,820	3.0	2.5	18
1,585	3.0	1.5	16
1,728	3.0	2.5	0
1,822	3.0	1.5	12
1,784	3.0	1.5	104
1,536	3.0	2.5	7
1,550	2.0	2.5	16
1,547	3.0	2.0	11
2,008	4.0	2.5	0
1,812	3.0	2.0	16
1,512	3.0	1.5	15
1,910	4.0	2.5	21
2,056	4.0	1.5	35
1,656	3.0	2.5	18
1,896	3.0	1.5	17
2,124	3.0	2.5	0
1,910	4.0	2.5	18
1,548	3.0	2.0	0
1,970	4.0	2.5	18
2,372	3.0	2.0	2
2,226	4.0	2.5	31
1,126	3.0	2.0	46
2,214	3.0	2.5	22
2,310	5.0	2.5	36
2,475	4.0	2.5	35
1,837	3.0	1.5	18
2,195	3.0	2.0	1
2,162	4.0	2.5	19
1,772	3.0	2.5	14
2,249	4.0	2.5	1
1,064	2.0	1.0	77
2,402	4.0	2.5	28
1,528	3.0	2.5	8
2,564	4.0	2.5	34
2,200	4.0	2.5	1
1,512	3.0	2.0	12
1,512	3.0	2.0	12
2,014	3.0	1.5	32
2,291	4.0	2.5	0
2,002	4.0	2.5	14
2,030	3.0	2.5	3
1,632	4.0	2.0	20
2,600	4.0	2.5	18
1,736	3.0	1.5	17
2,066	4.0	2.5	32
2,294	5.0	2.5	36
2,310	4.0	2.5	31
1,570	3.0	2.0	14
1,815	3.0	2.5	11
2,050	4.0	1.5	33
2,310	4.0	3.0	31
2,648	4.0	2.5	0
1,944	4.0	2.5	25
1,842	3.0	1.5	8
1,924	3.0	2.0	16
2,204	4.0	1.5	31
1,822	3.0	2.5	4
2,396	4.0	2.5	28
2,035	4.0	2.5	35
2,262	4.0	2.5	24
1,758	3.0	2.5	1
1,836	3.0	2.5	9
2,570	5.0	2.5	28
1,250	4.0	1.5	43
2,702	5.0	1.5	31
1,920	3.0	2.5	0
2,152	3.0	2.5	8
2,296	4.0	2.5	19
1,472	4.0	1.5	3
2,212	4.0	2.5	18
1,500	4.0	1.5	208
1,662	3.0	2.0	0
2,271	3.0	2.5	1
2,756	4.0	2.5	33
2,011	4.0	2.5	14
2,328	3.0	2.5	1
1,868	3.0	2.5	13
1,831	3.0	2.0	19
2,027	3.0	2.5	15
2,040	4.0	2.5	1
1,992	4.0	2.5	30
1,742	3.0	2.5	5
2,110	3.0	2.5	9
2,097	3.0	2.5	10
2,320	4.0	2.5	16
2,367	4.0	2.5	4
1,334	2.0	1.5	122
2,203	3.0	2.5	1
2,588	4.0	2.5	31
1,964	4.0	2.5	6
1,726	3.0	2.0	26
2,316	3.0	2.5	7
2,150	4.0	2.0	104
1,879	3.0	2.5	5
1,836	3.0	2.0	0
2,086	4.0	2.5	14
2,088	4.0	2.5	22
1,666	3.0	1.0	140
2,304	4.0	2.5	0
2,096	3.0	3.0	18
2,079	3.0	2.5	11
1,948	3.0	2.5	13
1,730	3.0	2.5	1
2,167	3.0	2.5	8
2,350	3.0	2.5	15
1,932	4.0	2.5	4
2,066	4.0	2.5	35
2,278	4.0	2.5	0
2,359	4.0	2.5	1
1,428	3.0	2.0	20
2,064	4.0	2.5	3
2,144	3.0	2.5	19
2,086	4.0	2.5	17
1,894	3.0	2.0	0
2,500	4.0	3.5	1
1,702	3.0	1.5	16
2,314	4.0	2.5	1
1,971	4.0	2.5	7
2,024	3.0	2.0	25
1,616	2.0	2.0	36
1,971	4.0	2.5	11
1,938	3.0	2.5	26
2,223	4.0	2.5	9
2,275	4.0	2.5	0
840	2.0	1.0	50
1,808	2.0	1.5	6
2,011	4.0	2.5	12
1,690	3.0	2.5	5
1,806	4.0	2.0	40
2,504	4.0	2.5	14
1,680	3.0	2.5	4
1,940	3.0	2.0	9
1,116	3.0	2.0	38
2,119	4.0	2.5	16
2,498	4.0	2.5	38
2,322	4.0	2.5	22
2,564	4.0	2.5	30
2,120	4.0	2.5	9
2,202	4.0	2.5	6
2,250	4.0	2.5	2
2,284	3.0	1.5	29
2,068	4.0	2.5	17
2,464	4.0	2.5	42
2,762	4.0	3.0	1
1,743	3.0	2.5	0
1,927	3.0	2.0	3
2,460	4.0	2.5	1
2,501	4.0	2.5	0
2,425	4.0	2.5	0
1,224	2.0	1.0	63
1,474	3.0	2.0	29
2,024	4.0	2.5	10
2,284	4.0	2.5	18
2,676	4.0	2.5	34
2,310	3.0	2.5	18
2,116	3.0	2.5	0
1,456	3.0	2.0	10
2,284	4.0	2.5	17
2,331	4.0	2.5	1
2,147	4.0	2.5	9
2,656	4.0	2.5	1
2,119	4.0	2.5	14
2,628	3.0	2.5	20
1,876	3.0	2.5	1
2,602	4.0	2.5	1
2,109	2.0	2.5	1
1,752	3.0	2.5	10
2,714	4.0	3.0	1
1,804	3.0	2.5	4
2,550	3.0	2.5	0
2,084	3.0	2.5	5
2,076	3.0	2.5	13
2,539	4.0	2.5	1
1,596	3.0	1.0	29
2,008	4.0	2.5	19
1,994	3.0	2.0	49
1,764	3.0	2.5	8
2,120	3.0	2.5	10
2,328	4.0	2.5	10
2,170	3.0	2.5	3
1,400	3.0	2.0	25
2,266	4.0	2.5	0
2,270	3.0	2.5	0
2,494	3.0	2.5	13
2,022	3.0	2.5	0
2,498	5.0	2.5	36
1,904	2.0	2.0	2
1,643	3.0	2.5	3
1,680	3.0	2.0	27
2,500	4.0	2.5	0
2,286	4.0	2.5	11
2,056	4.0	2.5	2
1,216	3.0	1.5	75
2,388	4.0	2.5	20
2,472	3.0	2.5	0
2,593	4.0	2.5	0
2,498	4.0	2.5	14
1,386	2.0	1.5	92
2,655	4.0	2.5	1
2,655	4.0	2.5	1
2,748	4.0	2.5	0
2,038	3.0	2.5	13
2,219	4.0	2.5	15
2,327	4.0	2.5	10
2,712	4.0	2.5	1
2,058	3.0	2.5	1
2,421	4.0	2.5	13
2,000	3.0	2.5	22
2,472	4.0	2.0	183
2,495	4.0	2.5	26
2,712	5.0	3.0	1
2,668	4.0	2.5	0
2,619	4.0	2.5	4
2,526	4.0	2.5	1
2,738	2.0	2.5	12
1,200	2.0	1.0	65
2,185	3.0	2.5	14
2,216	3.0	2.5	8
2,524	4.0	2.5	6
1,921	3.0	2.0	0
2,510	4.0	2.5	1
2,764	4.0	2.5	1
1,973	3.0	2.5	3
1,986	3.0	2.5	1
2,512	4.0	2.5	0
2,527	4.0	2.5	1
2,577	4.0	2.5	0
1,824	3.0	2.5	11
2,500	4.0	2.5	0
2,310	4.0	2.5	3
2,230	3.0	2.5	1
2,103	4.0	2.5	6
2,623	4.0	2.5	0
2,548	3.0	2.5	3
1,800	3.0	2.5	16
1,980	3.0	2.0	6
2,541	4.0	2.5	5
2,500	4.0	2.5	0
2,116	3.0	2.5	20
2,248	4.0	2.5	7
2,338	4.0	2.5	16
2,434	4.0	2.5	20
2,434	4.0	2.5	20
1,470	3.0	2.5	3
2,294	4.0	3.5	0
2,299	4.0	2.5	6
2,107	2.0	1.0	1
2,405	4.0	2.5	16
2,066	3.0	2.5	2
1,392	3.0	2.5	4
2,412	4.0	2.5	10
2,608	4.0	2.5	4
2,472	4.0	3.5	0
2,300	3.0	2.5	16
2,500	4.0	2.5	11
2,604	4.0	2.5	0
2,936	4.0	2.5	6
2,762	4.0	2.5	17
2,996	4.0	2.5	1
2,250	4.0	2.5	10
2,872	5.0	3.0	0
2,641	4.0	3.0	1
2,641	4.0	3.0	1
2,619	4.0	2.5	0
3,001	4.0	2.5	1
2,572	4.0	2.5	9
1,445	3.0	1.5	17
2,348	4.0	2.5	7
1,921	3.0	2.0	0
2,376	4.0	2.5	10
2,604	4.0	3.0	0
1,708	2.0	2.0	14
1,954	2.0	1.5	66
2,242	3.0	2.5	0
2,346	4.0	2.5	0
2,572	4.0	2.5	6
2,396	3.0	2.5	5
2,810	4.0	2.5	14
1,652	3.0	1.5	4
2,835	4.0	3.0	1
2,445	4.0	2.5	18
1,016	2.0	2.0	41
1,536	3.0	1.5	66
1,908	3.0	2.0	0
2,604	4.0	2.5	1
2,490	4.0	2.5	4
2,394	4.0	2.5	0
1,932	3.0	2.0	0
2,741	4.0	2.5	2
2,612	4.0	2.5	23
3,021	4.0	2.5	21
1,498	2.0	1.0	51
2,464	4.0	2.5	2
2,541	4.0	2.5	5
2,579	4.0	2.5	0
2,242	3.0	2.5	0
2,752	5.0	3.0	9
2,093	3.0	2.5	1
1,675	2.0	2.5	18
2,577	4.0	2.5	1
2,092	4.0	2.5	0
2,143	3.0	2.5	6
2,176	3.0	2.0	36
3,015	4.0	2.5	1
2,280	4.0	2.5	24
1,859	3.0	1.5	85
1,850	4.0	2.5	16
2,772	4.0	2.5	0
2,380	3.0	2.5	9
2,505	4.0	2.5	1
2,809	4.0	2.5	2
2,932	4.0	2.5	31
1,738	3.0	2.0	5
2,641	4.0	2.5	3
1,870	3.0	2.5	4
3,030	4.0	2.5	1
2,993	4.0	2.5	15
3,001	5.0	2.5	0
2,657	4.0	2.5	15
2,329	5.0	2.0	72
3,319	3.0	2.5	20
2,306	3.0	2.5	1
2,815	4.0	2.5	1
3,020	4.0	2.5	1
2,950	4.0	2.5	1
2,988	5.0	2.5	9
2,960	4.0	2.5	1
1,908	3.0	2.0	16
2,000	3.0	2.5	4
3,017	4.0	3.5	0
2,793	3.0	2.5	21
2,931	4.0	3.5	12
2,346	4.0	2.5	1
2,808	4.0	2.5	1
2,058	4.0	2.5	26
2,900	4.0	2.5	1
3,210	3.0	2.5	15
3,020	4.0	2.5	2
2,748	4.0	2.5	3
2,906	4.0	2.5	2
2,310	2.0	3.0	23
847	2.0	1.0	78
3,329	3.0	1.5	14
2,960	4.0	2.5	8
2,880	4.0	2.5	9
2,958	4.0	2.5	0
2,270	3.0	2.5	9
2,843	4.0	2.5	5
3,028	5.0	2.5	0
2,919	4.0	2.5	5
2,892	4.0	3.5	1
2,592	3.0	3.0	1
1,326	3.0	1.0	52
2,733	4.0	2.5	3
2,934	3.0	2.5	9
2,786	4.0	2.5	0
2,576	3.0	2.5	31
3,026	4.0	4.0	1
1,908	4.0	3.5	17
2,926	4.0	3.0	11
2,186	3.0	2.5	12
2,618	3.0	1.5	1
2,322	3.0	2.5	0
2,058	2.0	1.5	49
3,457	3.0	2.5	20
3,003	4.0	3.5	88
3,250	3.0	2.5	23
1,764	4.0	2.5	85
1,764	4.0	2.5	86
780	2.0	1.5	55
2,986	4.0	2.5	12
2,563	4.0	2.0	55
2,586	4.0	3.0	3
2,472	3.0	2.5	6

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

MBA 6350 Week 7 Case Study - Regression Model (Case Study #4) Case Study #4 will assess your ability to apply the concepts of chapter 14 to conduct simple and multiple regression analyses to create a...

Case Study #4- multiple regression analyses to create a prediction model for home prices based on up to fourindependent variables. You will calculate various descriptive statistics, create summary...

The data file contains data for a random sample of 1,000 houses located in the greater Wilmington, DE area. The data fields included are as follows: ? Home Price ? Living area (square feet)?...

for 1552474 Lic48000040179 S ZI PER 31 Uniform Residential Appraisal Report The purpose s summary appraisal report is to provide the lender der with an and d y sporiadanion of the market value of the...

Im having trouble with question 3 part A of the attached file. I know and understand her needs but im not sure if im filling out the table correctly ? Assignment Tier 1 Financial Planning...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

ASSESSMENT TASKS - ASSIGNMENT 1 Page 2 ASSIGNMENT 1 Task Using the information contained in the Scenario below, please complete the following 6 tasks. You must complete each task for your submission...

data and resources are there thanks! data for quesiton 1 "Games1vs2" (this is entered through iNZight to get the graph) Data for question 3 "Housesales1" (this is entered through iNZight to get the...

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

After a difficult delivery, Jackie observes her 2-day-old daughter, Kelly, being given the NBAS. Kelly scores poorly on many items. Seeing this, Jackie wonders if Kelly will develop normally. How...

The value of 75 coins, consisting of only nickels and dimes, is $5.95. How many of each kind are there?

Pandora Co . expects to pay 4 , 1 9 9 , 0 4 0 in one month for its imports from Spain. It also expects to receive 1 0 , 1 2 5 , 0 0 0 for its exports to Spain in one month. Pandora estimates the...

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....