Monday, August 31, 2015

Sydney House Prices 30/08/15: Average 3 bedroom house now sells for $1,229.523 (down 0.09%)

Stats as per usual


House Type Total Sample Average Min Max Confidence Change
Average 2 Bedroom House 417      1,144,773.21           1,104,732.97    1,184,813.45 40040.24411 -0.94%
3 Bedroom House 1605      1,229,523.66           1,205,237.08    1,253,810.23 24286.57627 -0.09%
4 Bedroom House 1225      1,437,893.35           1,402,356.78    1,473,429.92 35536.57182 0.61%
Unit Type Average Min Max Confidence
2 Bedroom Unit 1114          824,804.17              805,534.22        844,074.13              19,269.95 -0.08%
3 Bedroom Unit 454      1,132,433.48           1,084,504.28    1,180,362.68              47,929.20 1.23%

Monday, August 24, 2015

Sydney House Prices 23/08/2015: Average 3 bedroom house now sells for $1,230,604 (down 0.06%)

Stats for this week


House Type Total Sample Average Min Max Confidence Change
Average 2 Bedroom House 376    1,155,660.24           1,112,996.57    1,198,323.91 42663.67184 -0.60%
1,162,640.26
3 Bedroom House 1489    1,230,604.08           1,205,322.54    1,255,885.61 25281.53473 -0.06%
1,231,295.84
4 Bedroom House 1128    1,429,192.86           1,392,417.64    1,465,968.09 36775.22107 0.19%
1,426,523.12
Unit Type Average Min Max Confidence
2 Bedroom Unit 1033        825,462.58              805,222.84        845,702.33              20,239.74 0.36%         770,000.00
3 Bedroom Unit 420    1,118,651.91           1,069,159.87    1,168,143.94              49,492.04 0.30%         995,000.00

Monday, August 17, 2015

Sydney House Prices 16/08/2015: Average 3 bedroom house now sells for $1,231,295 (down 0.01%)

Stats as per normal


House Type Total Sample Average Min Max Confidence Change
Average 2 Bedroom House 346    1,162,640.26           1,117,331.37    1,207,949.15 45308.89073 0.37%
3 Bedroom House 1401    1,231,295.84           1,204,949.02    1,257,642.66 26346.82143 -0.01%
4 Bedroom House 1051    1,426,523.12           1,388,093.87    1,464,952.37 38429.24977 -0.14%

Wednesday, August 12, 2015

Noses in the trough..Part 2. Libs, Nats and Greens the worst when it comes to expenses

Some further stats around the entitlements in the commonwealth. I calculated expenses by Party and compared each Parties representation in the members claiming vs the % of the total entitlement claimed. In theory, if it were fair, each parties % of entitlement would be equal to its % of representation. Not the case however. Here are the summary stats.


Labor is surprisingly good. Liberal, Nats (including CLP), Greens and Bob Katter less so.
Party Entitlement by
Party
% of Total
Entitlement    
Number of Party
Members claiming
% of Total Members  Claiming Amount Parties are overcharging based on representation
Labor $16,740,241.80 36.6244% 121 39.29% -2.6614%
Liberal $20,510,946.47 44.8739% 133 43.18% 1.6921%
National $4,218,421.62 9.2291% 24 7.79% 1.4369%
Greens $2,143,832.66 4.6903% 13 4.22% 0.4695%
PUP $153,528.00 0.3359% 3 0.97% -0.6381%
CLP $820,938.72 1.7961% 3 0.97% 0.8220%
Independent $723,609.52 1.5831% 7 2.27% -0.6896%
AUS $334,340.72 0.7315% 1 0.32% 0.4068%
AMEP $12,520.18 0.0274% 1 0.32% -0.2973%
FFP $29,056.29 0.0636% 1 0.32% -0.2611%
LDP $20,517.37 0.0449% 1 0.32% -0.2798%
Total Members 308
Total Entitlements  $  45,707,953.35
Average Entitlement  $        148,402.45 

Who has their nose in the trough: An Analysis of Australian Federal Members Entitlements

Been looking over the Federal Govenment's Entitlements that were provided by The Guardian Australia Website.


I collated all the expenses to get an idea of which members claim the most. The top 10 list is below (not the collated stats included flights, charters, Electoral Business expense, travel expenses from 2011 - 2014


And we have the top 10.


SNOWDON Warren 529652.27  NT Labor
SCULLION Nigel 495887.16  NT CLP
TRUSS Warren 484990.23  QLD National
BISHOP Julie 464470.99  WA Liberal
GRAY Gary 435525.4  WA Labor
CORMANN Mathias 421243.8  WA Liberal
MACDONALD Ian 406051.84 QLD Liberal
JOYCE Barnaby 382486.5 NSW National
SIEWERT Rachel 381147.5  WA Greens
DUTTON Peter 375724.51  QLD Liberal
 

Monday, August 10, 2015

Australian/NZ Netflix Subscribers. Total Members likely to be only 581,500

Lots of numbers floating about the Australian media about Netflix Subscribers in Australia and how there are over 1.4 million Netflix Subscribers over the last three months. I think this is absolute rubbish. When you think there are only around 8,000,000 households in Australia, that would mean a market penetration of 17.5%...which is a lot for a luxury item, especially when Foxtel only has around 30% of the market (being around for a while and has the advantage of sport)


So I decided to do my own analysis. Firstly I downloaded the quarterly International Streaming total members numbers published in the financial reports of Netflix since 2011. (Since Australian/NZ data would appear in that segment


I then calculated the increases in each period, found the 4 quarter moving average and seasonally adjusted the data to get the Seasonally Adjusted Data Set. Produces the data set below.


Raw Increase Average Residual Average Residual
Seasonal
SA Series
2015.1 20877 2600 2048.5 551.5 390.625 2209.375
2014.4 18277 2434 1836.75 597.25 448.6875 1985.313
2014.3 15843 2042 1663.75 378.25 149.7291667 1892.271
2014.2 13801 1118 1513.5 -395.5 -311.5 1429.5
2014.1 12683 1753 1385.25 367.75 390.625 1362.375
2013.4 10930 1742 1202.25 539.75 448.6875 1293.313
2013.3 9188 1441 1219.25 221.75 149.7291667 1291.271
2013.2 7747 605 1030.75 -425.75 -311.5 916.5
2013.1 7142 1021 1019.25 1.75 390.625 630.375
2012.4 6121 1810 1065.75 744.25 448.6875 1361.313
2012.3 4311 687 707.75 -20.75 149.7291667 537.2708
2012.2 3624 559 664.25 -105.25 -311.5 870.5
2012.1 3065 1207 565.5 641.5 390.625 816.375
2011.4 1858 378 464.5 -86.5 448.6875 -70.6875
2011.3 1480 513 493.3333 19.66667 149.7291667 363.2708
2011.2 967 164 483.5 -319.5 -311.5 475.5
2011.1 803 803 803 0






Finding the trend on that SA Series, (y = 119.86x+66.431) gives you a SA increase for 2015. Q2 of 2,104,000 subscribers





However, we need to remove the seasonal adjustment of that (by adding back the Q2 average residual),which results in a raw increase  of 1,792,551 subscribers.


As the 2015.Q1 International Subscribers (this includes paid and un payed) was reported as 20,877,000 members, that means that based on the trend there should be 22,669,550 International Subscribers of Netflix at the end of 2015.Q2


Note: As Australia/NZ Netflix only started in Q2, 2015, we can make the assumption that any difference in the trend Subscriber numbers and the raw subscriber numbers (from the Q2 report) will be from Australia and NZ (as no other international division started during that period.)


From the Q2.2015 financial report, the international members of Netflix are reported as 23,251,000 members.


So based on those figures, we have Australian/NZ Netflix subscribers to be 581,500 (23,251,000 - 22,669,550). A good number for three months, but no where near the 1.4 members being thrown about in the press.


Don't believe everything you read.


Sydney House Prices 9/8/15: Average 3 bedroom house now sells for $1,231,477 (up 0.45%)

Still a bit of heat in the 2/3 bedroom house ranges.


Type Total Sample Average Min Max Confidence Change
2 Bedroom House 322    1,158,353.45           1,112,350.11    1,204,356.79 46003.34111 0.45%
3 Bedroom House 1289    1,231,477.27           1,204,218.43    1,258,736.11 27258.84215 0.43%
4 Bedroom House 966    1,428,586.75           1,388,030.07    1,469,143.43 40556.68236 -0.06%