Hawsha DVAR ee Microsoft Excel waa hawl kaydineed, ujeeddadeeduna waa in la qiyaaso kala duwanaanshiyaha dadweynaha iyadoo lagu salaynayo muunad laga soo qaatay macluumaadka la soo xulay. Habka shaqada DVAR waa DVAR (database, field, standards). Erayga shaqada DVAR waa:

• Database : Kala duwanaanshaha unugyada ka kooban kaydinta xogta. Waa loo baahan yahay.
• Goobta^(Field) : Waxay muujinaysaa tiirka loo isticmaalo shaqada. Waa loo baahan yahay.
• Shuruudaha^(Criteria) : Kala duwanaanta unugyada ka kooban xaaladda aad sheegtay. Waa loo baahan yahay.

Sida loo isticmaalo shaqada DVAR gudaha Excel

Si aad u isticmaasho shaqada DVAR gudaha Excel ; raac talaabooyinka hoose:

1. Fur xaashida xaashida ee Excel
2. Samee miis
3. Samee shaxda shuruudaha
4. Geli^(Enter) xogta aad raadinayso shaxda shuruudaha.
5. Isticmaal  =DVAR (A1:B7, “Height,” A10:B11)
6. Geli xogta

Aynu si faahfaahsan u eegno habka.

Fur Microsoft Excel .

Samee miis.

Sidoo kale, samee shaxda shuruudaha.

Shaxda shuruudaha ayaa ka koobnaan doona xogta aad raadinayso.

Casharradan, waxaan ku abuureynaa jaantusyo ka kooban laba beerood, Geed^(Tree) iyo Dherer^(Height) , laakiin waxaan galeynaa oo kaliya orange-ka hoostiisa beerta^(Tree) sababtoo ah waxaan qiyaasi doonaa kala duwanaanshaha dhererka liinta.

Unugga meesha aad rabto inaad dhigto nooca natiijada =DVAR (A1:B7, "Height," A10:B11).

• A1:B7 waa Database-ka.
• "Dheer" waa Goobta.
• A10:B11 waa shuruudaha.

Riix furaha Enter ee kiiboodhka si aad u aragto natiijada.

Waxaa jira hab kale oo loo isticmaalo shaqada DVAR .

Guji badhanka fx ee bidix ee sare ee xaashida shaqada ee ^(fx)Excel .

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

Gudaha sanduuqa wada hadalka ee qaybta, Dooro Qaybta^{(Select a Category)} , ka dooro Database sanduuqa liiska.

Qaybta Dooro Function^{(Select a Function)} , ka dooro hawsha  DVAR liiska.

Kadib dhagsii OK .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa furmi doona.

• Qaybta Database , geli sanduuqa unugga A1:B7 .
• Qaybta Goobta^{(Field )} , geli sanduuqa dhererka unugga.^(Height.)
• Qaybta Shuruudaha^{(Criteria )} , geli sanduuqa unugga A10:B11.

Kadib guji OK si aad u aragto natiijada.

la xidhiidha: ^(Related:) Excel ma furi karo faylka sababtoo ah qaabka faylka ama kordhintu maaha mid sax ah^{(Excel cannot open the file because the file format or extension is not valid)} .

Waxaan rajeyneynaa in casharkan uu kaa caawiyo inaad fahamto sida loo isticmaalo shaqada DVAR gudaha Excel .

How to use the DVAR function in Excel

The DVAR function in Microsoft Excel is a database function, and its purpose is to estimate the variance of a population based on a sample from selected database entries. The formula for the DVAR function is DVAR (database, field, criteria). The syntax for the DVAR function is:

• Database: The range of cells that makes up the database. It is required.
• Field: Indicates which column is used in the function. It is required.
• Criteria: The range of cells that contains the condition you specify. It is required.

How to use the DVAR function in Excel

To use the DVAR function in Excel; follow the steps below:

1. Launch Excel spreadsheet
2. Create a table
3. Create a criteria table
4. Enter the data that you are looking for into the criteria table.
5. Use =DVAR (A1:B7, “Height,” A10:B11)
6. Enter the data.

Let us check out the method in details.

Open Microsoft Excel.

Create a table.

Also, create a criteria table.

The criteria table will contain the data you are searching for.

In this tutorial, we create a criteria table that contains two fields, Tree and Height, but we only enter orange under the Tree field because we will estimate the variance of the height of the oranges.

The cell where you want to place the result type =DVAR (A1:B7, "Height," A10:B11).

• A1:B7 is the Database.
• “Height” is the Field.
• A10:B11 is the Criteria.

Press the Enter key on the keyboard to see the result.

There is another method to use the DVAR function.

Click the fx button on the top left of the Excel worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the section, Select a Category, select Database from the list box.

In the section Select a Function, choose the  DVAR function from the list.

Then click OK.

A Function Arguments dialog box will open.

• In the Database section, enter into the box the cell A1:B7.
• In the Field section, enter into the box the cell Height.
• In the Criteria section, enter into the box the cell A10:B11.

Then click OK to see the result.

Related: Excel cannot open the file because the file format or extension is not valid.

We hope this tutorial helps you understand how to use the DVAR function in Excel.

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

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• 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 bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

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

• Sida loo isticmaalo Find and FindB functional in Excel

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

• Sidee looga saaraa Akhri kaliya dukumeenti Excel ah?

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

• Sida loo isticmaalo shaqada Mode ee Excel

• Casharka Microsoft Excel, ee Bilowga ah