TREND ANALYSIS

CHENNAI

PLACE 2006 2007 2008 2009 2010

Nungabakkam 3200 5800 10440 15660 20358
Anna Nagar 3500 6500 8500 11115 14535
Besant Nagar 5600 7448 13174 17522 23304
T Nagar 4000 5800 7500 10125 13668
Velachery 3200 3840 4608 5529 6635
Average 3900 5877.6 8844.4 11990.2 15700

Year Price(y) Deviation(x) x2 x*y

2006 3900 -2 4 -7800
2007 5877.6 -1 1 -5877.6
2008 8844.4 0 0 0
2009 11990.2 1 1 11990.2
2010 15700 2 4 31400
 N=5 46312.2 0 10 29712.6

a=9262.44 b=2971.2

PROJECTION OF THE PRICES:

Year Prices 
2010 15204.96
2011 18176.22
2012 21147.48
2013 24118.74
2014 27090
2015 30061.26
 BANGALORE

PLACE 2006 2007 2008 2009 2010

White field 5000 8900 12500 17500 24500
Richmond town 7200 11000 15500 21840 30775
Palace orchards 7500 11000 13500 16568 20330
Indira nagar 4200 6500 9200 13020 18430
Kanamangla 4000 6500 8500 11100 14530
Average 5981.2 9181.4 12241.6 16407.4 22115

Year Price(y) Deviation(x) x2 x*y

2006 5981 -2 4 -7800
2007 9181 -1 1 -5877.6
2008 12241 0 0 0
2009 16407 1 1 11990.2
2010 22115 2 4 31400
 N=5 65925 0 10 29712.6

a=13185 b=29

PROJECTION OF THE PRICES

Year Prices 
2010 21083.8
2011 25033.2
2012 28982.6
2013 32932
2014 36881.4
2015 40830.8
 DELHI

PLACE 2006 2007 2008 2009 2010

Shanti Niketan 18000 22500 27000 33750 40500
Vasant Vihar 17000 21000 26500 33440 42200
Friends Colony 10000 13500 18000 24000 32000
Gurgaon 3700 4850 6100 7672.165 9649.527
Nodia 3700 4900 6850 9576.02 13386.89

Average 10881.2 13751.4 17291.6 22089.44 27949.28

Year Price(y) Deviation(x) x2 x*y

2006 10881.2 -2 4 -7800
2007 13751.4 -1 1 -5877.6
2008 17291.6 0 0 0
2009 22089.44 1 1 11990.2
2010 27949.28 2 4 31400
 N=5 91926.92 0 10 29712.6

a=5589.856 b=4247.42

PROJECTION OF THE PRICES

Year Prices 
2010 26887.42
2011 31134.84
2012 35382.26
2013 39629.68
2014 43877.1
2015 48124.52
 HYDERABAD

PLACE 2006 2007 2008 2009 2010

Banjara Hills 3000 4800 6500 8800 11920
Jublee Hills 3000 4600 7500 12230 19930
Himayatnagar 2000 3200 4800 7200 10800
West & East 2000 2800 4200
Marredpally 6300 9450
Secunderabad 2000 3100 4500 6530 9480
Average 2801.2 4101.4 5901.6 8613.8 12718

Year Price(y) Deviation(x) x2 x*y

2006 2801.2 -2 4 -5602.4
2007 4101.4 -1 1 -4101.4
2008 5901.6 0 0 0
2009 8613.8 1 1 8613.8
2010 12718 2 4 25436
N=5 34136 0 10 24346

a= 6827.2 b= 2434.6

PROJECTION OF THE PRICES

Year Prices 
2010 11696.4
2011 14131
2012 16565.6
2013 19000.2
2014 21434.8
2015 23869.4
 MUMBAI

Place 2006 2007 2008 2009 2010

Cuffe Parade 25000 35000 42000 50400 60480

Malabar Hill 28000 38000 46000 55684.21 67407.2

Worli 18000 26000 32500 33120 41400

Bandra (W) 13500 21500 26500 33125 41406.25

Navi Mumbai 2800 3500 5500 8642.857 13581.63

Average 17460 24800 30500 36194.41 44855.02

Year Price(y) Deviation(x) x2 x*y

2006 17460 -2 4 -34920
2007 24800 -1 1 -24800
2008 30500 0 0 0
2009 36190 1 1 36190
2010 44850 2 4 89700
N=5 153800 0 10 66170

a= 30760 b= 6617

PROJECTION OF THE PRICES

Year Prices 
2010 43994
2011 50611
2012 57228
2013 63845
2014 70462
2015 77079
CORRELATION

Price & Unemployment

Price & Interest
Price & Inflation rate rate
rate
Chennai

0.993749 0.347610718 -0.703721256

Price & Unemployment

Price & Interest
Price & Inflation rate rate
rate
Mumbai

0.986543 0.318633477 -0.652526643

Price & Unemployment

Price & Interest
Price & Inflation rate rate
rate
Delhi

0.998109 0.385912761 -0.730913346

Price & Unemployment

Price & Interest
Price & Inflation rate rate
rate
Hyderabad

0.999327 0.461329945 -0.783078072

 Price & Unemployment
Price & Interest
Price & Inflation rate rate
rate
Bangalore

0.997929 0.387569695 -0.722131407

 CHENNAI

REGRESSION STATISTICS

Multiple R 0.998376479
R Square 0.996755594
Adjusted R Square 0.987022377
Standard Error 538.1825828
Observations 5

ANOVA

Significance
df SS MS F F
Regression 3 88984180.31 29661393.44 102.4076198 0.072484088
Residual 1 289640.4924 289640.4924
Total 4 89273820.8

Standard P- Lower Upper

Coefficients Error t Stat value Lower 95% Upper 95% 95.0% 95.0%
Intercept -687.62 9893.48 -0.07 0.96 -126396.14 125020.90 -126396.14 125020.90
Inflation rate 185042.32 20675.02 8.95 0.07 -77658.74 447743.37 -77658.74 447743.37

Unemployment
rate -33885.94 43540.03 -0.78 0.58 -587114.43 519342.54 -587114.43 519342.54
Interest Rate -2067.92 47079.82 -0.04 0.97 -600273.79 596137.94 -600273.79 596137.94

RESIDUAL OUTPUT

Predicted Price (per Standard

Observation Sq.ft.) Residuals Residuals
1 3835.668109 64.33189127 0.239070878
2 6207.690314 -330.690314 -1.228914961
3 8448.039771 395.9602287 1.471471732
-
4 12128.83805 138.8380547 -0.515951497
5 15690.76375 9.236248757 0.034323849
 Interest Rate Line Fit Plot

Price (per Sq.ft.) 20000

15000 Price (per Sq.ft.)

10000
Predicted Price
5000 (per Sq.ft.)

0
0.00% 5.00% 10.00% 15.00%
Interest Rate

Unemployment
rate Line Fit Plot
Price (per Sq.ft.)

20000
15000
10000 Price (per Sq.ft.)
5000
0
Predicted Price
0.00% 5.00% 10.00% 15.00% (per Sq.ft.)
Unemployment
rate

Inflation rate Line Fit Plot

20000
Price (per Sq.ft.)

15000 Price (per Sq.ft.)

10000
Predicted Price
5000 (per Sq.ft.)
0
0.00% 5.00% 10.00% 15.00%
Inflation rate
 MUMBAI

REGRESSION STATISTICS

Multiple R 0.999409823
R Square 0.998819994
Adjusted R Square 0.995279975
Standard Error 721.1110266
Observations 5

ANOVA

Significance
  df SS MS F F
Regression 3 440156563.7 146718854.6 282.1510396 0.043728728
Residual 1 520001.1127 520001.1127
Total 4 440676564.8      

Standard Lower Upper

  Coefficients Error t Stat P-value Lower 95% Upper 95% 95.0% 95.0%
Intercept -28899.12 13256.27 -2.18 0.27 -197336.01 139537.77 -197336.01 139537.77
Inflation rate 483005.62 27702.47 17.44 0.04 131012.39 834998.85 131012.39 834998.85

Unemployment
rate 59818.01 58339.30 1.03 0.49 -681453.02 801089.04 -681453.02 801089.04
Interest Rate 183670.10 63082.27 2.91 0.21 -617866.15 985206.34 -617866.15 985206.34

RESIDUAL OUTPUT

Predicted Price (per Standard

Observation Sq.ft.) Residuals Residuals
1 17373.80168 86.1983231 0.239070878
2 25243.09206 -443.0920647 -1.228914961
3 29969.45275 530.5472457 1.471471732
4 36380.02916 -186.029157 -0.515951497
5 44842.62435 12.37565287 0.034323849
 Interest Rate Line Fit Plot
P ric e (p er S q .ft.)
50000
40000 Price (per Sq.ft.)
30000
20000 Predicted Price
10000 (per Sq.ft.)
0
0.00 5.00 10.00 15.00
% % % %
Interest Rate

Unemployment
rate Line Fit Plot
P rice (p er S q .ft.)

50000
40000
30000
20000
10000 Price (per Sq.ft.)
0
0.00 5.00 10.00 15.00 Predicted Price
% % % % (per Sq.ft.)
Unemployment
rate

Inflation rate Line Fit Plot

Price (per Sq.ft.)

50000
40000
Price (per Sq.ft.)
30000
20000 Predicted Price
(per Sq.ft.)
10000
0
0.00% 5.00% 10.00% 15.00%
Inflation rate
 DELHI

REGRESSION STATISTICS

Multiple R 0.99965953
R Square 0.99931917
Adjusted R Square 0.9972767
Standard Error 354.101465
Observations 5

ANOVA

Significance
  df SS MS F F
Regression 3 1.84E+08 61348291 489.2682 0.033218407
Residual 1 125387.8 125387.8
Total 4 1.84E+08      

Coefficient Standard Lower Upper

s Error t Stat P-value Lower 95% Upper 95% 95.0% 95.0%
Intercept 3093.96 6509.49 0.48 0.72 -79616.95 85804.87 -79616.95 85804.87
Inflation rate 261274.16 13603.29 19.21 0.03 88427.94 434120.39 88427.94 434120.39

Unemployment
rate -30515.91 28647.50 -1.07 0.48 -394516.95 333485.12 -394516.95 333485.12
Interest Rate -4559.02 30976.54 -0.15 0.91 -398153.28 389035.24 -398153.28 389035.24

RESIDUAL OUTPUT

Predicted Price (per Standard

Observation Sq.ft.) Residuals Residuals
1 10838.67233 42.32767407 0.239070878
2 13968.58029 -217.5802942 -1.228914961
3 17030.47485 260.5251482 1.471471732
4 22180.34959 -91.34959059 -0.515951497
5 27942.92294 6.077062547 0.034323849
 Interest Rate Line Fit Plot
Price (per Sq.ft.)
30000
20000
10000 Price (per Sq.ft.)

0
Predicted Price (per
0.00% 5.00% 10.00 15.00 Sq.ft.)
% %
Interest Rate

Unemployment
rate Line Fit Plot
Price (per
Sq.ft.)

50000
0
0.00% 5.00% 10.00 15.00 Price (per Sq.ft.)
% %
Unemployment Predicted Price
rate (per Sq.ft.)

Inflation rate Line Fit Plot

Price (per

30000
Sq.ft.)

20000
10000 Price (per Sq.ft.)
0
0.00% 5.00% 10.00 15.00
Predicted Price
% %
(per Sq.ft.)
Inflation rate
 HYDERABAD

REGRESSION STATISTICS

Multiple R 0.999811642
R Square 0.999623319
Adjusted R Square 0.998493277
Standard Error 153.3039723
Observations 5

ANOVA

Significance
  df SS MS F F
Regression 3 62369124.69 20789708.23 884.5890892 0.024709822
Residual 1 23502.10791 23502.10791
Total 4 62392626.8      

Coefficient Standard Upper Lower Upper

  s Error t Stat P-value Lower 95% 95% 95.0% 95.0%
Intercept -2116.89 2818.21 -0.75 0.59 -37925.59 33691.80 -37925.59 33691.80
Inflation rate 143603.85 5889.38 24.38 0.03 68772.15 218435.55 68772.15 218435.55

Unemployment
rate -359.79 12402.59 -0.03 0.98 -157949.66 157230.08 -157949.66 157230.08
Interest Rate -9775.77 13410.92 -0.73 0.60 -180177.67 160626.13 -180177.67 160626.13

RESIDUAL OUTPUT

Predicted Price (per Standard

Observation Sq.ft.) Residuals Residuals
1 2782.674742 18.32525762 0.239070878
2 4195.198773 -94.19877258 -1.228914961
3 5789.208769 112.7912308 1.471471732
4 8653.548707 -39.54870702 -0.515951497
5 12715.36901 2.63099117 0.034323849
 Interest Rate Line Fit Plot
P ric e (p e r S q .ft.)
15000
Price (per Sq.ft.)
10000
5000 Predicted Price
(per Sq.ft.)
0
0.00% 5.00% 10.00 15.00
% %
Interest Rate

Unemployment
rate Line Fit Plot
Price (per
Sq.ft.)

20000
0
0.00% 5.00% 10.00 15.00 Price (per Sq.ft.)
% %
Unemployment Predicted Price
rate (per Sq.ft.)

Inflation rate Line Fit Plot

Price (per

15000
Sq.ft.)

10000
5000 Price (per Sq.ft.)
0
0.00% 5.00% 10.00 15.00
Predicted Price
% %
(per Sq.ft.)
Inflation rate
 BANGLORE

REGRESSION STATISTICS

Multiple R 0.999837299
R Square 0.999674624
Adjusted R Square 0.998698495
Standard Error 227.4136506
Observations 5

ANOVA

Significance
  df SS MS F F
Regression 3 158893347.8 52964449.28 1024.12 0.022965694
Residual 1 51716.9685 51716.9685
Total 4 158945064.8      

Standard P- Upper Lower Upper

  Coefficients Error t Stat value Lower 95% 95% 95.0% 95.0%
Intercept -8986.38 4180.57 -2.15 0.28 -62105.59 44132.83 -62105.59 44132.83
Inflation rate 256439.69 8736.41 29.35 0.02 145433.12 367446.27 145433.12 367446.27

Unemployment
rate 4127.33 18398.21 0.22 0.86 -229644.09 237898.76 -229644.09 237898.76
Interest Rate 33799.09 19893.98 1.70 0.34 -218977.92 286576.09 -218977.92 286576.09

RESIDUAL OUTPUT

Predicted Price (per Standard

Observation Sq.ft.) Residuals Residuals
1 5953.816009 27.18399055 0.239070878
2 9320.736019 -139.7360189 -1.228914961
3 12074.68362 167.3163792 1.471471732
4 16465.66721 -58.66720679 -0.515951497
5 22111.09714 3.902855862 0.034323849
 Inflation rate Line Fit Plot
P ric e (p er S q .ft.)

25000
20000
15000
10000 Price (per Sq.ft.)
5000
0
Predicted Price
0.00% 5.00% 10.00 15.00
(per Sq.ft.)
% %
Inflation rate

Unemployment
rate Line Fit Plot
P ric e (p e r
S q .ft.)

40000
20000
0 Price (per Sq.ft.)
0.00% 5.00% 10.00 15.00
% % Predicted Price
Unemployment (per Sq.ft.)
rate

Interest Rate Line Fit Plot

Price (per Sq.ft.)

25000
20000 Price (per Sq.ft.)
15000
10000 Predicted Price (per
5000 Sq.ft.)
0
0.00% 5.00% 10.00% 15.00%
Interest Rate