Dhexdhexaadku wuxuu ka dhigan yahay qiime kala sooca qaybta sare iyo qaybta hoose ee muunada xogta. Microsoft Excel waxay leedahay shaqo kuu ogolaanaysa inaad si fudud u xisaabiso Median-ka. Aan aragno sida loo sameeyo xisaabinta dhexdhexaadka ah ee Excel^{( median calculation in Excel)} .

Xisaabinta Dhexdhexaadinta ee Excel

Shaqada dhexe ee Excel waxaa loo kala saari karaa hawl xisaabeed. Waxa loo geli karaa qayb ka mid ah qaacido ku jira unugga xaashida shaqada. Isku dhafka shaqada MEDIAN waa sida soo socota:

MEDIAN (number1, [number2], …)

Halka tirada1, nambarka2, … ay yihiin qiimayaal tirooyin ah oo aad rabto inaad ku xisaabiso dhexdhexaadiyaha. Kuwani waxay noqon karaan tirooyin, tiro la magacaabay, ama tixraacyo unugyo ka kooban tirooyin. Number1 ayaa loo baahan yahay, tirooyinka soo socda waa ikhtiyaari.

Si aad u isticmaasho shaqada MEDIAN sida shaqada xaashida shaqada ee Microsoft Excel :

1. Geli qiyamka unugyada
2. Isticmaal qaacidada si aad u xisaabiso qiimaha.

1] Geli qiyamka unugyada

Adiga oo u malaynaya in aad rabto in aad ka heshid dhexdhexaadka tirooyinka unugyada D2:D8 . Kaliya^(Simply) geli qiimaha xogta adoo furaya xaashi Excel ah oo maran oo samee waxyaabaha soo socda,^(Excel)

Samee hal^{(Make one)} tiir oo ah Kharashaadka Bisha Celceliska ah^{(Average Monthly Expenses)} iyo tiir kale, oo ku dheggan qaddarka^(Amount) .

Geli^(Enter) sharraxaadda tiirka 1 iyo qiimaha ama qaddarka u dhigma tiirka 2

2] Isticmaal^(Use) qaacidada si aad u xisaabiso qiimaha

Hadda, si aad u xisaabiso dhexdhexaadiyaha dhagsii unug kasta oo u isticmaal qaacidada sida tan:

=MEDIAN (D2:D8)

Isla markiiba, qiimaha dhexdhexaadka ah ee u dhigma xogta ayaa ka dhex muuqan doona unugga. Halkan, waxaa muhiim ah in la ogaado in marka wadarta guud ee qiyamku ay khayaali tahay, shaqada Excel MEDIAN waxay soo celisaa lambarka dhexe ee xogta, tusaale ahaan, haddii ay jiraan tirooyinka 1 ilaa 7, qiimaha dhexdhexaadku wuxuu noqon doonaa 4 (1,2). ,3, 4, 5,6,7)

Haddii kale, marka wadarta tirada qiimayuhu ay siman yihiin, Excel waxa uu ku soo noqonayaa celceliska labada lambar ee dhexe, tusaale ahaan, haddii ay jiraan tirooyin laga bilaabo 1 ilaa 8, dhexdhexaadku wuxuu noqonayaa (1,2,3,4,5,6). ,7,8) 4+5/2 = 4.5

Uma baahnid inaad ka walwasho unugyada Qoraallada^(Texts) sida unugyo madhan, iyo sidoo kale unugyo ka kooban qoraal iyo qiyam macquul ah, waa la iska indhatiray.

Xusuusin^(Note) : Unugyada leh qiyamka eber (0) waxay ku jiraan xisaabinta.

Noocyadii ugu dambeeyay ee Microsoft Excel , shaqada MEDIAN waxay aqbashaa ilaa 255 doodood.

How to calculate Median in Excel

The median represents a value that separates the higher half from the lower half of a data sample. Microsoft Excel has a function that allows you to calculate the Median easily. Let’s see how to do median calculation in Excel.

Median Calculation in Excel

The median function in Excel can be categorized as a statistical function. It can be entered as part of a formula in a cell of a worksheet. The syntax of the MEDIAN function is as follows:

MEDIAN (number1, [number2], …)

Where number1, number2, … are numeric values for which you want to calculate the median. These can be numbers, named ranges, or references to cells containing numbers. Number1 is required, subsequent numbers are optional.

To use the MEDIAN function as a worksheet function in Microsoft Excel:

1. Enter the values in cells
2. Use the formula to calculate the value.

1] Enter the values in cells

Supposing you want to find the median of numbers in cells D2:D8. Simply enter the data value by opening a blank Excel sheet and doing the following,

Make one column of Average Monthly Expenses and another column, adjacent to it of Amount.

Enter the description in column 1 and value or amount corresponding to it in column 2

2] Use the formula to calculate the value

Now, to calculate the median click inside any cell and use the formula as simple as this:

=MEDIAN (D2:D8)

Instantly, the median value corresponding to the data will be visible in the cell. Here, it is important to note that when the total number of values is odd, the Excel MEDIAN function returns the middle number in the data set i.e., if there are numbers from 1 to 7, the median value will be 4 (1,2,3,4,5,6,7)

Alternatively, when the total number of values is even, Excel will return as the average of the two middle numbers i.e., if there are numbers from 1 to 8, the median value will be (1,2,3,4,5,6,7,8) 4+5/2 = 4.5

You need not worry about cells with Texts as empty cells, as well as cells containing text and logical values, are ignored.

Note: Cells with zero values (0) are included in calculations.

In most recent versions of Microsoft Excel, the MEDIAN function accepts up to 255 arguments.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• 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

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel