Assessment of Numeracy, Data, and IT Content for Analysis Assignment

This assignment solution delves into various aspects of numeracy, data analysis, and IT skills. Part 1 covers fundamental concepts like fractions, percentages, and basic calculations. Part 2 analyzes data from Olympic games, focusing on medal counts and rankings. Part 3 provides detailed Excel-based solutions, including ranking methods and data visualization techniques. The assignment demonstrates practical application of these skills, offering insights into data interpretation and problem-solving within different contexts. The document incorporates references to support the presented information and analysis.

Using Numeracy, Data &
IT

Contents
INTRODUCTION...........................................................................................................................................4
PART 1.........................................................................................................................................................4
Q. 1..........................................................................................................................................................4
Q. 2..........................................................................................................................................................5
Q. 3..........................................................................................................................................................5
Q. 4..........................................................................................................................................................5
Q. 5..........................................................................................................................................................5
Q. 6..........................................................................................................................................................6
Q. 7..........................................................................................................................................................6
Q. 8..........................................................................................................................................................7
Q. 9..........................................................................................................................................................7
Q. 10........................................................................................................................................................7
PART 2.........................................................................................................................................................8
Q. 11 .......................................................................................................................................................8
PART 3.......................................................................................................................................................10
Q. 12......................................................................................................................................................10
Q. 13......................................................................................................................................................11
Q. 14......................................................................................................................................................14
Q. 15......................................................................................................................................................16
Q. 16......................................................................................................................................................17
CONCLUSION.............................................................................................................................................18
REFERENCES..............................................................................................................................................19

INTRODUCTION
The capacity to rationale and to implement precise mathematical definitions is described
as numeracy. Simple abilities in numeracy comprise of understanding basic arithmetic such as
addition, subtraction, multiplication, and differentiation (Ali and Mukhtar, 2017). In their growth
and pathological regression, numeracy skills have been thoroughly researched, but it is not well
understood if they alter healthy ageing. Similarly, it is still an unanswered question if either
numerical ability can be enhanced during ageing. Data analysis is a data inspection, cleaning,
transformation and modeling method aimed at finding valuable knowledge, reporting findings
and facilitating decision-making. Data analysis has numerous facets and methods, under a
number of names, involving various strategies, and is used in various fields of business, research,
and social science. Data analysis involves making more knowledge related in today’s business
environment and helping companies perform more effectively.
PART 1
Q. 1
Numerator: The numerator is the amount on the upper part of the fraction that occurs. A
fraction is nothing other than a portion of all of it that said previously (Armaidi, Suyitno and
Dewi, 2020). The numerator thus reflects the amount of equal portions of all of it that will be
factored.
Denominator: The second element of the fraction is the denominator. Mostly on lower part of
the fraction, we constitute it. In addition, it refers to the number of two portions that we can split
the whole into. Take another example of the 1⁄2 fraction. Over here, 1⁄2 implies that two
equivalent portions of a specific image are factored.
The denominator reflects the amount of equal portions in a fraction, and the numerator
reflects however many sections are included in a fraction. As p / q is like p parts in a fraction,
which is really the numerator of an entire entity, which is separated into q sections of the same
dimension, which would be the denominator.

Q. 2
24 / 40 = 0.6
18 / 42 = 0.43 (approximately)
Q. 3
a. Expressing following fractions 2/3,3//4 and 5/6 as equivalent fractions to the denominator of
12
2 / 3 = 2*4 / 3*4 = 8 / 12
3 / 4 = 3*3 / 4*3 = 9/12
5 / 6 = 5*2 / 6*2 = 10 / 12
b. Evaluating the percentage of library books on the basis of computing
Remainder book = 60,000 – 14,000 – 22,000 – 12,000
=12,000
Computing of books = 12,000
= 8,000
Percentage of computing of books =
= 13.33%
Q. 4
Sum of money given by Liz = £ 50 × 3 = £150
Total rate of two pairs of shoes = £150 - £10.50
= £139.50
Rate of each pair of shoes = £139.50 / 2
= £69.75 per pair
Q. 5
240.50 * 19.54 in two significant numbers
= 4699.37

Therefore, significant number equals to 46
(b) Determine the number 52100 as power of 10.
= 5.21 * 104
Q. 6
Discounting rate = 30%
Number of people = 3
Sum of amount paid = £210
Amount to be paid for 1 person = £210 / 3 = 70
Amount paid 's percentage = 70%
Total amount required to be for sign up = £210
Total amount of discount received = £210 ×
= £63
Hence, the total amount of savings = £63
(b) Average of per person saving = £63 / 3 (Patty and her two siblings)
= £21 per person
Q. 7
a) 3 / 4 – 7 / 9 + 2 / 3
Apply BODMAS = 17 / 12 – 7 / 9
= 237 / 108
b) The largest figure among all series is 1.0 the reason behind this significant decimal digit, right
digit of decimal point 0.1 has two individual decimal digit is 0.1 depicted from the number of
zero and become 0.10 that gives it two same decimal digits such as 0.02,0.003 and others (Joyce
and et.al., 2020).
0.1

Q. 8
Number of people who said yes = ( 90 + 60 )
= 90
Number of women who said yes = 60
= 18
Sum of number of man who said yes = 90 – 18
= 72
Number of man who denied = 90 - 72 = 18
Percentage of the men who denied =
= 20%
Q. 9
In this method of reverse calculation will be used:
Specific time on which Annebelle has to attend conference meeting = 10:30am
Required time taken from Euston Rail station to reach Birmingham is 1 hour 10 minutes, she
needs train at = 10:30am – 1:15hrs = 09:15am
No train is available on this exact time and Annabelle has one option to take at 09:05am
Required time taken from her house to the station is 1hr = 09:05 am – 1hr
= 08:05 am
Hence; she requires to leave house at 08:05 am.
Q. 10
Both values has converted into simple form = 9 / 25
= 0.36 Kg
Hence, From the calculations it is evaluated that 0.36 Kg or 9 / 25 Kg is heavier than 0.35Kg of
Shredded Wheat.

PART 2
Q. 11
a... Hungary is the country which has win lowest number or medals among the countries.
b.... China and soviet Union has completed least number of games.
c... the mode number of games in which countries participated is 27.
d.... In the range between gold medals there is the maximum and minimum range which is 1022,
147 respectively (Khasnabish and et.al., 2020).
RANGE = Maximum – Minimum
= 1022 – 147
= 875
e... The number of countries get more silver medals than bronze medals is 4 countruies.
f... the name of the country which won gold, silver and bronze medals are Germany, United
States and Soviet Union.
g....
Country
Total
Games
Total
medals
Medals per
game
Australia..... 26 497 19.11538462
China....... 10 543 54.3
France...... 28 713 25.46428571
Germany...... 24 937 39.04166667
Great
Britain.... 28 847 30.25
Hungary..... 26 491 18.88461538
Italy..... 27 577 21.37037037

Soviet
Union.... 10 1122 112.2
Sweden ….. 27 494 18.2962963
United
States.... 27 2520 93.33333333
Thus, 93.33 medals per game were won by the United States, which is the highest of all nations.
Firstly, the largest number of trophies won per game is in the United States (Logan and Lowrie,
2017).
h... Causes include the following:
1. In total Olympic games, Jamaica has scored little because they are no able to participate in all
the activities for gold medal; because of that which was not included in the top 10 rankings.
2. Athletes from Jamaica have indeed actively participated in one sprinting event among all
events which is very important for all countries.
(i)
Country
Gold...
.
United
States..... 1022
Soviet
Union..... 440
582
Country
Silver..
..
United
States..... 794
Soviet
Union...... 357
437
Country
Bronze
....
United
States...... 704
Soviet
Union...... 325
379

Gold (582) is the overall disparity between award classes with the nearest rival; thus,
Gold is the division whereby the nearest rival has far outpaced in the United States (Putri, Salim
and Sunardi, 2017).
(j) Sweden and Australia have less gold medals = 147
Hungry and Australia have less silver medals = 147 & 163
country which have less bronze medals are china and Hungary = 151 & 179
Team..... Gold.... Silver..... Bronze....
Range..
..
Hungary.... 175 147 169 28
Italy..... 206 178 193 28
Great
Britain... 263 295 289 32
Sweden …. 147 170 179 32
Australia..... 147 163 187 40
France..... 212 241 260 48
Germany..... 275 313 349 74
China..... 227 165 151 76
Soviet
Union.... 440 357 325 115
United
States.... 1022 794 704 228
From the above table present the total medals of each country with the range of smallest numbers
(Rakhmawati, Hasibuan and Sholichah, 2020).
PART 3
Q. 12
Team Total games Gold Silver Bronze Total
Australia..... 26 147 163 187 497
China...... 10 227 165 151 543
France..... 28 212 241 260 713
Germany.... 24 275 313 349 937
Great
Britain..... 28 263 295 289 847
Hungary..... 26 175 147 169 491
Italy...... 27 206 178 193 577

Soviet
Union..... 10 440 357 325 1122
Sweden..... 27 147 170 179 494
United
states..... 27 1022 794 704 2520
Q. 13
a. What moves or acts would you take to rank them from 1st to 10th in Excel?
In Excel, it is the RANK method that contains the rank of a variable in a number list. If
there's enough only one amount of the same rank, then there is the use of the RANK AVERAGE
to determine average rank.
1. Unless in the third statement is excluded (or 0), Excel ranks first in the greatest number,
second one is the highest amount, etc (Sikora, Evans and Kelley, 2019).
2. If there is the another third statement is 1, the shortest amount is the first ranked by Excel,
there is the second lowest amount is also second etc.
3. In Excel, there is the RANK AVERAGE function returns in which there is the sample
consisted whether the same rank is used for upwards of once amount.
Only for RANK feature, there are 3 justifications:
• Number: In the instance earlier in this thread, the amount to be ranked is the cell B2.
•Reference: researchers would likes to consider the number to the $B$2:$B$11 ranking of the
cell numbers (Söğüt, Göksun and Altan‐Atalay, 2020). Using an absolute reference
($B$2:$B11), rather than a conditional reference (B2: B11), so that when you copied the
equation across to the cells above, the defined range will remain same for all the row.
Order: (adjustable) This is the statement informs Excel if the list should be ranked in lowest to
highest.
 To seek the rank in the chart in increasing order, there is the use of the zero, or leaving
this statement blank. The rank claim was ignored entirely in the instance before, to seek
the rank in descending order.

 (B2,$B$2:$B$11)..... = RANK
 Form a 1, there is the other number but zero, for ascending order.
 You might type a 1, to rank in ascending order, if you were contrasting golf scores.
 RANK(B2,$B$2:$B$11,1).....
The 3rd statement is unspecified in the RANK function. The command claim informs Excel
whether the list is should be ranked in ascending or descending (Spithourakis and Riedel, 2018).
When you use zero as the ordering structure, or if the 3rd argument is not used, the rank is
defined in descending order.
 A rank of 1.... gets the highest number.
 The tenth largest number is ranked at 10.....;
 If you use number 1 as the ordering framework, or if you insert as the 3rd argument any
quantity but zero, the rank is set in decreasing order.
 A rank of 1 receives the shortest distance
 those who get rank 10 receives the 10th lowest amount.
 Using a cell guide to construct the versatile equation, rather than entering the order
statement amount into a RANK method.
For illustration, in cell E1, type a 1, but for the ordering statement, connect to cell E1.
You can easily see higher capacity by connecting to a cell, while changing the design. In cell E1,
write a zero or remove the amount, and the rank changes to Descending Order.
There are only 2 options for the order option-ascending or descending. Using a check boxes to
switch the Ascending Order ON or OFF to make it easier for people to change the structure of
the excel function.
Whether it is ON, the order of the RANK is Ascending.

It is switched OFF, the descending order of the RANK will be
B. In Excel, define the particular corrective action or step(s) that will create a list / display of the
countries with a total of 800 or more medals...
Conditional formatting makes it much easier through using information labels, colour scales, and
symbol collections which conform to unique differences in the data to identify unique cells or
groups of cells, identify mysteriously, and visualize data. Depending on the circumstances that
you define, a conditional format affects the color of cells. The cell range is configured unless the
statements are met; unless the conditions are incorrect, the range of cells is not configured. There
are several built-in requirements, and you can build your own as well (such as when using a True
or False assessment method).To implement this practice, the Excel method is contingent
formatting, which can imagine values below 800 by showing them as different colours. The steps
for getting the answer below provide:
Support these measures to establish this fundamental configuration rule:
1. Select a particular modules in the normal range (in this case, cells C3: C14), click the Excel
Ribbon 's Home tab, and afterwards click Conditional Formatting as a new rule. A options dialog
box with the New Configuration Rule (Winter, 2019).
2. Press the Use Formula to Decide Increasing Cells to Format choice in the list box on the right
of the dialogue box. This subset examines the meanings accordance with the study definition. If
it is TRUE is evaluated by a specific value, the conditional specification is transferred to that
cell.
3. Access the calculation presented here in the calculation box that appears. Remember the first
cell in the goal range is literally referenced by you. It's not necessary for you to search the full
portfolio.
4. Press the button on Format. This triggers explain the utilizing existing dialogue box, which
provides you with a full range of font, border, and fill advanced settings for your cell nucleus.
After determining your formatting choices have been accomplished, click “OK” to approve your
modifications and navigate to the New Formatting Rule dialogue.

(c... In representing gold medal information Line graph or bar graph is more suitable for the line
graph.
(d.... Total; in total column replicating formula of the SUM has been used for all other teams.
(e..... =SUM() formula can be used to calculate the total overall medals.
Q. 14
a. Give the total number of medals for Germany and Great Britain.
Formula:
= the formula used in this is SUM(F32 + F38).
b. Give the average number of silver medals for a European country
Formula:
The number of European countries is which get average number of silver medals are France,
Germany, Great Britain, Italy, Soviet Union and Sweden.
Total OF 6 counties.
=AVERAGE (F31 + F32 + F33 + F35 + F36 + F37)
c. Sum the Medals Total for Gold for those countries with less than 20 games involvement.
To solve this, the equation 'what if' will be applied, after which the answer will be in the type of
FALSE TRUE; whereby 'FALSE' implies quantities below 20 there is the 'TRUE' implies value
above 20. Afterwards, all the cells representing the TRUE value are filtered and GOLD
quantities are determined (Walter, Nuhfer and Suarez). These steps are listed below:
1.... Pick the cell that contains the value you want to alter. You'll need to pick a cell which
already includes a method or structure when you use Goal Seek.
2.....Press the What-If Research button on the Data tab, and then pick Target Seek from the drop-
down menu.
3. With 3 domains there is the dialog box appears:
Set cell: This is the cell that holds the result that you want. In our example, cell B7 has been
picked.

By modifying the cell: This is the unit where even the response is put by Target Seek. We will
choose cell B6 in our instance, if we want to decide the grade on the final project that we need to
win.
4. Whether Goal Seek is able to get it done, the dialogue box will inform you. Only click OK.
5. In the stated cell, there is the results will be displayed (Poro, Yiga and Enon, 2019). In our
instance, Goal Seek determined that in order to earn good grade, we would need to score at least
90 on the final project.
d. Check the file (the entire spreadsheet) to identify ‘Italy’ and even the related Medals Overall.
The VLOOKUP feature will be implemented here; VLOOKUP continues to stand for "vertical
lookup." In Excel, this involves the practice of horizontally looking data up along a spreadsheet,
that use the sections of the excel sheet as the grounds of your quest, and a specific location in
those sections. Because once you look up your files, that wherever the data resides, it should be
mentioned diagonally.
To worth: This is the outcome that was desired. We'll be entering 70 in our case, but we need to
pay at least that to complete this course.
1. Define a column of cells that you want to populate with new information.
2. Choose 'Feature' which is (Fx) > VLOOKUP and paste this equation into the cell you
illuminated.
3. Insert the lookup key for which one you want new information to be retrieved.
4. Enter a database tables set where even the required data is stored.
5. Enter the column amount of the information you would like to retrieve from Excel.
6. To pinpoint the suitable or estimated match of your search value, enter your scope lookup.
7. Select button 'Done' (or 'Enter') and your current row now be filled in.
Q. 15.
a.
• The median is determined as the middle element in the category in which there is the overall
amount of provided figures is odd.

The median is determined for the sum of the two numbers in the cent re when the overall
amount of provided items is even.
• Neglect cells that contain relevant, maximum quantity, or no meaning.
• figures can be provided as figures, ranges, decided to name distances, or comparisons to cells
containing numerical values. It is possible to supply up to 255 numbers.
 There is no constructed way for applying parameters to the MEDIAN function (Bitterly,
VanEpps and Schweitzer, 2020). Provided a range, the MEDIAN (middle) amount in that
range would be returned. We just use IF function within MEDIAN to 'philtre' values for
the important to formulate parameters.
So, firstly, results is presented in the following subsections and median will be recognized for
5th and 6th position in the excel.
Gold Median:
219.5.....
Silver Median:
209.5
Bronze median:
206.5.......
b. Calculate the mean number of medals for each of the 3 medal types, stating the formula you
would use for determining the mean for the bronze medals.
Mean:
means for the Gold = 311; Silver = 282 and Bronze = 281 for calculate the mean there is the
formula is used
Formula; (= AVERAGE(E29:E38))
c. Calculate the standard deviation of the total medals awarded to each country (column F)
using the formula below.
Standard Deviation = 288.60926......
Variance (σ2)= 83295.306.......
Count (n) = 12.....

Meanx¯=478.83333......
Sum of SquaresSS =999543.67.......
= 288.60926......
d. The most widely utilized Standard deviation in an observable procedure is standard deviation
when combining is being used to calculate focused preference (Yamashita and et.al., 2020). It
calculates the total distribution, since these lines to do. Due to the near links to the mean, if the
mean offers an unassisted aspect of the attention deflection, a normal movement may have a
major impact.
Exceptions which can usually be added in the aftereffects of the particular deviation are also
covered by the standard deviation. In this regards, a fair suggestion that there are variations is
universal prejudice. For correct ratio without deviations, this makes natural movement a very
helpful aspect of the transmission.
Q. 16.
a. It has been used column chart to represent the total gold, Bronze and Silver that was won by
10 countries in Olympic Game.
b. Column chart: A graph that depicts comparable variability intervals or the Comparative size,
Length, Quality, Strength of a number of individuals from the means of contrasted relative
column
This chart present the total medals of 10 countries that was won by players in Olympic Games
after competition.
CONCLUSION

REFERENCES
Books and Journal
Ali, S. R. and Mukhtar, F., 2017. A case study of fun learning with numeracy of
preschoolers. Southeast Asia Early Childhood Journal. 6. pp.51-58.
Armaidi, I. E., Suyitno, H. and Dewi, N. R., 2020, June. Implementation of Problem-Based
Learning Assisted with Recreation of Second Mathematics to Improve Numeracy and
Problem Solving Skills. In International Conference on Science and Education and
Technology (ISET 2019) (pp. 694-698). Atlantis Press.
Bitterly, T. B., VanEpps, E. and Schweitzer, M. E., 2020. Exponential Numeracy. Available at
SSRN 3746327.
Joyce, D. D. and et.al., 2020, May. Examining the association of health literacy and numeracy
with prostate-related knowledge and prostate cancer treatment regret. In Urologic
Oncology: Seminars and Original Investigations. Elsevier.
Khasnabish, S. and et.al., 2020. Best practices for data visualization: creating and evaluating a
report for an evidence-based fall prevention program. Journal of the American Medical
Informatics Association. 27(2). pp.308-314.
Logan, T. and Lowrie, T., 2017. Gender perspectives on spatial tasks in a national assessment: A
secondary data analysis. Research in Mathematics Education. 19(2). pp.199-216.
Poro, S. G., Yiga, A. P. and Enon, J. C., 2019. Learners’ attainment of numeracy skills, is
supervision relevant? A case of selected districts in Acholi Sub-region Uganda.
Putri, N. D. A., Salim, A. and Sunardi, S., 2017. The Effectiveness Of The Use of Course
Review Horay (CRH) Methods To Improve Numeracy Division Skill of Children With
Mild Mental Retardation In SLB Negeri Surakarta, Indonesia YEAR
2016/2017. European Journal of Special Education Research.
Rakhmawati, N. I., Hasibuan, R. and Sholichah, I., 2020, December. Developing Children’s
Early Numeracy Skill Through Traditional Game “Dragon Snakes”. In International
Joint Conference on Arts and Humanities (IJCAH 2020) (pp. 243-249). Atlantis Press.
Sikora, J., Evans, M. D. R. and Kelley, J., 2019. Scholarly culture: How books in adolescence
enhance adult literacy, numeracy and technology skills in 31 societies. Social science
research. 77. pp.1-15.
Söğüt, M., Göksun, T. and Altan‐Atalay, A., 2020. The role of numeracy skills on the Wisconsin
card sorting test (WCST) performances of 5‐to 8‐Year‐old turkish children. British
Journal of Developmental Psychology.
Spithourakis, G. P. and Riedel, S., 2018. Numeracy for language models: Evaluating and
improving their ability to predict numbers. arXiv preprint arXiv:1805.08154.

Walter, P. J., Nuhfer, E. and Suarez, C., Probing for Bias: Comparing Populations Using Item
Response Curves. Numeracy. 14(1). p.2.
Winter, L., 2019. Embedded numeracy teaching practices at an Institute of Technology:
Vocational tutors' characterisations of embedding numeracy and related professional
development(Doctoral dissertation, The University of Waikato).
Yamashita, T. and et.al., 2020. Numeracy and preventive health care service utilization among
middle-aged and older adults in the US. Clinical gerontologist. 43(2). pp.221-232.