ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I get a normal curve in Excel with values 0-200000? (https://www.excelbanter.com/excel-worksheet-functions/114524-how-do-i-get-normal-curve-excel-values-0-200000-a.html)

Kizzy

How do I get a normal curve in Excel with values 0-200000?
 
I need to make a normal distribution chart for class and don't know how? I
know that I have to use NORMDIST but I don't know how to get my x value. When
I make my graph it is just one line. Please help!

Martin P

How do I get a normal curve in Excel with values 0-200000?
 
My suggestion:
In column A from A1 create a series from -3 to +3 in 0.1 increments. In B1
enter
=NORMDIST(A1,0,1,FALSE)
and copy this down.
Use XY (Scatter) on your chart wizard to create the chart.

"Kizzy" wrote:

I need to make a normal distribution chart for class and don't know how? I
know that I have to use NORMDIST but I don't know how to get my x value. When
I make my graph it is just one line. Please help!



All times are GMT +1. The time now is 01:04 PM.

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