Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finite Mathematics and Its Applications

Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair

12th edition

978-0134768588, 9780134437767, 134768582, 134437764, 978-0134768632

More Books

Students also viewed these Mathematics questions