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
Korin Holden
Southern New Hampshire University
Selling Price Analysis for D.M. Pan National Real Estate Company 2
Introduction
From the real estate data and a selling price analysis, I will take a random sample of 30
properties from the Pacific Region and will collect the mean and median of the square footage
and listing price to determine trends or a correlation. The Statistic equations used are descriptive,
competitive, and regression analysis based. The study has been done to determine competitive
advantage of the smart businesses. Regression analysis will be utilized to deduce my own
determination of a suitable listing price for a sizable property.
Representative Data Sample
Pacific wa clallam 427,000
2,096
or lincoln 371,200
Pacific 1,334
Pacific ca yuba 777,900
4,635
Pacific ca merced 339,600
1,726
Pacific ca santa 405,100
cruz 1,955
Pacific ca imperial 343,900
1,478
Pacific wa grays 395,300
harbor 1,393
Pacific ca tehama 371,200
Selling Price Analysis for D.M. Pan National Real Estate Company 3
1,597
Pacific wa mason 332,900
1,145
Pacific or douglas 357,000
1,324
Pacific ca san diego 421,400
2,081
Pacific or clackama 401,700
s 1,780
Pacific ca solano 343,700
1,240
Pacific or washingt 764,900
on 3,504
Pacific or columbia 367,800
1,509
Pacific ca san luis 370,000
obispo 1,246
Pacific wa grant 370,100
1,351
Pacific wa walla 420,400
walla 1,963
Pacific ca alameda 472,100
2,065
Pacific wa clark 460,700
1,922
Pacific wa spokane 422,800
Selling Price Analysis for D.M. Pan National Real Estate Company 4
1,462
Pacific or deschute 351,500
s 1,467
Pacific or marion 419,300
1,936
Pacific ca tulare 403,900
1,566
Pacific ca fresno 389,500
1,395
Pacific wa clallam 887,800
4,422
Pacific or yamhill 458,800
2,020
Pacific ca san 413,100
francisco 1,595
Pacific hi maui 342,000
1,149
Pacific ca riverside 329,500
1,274
Listing
Square Feet Price
mean 1,854 431,070
median 1,581 398,500
standard d 858.602045 135395.393
Selling Price Analysis for D.M. Pan National Real Estate Company 5
Data Analysis
I acquired my sample by using Excel and using the random sorting feature after I selected a
region and narrowed the selection to 30. The National Summary of Real Estate Data, Statistics,
and Graphs shows a very similar trend of what I estimated on the regional end. Although, my
sample is not representative of the population, housing prices still varied from $315,000-
$415,000 when square footage ranged between 1,500 and 1,900.
Scatterplot
Regional Sample Graph
1,000,000
900,000
800,000
700,000
Listing Price ($)
600,000
500,000
400,000
300,000
200,000
100,000
-
1,000 1,500 2,000 2,500 3,000 3,500 4,000 4,500 5,000
Square Feet
The Pattern
X axis = square feet, Y axis = listing price
Linear trendline with a positive association between the two variables determining increase in
square footage does lead to an increase in listing price.
If I had a home to sale that was 1800 square feet, I would choose to list it at $288,151. This is
because by finding the mean values of X and Y, and knowing the coefficient X is 1,800, it
creates the equation =151.77*1800+14963. Which produces a trend of 1,800 square foot houses
ranging from $288,149-$288,151.
Selling Price Analysis for D.M. Pan National Real Estate Company 6
