How to calculate percentile using Minitab and Excel PDF

Preview

Summary

INSTRUCTIONS...

Description

Howt ocal cul at eper cent i l eus i ngMI NI T ABandEx c el

Us eMI NI TABt oc al c ul at eper c ent i l eofadat as ets t or edi ncol umnC1asf ol l ows : Sel ectCal cf r om menuandt hens el ec t' c al c ul at or ' .Ent erc ol umnC2i nwhi c hy ouwant t os t or eper c ent i l ev al uei nt hefir stc el lofc ol umnC2.Mi ni t abwi l laut omat i c al l ys el ec t t hefi r s tcel l ofcol umnC2t os t or et heper cent i l ev al uei n.Theni nex pr es s i onar eaent er t hef ol l owi ngex pr es si ont oc al c ul at e95t hper cent i l eoft hedat as t or edi ncol umnC1: PERCENTI LE( C1,0. 95) .Thenhi tok .Ther es ul twi l lbedi s pl ay edi nt hefi r s tcel lof c ol umnC2.Mak es ur ey oudonothav eanyus ef ul i nf or mat i ons t or edi nt hefi r stcel lof c ol umnC2. They oucanc al c ul at ebyhandt her equi r edper c ent i l et ov er i f yt haty ougett hes ame r es ul tast hatofMI NI TAB. I fy ouwantt ouseEx c elt oc al cul at eper cent i l es ,us et hef ol l owi ngf unc t i on: Ent eri nac el lwher ey ouwantt odi s pl ayt heper cent i l ev al ue=PERCENTI LE( Dat a Range,. 95)f orcal c ul at i ngt he95t hper cent i l ewher et hedat ai ss t or edi nt hedat ar ange s pec i fi edi nt hePERCENTI LEf unct i ons hownabov e.Si mi l ar l yquar t i l esi nEXCELc an bec al c ul at edas : Fi r s tquar t i l ebyent er i ng i nacel l PERCENTI LE( Dat aRange,. 25)

=QUARTI LE( Dat aRange,1)orequi v al ent l y

Secondquar t i l ebyent er i ngi nac el l =QUARTI LE( Dat aRange,2)ororequi v al ent l y PERCENTI LE( Dat aRange,. 5) Thi r dQuar t i l ebyent er i ngi nac el l =QUARTI LE( Dat aRange,3)ororequi v al ent l y PERCENTI LE( Dat aRange,. 75)...