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
Have you seen AVERAGE and STDEV.S, STDEV.P functions ?
- Battle without fear gives no glory - Just try
I pasted your sample into J2:J33 and ran this:
Which yielded:
Please Login or Register to view this content.
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
Last edited by xladept; 05-13-2020 at 03:12 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks