Excel-Based Data Analysis: A Facebook Case Study for Numeracy Test

This report analyzes Facebook data using MS Excel to assess numeracy skills. It examines market capitalization, revenue, and employee numbers from 2017 to 2021. Statistical methods such as SUM, COUNT, MINIMUM, and MAXIMUM are applied, and the raw data is presented graphically. Key findings include the growth in employee numbers, market capitalization, and revenue over the five-year period. The analysis interprets trends and highlights the significance of these metrics for understanding Facebook's business performance. The report concludes that effective data management and analysis are crucial for assessing organizational growth and financial health. Desklib provides this assignment solution along with numerous past papers and study resources to aid students in their academic pursuits.

A1 MS EXCEL TASK
A2 IN CLASS
NUMERACY TEST

Table of Contents
INTRODUCTION...........................................................................................................................3
TASK...............................................................................................................................................3
1. Selection of Research topic and its explanation:................................................................3
2. Raw information for analysis and sampling of data:..........................................................4
3. Performance of statistical methods on set of information:.................................................4
(Covered in Excel)..................................................................................................................4
4. Graphical Presentation of Raw Data information:.............................................................4
5. Description about findings obtained:..................................................................................6
CONCLUSION................................................................................................................................8
REFERENCES................................................................................................................................9

INTRODUCTION
The record coordinated underneath Neath takes a related examinations topic on Facebook
which works with to find normal of realities gathered, mid expense of assortment coordinated
and deals created with the guide of involving the organization for a length of north of five years.
Facebook is moreover perceived as 'Meta' that could be an online entertainment stage useful in
building procedures this is helpful for interfacing people from wherever on the planet. The report
comprises of commercial centre capitalisation, amount of faculty drew in with organization,
deals created with the guide of involving the business and its related conceivable outcomes also.
The report counts directions comprehensive of Maximum, Minimum, Count and Sum (Dwyer,
Willis and Call, 2020).
TASK
1. Selection of Research topic and its explanation:
The topic selected under Coordination Records is Facebook. This report was performed
after looking at various ways to manage data and considering specific ways. It serves as a guide
tool for calculating transactions obtained through the method of association given below over
five years. So far, the research topic is the significance of association work and income
measurement obtained through the method of association method. The ability to decipher and
close from previously coordinated archives is advantageous. Therefore, it takes into account the
interpretation and use of such expressions in relevant gatherings. The exam content I decided to
look for was Facebook. It will clarify what is assumed to be selected that may have value in
improving general execution related to association. There are a number of competencies that may
be associated with higher-level organizations that also help maintain inventory levels in the
effort (Gunn, E., 2020).
Importantly, the association is suitable for gradually adding more people over a period of
time. There are many reiterations that help make gatherings more productive amid strong
environmental factors and help cut expenses, reduce risk, and increase productivity. To develop
executive and strong associations need to look for thought processes that can be checked and
committed to doing so. There are many programs that promise in a subjective and quantitative
gathering of characters that try to perceive the thought processes behind what is missing in the

artwork, and the laxness behind powerful environmental elements. Separate data related to
business centre capital, transactions, and customer reach.
Collecting number one base information: It states the records accumulated through big
business or any related festival methods were spotless and new. What's more, this data has not
been used consistently by another organization until today. Therefore, this type of data is helpful
because it reduces the number of risks involved and reduces the scope of errors. It is considered
to be more correct and reliable when examining the various data used by any business. In this
mind-set, control over the record is often not justified, so the choices taken may be relevant in
the near future (Hanemann and McKay, 2019).
Collecting information from various sources: Associations may be using different sources for
determinations that can serve the effort in an appropriate manner at a legitimate time. Also, it is
useful because the data is surveyed and aggregated through the boss' method of reality. It
involves a variety of examples, so the dataset final product may be out of date, no errors or
misrepresentations are incorporated in any way. It is helpful when associations are faced with the
same inconveniences that are addressed through various organizational approaches, as it
delightfully enables them to utilize and adapt various technologies.
2. Raw information for analysis and sampling of data:
Year Market capitalisation Revenue Number of employees
2021 927.528 117929 71970
2020 674.568 85965 58604
2019 530.563 70697 44942
2018 506.986 55838 35587
2017 457.985 40653 25105
3. Performance of statistical methods on set of information:
(Covered in Excel)
4. Graphical Presentation of Raw Data information:

2021 2020 2019 2018 2017
0
20000
40000
60000
80000
100000
120000
140000
Revenue
2021 2020 2019 2018 2017
0
100
200
300
400
500
600
700
800
900
1000
Market capitalisation

2021 2020 2019 2018 2017
0
10000
20000
30000
40000
50000
60000
70000
80000
Number of employees
5. Description about findings obtained:
It can be seen that the number of employees in 2018 increased from 25,105 to 35,587, an
increase of 4.44%. Then, at that time, it repeats in 9,355 for each long term, indicating that
Facebook has a higher rate of employee enlistment. It saves development money until 2021 to be
incorporated into 71970, which is a great option for higher general business performance
(Indefenso and Yazon, 2020).
 Market Capitalisation: This segment is likely to rise from 457.98 in the long term to 49,
23.577 in 2019, 144.50 in the long term, and 252.96 in 2021. This shows that the
association is evident in developing perspectives each year approaching.
SUM: This capacity shows that so far, 371,082 transactions have occurred, 236,208 faculty and
staff, and 3,097.63 if the business centre is capitalized, corresponding to 371,082 transactions
recorded (Passolunghi and Costa, 2019).
 COUNT: The be considered number is recorded five which shows the years. It shows that
what number of years' turn of events and satisfaction is being refreshed if there should
arise an occurrence of Facebook partnership.
 MINIMUM: It shows that, once complete, the underlying parent of the set of insights
reconciled by business risk over a given time span is displayed again. The minimum
parent is considered to be 457.985 if commercial center capitalization occurs, 25105 in
the broad faculty field, and 40653 if transactions are generated in the Facebook
Association.

 MAXIMUM: The mark hints at the absolute best number of coordinated insights to date.
It shows a parent of 927.528, which is by far the largest number purchased through the
association in a market cap event. When showing various employees, it records 71970,
and in partial transactions, it depicts 117929 results (Steinhardt, 2020).
Interpretation: It shows, estimates and graphs show that business efforts have addressed
and taken into account the development scale of the calculated market cap, in addition, it
has maintained a rapid vertical push in the trading percentage from 10.96 to a level of
31.78%. The number of employees associated with the business has increased
significantly each year, and in 5 years, the association has seen an explosion from 2017 to
long-term, from 25,105 to 71,970 guardians raised. It needs the help of min, max,
counted and aggregated composite elements. These transactions create well-established
business activities, help hire more talented employees from relevant business centres, and
cooperate with more noteworthy customers, thereby determining the increment and
development of business risks within a certain period of time.

CONCLUSION
From the above report it can be Concluded that each organization has various capabilities
and guidelines, and there is roughly a legitimate idea of what a partnership does and works in a
relevant competitor environment. Dealing with messy and complex data in one region is the
foundation of every effort, helping to chart the growth of the organization over the years. It has
the power to examine its financial work in the business centre and whether it has any strong
advantages in running large businesses. In addition, the record enables partners to get a rough
idea of whether the business exists behind it and how it is prepared to look for different
procedures to assess the promise of the results provided so far. It is essential and mandatory for
every business to understand where a partnership can improve its related work and execution. In
addition, it can also find ways while aggregating data, finding the least and most decisions until
this point is determined.

REFERENCES
Books and Journals
Dwyer, R., Willis, A. and Call, K., 2020. Teacher educators speaking up: Illuminating stories
stifled by the iron-grip regulation of initial teacher education. Asia-Pacific Journal of
Teacher Education, 48(5), pp.572-585.
Gunn, E., 2020. Critical numeracy: an interview with Anke Grotlueschen. Fine Print, 43(1),
pp.15-18.
Hanemann, U. and McKay, V., 2019. Learning in the mother tongue: Examining the learning
outcomes of the South African Kha Ri Gude literacy campaign. International Review of
Education, 65(3), pp.351-387.
Indefenso, E.E. and Yazon, A.D., 2020. Numeracy Level, Mathematics Problem Skills, and
Financial Literacy. Universal Journal of Educational Research, 8(10), pp.4393-4399.
Passolunghi, M.C. and Costa, H.M., 2019. Working memory and mathematical learning.
In International handbook of mathematical learning difficulties (pp. 407-421). Springer,
Cham.
Steinhardt, J., 2020. The role of numeric and statistical content on risk perception in infographics
about road safety. Journal of Risk Research, 23(5), pp.613-625.
Vetter, M. and et.al., 2020. ‘Maths on the move’: Effectiveness of physically-active lessons for
learning maths and increasing physical activity in primary school students. Journal of
Science and Medicine in Sport, 23(8), pp.735-739.