MAT 240 Module Two Assignment

Selling Price Analysis for D.M. Pan National Real Estate Company 2 Introduction The purpose of this report is to analyze the correlation between the listing price of properties and the property sizes in square feet. A spreadsheet containing data for the Real Estate County Data was used to randomly sample 30 sales from the West South Central Region. Representative Data Sample This random sample of 30 was taken from the West South Central Region West South Central Region Region Stat e County Listing Price Price per Sq Ft. Sq Ft. West South Central ar benton 232,900 $138 1,690 West South Central ar craighead 251,100 $110 2,285 West South Central ar crawford 172,900 $100 1,734 West South Central ar crittenden 298,800 $155 1,928 West South Central ar faulkner 280,500 $129 2,168 West South Central ar garland 274,800 $134 2,056 West South Central ar jefferson 314,600 $144 2,179 West South Central ar lonoke 289,000 $132 2,190 West South Central ar pope 273,200 $114 2,389 West South Central ar pulaski 211,300 $121 1,745 West South Central ar saline 273,500 $114 2,396 West South Central ar sebastian 208,600 $111 1,879 West South Central ar washington 215,600 $126 1,712 West South Central ar white 254,800 $145 1,763 West South Central la acadia 226,300 $135 1,681 West South Central la ascension 303,200 $149 2,030 West South Central la bossier 305,500 $140 2,177

Selling Price Analysis for D.M. Pan National Real Estate Company 3 West South Central la caddo 278,500 $158 1,768 West South Central la calcasieu 214,300 $115 1,871 West South Central la east baton rouge 254,100 $135 1,881 West South Central la iberia 188,700 $125 1,511 West South Central la jefferson 306,100 $131 2,344 West South Central la lafayette 221,000 $108 2,040 West South Central la lafourche 297,000 $128 2,320 West South Central la livingston 297,300 $139 2,135 West South Central la orleans 258,600 $152 1,698 West South Central la ouachita 304,300 $158 1,921 West South Central la rapides 347,800 $151 2,297 West South Central la st. charles 171,400 $99 1,724 Listing Price Sq Ft Mean $259,507 1,983 Median $273,200 1,928 standard deviation of the listing price 45622.511 1 255.76203 6 Data Analysis The national market, the median listing price is $ 318,000 and for the above sample, the average median listing price is $273,200, meaning that houses in this area are listed less than the national market. Further, the average square footage in the random sample came in at 1,983, while the average national square footage of listed homes was 1,881, therefore it can be proven that the average house on the market in this random sample is much smaller in size and less expensive than the national averages. The standard deviation of the measured homes also vary widely between the sample and the national average, with the sample having a standard deviation of 255.762036 for square footage and $45622.5111 for listing price, while the national standard