• Type Assignment
• Downloads768
• Pages14

Introduction - COM3006NFC: Assessement Of An Introduction To Numeracy, Data & It Assignment Sample

Achieve your academic dreams with expert Assignment Help that guarantees top grades and timely delivery.

Section 1

Part A: Calculate the Total Cost for Tickets for 3 Return Adult Tickets and 2 Return Child Tickets

A person purchased 2 return child tickets and 3 return tickets.

Since the cost of return adult tickets to ‘Edinburg’ is £ 290.00 and the cost of return child tickets to ‘Edinburg’ is £ 100.00 the total price becomes = £ 290.00*3+2*£ 100.00 =£ 1070.00

So, the total cost for these two tickets is £ 1070.00.

Part B: Calculate the Total Cost of the Tickets If 1 Adult and 1 Child Could Not Travel and Their Tickets Are Refunded

Since the total cost of the three tickets is £ 1070.00 and here one adult and one child could not travel and their tickets are refunded then the calculation becomes= £1070.00-(£ 290.00+£ 100.00) =£ 680.00

So the answer is £ 680.00 and the ticket amounts are refunded.

Part C: Options Available To Rail Customers

Here the ‘Family and Friends Ticket’ offers 60% off child tickets and 1/3 off adult tickets. A family of one child and two adults were to operate this ‘ticket’ on a return journey to ‘Manchester’. From the delivered table it can be stated that the cost of returning adult tickets to ‘Manchester’ is £ 190.00 and the cost of returning child tickets to ‘Manchester’ is £ 60.00.

I. Two Adult Tickets Cost Together With the Ticket Discount

Two adult tickets cost £ 190.00*2 = £ 380.00

Now together with the ticket discount the cost of the two adult tickets becomes £ 380.00*? = £ 253.34 (approx.).

II. Child Ticket Cost with the Ticket Discount

Generally, the cost of the child ticket is £ 60.00 but with the ticket discount, it becomes £ 60.00*40% =£ 24.00

 III. Total Cost of the Journey for This Family Using The Ticket

Normally in the fundamental ticket price, for this family, the total cost of the journey will be £ 380.00+£ 60.00 =£ 440.00.

But in this case, the family is using the ticket discount. So applying the discounts the total cost of the journey for the family becomes £ 253.34+£ 24.00 = £ 277.34 (approximately)

 IV. Family Saved On This Journey by Using Their Ticket

Without the ticket discount, the total cost is £ 440.00 and with the ticket discount the total cost of the family is £ 277.34, the family saved on this journey £ 440.00-£ 277.34 = £ 122.66 (approx.)

Part D: Destination Should They Choose To Get the Cheapest Deal

Here, in this case, a faction of 4 adults desire to go on a journey. They are willing to profit from the group discount advertising. They choose on a return trip to either ‘Leeds or Manchester’. They picked to determine to obtain the cheapest value.

So here it is essential to calculate the two types of costs for this group.

First, they will go to Manchester. In that case, the price of return adult tickets to Manchester is £ 190.00 and there are a total of four people. So, the total cost becomes £ 760.00.

Here group discount promotion is available for 4 adults 30% off all tickets. So applying this offer the cost of the ticket becomes £ 190.00-(£ 190.00*30%) =£ 133.00 so as a result the total cost becomes £ 532.00.

Now for the second part, assume that they will go to Leeds. Then In that case, the price of return adult tickets to Leeds is £ 150.00 and there are a total of four people. So, the total cost is £ 600.00.

Here group discount promotion is available for 4 adults 10% off all tickets. So applying this offer the cost of the ticket becomes £ 150.00-(£ 150.00*10%) =£ 135.00 so as a result the total cost becomes £ 540.00.

By observing this calculation it can be said that they should choose the trip to Manchester to get the cheapest deal.

Part E: Price of a Return Adult Ticket to Birmingham Last Year before the Increase

For the increment in costs of the railway company, the present cost of 'tickets to Birmingham' is 5% more than it was earlier year. Now, the cost of a return adult 'ticket to Birmingham' is £ 60.00. 

Thereafter, last year the price of a return adult 'ticket to Birmingham' was £ 60.00*100/105= £ 57.14 (approx.)

So, the cost of a return adult 'ticket to Birmingham' the previous year before the upsurge was £ 57.14 (approx.).

Part F: Cost of a Return Adult Ticket to Edinburgh Cost in 3 Years

Rail National has to resume raising their ticket costs by 5% per year for the next three years.

At present time the price of a return adult 'ticket to Edinburgh' is £ 290.00

Next year the cost will be £ 290.00+£ 290.00*5%=£ 304.50

After the next year, the cost will be £ 304.50+£ 304.50*5%= £ 319.73 (approx.)

And after two years from the present year, the cost will be £ 319.73 +£ 319.73*5% =£ 335.72(approx.)

So, here it can be said that if Rail National decided to restart to grow their ticket costs by 5% per year for the following three years, the price of a return adult 'ticket to Edinburgh' in 3 years would be £ 335.72 (approx.)

Section 2

Part A: Reproduce the Table in Excel Spreadsheet

Figure 1: Reproduce the Table

(Source: Self-created in Excel)

Part B: Mean Average Monthly Cost Of a Sim-only Contract

Figure 2: Calculate Mean Average Monthly Cost of A SIM-Only Contract

(Source: Self-created in Excel)

Part C: Statistical Analysis

I. Median Number of GB of Data on Offer by the Ten Mobile Networks

Figure 3: Calculate Median Number of GB of Data on Offer by the Ten Mobile Networks

(Source: Self-created in Excel)

II. Mean Average of GB of Data on Offer by the Ten Mobile Networks

Figure 4: Calculate Mean Average of GB of Data on Offer by the Ten Mobile Networks

(Source: Self-created in Excel)

 III. Better Indication of the Average Number of GB of Data on Offer by the Ten Mobile Networks

The answer in answer (i), which means using the ‘MEDIAN’ to discover the ‘median number’ of GB of data, would deliver an adequate indication of the ‘average number’ of GB of data on recommendation by the 10 mobile networks in this detailed context.

The median is a measurement of the major tendency that is slightly affected by excessive values or deviation in the data (Paul, et al. 2021). If there are periodic unusually low or high prices in the dataset, the median will be undersized and influenced by this deviation compared to the average mean.

 IV. Reason for Answer to (III)

The rationale for utilizing the median to sufficiently demonstrate the ‘average number’ of GB of data on request by the 10 mobile networks, as objected to the average mean, is due to the existence of possible outliers or severe values in the dataset.

Outliers and Extreme Values: The median is a strong benchmark of central movement that is not significantly influenced by outliers or excessive values (Little, et al. 2019). Outliers, which are importance significantly lower or higher than the prevalence of the data, can immensely affect the mean. If there are ‘mobile networks’ with extremely low or high data requests, the mean can be changed, directing to a smaller model “average”.

Reflecting Typical Values: The median describes the median value of the dataset when the prices are arranged, and it is less susceptible to severe values. This means it provides an adequate indication of what a distinctive data offer is surrounded by the 10 mobile networks, and of whether there are networks with unexpectedly small or large data offers.

Ensuring Fairness: In specific cases, there might be curiosity to deliver a reasonable representation of the data that is not changed by severe observations (Mishra, et al. 2019). The median performs this, making it a more useful choice when wanting dimensions of central movement that recall the "middle" of the data allocation.

Part D: Choose Between Escot and Rebala

When selecting between ESCOT and Rebala for a ‘SIM-only deal’, I would personally choose ESCOT. Because:

Data Allowance: ESCOT presents an influential 750 GB of 5G data, while Rebala only delivers 30 GB of data. This is a substantial contrast, and if need a large amount of data for operating, downloading, or different data-intensive movements, ESCOT is the more suitable option.

Minutes and Texts: Both ESCOT and Rebala deliver equal text allowances and minutes, so this element doesn't recreate an influential role in the judgment (Meeker, et al. 2022).

Monthly Cost: ESCOT is valued at $12.00 per month, whereas Rebala is valued at $5.00 per month. While Rebala is cost-effective on the basis of the month, the significant distinction in data allowance explains the higher cost of ESCOT, particularly if depends laboriously on data.

Contract Duration: Both ESCOT and Rebala hold a 12-month agreement, so there's no influential contrast in terms of responsibility.

In overview, ESCOT delivers a considerably bigger data allowance, which can be a critical aspect for multiple users who rely on data for different online actions. While it's valued barely higher than Rebala (Manoukian, 2022), the additional data capacity more than explains the cost difference, making ESCOT the excellent choice for those who require comprehensive data for the use of their smartphone.

Section 3

Part A: Percentage of Recorded Offences of Shoplifting Were Groceries in 2022/23

Figure 5: Calculate the Percentage of Recorded Offences of Shoplifting Were Groceries in 2022/23

(Source: Self-created in Excel)

Part B: Two Reasons Why You Believe Groceries Have a Higher Percentage Than Any Other Category of Items Shoplifted

There are two initial reasons why groceries may contain a ‘higher percentage’ of shoplifting compared to other types of items:

Necessity and Consumption Frequency: Groceries are essential to daily life, and individuals buy them regularly. This high need for groceries indicates that they are more often targeted by shoplifters (Eremeev, et al. 2020). Since groceries are unstable or consumable goods, there is an invariant requirement to reload them, making them an appealing target for those examining to meet their primary requirements without obtaining costs.

Ease of Concealment and Lower Perceived Risk: Groceries are generally smaller and slightly costly compared to objects in other categories, like homeware or electronics. This makes them easier to suppress in bags or clothing, lowering the sensed risk of anxiety by shoplifters. Shoplifters might sense groceries as low-risk marks, particularly if they acknowledge that security benchmarks are less severe for these objects in contrast to higher-priced interests.

These elements, among others, donate to groceries having a ‘higher percentage’ of shoplifting incidents in multiple issues.

Part C: Analysis and Interpretation of Ratio

1. Ratio Of The Number Of Homeware Items Shoplifted To Electrical Items In 2019/20

Figure 6: Ratio of the Number of Homeware Items Shoplifted To Electrical Items in 2019/20

(Source: Self-created in Excel)

1. Means Of Ratio

The ratio of 2:1, denoting the item number of homeware shoplifted to electrical items in 2019/20, has a detailed performance. In other phrases, homeware theft happened at twice the velocity of electrical theft (Shulenin, 2020). This ratio delivers a comparative comparison of the regularity of shoplifting in these two varieties. It means that, within the circumstances of shoplifting in 2019/20, homeware things were more continually targeted or registered as stolen compared to electrical objects, signifying a higher appearance of theft in the homeware variety.

Part D: Total Number of Recorded Offences between 2013/14 and 2022/23

Figure 7: Calculate the Total Number of Recorded Offences between 2013/14 and 2022/23

(Source: Self-created in Excel)

Part E: Minimum Number of Recorded Offences between 2013/14 and 2022/23

Figure 8: Calculate the Minimum Number of Recorded Offences between 2013/14 and 2022/23

(Source: Self-created in Excel)

Part F: Count How Many Years the Total Number of Recorded Offences Were Greater Than 340,000

Figure 9: Calculate the Count How Many Years the Total Number of Recorded Offences Were Greater Than 340,000

(Source: Self-created in Excel)

Part G: Create a Fully Labelled Line Graph to Show the Total Number of Recorded Offences in Each Year from 2013/14 to 2022/23

Figure 10: Graph of Total Number of Recorded Offences in Each Year from 2013/14 to 2022/23

(Source: Self-created in Excel)

Part H: Based on the Above Graph, Comment on the Overall Trend of Shoplifting between 2013/14 and 2022/23

The data on registered shoplifting offences between ‘2013/14 and 2022/23’ delivers a significant trend with both dips and peaks.

Overall Increasing Trend: From ‘2013/14 to 2017/18’, there was a constant rising trend in registered shoplifting offences (Kim, et al. 2021). The decimal of offences frequently raised from 321,483.00 to 391,213.00 by this period. Various aspects might contribute to this trend, like changing law enforcement methods, advanced reporting, or economic circumstances.

Dip and Peak: An effective peak was obeyed in 2016/17 when the digit of registered offences streamed to 365,652.00. This might be attributed to a mixture of elements, containing changes in societal conditions, law enforcement efforts, and economic factors. After the peak, there was a prominent dip in 2018/19 to 378,982.

Fluctuations: The data indicates fluctuations in the following years i.e. 2019/20 to 2022/23. Shoplifting offences dropped to 358,351.00 in 2019/20 but then grew to 421,679.00 in 2022/23. These fluctuations could be caused by a variety of elements (Janse, et al. 2021), involving social conditions, store security measures, and differences in the economic climate.

In overview, while there is a general developing trend in registered shoplifting offences, the ‘dips and peaks’ suggest that a critical interplay of social, economic, and law enforcement aspects affects shoplifting rates.

Section 4

Part A: Analysis and Interpretation of Graph and Correlation

I. Suitable Graph to Show the Correlation between Sales and Advertising

A proper graph to demonstrate the ‘correlation between sales and advertising’ is a ‘scatter plot’. A ‘scatter plot’ is a variety of graphs that shows particular data points on a ‘two-dimensional craft’, with one variable i.e. income from sales on the “x-axis” and the other variable i.e. cost of advertising on the “y-axis” (Hilasaca, et al. 2023).

In this case, here can utilize the data that have been gathered for the ‘income from sales’ and the ‘cost of advertising’ per year to construct the ‘scatter plot’ (Makowski, et al. 2020). This will help to specify whether there is a ‘correlation’ between sales and advertising cost, and if so, the character of that correlation becomes negative, positive, or no correlation.

II. Relevant Graph for Correlation between the Income from Sales and the Cost of Advertising

Figure 11: Graph to Show the Correlation between the Income from Sales and the Cost of Advertising

(Source: Self-created in Excel)

 III. Type of Correlation Is Present Between the Income from Sales and the Cost of Advertising

Based on the above graph’s data, it appears that there is a ‘positive correlation’ between ‘income from sales’ and the ‘cost of advertising’. As the price of advertising grows, the ‘income from sales’ also tends to grow. This is apparent from the prevalent trend in the data, where more increased advertising expenses are connected with higher figures of sales.

The ‘scatter plot’ of the data points would probably deliver an upward-sloping practice, demonstrating a ‘positive linear correlation’ (Strain, et al. 2023). This means that, in the conditions of the ‘Mini-Zoo Pet Store in Berlin’, funding more in promotion has a positive effect on sales implementation. Regardless, the correlation does not indicate causality, and other characteristics may also affect sales.

 IV. Meaning of Correlation

The positive correlation between ‘income from sales’ and the ‘cost of advertising’ implies that in the circumstance of the ‘Mini-Zoo Pet Store in Berlin’, there is a connection where more increased spending on promotion is correlated with higher sales income. In realistic terms, this signifies that funding more in advertising movements, marketing efforts, or promotions can have a profitable effect on the store's sales implementation.

V. Consideration to Increase the Sales Even Further Next Year

As the manager of the ‘Mini-Zoo Pet Store’, there are various methods to evaluate for growing sales further next year:

Expand Product Range: Evaluate consumer demands and consider counting new products or benefits that are set with existing market trends. This can draw a broader consumer base.

Customer Engagement: Improve consumer service and employment through feedback collection, personalized recommendations, and loyalty programs to create a loyal consumer base.

Online Presence: Boost online presence by enhancing the store's website and employing e-commerce (McGuire, et al. 2019). This encourages consumers to shop online, particularly if there's a climb in online shopping due to the altering market landscape.

Marketing and Advertising: Since there's a ‘positive correlation’ between advertising spend and sales, consider assigning higher funding for advertising. Utilize both digital and traditional marketing media to achieve a broader audience.

Inventory Management: Execute efficient inventory management strategies to decrease costs and control stockouts or overstocking.

Market Research: Remain updated with market research and industry trends. This can aid in determining emerging possibilities and threats.

By executing a variety of these techniques while observing the effect on sales, here can work towards improving the store's income in the forthcoming year.

Part B: Cost of Personalizing Products and How Many Have Been Sold

I. Labelled Pie Chart to Show the Income from Sales of the Most Popular Pet Names Used On Personalized Products Sold By Mini-Zoo

Figure 12: Pie Chart to Show the Income from Sales of the Most Popular Pet Names Sold By Mini-Zoo

(Source: Self-created in Excel)

II. Reason Why the Biggest Sector of the Pie Chart Does Not Represent the Most Popular Pet Name

The largest sector of the pie chart describes the pet “Trumpet” which does not naturally suggest that it is the famous pet for various reasons. While the chart demonstrates that "Trumpet" yielded the highest revenue, popularity is not exclusively defined by income. Some key reasons for this discrepancy are:

Pricing Structure: The pricing for customized is not constant across pet s. "Trumpet" has ‘7 letters’, and separate further letter costs €0.50. Thus, it inherently generates more revenue due to its lengthier . This doesn't certainly reflect its favor among pet proprietors but rather the expense associated with customizing products with this .

Different Customer Base: Mini-Zoo's consumers may have variable preferences for customization. Some consumers might prefer s such as "Trumpet" for detailed reasons, while others may choose shorter s such as "Tom" or "Jerry." This variety in choices can lead to deviations in income without displaying popularity.

Marketing and Promotion: The popularity of pet s can be affected by seasonal, trends, or marketing factors. A concerted measure in broadcasting specific s could guide to improved sales and income without glancing at intrinsic popularity.

Cultural and Regional Differences: The popularity of pet s can also change based on regional and cultural aspects. Some s may be famous in particular areas or within specific communities, which can bias the income allocation.

 III. Add Up the Total Number of Sales from Those Pets Whose Names Begin with the Letter ‘J’

Figure 13: Calculate the Total Number of Sales from Those Pets Who’s Names Begin with the Letter J

(Source: Self-created in Excel)

 IV. Find the Average Income from Sales from Those Pets Whose Names Have More Than 4 Letters

Figure 14: Calculate the Average Income from Sales from Those Pets Whose Names Have More Than 4 Letters

(Source: Self-created in Excel)

References

Journals

• Eremeev, D.V., Boyko, A.A., Kukartsev, A.V., Rozhkova, A.V., Mylnikova, E.V. and Korpacheva, L.N., 2020, July. The use of mathematical calculations to determine the feasibility of borrowing in the planning period. In Journal of Physics: Conference Series (Vol. 1582, No. 1, p. 012027). IOP Publishing.
• Hanandeh, S., Ardah, A. and Abu-Farsakh, M., 2020. Using artificial neural network and genetics algorithm to estimate the resilient modulus for stabilized subgrade and propose new empirical formula. Transportation Geotechnics, 24, p.100358.
• Hilasaca, G.M., Marcílio-Jr, W.E., Eler, D.M., Martins, R.M. and Paulovich, F.V., 2023. A Grid-based Method for Removing Overlaps of Dimensionality Reduction Scatterplot Layouts. IEEE Transactions on Visualization and Computer Graphics.
• Jäder, J., Lithner, J. and Sidenvall, J., 2020. Mathematical problem solving in textbooks from twelve countries. International Journal of Mathematical Education in Science and Technology, 51(7), pp.1120-1136.
• Jadhav, A., Pramod, D. and Ramanathan, K., 2019. Comparison of performance of data imputation methods for numeric dataset. Applied Artificial Intelligence, 33(10), pp.913-933.
• Janse, R.J., Hoekstra, T., Jager, K.J., Zoccali, C., Tripepi, G., Dekker, F.W. and van Diepen, M., 2021. Conducting correlation analysis: important limitations and pitfalls. Clinical Kidney Journal, 14(11), pp.2332-2337.
• Kim, J.K. and Shao, J., 2021. Statistical methods for handling incomplete data. CRC press.
• Kulkarni, A., Chong, D. and Batarseh, F.A., 2020. Foundations of data imbalance and solutions for a data democracy. In Data democracy (pp. 83-106). Academic Press.
• Little, R.J. and Rubin, D.B., 2019. Statistical analysis with missing data. John Wiley & Sons.
• Makowski, D., Ben-Shachar, M.S., Patil, I. and Lüdecke, D., 2020. Methods and algorithms for correlation analysis in R. Journal of Open Source Software, 5(51), p.2306.
• Manoukian, E.B., 2022. Mathematical nonparametric statistics. Taylor & Francis.
• McGuire, J.W., Chiu, J.S. and Elbing, A.O., 2019. Executive incomes, sales and profits. The American Economic Review, pp.753-761.
• Meeker, W.Q., Escobar, L.A. and Pascual, F.G., 2022. Statistical methods for reliability data. John Wiley & Sons.
• Mishra, P., Pandey, C.M., Singh, U., Gupta, A., Sahu, C. and Keshri, A., 2019. Descriptive statistics and normality tests for statistical data. Annals of cardiac anaesthesia, 22(1), p.67.
• Paul, D., Chakraborty, S. and Das, S., 2021. Robust principal component analysis: a median of means approach. arXiv preprint arXiv:2102.03403.
• Rabin, L.A., Krishnan, A., Bergdoll, R. and Fogel, J., 2021. Correlates of exam performance in an introductory statistics course: Basic math skills along with self-reported psychological/behavioral and demographic variables. Statistics Education Research Journal, 20(1), pp.3-3.
• Shulenin, V.P., 2020. Robust methods of mathematical statistics.
• Strain, G., Stewart, A.J., Warren, P. and Jay, C., 2023. The Effects of Contrast on Correlation Perception in Scatterplots. International Journal of Human-Computer Studies, 176, p.103040.