Handling and Using ICT for Netflix Performance Analysis

This report discusses the use of ICT techniques for analyzing Netflix's performance from 2012 to 2020. It covers statistical techniques such as mean, median, and mode, and data manipulation techniques such as minimum, maximum, sum, average, and count calculation. The report provides insights on profits, sales, content spend, and subscribers, and includes a presentation of the raw data using charts and graphs.

HANDLING & USING
ICT

Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY...................................................................................................................................3
1.Explanation of the Research Subject under consideration:.................................................3
2.Representation on the raw information:..............................................................................4
3.Implementation of statistical technique on raw information:..............................................4
4.Data manipulation techniques:............................................................................................6
5.Data presentation using charts and graphs:.........................................................................9
CONCLUSION..............................................................................................................................11
REFERENCES..............................................................................................................................12

INTRODUCTION
This report will consist of raw information that has been taken from the online sources and
the topic that has been taken is Netflix. The information so collected has been categorised into
profits, sales, content spend and subscriber that Netflix hold during the period starting from 2012
to 2020. This report includes presentation of the raw data, application of statistical techniques on
the raw information, data manipulation technique and presentation of data in the form of graphs
and charts. This report shall address mean, median, mode calculation on the raw data along with
application of sum, average, count etc. function. The purpose of the statement is to carry out
research analysis on Netflix performance over the period starting from 2012 to 2020. The
statement briefly describes the statistical techniques that have been implemented along with the
interpretation on the performance that has been made. This statement also focusses on improving
the proficiency that has been done on excel workbook on the basis of given information on
Netflix (Ahaiuzu, Nyemezu and Nsirim, 2020).
MAIN BODY
1.Explanation of the Research Subject under consideration:
The development of this assignment is based on the case study related to Netflix which is
an American company engaged in offering streaming service to their users and they charge fees
against such facility. The payment that they receive can been monthly, quarterly or annually
depending upon the plan the subscriber wants to activated. They initially started their business
during august 1997 and at that time they provide services in the form of television series, films
alongside distribution deals etc. and later on they own brand with the name called as Netflix
originals. After takin the information from the internet regarding the Netflix, such data has been
sorted in the systematic order in spreadsheet. Afterword’s the statistical techniques and data
manipulation techniques has been implemented on them to ensure that how they are performing
in the market and whether they are getting advantage against their competitors over such period.
After performing such tools in the systematic way, graphical presentation has been made therein
so that performance can be judged analytically in arrive at the conclusion (Antonopoulos and
et.al., 2019).

2.Representation on the raw information:
The information that has been obtained from the various online sources relating to Netflix
has been collectively gathered and submitted in the workbook so that statistical techniques has
been carried out upon them. The information that has been taken into consideration includes the
sales volume, profit figures, contend spend and subscriber the Netflix have between 2012 to
2020. Such raw information has been arranging in the proper structure and headings has been
bold out along with underlining the same so that it will clearly visible to the user of such
information (Aravindakshan and Sivarajan, 2019). The importance of such data is maximum
because if wrong data has been imported in the statement then accurate and desired results will
not be processed in the form of output. The conclusions made thereon will not be considered as
valid, therefore information that has been used must be obtained from the authentic source to
carry out the research. The data used to carry out on Netflix has been shown in the table below: -
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
3.Implementation of statistical technique on raw information:
Statistical techniques play a vital role in analysing the input in a systematic manner and once
such techniques have been performed than it would help the business to take proper decision
making of the performance of the business and it would also help in making the correct
judgement and improvement that would be needed in future to support the business (Fachal,
Abásolo and Sanz, 2019). Such statistical tools have been implemented by various corporation in
their business so that meaningful results would be obtained that would help the business a lot in
running their operations. The statistical techniques are multiple in the form of mean, median,

mode, correlation, regression, standard deviation etc. but the tools used in this data set is mean,
median and mode and such tools are explained below: -
 Mean:
Mean is considered to be and efficient technique with respect to central tendency and to
calculate the mean the business must collect and compile the data to calculate the same.
The formula of calculating the mean is sum of number of observation divided by number
of observation. In the report mentioned below the mean has been calculated for the profit
earned by the Netflix, sales volume, content spend and the subscriber they are retaining in
their business model. The mean so calculated for the given set of data is $565.44, $11.22,
$7.82 and $82.44 respectively which shows the average profits, sales, contend spend and
subscriber Netflix are gaining during the period starting from 2012 to 2020. The
important fact that can be concluded from the mean arrive shows their capability to build
such strong market base that provides them the competitive gain and support in the
market (Fjørtoft and Berge, 2019).
 Median:
Median is an another statistical tools that supports the business in interpreting the data so
that performance of the business can be judged. Median is considered to be the mid value
which represent the entire data and this will be computed differently in case of even and
odd observations. It is the measure of central tendency and to calculate the median the
data or information must be sorted in ascending and descending order then median is
calculated. In order to calculate the median, if observation is even then the formula used
will be (n+1) / 2 and in case of odd the formula used is (n / 2). The median computed in
case of Netflix data has been $ 8.80, $ 62.70, $ 403, $ 6.88 for profits, sales, content
spend and subscriber which shows in between the 4th and 5th year such profits, sales,
content spend and subscriber are earned by Netflix. Such fourth and fifth year in the
given information would be 2015 and 2016 respectively (Giabelli and et.al., 2020).
 Mode:
It is simply the number which is most repetitive in frequency in the given set of
information. It usually shows those values which are occurred maximum times in
numbers for the input of the organisation. If in case the numbers will not be repeated by
the single times, then mode will be regarded as zero in that case. In case of Netflix data,

the mode bill be zero because no repetition has been made in the sales figures, profit
volume, subscribers they hold and content spend. The data used with respect to Netflix
has been equally divided in term of information used if mode arrived is zero (Ishita,
Ahmed and Leung, 2022). Further it is practically not feasible for the Netflix data to
repeat the mode value because such information is volatile and nature and changes with
the market changes and conditions.
The following table shows the calculation of mean median and mode along with its formula in
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.Data manipulation techniques:
Data manipulation techniques is the process of changing the information or given set of data
so that it will become more organized and readable to the users (Hanafizadeh, Khosravi and
Badie, 2019). The example of such technique would be arranging the information alphabetically

so that useful information will be generated. The data manipulation would of various types such
as moving data around unchanged, implementing arithmetic operation on information, testing the
data and conducting logic operations on the information. The manipulation techniques that has
been used towards Netflix information or data is maximum, minimum, sum, average and count
calculation with respect to sales, profit, content spend and subscriber. The details along with
formula of each of the function mentioned above has been explained below: -
 Minimum:
The minimum formula shows the value which is come to be the lowest in the given set of
data. Such value simply arrives by using the minimum formula in the excel. The
minimum value that is calculated for the sales is $3.50 billion which simply means the
lowest value the Netflix has achieved in between 2012 to 2020. Similarly, this formula
shows the lowest output in terms of profits, subscribers and contend spend that must need
to be improve by them (Kaur, Kumar and Kaushal, 2019).
 Maximum:
The maximum formula is helpful in calculating the highest figures that has been achieved
by the business that needs to be maintain in the long run so that goals and objective of the
entity can be achieved. In the given data of Netflix, the lowest performance in judged by
the use of such formula. The minimum sales volume is $3.50 billion, similarly their
lowest profits, subscriber, and content spend is $50, $3.19 and $21.50 respectively which
needs to be improved in by the company so that complete utilization of business assets
will be made and performance can be improved in the market.
 Sum:
The sum formula has been used to simply add on the value that has been given in the
data. By applying this formula total has been arrived of all the value. The sum of the
Netflix information will give the business the total sales volume they achieved between
2012 to 2020. Similarly, the profits, content spend and subscribers in total has been
calculated using them (Ma and Qin, 2021).
 Average:
The average function is used to calculate the average of the given numbers or data set.
The purpose of calculating the excel is to calculate the centre value or the mean. The

average sales value of the Netflix during 2012 to 2020 to $11.22. Similarly, the average
profits, content spend and subscriber are $565.44, $7.82 and 82.44 respectively.
 Count:
The count is used to count the number of values given in the information which is arrived
to be 9 in case of sales, profit, contend spend and subscriber which is because the data
used for Netflix has been between 2012 to 2020 (Mohamed, Al-Jaroodi and Jawhar,
2020).
The table mentioned below shows application of such techniques along with 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.Data presentation using charts and graphs:
The representation in charts helps the business in analysing the data in a systematic way and
it also makes the document more presentable. The following is the pictorial presentation of
profits, sales, content spend and subscribers of the Netflix: -
 Profits: This graph represent the profits earned by Netflix during 2012 to 2020 which is
in increasing order over such period shows that they are performing well efficiently and
becoming the market leader in their respective industry.
 Sales: Similar to the profits figures their sales volume are also increasing over the period
of time simply states that they are effectively utilising their resources and gaining
maximum benefit from the assets they are using towards achieving the business goals
(Olubowale, 2019).

 Content Spend: The maximum content gain they are gaining in 2018 to 2020 because
during that period mobile usage and OTT platform has been increased worldwide. That’s
why the business mode Netflix has been using is gaining popularity amongst generation
(Park, Liu and Headrick, 2020).
 Subscribers: The rate of annual subscribers is increasing at the rapid speed which simply
shows that they are capturing the market at the fast rate and also satisfying their customer
with the content they providing (Sezer and Bröchner, 2019).

CONCLUSION
This report contains the research topic relating to the Netflix and for analysing their
performance the raw data has been extracted using the online sources so that their performance
can be judged accordingly. The main category for analysing their performance is the sales
figures, profits they made, subscribers they hold and their content spend during the period
starting from 2012 to 2020. After extracting such data, statistical analysis has been carried out on
such data in the form of calculation of mean, median, and mode. After calculating the same, data
manipulation techniques have been performed which includes maximum, minimum, count,
average and sum function which is performed in excel. After performing such statistical tools on
the Netflix data interpretation and conclusion has been made so that their performance can be
checked. At the end of this statement graphical presentation has been made for such in various
bar charts so that proper comparative study can be done. The purpose of such statement is to
check the accuracy of the Netflix in the changing environment so that their competitor
performance can be judged accordingly and if they are not performing well during such years
then appropriate suggestion has been made to them so that loopholes will be fulfilled
accordingly.

REFERENCES
Books and Journals
Ahaiuzu, B.E., Nyemezu, C.O. and Nsirim, O., 2020. Assessment of ICT Skills of LIS Educators
for the Adoption of Blended Learning in Rivers State, Nigeria. Information
Impact: Journal of Information and Knowledge Management, 11(3), pp.51-62.
Antonopoulos, C.P and et.al., 2019. Tackling Critical Challenges towards Efficient
CyberPhysical Components & Services Interconnection: The ATLAS CPS
Platform Approach. Journal of Signal Processing Systems, 91(11), pp.1273-1281.
Aravindakshan, J. and Sivarajan, K.N., 2019. CSI Wireless Special Issue: Overview. CSI
Transactions on ICT, 7(1), pp.1-2.
Fachal, A.S., Abásolo, M.J. and Sanz, C.V., 2019, October. Experiences in the use of ICT and
digital ramps for students in tertiary education with visual or hearing impairment.
In Argentine congress of computer science (pp. 369-388). Springer, Cham.
Fjørtoft, K. and Berge, S.P., 2019. ICT for sustainable shipping. In Sustainable Shipping (pp.
137-166). Springer, Cham.
Giabelli, A. and et.al., 2020. GraphLMI: A data driven system for exploring labor market
information through graph databases. Multimedia Tools and Applications, pp.1-30.
Hanafizadeh, P., Khosravi, B. and Badie, K., 2019. Global discourse on ICT and the shaping of
ICT policy in developing countries. Telecommunications Policy, 43(4), pp.324-
338.
Ishita, S.Z., Ahmed, C.F. and Leung, C.K., 2022. New approaches for mining regular high utility
sequential patterns. Applied Intelligence, 52(4), pp.3781-3806.
Kaur, P., Kumar, H. and Kaushal, S., 2019, December. Competitive Examinations in India: e-
Assessment Based Case Study. In 2019 IEEE Tenth International Conference on
Technology for Education (T4E) (pp. 162-165). IEEE.
Ma, Y. and Qin, X., 2021. Measurement invariance of information, communication and
technology (ICT) engagement and its relationship with student academic literacy:
Evidence from PISA 2018. Studies in Educational Evaluation, 68, p.100982.
Mohamed, N., Al-Jaroodi, J. and Jawhar, I., 2020, July. Opportunities and challenges of data-
driven cybersecurity for smart cities. In 2020 IEEE Systems Security Symposium
(SSS) (pp. 1-7). IEEE.

Olubowale, D., 2019. Effect of ICT Skills and Accessibility of Learners on Learning
Mathematics Education in Open and Distance Learning Education. Available at
SSRN 3931489.
Park, Y., Liu, Y. and Headrick, L., 2020. When work is wanted after hours: Testing weekly
stress of information communication technology demands using boundary
theory. Journal of Organizational Behavior, 41(6), pp.518-534.
Sezer, A.A. and Bröchner, J., 2019. Site managers’ ICT tools for monitoring resources in
refurbishment. Engineering, Construction and Architectural Management.
Tatnall, A., 2020. Technological innovation in ICT for education. Encyclopedia of education and
information technologies, pp.1692-1705.