Regional vs. National Housing Price Comparison Report
The purpose of this assessment is to create a hypothesis statement and determine it to be
valid or not.
My initial hypothesis is that the average price of a home in South Atlantic
region is higher than the national average priced home.
My second hypothesis is that the
average square foot in the South Atlantic is 1980. To perform our assessment, we took a
random sample of 100 homes in the South Atlantic region and compared these homes to the
To help me determine if whether the null hypothesis or the alternative
hypothesis can be accepted, I will perform descriptive analytics for both hypothesis’ and
create a chart and histogram of my findings to compare them to the national averages.
To collect our random sample I used the rand() function in an excel worksheet and took a
sample of the first 100 property listings.
This sample included states in the South Atlantic
Region such as VA, GA, NC, SC, FL, MD, DE and WV.
From this sample I calculated the
descriptive statistics and created scatterplot and histogram of the listings.