Analysis of Netflix Performance from 2012 to 2020

This report analyzes Netflix's performance from 2012 to 2020 using raw statistics, statistical methods, and data manipulation techniques. Mean, median, and mode calculations were performed on profits, sales, content spend, and subscribers. The report also includes graphical representations of the data.

MS EXCEL TASK

Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY...................................................................................................................................3
1.Explanation of the Research Subject:..................................................................................3
2.Portrayal on the Raw Statistics:...........................................................................................3
3.Submission of Statistical Method on Raw Statistics:..........................................................4
4.Statistics Management Methods:.........................................................................................5
5.Statistics Demonstration using Maps and Tables:...............................................................7
CONCLUSION..............................................................................................................................10

INTRODUCTION
This report will encompass raw facts that has been taken from the internet reasserts and the
concern that has been taken is Netflix. The facts so amassed has been categorised into profits,
sales, content material cloth spend and subscriber that Netflix preserve at some stage in the
length starting from 2012 to 2020. This report includes presentation of the raw facts, software of
statistical techniques on the raw facts, facts manipulation approach and presentation of facts
withinside the form of graphs and charts. This report shall deal with mean, median, mode
calculation on the raw facts on the aspect of software of sum, average, do not forget etc. function
(Bruno, Barca, and Passarella, 2018).
MAIN BODY
1.Explanation of the Research Subject:
The development of this assignment is based definitely on the case have a look at related to
Netflix that is an American business enterprise engaged in presenting streaming company to their
clients and they fee expenses in the direction of such facility. The price that they get preserve of
can been monthly, quarterly or every year depending upon the plan the subscriber wants to
activated. They to start with started out their business corporation all through august 1997 and at
that factor they provide services withinside the form of television series, films alongside
distribution gives etc. and in some time they non-public logo with the decision referred to as
Netflix originals.
2.Portrayal on the Raw Statistics:
The data which have been received from the numerous on-line reasserts relating to Netflix
has been collectively gathered and submitted withinside the workbook just so statistical
techniques were achieved upon them. The importance of such facts is maximum because of the
truth if wrong facts has been imported withinside the statement, then accurate and favoured
effects will now not be processed withinside the form of output (Chen, Wylie, and Genova,
2020). The conclusions made thereon will now not be considered as valid, therefore data that has
been used have to be received from the real deliver to carry out the research. The facts used to
carry out on Netflix has been confirmed withinside the table below: -
Netflix
Year Profits Sales Content Spend Subscriber

(Million) (Billion) (Billion) (Million)
2012 $50.00 $3.50 $4.65 $21.50
2013 $228.00 $4.30 $3.75 $25.70
2014 $403.00 $5.40 $3.19 $35.60
2015 $306.00 $6.70 $5.27 $47.90
2016 $379.00 $8.80 $6.88 $62.70
2017 $839.00 $11.60 $8.91 $79.90
2018 $894.00 $15.70 $12.00 $124.30
2019 $993.00 $20.10 $13.90 $151.50
2020 $997.00 $24.90 $11.80 $192.90
3.Submission of Statistical Method on Raw Statistics:
Statistical techniques play an important feature in analysing the input in a systematic
manner and as quickly as such techniques have been done than it'd help the employer to take
proper choice making of the general overall performance of the employer and it'd moreover help
in making the proper judgement and improvement that would be wanted in future to resource the
employer. Such statistical gadget has been done with the resource of the use of several
organizations in their employer just so giant results is probably obtained that would help the
employer plenty in running their operations (ElMoaqet, Ismael, and Ryalat, 2018).
The statistical techniques are a couple of withinside the form of mean, median, mode,
correlation, regression, brand new deviation etc. but the gadget used on those data set is mean,
median and mode and such gadget are described below:
 Mean: Mean is considered to be and inexperienced method with respect to foremost
tendency and to calculate the endorse the employer want to accumulate and bring
together the data to calculate the same. The technique of calculating the endorse is sum of
extensive kind of observations divided via extensive kind of observations.
 Median: Median is another statistical tool that facilitates the employer in decoding the
data just so standard overall performance of the employer can be judged. Median is
considered to be the mid-fee which represent the entire data and this can be computed in
any other case in case of even and peculiar observations.
 Mode: It is in reality the extensive range this is most repetitive in frequency withinside
the given set of information. It typically shows those values which may be occurred
maximum times in numbers for the input of the organisation. If in case the numbers will

now not be repeated via the single times, then mode is probably regarded as zero in that
case.
The following table shows the calculation of endorse median and mode collectively with its
technique withinside the form of screenshot:
Year Profits (Million) Sales (Billion) Content Spend (Billion) Subscriber(Million)
2012 $50.00 $3.50 $4.65 $21.50
2013 $228.00 $4.30 $3.75 $25.70
2014 $403.00 $5.40 $3.19 $35.60
2015 $306.00 $6.70 $5.27 $47.90
2016 $379.00 $8.80 $6.88 $62.70
2017 $839.00 $11.60 $8.91 $79.90
2018 $894.00 $15.70 $12.00 $124.30
2019 $993.00 $20.10 $13.90 $151.50
2020 $997.00 $24.90 $11.80 $192.90
Application of Statistical Techniques:-
Mean $565.44 $11.22 $7.82 $82.44
Median $403.00 $8.80 $6.88 $62.70
Mode #N/A #N/A #N/A #N/A
Screen shot of the Formulas used in Statistical Techniques: -
4.Statistics Management Methods:
Data manipulation techniques is the method of changing the facts or given set of data simply so
it will become extra organized and readable to the users.
 Minimum: The minimum method indicates the price this is become the lowest withinside
the given set of data. Such price certainly arrives with the resource of the usage of using
the minimum method withinside the excel (Kokol and Vošner, 2019). The minimum
price that is calculated for the earnings is $3.50 billion which certainly manner the lowest
price the Netflix has completed in amongst 2012 to 2020.

 Maximum: The maximum method is beneficial in calculating the first-class figures that
has been completed with the resource of the usage of the agency that desires to be keep
ultimately simply so desires and aim of the entity can be completed.
 Sum: The sum method has been used to certainly add on the price that has been given
withinside the data. By utilizing this method trendy has been arrived of all the price. The
sum of the Netflix facts will supply the agency the whole earnings volume they
completed amongst 2012 to 2020.
 Average: The not unusual place characteristic is used to calculate the not unusual place
of the given numbers or data set. The reason of calculating the excel is to calculate the
centre price or the mean (Muneer and Ivanova, 2022).
 Count: The depend is used to depend the type of values given withinside the facts this is
arrived to be 9 in case of earnings, profit, contend spend and subscriber this is because of
the reality the data used for Netflix has been amongst 2012 to 2020.
The table said underneath indicates software of such techniques alongside screenshot of the
formulae used to calculate the solution: -
Netflix
Year
Profits
(Million)
Sales
(Billion)
Content Spend
(Billion) Subscriber(Million)
2012 $50.00 $3.50 $4.65 $21.50
2013 $228.00 $4.30 $3.75 $25.70
2014 $403.00 $5.40 $3.19 $35.60
2015 $306.00 $6.70 $5.27 $47.90
2016 $379.00 $8.80 $6.88 $62.70
2017 $839.00 $11.60 $8.91 $79.90
2018 $894.00 $15.70 $12.00 $124.30
2019 $993.00 $20.10 $13.90 $151.50
2020 $997.00 $24.90 $11.80 $192.90
Data Manipulation
implementation:-
Minimum $50.00 $3.50 $3.19 $21.50
Maximum $997.00 $24.90 $13.90 $192.90
Sum $5,089.00 $101.00 $70.35 $742.00
Average $565.44 $11.22 $7.82 $82.44
Count 9 9 9 9

Screen shot of the Formulas used in Data Manipulation:
5.Statistics Demonstration using Maps and Tables:
The example in charts lets in the industrial employer in analysing the records in a systematic
way and it moreover makes the report greater presentable. The following is the pictorial
presentation of profits, profits, content material cloth spends and subscribers of the Netflix:
 Profits: This graph represent the profits earned through manner of method of Netflix all
through 2012 to 2020 this is in developing order over such duration shows that they may
be acting properly efficiently and becoming the market leader in their respective Industry
(Myers, Bergner, and Campion, 2022).
.
 Sales: Similar to the earnings figures their earnings quantity are also developing over the
timeframe without a doubt state that they may be efficaciously the usage of their
belongings and gaining maximum experience the belongings they may be using
withinside the route of achieving the economic organisation goals.

.
 Content Spend: The maximum content material fabric gain they may be gaining in 2018
to 2020 because of the truth all through that period molecular usage and OTT platform
has been extended worldwide. That’s why the industrial employer mode Netflix has been
using is gaining popularity amongst generation (Szalma, 2019).
 Subscribers: The rate of annual subscribers is developing at the rapid tempo which
actually indicates that they may be taking photographs the market at the fast rate and

moreover enjoyable their consumer with the content material fabric they providing
(Nyeche and Diemuodeke, 2020).

CONCLUSION
This document includes the research situation count concerning the Netflix and for
analysing their normal overall performance the raw information has been extracted the use of the
internet reasserts just so their normal overall performance can be judged accordingly. The
important magnificence for analysing their normal overall performance is the earnings figures,
earnings they made, subscribers they preserve and their content material fabric spend sooner or
later of the duration starting from 2012 to 2020. After extracting such information, statistical
assessment has been completed on such information withinside the form of calculation of mean,
median, and mode. After calculating the same, information manipulation techniques have been
done which includes maximum, minimum, count, not unusual place and sum function it is done
in excel. After acting such statistical device on the Netflix information interpretation and stop
has been made just so their normal overall performance can be checked.

REFERENCES
Books and Journals
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.
ElMoaqet, H., Ismael, 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.
Muneer, T. and Ivanova, S., 2022. Artificial Neural Networks in Excel. In Excel-VBA (pp. 143-
162). Springer, Cham.
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
Neigel, A.R., Claypoole, V.L. and Szalma, J.L., 2019. Effects of state motivation in overload
and underload vigilance task scenarios. Acta psychologica, 197, pp.106-114.
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.