Data Analysis and Interpretation: Facebook User Growth 2011-2021

This report presents a comprehensive analysis of Facebook user growth from Q1 2011 to Q4 2021. It includes raw data presentation, statistical techniques such as mean, mode, and median, and data manipulation using AutoSum features (sum, average, count, max, min) and percentage formulas. The analysis interprets the increasing trend in Facebook users, highlighting factors contributing to this growth, such as innovative features and user-friendly interface. The report concludes that Facebook's user base has consistently risen since its inception, with specific figures provided for key statistical measures. Charts and graphical representations support the data analysis.

SUMMATIVE
ASSESSMENT 01 FOR THE
DHICT MODULE

Table of Contents
INTRODUCTION...........................................................................................................................3
Brief description about the data...................................................................................................3
MAIN BODY..................................................................................................................................3
Raw data presentation..................................................................................................................3
Statistical techniques...................................................................................................................4
Interpretation................................................................................................................................5
Data manipulation........................................................................................................................5
Manipulation of data using the auto sum feature.........................................................................5
Manipulation of data using percentage formula..........................................................................7
Interpretation................................................................................................................................7
CONCLUSION................................................................................................................................9
REFERENCES..............................................................................................................................10

INTRODUCTION
Brief description about the data
The process of examining, cleaning, altering and demonstrating data with an objective of
determining important information, finding conclusions and formulate important decisions. The
present report is based on the case study of Facebook and the raw data that is collected represents
the number of users of Facebook from the quarter 1 of the year 2011 to the quarter 4 of the year
2021. The report also includes the change in the number of active users of Facebook over a
period of time. The current report is based on the percentage, graphs and formation of charts in
order to interpret the statistically.
MAIN BODY
Raw data presentation
Quarters (2011 to 2021) Number of users (in millions) Percentage
Q1 2011 372 1%
Q2 2011 417 1%
Q3 2011 457 1%
Q4 2011 483 1%
Q1 2012 526 1%
Q2 2012 552 1%
Q3 2012 584 1%
Q4 2012 618 1%
Q1 2013 665 1%
Q2 2013 699 1%
Q3 2013 728 1%
Q4 2013 757 1%
Q1 2014 802 2%
Q2 2014 829 2%

Q3 2014 864 2%
Q4 2014 890 2%
Q1 2015 936 2%
Q2 2015 968 2%
Q3 2015 1007 2%
Q4 2015 1038 2%
Q1 2016 1090 2%
Q2 2016 1128 2%
Q3 2016 1179 2%
Q4 2016 1227 2%
Q1 2017 1284 2%
Q2 2017 1325 3%
Q3 2017 1368 3%
Q4 2017 1401 3%
Q1 2018 1449 3%
Q2 2018 1471 3%
Q3 2018 1495 3%
Q4 2018 1523 3%
Q1 2019 1562 3%
Q2 2019 1587 3%
Q3 2019 1623 3%
Q4 2019 1657 3%
Q1 2020 1734 3%
Q2 2020 1785 3%
Q3 2020 1820 4%
Q4 2020 1845 4%
Q1 2021 1878 4%
Q2 2021 1908 4%
Q3 2021 1930 4%
Q4 2021 1929 4%
Statistical techniques
Mean 1167.954545
Mode #N/A
Median 1153.5

Interpretation
Mean
Mean indicates the average of the current data set. From the calculations made, it is
analysed that there are around 1153.5 million people all over the world who are the active users
Facebook and uses the Facebook on a regular basis (Claudia, Leogrande, and Manca, 2020).
Mode
Another tool that is used for the purpose of statistical analysis is Mode. With the use of
Mode, raw data can easily be converted in to meaningful information. Mode is the most observed
value in a particular data set. However, the current data set do not have any mode. This means
that there are not a specific number of users of Facebook that are constantly repeating the given
data set.
Median
Median is tool of statistics which helps in determining the middle value of a data set
when arranged in ascending order. From the analysis of the data, it has been identified that the
median value of the current data set is 1167.954545 million. This represents the middle value of
the users of the users of Facebook (Dean, and Illowsky, 2018).
Data manipulation
Manipulation of data using the auto sum feature
AutoSum Features
Sum 51390

Average 1167.954545
Count 44
Max 1930
Min 372
Interpretation
Sum
Sum is that value of a data set that is received after adding all the value of a data set.
After analysing the above stated information, it has been determined that the total number of
users of Facebook are about 51390 million all over the world. This figure has been determined as
a result of adding all the users starting from the quarter 1 of the 2011 to the quarter 4 of the 2021.
Average
Average can be understood as the mean that was identified for the purpose of converting
the raw data into the useful information. It is a measure of central tendency which helps in
determining the average value of the data set (Kosmidis, Kenne Pagui,. and Sartori, 2020). From
the above calculation, it can be stated that the average number of users of Facebook on a regular
basis all over the world is 1167.95454 million.
Count
Count can be defined as the total number of observations that are going to be considered
for the purpose of converting the raw data in to the formation of useful information. It is
generally in order to quantify the data. From the above data, it has been determined that there a

total 44 observations which have been considered for the purpose of calculating the necessary
information. The 44 observations that have been considered are a result of the data that is
collected starting from the Quarter 1 of the year 2011 till the quarter 4 of the year 2021.
Max
This is an auto sum feature that is used to state the highest value present within the whole
data set. On the basis of the above analysis, it has been observed that the highest value within the
data set that is the maximum value of Facebook users till now is 1930 million.
Min
Another feature of the auto sum in Min feature. It is used for the purpose determining the
lowest value from the whole data set. On the basis of interpretation, it has been determined that
the lowest value from the whole data is 372 million. This states that the minimum number of
people who uses the Facebook on a daily basis is 372 million (Moriarty, Held, and Richardson,
2018).
Manipulation of data using percentage formula
Interpretation
As per the observations made on the data set, it has been determined that the number of
users that the company had in the year in which it initiated its business operations were 372

million. Currently, Facebook has a number of around 1929 million users which use the Facebook
On a regular basis. The number of users that have rose in the list of users of Facebook from the
year 2011 to the year 2021 is humungous i.e., 1557 million users all over the world. This means
that the Facebook has gained a lot of popularity among the target audience which has led to this
huge increase in the number of users of the company (Zhou, 2022). There are a number features
that is constantly increasing the growth of the company, it includes innovative features,
connectivity, easy to use user interface, constant upgrades and many more. Moreover, the team
of Facebook is constantly working towards engaging the current users and attracting new
customers towards the brand.
Representation
The present data represents the number of active users of Facebook starting from the
quarter 1 of the 2011 till the quarter 4 of the year 2021. On the basis of the interpretations made,
it can be determined that the number of users of Facebook has constantly rose ever since the
company has been launched in the market (Zhou,). In the quarter 1, the number of users of
Facebook were recorded to be 372 million and in the year 2021, quarter 4, the users of Facebook

have been recorded as 1929 million. This states the ability of Facebook to attract new customers
towards the brand.
CONCLUSION
Based on the observations made above, it can be stated the number of users of Facebook
starting from the year in which the company has been launched in the market have constantly
rose. The current study has been able to determine the figures with respect to the mean, mode
and median of the Facebook i.e., 11.53 million, N/A and 1167.95454 respectively. There has
been made use auto sum features for the purpose of conducting manipulation of the raw data
which includes sum, average, count, min, and max. The report has covered all the necessary
charts and graphical representation of the data set with respect to the users of the Facebook.

REFERENCES
(books and Journal)
Claudia, M., Leogrande, D. and Manca, F., 2020. The Mean Deviation from the Median of the
Dagum Distribution. Applied Mathematics. 11(10). pp.951-956.
Dean, S. and Illowsky, B., 2018. Descriptive statistics: skewness and the mean, median, and
mode. Connexions website.
Kosmidis, I., Kenne Pagui, E.C. and Sartori, N., 2020. Mean and median bias reduction in
generalized linear models. Statistics and Computing. 30(1). pp.43-59.
Moriarty, B., Held, B. and Richardson, T., 2018. Microsoft excel functions and formulas. Stylus
Publishing, LLC.
Zhou, H., 2022. PivotTable Data Analysis. In Mastering Excel Through Projects (pp. 169-201).
Apress, Berkeley, CA.
Zhou, H., Mastering Excel Through Projects.