ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Frequency chart and normal curve (https://www.excelbanter.com/new-users-excel/100621-frequency-chart-normal-curve.html)

Carl W.

Frequency chart and normal curve
 
2 questions:
1. I have a series of about 200 numbers that I would like to create a
frequency chart/graph for. I am having difficulty in OL2000 creating a
frequency graph.

2. I have the mean and standard deviation. I do I create a normal curve
with this data?

Thank you,
Carl

Bondi

Frequency chart and normal curve
 

Carl W. wrote:
2 questions:
1. I have a series of about 200 numbers that I would like to create a
frequency chart/graph for. I am having difficulty in OL2000 creating a
frequency graph.

2. I have the mean and standard deviation. I do I create a normal curve
with this data?

Thank you,
Carl


Hi Carl,

Here are two links that might help you:

1. For the frequency graph:
http://www.ozgrid.com/News/excel-histogram.htm

2. For the normal distribution:
http://www.tushar-mehta.com/excel/ch..._distribution/

Regards,
Bondi


Carl W.

Frequency chart and normal curve
 
Thank you for the help. This community has been very helpful.

"Bondi" wrote:


Carl W. wrote:
2 questions:
1. I have a series of about 200 numbers that I would like to create a
frequency chart/graph for. I am having difficulty in OL2000 creating a
frequency graph.

2. I have the mean and standard deviation. I do I create a normal curve
with this data?

Thank you,
Carl


Hi Carl,

Here are two links that might help you:

1. For the frequency graph:
http://www.ozgrid.com/News/excel-histogram.htm

2. For the normal distribution:
http://www.tushar-mehta.com/excel/ch..._distribution/

Regards,
Bondi




All times are GMT +1. The time now is 02:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com