Shaqada boqolleyda Exc^{(Percentile Exc)} ee Excel waa shaqo xisaabeed, ujeeddadeeduna waa in lagu soo celiyo k-th Boqolleyda^(Percentile) qiyamka ee kala duwan, halkaasoo k uu yahay 0 ilaa 1. Qaaciddada boqolleyda^(Percentile) . Exc function waa PERCENTILE.EXC(array, k).

Percentile.Exc iyo Percentile.Inc^{(Percentile.Exc)} waa nooca ugu cusub ee shaqada ^(Percentile)boqolleyda^{(Percentile.Inc)} . Labadan hawlood waxay bixiyaan saxnaan badan oo magacyadoodu ka tarjumayaan isticmaalkooda. Sintax ee Percentile.Exc ^(Syntax)Function^{(Percentile.Exc Function)} waa sida soo socota:

• Array : Kala duwanaanshaha xogta.
• K : qiimaha u dhexeeya 0 iyo 1 oo u taagan k-th Percentile .

Sida loo isticmaalo Percentile.Exc function gudaha Excel

Fur Microsoft Excel ama miiska Excel ee jira .

Tababarkan, waxaan rabnaa inaan u helno Percentile.Exc 53% ee shaxda.

Geli^(Enter) qolka aad rabto in natiijadu noqoto =PERCENTILE.EXC(A2:A10,0.53) .

A2:A10 waa tirada xogta, iyo 0.53 waa⁽⁵³⁾ qiimaha u dhexeeya 0 iyo 1 taas oo ka dhigan boqolleyda k- th^(Percentile)

Riix^(Press) geli waxaad arki doontaa natiijada.

Natiijadu waa 0.679 .

Si loo beddelo 0.679  boqolkiiba. Tabka guriga^(Home) ee kooxda nambarka^(Number) , dhagsii calaamada boqolkiiba^(Percent) .

Waxay noqon doontaa 68% .

Waxaa jira laba hab oo kale oo loo isticmaalo   Percentile.Exc function.

Habka koowaad waa inaad gujiso badhanka Fx ee korka warqadda shaqada.

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada hadalka ee ka dooro^{(Select a Category)} qaybta qaybta, dooro Tirakoobka^{(Statistical)} .

Qaybta Xulashada Shaqada^{(Select a Function)} , dooro Percentile.Exc.

Kadib, dhagsii OK .

Sanduuqa wada hadalka doodaha Function^{(Function Arguments)} ayaa soo bixi doona.

Gudaha sanduuqa wada hadalka doodaha Function^{(Function Arguments)} , geli sanduuqa Array tirada xogta A2:A10 .

Sanduuqa K , geli 0.53 .

Kadib, dhagsii OK .

Habka labaad waa in la aado tab Formulas iyo in kooxda ^(Formulas)Library Function^{(Function Library)} oo guji Functions More^{(More Functions)} .

Liistada hoos-u-u-soo-u-dhac ku jirta, ku dul-kor-kormeerka Tirakoobka^{(Statistical)} oo dooro Percentile.Exc .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona; raac tillaabooyinka habka koowaad.

Waxaan rajeyneynaa in casharkaan uu kaa caawiyo inaad fahamto sida loo isticmaalo Percentile.Exc function in   Microsoft Excel .

Hadda akhri^{(Now read)} : Sida loo sameeyo koodka QR gudaha Excel & PowerPoint^{(How to create a QR code in Excel & PowerPoint)} .

How to use Percentile.Exc function in Excel

The Percentile Exc function in Excel is a statistical function, and its purpose is to return the k-th Percentile of values in a range, where k is 0 to 1. The formula for the Percentile. Exc function is PERCENTILE.EXC(array, k).

The Percentile.Exc and Percentile.Inc is the newest version of the Percentile function. These two functions provide more accuracy and whose names reflect their usage. The Syntax for the Percentile.Exc Function is as follows:

• Array: The range of data.
• K: the value between 0 and 1 that represents the k-th Percentile.

How to use Percentile.Exc function in Excel

Open Microsoft Excel or an existing Excel table.

For this tutorial, we want to find the Percentile.Exc for the 53% in the table.

Enter into the cell where you want the result to be =PERCENTILE.EXC(A2:A10,0.53).

A2:A10 is the range of data, and 0.53 is the value between 0 and 1 that represents the k-th Percentile

Press enter you will see the result.

The result is 0.679.

To turn 0.679  into a percentage. On the Home tab in the Number group, click the Percent symbol.

It will turn to 68%.

There are two other methods to use the  Percentile.Exc function.

Method one is to click the Fx button on top of the worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the Select a Category section, select Statistical.

In the Select a Function category, select Percentile.Exc.

Then, click OK.

A Function Arguments dialog box will pop up.

Inside the Function Arguments dialog box, enter in the Array box the range of data A2:A10.

In the K box, enter 0.53.

Then, click OK.

Method two is to go to the Formulas tab and in the Function Library group and click More Functions.

In the drop-down list, hover the cursor over Statistical and select Percentile.Exc.

A Function Arguments dialog box will appear; follow the steps in method one.

We hope this tutorial helps you understand how to use the Percentile.Exc function in  Microsoft Excel.

Now read: How to create a QR code in Excel & PowerPoint.

Related posts

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sidee looga saaraa Akhri kaliya dukumeenti Excel ah?

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel