Qalooca gambaleelka^{(bell curve)} ama shaxda qaybinta caadiga ah^{(normal distribution chart)} waa garaaf falanqeeye. Shirkado badan ayaa isticmaala jaantuska gambaleelka si ay ula socdaan waxqabadka shaqaalahooda. Sidoo kale, garaafka waxa kale oo loo isticmaali karaa dugsiyada si loola socdo waxqabadka ardayda. Waxaad isticmaali kartaa jaantuskan si aad u falanqeyso waxqabadka qof gaar ah oo wejiyo kala duwan ah ama koox marxalad gaar ah. Maqaalkan, waxaan arki doonaa sida loo abuuro qalooca gambaleelka ee Excel .

Sida loo abuuro Curve Bell gudaha Excel

Si aan kuu baro habka loo sameeyo qalooca gambaleelka gudaha Excel , waxaan soo qaatay xogta muunad ee 10 arday ee maado gaar ah. Calaamaduhu waa 100 ka mid ah.

1] Marka hore^(First) , waa inaad xogta oo dhan u habayso siday u korto. Taas awgeed, dooro dhammaan tiirka calaamadaha, dhagsii badhanka " Sort Filter " ee ku yaal aaladda aaladda oo dooro ikhtiyaarka "Ka- soocidda ugu yar ilaa ugu weyn^{(Sort Smallest to Largest)} ". Xulashadan ka dib, daaqad popup ah ayaa ka soo muuqan doonta shaashadda oo leh laba ikhtiyaar, " Balaadhi Xulashada^{(Expand the Selection)} " iyo " Ku sii wad xulashada hadda^{(Continue with the Current Selection)} ." Waa inaad doorataa ikhtiyaarka koowaad maadaama ay u habayn doonto buundooyinka ardayda siday u kala horreeyaan iyo magacyadooda.

2] Si aan u abuurno qalooca gambaleelka ee excel, waxaan u baahanahay saddex qiimeyaal, celcelis ahaan, weecasho caadi ah, iyo qaybinta caadiga ah. Aynu marka hore xisaabino celceliska xogta. Taas awgeed, geli qaacidada soo socota oo taabo badhanka " Enter "

=Average(B2:B10)

Waxaad xisaabin kartaa celceliska unug kasta, waxaan ku xisaabiyay unugga B13 . Ogow in aad geliso ciwaanka unugga saxda ah celceliska qaacidada. Halkan, unugga B2 waxa uu ka kooban yahay lambarka koowaad iyo unugga B11 waxa uu ka kooban yahay lambarka ugu dambeeya ee xisaabinta celceliska.

Celceliska xogtayadu waa 82.

3] Hadda, aynu xisaabino weecanka caadiga ah ee xogta. Taas awgeed, waa inaad gelisaa qaacidada soo socota:

=STDEV.P(B2:B11)

Sida celcelis ahaan, waxaad xisaabin kartaa leexashada caadiga ah ee unug kasta, waxaan ku xisaabiyay unugga B14 . Mar labaad^(Again) , qaacidadan, B2 waxay u taagan tahay xogta ku jirta unugga B2, B11na^(B11) waxay u taagan tahay xogta ku jirta unugga B11 . Fadlan^(Please) si sax ah u geli ciwaanka gacanta

Isbeddelka caadiga ah ee xogtayadu waa 6.09918. Tani waxay ka dhigan tahay in ardayda badankoodu ay jiifsan doonaan inta u dhaxaysa 82 - 6.09918 ama 82 + 6.09918.

4] Hadda, aynu xisaabino qaybinta caadiga ah ee xogta. Qaybinta caadiga ah waa in loo xisaabiyaa arday kasta si gaar ah. Sidaa darteed^(Therefore) , waxaan ku qoray tiirka C. Dooro^{(C. Select)} unugga C2 (unugga wax yar ka hooseeya unugga qaybinta caadiga ah) oo geli qaacidada soo socota, oo taabo badhanka " Gelida ":^(Enter)

=NORM.DIST(B2,$B$13,$B$14,FALSE)

Qaacidada sare, calaamada $ waxay muujinaysaa inaan dhignay unuga ay u kala leeyihiin inay qaboojiyaan, BEEN ABUURtuna^(FALSE) waxay muujinaysaa " qaybinta tirada suurtogalka ah^{(Probability mass distribution)} ." Maaddaama qalooca gambaleelka aanu ahayn qalooca si joogto ah u koraya, waxaanu dooranay shaqada BEEN^(FALSE) . Shaqada RUNTA^(TRUE) ah waxay tusinaysaa " Shaqada qaybinta wadarta^{(Cumulative distribution function)} " taas oo loo isticmaalo in lagu abuuro garaafyo leh qiimayaal sii kordhaya.

5] Hadda, dhig calaamaddaada dhinaca midig ee hoose ee unugga la doortay (C2) oo u jiid unugga u dambeeya ( C11 ). Tani waxay koobiyayn doontaa oo ku dhejin doontaa dhammaan caanaha caanaha dhammaan unugyada.

6] Xogtayadu waa diyaar. Hadda, waa inaan gelinaa qalooca gambaleelka. Taas awgeed, marka hore, dooro calaamadaha iyo tiirarka qaybinta caadiga ah oo tag " Insert > Recommended Charts ."

7] Hadda, dhagsii " Dhammaan Charts^{(All Charts)} " tab oo tag " XY Scatter > Scatter with Smooth Lines ." Halkan, dooro shaxda " Qaybinta ^{(Distribution)}Caadiga ah " oo guji " ^(Normal) OK " badhanka.

8] Qallooca gambaleelka waa diyaar.

Qalooca gambaleelka ayaa jira doorashooyin badan oo waxka bedelka ah. Waxaad dejin kartaa qiimaha ugu yar iyo kan ugu sarreeya ee X iyo Y-faasas adiga oo gujinaya iyaga. Si ay kuugu habboonaato, waxaan taxday tillaabooyinka lagu beddelayo qiyamka dhidibka-X^(X-axis) .

1. Dooro dhidibka X.
2. Ka dooro liiska " Axis Options " dhinaca midigta oo deji qiimaha ugu yar iyo kan ugu sarreeya qaybta " Bonds^(Bounds) ".

Waxa kale oo aad muujin kartaa oo aad qarin kartaa qaybaha shaxda kala duwan. Taas awgeed, dooro garaafka oo guji sumadda " Plus ". Halkaa, waxaad ka heli doontaa dhowr doorasho. Waad dooran kartaa oo ka saari kartaa mid ama dhamaantood.

Waxaan kor ku soo aragnay in qaabka qalooca gambaleelka uusan ahayn mid qumman. Tani waa sababta oo ah farqiga u dhexeeya qiyamka dhidibka X^(X-axis) (calaamadaha ardayda) isku mid ma aha. Hadda, waxaan abuureynaa hal garaaf garaaf oo kale oo leh qiyam siman oo kala fogaaday dhidibka X. ^(X-axis)Waa inaad raacdaa tillaabooyinka kor ku xusan ee maqaalka. Eeg sawirka hoose

Tani waa qalooca gambaleelka oo si fiican u qaabaysan. Maqaalkan, waxaanu ku sharaxnay qalooca gambaleelka oo leh qiimayaal siman oo aan sinnayn oo u dhexeeya dhidibka X.

Hadda, waxaad ku abuuri kartaa qalooca gambaleelka MS excel.

Waxaad sidoo kale jeclaan kartaa^{(You may also like)} : Sida loo sameeyo jaantuska Gantt gudaha Excel .

How to create a Bell Curve in Excel

A bell curve or normal distribution chart is a performance analyzer graph. Many companies use the bell chart to track the performance of their employees. Similarly, the graph can also be used in schools to track the performance of students. You can use this chart to analyze the performance of a particular person in different phases or a team in a particular phase. In this article, we will see how to create a bell curve in Excel.

How to create a Bell Curve in Excel

To teach you the process of making a bell curve in Excel, I have taken sample data of 10 students’ marks in a particular subject. The marks are out of 100.

1] First, you have to arrange the entire data in ascending order. For this, select the entire column of marks, click on the “Sort Filter” button on the toolbar and select the “Sort Smallest to Largest” option. After selecting this option, a popup window will appear on the screen with two options, “Expand the Selection” and “Continue with the Current Selection.” You have to select the first option as it will arrange the students’ marks in ascending order along with their names.

2] To create a bell curve in excel, we need three values, average, standard deviation, and normal distribution. Let’s calculate the average of the data first. For this, enter the following formula and press the “Enter” button:

=Average(B2:B10)

You can calculate the average in any cell, I have calculated it in B13 cell. Do note that you have to enter the correct cell address in the average formula. Here, cell B2 contains the first number and cell B11 contains the last number for the calculation of average.

The average of our data is 82.

3] Now, let’s calculate the standard deviation of the data. For this, you have to enter the following formula:

=STDEV.P(B2:B11)

Like mean, you can calculate the standard deviation in any cell, I have calculated it in B14 cell. Again, in this formula, B2 represents the data in the B2 cell, and B11 represents the data in the B11 cell. Please enter the cell address correctly.

The standard deviation of our data is 6.09918. This means that most of the students will lie in the range of 82 – 6.09918 or 82 + 6.09918.

4] Now, let’s calculate the normal distribution of the data. The normal distribution is to be calculated for each student separately. Therefore, I have written it in column C. Select the cell C2 (the cell just below the normal distribution cell) and enter the following formula, and press the “Enter” button:

=NORM.DIST(B2,$B$13,$B$14,FALSE)

In the above formula, the $ sign indicates that we have put the respective cell to freeze and FALSE indicates the “Probability mass distribution.” Since the bell curve is not a continuously increasing curve, we have selected the function FALSE. The TRUE function indicates the “Cumulative distribution function” which is used to create graphs with increasing values.

5] Now, place your cursor at the bottom right corner of the selected cell (C2) and drag it to the last cell (C11). This will copy and paste the entire formula to all the cells.

6] Our data is ready. Now, we have to insert the bell curve. For this, first, select the marks and normal distribution columns and go to “Insert > Recommended Charts.”

7] Now, click on the “All Charts” tab and go to “XY Scatter > Scatter with Smooth Lines.” Here, select the “Normal Distribution” chart and click the “OK” button.

8] The bell curve is ready.

There are many customization options in the bell curve. You can set the minimum and the maximum values of X and Y-axes by clicking on them. For your convenience, I have listed the steps to change the values of the X-axis.

1. Select the X-axis.
2. Select the “Axis Options” menu from the right panel and set minimum and maximum values in the “Bounds” section.

You can also show and hide different chart elements. For this, select the graph and click on the “Plus” icon. There, you will get a number of options. You can select and deselect any or all of them.

We have seen above that the shape of the bell curve is not perfect. This is because the difference between the values on the X-axis (marks of the students) is not the same. Now, we are creating one more bell graph with equally spaced values on the X-axis. You have to follow the same steps mentioned above in the article. See the below screenshot.

This is the perfectly shaped bell curve. In this article, we have explained the bell curve with both equally and unequally spaced values on the X-axis.

Now, you can create a bell curve in MS excel.

You may also like: How to make a Gantt chart 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 loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

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

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sidee looga saaraa Akhri kaliya dukumeenti Excel ah?

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel