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.

 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.

 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.

 

Transcribed Image Text:

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 No. of Recorded Year Groceries Homeware Electrical 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. 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 No. of Recorded Year Groceries Homeware Electrical 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.