ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do i set up a normal distribution in excel? (https://www.excelbanter.com/new-users-excel/91175-how-do-i-set-up-normal-distribution-excel.html)

dimi

How do i set up a normal distribution in excel?
 
I need to find out how you can set up a normal distribution curve on
microsoft excel. When I search normal distribution i get a function for it
but i want to see the curve, which i can't figue out how to do

Matt Lunn

How do i set up a normal distribution in excel?
 


"dimi" wrote:

I need to find out how you can set up a normal distribution curve on
microsoft excel. When I search normal distribution i get a function for it
but i want to see the curve, which i can't figue out how to do



In column A set up your X values, For example from -4 to +4. Increments of
0.1 should be OK.

In column B use the NORMDIST function like this

If you X values start at A1 then cell B1 should be

=NORMDIST(A1,0,1,FALSE)

Copy the formula down for all X values.

Produce chart on Column B and use Column A for X values

HTH

Matt


All times are GMT +1. The time now is 10:29 PM.

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