+ Reply to Thread
Results 1 to 3 of 3

Find parameters of Normal Distribution for given dataset

  1. #1
    Registered User
    Join Date
    05-13-2020
    Location
    Nalchik
    MS-Off Ver
    2010
    Posts
    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. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,657

    Re: Find parameters of Normal Distribution for given dataset

    Have you seen AVERAGE and STDEV.S, STDEV.P functions ?
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,380

    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
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 14
    Last Post: 11-19-2019, 09:17 AM
  2. ways to determine a normal or log normal distribution in excel
    By aprildu in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-29-2016, 06:32 PM
  3. percentage distribution from a dataset
    By stockman in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-16-2016, 04:15 PM
  4. Replies: 9
    Last Post: 07-24-2015, 03:40 PM
  5. Replies: 5
    Last Post: 01-31-2011, 12:21 AM
  6. Normal distribution
    By smaug82 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2008, 02:56 AM
  7. NORMAL DISTRIBUTION
    By FLKULCHAR in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-27-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1