[Total Marks for Question 2 = 22] Section 3 Below is a table that represents the data gathered by students during their research to explore the causes of shoplifting in England and Wales between 2013 and 2023. They gathered data on the overall number of shoplifting offences recorded each year and also displayed the main categories of items that were stolen. Number of Shoplifting Offences in England and Wales by Category Year Groceries Homeware Electrical No. of Recorded Other Offences 2013/14 208,964 48,222 19,289 45,008 321,483 2014/15 201,920 42,338 16,284 65,136 325,678 2015/16 199,672 39,934 13,311 79,869 332,786 2016/17 244,987 54,848 21,939 43,878 365,652 2017/18 246,464 58,682 27,385 58,682 391,213 2018/19 227,389 53,057 22,739 75,797 378,982 2019/20 250,846 43,002 21,501 43,002 358,351 2020/21 161,077 35,304 14,342 9,930 220,653 2021/22 210,011 42,002 22,401 5,600 280,014 2022/23 290,959 75,902 33,734 21,084 421,679 Use the information in the table above to answer the following questions below. a) What percentage of recorded offences of shoplifting were groceries in 2022/23? (Round your answer to 1 decimal place) [3 marks] b) Give two reasons why you believe groceries have a higher percentage than any other category of items shoplifted. [2 Marks] c) Answer the following two parts: i) What is the ratio of the number of homeware items shoplifted to electrical items in 2019/20? Give your answer in it's most simplest form. ii) Using your answer from part i), explain in words what this ratio means. [4 marks] Page 7 of 14 [2870] Arden University @ reserves all rights of copyright an ghts in the learning trials and this publication. No part of any of the learning materials or this publication may be reproduc any form or me including without limitation electronic, mechanical, pho sent of Arden University. To find out more about the use and distribution of programme materials please see the Arden Student Terms and Conditions. A UNIVERSITY d) Use Excel to find the total number of recorded offences between 2013/14 and 2022/23. To ensure full marks, write the formula you used in Excel as part of your answer. [3 marks] e) Use Excel to find the minimum number of recorded offences between 2013/14 and 2022/23. To ensure full marks, write the formula you used in Excel as part of your answer. [3 marks] f) Write the conditional formulae that you would use in Excel to count how many years the total number of recorded offences were greater than 340,000. [3 marks] g) Use Excel to create a fully labelled line graph to show the total number of recorded offences in each year from 2013/14 to 2022/23. Take a screenshot of your chart or graph and insert it into your portfolio. [6 marks] h) Based on your graph from part g), comment on the overall trend of shoplifting between 2013/14 and 2022/23. (Hint: In your answer, comment on why you think there were peaks and dips in the graph) [4 marks] [Total Marks for Question 3 = 28]