Question
Retail turnover in Australia by industry group between Oct 2020 and Sep 2021 (in $ millions) Turnover Month Household goods Clothing, footwear and personal accessory
Retail turnover in Australia by industry group between Oct 2020 and Sep 2021
(in $ millions)
Turnover
Month | Household goods | Clothing, footwear and personal accessory | Department stores | Other retailing | Cafes, restaurants and takeaway food services |
Oct-2020 | 5,363.4 | 2,095.6 | 1,571.5 | 4,357.1 | 3,468.9 |
Nov-2020 | 5,981.3 | 2,631.7 | 1,877.0 | 4,697.9 | 3,697.7 |
Dec-2020 | 5,513.3 | 2,395.3 | 1,655.4 | 4,503.3 | 3,819.2 |
Jan-2021 | 5,509.2 | 2,344.8 | 1,638.8 | 4,555.0 | 3,806.8 |
Feb-2021 | 5,550.1 | 2,383.2 | 1,675.4 | 4,536.1 | 3,848.0 |
Mar-2021 | 5,546.1 | 2,511.8 | 1,817.1 | 4,598.9 | 4,034.2 |
Apr-2021 | 5,629.0 | 2,540.9 | 1,695.3 | 4,678.0 | 4,125.3 |
May-2021 | 5,569.0 | 2,540.1 | 1,683.9 | 4,708.6 | 4,155.1 |
Jun-2021 | 5,494.8 | 2,299.3 | 1,565.3 | 4,632.6 | 3,904.4 |
Jul-2021 | 5,371.6 | 1,944.4 | 1,387.0 | 4,658.7 | 3,425.7 |
Aug-2021 | 5,247.0 | 1,640.1 | 1,245.2 | 4,695.9 | 3,186.2 |
Sep-2021 | 5,474.7 | 1,736.2 | 1,241.2 | 4,793.9 | 3,345.9 |
a) Calculate the mean and standard deviation for each industry group. 1 mark
b) Calculate the Minimum, Q1, Median, Q3 and Maximum values for each industry group. 1 mark c) Draw a box and whisker plot for the retail turnover of each industry group and put them side by side on one graph with the same scale for comparison. (This graph must be done in EXCEL or similar software and cannot be hand-drawn.) 1 mark
d) Compare the box plots and comment on the distribution of the data. 1 mark
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