Real Estate Growth Rates

A Comparison of Gardnerville/Minden and Carson City Areas

 

By

Amy Smith

 

The purpose of this project is to evaluate the real estate growth in the Gardnerville/Minden, NV area versus real estate growth in the Carson City, NV area over the past ten years.  Both areas have experienced rapid growth over the past decade however it is believed that the mean growth rates are not equal.  The null hypothesis is that the growth in Gardnerville/Minden, NV is equal to that of Carson City, NV.  The alternative hypothesis is that the growth rates are not equal and that one is greater than the other.  To determine the growth rates we will use the number of homes sold over the past ten years and compute statistical analysis on the data with alpha equal to 95%.

Furthermore, analysis of the mean home price for both real estate areas will be calculated to determine if there is any correlation between mean home price and growth rate.  The data listed for these calculations comes from the multiple listing service stats of single family homes and was obtained from the Sierra Nevada Association of Realtors located at 300 South Curry Street #3 in Carson City, NV 89703.

The following data table shows the number of homes sold in Gardnerville/Minden area and the number of homes sold in the Carson City area over the past ten years.

 

Year

No. Of Homes Sold in Gardnerville/Minden, NV

No. Of Homes Sold in

Carson City, NV

1993

727

540

1994

732

456

1995

601

470

1996

692

494

1997

636

465

1998

713

524

1999

839

687

2000

894

692

2001

995

774

2002

1002

811

2003

1151

775

           

Provided below are histograms which represent the frequency distribution of the data points in the above chart. 

 

 

 

            In Gardnerville/Minden, the highest frequency of homes sold is around 784 per year and greater than 968 sold per year.  The frequency distribution for homes sold in Gardnerville/Minden is bi-modal and slightly

skewed right.

 

       

 

            In Carson City, the highest frequency of homes sold is around 574 per year and greater than 693 homes sold per year.  The frequency distribution for homes sold in Carson City is bi-modal and slightly skewed right.

 

The following pie chart represents the total number of homes sold from 1993-2003 and the distribution of those homes sold.  There were 15,670 homes sold from 1993-2003 – 57% of those homes sold were located in Gardnerville/Minden areas and 43% of the homes sold were located in the Carson City area.

 

 

 

In order to analyze this data I have provided a descriptive statistic chart of homes sold for each real estate area.

 

Gardnerville/Minden

 

 

Carson City

 

 

 

 

 

 

Mean

816

 

Mean

608

Standard Error

52.6617618

 

Standard Error

42.3431866

Median

732

 

Median

540

Mode

#N/A

 

Mode

#N/A

Standard Deviation

174.659305

 

Standard Deviation

140.436463

Sample Variance

30505.8727

 

Sample Variance

19722.4

Kurtosis

-0.5343204

 

Kurtosis

-1.8671854

Skewness

0.6809611

 

Skewness

0.31904986

Range

550

 

Range

355

Minimum

601

 

Minimum

456

Maximum

1151

 

Maximum

811

Sum

8982

 

Sum

6688

Count

11

 

Count

11

Confidence Level (95.0%)

117.337738

 

Confidence Level (95.0%)

94.3465156

           

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

From the given data table the mean number of homes sold per year in Gardnerville/Minden is 816 homes with a standard deviation of approximately 175.  The mean number of homes sold per year in Carson City is 608 with a standard deviation of approximately 140.  The average number of homes sold per year is greater in Gardnerville/Minden area than it is in the Carson City area.  The bar chart below compares the number of homes sold in Gardnerville/Minden vs. Carson City.

 

         

                    From the data given above, it is clear that the number of homes sold in Gardnerville/Minden is greater than the number of homes sold in Carson City over the past 10 years.  Now we need to look at the growth rate in number of homes sold for both locations to determine which is higher.  To determine the growth rate we will look at the percentage of homes sold in previous years and compare the percentages for each location.  The following data table shows the number of homes sold in each location compared to the previous year.

 

Year

Homes sold compared to previous year in Gardnerville/Minden

Homes sold compared to previous year in Carson City

1994

5

-84

1995

-131

14

1996

91

24

1997

-56

-29

1998

77

59

1999

126

163

2000

55

5

2001

101

82

2002

7

37

2003

149

-36

 

           The average difference of homes sold from previous year in the Gardnerville/Minden area is 43 homes.  More specifically, this means that over the past ten years there has been an average growth of 43 more homes sold per year in Gardnerville/Minden.  The average difference of homes sold from previous years in the Carson City area is 24 homes, which means that on average there is an increase of 24 homes sold per year.  Below is a line chart to visually represent this data.

 

                

 

 

            In order to determine growth rates, we will examine the percentage of real estate growth in each area.  By looking at percent of real estate growth we will be able to determine if there is enough change in percentage of growth per year to determine whether or not one area is growing at a more rapid rate than the other.  The following table lists the data.

 

           

 

 

 

 

 

 

 

 

 

The mean real estate growth percentage for Gardnerville/Minden is 6.56% per year for the past ten years.  Additionally, the mean real estate growth percent for Carson City is 5.81% per year for the past ten years.  Gardnerville/Minden has a higher mean growth percentage rate than Carson City, however, this does not mean that we can reject the null hypothesis and accept the alternative hypothesis.  Statistical analysis must be done to determine if out data falls outside the critical region.  In order to correctly analyze the data a t-test for two variables need to be calculated (with alpha equal to 95%).  The table below lists the results of the t-test.

           

t-Test: Two-Sample Assuming Equal Variances

 Carson City

  Gardnerville

    /Minden

 

 

 

 

0.687757909

-15.55556

Mean

5.81758193

6.5577851

Variance

145.1904777

124.38138

Observations

9

9

Pooled Variance

134.7859287

 

Hypothesized Mean Difference

0

 

df

16

 

t Stat

-0.135249266

 

P (T<=t) one-tail

0.447050845

 

t Critical one-tail

1.745884219

 

P (T<=t) two-tail

0.89410169

 

t Critical two-tail

2.119904821

 

 

           

To determine whether or not to accept the alternative hypothesis we must look at the critical area for the two tail test with an alpha of 95% and see if the t score falls beyond that region.  The two tailed t-test critical region is (-) or (+) 2.1199.  The calculated t score for the data equals -.1352, which does not fall into the critical region for accepting the alternative hypothesis.  Therefore, we fail to reject the null hypothesis and conclude that the data is not statistically significant enough to accept the alternative hypothesis.  More data collection is needed and further statistical analysis should be done.

 

 

The second purpose of this project is to determine whether or not there is any correlation between growth rate and mean home price in the study areas.  The data needed to calculate this relationship is the mean home price for each year in the given area and the percent of real estate growth in each area.  The following table lists the necessary data.

 

Year

Average home $ in Gardnerville/Minden

Growth % from previous year GV/Minden

Average home $ in Carson City

Growth % from previous year Carson City

1993

158,743

0.68775791

134,326

-15.555556

1994

160,042

-17.896175

136,874

3.07017544

1995

158,046

15.1414309

139,129

5.10638298

1996

167,286

-8.0924855

139,068

-5.8704453

1997

173,457

12.1069182

139,419

12.688172

1998

174,401

17.6718093

153,505

31.1068702

1999

187,886

6.55542312

160,035

0.72780204

2000

189,237

11.2975391

163,643

11.849711

2001

194,386

0.70351759

168,544

4.78036176

2002

199,853

14.8702595

172,785

-4.4389642

2003

204,823

 

190,784

 

 

            It is helpful to view the data in a scatter diagram to see if there is any correlation.  Below is the scatter diagram for Gardnerville/Minden, which shows the relationship (if any) between mean home price and growth percentage.

 

   

 

            The r-squared value is .1349, which indicates there is approximately a 13.40% percent that the y-value can be predicted from the given x-value.  Moreover, there is 86.51% that you can predict the y-value from a given x-value.  There might be other factors involved when trying to predict the growth percentage other than mean home price. 

            The following scatter diagram depicts the correlation (if any) between mean home price and percent of growth for Carson City.

 

 

           

The diagram above illustrates that there is very little correlation between the mean home price and percent growth rate for Carson City.  From the scatter chart the r-squared value is .0352, which means that there is a 3.52% that the y-value can be predicted from a given x-value.  Conversely, there is a 96.48% that the y-value cannot be predicted from a given x-value.  From this data set it cannot be concluded that there is any correlation between the mean home price and the percent growth rate in Cason City.

 

            In conclusion, we fail to reject our first hypothesis, in that, we cannot conclude that the real estate growth rates for Carson City and Gardnerville/Minden areas are different than one another.  Second, the data is statistically insignificant to conclude that there is any relationship between the real estate growth rates and mean home price in either study areas.  Larger samples are needed and further statistical analysis needs to be done accept either alternative hypothesis.