Scenarios
Scenario 1: income vs sentiment
Median income joined with suburb tweet sentiment pooled to each Victorian SA2 (revival analysis). avg_* are NULL where an SA2 had no tweets.
page 17 of 19 CSV
| sa2_codeTEXT | sa2_nameTEXT | median_audREAL | mean_audREAL | vic_iqr_keptINTEGER | tweets_allINTEGER | avg_allREAL | sal_countINTEGER | tweets_incomeINTEGER | avg_incomeREAL |
|---|---|---|---|---|---|---|---|---|---|
| 214021378 | Flinders | 37,354 | 57,056 | 1 | 241 | 5.2946058 | 8 | 5 | 5.8 |
| 214021379 | Hastings - Somers | 37,336 | 44,985 | 1 | 20 | 6.2 | 2 | 1 | 7 |
| 214021380 | Mornington | 46,108 | 55,030 | 1 | 0 | null | 0 | 0 | null |
| 214021381 | Mount Eliza | 41,089 | 46,667 | 1 | 0 | null | 0 | 0 | null |
| 214021382 | Mount Martha | 35,444 | 43,248 | 1 | 0 | null | 0 | 0 | null |
| 214021383 | Point Nepean | 42,686 | 48,270 | 1 | 28 | 5.8571429 | 4 | 2 | 6.5 |
| 214021384 | Rosebud - McCrae | 33,573 | 34,273 | 1 | 17 | 5.8823529 | 2 | 0 | null |
| 214021385 | Somerville | 34,734 | 37,437 | 1 | 15 | 5.8666667 | 3 | 0 | null |
| 215011386 | Ararat | 34,357 | 38,690 | 1 | 1,084 | 5.6420664 | 1 | 98 | 5.7857143 |
| 215011387 | Ararat Region | 39,828 | 45,445 | 1 | 125 | 5.408 | 16 | 1 | 5 |
| 215011388 | Horsham | 36,974 | 43,613 | 1 | 594 | 5.53367 | 2 | 30 | 6.1 |
| 215011389 | Horsham Region | 33,733 | 38,594 | 1 | 12 | 5.25 | 6 | 0 | null |
| 215011390 | Nhill Region | 42,622 | 52,071 | 1 | 856 | 5.5175234 | 11 | 21 | 5.5714286 |
| 215011391 | St Arnaud | 38,952 | 44,622 | 1 | 41 | 6 | 7 | 1 | 5 |
| 215011392 | Stawell | 37,943 | 45,361 | 1 | 400 | 6.2425 | 9 | 10 | 7.4 |
| 215011393 | West Wimmera | 39,412 | 42,842 | 1 | 21 | 5.5714286 | 8 | 1 | 5 |
| 215011394 | Yarriambiack | 40,723 | 47,607 | 1 | 55 | 5.8727273 | 17 | 3 | 6.3333333 |
| 215021395 | Irymple | 42,913 | 49,379 | 1 | 14 | 6.0714286 | 1 | 1 | 5 |
| 215021396 | Merbein | 28,996 | 34,389 | 1 | 44 | 5.9090909 | 2 | 2 | 6.5 |
| 215021398 | Mildura Region | 35,131 | 40,336 | 1 | 31 | 6.0967742 | 13 | 1 | 8 |
| 215021399 | Red Cliffs | 36,422 | 40,481 | 1 | 12 | 5.0833333 | 2 | 0 | null |
| 215021469 | Mildura - North | 37,243 | 50,750 | 1 | 0 | null | 0 | 0 | null |
| 215021470 | Mildura - South | 42,773 | 48,445 | 1 | 1,022 | 5.7358121 | 1 | 32 | 6.71875 |
| 215031400 | Buloke | 37,364 | 43,380 | 1 | 1,105 | 5.1303167 | 17 | 10 | 5.9 |
| 215031401 | Gannawarra | 42,933 | 49,745 | 1 | 105 | 5.6666667 | 13 | 0 | null |