Analysis of Facebook's Business Performance using Statistical Techniques in MS Excel

MS Excel

Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
1. Choose the research topic........................................................................................................3
2. Collect the Relevant Raw Rata of Facebook...........................................................................3
3. (i) Calculate the percentage of the data:..................................................................................3
3. (ii) Apply some of the Statistical Techniques:........................................................................4
3. (iii) Apply Auto Sum excel functions:.....................................................................................4
3. (iv) Chart Representation:........................................................................................................5
4. Elaborate the findings and analysis.........................................................................................6
CONCLUSION................................................................................................................................7
REFERENCES................................................................................................................................8

INTRODUCTION
The data collection is a tool for analysing, evaluating and measuring the performance of the
business all over the marketplace. The data could be assimilated for the primary and secondary
data (Cacciatore and et.al., 2018). In this report, the primary data is collected for the company
Facebook. It was established in the year 2004. The data is collected of the 5 years from 2017 to
2021. Further the statistical functions are computed and then the further analysis is made
according to the outcomes of the data.
MAIN BODY
1. Choose the research topic.
The topic chosen for the research is to know about the improvement of business
performance of Facebook. Facebook is a social networking website which was founded in 2004
by mark Zuckerberg. The technology has emerged a new way of living which has made everyone
very use to of the internet services. Google have contributed a lot in helping individual by
solving their problems. Facebook had a monopoly in the market before the new applications
arrived in the market. Now there are various alternatives available in the market that is used to
communicate with each other. It makes life easy of the people by facilitating the conversation of
people with the others (Buchanan, Dorey and Pierce Meyer, 2018).
2. Collect the Relevant Raw Rata of Facebook.
Facebook
Yea
r Market capitalization
Revenu
e 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. (i) Calculate the percentage of the data:
Facebook
Yea Market Market Revenu Revenue( No of No of