Analyse the monthly Australian retail turnover by state using an appropriate graphical descriptive method. Briefly comment on
Fantastic news! We've Found the answer you've been seeking!
Question:
Analyse the monthly Australian retail turnover by state using an appropriate graphical descriptive method. Briefly comment on any pattern that can be observed. Monthly retail turnover data for the period between January 2018 and February 2023 are given in the file Retail_Turnover.xlsx.
| Turnover ; New South Wales ; Total (Industry) ; | Turnover ; Victoria ; Total (Industry) ; | Turnover ; Queensland ; Total (Industry) ; | Turnover ; South Australia ; Total (Industry) ; | Turnover ; Western Australia ; Total (Industry) ; | Turnover ; Tasmania ; Total (Industry) ; | Turnover ; Northern Territory ; Total (Industry) ; | Turnover ; Australian Capital Territory ; Total (Industry) ; | Turnover ; Total (State) ; Total (Industry) ; | |
| Unit | $ Millions | $ Millions | $ Millions | $ Millions | $ Millions | $ Millions | $ Millions | $ Millions | $ Millions |
| Series Type | Seasonally Adjusted | Seasonally Adjusted | Seasonally Adjusted | Seasonally Adjusted | Seasonally Adjusted | Seasonally Adjusted | Seasonally Adjusted | Seasonally Adjusted | Seasonally Adjusted |
| Data Type | FLOW | FLOW | FLOW | FLOW | FLOW | FLOW | FLOW | FLOW | FLOW |
| Frequency | Month | Month | Month | Month | Month | Month | Month | Month | Month |
| Collection Month | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Series ID | A3348648L | A3348711T | A3348774A | A3348837X | A3348900C | A3348963L | A3349026L | A3349089W | A3348585R |
| Jan-2018 | 8487.3 | 6761.6 | 5259.2 | 1736.5 | 2826.6 | 522.5 | 260.6 | 479.9 | 26334.2 |
| Feb-2018 | 8553.1 | 6824.4 | 5214.2 | 1745.2 | 2813.2 | 527.8 | 262.7 | 481.7 | 26422.4 |
| Mar-2018 | 8537.7 | 6831.9 | 5202.1 | 1748.2 | 2821.0 | 526.9 | 263.9 | 489.8 | 26421.5 |
| Apr-2018 | 8599.7 | 6864.5 | 5207.2 | 1736.8 | 2845.8 | 533.2 | 269.5 | 492.2 | 26548.9 |
| May-2018 | 8623.9 | 6864.9 | 5239.3 | 1751.1 | 2834.0 | 539.1 | 269.3 | 494.1 | 26615.8 |
| Jun-2018 | 8630.8 | 6939.9 | 5227.4 | 1751.5 | 2837.9 | 542.2 | 267.6 | 497.6 | 26694.9 |
| Jul-2018 | 8640.6 | 6947.6 | 5292.9 | 1750.1 | 2803.3 | 539.2 | 264.2 | 493.7 | 26731.5 |
| Aug-2018 | 8722.2 | 7004.3 | 5310.1 | 1761.1 | 2825.8 | 544.7 | 261.5 | 492.1 | 26921.9 |
| Sep-2018 | 8674.7 | 7070.0 | 5325.2 | 1764.9 | 2821.5 | 545.5 | 257.8 | 496.7 | 26956.3 |
| Oct-2018 | 8631.8 | 7137.9 | 5407.0 | 1774.2 | 2840.5 | 547.4 | 258.4 | 502.4 | 27099.6 |
| Nov-2018 | 8656.2 | 7065.0 | 5381.7 | 1760.8 | 2847.0 | 545.0 | 255.3 | 504.5 | 27015.6 |
| Dec-2018 | 8712.8 | 7070.9 | 5392.4 | 1763.1 | 2853.3 | 545.9 | 255.8 | 500.8 | 27094.9 |
| Jan-2019 | 8759.8 | 7059.4 | 5376.8 | 1768.5 | 2849.3 | 546.9 | 252.5 | 498.4 | 27111.5 |
| Feb-2019 | 8764.5 | 7112.5 | 5423.6 | 1777.8 | 2870.0 | 544.0 | 257.8 | 507.7 | 27258.0 |
| Mar-2019 | 8707.2 | 7137.0 | 5471.1 | 1784.0 | 2850.8 | 546.0 | 258.7 | 508.2 | 27263.0 |
| Apr-2019 | 8661.6 | 7088.7 | 5498.6 | 1791.4 | 2852.4 | 546.6 | 257.7 | 507.4 | 27204.2 |
| May-2019 | 8657.1 | 7165.3 | 5505.0 | 1803.7 | 2864.3 | 544.9 | 258.9 | 510.4 | 27309.5 |
| Jun-2019 | 8685.8 | 7175.1 | 5510.1 | 1787.7 | 2871.6 | 551.8 | 259.5 | 510.2 | 27351.9 |
| Jul-2019 | 8697.0 | 7197.3 | 5532.4 | 1779.6 | 2898.7 | 550.3 | 260.5 | 505.0 | 27420.8 |
| Aug-2019 | 8741.4 | 7230.5 | 5570.7 | 1786.9 | 2897.7 | 553.6 | 261.3 | 513.7 | 27555.9 |
| Sep-2019 | 8800.2 | 7263.3 | 5560.8 | 1797.1 | 2918.0 | 558.6 | 259.7 | 517.5 | 27675.2 |
| Oct-2019 | 8777.5 | 7249.6 | 5626.4 | 1793.4 | 2930.4 | 572.6 | 264.4 | 521.8 | 27736.1 |
| Nov-2019 | 8838.8 | 7271.5 | 5666.5 | 1810.4 | 2929.3 | 573.8 | 263.1 | 520.4 | 27873.8 |
| Dec-2019 | 8758.5 | 7266.5 | 5641.5 | 1784.2 | 2935.5 | 584.1 | 260.6 | 519.6 | 27750.4 |
| Jan-2020 | 8761.1 | 7254.9 | 5655.4 | 1788.6 | 2902.1 | 579.2 | 259.1 | 504.5 | 27704.7 |
| Feb-2020 | 8719.1 | 7302.2 | 5672.5 | 1793.7 | 2936.6 | 577.1 | 259.6 | 515.1 | 27776.1 |
| Mar-2020 | 9300.3 | 7785.8 | 6193.7 | 1963.7 | 3223.5 | 627.4 | 287.8 | 565.3 | 29947.3 |
| Apr-2020 | 7721.5 | 6186.6 | 5227.8 | 1681.2 | 2713.7 | 517.3 | 264.9 | 481.0 | 24793.9 |
| May-2020 | 8907.4 | 7203.7 | 6061.6 | 1942.9 | 3227.1 | 605.2 | 286.0 | 537.8 | 28771.8 |
| Jun-2020 | 9264.3 | 7502.3 | 6132.7 | 1966.1 | 3295.0 | 626.1 | 278.4 | 556.8 | 29621.8 |
| Jul-2020 | 9879.3 | 7405.8 | 6480.3 | 2030.5 | 3446.1 | 654.7 | 282.7 | 586.2 | 30765.6 |
| Aug-2020 | 9691.2 | 6500.2 | 6385.6 | 2002.0 | 3409.9 | 649.4 | 290.8 | 590.1 | 29519.2 |
| Sep-2020 | 9607.4 | 6494.9 | 6279.3 | 1952.6 | 3357.9 | 636.2 | 297.5 | 580.3 | 29206.2 |
| Oct-2020 | 9738.7 | 6835.3 | 6303.9 | 1970.2 | 3390.5 | 635.3 | 298.7 | 582.7 | 29755.4 |
| Nov-2020 | 9902.1 | 8281.1 | 6501.2 | 1954.0 | 3402.8 | 649.4 | 304.6 | 589.4 | 31584.6 |
| Dec-2020 | 9530.5 | 7727.4 | 6421.9 | 1953.3 | 3374.0 | 630.0 | 305.4 | 585.4 | 30527.9 |
| Jan-2021 | 9559.6 | 7788.0 | 6328.4 | 1953.5 | 3426.0 | 635.6 | 307.0 | 586.8 | 30585.0 |
| Feb-2021 | 9626.8 | 7562.7 | 6362.0 | 1956.3 | 3253.7 | 637.9 | 302.7 | 590.2 | 30292.4 |
| Mar-2021 | 9580.4 | 7818.4 | 6359.8 | 1947.1 | 3424.7 | 643.5 | 303.1 | 579.4 | 30656.4 |
| Apr-2021 | 9774.1 | 7872.8 | 6360.0 | 1956.4 | 3397.4 | 644.8 | 301.3 | 586.5 | 30893.4 |
| May-2021 | 9830.8 | 7830.7 | 6432.8 | 1953.0 | 3425.2 | 650.1 | 298.1 | 593.8 | 31014.6 |
| Jun-2021 | 9626.0 | 7540.6 | 6394.1 | 1966.6 | 3426.0 | 641.1 | 292.9 | 596.0 | 30483.2 |
| Jul-2021 | 8842.1 | 7624.7 | 6364.0 | 1895.8 | 3462.3 | 657.4 | 298.8 | 605.9 | 29751.0 |
| Aug-2021 | 8497.3 | 7432.8 | 6318.2 | 2015.7 | 3540.7 | 649.7 | 298.4 | 485.2 | 29238.0 |
| Sep-2021 | 8822.0 | 7361.6 | 6627.6 | 2046.9 | 3596.9 | 661.5 | 299.2 | 428.1 | 29843.9 |
| Oct-2021 | 9933.1 | 7539.8 | 6664.3 | 2026.0 | 3607.4 | 657.4 | 301.7 | 517.8 | 31247.4 |
| Nov-2021 | 10398.8 | 8929.6 | 6687.6 | 2064.0 | 3639.5 | 670.5 | 296.3 | 616.0 | 33302.2 |
| Dec-2021 | 10028.5 | 8247.2 | 6667.6 | 1987.1 | 3569.7 | 655.0 | 303.0 | 594.2 | 32052.2 |
| Jan-2022 | 10176.3 | 8446.7 | 6699.0 | 2046.6 | 3696.8 | 657.5 | 309.3 | 600.2 | 32632.4 |
| Feb-2022 | 10436.6 | 8550.4 | 6774.3 | 2103.2 | 3592.9 | 660.2 | 297.1 | 608.6 | 33023.2 |
| Mar-2022 | 10548.3 | 8593.2 | 7016.9 | 2099.3 | 3663.7 | 663.0 | 301.0 | 618.2 | 33503.5 |
| Apr-2022 | 10585.9 | 8655.7 | 7096.2 | 2123.5 | 3734.9 | 677.2 | 302.1 | 622.3 | 33797.8 |
| May-2022 | 10706.4 | 8747.8 | 7100.5 | 2153.9 | 3752.8 | 682.3 | 305.0 | 620.1 | 34068.9 |
| Jun-2022 | 10785.9 | 8788.5 | 7149.8 | 2166.5 | 3777.6 | 686.8 | 309.0 | 625.0 | 34289.2 |
| Jul-2022 | 10894.1 | 8886.2 | 7176.4 | 2187.8 | 3824.2 | 686.7 | 310.2 | 631.1 | 34596.7 |
| Aug-2022 | 11014.6 | 8969.8 | 7221.6 | 2214.2 | 3827.0 | 695.6 | 312.0 | 642.2 | 34897.1 |
| Sep-2022 | 11088.7 | 9023.6 | 7260.9 | 2222.3 | 3872.8 | 701.9 | 313.8 | 651.7 | 35135.6 |
| Oct-2022 | 11133.4 | 9079.5 | 7279.8 | 2227.4 | 3886.3 | 702.1 | 311.1 | 649.8 | 35269.5 |
| Nov-2022 | 11315.8 | 9223.6 | 7384.0 | 2261.4 | 3969.0 | 714.2 | 318.1 | 657.8 | 35843.9 |
| Dec-2022 | 10933.5 | 8788.5 | 7102.1 | 2203.1 | 3781.2 | 686.9 | 309.1 | 635.2 | 34439.7 |
| Jan-2023 | 11095.4 | 9051.6 | 7131.2 | 2240.9 | 3876.8 | 705.5 | 310.7 | 657.6 | 35069.6 |
| Feb-2023 | 11125.4 | 9068.0 | 7102.5 | 2253.6 | 3907.9 | 707.0 | 312.7 | 664.3 | 35141.4 |
Expert Answer:
Posted Date:
