You are here: HomeExcelTutorials

# How to create a bell curve / normal distribution graph

## How to create a bell curve / normal distribution graph

Price: FREE

I am having hard time to create the bell curve. I have sorted the data (please see the attached file) according to the distribution (only the green marked data) and I believe I will have to use different formulas to create the column graph and the curve.
I would appreciate it a lot if someone could take a look at this an advise, how to do it. I have already spend couple of hours researching how to do this but it seems to be quiet complex. Is there an easy way to create that type of chart?

Visit publisher's web-site: How to create a bell curve / normal distribution graph

Category and Tags: ExcelTutorials :

## Related Tutorials

### How to graph normal distribution curve

Free: Yes
Tags: Excel › Charts

at Excel and need help graphing a sampling distribution of of the sample proportion. sample is 150, sample proportion is .15, std deviation is .029 How do I make a normal bell curve?

### bell curve widths

Free: Yes
Tags: Excel ›

I have discovered how to create a normal distribution (Bell) curve on my excel spreadsheet. The instructions on the net all seem the same, and the curve always covers the same width 1 to 8 or 9. I am trying to produce a curve to lok at a number of ratings the lowest is 0 and the highest 5 How do I amend the width of the bell. I believe it is something to do with the standard deviation number which is generated and used. But now I'm lost

### Chart and statistics

Free: Yes
Tags: Excel ›

I am looking to draw the following graph in my attachment (please see attached PDF).
I tried converting them into histogram and then into a bell curve, but couldn't get it to work,
because I don't understand terms such as "bin range". Can someone enlighten me on whether I need to convert the data into a histogram first then into a separate bell curve? If so, could someone show me how I should do it? Many thanks
PS - I understand that the graph I am looking for should be a normal distribution (I'm guessing it's not a standard normal distribution graph as the graph I am looking for is not one with 0 in the middle). Please kindly advise me.

### Graph a normal distribution chart?

Free: Yes
Tags: Excel › Charts

I am having trouble graphing the percentage to the bell curve shape. Can

### Random distribution of numbers to create Bell curve

Free: Yes
Tags: Excel ›

I think its too early in the morning or I have just worn my brain out with information over the last 2 weeks!
Anyway, I figured I would differ this one to the group for a simple solution!
I want to simulate a bell curve with random numbers for test data, so I need a formula to return a large percentage of numbers around a mid point and get less and less to the outside, with a very marginal amount of really wild outside points!
=LOOKUP(RAND(),{0.05,0.15,0.5,0.85,0.95},{0.03,0.02,0.01,0.01,0.02,0.03})*RAND()+MIDPOINT-RANGE
was where I was looking

## Related Applications & Scripts

### Fire Alarm Bell Animation

Free: No
Tags: Flash › Excel Animations

This animation of a fire alarm bell signifies the state of emergency.

### Body Mass Index Calculator for Adults and Kids

Free: Yes
Tags: JavaScript › Excel Calculators

This calculator is actually 4 calculators in 1. In addition to Body Mass Index, you can calculate your Body Surface Area, Ideal Body Weight, and Lean Body Weight. Body Mass Index (BMI) provides a simple and useful estimate of overweight, obesity, and body fat distribution by determining your weight relative to your height. This calculator helps you to know if your weight is above normal (overweight or obese) and use frequently if you are trying to lose weight.

### dkLab Apache: Patched Apache distribution for virtual hosts

Free: Yes

The dkLab Apache is a patched Apache distibution for those who plan to use Apache web-server in Unix (Linux, FreeBSD etc.) to serve multiple separated sites working under different, fully separated and independent Unix users. It does not have some lacks of analogs, e.g.: does not require to install any OS kernel modules nor disable setuid; works correctly and intelligently with KeepAlive turned on and MaxRequestsPerChild > 1.
Here is some abilities of these patches:
- Run different virtual hosts with privileges of different Unix users.
- Ability to create virtual hosts using domain templates: abc.example.com -> /home/example/abc.
- Apache module mod_rewrite is protected from getting caught in an endless loop.

### PHPLicengine - PHP Licensing & Distribution

Free: Yes
Tags: PHP › Excel Security Systems