MAT 240 Module Two Assignment Template (2)

.docx

School

New Mexico State University *

*We aren’t endorsed by this school

Course

240

Subject

Economics

Date

Feb 20, 2024

Type

docx

Pages

4

Uploaded by DeaconTroutMaster498

Report
Selling Price and Area Analysis for D.M. Pan National Real Estate Company 1 Report: Selling Price and Area Analysis for D.M. Pan National Real Estate Company Timberly Swaim Southern New Hampshire University
Selling Price Analysis for D.M. Pan National Real Estate Company 2 Introduction This report will provide a detailed examination of two variables: the selling price and the square footage of a household within a specific region. This report will focus on the East North Central region. This will show the differences between the national and random sample means, medians, and standard deviation for both the listing price and the square footage. Representative Data Sample First, I selected the East North Central region, by deleting the rest of the regions along with the data that represented them. To get my random sample I used the random function in column G to produce random numbers that are smaller than zero. I then proceeded to highlight all the data presented to me for East North Central and went to the data tab in Excel and clicked the sort section where I chose random from smallest to largest to get truly random samples. The mean for the listing price is less when compared to the mean of the national listing price, This is less than expected for the mean price, this is a $128,582 difference. The median price for the sample is $212,900, while the median price for the national sample is $318,000. This is about a $105,000 difference. The standard deviation for the sample price is $38,454, while the standard deviation for the national price is $125,914, this difference is approximately $88,000. Now for the square footage, the mean square footage for the random sample is 1,647, while the national mean of square footage is 2,111. This means only a 464 difference. The median square footage for the random sample is 1,643, and the national median square footage is 1,881. This gives a difference of 238. The standard deviation of the square footage for the random samples is 282, while the standard deviation of square footage for the national is 921. Giving a difference of 639.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help