QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Create a Bell Curve in Excel?

By Neha T Leave a Comment

Bell curve is a kind of graph that displays the normal distribution of a variable. It is mostly used to analyze the performance of employees or students etc. Bell curve helps you in identifying the poor, average and good performers in the team.

The individuals whose performance is marked at the left side of the bell curve can be identified as poor performers and the individuals whose performance lies at the right side of the bell curve are identified as excellent performers and the individuals that are marked in the middle of the curve are the average performers.

Steps to Create a Bell Curve in Excel:

Step 1: Consider that we have the scores of twenty students in ascending order. As to get a smooth bell curve we need the data sorted in ascending order.

Create a Bell Curve in Excel - 1

Step 2: First we need to calculate the mean of scores that the twenty students have secured. To compute the mean we can use an AVERAGE formula in excel as

=AVERAGE(number 1: number n)

Create a Bell Curve in Excel - 2

Step 3: Next after calculating the average we have to calculate the standard deviation. For that, we have the formula in excel as:

=STDEV.P(number 1: number n)

Create a Bell Curve in Excel - 3

Step 4: Now you have to calculate the normal distribution value for each of the score values. For this you have an inbuilt formula as given below:

=NORM.DIST(x, mean, standard_dev, cumulative)

  • x is the value for which the normal distribution value has to be calculated.
  • mean – is the average of the data
  • standard_dev – is the standard deviation of the distribution.
  • cumulative – it determines the logical value of the function. If it is TRUE, NORM.DIST returns the cumulative distribution function. If it is FALSE, return probability density function.

Create a Bell Curve in Excel - 4

To get the normal distribution value for each score value just drag the NORM.DIST formula down up to the last score values.

Step 5: Now select the x and y-axis for the bell chart. In this example our x-axis will be our score column and the y-axis will be our normal distribution column. Select all the values of the score and normal distribution column and go to the Insert tab and search for the Charts group.

In the Charts group, you have two options either you can go for ‘Recommended Charts’ or you can pick one from the ‘Scatter Charts’.

Create a Bell Curve in Excel - 5From the Scatter the charts in the above row show variants of a smooth bell curve.

Create a Bell Curve in Excel - 6

The Recommended Charts also show you variants of the smooth bell curve.

Create a Bell Curve in Excel - 7

In the graph below, we can notice that the maximum number of students lies between 74.8 to 86.2. In our example, we have 13 students who are between this range and we have three students who are below this range and four students who are above this range.

Create a Bell Curve in Excel - 8

So, we can say that we have three students who have not performed well. There are 13 students are who are average performers and four students who have excelled in the exam.

Note: You must have data sorted in ascending order to get a smooth bell curve.

If you have unsorted data then your bell curve will look like this:

Create a Bell Curve in Excel - 9

So this is how you can create a bell curve to analyze the performance of employees or students etc.

You Might Also Like:

Calculate Average in Excel feature imageHow to Calculate Average in Excel? Calculate Age in Excel feature imageHow to Calculate Age in Excel? Calculate percentage Featured ImageHow to Calculate Percentage in MS Excel 2016? generate a random number in excel featured imageHow to Generate Random Number in Excel? count unique values featured imageHow to Count Unique Values in Excel 2016? Graph in Excel - featured ImageHow to Create a Graph in Excel? feature imageHow to COUNTIF in MS Excel 2016? Delete Duplicates feature imageHow to Delete Duplicates in Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Translate a Webpage in Google Chrome?
  • How to Edit a Template in Joomla 3.x
  • How to Clear Cache in Windows 10?
  • How to Enable & Disable Registry Editor in Windows 10?
  • How to Create a Drop-Down List in MS Excel 2016?

Copyright © 2023 · QueHow · Contact Us