Data Analysis of Facebook: A1 MS Excel Task & A2 Numeracy Test Report

This document presents an analysis of Facebook's financial and operational data from 2017 to 2021, utilizing MS Excel for data manipulation and statistical analysis. The assignment focuses on a chosen research topic: Facebook, and involves collecting raw data on market capitalization, revenue, and the number of employees. The collected data is then processed using various Excel tools to calculate key metrics such as maximum, minimum, sum, and count, which helps to identify trends and patterns over the five-year period. The analysis includes graphical representations of revenue, market capitalization, and employee numbers to visualize the company's growth. The findings reveal significant increases in market capitalization, revenue, and employee count, indicating positive business performance. The analysis also highlights the application of statistical tools to interpret the data and draw conclusions about Facebook's financial health and growth trajectory, emphasizing the importance of data-driven decision-making in understanding business performance and identifying areas for improvement.

A1 MS EXCEL TASK
A2 IN CLASS
NUMERACY TEST

Table of Contents
INTRODUCTION...........................................................................................................................3
TASK...............................................................................................................................................3
1. Choose one research topic from provided list....................................................................3
2. Acquire applicable raw data for analysis and sampling.....................................................4
3. With the help of Excel manipulate the raw data collected with several statistical tools and
communicate the analysis and information............................................................................5
(Covered in Excel)..................................................................................................................5
4. Graphical Presentation of Raw Data information:.............................................................5
5. Briefly describe assessment and findings carried out.........................................................6
CONCLUSION................................................................................................................................8
REFERENCES................................................................................................................................9

INTRODUCTION
The document organized beneath Neath takes a associated studies subject matter on
Facebook which facilitates to discover common of facts collected, mid cost of collection
organized and sales generated with the aid of using the company for a length of over five years.
Facebook is likewise recognised as 'Meta' that could be a social media platform beneficial in
constructing strategies this is beneficial for connecting humans from everywhere in the world.
The document consists of marketplace capitalisation, quantity of personnel engaged with
company, sales generated with the aid of using the employer and its associated possibilities as
well. The document counts instructions inclusive of Maximum, Minimum, Count and Sum as
well.
TASK
1. Choose one research topic from provided list.
The subject matter selected in organized document is Facebook. The report performed
takes in account looking numerous paths for dealing with information and sorting it in a
particular way. It behaves as a guiding device for computation of sales earned via way of means
of an organization for over five years counted from 2017 to 2021. Research subject matter
explains the operating of organization and the amount of earnings that has been earned via way
of means of an organization so far (Bassey, Owan, and Eze, 2019). It is beneficial in know-how
what may be interpreted and concluded from the document organized above. It for that reason
takes in account clarification and utilization of such phrases in associated groups. The studies
content material decided on for locating is Facebook. It will give an explanation for if the gear
selected might be beneficial in enhancing the overall performance this is related to organisation.
There are many functions which might be connected for higher functioning of agency and which
additionally assist to keep stock degree inside an enterprise. It is critical that the organisation is
capable of join increasingly more human beings over a duration of time. There are many
reasserts that assist in higher operating of groups in aggressive surroundings and which might in
slicing of costs, decreasing hazard and growing profitability ratios. For growing performance and
powerful the organization need to look for motives which might check and make a contribution
in doing so (Bruno, Barca, and Passarella, 2018). There are many strategies that could make a
contribution in a qualitative and quantitative factor in case of groups trying to recognize the

motives at the back of missing in paintings and lagging at the back of in aggressive enterprise
surroundings. Extracting information associated with marketplace capitalisation, sales and range
of users.
Collecting number one base information: It states that the records this is accumulated via way of
means of enterprise or any associated celebration is clean and new. It in addition explains that
information which isn't always being utilized by another agency until date. Thus, such form of
information is beneficial because it enables to lessen the quantity of hazard concerned and
decline in range of mistakes as nicely. It is taken into consideration extra correct and dependable
whilst in comparison with different reasserts of information utilized by any enterprise.
Manipulation of records isn't always feasible in such instances for that reason selections taken
might be fruitful for organisation in close to future (Chen, Wylie, and Genova, 2020).
Collecting information from secondary reasserts: There are books, articles, reports, surveys and
questionnaire which might be being utilized by the organisation for taking selections that could
serve the enterprise in proper way at proper time. It in addition is beneficial due to the fact the
information is analysed and accumulated via way of means of superiors. It has been used
numerous instances for that reason the dataset can end result to be out of date however
incorporates no blunders or fraud. It is beneficial whilst the organisation faces equal troubles
being countered via way of means of different corporations as nicely it enables them to use and
adapt numerous strategies (Chertchom, 2018).
2. Acquire applicable raw data for analysis and sampling.
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. With the help of Excel manipulate the raw data collected with several statistical tools and
communicate the analysis and 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. Briefly describe assessment and findings carried out.
 No. of personnel: It is found that wide variety of personnel have multiplied from 25105 to
35587 in year 2018 with a percent hike of 4.44%. It then multiplied through some of
9355 in 2019 year which denotes that the hiring and reattainment of personnel is growing
in Facebook. It saved on growing until the be counted number of 71970 in year 2021
which is a superb indicator toward higher overall performance of the organisation
(ElMoaqet, Ismael, and Ryalat, 2018).
 Market capitalisation: In this segment it could be found to upward push from 457.98
through a quantity of 49 in 2018 year, 23.577 in year 2019, 144.50 in 2020 year and
through 252.96 in year 2021. It denotes that the organization has visible a growing scale
in every passing year.
 SUM: Summation of figures recorded up to now in case of sales resulted as 371082, wide
variety of personnel resulted as 236208 and in case of marketplace capitalisation it
amounted as 3097.63, in context of sales it recorded as 371082.
 COUNT: The be counted number is recorded as five which denotes years. It states that
what number of years development and fulfilment is being recorded in case of Facebook
organisation.
 MINIMUM: It is command that once carried out reverts again the smallest parent from
the statistics set organized through the business enterprise for a given duration of time.
Minimum parent pondered as 457.985 in case of marketplace capitalisation, 25105 in

location of wide variety of personnel and 40653 in case of sales generated in Facebook
organisation (Kokol and Vošner, 2019).
 MAXIMUM: The characteristic denotes the very best digit from the statistics set
organized up to now. It displays a parent of 927.528 this is the largest integer up to now
acquired through the organization in case of Market capitalisation. In case of wide variety
of personnel, it recorded to be 71970 and in segment of sales it depicted an end result of
117929.
Interpretation: It may be interpreted from above calculation and charts displayed that
the business enterprise has represented and pondered a growing scale in computation of
Market capitalisation, it has additionally recorded a fast upward push in sales percent that
commenced from 10. ninety-six and reached a degree of 31.78%. Number of personnel
related to the business enterprise has visible to upward push with each yr and for instantly
5 years the organization has found a boom from yr 2017 until 2021 year the amount
raised from 25105 until 71970 parents. It takes assist of features inclusive of Minimum,
maximum, be counted number and sum. The sales producing great of business enterprise
might assist to rent greater personnel and have interaction greater clients from the
associated marketplace which might determine in increase and growth of commercial
enterprise in a sure duration of time.

CONCLUSION
From the above record it is able to be concluded that there are numerous capabilities and
instructions that each corporation to have an honest concept approximately the Working and
functioning of corporation in associated competitor environment. It is essential for each
enterprise to kind complicated and complex information at one region which could assist to
depict the increase of company over years. It enables to examine its economic role in
marketplace and whether or not it has any aggressive benefit related to the jogging of enterprise.
The record in addition enables the corporation to have a honest concept approximately wherein
the corporation is missing in the back of and the way it is able to discover diverse techniques that
could make contributions in evaluation of consequences introduced thus far. It is essential and
obligatory for each enterprise to recognize wherein the corporation can enhance its associated
operating and performance. It additionally enables to discover approaches along with summation
of information, locating minimum, most determine thus far calculated

REFERENCES
Books and Journals
Bassey, B.A., Owan, V.J. and Eze, E.A., 2019. Nexus between students’, teachers’ and school
system effectiveness: Construction and factorial validity of a measuring
instrument. Bassey, BA, Owan VJ & Eze, EA (2019). Nexus between students’, teachers’
and school system effectiveness: Construction and factorial validity of a measuring
instrument. British Journal of Education, 7(7), pp.62-75.
Bruno, D.E., Barca, E., and Passarella, G., 2018. Linear and evolutionary polynomial regression
models to forecast coastal dynamics: Comparison and reliability
assessment. Geomorphology, 300, pp.128-140.
Chen, M.H., Wylie, G.R., and Genova, H.M., 2020. Neural mechanisms underlying state mental
fatigue in multiple sclerosis: A pilot study. Journal of Neurology, 267(8), pp.2372-2382.
Chertchom, P., 2018, May. A comparison study between data mining tools over regression
methods: Recommendation for SMEs. In 2018 5th International Conference on Business
and Industrial Research (ICBIR) (pp. 46-50). IEEE.
ElMoaqet, H., Ismael, I., and Ryalat, M., 2018, September. Design and integration of an IoT
device for training purposes of industry 4.0. In Proceedings of the 2nd International
Symposium on Computer Science and Intelligent Control (pp. 1-5).
Kokol, P. and Vošner, H.B., 2019. Historical, descriptive and exploratory analysis of application
of bibliometrics in nursing research. Nursing Outlook, 67(6), pp.680-695.
Kramer, E.H., 2020. A close look: Roving reference in a community college library information
common. Reference Services Review.
Myers, M.F., Bergner, A., and Campion, M., 2022. A report of the AGCPD task force to
evaluate associations between select admissions requirements, demographics, and
performance on ABGC certification examination. Journal of genetic counseling, 31(2),
pp.302-315.
Nyeche, E.N. and Diemuodeke, E.O., 2020. Modelling and optimisation of a hybrid PV-wind
turbine-pumped hydro storage energy system for mini-grid application in coastline
communities. Journal of cleaner production, 250, p.119578.

Snyder, H.R., Friedman, N.P. and Hankin, B.L., 2021. Associations between task performance
and self-report measures of cognitive control: Shared versus distinct
abilities. Assessment, 28(4), pp.1080-1096.