software

Range of data and I want to create a bell curve of this - HOW?
Mike

26
20
35
16
84.9
15
17
42
36
22
18
26
23
49
19
16
29
20
40
26
18
20
14
45
13
19
128.5
29
16
12You probably want a combination chart, with a column series showing a
histogram of your values and a line series showing a normal distribution
density curve based on the mean and standard deviation of the data.

Tushar Mehta has instructions for a normal probability curve (bell curve) on
his website, tushar-mehta.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;MikeR-Ozquot; gt; wrote in message
...
gt; Range of data and I want to create a bell curve of this - HOW?
gt; Mike
gt;
gt; 26
gt; 20
gt; 35
gt; 16
gt; 84.9
gt; 15
gt; 17
gt; 42
gt; 36
gt; 22
gt; 18
gt; 26
gt; 23
gt; 49
gt; 19
gt; 16
gt; 29
gt; 20
gt; 40
gt; 26
gt; 18
gt; 20
gt; 14
gt; 45
gt; 13
gt; 19
gt; 128.5
gt; 29
gt; 16
gt; 12
gt;
Thaks Jon, But I had seen this link before but is still all 'double-dutch' to
me. I have the following list of numbers for example:26
20
28
16
84.9
15
17
28
29
22
Where in the link do I start with to use these numbers to create a bell
curve etc. I know how to get the mean, stdev, for this. I can create a column
graph as well I think. But where to for the next step in putting it all
together in a bell curve etc.
Mikequot;Jon Peltierquot; wrote:

gt; You probably want a combination chart, with a column series showing a
gt; histogram of your values and a line series showing a normal distribution
gt; density curve based on the mean and standard deviation of the data.
gt;
gt; Tushar Mehta has instructions for a normal probability curve (bell curve) on
gt; his website, tushar-mehta.com
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt; quot;MikeR-Ozquot; gt; wrote in message
gt; ...
gt; gt; Range of data and I want to create a bell curve of this - HOW?
gt; gt; Mike
gt; gt;
gt; gt; 26
gt; gt; 20
gt; gt; 35
gt; gt; 16
gt; gt; 84.9
gt; gt; 15
gt; gt; 17
gt; gt; 42
gt; gt; 36
gt; gt; 22
gt; gt; 18
gt; gt; 26
gt; gt; 23
gt; gt; 49
gt; gt; 19
gt; gt; 16
gt; gt; 29
gt; gt; 20
gt; gt; 40
gt; gt; 26
gt; gt; 18
gt; gt; 20
gt; gt; 14
gt; gt; 45
gt; gt; 13
gt; gt; 19
gt; gt; 128.5
gt; gt; 29
gt; gt; 16
gt; gt; 12
gt; gt;
gt;
gt;
gt;

Have you looked at
Understanding the Standard Normal distribution and how it connects all other
Normal distribution functions
www.tushar-mehta.com/excel/ch..._distribution/
#understanding_std_norm ?

Also, to test whether the data represent a normal distribution, you might
want to look at
www.usfca.edu/~middleton/demand.pdf

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article gt;,says...
gt; Thaks Jon, But I had seen this link before but is still all 'double-dutch' to
gt; me. I have the following list of numbers for example:26
gt; 20
gt; 28
gt; 16
gt; 84.9
gt; 15
gt; 17
gt; 28
gt; 29
gt; 22
gt; Where in the link do I start with to use these numbers to create a bell
gt; curve etc. I know how to get the mean, stdev, for this. I can create a column
gt; graph as well I think. But where to for the next step in putting it all
gt; together in a bell curve etc.
gt; Mike
gt;
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt; gt; You probably want a combination chart, with a column series showing a
gt; gt; histogram of your values and a line series showing a normal distribution
gt; gt; density curve based on the mean and standard deviation of the data.
gt; gt;
gt; gt; Tushar Mehta has instructions for a normal probability curve (bell curve) on
gt; gt; his website, tushar-mehta.com
gt; gt;
gt; gt; - Jon
gt; gt; -------
gt; gt; Jon Peltier, Microsoft Excel MVP
gt; gt; Peltier Technical Services
gt; gt; Tutorials and Custom Solutions
gt; gt; PeltierTech.com/
gt; gt; _______
gt; gt;
gt; gt;
gt; gt; quot;MikeR-Ozquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Range of data and I want to create a bell curve of this - HOW?
gt; gt; gt; Mike
gt; gt; gt;
gt; gt; gt; 26
gt; gt; gt; 20
gt; gt; gt; 35
gt; gt; gt; 16
gt; gt; gt; 84.9
gt; gt; gt; 15
gt; gt; gt; 17
gt; gt; gt; 42
gt; gt; gt; 36
gt; gt; gt; 22
gt; gt; gt; 18
gt; gt; gt; 26
gt; gt; gt; 23
gt; gt; gt; 49
gt; gt; gt; 19
gt; gt; gt; 16
gt; gt; gt; 29
gt; gt; gt; 20
gt; gt; gt; 40
gt; gt; gt; 26
gt; gt; gt; 18
gt; gt; gt; 20
gt; gt; gt; 14
gt; gt; gt; 45
gt; gt; gt; 13
gt; gt; gt; 19
gt; gt; gt; 128.5
gt; gt; gt; 29
gt; gt; gt; 16
gt; gt; gt; 12
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt;