Hello,
I have attached one file where i need normal distribution curve.
Request you to please help me in creating normal distribution curve.
File is also attached for ref.
Hello,
I have attached one file where i need normal distribution curve.
Request you to please help me in creating normal distribution curve.
File is also attached for ref.
Click on (*), if you agree.
Here's one tutorial: http://www.tushar-mehta.com/excel/ch..._distribution/ It appears that it was done in Excel 2002/2003, so some of the commands are in different places. If you don't need it backwards compatible to pre-2010, you might prefer to use the NORM.DIST() function (introduced in 2010) instead of NORMDIST().
Originally Posted by shg
What issues are you facing? Are you having trouble building a table of values for the chart? Are you having trouble creating a scatter chart? Are there arguments to the function that you don't understand? It is difficult to help when you don't explain what you are having difficulty with.
Hi ,
I can create chart but i am facing issues in creating table by which chart can be prepared.
The tutorial suggests starting with a column of x values suitable for the standard normal distribution (-4, -3.5, -3,... or similar). See the section under "enumerate a set of points in a worksheet" explaining what he does with A2 and the rest of column A. (http://www.tushar-mehta.com/excel/ch...numerate_a_set ).
Then he puts a formula in column B that will "convert" the xvalues for a standard normal distribution to a column of x values that will be suitable for any normal distribution based on the entered mean and standard deviation.
Finally, he puts the NORMDIST() function in column C to generate the desired probability density values for the normal distribution.
Columns B and C then are used to create the scatter chart.
What part of those steps are you having trouble with?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks