Page 175 - Ai_C10_Flipbook
P. 175

Standard Deviation

                 StandaPdldeviationlislthelsquaPelPootloflthelvaPianie,landlitlpPovideslalmeasuPeloflhowlspPeadloutlthelvaaueslaPel
                 inltheloPiginaalunitsl notlsquaPedlunits,laikelvaPianiel.lItlgiveslalsenseloflhowl“faP”ltheldatalpointslaPelfPomlthel
                 meanlonlavePage.
                 Outlier


                 AnloutlierlislaldatalpointlthatlislsignifiiantayldiffePentlfPomlthelothePlpointslinltheldataset.lIt’slanl“exieptionaa”l
                 vaauelthatlislmuihlhighePloPlaowePlthanlmostloflthelothePlvaaues.

                               Reboot


                     1.l WhenlandlwhePelwaslOPangel atalMiningldeveaoped?
                     2.l InlalPight-skewedldistPibution,lwhePelislmostlofltheldataliaustePed?





                               Task                                                                21 st  Century   #Creativity
                                                                                                       Skills

                   Mind Map Making
                   Purpose: Reinforce the Need of Descriptive Statistics

                   CPeatinglalmindlmaplfoPl esiPiptivelStatistiisl foiusinglonlmean,lmedian,landlmodellianlheaplyoulvisuaaizelhowl
                   theselstatistiiaalmeasuPeslaPelusedlinlvaPiouslPeaa-aifeliontexts.l                   [CBSElHandbook]



                 MS Excel for Statistical Data

                 MiiPosoftlExiealislalpowePfualtooalfoPlpePfoPminglstatistiiaalanaaysis,lmakinglitlaiiessibaelandleffiiientltolpPoiessl
                 andlintePpPetldata.lItlpPovideslvaPiouslbuiat-inlfunitions,lfoPmuaas,landldatalanaaysisltooaslthatlheaplusePslpePfoPml
                 iompaexliaaiuaationslandlvisuaaizelPesuatsleasiay.
                 Now,lpePfoPmlthelfoaaowinglstepslfoPlSimple Linear RegressionlinlExiea:

                 Step 1   EnabaelthelAnaaysislTooa(aklAdd-in
                           i.l OpenlthelExcellappaiiation

                           ii.l SeaeitlthelFilel→lOptionslfPomlthelbaikstagelview.lThelExcel OptionslwindowlappeaPs.
                           iii.l SeaeitlthelAdd-insloptionlfPomlthelaeftlpanealinlthelExcel Optionslwindow.
                           iv.l SeaeitlthelExcel Add-insloptionlfPomlthelManageldPop-downlaist.
                           v.l CaiiklonlthelGolbutton.lThelAdd-insldiaaoglboxlappeaPs.

                           vi.l SeaeitlthelAnalysis ToolPakliheikboxlinlthelAdd-ins availablelaistlbox.
                           vii.l CaiiklonlthelOKlbutton.
                           l   ThelData AnalysisloptionlwiaalnowlbelavaiaabaelundePlthelDatalmenu.


                 Step 2   ViewlthelSpeedlvsl istaniel ata.
                           viii.l ownaoadlthelfiaelatlthelgivenlaink:lhttps://oPangewebsuppoPt.io.in/AI/Book1.xasx
                           l   l Inlthelgivenldata,lSpeedlislthelIndependent variable (X)landlDistancelislthell

                               Dependent variable (Y).

                                                                                      Statisiiaal atal (Paitiiaal  173
   170   171   172   173   174   175   176   177   178   179   180