ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Bell Curve Creation with more than 255 in one data series (https://www.excelbanter.com/charts-charting-excel/218397-bell-curve-creation-more-than-255-one-data-series.html)

Kcope8302

Bell Curve Creation with more than 255 in one data series
 
I have a list of data that 2344 sets of data. I want to create a standard
bell curve with this data. I have tried to create a smooth scatter plot but
it does not depict the bell curve.

Please inform me what the best method would be to do this.

Thanks

Mike Middleton

Bell Curve Creation with more than 255 in one data series
 
Kcope8302 -

(1) Do you have a data set with 2,344 values?

(2) Do you want "a standard bell curve" using the mean and standard
deviation of your data?

(3) Or, do you want a histogram (column chart of the frequency distribution
of your data), which may or may not be bell-shaped?

- Mike Middleton
http://www.MikeMiddleton.com



"Kcope8302" wrote in message
...
I have a list of data that 2344 sets of data. I want to create a standard
bell curve with this data. I have tried to create a smooth scatter plot
but
it does not depict the bell curve.

Please inform me what the best method would be to do this.

Thanks




Kcope8302

Bell Curve Creation with more than 255 in one data series
 
I have 2344 values that I need to be analyzed in a standard bell curve.

"Mike Middleton" wrote:

Kcope8302 -

(1) Do you have a data set with 2,344 values?

(2) Do you want "a standard bell curve" using the mean and standard
deviation of your data?

(3) Or, do you want a histogram (column chart of the frequency distribution
of your data), which may or may not be bell-shaped?

- Mike Middleton
http://www.MikeMiddleton.com



"Kcope8302" wrote in message
...
I have a list of data that 2344 sets of data. I want to create a standard
bell curve with this data. I have tried to create a smooth scatter plot
but
it does not depict the bell curve.

Please inform me what the best method would be to do this.

Thanks





Mike Middleton

Bell Curve Creation with more than 255 in one data series
 
Kcope8302 -

You answered my first question, but you did not answer Yes or No to my
second and third questions.

If by "analyzed in a standard bell curve" you mean Yes to the second
question, see Tushar Mehta's web page
http://www.tushar-mehta.com/excel/ch...tion/index.htm

Instead, if you mean Yes to the third question, (a) use the Histogram tool
of Excel's Analysis ToolPak, or (b) use my Better Histogram add-in
(http://www.treeplan.com/better.htm), or (c) use worksheet function COUNTIF
(or array-entered FREQUENCY) with a Column chart.

- Mike Middleton
http://www.MikeMiddleton.com



"Kcope8302" wrote in message
...
I have 2344 values that I need to be analyzed in a standard bell curve.

"Mike Middleton" wrote:

Kcope8302 -

(1) Do you have a data set with 2,344 values?

(2) Do you want "a standard bell curve" using the mean and standard
deviation of your data?

(3) Or, do you want a histogram (column chart of the frequency
distribution
of your data), which may or may not be bell-shaped?

- Mike Middleton
http://www.MikeMiddleton.com



"Kcope8302" wrote in message
...
I have a list of data that 2344 sets of data. I want to create a
standard
bell curve with this data. I have tried to create a smooth scatter plot
but
it does not depict the bell curve.

Please inform me what the best method would be to do this.

Thanks








All times are GMT +1. The time now is 04:36 AM.

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