{"id":32992,"date":"2026-07-30T06:59:27","date_gmt":"2026-07-30T06:59:27","guid":{"rendered":"https:\/\/academicwritersbay.com\/solutions\/com3006-nfc-d-introduction-to-numeracy-data-it-assignment-2026-arden-college-evaluate-temporary-as-fragment-of-the-formal-assessment-for-the-module-introduction-to-numeracy-data-and-it-you-is-s\/"},"modified":"2026-07-30T06:59:27","modified_gmt":"2026-07-30T06:59:27","slug":"com3006-nfc-d-introduction-to-numeracy-data-it-assignment-2026-arden-college-evaluate-temporary-as-fragment-of-the-formal-assessment-for-the-module-introduction-to-numeracy-data-and-it-you-is-s","status":"publish","type":"post","link":"https:\/\/academicwritersbay.com\/solutions\/com3006-nfc-d-introduction-to-numeracy-data-it-assignment-2026-arden-college-evaluate-temporary-as-fragment-of-the-formal-assessment-for-the-module-introduction-to-numeracy-data-and-it-you-is-s\/","title":{"rendered":"COM3006 NFC \/ D Introduction to Numeracy, Data &#038; IT Assignment 2026 Arden College Evaluate Temporary As fragment of the formal assessment for the module Introduction to Numeracy, Data and IT, you is susceptible to be required t"},"content":{"rendered":"<h1 id=\"com3006-nfc-d-introduction-to-numeracy-data-it-assignment-2026-arden-university\">COM3006 NFC \/ D Introduction to Numeracy, Data &#038; IT Assignment 2026 Arden College<\/h1>\n<h2 id=\"assessment-brief\">Evaluate Temporary<\/h2>\n<p>As fragment of the formal assessment for the module Introduction to Numeracy, Data and IT, you is susceptible to be required to put up the assessment that&#8217;s described on this assessment short.<\/p>\n<h2 id=\"learning-outcomes\">Learning Outcomes: <\/h2>\n<p>After winding up the module, strive so as to: <\/p>\n<p>LO1: Use frequent numerical operations with entire numbers, integers, fractions, and decimals.  <\/p>\n<p>LO2: Calculate ratios and proportions, percentages, averages.  <\/p>\n<p>LO3: Originate and exercise appropriate graphical tactics to present straightforward details.  <\/p>\n<p>LO4: Originate and exercise a spreadsheet application to listing numerical details and exercise straightforward system capabilities. <\/p>\n<p>All studying outcomes could maybe well just light be met to bound the module. <\/p>\n<h3 id=\"guidance\">Guidance <\/h3>\n<p>Your assignment could maybe well just light consist of: a title page containing your student quantity, the module title, the submission closing date and the actual notice depend of your submitted doc; the appendices if linked; and a reference list in (scrutinize referencing fragment for extra details). It&#8217;s essential maybe well just light tackle the full parts of the assignment assignment listed below. Please hiss that tutors will exercise the assessment criteria assign out below in assessing your work.  <\/p>\n<p>You&#8217;ve got gotten to no longer consist of your title to your submission because Arden College operates anonymous marking, which ability that that markers could maybe well just light no longer be responsive to the identity of the scholar. Alternatively, please attain no longer put out of your mind to consist of your STU quantity. <\/p>\n<p><strong>Maximum notice depend: 2000 phrases <\/strong><\/p>\n<p>Please consult with the total notice depend policy that can maybe well just be hiss in the Student Policies fragment right here: Arden College | Regulatory Framework <\/p>\n<p>The notice depend involves every part in basically the primary body of the assessment (alongside side in text citations and references). The notice depend excludes numerical details in tables, figures, diagrams, footnotes, reference list and appendices. All assorted printed phrases ARE integrated in the notice depend. <\/p>\n<p>Students who exceed the wordcount as much as a 10% margin is maybe no longer penalised. Students could maybe well just light hiss that no marks will seemingly be assigned to work exceeding the specified restrict as soon as basically the most assessment dimension restrict has been reached. <\/p>\n<h3 id=\"section-1\">Section 1 <\/h3>\n<p><strong>The table below reveals the value of rail tickets from London to assorted destinations  <\/strong><\/p>\n<p> <!--kg-card-begin: html--> <\/p>\n<table border=\"1\" style=\"box-sizing: border-box; caption-side: bottom; border-collapse: collapse; margin: 1rem 0px; border-width: 1.5px; border-color: rgb(0, 0, 0); width: 692.494px; height: 199.922px;\">\n<thead style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 59.1094px;\">\n<th style=\"box-sizing: border-box; text-align: -webkit-match-parent; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.9125px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Destination<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: -webkit-match-parent; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 164.181px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Return Label (1 Adult)<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: -webkit-match-parent; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 160.725px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Return Label (1 Child)<\/strong><\/span><\/th>\n<th style=\"box-sizing: border-box; text-align: -webkit-match-parent; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 270.475px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Neighborhood Discount Promotion (4 Adults)<\/strong><\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.9125px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Edinburgh<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 164.181px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">\u00a3290<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 160.725px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">\u00a3100<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 270.475px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">25% Off All Tickets<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.9125px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Manchester<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 164.181px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">\u00a3190<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 160.725px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">\u00a360<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 270.475px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">30% Off All Tickets<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.9125px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Leeds<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 164.181px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">\u00a3150<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 160.725px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">\u00a3forty five<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 270.475px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">10% Off All Tickets<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 30.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.9125px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Birmingham<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 164.181px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">\u00a360<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 160.725px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">\u00a312.50<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 270.475px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">15% Off All Tickets<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <!--kg-card-end: html--> <\/p>\n<p>Primarily essentially essentially based on the strategies in the table, answer the next questions (a \u2013 f) and manufacture decided that that to hiss your work to get grasp of full marks for every ask. <\/p>\n<p>a) If a particular person supplied 3 single adult tickets and 2 single runt one tickets to Edinburgh, calculate the full cost for these tickets. <strong> [2 marks]<\/strong><\/p>\n<p>b) The utilization of your answer from fragment a), calculate the full cost of the tickets, if 1 adult and 1 runt one could maybe well no longer bound back and forth and their tickets are refunded? <strong>[2 marks]<\/strong> <\/p>\n<p>c) There are extra than one railcard alternatives in the market to rail possibilities. The Household and Company Railcard offers 1\/3 off adult tickets and 60% off runt one tickets. If a household of two adults and one runt one were to make exercise of this railcard to bound back and forth to Manchester.  <\/p>\n<p>i) How powerful would the 2 adult tickets cost alongside with the railcard decrease designate? <\/p>\n<p>ii) How powerful would the runt one sign cost with the railcard decrease designate? <\/p>\n<p>iii) What would the full cost of the gallop be for this household the utilization of the railcard. <\/p>\n<p>iv) How powerful has the household saved on this gallop by the utilization of their railcard. <strong>[7 marks] <\/strong><\/p>\n<p>d) A community of 4 adults wish to head on a outing. They will avail of the community decrease designate promotion as seen in the table above. They resolve to bound back and forth to both Manchester or Leeds. Which vacation design could maybe well just light they resolve to get grasp of basically the most inexpensive deal? <strong>[5 marks] <\/strong><\/p>\n<p>e) On account of an manufacture bigger in charges for the railway company, the present designate for an indication to Birmingham is 5% extra than it was last year. What was the value of a return adult sign to Birmingham last year earlier than the manufacture bigger? (Spherical your answer to 2 decimal areas) <strong> [4 marks] <\/strong><\/p>\n<p>f) Rail National maintain made the selection to proceed to manufacture bigger their sign prices by 5% every year for the next three years. What&#8217;s going to the value of a return adult sign to Edinburgh cost in 3 years. (Spherical your answer to 2 decimal areas) <strong> [5 marks]<\/p>\n<p>[Total Marks for Question 1 = 25] <\/strong><\/p>\n<h3 id=\"section-2\"><strong>Section 2 <\/strong><\/h3>\n<p><strong>Beneath is a table evaluating the quite loads of SIM-easiest deals supplied by 10 cell networks. <\/strong><\/p>\n<p> <!--kg-card-begin: html--> <\/p>\n<table border=\"1\" style=\"box-sizing: border-box; caption-side: bottom; border-collapse: collapse; margin: 1rem 0px; width: 691.763px; height: 428px; border-width: 1.5px; border-color: rgb(0, 0, 0);\">\n<thead style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 59.1094px;\">\n<th style=\"box-sizing: border-box; text-align: -webkit-match-parent; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Network Name<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: -webkit-match-parent; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Texts<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: -webkit-match-parent; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Minutes<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: -webkit-match-parent; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Data (GB of 5G)<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: -webkit-match-parent; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Contract (Months)<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: -webkit-match-parent; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Month-to-month Mark (\u00a3)<\/strong><\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Suave Network<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">1000<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">360<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">70<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">1<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">10<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">CO2<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">500<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">180<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">30<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">12<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">5<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Chat Mobile<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">750<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">240<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">70<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">12<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">8<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">To hand Mobile<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">1000<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">720<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">140<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">1<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">10<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Rebala<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">500<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Unlimited<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">30<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">12<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">5<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Dovefone<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">850<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">600<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">60<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">6<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">8<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Four Network<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">900<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">480<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">25<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">6<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">5.ninety nine<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">ESCOT<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">250<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">240<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">750<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">12<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">12<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Costnet<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">900<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">480<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">50<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">12<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">8<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 124.594px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">S-Mobile<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 59.4188px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">950<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 85.3px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Unlimited<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 130.35px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">10<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.394px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">12<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 138.506px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">10<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <!--kg-card-end: html--> <\/p>\n<p>Primarily essentially essentially based on the strategies in the table, answer the next questions (a \u2013 d) and manufacture decided that that to hiss your work to get grasp of full marks for every ask.<\/p>\n<p>a) \u00a0By the utilization of appropriate cell formatting tactics outlined on this module, reproduce the above spreadsheet in Excel. Seize a clear screenshot and insert it into your portfolio as your answer to this ask. Be particular that you consist of row and column identifiers to your screenshot, so it is decided that you&#8217;ve got got got extinct Excel to breed the table. <strong> [10 marks] <\/strong><\/p>\n<p>b) \u00a0Use Excel or otherwise to ranking the mean average month-to-month cost of a SIM-easiest contract. Please round your answer to the nearest integer. <strong>[3 marks] <\/strong><\/p>\n<p>c) \u00a0 i) \u00a0Use Excel to ranking the median quantity of Gigabytes (GB) of details on provide by the ten cell networks. Please consist of the system you exercise for full marks. <\/p>\n<p>ii) \u00a0Use Excel to ranking the mean average of Gigabytes (GB) \u00a0of details on provide by the ten cell networks. Please consist of the system you exercise for full marks. <\/p>\n<p>iii) \u00a0Primarily essentially essentially based on your two solutions in fragment i) and ii), which answer would give a higher indication of the frequent quantity of Gigabytes (GB) of details on provide by the ten cell networks.  <\/p>\n<p>iv) \u00a0Give a cause for your answer to fragment iii). <strong>[8 marks]<\/strong><\/p>\n<p>d) \u00a0Whenever you happen to were to resolve between ESCOT and Rebala, which one would you in my understanding resolve? You&#8217;ve got gotten to provide a cause for your answer. <strong>[1 marks]<\/strong><\/p>\n<p><strong>[Total Marks for Question 2 = 22]<\/strong><\/p>\n<h3 id=\"section-3\">Section 3<\/h3>\n<p>Beneath is a table that represents the strategies gathered by students at some level of their research to explore the causes of shoplifting in England and Wales between 2013 and 2023. They gathered details on the total quantity of shoplifting offences recorded every year and likewise displayed basically the primary categories of objects that were stolen.  <\/p>\n<p> <!--kg-card-begin: html--> <\/p>\n<table border=\"1\" style=\"box-sizing: border-box; caption-side: bottom; border-collapse: collapse; margin: 1rem 0px; width: 664.819px; height: 420.141px; border-width: 1.5px; border-color: rgb(0, 0, 0);\">\n<thead style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 59.1094px;\">\n<th style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Year<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Groceries<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Homeware<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Electrical<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">Other<\/strong><\/span><\/th>\n<th align=\"right\" style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\"><strong style=\"box-sizing: border-box; font-weight: bolder;\">No. of Recorded Offences<\/strong><\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2013\/14<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">208,964<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Forty eight,222<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">19,289<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">forty five,008<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">321,483<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2014\/15<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">201,920<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">42,338<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">16,284<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">65,136<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">325,678<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2015\/16<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">199,672<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">39,934<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">13,311<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Seventy nine,869<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">332,786<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2016\/17<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">244,987<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">54,848<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">21,939<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">43,878<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">365,652<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2017\/18<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">246,464<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">58,682<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">27,385<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">58,682<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">391,213<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2018\/19<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">227,389<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">fifty three,057<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">22,739<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">75,797<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">378,982<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2019\/20<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">250,846<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">43,002<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">21,501<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">43,002<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">358,351<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2020\/21<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">161,077<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">35,304<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">14,342<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">9,930<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">220,653<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2021\/22<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">210,011<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">42,002<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">22,401<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">5,600<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">280,014<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 30.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 95.425px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2022\/23<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.2375px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">290,959<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 109.238px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">75,902<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 93.9875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">33,734<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 92.5125px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">21,084<\/span><\/td>\n<td align=\"right\" style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 179.219px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">421,679<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <!--kg-card-end: html--> <\/p>\n<p><strong>Use the strategies in the table above to answer to the next questions below. <\/strong><\/p>\n<p>a) \u00a0What percentage of recorded offences of shoplifting were groceries in 2022\/23? (Spherical your answer to 1 decimal reputation) [3 marks] <\/p>\n<p>b) \u00a0Give two causes why you imagine groceries maintain a elevated percentage than any assorted category of objects shoplifted. [2 Marks]  <\/p>\n<p>c) \u00a0Reply the next two parts:<br \/>i) \u00a0What&#8217;s the ratio of the amount of homeware objects shoplifted to electrical objects in 2019\/20? Give your answer in it\u2019s most easiest manufacture. <\/p>\n<p>ii) \u00a0 The utilization of your answer from fragment i), hiss in phrases what this ratio ability. [4 marks]  <\/p>\n<p>d) \u00a0Use Excel to ranking the full quantity of recorded offences between 2013\/14 and 2022\/23. To manufacture decided that that full marks, write the system you extinct in Excel as fragment of your answer. [3 marks] <\/p>\n<p>e) \u00a0Use Excel to ranking the minimum quantity of recorded offences between 2013\/14 and 2022\/23. To manufacture decided that that full marks, write the system you extinct in Excel as fragment of your answer. [3 marks] <\/p>\n<p>f) \u00a0Write the conditional formulae that you would exercise in Excel to depend how a few years the full quantity of recorded offences were better than 340,000.  [3 marks]  <\/p>\n<p>g) \u00a0Use Excel to construct an awfully labelled line graph to hiss the full quantity of recorded offences in every year from 2013\/14 to 2022\/23. Seize a screenshot of your chart or graph and insert it into your portfolio. [6 marks] <\/p>\n<p>h) \u00a0Primarily essentially essentially based on your graph from fragment g), grunt on the total pattern of shoplifting between 2013\/14 and 2022\/23. (Tag: To your answer, grunt on why you imagine there were peaks and dips in the graph) [4 marks] [Total Marks for Question 3 = 28]<\/p>\n<h3 id=\"section-4\">Section 4<\/h3>\n<p> You are the manager on the Mini-Zoo Pet Retailer in Berlin. You&#8217;ve got gotten labored there for ten years and collated the strategies into the table below, displaying the full profits from sales of objects every year and the full you&#8217;ve got spent on promoting.<\/p>\n<p> <!--kg-card-begin: html--> <\/p>\n<table border=\"1\" style=\"box-sizing: border-box; caption-side: bottom; border-collapse: collapse; margin: 1rem 0px; border-width: 1.5px; border-color: rgb(0, 0, 0); width: 497.344px; height: 449.547px;\">\n<thead style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 59.1094px;\">\n<th style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year<\/span><\/th>\n<th style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Income from Gross sales (\u20ac)<\/span><\/th>\n<th style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Mark of Promoting (\u20ac)<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year 1<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">21,450<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2,350<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year 2<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">47,000<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2,703<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year 3<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">71,000<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">15,000<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year 4<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">81,650<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">12,000<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year 5<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">106,145<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">15,465<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year 6<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">134,804<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">25,382<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year 7<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">180,638<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">33,698<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year 8<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">213,569<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">54,320<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year 9<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">298,713<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">62,561<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 60.1094px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 175.575px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Year 10<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 152.306px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">323,517<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 168.262px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">81,396<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <!--kg-card-end: html--> <\/p>\n<p>a) \u00a0 i) \u00a0What manufacture of graph is upright to hiss the correlation between sales and promoting? <\/p>\n<p>ii) \u00a0Originate a linked graph to hiss the correlation between the profits from sales and the value of promoting. Seize a screenshot of your chart or graph and insert it into your portfolio.  <\/p>\n<p>iii) \u00a0From this graph, what manufacture of correlation is present between the profits from sales and the value of promoting.  <\/p>\n<p>iv) \u00a0Indicate what this correlation ability in phrases.<\/p>\n<p>v) \u00a0As manager of the shop, what could maybe well maybe you take into epic doing to manufacture bigger the sales even further next year? [10 marks]<\/p>\n<p>b) \u00a0As manager of Mini-Zoo, you launched customised items. Prospects can maintain the names of their pets embossed on products you promote. The minimum designate for personalising a gift is \u20ac2 for 3 letters. Each and every letter extinct after this charges \u20ac0.50. The table below reveals the value of personalising products and how many maintain been sold.<\/p>\n<p> <!--kg-card-begin: html--> <\/p>\n<table border=\"1\" style=\"box-sizing: border-box; caption-side: bottom; border-collapse: collapse; margin: 1rem 0px; width: 538.119px; border-width: 1.5px; border-color: rgb(0, 0, 0);\">\n<thead style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<th style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Pet Name<\/span><\/th>\n<th style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">No. of letters<\/span><\/th>\n<th style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Mark (\u20ac)<\/span><\/th>\n<th style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">No. of Gross sales<\/span><\/th>\n<th style=\"box-sizing: border-box; text-align: center; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Income from Gross sales (\u20ac)<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Jake<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">4<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2.50<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">102<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">255.00<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Brodie<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">6<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">3.50<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">38<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">133.00<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Ringo<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">5<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">3.00<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">63<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">189.00<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Coco<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">4<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2.50<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">71<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">177.50<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Jude<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">4<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2.50<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">81<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">202.50<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Fluffy<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">6<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">3.50<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">40<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">140.00<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Twitch<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">6<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">3.50<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">35<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">122.50<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Trumpet<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">7<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">4.00<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">85<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">340.00<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Jerry<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">5<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">3.00<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">40<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">120.00<\/span><\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 102.719px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">Tom<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 88.875px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">3<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 120.244px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">2.00<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.15px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">20<\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px; width: 112.931px; text-align: center;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">40.00<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <!--kg-card-end: html--> <\/p>\n<p>Use the strategies in the table above to answer to the next questions below.<\/p>\n<p>i) Originate a upright and entirely labelled pie chart to hiss the profits from sales of basically the most popular pet names extinct on personalized products sold by Mini-Zoo. [6 marks]  <\/p>\n<p>ii) Give a the reason why basically the most spirited sector of the pie chart doesn&#8217;t signify basically the most popular pet title. [1 marks] <\/p>\n<p>iii) Write the conditional formulae that you would exercise in Excel to add up the full quantity of sales pets whose names launch up with the letter J. [4 marks] <\/p>\n<p>iv) Write the conditional formulae that you would exercise in Excel to ranking the frequent profits from sales from those pets whose names maintain extra than 4 letters. [4 marks] <\/p>\n<h2 id=\"final-portfolio-submission\"><strong>Last portfolio submission <\/strong><\/h2>\n<p>Assessments submitted slack is maybe no longer authorized. <\/p>\n<p>Please put up your portfolio as a Word doc. You&#8217;ve got gotten to manufacture decided that that that the submitted assessment is all of your possess work and that each one sources extinct are appropriately attributed. Penalties apply to assessment s which hiss evidence of tutorial unfair practice. (Inspect the Student Handbook which is in the market on the A-Z key details on iLearn.)  <\/p>\n<h2 id=\"assessment-support\">Evaluate Give a enhance to <\/h2>\n<p>We strongly inspire you to engage with our assessment red meat up alternatives as you work by your assessment assignment(s): <\/p>\n<p>\u2022 \u00a0Book an tutorial with a Foundation Year lecturer<br \/>\u2022 Tutorial Skills Crew &#8211; book an appointment with a tutor right here<br \/>\u2022 Tutorial Skills Crew \u2013 book a workshop<br \/>\u2022 \u00a0Tutorial Skills Crew \u2013 be aware sources<br \/>\u2022 \u00a0For red meat up with English Language talk over with the English Language Hub <\/p>\n<h3 id=\"formative-feedback\">Formative Solutions  <\/h3>\n<p>You&#8217;ve got two opportunities to put up a partial draft of your work in week 6 &#038; 8 for strategies. Please talk over with the My Evaluate tab for steerage on what is expected in every draft. <\/p>\n<p>Put up a reproduction of your draft the utilization of the Turnitin formative draft hyperlink by the given closing dates in week 6 &#038; 8. It&#8217;s essential maybe well detect the closing date for your draft on iLearn. It&#8217;s essential maybe well put up your draft on iLearn below the \u2018My Evaluate\u2019 tab. <\/p>\n<p>Formative tasks provide the opportunity to overview your understanding of key concepts, and therefore enable you to prepare for the closing portfolio submission. <\/p>\n<p>Your lecturer will provide verbal\/written strategies to enable you to make stronger your assessment, earlier than submitting your closing portfolio in week 10. <\/p>\n<p>Submission checklist \u2013 exercise this to be particular you&#8217;ve got done all tasks <\/p>\n<p><strong>Enjoy you done: <\/strong><\/p>\n<p> <!--kg-card-begin: html--> <\/p>\n<table border=\"1\" style=\"box-sizing: border-box; caption-side: bottom; border-collapse: collapse; margin: 1rem 0px; width: 856.331px; height: 75.3594px; border-width: 1.5px; border-color: rgb(0, 0, 0);\">\n<colgroup style=\"box-sizing: border-box;\">\n<col style=\"box-sizing: border-box; width: 427.562px;\">\n<col style=\"box-sizing: border-box; width: 427.569px;\"><\/colgroup>\n<tbody style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px;\">\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 38.6562px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">SECTION 1: a, b, ci, cii, ciii, civ, d, e, f <\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px;\"> <\/td>\n<\/tr>\n<tr style=\"box-sizing: border-box; border-color: inherit; border-style: solid; border-width: 0px; height: 36.7031px;\">\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px;\"><span style=\"box-sizing: border-box; color: rgb(0, 0, 0);\">SECTION 2: a, b, ci, cii, ciii, civ, d <\/span><\/td>\n<td style=\"box-sizing: border-box; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1.5px;\"> <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <!--kg-card-end: html--> <\/p>\n<h3 id=\"referencing-guidance\">Referencing Guidance<\/h3>\n<p>You Must underpin your prognosis and review of the foremost considerations with appropriate and broad-ranging tutorial research and manufacture decided that that right here&#8217;s referenced the utilization of the AU Harvard machine. \u00a0Apply this hyperlink to ranking the referencing guides for your area: Arden Library  <\/p>\n<p><strong>The utilization of AI<\/strong><\/p>\n<p>An AI language mannequin treasure ChatGPT will also be extinct as a tool to enable you to produce writing abilities, conceptual objects and templates for your writing. To illustrate, ChatGPT will also be extinct effectively to:<br \/>&#8211; \u00a0Invent research questions<br \/>&#8211; \u00a0Originate an outline for an assessment<br \/>&#8211; \u00a0Originate examples\/steerage for assorted writing kinds and kinds<br \/>&#8211; \u00a0Demand linked sources (though it is foremost to verify that the provision just is not any longer falsified by finding and the utilization of the authentic supply)<br \/>&#8211; \u00a0Brainstorm tips<br \/>&#8211; \u00a0Translate text into English<\/p>\n<p>Alternatively, it&#8217;s not any longer counseled to make exercise of AI-generated texts and so they could maybe maybe well just light no longer be extinct to adjust your possess serious prognosis and students could maybe well just light somewhat overview details obtained from ChatGPT (and assorted AI software program,) with assorted credible sources.<\/p>\n<p>Students could maybe well just light also seek the advice of with their lecturer or division about particular requirements of the utilization of AI-generated instruct and how an acknowledgement grunt of AI assistance could maybe well just light be presented to your assessment.<\/p>\n<p>Please consult with the referencing guides for steerage on easy methods to reference any exercise of man-made intelligence in the writing of your assessments. \u00a0It&#8217;s essential maybe well get grasp of entry to the referencing guides right here: \u00a0Arden Library<\/p>\n<p>The assessment criteria for your Foundation Year modules apply the Pass\/Fail criteria for the next Module assignments: <\/p>\n<ul>\n<li>Introducing Research Skills<\/li>\n<li>Tutorial Skills Word<\/li>\n<li>Ethics, Working Collaboratively and Values  <\/li>\n<li>Introduction to Numeracy, Data, and IT<\/li>\n<\/ul>\n<p>The next generic assessment criteria is extinct to designate students\u2019 work on a Pass\/Fail basis. Enlighten steerage on easy methods to meet these criteria will seemingly be contextualised to particular modules by providing the marking scheme<\/p>\n","protected":false},"excerpt":{"rendered":"<p>COM3006 NFC \/ D Introduction to Numeracy, Data &#038; IT Assignment 2026 Arden College Evaluate Temporary As fragment of the formal assessment for the module Introduction to Numeracy, Data and IT, you is susceptible to be required to put up the assessment that&#8217;s described on this assessment short. Learning Outcomes: After winding up the module, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-32992","post","type-post","status-publish","format-standard","hentry","category-solutions"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/32992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/comments?post=32992"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/32992\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/media?parent=32992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/categories?post=32992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/tags?post=32992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}