Data Analysis of Netflix Sales Revenue (2011-2020) Using MS Excel

This assignment delves into the analysis of Netflix's sales data from 2011 to 2020 using MS Excel. It begins with an understanding of data evaluation and its significance in strategic decision-making. The assignment presents raw sales revenue data, followed by the application of statistical techniques such as mean, mode, and median to derive meaningful insights. Data manipulation techniques, including calculations of average, sum, count, maximum, and minimum values, are then employed to further refine the data. Finally, the assignment emphasizes the representation of data through charts to visualize trends and patterns in Netflix's revenue growth over the specified period. The conclusion highlights the importance of data analysis in business and summarizes the key aspects covered in the report.

MS Excel Task

TABLE OF CONTENTS
UNDERSTANDING OF TOPIC.....................................................................................................1
MAIN BODY...................................................................................................................................1
Presentation of raw Data .......................................................................................................1
Presenting statistical techniques.............................................................................................2
Data Manipulation..................................................................................................................2
Representations of chart.........................................................................................................4
CONCLUSION ...............................................................................................................................4
REFERENCES................................................................................................................................5

UNDERSTANDING OF TOPIC
Data evaluation is one of the crucial practice that is taken into the consideration by the
organization for obtaining significant practice of assessing the available information so that
accomplishing the objective of strategic decision formulation can become possible. Present
working scenario is highly competitive which require firm to possess effective approach of
having appropriate data analysis in turn meeting the overall competitiveness to get higher
productivity via making relevant decision which can contribute in overall development of
enterprise. Recent report is based on Netflix that is one of the successful firm in the current era
that offers different types of entertainment service such as series, movies, etc. access to target
audience. Current investigation will have emphasized on having information regarding the sales
revenue of the 10 consecutive years. It will focus on presenting the raw data, utilizing statistical
technique, having data manipulation and presenting data in the chart format.
MAIN BODY
Presentation of raw Data
Raw data is basically related with the information which has not been processes for use
(Mölder and et.al., 2021). The below presented table is regarding the raw data which is
concerned with Netflix’s sales revenue that is shown for the 10 continuous year. Sales revenue
generated for the specified 10 years will be taken into the process for analysis in turn crucial
information to get deeper insights can be articulated.
Year Sales revenue
(Billions)
2011 3.1
2012 3.5
2013 4.3
2014 5.4
2015 6.7
2016 8.8
2017 11.6
2018 15.7
2019 20.1
2020 24.9
1

Presenting statistical techniques
Statistical techniques are related with using the appropriate tools in order to evaluate the
data in highly effective manner. Mean, mode and median are the crucial statistical technique
which are taken into the process for evaluation of the data.
Year Sales revenue
(Billions)
2011 3.1
2012 3.5
2013 4.3
2014 5.4
2015 6.7
2016 8.8
2017 11.6
2018 15.7
2019 20.1
2020 24.9
Mean 10.41
Mode 0
Median 7.75
Mean is one of the significant technique of statistics which is taken into the process for
evaluating average revenue generated by the specified organization for the particular duration.
For the able table excel function of average has been taken into the consideration that is
indicating that 10.41 billion is generated averagely for the ten years from 2011 to 2020.
Mode refers to the higher number of the frequency which has occurred in the specified
period (TIETZ and CAINAS, 2021). In the current case, there is different revenue amount is
generated which helps in evaluating that there is no repeating of the same revenue amount which
is indicating the absence of mode value. This is basically calculated by using the mode function
in the excel that Is equals to array of numbers so that required value can be derived.
Median is major technique that is related with having the appropriate analysis of the data by
assessing the middle value of the data. This is calculated by using excel function which
comprises = median(number of array). The computed figure is 7.75 billions.
Data Manipulation
It is the process of adjusting data in order to get the appropriate level of the ability to
organize the data in turn accomplishing the objective of easy to read (Bernard and Senjayawati,
2019). This permits ability to ascertain the crucial information which is highly required for the
2

purpose of decision-making. It is exerted by focusing on the inserting, deleting and modifying
data base in turn meeting the overall functioning of the organization can be evaluated.
Year Sales revenue
(Billions)
2011 3.1
2012 3.5
2013 4.3
2014 5.4
2015 6.7
2016 8.8
2017 11.6
2018 15.7
2019 20.1
2020 24.9
Average 10.41
Sum 104.1
Count 10
Max 24.9
Min 3.1
Average is related with gaining the crucial insights about the centric value that is
obtained by dividing the number of values to the total (Miles, Huberman and Saldaña, 2018). In
the current investigation is concerned with total of the provided period's sales revenue and
dividing by the number of years. The obtained information is 10.41 billion. The sum of the
overall sales revenue has been derived by having auto sum formula into the consideration. The
total of the overall sales revenue is 104.1 billion. Count is another crucial function that is helpful
in gaining the significant information 10 number of years. Max is concerned the maximum value
of the revenue generation so that accomplishing the organizational objectives of assessing how
much revenue can be generated. This can be specified from the above table that max sales
revenue in billions is 24.9 whereas minimum is concerned with 3.1 billions.
3

Representations of chart
From the above provided information in the graphical presentation of the sales revenue
it can be interpreted that there is inclination trend in the overall performance of the company is
derived. With help of the pictorial presentation it can be mentioned that different years have
generated distinct revenue which is depicting that in the year 2011 the revenue generated is 3.1
billion and in period of 2020 the revenue generated is 2020 which tends to show that how
effectively improvement has been taken into the consideration. In addition to this, it can be
mentioned that firm has paid attention on achieving reliable level of growth in the current time
as compared to the previous which depicts that how effectively firm is gaining development to
accomplish the overall performance.
CONCLUSION
From the above report it can be concluded that data analysis is crucial in the current time
which tends to specify the major aspects that are required to be taken into the process so that
accomplishing reliable productiveness in the business can be achieved. The current study has
given emphasis on presenting the raw data of sales revenue of the selected case regarding
Netflix. The statistical techniques such as mean, mode and median are basically taken into the
consideration. Present report has involved manipulation of selected data set so that
accomplishing the objective of ascertaining data in corrective manner can become possible and
graphical presentation has been taken into the process for deeper insights.
4

REFERENCES
Books and Journals
Bernard, M. and Senjayawati, E., 2019. Developing the students’ ability in understanding
mathematics and self-confidence with VBA for Excel. JRAMathEdu (Journal of Research
and Advances in Mathematics Education. 4(1). pp.45-56.
Miles, M. B., Huberman, A. M. and Saldaña, J., 2018. Qualitative data analysis: A methods
sourcebook. Sage publications.
Mölder, F. and et.al., 2021. Sustainable data analysis with Snakemake. F1000Research, 10.
TIETZ, W. and CAINAS, J. M., 2021. EXCEL. Strategic Finance.
5