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 18 of 19 CSV
| sa2_codeTEXT | sa2_nameTEXT | median_audREAL | mean_audREAL | vic_iqr_keptINTEGER | tweets_allINTEGER | avg_allREAL | sal_countINTEGER | tweets_incomeINTEGER | avg_incomeREAL |
|---|---|---|---|---|---|---|---|---|---|
| 215031402 | Kerang | 38,735 | 42,824 | 1 | 43 | 5.1162791 | 1 | 0 | null |
| 215031403 | Robinvale | 36,796 | 41,334 | 1 | 36 | 5.4166667 | 2 | 0 | null |
| 215031404 | Swan Hill | 37,002 | 44,881 | 1 | 0 | null | 0 | 0 | null |
| 215031405 | Swan Hill Region | 33,363 | 39,370 | 1 | 1,783 | 5.2978127 | 10 | 44 | 5.7272727 |
| 216011406 | Echuca | 41,362 | 48,271 | 1 | 1,213 | 5.6974444 | 1 | 83 | 5.8674699 |
| 216011407 | Kyabram | 34,324 | 41,955 | 1 | 44 | 5.4318182 | 4 | 3 | 6.3333333 |
| 216011408 | Lockington - Gunbower | 37,413 | 41,316 | 1 | 1 | 5 | 1 | 0 | null |
| 216011409 | Rochester | 38,477 | 46,072 | 1 | 27 | 6.0740741 | 2 | 2 | 6.5 |
| 216011410 | Rushworth | 42,178 | 45,198 | 1 | 762 | 5.1154856 | 5 | 26 | 3.6153846 |
| 216021411 | Cobram | 44,395 | 52,861 | 1 | 87 | 5.1609195 | 1 | 0 | null |
| 216021412 | Moira | 41,211 | 47,888 | 1 | 24 | 5.4166667 | 9 | 0 | null |
| 216021413 | Numurkah | 40,539 | 46,919 | 1 | 683 | 5.682284 | 9 | 65 | 5.5076923 |
| 216021414 | Yarrawonga | 39,055 | 44,486 | 1 | 1,327 | 5.7467973 | 1 | 154 | 5.1753247 |
| 216031415 | Mooroopna | 40,473 | 49,529 | 1 | 1 | 5 | 1 | 0 | null |
| 216031416 | Shepparton - North | 39,889 | 47,314 | 1 | 1,859 | 5.8897257 | 1 | 75 | 6.6266667 |
| 216031417 | Shepparton - South | 43,902 | 53,527 | 1 | 1 | 9 | 1 | 0 | null |
| 216031418 | Shepparton Region - East | 38,141 | 45,457 | 1 | 39 | 5.025641 | 6 | 0 | null |
| 216031419 | Shepparton Region - West | 40,088 | 45,498 | 1 | 781 | 5.553137 | 5 | 25 | 5.84 |
| 217011420 | Glenelg (Vic.) | 43,141 | 47,905 | 1 | 62 | 5.5645161 | 15 | 2 | 7 |
| 217011421 | Hamilton (Vic.) | 36,725 | 43,107 | 1 | 327 | 5.3608563 | 1 | 17 | 5.5294118 |
| 217011422 | Portland | 38,679 | 44,881 | 1 | 242 | 6.161157 | 1 | 22 | 6.0909091 |
| 217011423 | Southern Grampians | 36,424 | 43,207 | 1 | 726 | 5.2713499 | 18 | 145 | 5.0482759 |
| 217031471 | Camperdown | 33,020 | 42,426 | 1 | 144 | 5.0347222 | 1 | 9 | 5.4444444 |
| 217031472 | Colac | 40,053 | 47,031 | 1 | 0 | null | 0 | 0 | null |
| 217031473 | Colac Region | 41,751 | 50,307 | 1 | 611 | 5.7708674 | 6 | 8 | 6.5 |