Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started