MAT_240_Module_Two_Area_Analysis_Report__CORRECTED.doc MAT_240 Report: Selling Price and Area Analysis for D.M. Pan National Real Estate Company Southern New Hampshire University Introduction The purpose of the r
...
MAT_240_Module_Two_Area_Analysis_Report__CORRECTED.doc MAT_240 Report: Selling Price and Area Analysis for D.M. Pan National Real Estate Company Southern New Hampshire University Introduction The purpose of the report is to show the relationship between the selling price of properties and the square feet that were sold nationwide over the last few years. The information captured below is a random sample which was then compared the national market. The data set will help determine if the average price and square foot per region aligns with the national market. Representative Data Sample Data Analysis The median for the listing price from my random sample stands at $309,748 compared to the national Statistics of $256,936. The median per square foot is also higher based on my random sample currently at 1924.583 vs. the national average of 1,084. I utilized the random sampling function in excel by using the =rand() formula in an empty cell next to the first line in the dataset and then copied the formula for the entire dataset. I then rearranged the data into a random order by utilizing the sort and filter feature. Once that was completed, I then selected a random 30 lines from the dataset and created my chart. I was also able to calculate the means, median and standard deviation from the information given Scatterplot The Pattern In the scatter plot about, the independent variable (x) is the median square feet, while the dependent variable (y) is the median listing price ($). The independent variable would be useful. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . .. .. . . . . . . . . . . . . . . . . . .. . . . .
[Show More]