Dear All,
Does anyone know how to create Skewed distribution charts, when knowing the mean, standard deviation and skewness ?? (For example, mean - 50, Standard deviation = 25%, skewness - 3.3)
I have no problem creating a normal distributed chart, but including skewness is not straightforward. I believe it maybe involve lognormdist function, but I am not familarly with how they function, so any explaination involving Lognormdist needs to assume I know nothing.
Thanks
Paul
I am using Excel 2002. There is a problem with the frequency function, which
is used for histograms. The frequency counts for some (not all) bins is
incorrect. The case that I learned of in another posting involves 101 data
values: 0, 10, and values in between that are created by using an increment
of 0.1. The frequency value for the first bin is (correctly) 11, and most of
the other bins have the correct frequency (10). However, the bin
representing the interval from 1 to 2 has a frequency of 9, which the bin
representing the interval from 4 to 5 has a frequency of 11! I have also
used the "Better Histrogram" downloadable file for this same problem, but
apparently the "Better Histogram" procedure starts with the Frequency
function, as it ends up with a histogram with the same results. Any
suggestions for correctly calculating all bin frequencies?
--
Jim
Does anyone know how to center the category axis (e.g. age groups 0-4, 5-9, 10-14, etc) in an Excel Histogram chart. At present this axis is positioned to the left of my dual histograms (i.e. male population on left side & female on the right). I want a space between these two sides of the histogram with the age group labels appearing next to the appropriate bars.
I hope this is clear enough. Thanks for any help you can provide.
Novice123
When creating histograms using the "Data Analysis feature, Excel creates bar
graphs. Bar graphs are not histograms. Histograms bars share a boundary. They
are used to chart interval and ration data. Bar graphs are used to graph
nominal and ordinal data.
Excel produces a wide range of really useful graphs, with the exception of
histograms (and box-and-whiskers are also difficult to do), even in the 2003
version that I use.
The Analysis ToolPak produces an apology for a histogram with bars not
touching and frequency density not used on the y - axis ("schoolboy error").
I am sure microsoft could easily rectify this if they wanted - there are
other programs (e.g. Autograph) that do it quite successfully.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...excel.charting
I have a data set based on an uneven distribution of cards in a 60 card deck, each with a value ranging from 0-5.
I need to build a probability distribution of all the random samples of 10. So, how many random sets of 10. have an average value of 1 (or a total of 10) etc.
Then, I need to build a variable distribution so that it changes as I change the sample size. So, with a sample of 20 cards, what does the distribution look like?
Can this be done in excel? Should I post what I have now to work with?
Hi Lords and Ladies!
I was wondering if there are any statistical tools in excel?
What I need is a comparison program to do the following:
Column A: abcdefgh
Column B: bcaghfrnreo
Column C: 80% match (roughly)
Is that possible to do in excel?
Regards,
Don Defy
Morning All,
Does anyone know of a free tutorial that can explain how to get statistical data in Excel? - I have seen it done before (in excel) for 'Linear regression', I am wondering if the same can be done for "Polynomal"?
Rgs
Neville
Hi everyone, first thanks for the help.
I am trying to create a histogram and let me explain some of the data.
I have a list of data separated like so:
3.5
3.6
3.8
3.8
3.9
3.9
etc...
Now I need to calculate the frequencies of these like so:
3.5 (up to but not including) 4.0
4.0 (up to but not including) 4.5
I can count out the frequencies myself but i need to create a histogram (bar graph) with the y axis as the frequency and the x axis as the IMR(infant mortality rate: ie the 3.5 (up to but not including) 4.0).
I am having problems with calculating the frequencies because when setting the bin values because they include 4.0.
If this is confusing I can provide some more information, but cannot find a good tutorial that would create a histogram anywhere remotely close to the histogram i drew by hand.
