# Find parameters of Normal Distribution for given dataset

1. ## Find parameters of Normal Distribution for given dataset

Hi All,

I have dataset from about 100 float values.
Now I need to find parameters of Normal Distribution to fit my dataset.
Any suggestion how to do it in Excel 2010 ?

Piece of dataset:
4,20E+01
3,70E+01
3,90E+01
3,90E+01
3,90E+01
3,70E+01
3,80E+01
3,10E+01
4,60E+01
5,70E+01
6,60E+01
7,70E+01
7,90E+01
7,60E+01
6,20E+01
6,90E+01
8,10E+01
6,60E+01
7,50E+01
8,30E+01
7,90E+01
7,90E+01
7,90E+01
7,40E+01
6,70E+01
4,70E+01
5,30E+01
6,20E+01
5,20E+01
5,90E+01
5,60E+01
6,00E+01

2. ## Re: Find parameters of Normal Distribution for given dataset

Have you seen AVERAGE and STDEV.S, STDEV.P functions ?

3. ## Re: Find parameters of Normal Distribution for given dataset

I pasted your sample into J2:J33 and ran this:

``Please Login or Register  to view this content.``
Which yielded:

 v J K L 1 2 4.20E+01 59.5625 Avg 3 3.70E+01 83 Max 4 3.90E+01 31 Min 5 3.90E+01 52 Range 6 3.90E+01 79 Mode 7 3.70E+01 61 Med 8 3.80E+01 16.1823 Std Dev 9 3.10E+01 75.25 Q3 10 4.60E+01 45 Q1 11 5.70E+01 30.25 IQ 12 6.60E+01 32 n 13 7.70E+01 14 7.90E+01 15 7.60E+01 16 6.20E+01 17 6.90E+01 18 8.10E+01 19 6.60E+01 20 7.50E+01 21 8.30E+01 22 7.90E+01 23 7.90E+01 24 7.90E+01 25 7.40E+01 26 6.70E+01 27 4.70E+01 28 5.30E+01 29 6.20E+01 30 5.20E+01 31 5.90E+01 32 5.60E+01 33 6.00E+01

There are currently 1 users browsing this thread. (0 members and 1 guests)