{"id":33015,"date":"2026-07-31T14:59:38","date_gmt":"2026-07-31T14:59:38","guid":{"rendered":"https:\/\/academicwritersbay.com\/solutions\/as-part-of-the-formal-overview-for-the-module-introduction-to-numeracy-data-and-it-you-are-required-to-put-up-the-overview-that-is-described-on-this-overview-brief-discovering-out-outcomes\/"},"modified":"2026-07-31T14:59:38","modified_gmt":"2026-07-31T14:59:38","slug":"as-part-of-the-formal-overview-for-the-module-introduction-to-numeracy-data-and-it-you-are-required-to-put-up-the-overview-that-is-described-on-this-overview-brief-discovering-out-outcomes","status":"publish","type":"post","link":"https:\/\/academicwritersbay.com\/solutions\/as-part-of-the-formal-overview-for-the-module-introduction-to-numeracy-data-and-it-you-are-required-to-put-up-the-overview-that-is-described-on-this-overview-brief-discovering-out-outcomes\/","title":{"rendered":"As part of the formal overview for the module Introduction to Numeracy, Data and IT, you are required to put up the overview that is described on this overview brief. Discovering out Outcomes:"},"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 Transient<\/h2>\n<p>As part of the formal overview for the module Introduction to Numeracy, Data and IT, you are required to put up the overview that is described on this overview brief.<\/p>\n<h2 id=\"learning-outcomes\">Discovering out Outcomes: <\/h2>\n<p>After winding up the module, you would possibly be in a arrangement to: <\/p>\n<p>LO1: Use total numerical operations with complete numbers, integers, fractions, and decimals.  <\/p>\n<p>LO2: Calculate ratios and proportions, percentages, averages.  <\/p>\n<p>LO3: Atomize and use appropriate graphical tactics to fresh easy data.  <\/p>\n<p>LO4: Atomize and use a spreadsheet utility to anecdote numerical data and use easy formulation features. <\/p>\n<p>All finding out outcomes must be met to cross the module. <\/p>\n<h3 id=\"guidance\">Guidance <\/h3>\n<p>Your assignment must embody: a title page containing your pupil number, the module name, the submission deadline and the actual be aware rely of your submitted doc; the appendices if associated; and a reference list in (gaze referencing section for extra data). It&#8217;s good to contend with the total parts of the assignment task listed below. Please ticket that tutors will use the overview requirements space out below in assessing your work.  <\/p>\n<p>You can need to no longer embody your name in your submission due to the Arden College operates nameless marking, meaning that markers need to no longer ever be responsive to the identity of the pupil. Then but all but again, please carry out no longer omit to embody your STU number. <\/p>\n<p><strong>Most be aware rely: 2000 phrases <\/strong><\/p>\n<p>Please consult with the elephantine be aware rely protection which will most certainly be found in the Pupil Insurance policies section right here: Arden College | Regulatory Framework <\/p>\n<p>The be aware rely involves every thing in the main body of the overview (including in textual advise material citations and references). The be aware rely excludes numerical data in tables, figures, diagrams, footnotes, reference list and appendices. All other printed phrases ARE incorporated in the be aware rely. <\/p>\n<p>College students who exceed the wordcount as much as a 10% margin is doubtlessly no longer penalised. College students must ticket that no marks will be assigned to work exceeding the specified limit as soon as the utmost overview dimension limit has been reached. <\/p>\n<h3 id=\"section-1\">Part 1 <\/h3>\n<p><strong>The table below reveals the fee of rail tickets from London to diversified 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 Trace (1 Grownup)<\/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 Trace (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 Nick ticket 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);\">\u00a345<\/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>In step with the working out in the table, acknowledge the following questions (a \u2013 f) and carry out sure to display your work to accumulate elephantine marks for every ask. <\/p>\n<p>a) If an individual sold 3 single adult tickets and 2 single child tickets to Edinburgh, calculate the complete ticket for these tickets. <strong> [2 marks]<\/strong><\/p>\n<p>b) The use of your acknowledge from part a), calculate the complete ticket of the tickets, if 1 adult and 1 child also can no longer shuttle and their tickets are refunded? <strong>[2 marks]<\/strong> <\/p>\n<p>c) There are extra than one railcard ideas obtainable to rail potentialities. The Family and Company Railcard presents 1\/3 off adult tickets and 60% off child tickets. If a family of two adults and one child were to make use of this railcard to shuttle to Manchester.  <\/p>\n<p>i) How grand would the 2 adult tickets ticket on the side of the railcard decrease ticket? <\/p>\n<p>ii) How grand would the newborn ticket ticket with the railcard decrease ticket? <\/p>\n<p>iii) What would the complete ticket of the stir be for this family the utilization of the railcard. <\/p>\n<p>iv) How grand has the family saved on this stir by the utilization of their railcard. <strong>[7 marks] <\/strong><\/p>\n<p>d) A neighborhood of 4 adults want to fling on a outing. They are able to avail of the neighborhood decrease ticket promotion as viewed in the table above. They think to shuttle to either Manchester or Leeds. Which destination must they resolve to accumulate the cheapest deal? <strong>[5 marks] <\/strong><\/p>\n<p>e) Attributable to an carry out bigger in prices for the railway firm, the unique ticket for a ticket to Birmingham is 5% bigger than it used to be final twelve months. What used to be the fee of a return adult ticket to Birmingham final twelve months earlier than the carry out bigger? (Round your acknowledge to two decimal locations) <strong> [4 marks] <\/strong><\/p>\n<p>f) Rail National be pleased made the choice to continue to carry out bigger their ticket prices by 5% each twelve months for the subsequent three years. What will the cost of a return adult ticket to Edinburgh ticket in 3 years. (Round your acknowledge to 2 decimal locations) <strong> [5 marks]<\/p>\n<p>[Total Marks for Question 1 = 25] <\/strong><\/p>\n<h3 id=\"section-2\"><strong>Part 2 <\/strong><\/h3>\n<p><strong>Under is a table comparing the diversified SIM-easiest deals equipped by 10 cellular 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 Title<\/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;\">Monthly Cost (\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);\">Artful 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 Cellular<\/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 Cellular<\/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);\">Limitless<\/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-Cellular<\/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);\">Limitless<\/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>In step with the working out in the table, acknowledge the following questions (a \u2013 d) and carry out sure to display your work to accumulate elephantine 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. Take a distinct screenshot and insert it into your portfolio as your acknowledge to this ask. Plot distinct you embody row and column identifiers in your screenshot, so it&#8217;s evident that it&#8217;s seemingly you will have frail Excel to reproduce the table. <strong> [10 marks] <\/strong><\/p>\n<p>b) \u00a0Use Excel or in some other case to search out the mean moderate monthly ticket of a SIM-easiest contract. Please round your acknowledge to the closest integer. <strong>[3 marks] <\/strong><\/p>\n<p>c) \u00a0 i) \u00a0Use Excel to search out the median collection of Gigabytes (GB) of data on offer by the ten cellular networks. Please embody the formulation you exhaust for elephantine marks. <\/p>\n<p>ii) \u00a0Use Excel to search out the mean moderate of Gigabytes (GB) \u00a0of data on offer by the ten cellular networks. Please embody the formulation you exhaust for elephantine marks. <\/p>\n<p>iii) \u00a0In step with your two solutions partly i) and ii), which acknowledge would give an even bigger indication of the moderate collection of Gigabytes (GB) of data on offer by the ten cellular networks.  <\/p>\n<p>iv) \u00a0Give a motive in your acknowledge to part iii). <strong>[8 marks]<\/strong><\/p>\n<p>d) \u00a0While you happen to were to carry out a quite quite loads of from ESCOT and Rebala, which one would you in my notion resolve? You can need to give a motive in your acknowledge. <strong>[1 marks]<\/strong><\/p>\n<p><strong>[Total Marks for Question 2 = 22]<\/strong><\/p>\n<h3 id=\"section-3\">Part 3<\/h3>\n<p>Under is a table that represents the tips gathered by college students all over their research to explore the causes of shoplifting in England and Wales between 2013 and 2023. They gathered data on the total collection of shoplifting offences recorded each twelve months and besides displayed the main classes of things 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;\">Yr<\/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;\">Diversified<\/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);\">45,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 working out in the table above to acknowledge the following questions below. <\/strong><\/p>\n<p>a) \u00a0What share of recorded offences of shoplifting were groceries in 2022\/23? (Round your acknowledge to 1 decimal enviornment) [3 marks] <\/p>\n<p>b) \u00a0Give two the reasons why you focus on groceries be pleased the next share than some other category of things shoplifted. [2 Marks]  <\/p>\n<p>c) \u00a0Resolution the following two parts:<br \/>i) \u00a0What is the ratio of the collection of homeware items shoplifted to electrical items in 2019\/20? Give your acknowledge in it\u2019s most easiest produce. <\/p>\n<p>ii) \u00a0 The use of your acknowledge from part i), sing in phrases what this ratio design. [4 marks]  <\/p>\n<p>d) \u00a0Use Excel to search out the complete collection of recorded offences between 2013\/14 and 2022\/23. To carry out sure elephantine marks, write the formulation you frail in Excel as part of your acknowledge. [3 marks] <\/p>\n<p>e) \u00a0Use Excel to search out the minimum collection of recorded offences between 2013\/14 and 2022\/23. To carry out sure elephantine marks, write the formulation you frail in Excel as part of your acknowledge. [3 marks] <\/p>\n<p>f) \u00a0Write the conditional formulae that you would use in Excel to rely how a long time the complete collection of recorded offences were bigger than 340,000.  [3 marks]  <\/p>\n<p>g) \u00a0Use Excel to manufacture a absolutely labelled line graph to display the complete collection of recorded offences in each twelve months from 2013\/14 to 2022\/23. Take a screenshot of your chart or graph and insert it into your portfolio. [6 marks] <\/p>\n<p>h) \u00a0In step with your graph from part g), touch upon the total vogue of shoplifting between 2013\/14 and 2022\/23. (Label: For your acknowledge, touch upon why you deem there were peaks and dips in the graph) [4 marks] [Total Marks for Question 3 = 28]<\/p>\n<h3 id=\"section-4\">Part 4<\/h3>\n<p> You&#8217;re the supervisor on the Mini-Zoo Pet Retailer in Berlin. You be pleased labored there for ten years and collated the tips into the table below, exhibiting the complete earnings from sales of things each twelve months and the complete it&#8217;s seemingly you will have spent on advertising and marketing.<\/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);\">Yr<\/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);\">Profits from 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);\">Cost of Marketing (\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);\">Yr 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);\">Yr 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);\">Yr 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);\">Yr 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);\">Yr 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);\">Yr 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);\">Yr 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);\">Yr 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);\">Yr 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);\">Yr 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 produce of graph is ethical to display the correlation between sales and advertising and marketing? <\/p>\n<p>ii) \u00a0Assemble a associated graph to display the correlation between the earnings from sales and the cost of advertising and marketing. Take a screenshot of your chart or graph and insert it into your portfolio.  <\/p>\n<p>iii) \u00a0From this graph, what produce of correlation is fresh between the earnings from sales and the cost of advertising and marketing.  <\/p>\n<p>iv) \u00a0Expose what this correlation design in phrases.<\/p>\n<p>v) \u00a0As supervisor of the retailer, what would perhaps you take into anecdote doing to carry out bigger the sales even additional next twelve months? [10 marks]<\/p>\n<p>b) \u00a0As supervisor of Mini-Zoo, you presented customised items. Potentialities will most certainly be pleased the names of their pets embossed on merchandise you sell. The minimum ticket for personalising a present is \u20ac2 for three letters. Every letter frail after this prices \u20ac0.50. The table below reveals the cost of personalising merchandise and how many had 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 Title<\/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);\">Cost (\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 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);\">Profits from 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 working out in the table above to acknowledge the following questions below.<\/p>\n<p>i) Assemble an ethical and absolutely labelled pie chart to display the earnings from sales of doubtlessly the most in vogue pet names frail on personalized merchandise sold by Mini-Zoo. [6 marks]  <\/p>\n<p>ii) Give a motive why the ideal sector of the pie chart doesn&#8217;t picture doubtlessly the most in vogue pet name. [1 marks] <\/p>\n<p>iii) Write the conditional formulae that you would use in Excel so as to add up the complete collection of sales pets whose names originate with the letter J. [4 marks] <\/p>\n<p>iv) Write the conditional formulae that you would use in Excel to search out the moderate earnings from sales from these pets whose names be pleased bigger than 4 letters. [4 marks] <\/p>\n<h2 id=\"final-portfolio-submission\"><strong>Closing portfolio submission <\/strong><\/h2>\n<p>Assessments submitted dull is doubtlessly no longer authorized. <\/p>\n<p>Please put up your portfolio as a Observe doc. You can need to carry out sure that the submitted overview is all of your non-public work and that each one sources frail are precisely attributed. Penalties apply to overview s which display proof of tutorial unfair apply. (Gaze the Pupil Instruction manual which is accessible on the A-Z key data on iLearn.)  <\/p>\n<h2 id=\"assessment-support\">Evaluate Reinforce <\/h2>\n<p>We strongly back you to be pleased interaction with our overview give a boost to ideas as you work by your overview task(s): <\/p>\n<p>\u2022 \u00a0Book an tutorial with a Foundation Yr lecturer<br \/>\u2022 Academic Abilities Team &#8211; book an appointment with a tutor right here<br \/>\u2022 Academic Abilities Team \u2013 book a workshop<br \/>\u2022 \u00a0Academic Abilities Team \u2013 take into anecdote assets<br \/>\u2022 \u00a0For give a boost to with English Language consult with the English Language Hub <\/p>\n<h3 id=\"formative-feedback\">Formative Feedback  <\/h3>\n<p>You would possibly perchance additionally be pleased two opportunities to put up a partial draft of your work in week 6 &#038; 8 for solutions. Please consult with the My Evaluate tab for guidance on what is expected in each draft. <\/p>\n<p>Put up a reproduction of your draft the utilization of the Turnitin formative draft hyperlink by the given deadlines in week 6 &#038; 8. You would possibly perchance additionally gain the deadline in your draft on iLearn. You would possibly perchance additionally put up your draft on iLearn below the \u2018My Evaluate\u2019 tab. <\/p>\n<p>Formative initiatives give you the assorted to test your working out of key ideas, and therefore allow you put together for the final portfolio submission. <\/p>\n<p>Your lecturer will provide verbal\/written solutions to allow you back your overview, earlier than submitting your final portfolio in week 10. <\/p>\n<p>Submission checklist \u2013 use this to carry out sure it&#8217;s seemingly you will have finished all initiatives <\/p>\n<p><strong>Like you finished: <\/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 evaluation of the main considerations with appropriate and big-ranging tutorial research and carry out sure this is referenced the utilization of the AU Harvard design. \u00a0Explain this hyperlink to search out the referencing guides in your topic: Arden Library  <\/p>\n<p><strong>The use of AI<\/strong><\/p>\n<p>An AI language mannequin fancy ChatGPT will most certainly be frail as a instrument to allow you carry out writing abilities, conceptual models and templates in your writing. Shall we embrace, ChatGPT will most certainly be frail effectively to:<br \/>&#8211; \u00a0Develop research questions<br \/>&#8211; \u00a0Assemble a top level notion for an outline<br \/>&#8211; \u00a0Assemble examples\/guidance for diversified writing styles and forms<br \/>&#8211; \u00a0Be taught about associated sources (though it&#8217;s important to verify that the source is no longer falsified by finding and the utilization of the long-established source)<br \/>&#8211; \u00a0Brainstorm tips<br \/>&#8211; \u00a0Translate textual advise material into English<\/p>\n<p>Then but all but again, it&#8217;s miles no longer beneficial to make use of AI-generated texts and they need to no longer ever be frail to interchange your non-public serious prognosis and college students must in moderation test data obtained from ChatGPT (and other AI tool,) with other credible sources.<\/p>\n<p>College students must also focus on with their lecturer or division about specific requirements of the utilization of AI-generated advise material and how an acknowledgement commentary of AI assistance must be presented in your overview.<\/p>\n<p>Please consult with the referencing guides for guidance on how to reference any use of synthetic intelligence in the writing of your assessments. \u00a0You would possibly perchance additionally entry the referencing guides right here: \u00a0Arden Library<\/p>\n<p>The overview requirements in your Foundation Yr modules follow the Paddle\/Fail requirements for the following Module assignments: <\/p>\n<ul>\n<li>Introducing Research Abilities<\/li>\n<li>Academic Abilities Explain<\/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 overview requirements is frail to stamp college students\u2019 work on a Paddle\/Fail basis. Particular guidance on how to meet these requirements will be contextualised to specific modules by providing the marking way<\/p>\n","protected":false},"excerpt":{"rendered":"<p>COM3006 NFC \/ D Introduction to Numeracy, Data &#038; IT Assignment 2026 Arden College Evaluate Transient As part of the formal overview for the module Introduction to Numeracy, Data and IT, you are required to put up the overview that is described on this overview brief. Discovering out Outcomes: After winding up the module, you [&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-33015","post","type-post","status-publish","format-standard","hentry","category-solutions"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/33015","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=33015"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/33015\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/media?parent=33015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/categories?post=33015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/tags?post=33015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}