Solved

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

Posted on 2014-09-15
134 Views
If I have just mean, median and standard deviation, can I derive the distribution curve in Excel?
0
Question by:fitaliano
• 2

LVL 27

Accepted Solution

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.

-Glenn
0

LVL 24

Expert Comment

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

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

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

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
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…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…