Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • Last Modified:

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

If I have just mean, median and standard deviation, can I derive the distribution curve in Excel?
0
fitaliano
Asked:
fitaliano
  • 2
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
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
 
SteveCommented:
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
 
Glenn RayExcel VBA DeveloperCommented:
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
 
fitalianoAuthor Commented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now