DATE.
TOPIC.
ASSIGMENT
Ir SKIu AND DATA
ANALYSIs
NAME NIDHI
RouNO. NCBc23225
ENR NO. - ZNCHLBCOHO00II
CLASS BcoNy 5EH)
Su8MITTED To RAJAN KUMAR
TOPIC. DATE.
Tntoduction to Descoiptive AtattstHeg 3
indat
Desciptiue hatiskícs ane kundamental tools
thabut the
Hnalysis, Proutding Aimple Summanies tistic înhell
Dumble and he meos wes. These
Understanding dhe bassc teures o data, otenîng in
tendeny ,and Vai
Digatr into tae díshibuien, Centl
albiiky
Neanhe fuerag Vale
Nedian- The atddle valehea data s ordered
Mode - The most heQusut occuning Valu
tandard pevíatien - Meas wnes the STIspehsíbn f dote
meaM
Nan fance - he suant at the Standand Devaion îo
dicating dala Abread.
Ranqe -The dihee behueon tne maxímum and Hønimum
yales
Detng up excel for stahstcal Analya
’Belore futormîng iatisical Analsts enential t2
ensuse dnot Gxcel is eQusthed fh dhe Neessaut
TOPIC.. DATE.
Enabl'ng the thnalysis ToolPak Add-tn 'a
). oken Excel and Navia ate to tne tile Tab
2.
Select o;tfons to ohen tne Exel oþtfons dlaloy box
Tn me Add- fas Categoh, locate the Ahoalyas Too
Pak
At he ho ttomn fn the Manage box, eteet xel Add
ns and clic go
Tn tae Add fnd bax, check the nalysts Toallak
Check boX, andfhen crck ok
*moxting and {repaning Data '
Data Entay tnhuw data fndo Brcel fn a stuctned
tomat Typfcally wfth Vanfables Bn colum ad
obseatien fn 1ou
Dala Ceaning - Cheek tor the add res 1fssing Valu
Dutlrerz or încansfs kent data enties
Data komattinghsune tha umexfcal data s
ComecHs koxmaHed to allous ar Accu
Calubaons.
TOPIC.
.DATE
Rer toxmina Descaíbtve cal Analyp
hatistcal
1.
Cllck on the Dala Iab and Delect Data Ahoalyi
ba dne Data Aaalysis Dralog boX, chooe Descipe
sattshcs end cieck ok
3 n the Desciptf e statshes drolag boxi
nhut Range' seleck he Ronge o dat to nalye
heuped by'- choose Jhethex dne data fp qouhed by
Contind Vaiable names
Gutputohtiens Select shere ko díshlay me reslt
tattsticg k check this box do qene ratt Hue
Jummany
Descxi Hve tattstig
4. clek ok to qenerae the.
’ Product a Table contlniaq He
Descipive Attistecz tor he Delectea date
TOPIC.
"......DATE
neretfnq the Resu
Ne an- ndrcotes the hvera
SHandand emer- estmakes dhe Vaniabi liy ot
he somle Mean
Meden- Shoussthe iddle Va novicng
fnsiqu ento the aatals Centul tenden f
Made fdentf'es tiae pmost t e a y
Value
Measnes the Disþesia
standand Deiat
fotat
Jamle Vantcnce - Wusnttes the sfadcf Hae
dala
Kun dofg - în cllcates tne trilednexs et ne date
Distebu'en
Skeones - Measunes he asymmetuy oh the dale
Drsttbuhn
Range uides me shrtad bls dhehiqh eat aad
lowes yalus
Hinmum Masmuml- Dhow dhe smallest and
lataest data Roint ResktcHvelye
DATE
TOPIC.
Sum - Total ad al dataotnhh
Set
Count - Junmbe pbse Vatiens fn the data
polentiy
Analyzing Aales data to
Busines ’
henda and tnfonm aty
Ahudent Perfomaae z
’ Evalyahiag
Educatian
Arademic
ut Comes
r clínical
Assessiaq fatient
data
tHeatn Care ’
huies
exeafmental dat to
mmanizing
Reseanch ’ Su Condlusfn
d o s frellminany
Advantaqes and Limitatianyl
Limitations
ladvantag) 1. Basee evel Anaysis
woentiendly intengae
Easfly Aieystable
2
uek Result 2. ot fdeal for lange
NoNeedtur Codiag 3-limiked visu alizatin
S. Enegcted 1oal ation
4 dack ot cutom
S. Nat Sitable for
Complex Mode
