Selling Price and Area Analysis for D.M. Pan National Real Estate Company
2
Report: Selling Price and Area Analysis for D.M. Pan National Real Estate Company
Introduction
This report identifies key data within the housing market of the Northeast. It outlines the relationship between the square footage of properties and their listed prices. Lastly, it will also indicate that best prices for certain square footage of properties with the use of graphs.
Generate a Representative Sample of the Data
The region selected is the Northeast, and a random sample of 30 was picked from that region.
sample
national
mean price
$321,277
342,365
median price
$302,450
318,000
std dev price
109714.9368
125,914
sample
national
mean sqft
1,921 2,111
median sqft
1,698 1,881
std dev sqft
852.5499439
921
Analyze Your Sample
The regional sample is reflective of the national market. This is because the mean, median, and standard deviation of both the price and square feet of the sample and national market are quite similar. The only difference seen is that the regional sample has a bit smaller price, but this is most likely since the size of the properties is also a bit smaller. The sample of 30 is random because the =rand() function was used on Excel to give each property a random number. The numbers were then sorted in order and the first 30 were picked.
