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.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
MS EXCEL TASK
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
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: Thedevelopmentof thisassignmentisbaseddefinitelyon thecasehave a look atrelated to Netflixthat isan Americanbusiness enterpriseengaged inpresentingstreamingcompanyto their clientsand theyfeeexpensesin the direction ofsuch facility. Thepricethat they getpreserveof can been monthly, quarterly orevery yeardependingupon the plan the subscriberwants to activated. Theyto start withstartedout theirbusinesscorporationall throughaugust 1997 and at thatfactortheyprovideserviceswithinside theformoftelevisionseries,filmsalongside distributiongivesetc. and insome timetheynon-publiclogowiththe decisionreferred to as Netflix originals. 2.Portrayal on the Raw Statistics: Thedatawhich have beenreceivedfrom thenumerouson-linereassertsrelating toNetflix hasbeencollectivelygatheredandsubmittedwithinsidetheworkbookjustsostatistical techniqueswereachievedupon them. Theimportanceof suchfactsismaximumbecause ofthe truthifwrongfactshas been imported withinside the statement, thenaccurateand favoured effectswill nownotbe processed withinside theformof output(Chen, Wylie, and Genova, 2020). The conclusions made thereon will nownotbeconsideredas valid,thereforedatathat has been usedhave tobereceivedfrom therealdelivertocarry outthe research. Thefactsused to carry outon Netflix has beenconfirmedwithinside thetablebelow: - Netflix YearProfitsSalesContent SpendSubscriber
(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: Statisticaltechniquesplay animportantfeaturein analysing theinputina systematic mannerand asquicklyas suchtechniqueshave beendonethanit'dhelptheemployerto take properchoicemaking ofthe generaloverall performanceof theemployerandit'dmoreoverhelp in makingthe properjudgement andimprovementthat wouldbewantedinfuturetoresourcethe employer. Such statisticalgadgethas beendonewith theresourceofthe use ofseveral organizationsin theiremployerjust sogiantresultsis probablyobtainedthat wouldhelpthe employerplentyinrunningtheir operations(ElMoaqet, Ismael, and Ryalat, 2018). Thestatisticaltechniquesareacoupleofwithinsidetheformofmean,median,mode, correlation, regression,brand newdeviation etc.but thegadgetused onthosedataset is mean, median and mode and suchgadgetaredescribedbelow: ï‚·Mean: Mean isconsideredto be andinexperiencedmethodwithrespecttoforemost tendency and to calculate theendorsetheemployerwanttoaccumulateandbring togetherthedatato calculate the same. Thetechniqueof calculating theendorseis sum of extensivekind ofobservations dividedviaextensivekind ofobservations. ï‚·Median: Median isanotherstatisticaltoolthatfacilitatestheemployerindecodingthe datajust sostandardoverall performanceof theemployercan bejudged. Median is consideredto be the mid-feewhichrepresenttheentiredataandthis canbe computedin any other casein case of even andpeculiarobservations. ï‚·Mode: It isin realitytheextensiverangethis ismostrepetitive in frequency withinside the given set of information. Ittypicallyshowsthosevalues whichmay beoccurred maximumtimesin numbers for theinputof the organisation. If in case the numbers will
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
nownotbe repeatedviathesingletimes, then modeis probablyregardedaszeroin that case. The followingtableshowsthe calculation ofendorsemedian and modecollectivelywith its techniquewithinside theformof screenshot: YearProfits (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 manipulationtechniquesis themethodofchangingthefactsor given set ofdatasimply so itwill becomeextraorganizedand readable to the users. Minimum: Theminimummethodindicatesthepricethis isbecomethe lowestwithinside the given set ofdata. Suchpricecertainlyarrives with theresourceofthe usage ofusing theminimummethodwithinside the excel(Kokol and Vošner, 2019). Theminimum pricethat iscalculated for theearningsis $3.50 billion whichcertainlymannerthe lowest pricethe Netflix hascompletedinamongst2012 to 2020.
ï‚·Maximum: Themaximummethodisbeneficialin calculating thefirst-classfigures that has beencompletedwith theresourceofthe usage oftheagencythatdesiresto bekeep ultimatelysimply sodesiresandaimof the entitycan becompleted. ï‚·Sum: The summethodhas been used tocertainlyaddon thepricethat has been given withinside thedata. Byutilizingthismethodtrendyhas been arrived ofall theprice. The sum of the Netflixfactswillsupplytheagencythewholeearningsvolumethey completedamongst2012 to 2020. ï‚·Average: Thenot unusual placecharacteristicis used to calculate thenot unusual place of the given numbers ordataset. Thereasonof calculating the excel is to calculate the centrepriceor the mean(Muneer and Ivanova, 2022). ï‚·Count: Thedependis used todependthetype ofvalues given withinside thefactsthis is arrived to be9in case ofearnings, profit, contend spend and subscriberthis isbecause of therealitythedataused for Netflix has beenamongst2012 to 2020. Thetablesaidunderneathindicatessoftwareof suchtechniquesalongsidescreenshot 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 Count9999
Screen shot of the Formulas used in Data Manipulation: 5.Statistics Demonstration using Maps and Tables: Theexamplein chartslets inthe industrialemployerin analysing therecordsina systematic wayand itmoreovermakes thereportgreaterpresentable. The following is the pictorial presentation ofprofits,profits,content materialclothspends and subscribers of the Netflix: ï‚·Profits:This graphrepresenttheprofitsearnedthroughmannerofmethodof Netflixall through2012 to 2020this isindevelopingorder over suchdurationshowsthatthey may beactingproperlyefficientlyandbecomingthemarketleaderin theirrespective Industry (Myers, Bergner, and Campion, 2022). . ï‚·Sales: Similar to theearningsfigures theirearningsquantityare alsodevelopingoverthe timeframewithout a doubtstate thatthey may beefficaciouslythe usage oftheir belongingsandgainingmaximumexperiencethebelongingstheymaybeusing withinside therouteofachievingthe economicorganisationgoals.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
. Content Spend: Themaximumcontent materialfabricgainthey may begaining in 2018 to 2020because ofthetruthall throughthatperiodmolecularusageand OTT platform has beenextendedworldwide. That’s whythe industrialemployermode Netflix has been usingis gainingpopularityamongstgeneration(Szalma, 2019). Subscribers: Therateof annual subscribers isdevelopingat therapidtempowhich actuallyindicatesthatthey may betakingphotographsthemarketatthe fastrateand
moreoverenjoyabletheirconsumerwith thecontent materialfabricthey providing (Nyeche and Diemuodeke, 2020).
CONCLUSION ThisdocumentincludestheresearchsituationcountconcerningtheNetflixandfor analysing theirnormaloverall performancetherawinformationhas been extractedthe use ofthe internetreassertsjust sotheirnormaloverall performancecan bejudged accordingly. The importantmagnificencefor analysing theirnormaloverall performanceis theearningsfigures, earningsthey made, subscribers theypreserveand theircontent materialfabricspendsooner or laterof thedurationstartingfrom 2012 to 2020. After extracting suchinformation, statistical assessmenthas beencompletedon suchinformationwithinside theformof calculation of mean, median, and mode. After calculating the same,informationmanipulationtechniqueshave been donewhich includesmaximum, minimum, count,not unusual placeand sumfunctionit isdone in excel. Afteractingsuch statisticaldeviceon theNetflixinformationinterpretation andstop has been madejust sotheirnormaloverall performancecan bechecked.
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
REFERENCES Books and Journals Bruno, D.E., Barca, E., and Passarella, G., 2018. Linear and evolutionary polynomial regression modelstoforecastcoastaldynamics:Comparisonandreliability 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 fortrainingpurposesofindustry4.0.InProceedingsofthe2ndInternational 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. InExcel-VBA(pp. 143- 162). Springer, Cham. Myers, M.F., Bergner, A., and Campion, M., 2022. A report of the AGCPD task force to evaluateassociationsbetweenselectadmissionsrequirements,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.