Manipulating Raw Data with Excel: A Case Study on Facebook

MS EXCEL TASK

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.................................................................................4
4. Briefly describe assessment and findings carried out.............................................................4
CONCLUSION ...............................................................................................................................5
REFERENCES................................................................................................................................7

INTRODUCTION
The report prepared under takes a related research topic on Facebook which helps to find
out average of data collected, mid value of series prepared and revenue generated by the firm for
a period of over 5 years. Facebook is also known as 'Meta' that is a social media platform helpful
in building techniques that is useful for connecting people from all over the world. The report
includes market capitalisation, number of employees engaged with firm, revenue generated by
the company and its related percentages as well. The report counts commands such as Maximum,
Minimum, Count and Sum as well (Xiong, 2020).
TASK
1. Choose one research topic from provided list.
The topic chosen in prepared report is Facebook. The document carried out takes in
account searching various paths for managing data and sorting it in a precise manner. It behaves
as a guiding tool for computation of revenue earned by a firm for over 5 years counted from
2017 to 2021. Research topic explains the working of firm and the quantity of profit that has
been earned by a firm so far. It is helpful in understanding what can be interpreted and concluded
from the report prepared above. It thus takes in account explanation and usage of such terms in
related companies.
The research content selected for finding is Facebook. It will explain if the tools chosen would
be useful in improving the performance that is associated with company. There are many
purposes that are linked for better functioning of organisation and which also help to maintain
inventory level within a enterprise. It is important that the company is able to connect more and
more people over a period of time. There are many sources that help in better working of
companies in a competitive environment and which would in cutting of costs, reducing risk and
increasing profitability ratios. For increasing efficiency and effective the firm must search for
reasons which would assess and contribute in doing so. There are many methods that would
contribute in a qualitative and quantitative aspects in case of companies wanting to know the
reasons behind lacking in work and lagging behind in competitive business environment.
Extracting data related to market capitalisation, revenue and number of users.
 Collecting primary base data: It states that the information that is collected by
business or any related party is fresh and new. It further explains that data which

is not being used by any other organisation till date. Thus such sort of data is
useful as it helps to reduce the amount of risk involved and decline in number of
errors as well. It is considered more accurate and reliable when compared with
other sources of data used by any enterprise. Manipulation of information is not
possible in such cases thus decisions taken would be fruitful for company in near
future (Rowan, Kartal and Hadidian, 2019).
 Collecting data from secondary sources: There are books, articles, reports,
surveys and questionnaire that are being used by the company for taking decisions
that would serve the business in right manner at right time. It further is useful
because the data is analysed and collected by superiors. It has been used several
times thus the dataset can result to be obsolete but contains no error or fraud. It
is helpful when the company faces same issues being countered by other firms as
well it helps them to apply and adapt various methods.
2. Acquire applicable raw data for analysis and sampling.