Solved

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

Posted on 2014-09-15
4
134 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now