3-3 Assignment - Real Estate Analysis part 2

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

240 APPLIE

Subject

Economics

Date

Jun 3, 2024

Type

docx

Pages

5

Uploaded by DoctorTurtle5212

Housing Price Prediction Model for D.M. Pan Real Estate Company Colleen Del Valle Southern New Hampshire University
Median Housing Price Prediction Model for D.M. Pan National Real Estate Company 2 Module Two Notes The listing price random sample mean is $213,636, the median is $231,127, and the standard deviation is $153,707. The mean for square feet is 3,078, with the median being 2,984, following up with the standard deviation of 1,127. The difference in mean price between the random sample and the National Summary Statistics is $128,729, the median difference is $86,873, and the standard deviation is $27,793. The difference of square footage between the Pacific Region and National mean is 967, the median comes in at 1,103, and lastly the standard deviation is 206. The regional sample does not seem to be reflective of the national model just because of the gap differences in listing prices alone. The square footage is a little closer but still has a noticeable difference. How I conducted the simple random sample was by copying and pasting the data specific to the Pacific region into a new workbook, from there I generated random numbers in the ‘G’ column with the ‘RAND’ function. After getting my random numbers, I highlighted all the columns with data, clicked the ‘Data’ tab at the top of the document, then clicked ‘Sort’ and had it sort the information randomly from smallest to largest. After it was all randomly sorted, I took the first 30 samples and copied them onto a separate worksheet. To get the mean, median, and standard deviation of the random listing price I used the ‘average’, ‘median’, and stdev.s’ functions on the spreadsheet. Below I have added a side by side of the Pacific Region and the National Summary Statistics. Listing Price (Dep. Var) sample national mean price $213,636 $342,365 median price $318,000
Median Housing Price Prediction Model for D.M. Pan National Real Estate Company 3 $231,127 std dev price $153,707 $125,914 Sq Ft (Indep. Var.) sample national mean sqft 3,078 2,111 median sqft 2,984 1,881 std dev sqft 1127 921 Regression Equation
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