In this Regional Sample, the response variable (y) is the median listing price and the predictor variable (x) is the median square feet. This graph shows us that as the listing price of the house increases as the square footage of the house is increased. There is a mostly even split of homes above the line and below the line as well a few that fall on the line. Overall, the data represents a trend that can predict the listing prices of homes based off of square footage pretty accurately
Median Housing Price Model for D. M Pan National Real Estate Company 6 of homes above the line and below the line as well a few that fall on the line. Overall, the data represents a trend that can predict the listing prices of homes based off of square footage pretty accurately. The Regression Model R=0.909 Median Listing Price y - 91.331x+ 68376 500000 R2 - 0.8274 5000DO 400000 300000 200000 100000 1000 3000 4000 5090 5000 The scatter plot shows an upward, linear trend that shows the increase of the median listing price as the median square feet increases. The regression linear equation for this regional sample is y - 91 331x - 68376, R* = 0.8274. R = SORT(R ) which gives us SORT(0 8274)-R which gives us R=0.9096. R falls into the equation 0.80 | R. | #1.00 which shows the positive linear relationship between the listing price of the house and the square footage of the house is strongMAT 240 Project One Template - Word Help ? Tell me what you want to do One Page "View Side by Side 18 Multiple Pages New All Synchronous Scrolling Arrange Split Switch Page Width Macros | Properties Window All A Reset Window Position Windows om Window Macros SharePoint Median Housing Price Model for DI M. Pan National Real Estate Company 2 Introduction This report examines the relationship between the selling price of properties and their size in square feet. The sample collected come from the Real Estate County Data and will be compared to the national Statistics Data of 2019. Linear regression allows us to establish the correlation of the listing price of homes and their size in square feet. Finding the best possible selling price of a house is priority for both the homeowner and the agent in the real estate industry. Many factors are considered when determining a selling price, a home's square footing seems to be one of the more predominant factors. I believe that the scatter plot shows us that as the amount of square footage increases, the listing price increases as well. Data Collection The representative data is a simple random sample of the East North Central region. A formula was used to provide a truly random sample. Out of the 100 properties available in the East North Central Region, 50 were chosen for the sample Median Listing Price - 91331x + 68376 R - 0.8274 600000 500000 400000 300000 200000 109000 2000 6090 1000 4000 50COWorkbook Views Show Zoom TextBox 1 B D E F G Region The State county Im Median Square Feel Listing Price 2 East North Central oh washington 208 324400 3 East North Central il henry 2087 257700 4 East North Central oh huron 1359 199700 5 East North Central mi montcalm 2081 218300 600009 6 East North Central in vanderburgh 1596 214100 7 East North Central oh lawrence 1587 248300 8 East North Central il macon 1659 212900 500000 9 East North Central il winnebago 1692 236700 10 East North Central oh allen 1550 227600 11 East North Central oh stark 1230 201000 400 000 12 East North Central in lawrence 1978 270600 13 East North Central oh richland 1880 248900 14 East North Central oh lucas 1978 228300 15 East North Central in st. joseph 1736 193000 16 East North Central mi eaton 1976 189900 17 East North Central mi st. joseph 1397 188500 206000 18 East North Central coles 189 220800 19 East North Central wi calumet 2033 226400 20 East North Central in grant 1898 219500 10000 21 East North Central mi ionia 1416 193600 22 East North Central in marion 3408 323300 23 East North Central tazewell 1693 278700 24 East North Central la salle 2015 311100 25 East North Central oh darke 1416 160800 26 East North Central oh pickaway 1853 265700 27 East North Central oh mahoning 1688 207500 28 East North Central il vermilion 1632 254500 29 East North Central oh cuyahoga 1947 265100 30 East North Central in vigo 1362 165800 31 East North Central il dekalb 3574 347500 32 East North Central wi douglas 3581 461400 33 East North Central in henry 1588 235000 34 East North Central oh knox 1510 192200 35 East North Central oh clark 1752 240500 36 East North Central in wayne 1441 203800 37 East North Central oh jefferson 1814 246500 38 East North Central il mclean 1526 203800 39 East North Central oh lake 1676 225900 40 East North Central oh ashtabula 1658 177000 35 41 East North Central oh sandusky 1738 253900 30 42 East North Central in lake 4316 470600 205100 25 43 East North Central il knox 1740 44 East North Central il st. clair 1225 201400 20 45 East North Central wi portage 4888 531000 15 46 East North Central il peoria 1434 87900 47 East North Central mi 10 jackson 1201 139200 48 East North Central mi wayne 1243 213800 49 East North Central oh muskingum 1999 188300 50 East North Central mi monroe 1679 228600 51 East North Central i delaware 1651 221600 52 Mean 1907 1 242554 53 Median 1692.5 223750 54 Standard Deviation 751 5405742 75460.42674