Solved

If I have just mean, median and standard deviation, can I derive the distribution curve in Excel?

Posted on 2014-09-15
4
138 Views
Last Modified: 2014-09-19
If I have just mean, median and standard deviation, can I derive the distribution curve in Excel?
0
Comment
Question by:fitaliano
  • 2
4 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40324338
No.  

A distribution function is dependent on the order of the data.  You can have two sets of numbers with identical elements such that the mean, median, and standard deviation are exactly the same.  However, if one was ordered in an ascending manner and another in descending (or randomly ordered) the distribution curve - whether linear, logarithmic, exponential, polynomial, or whatever - would be different.
example data and plot
-Glenn
0
 
LVL 24

Expert Comment

by:Steve
ID: 40325334
Yes it is possible.
A normal distribution is based upon the mean (AVERAGE) and the standard deviation (STDDEV.S).

Provided you are referring to a normal distribution (using NORMDIST) you can plot a normal distribution quite simply.

If you see the attached you can see this being plotted.
U--NORMDIST.xlsx
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40333406
As much as I hate to ask, are you sure my answer was the correct answer?  After I saw Steve's post, I realized that a normal distribution is a possible curve that can be calculated (even if the only arguments are the average/mean and standard deviation).

Regards,
-Glenn
0
 

Author Comment

by:fitaliano
ID: 40333421
I need to actually plot curves for what they are: meaning left or right skewed if the coefficient of skewedness is big enough (> abs(0.5) or > abs(1)). Coefficient of skewedness takes into account mean, median and standard deviation.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question