Note: The other languages of the website are Google-translated. Back to English
Logáil isteach  \/ 
x
or
x
Cláraigh  \/ 
x

or

Conas teimpléad cairt cuar cloig a chruthú in Excel?

De ghnáth déantar cairt cuar cloig, ainmnithe mar dháileachtaí dóchúlachta gnáth i Staitisticí, chun na himeachtaí is dóichí a thaispeáint, agus léiríonn barr an chuar clog an teagmhas is dóichí. San Airteagal seo, treoróidh mé duit cairt cuar cloig a chruthú le do chuid sonraí féin, agus an leabhar oibre a shábháil mar theimpléad in Excel.

Cluaisín Oifige Cumasaigh Eagarthóireacht agus Brabhsáil Tabbed in Oifig, agus Déan Do Obair i bhfad Níos Éasca ...
Réitíonn Kutools for Excel an chuid is mó de do chuid Fadhbanna, agus Méadaíonn sé do Tháirgiúlacht 80%
  • Athúsáid Rud ar bith: Cuir na foirmlí, na cairteacha agus aon rud eile is úsáidí nó is casta le do rogha Favorites, agus athúsáid go tapa iad sa todhchaí.
  • Níos mó ná 20 gné téacs: Uimhir Sliocht as Teaghrán Téacs; Sliocht nó Bain Cuid de Théacsanna; Tiontaigh Uimhreacha agus Airgeadraí go Focail Bhéarla.
  • Cumaisc Uirlisí: Illeabhair Oibre agus Bileoga ina hAon; Cumaisc Ilchealla / Sraitheanna / Colúin Gan Sonraí a Chailleadh; Cumaisc Sraithe Dúblacha agus Suim.
  • Uirlisí Scoilt: Roinn Sonraí i Ilbhileoga Bunaithe ar Luach; Leabhar Oibre amháin le Ilchomhaid Excel, PDF nó CSV; Colún amháin go Colúin Iolracha.
  • Greamaigh gan bacadh Sraitheanna Hidden / Scagtha; Líon agus Suim de réir Dath Cúlra; Seol Ríomhphoist Phearsantaithe chuig Il-Faighteoirí i mBulc.
  • Scagaire Sármhaith: Ardscéimeanna scagaire a chruthú agus a chur i bhfeidhm ar aon bhileoga; Sórtáil de réir seachtaine, lae, minicíochta agus níos mó; scagairí le cló trom, foirmlí, trácht ...
  • Níos mó ná 300 gné chumhachtach; Oibríonn sé le hOifig 2007-2019 agus 365; Tacaíochtaí le gach teanga; Imscaradh éasca i d’fhiontar nó d’eagraíocht.

Cruthaigh cairt cuar cloig agus sábháil mar theimpléad cairte in Excel

Chun clogchairt a chruthú le do chuid sonraí féin, agus ansin é a shábháil mar theimpléad Excel, is féidir leat é a dhéanamh mar a leanas:

1. Cruthaigh leabhar oibre bán, agus iontráil ceanntásc an cholúin I Raon A1: D1 mar a thaispeánann an griangraf seo a leanas:

2. Iontráil do chuid sonraí sa cholún Sonraí, agus sórtáil na sonraí trí chliceáil trí chliceáil Dáta > Sórtáil.
Is é ár gcás, iontráilimid ó 10 go 100 i Rang A2: A92 sa Cholún Sonraí.

3. Ríomh na sonraí mar seo a leanas:

(1) I gCill C2, clóscríobh thíos an fhoirmle chun an meán a ríomh:

= AVERAGE (A2: A92)

(2) I gCill D2, iontráil thíos an fhoirmle chun an diall caighdeánach a ríomh:

= STDEV (A2: A92)

(3) I gCill B2, clóscríobh ceann de na foirmlí thíos le do thoil, agus tarraing an Láimhseáil AutoFill go dtí an Raon A3: A92.

A. In Excel 2010 nó i leaganacha níos déanaí:

= NORM.DIST (A2, $ C $ 2, $ D $ 2, BRÉAGACH)

B. In Excel 2007:

= NORMDIST (A2, $ C $ 2, $ D $ 2, BRÉAGACH))

nótaí: Is é an A2: A92 an raon a iontráimid ár sonraí, agus athraigh an A2: A92 go dtí an raon le do chuid sonraí.

4. Roghnaigh Raon A2: B92 (Colún sonraí agus colún Dáileacháin) , agus cliceáil ar an Ionsáigh > Scaip (nó Cairt scaipthe agus donut in Excel 2013)> Scatter le Línte agus Marcóirí Smooth.

Ansin cruthaítear cairt cuar cloig a thaispeánann mar a leanas an scáileán scáileáin.

Is féidir leat cuar na gcloch a fhormáidiú trí finscéalta, ais agus línte eangaí a bhaint sa chairt cuar cloig.

Agus anois is féidir leat an chairt cuar cloig chruthaithe a shábháil mar ghnáth-theimpléad cairte in Excel leis na céimeanna seo a leanas:

5. Sábháil an chairt cuar clog mar theimpléad cairte:
A. In Excel 2013 nó leaganacha níos déanaí, cliceáil ar dheis ar an gcuar cuar clog, agus roghnaigh an Sábháil mar Theimpléad ón roghchlár cliceáil ar dheis;
B. In Excel 2007 agus 2010, cliceáil an chairt cuar clog chun na hUirlisí Cairte a ghníomhachtú, agus ansin cliceáil ar an dearadh > Sábháil Mar Theimpléad.

6. Sa bhosca dialóige Teimpléad Sábháil Cairt aníos, cuir ainm do theimpléad sa Ainm comhaid bosca, agus cliceáil ar an Sábháil cnaipe.

 
 
 
 
 

Cuidíonn uirlis den chéad scoth leat 2 chéim chun cairt cuar cloig a chruthú in Excel

Breiseán iontach Excel, Kutools le haghaidh Excel, soláthraíonn sé 300+ gné chun cabhrú leat éifeachtúlacht oibre a fheabhsú go mór. Agus a Dáileadh Gnáth / Cuar Bell (cairt) gné is féidir cairt cuar cloig foirfe a chruthú gan ach 2 chéim ann! Faigh é anois!

Kutools le haghaidh Excel - Cuimsíonn sé níos mó ná 300 uirlis áisiúil le haghaidh Excel. Triail saor in aisce gné iomlán 30 lá, níl aon chárta creidmheasa ag teastáil! Get sé anois


Cruthaigh cuar clog go tapa le huirlis iontach

Sa mhodh seo, tabharfaidh mé isteach an Dáileadh Gnáth / Cuar Bell gné de Kutools le haghaidh Excel. Cuideoidh an ghné seo leat cairt cuar cloig a chruthú gan ach dhá chlic. Ina theannta sin, tacaíonn an ghné seo le cairt histeagram minicíochta a chruthú, agus cairt teaglama de chuar cloig agus histeagram minicíochta freisin.

Kutools le haghaidh Excel: tá níos mó ná 300 uirlis áisiúil ann do Excel. Saor in aisce triail a bhaint gan aon teorannú i 60 lá. Faigh é anois!

1. Roghnaigh an raon sonraí a chruthóidh tú cuar clog bunaithe air, agus cliceáil Kutools > Charts > Dáileadh Gnáth / Cuar Bell. Féach an pictiúr:

2. Sa dialóg tosaigh, seiceáil an Gnáthchairt dáilte rogha sa Roghnaigh alt, agus cliceáil ar an OK Cnaipe. Féach an pictiúr:

Leid:
(1) Tá sé roghnach teideal na Cairte a chlóscríobh sa bhosca teidil Cairte;
(2) Más gá duit cairt histeagram minicíochta a chruthú, seiceáil an Cairt histeagram minicíochta rogha amháin sa Roghnaigh alt; le haghaidh cairt teaglama de chuar cloig agus histeagram minicíochta, seiceáil an dá rogha sa Roghnaigh alt seo.

Mura ndéanann tú ach an Gnáthchairt Dáileacháin rogha:

Má sheiceálann tú an dá rud Gnáthchairt Dáileacháin agus Cairt histeagram minicíochta roghanna:

 
 
 
 
 

Sábháil cairt cuar cloig chruthaithe mar iontráil AutoText le haghaidh athúsáid éasca gan ach cliceáil amháin

Chomh maith leis an gcairt chruthaithe Bell Curve a shábháil mar theimpléad cairte lena athúsáid sa todhchaí, Kutools le haghaidh Excel's AutoText Tacaíonn fóntais le húsáideoirí Excel cairt chruthaithe a shábháil mar iontráil AutoText agus AutoText na cairte a athúsáid ag am ar bith in aon leabhar oibre gan ach cliceáil amháin a dhéanamh. Faigh é anois!

Kutools le haghaidh Excel - Cuimsíonn sé níos mó ná 300 uirlis áisiúil le haghaidh Excel. Triail saor in aisce gné iomlán 30 lá, níl aon chárta creidmheasa ag teastáil! Get sé anois

Taispeántas: Cruthaigh teimpléad cairte cuar clog in Excel

Kutools le haghaidh Excel Cuimsíonn sé níos mó ná 300 uirlis áisiúil le haghaidh Excel, saor in aisce le triail gan teorainn i 30 lá. Íoslódáil agus Triail In Aisce Anois!

Airteagail gaolmhara


Na hUirlisí Táirgiúlachta Oifige is Fearr

Réitíonn Kutools for Excel an chuid is mó de do chuid Fadhbanna, agus Méadaíonn sé do Tháirgiúlacht 80%

  • Athúsáid: Cuir isteach go tapa foirmlí casta, cairteacha agus aon rud a d'úsáid tú roimhe seo; Cealla a Chriptiú le pasfhocal; Cruthaigh Liosta Ríomhphoist agus seol ríomhphoist ...
  • Barra Foirmle Super (cuir línte iolracha téacs agus foirmle in eagar go héasca); Leagan Amach Léitheoireachta (líon mór cealla a léamh agus a chur in eagar go héasca); Greamaigh go dtí an Raon Scagtha...
  • Cumaisc Cealla / Sraitheanna / Colúin gan Sonraí a chailleadh; Ábhar Cealla Scoilt; Comhcheangail Sraitheanna / Colúin Dúblacha... Cill Dúblach a Chosc; Déan comparáid idir Ranganna...
  • Roghnaigh Dúblach nó Uathúil Sraitheanna; Roghnaigh Blank Rows (tá na cealla uile folamh); Aimsigh Super agus Fuzzy Aimsigh i go leor Leabhar Oibre; Roghnaigh go randamach ...
  • Cóip Díreach Cealla Il gan tagairt fhoirmle a athrú; Tagairtí Cruthaigh Auto chuig Bileoga Il; Cuir Urchair isteach, Boscaí Seiceála agus go leor eile ...
  • Sliocht Téacs, Cuir Téacs leis, Bain de réir Poist, Bain Spás; Subtotals Paging a chruthú agus a phriontáil; Tiontaigh Idir Ábhar Cealla agus Tráchtanna...
  • Scagaire Super (scéimeanna scagaire a shábháil agus a chur i bhfeidhm ar bhileoga eile); Ard-Sórtáil de réir míosa / seachtaine / lae, minicíocht agus níos mó; Scagaire Speisialta le cló trom, iodálach ...
  • Comhcheangail Leabhair Oibre agus Bileoga Oibre; Cumaisc Táblaí bunaithe ar eochaircholúin; Roinn Sonraí i Ilbhileoga; Baisc Tiontaigh xls, xlsx agus PDF...
  • Níos mó ná 300 gné chumhachtach. Tacaíochtaí Office / Excel 2007-2019 agus 365. Tacaíonn sé le gach teanga. Imscaradh éasca i d’fhiontar nó d’eagraíocht. Gnéithe iomlána triail saor in aisce 30 lá. Ráthaíocht ar ais airgid 60 lá.
cluaisín kte 201905

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
bun officetab
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    kellytte · 11 months ago
    @Ian Hi lan,
    If you want to create a bell curve chart with the first method (insert a scatter with smooth line and markers chart), you’d better prepare enough data points. Otherwise, it will create a normal scatter chart only.
  • To post as a guest, your comment is unpublished.
    Ian · 1 years ago
    The normal excel method without Kurtosis DOES NOT WORK, this is the fifth page I've visited and I NEVER get a bell shaped curve.
  • To post as a guest, your comment is unpublished.
    Sophie · 2 years ago
    I followed the instructions above but ended up with a graph which wasn't in a normal distribution. What can I do to make this normally distributed?
  • To post as a guest, your comment is unpublished.
    Geeky · 2 years ago
    Good explanation loved it!
  • To post as a guest, your comment is unpublished.
    Rudra · 2 years ago
    Hi, I have query on NORM.DIST Function in Excel. For probability mass function (False case) contains formula and result is generated. For cumulative (True case) in excel which formula is using to generate the result? For True, it is mentioned as integral of probability mass function formula.
  • To post as a guest, your comment is unpublished.
    shawn · 2 years ago
    @DanHammang copy the formula in B2 and paste it in cells B3:B9
  • To post as a guest, your comment is unpublished.
    DanHammang · 2 years ago
    I think I'm missing something in the instructions for how to make a bell curve chart. In step 4 the formula creates, in cellB2, a normal distribution for the range of my data in column A. However there is no data in B3 through B93, yet the scatter chart seems to require data in cells B3 through B93. How is that data produced? Any suggestions would be appreciated.
  • To post as a guest, your comment is unpublished.
    Jason Erdmann · 3 years ago
    Good stuff, much better than some other site I was trying to follow. But, in Excel 2016 at least, you don't need to sort your data for the graph to show properly, its nice to be able to save a step or not have to worry about it if your data might change, extend, or be in a certain order for a reason (e.g. data entry ease). Also, because you made this so easy to follow, I was able to figure out how to add a second set of data (with its own average, standard deviation, and norm.dist values) to the same graph, it makes my graph more interesting. I think it would be cool if you expanded your base example into an advanced example like that. Again, good stuff.
  • To post as a guest, your comment is unpublished.
    NK · 3 years ago
    Can any set of data be made to look like a Bell curve this way?? What if the Kurtosis of the data was not within +/- 3 for a Normal Distribution?
  • To post as a guest, your comment is unpublished.
    Pam Hanes · 3 years ago
    Clear example -- a lifesaver!
  • To post as a guest, your comment is unpublished.
    val · 3 years ago
    @Paul S Hi! The way I have done it is by creating an extra set of data and then adding them to the graph. e.g.
    y x
    0 25
    0.1 25

    (0.1 is my max distribution and 25 the z score i want to add the vertical line)

    Hope it helps :)
  • To post as a guest, your comment is unpublished.
    kelly.extendoffice@gmail.com · 3 years ago
    @Brenda Hi Brenda,
    List the student scores in Column A in the ascending order, and then follow the first method to create a bell curve chart.
  • To post as a guest, your comment is unpublished.
    Brenda · 3 years ago
    I would like to plot student scores (percentiles) on a standard bell curve - is that possible to do in excel?
  • To post as a guest, your comment is unpublished.
    Tim Platz · 3 years ago
    Is there a way to shade parts of this bell curve?
  • To post as a guest, your comment is unpublished.
    kelly.extendoffice@gmail.com · 3 years ago
    @Paul S Hi Paul,
    Thank you for your comment. I am afraid I can’t. Sorry!
  • To post as a guest, your comment is unpublished.
    Paul S · 3 years ago
    Is there a way to put a vertical line at a certain Z score? I've been doing it in paint, but I'd like to do it automatically
  • To post as a guest, your comment is unpublished.
    soo · 3 years ago
    thanks a lot.
  • To post as a guest, your comment is unpublished.
    rudra · 3 years ago
    great help
  • To post as a guest, your comment is unpublished.
    Catherine · 3 years ago
    Brilliant. Thank you!
  • To post as a guest, your comment is unpublished.
    Mary · 3 years ago
    Thank you very much. Most helpful.
  • To post as a guest, your comment is unpublished.
    Sana · 3 years ago
    I just wanted to thank u:)
  • To post as a guest, your comment is unpublished.
    ASHISH · 4 years ago
    Thank you very much.

    How we can decorate this graph with X-axis 0.4 to +4 , mentioning 68,95,97 area
  • To post as a guest, your comment is unpublished.
    ASHISH · 4 years ago
    Thank you very much. Most helpful.

    Please help me to convert this graph in the form of x-axis -4 to +4 with shaded area
    68.3,95.4,99.7. , just as it looks like when we search "Normal Curve" in google
    Thanks
  • To post as a guest, your comment is unpublished.
    Jordy · 4 years ago
    Thanks for the training. I was wondering if it was possible to add vertical lines the distance of the standard deviation from the mean?
  • To post as a guest, your comment is unpublished.
    Jordy · 4 years ago
    Thanks for the training. I was wondering if you could add in vertical lines the distance of the standard deviation? Your help is much appreciated
    -Jordy
  • To post as a guest, your comment is unpublished.
    Steve · 4 years ago
    Thanks, works great for me too, most helpful.

    Is it possible to overlay two or more distribution curves on the same 'x' axis?
  • To post as a guest, your comment is unpublished.
    Dr Manaullah · 4 years ago
    Thank U very much for informative and narrative explanation.
  • To post as a guest, your comment is unpublished.
    Dr Manaullah · 4 years ago
    Very nice way of explaining. It works very fine. I tried for my class marks distribution. Long Live.
  • To post as a guest, your comment is unpublished.
    Michele · 4 years ago
    Thanks so much for the training - extremely clear and helpful!
  • To post as a guest, your comment is unpublished.
    adel · 5 years ago
    hi
    thanks for your training article . i performed every thing right as you explained in article . but finally i have an strange graph that is not similar to normal dist . may you help me ?
    tnx again