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

