Analysis of Netflix's Performance from 2012 to 2020

The report provides a comprehensive analysis of Netflix's performance from 2012 to 2020. It includes statistical analysis, data manipulation techniques, and charts and graphs to present the data in a more understandable way.

A1 MS Excel task

Table of Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
1. Description based on the research topic - Netflix....................................................................3
2. Representation of Raw Data....................................................................................................4
3. Converting the Raw Data into meaningful statistical Techniques...........................................4
4. Data Manipulation Techniques................................................................................................6
5. Data Presentation using Charts and graphs of Netflix:............................................................8
CONCLUSION..............................................................................................................................10
REFERENCES..............................................................................................................................11

INTRODUCTION
According to the following report, the raw data of Netflix are collected and analysed. The
data set is gathered from some online platform and then represent in a suitable framework
(Türegün., 2020). In this report, data are classified into subscribers, profits and speed, and the
total number of profits the company gain occurs. All the data are collected during the period
from 2012 to 2020. In the following report, Research of data, Putting the value of set data in
excel, statistical techniques such as mean, median, and mode, leverage on the excel auto sum
features, graphs and charts, and analysis are explained to display the relevant information.
MAIN BODY
1. Description based on the research topic - Netflix
The following case study topic is related to the American-based streaming services and
production company which is founded on 29 August 1997 and it's known as Netflix Originals.
that has its portal and application which run by the customer on desktops, laptops, and mobiles
after taking subscription on Netflix. It charges some amount on subscription according to the
plan of the customer and the period of such plan is monthly, quarterly and yearly. It offers
movies, series, TV shows, etc. in its application and it also gives facilities in the setup box and
smart TVs. After determining all Netflix activity, they prepared systematic data in a numerical
framework in a spreadsheet and then some statistical techniques like average, median, and mode
are performed for analysing the market conditions. It also performs an activity that represents the
data in graphical presentation for understanding the work easily and timely. The data table are
represented below:
Netflix
Year Profits (Million)
Sales
(Billion)
Speed of
Content
(Billion)
Subscribers
(Million)
2012 $100.00 $7.00 $9.30 $43.00
2013 $456.00 $8.60 $7.50 $51.40
2014 $806.00 $10.80 $6.38 $71.20
2015 $612.00 $13.40 $10.54 $95.80
2016 $758.00 $17.60 $13.76 $125.40
2017 $1,678.00 $23.20 $17.82 $159.80
2018 $1,788.00 $31.40 $24.00 $248.60

2019 $1,986.00 $40.20 $27.80 $303.00
2020 $1,994.00 $49.80 $23.60 $385.80
2. Representation of Raw Data
In the following table data of Netflix are collected from the online source which
represents the company's profits, sales, speed of content, and volume of the subscriber from the
period 2012 to 2020. The data are represented in the form of a table that expresses the data of
Netflix understandable. The data help computes the statistical techniques and leverage the excel
auto sum features (Mwebe, Volante and Weaver., 2020). The table shows the heading of activity
in the topmost row and their related data points are plotted respectively. In the following result,
the accuracy of data is concluded if any type of wrong data has been occurring then the result
automatically hurts. Therefore, the data represented in the below table is collected from valid
sources for carrying forward the research. The following data are represented below in the proper
table form:
3. Converting the Raw Data into meaningful statistical Techniques
The technique which is used for determining the information of the company in
numerical form is called statistical techniques. It is the method that plays an important role in the
field of understanding because it prepares and represents the data in a systematic framework.
After this statistical activity, the company helps make future decisions and is also useful in
maximizing and improving the position and expansion of the business market. These statistical
tools are used by many organizations of expressing the business in meaningful conclusion that
helps the organization in long run for running their business and also in facing the issues. The
important types of statistical tools are mean, median and mode, range, standard deviation, etc.
but generally three types of tools are used by the company that are mean, median, and mode
which is explained below;
Mean: The calculation which shows the average value from the given data set is known
as the Mean. It is a technique that helps the business to work efficiently in respect of central
tendency. There are several steps to compute the mean value:
Step 1: Collect the data from all the sources in a numerical form.
Step 2: Calculate the data points.
Step 3: Add the total number to the data set.

Step 4: As a result, Divide the sum of the total number of data sets by the total number of data
points
In this following report mean is calculated on the Netflix profit, sales, speed of content, and the
total number of subscribers they are earning or expanding in their business. As result, the mean is
calculated from the table data are $1130.89, $22.44, $15.63, and $164.89 respectively. The
average values of Netflix are shows the gaining capacity from the period 2012 to 2020. Mean of
all the selective data helpful in informing the business position and their competitor's market
value.
Median: The median is the tool of statistics that calculates the mid-value from the given
data set. It is also an important and useful tool for measuring the company's performance in such
a way that can be easily understandable and helpful in decision making (Souza, Alves and
Alencar., 2018). The Median is calculated through the following major steps:
Step 1: Represent the data in ascending or descending order.
Step 2: Calculate the total data sets present in a given table.
Step 3: Analyse the Nth term whether odd or even.
Step 4: Put the value formula of median according to the Nth term.
Step 5: If the Nth term is odd then (N + 1) and if even then (N/2).
By analysing the following table, the calculation of median value has resulted in a profit, sales,
speed of content, and the number of the subscriber are $ 806, $ 17.60, $ 13.76, and $ 125.40.
respectively. This median shows that Netflix earned more in the year 2015 and 2016 which
means the Netflix growth is higher in the 4th and 5th years.
Mode: It is the term that is useful for calculating the value which has more probability in
the given datasheet. In simple words, the mode analyses and results in the term which occurs
maximum in the table. The calculation of mode has some steps are as follows:
Step 1: Sort the number in the form of A to Z or Z to A.
Step 2: Determine all the values in a given set.
Step 3: Analyse the number which is continuously occurring.
Step 4: Pick out the higher outcome number as the mode.
By analysing the steps, the calculation of Netflix mode is concluded but as result, it shows that
there is no repetitive value in the whole table of data which means the Mode of Netflix about

profit, sales, speed of content, and several subscribers is Zero that means the company position is
always changing (Messer., 2020).
The following table of Netflix shows the calculation of mean, median and mode with its formula
and screenshot of formula:
Netflix
Year Profits (Million) Sales (Billion)
Speed of
Content
(Billion)
Subscribers
(Million)
2012 $100.00 $7.00 $9.30 $43.00
2013 $456.00 $8.60 $7.50 $51.40
2014 $806.00 $10.80 $6.38 $71.20
2015 $612.00 $13.40 $10.54 $95.80
2016 $758.00 $17.60 $13.76 $125.40
2017 $1,678.00 $23.20 $17.82 $159.80
2018 $1,788.00 $31.40 $24.00 $248.60
2019 $1,986.00 $40.20 $27.80 $303.00
2020 $1,994.00 $49.80 $23.60 $385.80
Application of Statistical Techniques:-
Mean $1,130.89 $22.44 $15.63 $164.89
Median $806.00 $17.60 $13.76 $125.40
Mode #N/A #N/A #N/A #N/A
4. Data Manipulation Techniques
It is the technique that is used by the organization to represent the data systematically and
understandably (Morgado, Palma and da Silva., 2020). There are several types of data
manipulation are present which are used by the companies but the Netflix uses types of data
manipulation that are Minimum, Maximum, Sum, Average, and count about profits, sales, speed
of content, and a number of the subscriber.
Minimum: Minimum is the value that shows the lowest term in the data points. The minimum
value of the numerical data is calculated by the company in MS excel. In Netflix, the lowest
value of all the row data of profit, sales, content speed, and the number of the subscriber are
$100, $7, $6.38, $43 respectively.

It shows that the company needs to improve the work for more gaining.
Maximum: It provides the number which determines the higher number in a given data set. The
maximum number is calculated in excel for easy and fast working. Netflix used this highest term
for analysing the company's capacity and productivity. The maximum value of profit, sales,
speed of content, and the number of the subscriber are $1994, $49.8, $27.8 and
$385.8respectively.
Sum: Sum formula is usually used for calculating the total number presented in a given set
(Khera, Khan and Rahman., 2020). The production company Netflix used this formula for
analysing the total profit, sales, speed of content, and the number of subscribers from the year
2012 to 2020.
Average: The organization calculates the average value based on two or more years' data for
analysing the average income, expenditure, and position of the company. Netflix calculates the
formula average in excel for calculating the mean value of profit, sales, speed of content, and the
number of subscribers.
Count: It is the term that is used to count the total data set in the given information(Domingo-
Carrillo and et.al., 2020). This information is used by Netflix for analysing the row data from the
period 2012 to 2020.
The following table represents all Data Manipulation which describes below:
Netflix
Year
Profits
(Million) Sales (Billion)
Speed of
Content
(Billion)
Subscribers
(Million)
2012 $100.00 $7.00 $9.30 $43.00
2013 $456.00 $8.60 $7.50 $51.40
2014 $806.00 $10.80 $6.38 $71.20
2015 $612.00 $13.40 $10.54 $95.80
2016 $758.00 $17.60 $13.76 $125.40
2017 $1,678.00 $23.20 $17.82 $159.80
2018 $1,788.00 $31.40 $24.00 $248.60
2019 $1,986.00 $40.20 $27.80 $303.00
2020 $1,994.00 $49.80 $23.60 $385.80
Data Manipulation implementation:-
Minimum $100.00 $7.00 $6.38 $43.00
Maximum $1,994.00 $49.80 $27.80 $385.80

Sum
$10,178.0
0 $202.00 $140.70 $1,484.00
Average $1,130.89 $22.44 $15.63 $164.89
Count 9 9 9 9
Data Manipulation implementation
5. Data Presentation using Charts and graphs of Netflix:
Profit Chart
Sales Chart

Speed of Content Chart
Subscribers Chart

CONCLUSION
The above report is prepared on the Company Netflix to analyse its performance from 2012
to 2020. The data has been extracted here from online sources by considering different areas
such as sales figures, profits, subscribers, strategies, content, etc. from 2012 to 2020. After
extracting the data, statistical analysis has been carried out by finding out the mean, median ad
mode of the following data to check the performance of the company, after calculating this,
techniques related to data manipulation have been applied concerning sales, profit, content speed
and subscriber such as maximum, minimum, sum, average and count to organize the given set of
data, resulting in easy to understand the content for users. In the end, graphical presentations in
line chart format has been made to showcase the data of different years for a better comparison.
The purpose of this report is to check the stability of Netflix in the dynamic environment and
after knowing the condition of the company, necessary corrective measures can be applied to
treat the loopholes.

REFERENCES
Books and Journals
Domingo-Carrillo, M.Á and et.al., 2020. Scientific production on revenue management in
tourism on Web of Science and SCOPUS. Current Issues in Tourism, 23(7), pp.880-
905.
Khera, N., Khan, S.A. and Rahman, O., 2020. Valve regulated lead acid battery diagnostic
system based on infrared thermal imaging and fuzzy algorithm. International Journal of
System Assurance Engineering and Management, 11(3), pp.614-624.
Messer, R., 2020. Times Series Forecasting Decisions. In Financial Modeling for Decision
Making: Using MS-Excel in Accounting and Finance. Emerald Publishing Limited.
Morgado, V., Palma, C. and da Silva, R.J.B., 2020. Monte Carlo bottom-up evaluation of global
instrumental quantification uncertainty: Flexible and user-friendly computational
tool. Chemosphere, 258, p.127285.
Mwebe, H.P., Volante, M. and Weaver, T., 2020. Monitoring cardiovascular disease risk in
individuals with severe mental illness in an inpatient mental health setting: a secondary
data analysis. British Journal of Mental Health Nursing, 9(3), pp.1-14.
Souza, R.F.D., Alves, A.D.S. and Alencar, I.G.M.D., 2018. Eventos adversos na unidade de
terapia intensiva. Rev. enferm. UFPE on line, pp.19-27.
Türegün, N., 2020. Does financial crisis impact earnings management? Evidence from
Turkey. Journal of Corporate Accounting & Finance, 31(1), pp.64-71.