Select Page

The rise of real estate business

Name

School Affiliation

Instructor

Course

Date

Contents Introduction 2 Hypotheses 3 CONCLUSION 3 RESULTS 4 Correlation table on the year built 4 Linear Regression Model 5 T STATS the values of t= -34.157 5 Regression summary: 5

## Introduction

This study’s approach is based on an analysis of the data set. Is population increase causing the real estate industry to grow more quickly in the recent years? Before investing in such a rich and rapidly growing firm, thorough study is required. This market sells a wide range of homes. There are three types of stories: one, 1.5, and two. This data is intended to provide information if population gworth real affects the growth of real estate business.

## Hypotheses

The purpose of this study is to investigate and conduct analytical tests on the growth of real estate business and the houses sold in various years, and which month of the year houses are most commonly sold. The hypothesis question raised are :

Is population growth directly proportional to the growth of real estate business in the recent years?

ANOVA in Excel is used to perform a variety of analyses. This design is used to do regression and correlation analysis to determine and display real estate market trends. The rate at which houses are being sold based on the increasing population growth.

### CONCLUSION

The data was evaluated after 2930 samples were counted. A measure of central tendency was calculated based on the descriptive data. Various measures have been calculated, including the mean, mode, and median.

#### Year built.

Samples were taken from the 2930. The mode of 6 indicates that the majority of homes were sold during this month. The most recent residence to sell was on the 12th month. The minimal value obtained from the descriptive analysis is 1. 11 is the range. This number was derived by subtracting the greatest value from the minimum value.

Samples were taken from the 2930. The year 2005 is the mode, indicating that the majority of the residences were constructed in that year. The oldest home was constructed in 1872. The minimal value is 1877, according to the descriptive analysis. 138 is the range. This number was derived by subtracting the greatest value from the minimum value.

## RESULTS

p has the value of 0. 1.733 is the standard deviation.

The criterion for significance is 0.05, which equates to a 95% confidence interval.

### Correlation table on the year built

r=0.558 is the correlation.

This shows a modest relationship.

The year a property was built has a modest relationship with the price it is being sold for. There’s no reason to believe that an ancient house won’t sell for a specific price.

We may deduce from the correlation value that the years a house was built and the amount it was sold for are somewhat associated.

### Regression summary:

The R square value is 0.312, while the R value is 0.558.

The coefficient of determination R square = 0.312, and there is no change in significance values, indicating that the entire model is still statistically significant, rejecting the null hypothesis with p < 0.000 from the ANOVA table.

Reject Ho

Scatter diagram

There appears to be a positive relationship in the distribution based on the scatter plot. According to the graph’s trend, the data set has a significant positive linear connection.

There is no enough evidence to support the claim that increasing population growth is directly proportional to the rise and growth of real estate business. The null hypothesis is rejected.

Reference

Real Estate Market Size & Trends Report, 2022–2030. (2020). Realestate. Retrieved 2022, from https://www.grandviewresearch.com/industry-analysis/real-estate-market

Ltd, R. A. M. (2022). Real Estate Global Market Report 2022 by Type, Mode, Property Type. Research and Markets Ltd 2022. https://www.researchandmarkets.com/reports/5546258/real-estate-global-market-report-2022

scatter diagram

Bsmt Full Bath 1656 896 1329 2110 1629 1604 1338 1280 1616 1804 1655 1187 1465 1341 1502 3279 1752 1856 864 2073 1844 1173 1674 1004 1078 1056 882 864 1337 987 1092 1092 1069 1456 836 1456 2334 1704 1940 1544 1541 1698 1822 1535 2364 1358 2696 2250 1752 1370 1626 1324 1145 1269 1374 1960 1733 1430 2035 2599 2475 1720 2622 2270 1839 3238 1595 1218 1547 1566 1947 1468 2084 1659 2110 923 1845 918 752 1744 1097 1564 1012 1902 1155 894 900 1040 1040 1494 1923 2349 2225 1488 1680 1200 1200 1200 1236 1478 1573 1512 1416 1080 1418 1848 788 1226 1479 1492 1829 2495 1610 1891 1714 1381 1645 1232 1328 1225 1209 1510 1775 1152 1054 1728 1078 2461 1556 858 1306 1063 1520 1268 1128 2274 2207 1888 1604 1480 1143 1700 1314 1194 1188 1264 1206 1580 1337 1064 972 988 1057 985 827 1086 936 1458 1056 1287 2978 1224 1246 1385 900 1116 1175 1395 1839 1844 1140 936 1028 1347 1605 747 804 1316 1251 1633 1245 832 720 1566 1652 2268 2256 1236 1363 2290 1470 1612 2068 765 1132 1196 1453 1416 1040 1536 1068 1710 1962 1560 1324 816 1092 1812 2403 1675 1224 1392 919 1884 1680 1020 1832 1768 1039 1392 912 1060 892 1352 864 1373 1440 1386 2260 1483 756 1067 1524 1981 1610 835 1074 1144 1531 1172 1212 1508 1298 930 1732 1433 1802 1949 996 1694 1208 1226 1222 3222 1445 1052 965 1692 1682 1026 1392 894 876 1978 1601 1829 2098 1661 848 848 1668 1484 1414 640 992 1664 1196 1120 1096 1117 960 1121 1487 924 1526 1296 1647 864 1691 856 2650 1666 2447 2133 2177 2340 1902 1652 1034 1191 1801 1154 540 1107 1128 1178 1044 952 1646 1916 1285 1560 1034 2048 1687 1346 1214 1444 1968 1894 1908 2018 1264 1430 1824 1344 1092 945 1112 1092 630 1092 1092 874 1188 833 2432 1274 1479 1803 1797 882 1434 2704 1608 2283 1628 1746 1474 2522 1659 1478 1734 1382 1718 1636 1571 1470 1516 1190 1593 1481 1167 1983 1442 1360 2234 2046 1530 1934 2353 1586 1411 1602 2050 1671 2673 1472 1707 2524 1601 1370 1868 1884 1935 1874 1811 1621 1116 1193 1350 2119 1792 1002 1026 1180 1050 864 864 864 864 864 987 1365 1302 987 987 1302 958 1548 1456 1055 1322 1456 1548 1441 1456 836 892 1120 1718 2772 3140 2402 1652 1600 2042 2690 2184 2020 2020 2296 2674 2822 1736 1782 2520 1717 1743 1713 1531 1808 2224 1836 1629 1760 1502 2392 2452 2400 1606 1358 1306 1306 1358 1314 2492 2200 1884 1456 1712 1324 1405 1626 1456 1490 1484 1560 1555 1569 1555 1504 1220 1145 1432 2267 1374 1630 1419 1594 1489 1342 1314 2256 2004 2054 1374 1800 1514 1430 2312 1675 2060 1430 2365 2794 2687 2450 2612 2344 2063 2646 2061 2232 2448 1850 1468 1696 1658 1578 1702 1432 1971 2490 1852 1590 1218 1436 1314 1402 1530 1766 1448 2007 1795 1953 1550 1836 1662 2094 1221 1553 1653 1218 1141 1158 1812 1512 1200 1114 1114 1114 1450 2122 1844 1434 1730 1217 1332 1540 1400 1882 841 784 980 980 864 864 1020 912 1144 864 912 2014 1755 3005 1224 1224 1726 1256 1471 1512 1452 1739 1694 1226 1740 2499 1620 1556 1442 1489 2090 2067 1395 2640 1724 1336 1216 2288 1334 1680 1665 864 1568 925 2061 1320 1342 894 864 864 1362 1728 1776 1516 1313 1292 1154 2140 1445 1041 1576 960 708 1203 1505 1691 1644 1050 1668 1113 1584 1453 1394 1567 1986 2142 1392 1738 1144 1478 1329 988 1632 1215 1202 1382 1200 1382 1297 1866 1062 1319 1112 1005 1363 793 1031 1210 1699 1527 1200 972 792 1656 1352 1039 792 1078 2377 1690 599 1374 846 725 2544 1380 1040 2634 951 1105 1306 1478 1142 1268 1040 1133 1040 1904 1041 1339 732 1183 1148 1461 1495 1806 941 1045 894 1224 1230 1378 1944 1131 1306 1464 1558 2372 1701 1960 1389 1447 936 1328 1387 861 612 968 886 792 1452 1510 1284 2138 2640 2007 1288 1742 816 1482 1022 1869 1480 1521 720 797 1576 1432 1548 1654 952 1324 1176 1348 1412 1142 904 1301 1539 1573 800 875 995 1582 1072 2134 2019 1768 1826 1944 2229 2128 1930 1208 1427 1864 1666 892 1403 704 1200 1200 1152 904 1369 1112 1464 1121 1683 1052 899 1034 858 860 1092 1774 1138 2071 660 1788 1473 1229 861 1867 1733 1383 1689 1073 1276 1639 672 1089 845 1049 1716 1258 1510 1061 1338 2132 2196 1775 1879 2020 2016 1535 1224 2228 1535 1535 2240 1229 1513 2787 2787 2787 1680 1718 1630 1720 1468 1768 1838 1800 1604 1290 1254 1232 1498 1422 1644 1759 2126 1040 990 1764 1661 1463 1097 990 1779 1501 1431 1772 1660 1573 1840 1430 1444 1492 1040 907 914 1040 864 1268 864 894 768 768 1611 2184 1788 1872 2153 1725 1870 1513 1504 1828 1417 2034 1716 1212 1630 848 848 1602 1728 1500 1476 1396 1126 1486 816 1922 1426 1149 1125 1698 1072 698 876 1368 1529 864 944 1678 1560 960 1196 1298 1604 1268 1520 438 1489 3082 1242 1981 1232 1608 1135 1913 1477 1228 2080 1567 1494 1308 1273 964 1343 2480 1112 1564 1561 1523 1152 1906 1032 1229 1229 1229 1982 2365 1680 1344 2168 1192 1526 572 1648 810 2052 2149 1710 1961 926 1287 1734 1217 1595 1344 2036 1620 1692 2036 1641 1466 1412 2237 1479 1296 2014 1838 1978 1008 1771 1204 1224 988 874 630 1404 630 1344 1092 796 1091 1110 833 883 1362 1287 1567 1632 1414 2117 2112 1604 1470 1604 1638 1636 1384 1446 1593 1682 1337 1280 1604 1633 1658 1895 1709 1228 1337 2500 2504 1884 1474 1710 1488 2093 1688 1422 1260 2064 1782 2872 1211 1126 2044 1308 2840 1523 1444 1964 1178 2340 1792 1054 936 864 864 1337 987 987 987 987 987 987 1302 1069 1456 1055 892 1932 2332 2084 2713 1582 1710 2464 1950 2748 2790 2331 2088 2332 2470 2668 2046 1575 2649 2690 1866 1702 1367 1518 1684 1800 1342 1342 1626 1626 1358 1455 1576 1504 1266 1246 1515 1593 1166 1456 1720 1986 1358 1792 1892 1490 1414 2322 1651 2199 2630 2198 2172 2006 2125 2501 2113 2418 2197 2127 1987 1580 1933 1574 1578 1506 1563 1428 1861 1874 1460 1372 1372 1428 1768 1992 1958 2078 1665 1660 1218 1728 1080 1696 1663 1175 1114 1114 1640 1162 1609 1680 1679 1657 1677 1737 1294 1710 1617 1199 984 912 864 890 864 912 1430 1641 2683 2786 1391 1250 1245 1200 1392 1392 1501 1549 1638 1310 1419 155 7 1709 1252 1404 1789 1586 1607 2393 1288 1239 1719 1232 2944 1671 1812 1682 1427 1740 1258 1620 1625 2614 1464 912 925 1728 1728 1656 1670 2715 1876 1632 999 1978 1014 907 952 1128 1425 1165 1136 1092 1265 1350 1114 1053 1252 1100 1118 720 729 1077 906 1496 1252 1337 1661 1036 1820 1362 1144 1537 1431 1988 1098 1144 1283 1176 1440 1261 1570 1196 1392 1080 1104 882 1152 950 1790 952 773 1764 1216 1824 869 1159 1558 672 1436 1294 1716 1044 1312 1253 1081 2069 910 876 1048 1507 1256 1027 1269 1320 984 832 1278 1800 1588 825 1796 1611 1117 1133 764 1539 1323 1360 2792 672 1456 1594 2082 1656 1740 1027 1436 899 1080 789 1122 1499 407 928 901 1588 3493 1627 1416 1450 1344 1017 2350 2058 1540 1378 1912 1484 2358 1111 2775 1086 2495 984 1795 882 1093 1143 1668 935 1738 784 1210 1290 1672 949 1158 1497 1342 1013 1216 896 1136 808 1573 2009 1902 1774 1362 520 1285 1848 1820 1716 1505 838 1984 1666 1609 768 1536 1969 1308 1040 1236 1406 825 1198 759 1344 1469 1054 1211 1271 1588 1355 1075 1040 1096 904 992 89 4 1034 1073 1126 1258 1140 1006 1228 960 1188 1383 1252 1601 672 1721 1350 904 1291 2022 1524 1363 1663 1357 1079 1094 2358 1518 1674 2108 1509 864 1269 1367 1347 1164 1096 1111 2329 2814 1626 2200 2037 1356 1615 2276 1766 2097 1511 1643 1688 990 1099 990 1418 1771 1652 1790 1724 1479 1494 1792 1823 1786 938 985 1174 1026 1076 1558 924 864 780 1795 2031 1865 2161 1852 2031 2263 1947 1786 2290 1768 2327 1640 1764 1908 848 848 1493 1838 1536 1710 1445 1436 1582 1234 1564 1361 1456 848 848 848 848 796 2200 1092 1256 1033 1127 996 1181 1656 1117 1398 1132 3820 5642 1072 1152 1152 1440 1152 784 1053 1137 930 1200 1470 1393 1204 1292 864 864 1716 1482 2192 1694 1424 1964 2601 1920 1316 2555 1680 1264 790 1512 1639 1603 1502 1660 1938 1374 1091 1873 3447 1954 2161 1898 1640 1032 1556 919 1090 796 816 778 1200 1656 912 1955 733 1361 1317 1049 894 864 1652 1648 1646 1646 2032 1689 1820 1118 1279 1872 1689 1786 1501 2898 1537 1646 1780 1442 1394 1612 1495 1651 1256 1509 1440 1675 2262 1728 1964 1344 1344 1092 1189 1200 1040 1304 1475 988 988 1160 1092 630 988 816 923 816 816 845 1750 889 1968 1836 1587 1277 2223 2217 1733 1572 1470 1600 1384 1652 1694 1714 1553 1253 2299 1187 1472 1482 1642 1128 1088 2090 1179 1321 1922 2541 2338 1424 1612 1419 2234 2042 1440 1284 1868 1479 1664 1930 1969 2030 1032 1177 1725 1353 1620 1220 1484 1743 1935 1324 1877 1109 981 1479 1422 914 950 872 858 914 864 767 1337 1337 1092 1218 1218 1302 1365 958 1548 1055 988 1816 1828 1694 1694 1734 2122 2121 2656 2550 2046 2172 2552 1973 2643 1634 1976 2758 2290 2152 2473 2100 2161 1802 2956 2468 2385 2374 1818 1614 1721 1828 1362 1302 1302 1362 1554 1554 1370 1577 1561 1869 1324 1405 1496 1536 1484 1458 1495 1746 1326 1456 1302 1340 1412 1504 1456 1258 1258 1402 1589 1266 1530 1119 1374 1959 1525 1720 1394 1948 1690 1995 1647 1430 1320 1690 1644 4476 2551 2285 2633 3078 2582 2385 4316 2013 2398 2520 2531 3228 2202 2538 1369 1542 1905 1464 1534 1966 1636 1795 1528 1726 1689 1588 1538 1496 1506 1694 1977 1830 1338 1335 1792 1588 1959 2610 1880 1656 1761 1584 1685 2443 2466 1100 1143 1094 1486 1721 1820 1349 1494 1575 1266 884 2020 894 970 1057 999 1120 1696 1040 988 902 2503 2167 1037 1701 1055 2810 2872 1378 1151 1565 1352 1352 1550 1241 1250 1501 1458 1512 1573 1525 1102 1441 1950 1358 2048 2362 1494 2362 1432 1437 1295 1855 1262 2497 2620 1929 1152 2411 1082 1295 1610 1594 2075 1680 1093 1242 1052 1107 1214 1073 1344 1728 1224 1422 958 1065 1138 912 1074 882 1187 964 894 1200 1042 1302 2154 1374 1652 1429 1327 1224 932 908 334 666 670 808 1977 1150 1920 1376 1644 1560 1280 1254 912 1524 2380 936 1008 1053 1056 1442 1056 1244 1144 1721 922 1048 1657 1411 1216 1154 1560 948 1040 1008 925 1360 1540 925 928 1647 924 1544 893 1728 3086 1034 882 1281 968 1534 691 1651 888 952 2080 924 1082 1846 988 1238 864 1134 1040 1170 1242 1377 1800 925 1851 1812 864 936 960 1432 1296 1022 936 967 1047 1072 1174 1183 1131 1141 960 1798 866 968 1772 1642 1472 1232 2337 1650 2210 1358 2454 2291 1616 1559 2554 1248 968 1382 1060 1435 1167 1635 1274 1232 1218 884 1409 1322 1426 1281 1513 854 1367 986 2264 1824 1376 1316 1396 1344 2526 1173 1214 1818 1108 2294 1355 1375 1952 2180 1315 1111 1196 1382 1889 840 1484 2267 3086 1134 1282 999 1452 1005 1029 1020 1040 913 894 948 868 897 943 955 894 1285 912 1375 2654 1416 1302 1299 1176 998 1824 1522 2060 1325 1630 1242 2422 2158 1626 864 943 1440 605 1038 1342 1480 1362 1340 1822 1442 2243 2730 2127 1982 1958 2696 2828 1651 2140 1494 1316 1651 2574 1274 1456 1240 1208 1546 1500 1270 1795 1314 2062 1873 2144 1953 2087 1743 1022 990 1200 1308 1796 990 1097 990 1786 1873 1753 1690 1842 1479 1668 894 1025 1009 1040 907 879 882 969 864 875 2000 2169 1673 1459 1932 1729 2452 1592 2439 1992 1668 2090 848 1341 1928 1337 1476 1797 1422 1190 1330 1491 1536 1214 936 1088 960 1351 1179 816 1044 1113 2233 1125 1090 1408 5095 4676 1072 960 1152 948 1195 774 865 894 1346 768 864 948 3395 2592 1502 789 1422 1298 1768 1098 1436 1426 1461 1646 694 1250 954 1958 2002 1718 1226 2624 3194 1755 1991 1355 2727 2320 1839 1740 2259 1560 1488 1045 1680 1020 1696 2515 2726 1517 1215 803 1601 1123 1828 816 1012 1077 1558 845 1991 1073 1001 1625 1625 1299 912 1080 1392 1409 1478 918 1026 1501 1502 1328 2279 1689 1564 1484 1571 1646 1240 1717 1756 1312 1146 1922 1491 1629 2486 1572 1776 1824 2482 1120 2034 936 1040 1632 1622 1060 1142 1092 992 1092 1092 630 1092 1062 1008 1356 1676 1432 796 768 1608 845 1178 816 816 974 887 1293 1024 1797 1390 1851 1525 2236 1671 1498 1776 1511 2462 1670 2064 1801 2212 2021 2687 1169 1501 1632 1204 1767 1742 2798 3390 2473 2868 2576 2698 2795 2945 2320 1056 1714 1826 2000 1621 2183 2263 1574 1102 1872 1857 1686 2784 1552 1083 2318 1875 1074 1664 1309 1103 1096 864 858 874 1419 1092 1365 987 1030 1218 1218 948 1092 987 1069 1387 900 1055 1456 1980 2589 2596 1618 2076 1740 1868 1850 2376 2452 2206 2098 2091 2324 2253 2389 2358 1944 1970 1792 1

Order your essay today and save 10% with the discount code ESSAYHELP